General Ledger + Converter in one subscription.
See pricingGUIDE · QUICKBOOKS CSV IMPORT
QuickBooks Online imports a bank CSV with 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), one date format, up to 1,000 lines and 350 KB. Upload it from Bank transactions, Link account, Upload from file. Starting from a PDF? See importing a PDF bank statement into QuickBooks; the ZeraBooks bank statement converter makes the CSV.
7-day trial · card required, nothing charged for 7 days · 1,000 pages a month from $79/month billed annually
THE FORMAT RULES
Every rule Intuit lists for a transactions CSV, from its help article updated August 24, 2026 and checked October 22, 2026: 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), extra columns deleted, up to 1,000 lines and 350 KB per upload, in English. The sample is a fictional September 2026 export for Brightwater Plumbing, checking ending 6614, reshaped from the bank’s file.
| Column | What goes in it | Example |
|---|---|---|
Date | One format for the whole file; Intuit suggests dd/mm/yyyy, and the format you pick when mapping must match. No day of the week in the cell | 09/01/2026 |
Description | The bank’s description; remove special characters if rows are rejected | Text from the bank |
Amount | 3 columns: money in positive, money out negative. Plain numbers, no currency sign or thousands separator | -642.30 |
Credit | 4 columns, in place of Amount: money in. No word “amount” in the header; leave the cell blank, never 0.00 | 1875.00 |
Debit | 4 columns: money out. Same header and blank-cell rules as Credit | 642.30 |
Date,Amount
09/01/2026,1875.00
09/02/2026,-642.30
09/08/2026,-1210.00
09/15/2026,980.50Only the Date and Amount columns are shown; the bank’s description comes across unchanged as Description. The bank’s file had the weekday inside the date (Tue 09/01/2026), separate Withdrawals and Deposits columns, zeros where nothing moved, and a running balance from an opening 3,904.12. Deposits 2,855.50 minus withdrawals 1,852.30 is +1,003.20, and 3,904.12 + 1,003.20 = 4,907.32, the bank’s closing balance, so the file is complete. The Amount column must total the same 1,003.20. For the 4-column layout instead, keep Withdrawals as Debit and Deposits as Credit, rename both headers without the word “amount”, and blank every 0.00. The Balance column and the opening row go either way. One transaction per line, no subtotals, page headers or balance rows in between. A CSV of 1,000 lines with three short columns is usually well under 350 KB, so the line limit is the one most files hit first.
We set you up and catch up your past months for free. Then ZeraBooks keeps your books done.
A REAL EXPORT
A real run in ZeraBooks Convert: the fictional Bank of America sample statement BofA_Business_Advantage_8803_September_2026.pdf, already proven to the cent, downloaded QuickBooks-ready as a CSV. The file that came out, QuickBooks-ready - BofA_Business_Advantage_8803_September_2026.csv, has 18 rows with the columns Date, Description, Amount.
The format, picked in Convert
The file that downloaded
STEP BY STEP
The menu names as Intuit’s current help article gives them.
Go to All apps, then Accounting, then Bank transactions. If the account already has a tile, select it.
Open the Link account dropdown and select Upload from file. For an account that isn’t connected to online banking, the option may read Or upload transactions manually.
Select Drag and drop or select files, choose the CSV and select Continue.
In the QuickBooks account dropdown, choose the bank or card account the file belongs to, or Add New, then Continue. Choose a credit card account for a card file.
Match Date, Description and Amount (or Credit and Debit) and choose the date format your file uses. If every amount looks backwards on the next screen, use reverse all values.
Tick the transactions to bring in, select Continue, then Yes and Done. They wait in For review until you categorize or match them.
OVER THE LIMIT
Split the file by date, never in the middle of a day. A busy account with 2,350 lines for 2026 goes in as three uploads:
| Upload | Dates | Lines | Under 1,000? |
|---|---|---|---|
| 1 | January 1 to May 31 | 980 | Yes |
| 2 | June 1 to September 30 | 940 | Yes |
| 3 | October 1 to December 31 | 430 | Yes |
| Year | 2,350 |
The three files add back to 2,350 lines, so nothing was dropped at the seams. Upload them in date order and make the first one start the day after the last transaction already in the account; Intuit gives that rule to avoid duplicates.
ERRORS AND FIXES
The causes Intuit documents in its two upload troubleshooting articles (updated August 2026), with the fix for each. The exact messages follow below.
| Symptom | Cause | Fix |
|---|---|---|
| File won’t import after mapping | Wrong columns chosen, or extra columns | Delete unneeded columns, rename headers to Date, Description and Amount, map again |
| Amounts rejected | Currency symbols or thousands separators | Format the amount cells as General, not Currency, and save again |
| Rows rejected for no clear reason | Special characters in the bank’s description | Find and remove the symbols, then re-upload |
| Credit/Debit file of only payments fails | No money-in line at all | Add one line with a positive amount, then untick it on the review screen |
| Upload to a subaccount fails | Intuit doesn’t support importing into a subaccount | Upload to the parent account, connect the subaccount to a feed, or enter the lines by hand |
If a file still fails, Intuit suggests copying the data into a blank spreadsheet to shake out hidden formatting. If your bank offers a QBO or QFX file for the period, that route skips the CSV rules entirely; see what a QFX file is.
ERROR MESSAGES
The messages Intuit documents, with the fix for each:
The uploaded file contains invalid transaction amount information.
WhyAn amount with 12 or more digits.
FixTake that row out, enter it by hand, re-upload the rest.
The uploaded file is of a different type than these accounts.
WhyA card file going to a bank account, or the reverse.
FixSelect Cancel and pick the matching account.
We were unable to upload the file…
WhyA timeout or a temporary server problem.
FixWait a few minutes and try again.
QuickBooks Online couldn’t upload your file…
WhyA timeout or a temporary server problem.
FixWait a few minutes and try again.
An Online Banking update is currently in progress
WhyQuickBooks is running its daily download.
FixWait until it finishes, then upload.
BEFORE YOU UPLOAD
WITH ZERABOOKS CONVERT
If the starting point is a PDF statement, ZeraBooks Convert makes the file. It doesn’t connect to QuickBooks.
QUICKBOOKS-READY
Choose QuickBooks-ready and CSV in the Download dialog and you get the 3-column layout: money out as a minus, plain amounts with two decimals, no balance column, one file per account. Dates are written MM/DD/YYYY, so pick that format when you map. Convert makes CSV and Excel only: no .qbo or IIF files and no QuickBooks connection. The product page is PDF to QuickBooks.
Choose a download format
CHECKED FIRST
Every statement is checked against its printed opening and closing balance, to the cent, and one that doesn’t tie is flagged for review before you download, the same proof as the Brightwater example above done for you. More formats for other software are in convert a bank statement to CSV.
How Convert proves a statement
MORE IMPORT GUIDES
Any single format, as long as it matches the one you choose when mapping. Intuit suggests dd/mm/yyyy. Don’t mix formats in one file, and take any day of the week out of the Date column.
Whichever is closer to your bank’s export. A bank that prints one signed amount fits 3 columns; one with separate withdrawals and deposits fits 4. Both import the same way. For other kinds of data, see the QuickBooks data import guide.
Up to 1,000 lines in a file of 350 KB or less. For more, split by date range and upload each file in order. For QuickBooks Desktop, see how to import a CSV file into QuickBooks Desktop.
The file has money out as positive, or Credit and Debit mapped the wrong way round. On the review screen, use reverse all values, or fix the signs in the file and upload again.
The file overlapped transactions already in the account. Start each file the day after the account’s last transaction, and exclude any doubles in For review before categorizing them.
No. ZeraBooks has no QuickBooks connection; you upload the QuickBooks-ready CSV yourself. Convert is included in the ZeraBooks subscription: 1,000 pages a month from $79 a month billed annually after a 7-day trial.
FREE SETUP + CATCH-UP
Free for 7 days, then 1,000 pages a month from $79 a month billed annually; see ZeraBooks pricing. Or keep the books in ZeraBooks with AI bookkeeping instead of importing at all.