Home › Guides › QuickBooks Online bank statement CSV template
QuickBooks Online bank statement CSV template
QuickBooks Online accepts a bank-transaction CSV in two layouts: Date, Description, Amount (payments negative, deposits positive) or Date, Description, Credit, Debit. Download the sample files below. Intuit limits each upload to 350 KB and 1,000 lines, and recommends dd/mm/yyyy dates. CSVLedger can turn a PDF statement into the three-column CSV (or a .qbo file); it does not convert an existing CSV into .qbo.
Updated November 10, 2026
Download the sample templates
Both files use fictional rows and dd/mm/yyyy dates (15/10/2026 and 16/10/2026), the format Intuit recommends. In the upload screen, choose the date format that matches the text in the file. These are bank-transaction uploads, not invoice, customer or journal imports.
Download the 3-column sample (Date, Description, Amount) Download the 4-column sample (Date, Description, Credit, Debit)
3-column format (signed Amount)
Intuit’s format article shows a payment as a negative amount and a deposit as a positive amount:
Date,Description,Amount
15/10/2026,Office supplies,-84.60
16/10/2026,Customer receipt,1200.00
Use plain decimal amounts, with no currency symbol and no thousands separator. Do not strip the minus sign from a payment. One transaction per row; omit opening-balance, closing-balance and total rows from the upload file.
4-column format (Credit and Debit)
Intuit documents the headings Date, Description, Credit, Debit. In its published example, a payment is entered under Credit and a deposit under Debit:
Date,Description,Credit,Debit
15/10/2026,Office supplies,84.60,
16/10/2026,Customer receipt,,1200.00
Put an amount in only one of the two amount columns on each row. Leave the other cell blank — Intuit says to remove zeros, not to store a 0. Remove the word “amount” from headers such as “Credit amount”. If the mapping is unclear, use the three-column file instead and confirm a payment and a deposit in the preview.
Upload steps and limits
From Intuit’s “Manually upload transactions into QuickBooks Online” article (updated August 24, 2026; checked November 10, 2026):
- Go to Bank transactions, open the correct bank or credit card account, and choose Upload from file (under Link account, or “upload transactions manually” if the account is not connected).
- Select the CSV and the destination account. A card statement belongs in its credit card account, not the checking account that pays the bill.
- Map Date and Description, then the one-amount or two-amount option to match your file. Select the date format that matches the file (Intuit recommends dd/mm/yyyy). If a bank added a weekday to the date (for example 20/11/2022 TUE), split that into a separate column first.
- In the preview, check one known payment and one known deposit. Stop if either has the wrong direction or date.
- Finish the upload, then match or categorise the lines. Uploading a file is not the same as completing reconciliation.
Limits: English file, 350 KB or less, up to 1,000 lines per upload. This path is for a list of transactions (CSV, QFX or QBO). QuickBooks Online can also extract an English PDF or image statement in a separate upload flow; that is not the same as this CSV template.
Convert your PDF statement to a QuickBooks CSV
Only have a PDF? Open the CSV converter, drop the statement, confirm the result is Reconciled, then download QuickBooks CSV (Date, Description, Amount). That is the three-column layout above. You can also download QBO (Web Connect) from the same result if you would rather upload a .qbo file. CSVLedger does not convert an existing CSV into .qbo.
Do not upload CSVLedger’s general CSV (the one with Debit, Credit, Balance and Check columns) unless you first remove the extra columns. Wave and some other tools also reject files with extra columns; QuickBooks Online expects only the three or four transaction fields.
Convert your PDF statement to a QuickBooks CSV Or create a .qbo file
Create a free account See plans
Conversion runs in your browser; the statement is not uploaded to CSVLedger. Free: 10 pages per day per browser. A balance check helps spot extraction issues; it does not replace your review or QuickBooks reconciliation.
Related guides
- QuickBooks Online CSV format: 3 columns vs 4 columns (mapping detail)
- How to import a CSV into QuickBooks Online
- Fix QuickBooks CSV date format errors
- Import a bank statement into QuickBooks Online
- Bank statement to QuickBooks: Online vs Desktop
- Xero bank statement CSV template
- Citi statement formats · Discover statement formats
Sources and scope
Based on Intuit’s public help articles updated August 24, 2026 and fetched November 10, 2026. Menu names and limits can change; follow Intuit’s current help if your screen differs. Examples are fictional. These instructions are documentation-based, not a claim of a completed live import test on this date. CSVLedger is not affiliated with Intuit or QuickBooks.
- Intuit: Format CSV files in Excel to get bank transactions into QuickBooks (updated August 24, 2026; checked November 10, 2026)
- Intuit: Manually upload transactions into QuickBooks Online (updated August 24, 2026; checked November 10, 2026)
Frequently asked questions
Which template should I use, 3-column or 4-column?
Either works. Intuit’s “Format CSV files in Excel” article (updated August 24, 2026; checked November 10, 2026) accepts Date, Description, Amount (payments negative, deposits positive) or Date, Description, Credit, Debit. A signed three-column file is usually easier to audit. CSVLedger’s QuickBooks CSV export is the three-column layout.
Why is a payment in the Credit column in the four-column sample?
That follows Intuit’s published four-column example, not a universal bank naming convention. A bank export may label columns from a different perspective. Always check one known payment and one known deposit in the QuickBooks preview before you finish the upload.
Can I keep a Balance column in the upload file?
Keep balances in your source copy for checking. The import copy should have only the three or four transaction columns Intuit documents. Leave any Amount, Credit or Debit cell that would be zero blank.
Does CSVLedger convert a CSV into a .qbo file?
No. CSVLedger converts PDF statements. It can export a three-column QuickBooks CSV or a Web Connect .qbo file from a PDF, but it does not turn an existing CSV into .qbo. If you already have a CSV, upload it to QuickBooks Online as CSV (or use your bank’s own .qbo download when you need Web Connect).
What are the upload limits?
Intuit’s transaction-list guidelines (same August 24, 2026 update) say the file must be in English, 350 KB or less, and up to 1,000 transaction lines per upload. Split longer periods into smaller, non-overlapping batches.