Free QuickBooks Online CSV import template for bank transactions (3- and 4-column)
Looking for a CSV template to upload bank transactions into QuickBooks Online? Intuit doesn't offer one to download: its help pages describe two layouts and leave the file to you. Here are both as free CSV files with no sign-up, already filled with a fictional month of business checking so you can test an upload and know exactly what should come in. Below, each template line by line, the rules that make an upload fail, and how to check the result.
Short answer: download the 3-column template (Date,Description,Amount, money out negative) or the 4-column template (Date,Description,Credit,Debit, one amount per row, the other cell blank). Both hold the same 31 fictional transactions: 11 deposits totalling 29,597.43, 20 payments totalling 28,575.27, net +1,022.16. Keep the header row, replace rows 2 to 32 with your own transactions, save as CSV and upload it from Bank transactions → Link account → Upload from file. Try the sample in a test company first.
See a PDF statement turned into this exact file
Open the fictional bank statement PDF in Utilly's statement converter. The results page shows all 31 transactions, confirms they add up to the statement's ending balance, and gives you the QuickBooks Online CSV (the 3-column template above) plus .QBO, Excel and Xero files. Free for the sample, no sign-up.
- Does QuickBooks have a CSV import template?
- The two templates
- The 3-column template, line by line
- The 4-column template and the Credit/Debit question
- Rules that make an upload fail
- Filling the template in Excel or Google Sheets
- Uploading the file to QuickBooks Online
- Credit card accounts
- Checking the upload against the known totals
- QuickBooks Desktop and other software
- From a PDF statement or a messy bank export
- FAQ
1. Does QuickBooks have a CSV import template?
Not as a download. Asked for a CSV template in the QuickBooks Community, Intuit's answer was no: QuickBooks expects the file to come from your bank, and it accepts it in one of two layouts. Intuit's help article: "You can upload CSVs with either the 3-column or 4-column format to QuickBooks." It also warns that "each bank formats CSV files differently", so many bank exports need cleaning before they'll upload. That's what these templates are for: a file already in Intuit's layout that you can copy your rows into, or compare a bank export against.
These are for bank and credit card transactions (the Upload from file screen). Bills, invoices, customers and the chart of accounts use different templates under Settings → Import data; for bills, see importing bills into QuickBooks Online from a CSV, and for accounts, our chart of accounts template with a QuickBooks import file.
2. The two templates
Both are written by the same code that makes Utilly's QuickBooks Online CSV for customers, run on the fictional statement explained on sample bank statement PDF, so they're exactly what a real conversion produces.
| File | Columns | Use it when | Known totals |
|---|---|---|---|
| 3-column template | Date, Description, Amount | You have one amount per row with a sign. The simplest layout, and there's no question about which column means what | 31 rows, +29,597.43 / −28,575.27, net +1,022.16 |
| 4-column template | Date, Description, Credit, Debit | Your bank export has money in and money out in separate columns | 31 rows, 29,597.43 in Credit, 28,575.27 in Debit |
| Credit card version | Date, Description, Amount | Testing a credit card account upload | 21 rows, net −397.76 |
Both bank files are 1.5 KB, well under Intuit's 350 KB limit, with Windows line endings and plain ASCII text. The same month also comes as .QBO, .IIF, Xero CSV and more on sample bank statement files.
3. The 3-column template, line by line
The start and the end of the file as plain text:
Date,Description,Amount
09/01/2026,ACH DEBIT GUSTO PAYROLL 0912,-6420.18
09/01/2026,STRIPE TRANSFER ST-K2M8Q4,3184.27
09/02/2026,CHECK 2041,-1850.00
09/02/2026,ACH DEBIT AUSTIN ENERGY UTIL,-412.66
…
09/30/2026,MONTHLY SERVICE FEE,-15.00
09/30/2026,INTEREST PAYMENT,3.21- Row 1 is the header, with exactly these three names. Nothing goes above it: no bank name, account number or statement period.
- Money out is negative, money in is positive. Payroll is −6420.18; the Stripe deposit is 3184.27. This is Intuit's own example: a payment of −100.00 and a deposit of 200.00.
- Amounts are plain numbers: no $ sign, no thousands comma, no parentheses for negatives, two decimals.
- One date format for every row, here MM/DD/YYYY. You tell QuickBooks which format it is when you map the columns.
- No Balance column and no zero rows. A running balance or a $0.00 line has to come out before you upload.
- Rows are in date order, one transaction per line, with no blank lines and no totals line at the bottom.
4. The 4-column template and the Credit/Debit question
Date,Description,Credit,Debit
09/01/2026,ACH DEBIT GUSTO PAYROLL 0912,,6420.18
09/01/2026,STRIPE TRANSFER ST-K2M8Q4,3184.27,
09/02/2026,CHECK 2041,,1850.00
09/02/2026,ACH DEBIT AUSTIN ENERGY UTIL,,412.66
…
09/30/2026,MONTHLY SERVICE FEE,,15.00
09/30/2026,INTEREST PAYMENT,3.21,- Each amount goes in one column only, as a positive number. The other cell is empty: that's the
,,and the trailing comma. Intuit: remove any zeros and leave those cells blank. A 0.00 in the unused cell is one of the most common reasons a 4-column file won't upload. - The headers are just Credit and Debit. Intuit says to remove the word "amount" from them, so "Credit Amount" and "Debit Amount" need renaming.
- In this template Credit is money in and Debit is money out, the way most bank exports label them and the way Utilly's QuickBooks Online CSV checker reads them.
The catch: Intuit's own 4-column example puts its "Example of a payment" under Credit and its deposit under Debit, the opposite way round. The column names don't decide the sign on their own: when you upload, you match each column in the file to a field in QuickBooks. So check the first rows on the review screen. Gusto payroll (6,420.18) should show as money spent and the Stripe transfer (3,184.27) as money received. If they're the other way round, go back and swap the two columns at the mapping step. If you'd rather not think about it at all, use the 3-column template.
5. Rules that make an upload fail
From Intuit's help articles on formatting and uploading CSV files (links at the end):
| Rule | What goes wrong | Fix |
|---|---|---|
| 3 or 4 columns | Balance, check number, category or card number columns left in | Delete every other column |
| No zeros | 0 or 0.00 in Amount, Credit or Debit | Leave the cell blank |
| Header names | "Credit Amount", "Debit Amount" | Rename to Credit and Debit |
| One date format | Day-first and month-first mixed, or a day of the week in the date (Intuit's example: 20/11/2018 TUE) | Make every date the same format; split off the weekday with Data → Text to Columns |
| Descriptions | A description that's just a number; special characters | Correct the row; remove characters like ! @ # $ % & * from descriptions |
| Size | Over 350 KB, or over 1,000 transactions in one upload | Split the file into shorter date ranges |
| Language and Mac files | Non-English text; a CSV saved in the Mac format | English only; on a Mac, save as a Windows CSV |
Don't want to check these by hand? Drop the file on the free QuickBooks Online CSV checker. It runs in your browser, so the file isn't uploaded anywhere, tests every rule above, and gives you a cleaned 3-column copy. Both templates pass it with no issues.
6. Filling the template in Excel or Google Sheets
- Open the template and delete rows 2 to 32 (the fictional transactions). Keep row 1.
- Paste your transactions under the header: date in A, description in B, and either one signed amount in C (3-column) or money in under Credit and money out under Debit (4-column).
- Two columns but you want the 3-column layout? With money in in C and money out in D,
=C2-D2in a new column gives the signed amount; copy it down, paste it as values, then delete the two originals. Blank cells count as zero in the formula, so it works on rows that only have one amount. - Fix the dates. If some dates are text and some are real dates, set the column to one format (Excel: Format Cells → Date, or a Custom format of mm/dd/yyyy) before saving.
- Delete zero rows, totals lines and blank lines.
- Save as CSV. Excel on Windows: File → Save As → CSV (Comma delimited). Excel on a Mac: Windows Comma Separated (.csv). Google Sheets: File → Download → Comma-separated values.
Excel can quietly change a CSV when it opens one, turning dates into day-first on a computer set that way or long reference numbers into 1.23E+11. Opening a bank CSV in Excel without breaking it covers the safe way to open one.
7. Uploading the file to QuickBooks Online
Intuit's steps for uploading a transaction list (CSV, .txt, .qbo or .ofx):
- Go to All apps, then Accounting, then Bank transactions.
- If you see a tile for the account you want to upload into, select it.
- Select the Link account ▼ dropdown, then Upload from file. If the account isn't connected to online banking, select Upload from file or upload transactions manually.
- Drag and drop or select the CSV, then select Continue.
- Choose the QuickBooks account to upload into (or add a new bank account), then Continue.
- Match the columns in the file to the fields in QuickBooks, pick the date format that matches the file, then Continue.
- Select the transactions to import, then Continue, Yes and Done.
Every way in, including .QBO files, PDF statements and filling months before the bank feed started, is in how to import bank transactions into QuickBooks Online.
The transactions then wait in the For review tab to be categorized or matched; nothing posts to the books until you accept them. Prefer to upload the PDF itself? QuickBooks Online can now read PDF statements too, and uploading a PDF bank statement to QuickBooks Online compares that with a CSV.
8. Credit card accounts
For a credit card account, use the same 3-column layout with charges negative and payments and returns positive, and choose the credit card account, not a bank account, when you upload. Intuit's tip for card CSVs: they "may display transactions in reverse order", and payments can look negative because they reduce the balance. The sample credit card CSV has 21 rows: 19 charges totalling 1,939.94 and 2 credits (a 1,500.00 payment and a 42.18 return) totalling 1,542.18, a net of −397.76. If your card's own CSV has purchases as positive numbers, that's normal (it's written from the bank's side); the credit card statement Excel template explains the sign flip. For QuickBooks Desktop and .QBO card files, see importing credit card transactions into QuickBooks.
9. Checking the upload against the known totals
The point of a filled-in template is that you know what should come in. After uploading the sample into a test company, compare the For review tab with this:
| Check | Should be | If it's wrong |
|---|---|---|
| Transactions | 31 | 62 means the file went in twice; fewer means rows were skipped at the review step or failed to read |
| Money received | 29,597.43 (11) | A different total means rows were skipped or a description pushed amounts into the wrong column |
| Money spent | 28,575.27 (20) | Same as above |
| Net change | +1,022.16 | −1,022.16 means every sign is flipped: the Credit and Debit columns were mapped the wrong way round |
An upload brings in transactions, not the opening balance. The statement these rows come from runs from 12,418.36 to 13,440.52, and 12,418.36 + 1,022.16 = 13,440.52. Uploaded it twice? Duplicate transactions after an import covers finding and removing them. If reconciling afterwards doesn't reach 0.00, see QuickBooks reconciliation not matching.
The transactions are fictional (Example Community Bank and Sample Customer LLC don't exist; the statement they come from says SAMPLE STATEMENT, FICTIONAL DATA FOR DEMONSTRATION ONLY). Upload them into a test or sample company, never into books you file from, and replace every row before using the template for real.
10. QuickBooks Desktop and other software
- QuickBooks Desktop doesn't use this upload screen. The usual routes are a .QBO Web Connect file or an .IIF, and both can be made from a CSV in this layout with CSV to QBO or CSV to IIF. A ready-made Desktop file is on sample IIF file, and the Desktop routes are compared in importing a CSV into QuickBooks Desktop.
- Xero uses its own statement template (*Date, *Amount, Payee, Description, Reference), filled and blank on Xero CSV import template; CSV to Xero rewrites a QuickBooks CSV into it.
- Wave takes Date, Description, Amount too, but with card purchases positive; see bank statement to Wave.
11. From a PDF statement or a messy bank export
Have a bank CSV with extra columns, a summary block on top or Debit/Credit labels? CSV to QBO reads it, shows a preview, and writes a clean file; the CSV checker gives you the 3-column version for free. Only have PDF statements, or months your bank no longer lets you download? Upload the PDF to bank statement to QuickBooks: the preview is free with no sign-up and checks that the rows add up to the statement's ending balance before you download the QuickBooks Online CSV or a .QBO; downloading uses 1 credit ($9 for 5, no subscription) or Pro at $19 a month.
Get your own statement into this template
PDF statements, downloaded or scanned, get a free preview with the balance check, no sign-up. CSV and Excel exports are free up to 100 rows. Files are processed in memory and not stored.
Sources: Intuit, Format CSV files in Excel to get bank transactions into QuickBooks (updated 8/24/2026), quickbooks.intuit.com; Manually upload transactions into QuickBooks Online, quickbooks.intuit.com; QuickBooks Community, Can I have a csv template to manually import bank statement, quickbooks.intuit.com/community. Checked November 1, 2026. Intuit updates these pages; if a screen differs, follow the current article.
FAQ
Does QuickBooks Online have a CSV template for bank transactions?
Not as a download. Intuit's help describes two layouts it accepts, 3-column (Date, Description, Amount) and 4-column (Date, Description, Credit, Debit), and expects the file to come from your bank. The templates on this page are both layouts as ready-made CSV files.
What is the 3-column format for QuickBooks?
A header row of Date, Description, Amount, then one transaction per row with money out as a negative number and money in as a positive one, for example -6420.18 for a payroll payment and 3184.27 for a deposit. No Balance column, no zeros, plain numbers and one date format.
What is the 4-column format for QuickBooks?
A header row of Date, Description, Credit, Debit, with each amount as a positive number in only one of the two columns and the other cell left blank, not 0. When you upload, you match each column to a field in QuickBooks, so check on the review screen that deposits show as money received.
Why does my CSV fail to upload to QuickBooks Online?
The usual causes are extra columns such as a running balance, zeros in the Amount, Credit or Debit cells, the word amount in the Credit or Debit header, mixed date formats or a day of the week in the date, a file over 350 KB or 1,000 transactions, and text above the header row. The free QuickBooks Online CSV checker tests a file for all of them in your browser.
Can I import a CSV into QuickBooks Desktop with this template?
Not through this screen; it's the QuickBooks Online upload. QuickBooks Desktop usually takes bank transactions as a .QBO Web Connect file or an .IIF, and both can be made from a CSV in this layout with a CSV to QBO or CSV to IIF converter.
How do I know the upload worked?
Upload the filled-in sample into a test company first. It should bring in 31 transactions: 11 deposits totalling 29,597.43 and 20 payments totalling 28,575.27, a net change of +1,022.16. A net of -1,022.16 means the Credit and Debit columns were mapped the wrong way round; 62 transactions means the file went in twice.
Related guides
- How to import bank transactions into QuickBooks Online (CSV, Excel, QBO or PDF)
- How to import credit card transactions into QuickBooks Online and Desktop (CSV, Excel or PDF)
- Free sample bank statement CSV (fictional, with known totals)
- How to upload a PDF bank statement to QuickBooks Online (and check nothing was missed)
- Free sample bank statement files: PDF, CSV, QBO, IIF, QIF and Xero CSV
- Duplicate transactions in QuickBooks after an import: find them, remove them, and stop them coming back
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.
