QuickCheckTools

Bank statement converter

Turn a PDF bank statement into Excel or CSV in seconds. Every row is checked against the balance the bank printed, and the statement never leaves your computer.

Choose a PDF or drop it here

Use the PDF from your online banking, not a scan. One statement a day is free.

statement.xlsxTransactions
DateDescriptionMoney inMoney outBalanceCheck
01 OctOpening balance1,240.50
02 OctCard payment, corner shop42.181,198.32OK
03 OctPayment from client350.001,548.32OK
06 OctDirect debit, energy86.001,462.32OK
08 OctStanding order, rent650.00812.32OK
09 OctTransfer from savings200.001,012.32OK
Opening 1,240.50 + in 550.00 − out 778.18 = closing 1,012.32RECONCILED
An example of the Excel file. The figures are made up; yours come from your statement.

Free for one statement a day

Free

$0

One statement a day, with both the Excel and CSV downloads. No sign-up.

30-day pass

$19 (£15)

As many statements as you like for 30 days. You pay once and it does not renew. Offered on this page when you convert your second statement of the day.

How the check works

A converter that only copies text can drop a row or misread a figure without you noticing. This one proves each row instead:

  1. Row by row: the previous balance plus money in, minus money out, must equal the balance printed on that row.
  2. Totals: opening balance plus all money in, minus all money out, must equal the closing balance.
  3. Count: where the statement says how many transactions it holds, the converter must have read exactly that many.

You only see RECONCILED when every check passes. If one fails, the converter tells you which row so you can look at it before you rely on the figures.

What you need

  • A PDF downloaded from your online banking, not a scan or a photo.
  • A statement that shows a balance on each transaction line. Most UK and US statements and online banking exports do.

Importing into Xero, QuickBooks or Sage? The bank statement to CSV converter gives you the CSV first, with the tested Xero import steps.

Questions

How do I convert a PDF bank statement to Excel?

Choose your PDF statement above. The converter reads every transaction, checks each one against the running balance printed on the statement, and gives you an Excel workbook or a CSV file to download. It takes a few seconds and nothing is uploaded.

Is the bank statement converter free?

Yes, one statement a day is free, with both the Excel and CSV downloads. If you have more to do, a 30-day pass converts as many statements as you like for $19 (£15). You pay once; it does not renew.

Is my bank statement uploaded anywhere?

No. The PDF is read by your own browser on your own computer. It is not sent to us or to anyone else, and nothing is stored. You can disconnect from the internet after the page has loaded and it still works.

How do I know the conversion is right?

Every row is checked: the previous balance plus that row's money in, minus its money out, must equal the balance the bank printed on that row. The totals must also take the opening balance exactly to the closing balance. You only see RECONCILED when every check passes; otherwise the converter tells you which row is out.

Which banks does it work with?

It works with text-based PDF statements that print a running balance on each transaction, which most UK and US bank statements and online banking transaction exports do. It has been tested on Barclays online banking exports and on standard statement layouts with paid-in/paid-out columns or a single signed amount column.

Does it work with scanned statements?

Not yet. A scanned statement is a picture with no text in it, so there is nothing to read. Download the statement from your online banking as a PDF instead; those contain the text.

What is in the Excel file?

A Transactions sheet with date, description, money in, money out and balance, plus a Check column with a formula on every row that shows OK when the balance follows. A Reconciliation sheet shows the opening balance, total in, total out and closing balance, and says RECONCILED or NOT RECONCILED.

Can I import the CSV into accounting software?

Yes. The CSV has one row per transaction, with a signed Amount column (money out as a minus) and separate Money in and Money out columns. Xero picks up the Date, Description and Amount columns automatically on its Import bank statement screen; we have tested this. For other software, map Date, Description and either Amount or Money in and Money out on its bank import screen.

Free calculator by QuickCheckTools