QuickBooks Online: upload a .QBO file or a CSV?
Short answer
QuickBooks suggests a .QBO file, and also takes QFX and CSV. A .QBO file needs no preparation; a CSV needs three or four specific columns, which you match to QuickBooks' fields during the upload. Whichever you use, one upload holds up to 1,000 transactions and 350 KB, and must be in English.
The limits on every file
- Up to 1,000 lines per upload, one transaction per line, and a file of 350 KB or less. For more, split the date range and upload in batches.
- The file must be in English.
- Start at least one day before the oldest transaction QuickBooks already has for that account.
- Check your chart of accounts first, so the upload doesn't create duplicate transactions.
- Bank rules set up beforehand categorize transactions as they arrive.
Upload the file
- Go to All apps, then Accounting, then Bank transactions.
- If there's a tile for the account, select it.
- Open the Link account dropdown and select Upload from file. If the account isn't connected to online banking yet, choose Upload from file or the option to upload transactions manually.
- Select Drag and drop or select files, choose your file, then Continue.
- Pick the QuickBooks account the transactions belong to, or Add New to create one, then Continue.
- Match the file's columns to QuickBooks' fields, then Continue.
- Select the transactions to import, then Continue, and confirm.
Then match and categorize the transactions, and reconcile the account.
What QuickBooks needs from a CSV file
- Three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit).
- Leave an amount, credit or debit cell blank rather than writing 0 in it.
- Every date in the same format. QuickBooks recommends dd/mm/yyyy.
- If your bank puts the weekday in the date cell (20/11/2022 TUE), move the weekday into its own column.
QuickBooks can also read the PDF itself
QuickBooks Online now accepts a statement as a PDF or an image. Its help page says its AI extracts the transactions, that some statements may be reviewed by its team of experts, and that you check a side-by-side view before saving.
If that suits you, you don't need a converter. ZeroParse is for when you'd rather the statement was read by fixed rules instead of AI: every file is checked against the totals it prints, and the PDF is discarded from memory as soon as it has been read.
Turning a PDF statement into a file QuickBooks accepts
Export .QBO writes a Web Connect file with QuickBooks' signs already applied: money spent negative, money received positive, including on card statements that print them the other way round. It's part of the Pro and Firm subscriptions.
More than 1,000 transactions, or a file over 350 KB, and the export splits them for you: several .QBO files in one zip, in date order, each within QuickBooks' limits. Upload each file in turn.
The CSV export is free on every plan. Use the Columns button to hide everything except Date, Description and Amount, and it has the three columns QuickBooks asks for, with every date in one format. Set CSV dates, under the table, to DD/MM/YYYY, the format QuickBooks recommends.
Sources
Checked against these help pages on 27 September 2026. They change; if one now says something different, it is right and this page is out of date.
Only have the PDF?
QuickBooks imports bank transactions from a .QBO file, the Web Connect format. ZeroParse turns a PDF statement into one, with every amount signed the way QuickBooks expects. New accounts get 50 free PDF credits, no card required.
Common questions
- Can I export to QuickBooks?
- Clean CSV export is available on every plan, including Free. .QBO export (QuickBooks' Web Connect format) is a Pro feature. QuickBooks Online takes up to 1,000 transactions and 350 KB per upload, so a larger export arrives as several .QBO files in one zip, in date order: upload each file in turn.
- Can I choose which columns show, and does that change what I export?
- Yes — the Columns button above the table shows or hides Date, Description, Amount, Type, and Source. The CSV and Excel exports match whatever's visible. The .QBO export doesn't: QuickBooks requires every field on every transaction to import at all, so it always includes the full record regardless of which columns you've hidden on screen.
- How does ZeroParse handle debit vs. credit on a credit card statement?
- We normalize every statement to the same convention QuickBooks and Xero expect: money you spent (a purchase) exports as negative, money you received back (a payment or refund) exports as positive — whether the file is a bank account or a credit card statement. Card issuers often print it the opposite way on the page itself (a purchase shown as a plain positive number, since it increases what you owe); we detect a credit card statement automatically and flip it, so what you export is ready to import rather than something you'd need to invert by hand.
- Does ZeroParse use Artificial Intelligence?
- No. Extraction is deterministic and rule-based — the statement's own text layer or OCR output, positional/spatial geometry to recover the transaction table, and pattern-matching parsers, cross-checked with mathematical reconciliation against the totals your statement prints about itself. There are no AI or LLM models anywhere in the pipeline, so there's no AI hallucination risk and nothing about your documents is ever used to train a model.