How to import bank transactions into QuickBooks from a PDF statement
By the Banking Converter editorial team
Published
QuickBooks cannot read a PDF statement directly. Convert the statement to CSV (QuickBooks Online) or QBO Web Connect (QuickBooks Online or Desktop), then upload it through Banking, Upload from file (Online) or File, Utilities, Import, Web Connect Files (Desktop). QBO files carry transaction ids that prevent duplicates; CSV files do not, so import non-overlapping periods.
CSV or QBO?
| CSV | QBO | |
|---|---|---|
| Works in QuickBooks Online | Yes (3- or 4-column layout) | Yes |
| Works in QuickBooks Desktop | No (needs a QBO or IIF file) | Yes |
| Duplicate protection | None built in; QuickBooks may warn on matching date and amount | FITID per transaction; already-imported ids are skipped |
| Requires bank identifiers | No | Yes: ORG, FID and INTU.BID registered with Intuit |
| Balances and dates | Dates must match QuickBooks' expected format | Dates unambiguous; ledger balance included |
If you only use QuickBooks Online and do not know your bank's Intuit identifiers, CSV is the simpler path. For Desktop, or for repeat imports where duplicates matter, use QBO. See CSV vs QBO.
QuickBooks Online: importing a CSV
- Convert the statement with the CSV converter. Choose the standard profile for a 3-column file (Date, Description, Amount) or the accounting profile and remove the Balance column for a 4-column file (Date, Description, Credit, Debit). Set the date format to match your QuickBooks region (MM/DD/YYYY in the US).
- In QuickBooks Online go to Transactions, Bank transactions. Open the Link account menu and choose Upload from file.
- Select the CSV, choose the QuickBooks account it belongs to, and map the columns. Confirm the date format and whether amounts are in one column with signs or two columns.
- Review the preview, deselect anything already in QuickBooks, and import. The transactions arrive in For review, where you categorise or match them.
QuickBooks Online limits CSV uploads to 350 KB; split very long statements by month if needed.
QuickBooks Online or Desktop: importing a QBO file
- Find your bank's Intuit identifiers (see what is a QBO file). The converter asks for ORG, FID and INTU.BID and writes them into the file; it will not invent them.
- Convert with the QBO converter. Review flagged rows and download the .qbo file.
- QuickBooks Online: Transactions, Bank transactions, Link account, Upload from file, select the .qbo file, choose the account.
- QuickBooks Desktop: File, Utilities, Import, Web Connect Files. Choose the .qbo file and, when asked, select the existing bank account to link it to (or create one).
- Transactions appear in the Bank Feeds Center (Desktop) or For review (Online).
Avoiding duplicates
- Import each statement period once. If a connected bank feed is already pulling transactions, only import PDF conversions for periods the feed did not cover.
- Use QBO files for repeat imports: the converter generates the same FITID for the same transaction every time, so re-importing a corrected file does not duplicate rows.
- With CSV, check the preview screen for rows already in QuickBooks and deselect them.
- If duplicates already exist, see fixing duplicate transactions after import.
Reconciling after import
After categorising, reconcile the account (Accounting, Reconcile in Online; Banking, Reconcile in Desktop) using the statement's closing balance and date. If the difference is not zero, compare the statement's total deposits and withdrawals with the imported totals; the conversion's reconciliation report tells you whether the extracted rows matched the statement, so any difference at this point is an import or categorisation issue rather than an extraction one.
Frequently asked questions
Can QuickBooks import a PDF bank statement directly?
No. QuickBooks imports CSV, QBO (Web Connect), OFX in some editions, and IIF for Desktop. A PDF must be converted first.
Which date format does QuickBooks Online expect?
The format set in your QuickBooks company settings, usually MM/DD/YYYY in the US and DD/MM/YYYY in the UK, Australia and Canada. You confirm the format during the CSV import mapping step.
Other bank statement converters
About the author
The Banking Converter editorial team is the engineering group that builds and tests the conversion engine: the parsers for regional date and number formats, the reconciliation checks and the CSV, Excel, JSON, OFX and QBO exporters. Guides describe what the software does and what the formats require; they are not financial, legal or tax advice.