DocumentIQ

Bank statement to QuickBooks

Convert a bank statement PDF to QuickBooks

Your bank only gives you PDFs, or its feed is missing the dates you need? Get a .qbo file that QuickBooks Online imports like a bank feed, with every balance checked first.

Tap to choose your statement

PDF from any bank, or photos of each page · or choose files

See an example result

How to get it into QuickBooks Online

  1. Upload your statement PDF, or photos of each page, and pay $4.99 for up to 10 pages. We check every balance before your files are ready.
  2. Download the QuickBooks (.qbo) file from your results page.
  3. In QuickBooks Online, go to Transactions › Bank transactions, then Link account › Upload from file, and choose the file.
  4. Pick the QuickBooks account to import into, then review and categorise the transactions as usual.

The .qbo file is built for QuickBooks Online. QuickBooks Desktop can import it through File › Utilities › Import › Web Connect Files, but some versions only accept files from banks they recognise.

Every format, one payment

Each conversion includes Excel, CSV, QuickBooks (.qbo), OFX for Xero, Sage and FreeAgent, and QFX for Quicken.

Bank statement to Xero →Bank statement to CSV →Bank statement to OFX →

How we know every number is right

Your statement already contains the answer. It prints the balance you started with and the balance you ended with. After reading every transaction, we do the sum.

Opening balance
£2,813.98
+Money in
£11,964.52
−Money out
£6,176.26
=Closing balance ✓
£8,602.24

From our example statement: 78 transactions, landing exactly on the closing balance printed by the bank — to the penny.

  1. 1Every row, every balance

    Most statements also print a running balance on each line. We check every one of those too, so an error can’t hide between two mistakes that cancel out.

  2. 2One slip breaks the sum

    A missed transaction, a doubled one, a misread digit or a debit read as a credit all make the total come out wrong — so we know, and so do you.

  3. 3If it doesn’t add up

    We re-read the pages where it went wrong. If it still doesn’t reconcile, we show you where, and you choose: keep the files, or a full refund. No choice within 24 hours means a refund.

What it proves: every amount and its direction is right, and nothing is missing or duplicated. What it can’t: the wording of descriptions isn’t part of the sum — they’re copied from the page and shown to you before you download. If your statement doesn’t print its balances, we can’t check it, so you get the same choice.