useme4bank files, sorted

PDF to QBO converter

Turn a PDF bank statement into a QBO (Web Connect) file that QuickBooks imports without column mapping. The PDF to QBO conversion runs entirely in your browser — the statement is never uploaded.

Choose your PDF statement

The PDF is read in your browser. It is never uploaded, and nothing is stored.

When you need a QBO file from a PDF

Banks offer QuickBooks Web Connect (.qbo) downloads for recent activity, but often only for a limited period — and some don’t offer them at all. When the only record of a month is the PDF statement, converting PDF to QBO is the fastest way to get those transactions into QuickBooks: a QBO file needs no column mapping, and each transaction carries an ID that helps QuickBooks avoid importing it twice.

Convert a PDF bank statement to QBO

  1. Drop the PDF statement on the converter. Review the transactions it finds and correct anything highlighted.
  2. In step 3, QuickBooks QBO (Web Connect) is preselected. Choose Bank or Credit card, the currency, and optionally the last four digits of the account number.
  3. Leave the Intuit bank ID at 3000 unless you have a reason to change it (see below), then download.
  4. Import the file into QuickBooks and pick the account it belongs to.

What goes into the QBO file

Each transaction becomes an OFX STMTTRN record with its date, signed amount, a payee name built from the description, and a stable transaction ID (FITID). The file also records the account type, currency and the date range of the statement. The running balance printed on the PDF is used to check the transactions while you review them, but QuickBooks calculates its own balance.

The Intuit bank ID

Every QBO file names a bank by its Intuit ID. QuickBooks Online accepts the generic ID used here. QuickBooks Desktop is stricter: it checks the ID against Intuit’s list and may refuse a bank it considers unsupported for Web Connect. If that happens, the QuickBooks Desktop Web Connect guide explains the options, including using a CSV import instead.

Avoiding problems

  • One statement, one file. Import statements in date order and don’t overlap periods already in QuickBooks.
  • Credit card statements. Choose Credit card in step 3 so charges and payments are treated correctly.
  • Check totals before importing. Compare the money in and out with the statement; a QBO import is harder to undo than a check.
  • Scanned PDFs have no text to read — download the statement again from online banking if you can.

QBO or CSV for a PDF statement?

Both get the transactions into QuickBooks. A QBO file is quicker — no mapping screen — and its transaction IDs help QuickBooks spot repeats. A QuickBooks CSV, chosen in the same list, is easier to inspect and edit in Excel before you upload it, and avoids QuickBooks Desktop’s bank ID check. If you’re unsure, start with QBO for QuickBooks Online and CSV for Desktop.

If your bank gives you a CSV or Excel file instead of a PDF, use CSV to QBO or Excel to QBO.

Frequently asked questions

Does the QBO file work in QuickBooks Online and Desktop?

Yes. QuickBooks Online imports it under Upload transactions. QuickBooks Desktop imports Web Connect files too, but may refuse some bank IDs; the Desktop guide explains why.

What is the Intuit bank ID for?

It tells QuickBooks which bank the file came from. The default works for QuickBooks Online; Desktop checks it against Intuit’s list.

Will QuickBooks create duplicates if I import twice?

Each transaction has an ID, which helps QuickBooks recognise repeats, but you should still avoid importing overlapping periods.

Is my statement uploaded to make the QBO file?

No. The PDF is read and the QBO file is created in your browser.

Can I convert a credit card statement to QBO?

Yes. Choose Credit card as the account type in step 3 and import into a credit card account.