QuickBooks Online bank CSV format: a practical checklist
A bank export can look correct in a spreadsheet and still fail during import. Check its columns, dates and amounts before you upload it to QuickBooks Online.
What the file needs
For a bank transaction import, QuickBooks Online accepts CSV files with either three columns—Date, Description, Amount—or four—Date, Description, Credit, Debit. Intuit says each upload can contain up to 1,000 transaction lines and must be 350 KB or smaller. The file must be in English. These requirements may vary by region or change over time, so check Intuit’s current instructions for your account.
Date,Description,Amount 2026-10-01,Client payment,1250.00 2026-10-02,Office supplies,-89.40
In the three-column form, money out is usually a negative amount. In the four-column form, credit and debit amounts occupy separate columns. Review the signs against your bank statement before confirming an import.
Common issues to check
| Issue | What to inspect |
|---|---|
| Ambiguous dates | 03/04/2026 could mean March 4 or April 3. Confirm the bank’s date order and use one format consistently. |
| Wrong amount signs | Check whether withdrawals are negative or appear in a separate debit column. |
| Extra columns | Remove balance, category and account fields from a three-column file. Keep a copy of the original export. |
| Repeated rows | Overlapping export date ranges can duplicate transactions. Check the bank statement and your existing QuickBooks records. |
| File too large | Split the transaction range into smaller files within Intuit’s limits. |
A safe import sequence
- Download a CSV from your bank and retain the original file.
- Open it in LedgerLint; match the date, description and amount columns.
- Review flagged rows and download the cleaned CSV.
- In QuickBooks Online, open Bank transactions → Upload from file, select the account and map the columns.
- Review the preview in QuickBooks and reconcile it against the bank statement.
LedgerLint processes CSV contents in your browser. It cannot check transactions already in QuickBooks, verify a bank statement’s completeness, or guarantee QuickBooks acceptance.
Source: Intuit, “Manually upload transactions into QuickBooks Online”. LedgerLint is independent and is not endorsed by Intuit.