Bank statement PDF to QuickBooks CSV: a worked example

By Yang Ding, StatementImporter · Updated 26 September 2026

To prepare a bank statement PDF for a CSV import, extract the transactions, compare each row with the original statement, then export dates, descriptions and signed amounts. A successful download alone does not establish that the transactions are complete or correct.

If your bank offers a CSV download for the same account and period, start with that file: it avoids PDF extraction. This guide covers the case where you are working from a PDF and want to review a CSV before importing it into QuickBooks.

Try the example before using your own statement

These files use four synthetic transactions. They contain no customer statement data and are not issued or endorsed by a bank. The PDF uses a Barclays-style test layout; results from this small example do not establish accuracy for other layouts or scans.

Download the synthetic PDF · Download its QuickBooks CSV · Download the reviewed Excel table

The PDF includes a visible synthetic-example label so it remains identifiable when downloaded or shared. The CSV and Excel downloads were produced by the StatementImporter browser workflow and contain the same four fictional transactions shown below. You can inspect them without an account. To repeat the conversion, open the converter, sign in with your email, and choose the synthetic PDF. The free beta requires no payment card.

1. Compare the extracted rows with the PDF

Check the statement account, currency, date range and page count first. Then compare every transaction date, description, amount and direction. A transfer to savings is money leaving this account even if you own both accounts. Do not treat a balance, opening total or carried-forward line as a transaction.

2. Check the movement against the balances

The opening balance is £920.55. The four rows contain £4,494.92 incoming and £552.19 outgoing. Therefore £920.55 + £4,494.92 − £552.19 = £4,863.28, matching the closing balance in this example.

This check helps detect some amount and direction mistakes. It cannot prove that every page is present: omitted offsetting transactions could leave the same net movement. Check page numbering, the source totals and every row as separate steps. Resolve warnings against the PDF before relying on an accounting export.

3. Choose the right export and date format

The reviewed Excel table is useful for inspecting statement details. The QuickBooks CSV is a separate, compact transaction file. In the three-column format, use Date, Description and Amount: payments are negative and deposits positive. Use a consistent date format, such as DD/MM/YYYY, and select the matching format during import. See Intuit’s current UK CSV preparation instructions for supported formats and requirements.

The example CSV deliberately omits running balances and statement totals. Do not copy the opening balance into the transaction list. Before importing, check whether your bank feed or a previous file has already brought in the same transactions, and confirm the destination account. StatementImporter creates an export file; it does not connect to or write into your QuickBooks account.

What changes for scanned or multiple statements?

Scans need OCR and can contain misread digits, missing signs or broken dates. A clean-looking table can still be wrong. Use a clearer source where possible and compare the extracted rows with the image. If a value remains uncertain, resolve it before import.

For a batch, keep different accounts and currencies separate. Overlapping statement periods can repeat transactions; examine possible duplicates against the source before removing them. This four-row fixture does not test all of these cases, so it should be used to understand the workflow rather than certify a batch.

Where is the PDF processed?

StatementImporter processes PDF and OCR content in your browser. Email sign-in uses the server for account authentication; signing in does not upload your statement. Review the privacy policy for account and local-storage details. Feedback opens your email app, where you choose what to send; avoid including a complete private statement.

Convert and review your statement · Tell us where the workflow needs improvement