Skip to content

Bank statement to QuickBooks

“QuickBooks” is two different programs that take two different files. Upload your statement, keep QuickBooks Online as the output, and the .qbo file imports through the bank feed; the section below covers what to do on Desktop.

Upload a file

What you get for QuickBooks

  • QuickBooks Online: a .qbo file for the bank-feed import
  • One transaction per line, in the order the statement prints them
  • Debits and credits on the side the statement shows them
  • QuickBooks Desktop is not served by this file — see below

QuickBooks Online vs QuickBooks Desktop

QuickBooks Online imports a .qbo file through its bank feed. That is what this page produces, and it is the file most people are looking for.

QuickBooks Desktop is a separate program and reads a separate format (IIF) or a bank-specific import. A .qbo file is refused by Desktop, so on Desktop convert to CSV or Excel and import that instead.

How to convert

  1. Upload your statement

    Drop in the PDF or CSV you downloaded from your bank.

  2. Check which QuickBooks you have

    Online takes the .qbo file below; Desktop needs CSV or Excel.

  3. Import the file

    Bring the .qbo in through the bank feed in QuickBooks Online.

Why this is more accurate than OCR

OCR reads a statement by position on the page. When a description wraps onto a second line, or the debit and credit columns sit close together, a positional parser attaches the wrong text to the wrong number.

Read by position

02/03  DIRECT DEBIT 4471
       ACME INSURANCE LTD   120.00
04/03  CARD PAYMENT
       NORTHGATE MARKET     -38.40

The wrapped line becomes a second transaction, and the amount lands on the wrong row.

Read as content

02/03  DIRECT DEBIT 4471 ACME INSURANCE LTD    120.00
04/03  CARD PAYMENT NORTHGATE MARKET           -38.40

One row per transaction, the description kept whole, the amount in the amount column.

Frequently asked questions

Does this work with QuickBooks Online or QuickBooks Desktop?

QuickBooks Online: yes, the .qbo file is what its bank feed imports. QuickBooks Desktop: no — Desktop reads IIF or a bank-specific format, so convert to CSV or Excel for it.

What is the difference between the two QuickBooks?

They are separate products with separate import formats. Online runs in a browser and imports .qbo; Desktop is installed locally and imports IIF.

Can I convert a PDF bank statement for QuickBooks?

Yes. The input is a statement PDF or CSV either way; only the output file differs.

Will my accounts be matched automatically?

No. The file carries the transactions; which account they land in is a decision you make during the import.

Is my statement kept after conversion?

No. The file is used only to produce your converted copy and is deleted right after.

Do I need an account?

No. The converter works without signing up.

Related converters