QuickBooks Online: Accepted File Formats
QuickBooks Online supports three file formats for manual bank transaction imports. Which format you use depends on what your bank provides and your conversion tool.
| Format | Extension | Column Mapping | Best For |
|---|---|---|---|
| QBO (Web Connect) | .qbo | Automatic | Recommended — no setup required |
| CSV | .csv | Manual per import | Custom exports, flexible columns |
| OFX | .ofx | Automatic | Some Canadian/European banks |
| Not supported | Must convert to QBO/CSV first |
Use QBO format whenever possible. When you import a QBO file, QuickBooks maps Date, Description, and Amount automatically. CSV imports require you to manually match columns every single time — and the mapping does not reliably save between sessions. Zera Books exports QBO format tested against current QuickBooks Online specifications.
Required Field Mapping for CSV Import
If you're using CSV, QuickBooks Online requires these fields during the column mapping step:
Date (required)
Format: MM/DD/YYYY or YYYY-MM-DD. Two-digit years are rejected. QuickBooks parses month-first in US accounts.
Description (required)
Maps to transaction memo/description. Keep under 255 characters. Payee is parsed from the description text.
Amount (required)
Use negative for withdrawals, positive for deposits. No dollar signs or commas. Or use separate Debit/Credit columns.
Balance (optional)
QuickBooks accepts but does not require a running balance column. Useful for reconciliation verification post-import.
Step-by-Step: PDF Bank Statement to QuickBooks Online
The complete workflow from PDF bank statement to reviewed, categorized transactions in QuickBooks Online.
Upload PDF to Zera Books
Go to zerabooks.com and upload your bank statement PDF. Supports multi-page PDFs, scanned documents, and password-protected files from any bank.
Export as QuickBooks Online (.qbo)
In the Zera Books export panel, choose "QuickBooks Online (.qbo)." The QBO file includes a proper OFX header with account number, bank routing, and transaction records formatted to QuickBooks Online's current specification.
In QuickBooks: Banking tab → Upload transactions
Open QuickBooks Online. In the left menu, click Banking, then select the Banking tab (not the Transactions tab). Click Upload transactions in the top-right corner.
Select account and upload QBO file
QuickBooks asks which account to import into. Select the matching account. Upload your QBO file — QuickBooks reads the account number from the file header and auto-matches when possible.
Review and accept in For Review tab
Imported transactions appear under the For Review tab. QuickBooks suggests matches against existing entries and categories based on payee history. Review, adjust if needed, and click Accept.
Batch processing: Processing multiple clients or months? Zera Books handles 50+ statements at once and exports a QBO file per account. Import each QBO file sequentially — QuickBooks Online supports multiple uploads per account without issues.
Convert any PDF to QBO in under 2 minutes
Any bank format. 99.6% accuracy. AI categorization included. $79/month unlimited for your entire practice.
Try for one weekCommon QuickBooks Online Import Errors
"We couldn't import your file" — format error
The QBO file header is malformed or the OFX version is incompatible. Fix: Re-export from Zera Books using the QuickBooks Online format specifically. Zera Books generates QBO files validated against current QuickBooks Online specs, not generic OFX.
Duplicate transactions after import
Your import date range overlaps with transactions already pulled in by the bank feed. Fix: Check the last transaction date in your bank feed and import only the gap period. Zera Books includes duplicate detection that flags potential overlaps before export.
Transactions imported to wrong account
The account number in the QBO header doesn't match any QuickBooks account, so it defaults to an unintended account. Fix: After import, verify the destination account in Banking > Banking tab. Delete and re-import to the correct account if needed.
CSV date format rejected
Dates formatted as DD/MM/YYYY or including timestamps are rejected. Fix: Zera Books normalizes all dates to MM/DD/YYYY during conversion. For manual CSV files, avoid European date formats — QuickBooks Online US parses month-first by default.
Frequently Asked Questions
What file format does QuickBooks Online accept for bank statement imports?
QuickBooks Online accepts QBO, CSV, and OFX. QBO is best — no column mapping needed. PDF files must be converted first. Zera Books converts any PDF to QBO with 99.6% accuracy.
How do I import a bank statement into QuickBooks Online?
Banking > Banking tab > Upload transactions. Select QBO or CSV, choose destination account, and import. Transactions appear in the For Review tab for categorization and matching.
Can I import a PDF bank statement directly into QuickBooks Online?
No. You must convert the PDF to QBO or CSV first. Zera Books handles this for any bank format — including scanned PDFs — in under 2 minutes.
Why do I get duplicate transactions after importing to QuickBooks?
Import date range overlaps with existing bank feed transactions. Check your bank feed's last sync date and only import the uncovered gap period. Zera Books duplicate detection flags these before export.