SheetProofConvert
Guide · bank statement PDF → Excel & CSV

Bank statement PDF to a CSV in the QuickBooks layout.

When your bank only gives you a PDF, convert it here and import the CSV. The balance check tells you whether every transaction made it across.

Drop your statement PDF

Chase, Bank of America, Wells Fargo, TD Bank and other banks (generic reader)

Several months? Select them together: you also get a month-to-month check.

No statement handy?
10 free pages a dayWorks with Wi-Fi off

Chase, Bank of America, Wells Fargo and TD Bank: tested on synthetic statements in their layouts and on the sample statements Wells Fargo and TD Bank publish, not yet on customer statements. U.S. Bank and Citi: no official sample exists that we could find, so they use the generic reader. Every file shows whether it balanced. How we test

sample-statement - SheetProof.xlsx · Proof tab · Microsoft Excel
The Proof tab of the converted sample statement, opened in Microsoft Excel: opening balance 3,842.15, money in 4,316.00, money out -3,351.52, calculated closing 4,806.63, closing on the statement 4,806.63, difference 0.00, balanced to the cent
Real screenshot: Microsoft Excel showing the Proof tab of the sample on this page (fictional data). Your file gets the same tab.

The steps

  1. Drop the statement PDF on this page and wait for the verdict.

  2. If it says "Balanced to the cent", click CSV for QuickBooks (Date as MM/DD/YYYY, Description without @ # $ %, Amount with money out negative).

  3. In QuickBooks Online, open the banking page and choose to upload transactions from a file. Pick the CSV and map Date, Description and Amount (a single Amount column with negatives for money out). Menu names change, so look for the upload-from-file option.

Tested: import into GnuCash (free)

We test-imported the downloads into GnuCash 5.17 for Windows with three public sample statements that balance and one synthetic statement full of awkward descriptions (ampersands, commas, quotes, accents, two identical rows on the same day). The OFX files matched in all four cases and the QuickBooks-layout CSV in two (Wells Fargo and the synthetic statement): the number of rows, every date, every amount with its sign and the final account balance came out as on the statement, to the cent. Importing the same file a second time added no duplicates (checked on the Wells Fargo sample, OFX and CSV). This tests our files, not QuickBooks or Xero.

OFX: File, Import, Import OFX/QFX, then pick the account when GnuCash asks. CSV: File, Import, Import Transactions from CSV; set the date format to month-day-year and the currency format to a decimal point (the default follows your computer language and can misread 1,234.56), skip 1 header row, and map the columns to Date, Description and Amount. GnuCash then asks for the other side of each transaction (a category), as any double-entry program does.

What this does not do

SheetProof Convert does not create .QBO files and does not connect to QuickBooks. QBO files need bank identifiers that a PDF does not contain. It does offer an OFX download when the statement balances, with a placeholder bank identifier (000000000) and the last four digits of the account when the PDF prints them; we checked it with two open-source OFX readers and test-imported it into GnuCash (not into QuickBooks), so use the CSV if the OFX import complains. If your bank offers a direct QBO or bank feed, use it: it is more reliable than any PDF. This tool is for the statements you only have as PDFs, for example older months or a statement a client sent you.

Why check the total first

Importing a CSV with one missing transaction puts your books out of balance in a way that is hard to trace weeks later. The check on this page compares the opening balance plus every row with the closing balance printed on the statement, and names the first row that breaks.

Questions

Does QuickBooks accept this CSV?

QuickBooks Online asks for a CSV with Date, Description and Amount columns (Intuit's help page on formatting CSV files for bank transactions). The "CSV for QuickBooks" download follows that layout. We have not imported it into QuickBooks ourselves: we checked the layout and test-imported the same file into GnuCash, where all rows, dates, signs and the final balance matched. GnuCash is a different program, so map the columns in the QuickBooks import preview and check the first rows.

Is my client’s statement uploaded?

No. It is read in your browser. If you work with client statements, you can show them the Wi-Fi test on the home page.

Can I convert many statements at once?

Up to 12 PDFs together get one workbook with a month-to-month check; the QuickBooks CSV is made for one statement at a time. There is no API yet.