Bank Statement to QuickBooks for Forensic Accountants and Litigation Support

Convert subpoenaed PDF bank statements to QBO files and rebuild books in QuickBooks. Totals checked against each statement, scans read, years done in hours.

Upload your bank statement

PDF, JPG, PNG, BMP, HEIC or TIFF, up to 50MB

Forensic accountants get subpoenaed or produced bank statements into QuickBooks by converting each PDF to a .qbo Web Connect file and importing it into a fresh company file, one account at a time. Every line keeps the date, description and amount printed on the statement, and the parsed total is checked against the statement's own totals before you export, so the ledger you analyze starts from the bank record rather than from someone's retyping. Upload the statements at the top of this page to start.

This page is for the engagement where there are no books, or the books cannot be trusted: a contested divorce with a business on the balance sheet, a partner dispute, a suspected embezzlement, a bankruptcy where the debtor's records stopped two years ago, or a lost profits claim that needs a clean revenue history. In all of them the bank statement is the most reliable document you have, and the work is turning stacks of it into something you can query, total and testify to.

A real .qbo file QuickBooks accepts

Built for the statements US banks actually send, checked before it exports.

Reconciliation

Every total checked against the statement

The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

OCR

Scans and phone photos read line by line

OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.

Volume

A year of statements in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Locked files

Password-protected PDFs handled

Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your statement to QuickBooks

Three steps. No column-mapping wizard.

1

Upload the PDF statement

Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.

2

Review the reconciled rows

Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, email [email protected].

Why reconstruction starts with the statement, not the client's ledger

When the question is whether the books are honest, you cannot start from the books. The bank record is created by a third party, it is hard to alter without leaving a trace, and opposing counsel can obtain the same document by subpoena. That is why indirect methods of proving income, such as the bank deposits analysis the IRS describes in its Internal Revenue Manual section on examining income, build from deposits rather than from what a taxpayer chose to record.

The practical problem is volume. A small operating business easily produces 80 to 150 bank lines a month across checking, savings and a card or two. Three years of that is several thousand lines, usually delivered as PDFs, often as scans of mailed statements, and sometimes as photos taken in a records room. Keying them into a spreadsheet takes days, and every keyed line is a line someone can challenge on cross.

Converting to .qbo and importing into QuickBooks solves two problems at once. The data lands without retyping, and it lands inside a tool that already does the things you need next: bank rules for coding repetitive payees, class or location tags for separating the two spouses' or two partners' activity, reconciliation against each statement, and standard reports you can export.

A worked example, three years of a closely held business

Take a divorce engagement where the marital estate includes an S corporation. Counsel has produced 36 months of statements for the operating checking account, a money market account and a business credit card, so 108 PDFs. Assume the checking account averages 120 lines a month, the money market 6 and the card 55. That comes to 4,320 plus 216 plus 1,980, or 6,516 lines. These are illustrative volumes to show the arithmetic, not a benchmark; substitute the counts from your own production.

TaskKeying into a spreadsheetConvert to .qbo and import into QuickBooks
Getting 6,516 lines inAbout 36 hours at 20 seconds a line, before any review108 uploads in batches of up to 50, then 108 imports
Proving the data matches the sourceSecond person re-foots every pageParsed totals compared with each statement's totals before export, then reconciled month by month in QuickBooks
Separating business from personal spendingManual flags in a columnBank rules plus classes, reported with standard QuickBooks reports
Tracing transfers between the three accountsLookups across tabsTransfers matched across accounts in one company file
Late production of a missing monthKey it, then re-check every downstream totalConvert the one statement and import it into the gap

The hours are only part of it. The bigger gain is defensibility: each imported line traces straight back to a page in the production, the file was never touched by hand on the way in, and the reconciliation report shows that every month ties to the bank's ending balance. When the other side's expert asks how a number was built, you can walk them from the report to the transaction to the statement page.

What forensic accountants use the QuickBooks file for

Income reconstruction. With deposits coded by source, you can separate customer receipts from transfers, loan proceeds and owner contributions, then compare the total to reported gross receipts. A large unexplained gap is usually the first finding in a hidden income case.

Personal expenses run through the business. Bank rules flag recurring payees such as schools, clubs, home utilities and vehicle payments. In a divorce valuation those add back to normalized earnings, and seeing them as a filtered QuickBooks report is far quicker than scanning PDFs.

Lifestyle analysis and asset tracing. Following money from the operating account to an outside account or an unexplained payee is the core of tracing. Real wealth at the top is usually held through entities and brokerage accounts that a bank statement only partly shows, which is why public rankings of the very richest people estimate rather than audit. For an ordinary business owner, though, the operating account is where the money actually moves, and that is the account you convert first.

Embezzlement and fraud examinations. Duplicate vendor payments, checks to unfamiliar payees and round-dollar transfers stand out once the year is in a register you can sort. Our guide to finding a transaction in QuickBooks covers the search and filter tools you will use most.

Bankruptcy and receivership. A trustee or receiver often inherits a debtor with no current books. Rebuilding from statements is the same job as a catch-up bookkeeping project, with a stricter standard for documenting each step.

How it works

Upload the statements, PDF, scan or phone photo. Multi-page statements with running balances are read as one document. You review the extracted transactions on screen, where the totals are checked against the statement. Then you export a .qbo file for QuickBooks, plus Excel and CSV copies of the same lines if you want a working paper outside QuickBooks. In QuickBooks Online the file goes in through Transactions, Bank transactions, Upload from file. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. The full import route is in our page on importing old bank statements into QuickBooks.

Good practice for a file that will be scrutinized
  • Create a separate QuickBooks company file for each engagement, never the client's live file.
  • Keep the original production and log which PDF produced which .qbo, by Bates number if the statements carry one.
  • Import one account at a time and reconcile each month before you start coding.
  • Code with bank rules and classes, then export the rule list so your method is documented.
  • Note every statement that was missing, illegible or produced late, and when you filled the gap.
Honest comparison of the options
ApproachWhere it winsWhere it falls short
Keying statements into a spreadsheetNo software cost, total control of layoutSlow, error prone, and every line is a keyed line
Dedicated forensic analytics suitesDeep data analytics, sampling and audit logging across many data typesPriced for firms, and they still need the bank lines extracted first
Bank feed into QuickBooksClean data for current activityUsually only reaches back a limited period and needs the account holder's login
Convert statements to .qbo with bankqboFast, reads scans, totals checked, lands in a tool you already knowBank and card statements only, not invoices, contracts or brokerage reports

If you are weighing statement conversion tools generally, our roundup of the best bank statement to QuickBooks converters compares them on price and output.

Frequently asked questions

Can forensic accountants use QuickBooks to reconstruct records?

Yes. Many forensic accountants rebuild a business's books in a separate QuickBooks company file because it reconciles each month to the bank, supports rules and classes for coding, and produces standard reports. The key is getting the bank lines in without retyping, which converting each statement to a .qbo file does.

How do you reconstruct accounting records from bank statements?

Start with the bank statements for every account, convert each to a .qbo file and import it into a new QuickBooks company file. Reconcile each month to the statement's ending balance, then code deposits and payments by source and payee. Missing months show up as reconciliation gaps you can document and request.

Does the converter read scanned or photographed statements?

Yes. Scans of mailed statements and phone photos are read with visual OCR, and the totals are checked against the statement before export. Faint or skewed pages should still be reviewed line by line on screen, which the review step lets you do before you download the file.

Which plan exports the .qbo file?

The Plus plan and above export .qbo, and Plus adds bulk upload of up to 50 files at once, which suits a production of a hundred or more statements. Your first three statements convert free, once, without a card, so you can test the output on the actual production before you buy.

Turn the production into a ledger today

Convert your first statement free.

Upload a PDF, see every transaction extracted in seconds. No card to try it.

Still comparing tools? See our bank statement to QuickBooks converter comparison.

Related guides

If you have a folder of statements and a deadline, upload a few of them at the top of this page and check the extracted lines against the PDFs. The pricing page lists the page allowances for larger engagements, and the accountant and bookkeeper version of this workflow covers the year-round batch routine.