SheetProofConvert
Guide · bank statement PDF → Excel & CSV

Bank statement PDF to CSV, with the balance check.

Drop the PDF, check the verdict, click Download CSV. The file has the columns accounting tools ask for, and nothing is uploaded.

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.

What is in the CSV

One row per transaction, with five columns:

  • Date as YYYY-MM-DD, the format most importers accept.
  • Description exactly as printed, with wrapped lines joined.
  • Amount with a minus for money out and no currency symbol or thousands separator.
  • Running balance, calculated from the opening balance.
  • Balance on statement, where your bank prints one on the row.

Check before you import

A CSV has no tabs, so the Proof tab only exists in the Excel file. The verdict on this page is your check: it adds every row to the opening balance and compares the result with the closing balance on the statement. If it says "Does not balance", fix the file before it reaches your books. Download the Excel version if you want to keep the proof next to the data.

Importing into other tools

Most importers want Date, Description and Amount. Map those three and ignore the other two columns. If your tool wants separate Debit and Credit columns, open the CSV in Excel or Google Sheets and split the Amount column with a formula such as =MAX(C2,0) and =MAX(-C2,0).

Questions

Does the CSV use a comma or a semicolon?

A comma, with quotes around any description that contains a comma. Amounts use a dot as the decimal point.

Can I get several months in one CSV?

Convert each month and append the files. Each month is checked against its own opening and closing balance.

Is the PDF uploaded to create the CSV?

No. The PDF is read in your browser. The result shows the number of network requests made while your file was read (0).