Try it now

Bank statement to QuickBooks or OFX

Updated

Accounting software imports bank transactions from files, but a bank does not always give you one, and older statements usually exist only as PDFs. docsanalyzer reads the statement, checks it, and exports a QuickBooks (.qbo) or OFX file ready to import.

QBO and OFX in a sentence each

OFX (Open Financial Exchange) is a standard file format for bank transactions that many accounting programs import. A .qbo file is the OFX variant QuickBooks uses for bank files, with a QuickBooks bank identifier added.

In docsanalyzer, the export menu lists them as QuickBooks (.qbo) and Xero / generic (.ofx).

Step by step

  1. Open docsanalyzer.com/app and drop the statement: a PDF, a locked PDF, a scan, a photo, or an Excel or CSV export.
  2. Check the balance check before exporting. An import is only as good as the rows in it, and “balance reconciled” means none are missing or misread.
  3. Review payees if you like: the payee goes into the file’s name field, the original description into its memo.
  4. Choose Export, then QuickBooks (.qbo) or Xero / generic (.ofx). The file is built in memory and downloaded to your computer.
  5. In your accounting software, use its bank-file import, choose the file, and pick the bank or card account the transactions belong to.
  6. Review the imported transactions there before you match or categorize them.

What each transaction carries

  • The posting date as printed on the statement, read in any of the usual formats such as 05/09/2026, 2026-09-05 or 05-Sep-26.
  • The amount: a debit is a negative withdrawal, a credit a positive deposit.
  • The payee as the name, so rules in your accounting software can match it.
  • The description exactly as printed, as the memo.
  • A transaction id built from the row itself, so the same row exported twice carries the same id.

Several statements

You can drop several months at once. In All statements they are merged: duplicate rows where two statements overlap are counted once, and each closing balance is checked against the next opening. Export from there to get one file for the whole period, or export each statement on its own.

When to use Excel or CSV instead

If your software does not take QBO or OFX, or you want categories and running balances to travel with the rows, export Excel or CSV. The CSV is UTF-8 with ISO dates and plain numbers, with columns for date, description, reference, debit, credit, account, balance and category. The Excel workbook adds a summary, the balance check, and breakdowns by payee, category, account and month.

Reconciling against your books

If you already keep books, you can go the other way too: in Reconciliation, give docsanalyzer an export from your books as CSV or Excel, and it matches the statement’s transactions against it by reference, amount and date, showing what matched and what did not.