QuickBooks CSV Import Template: Free Download + Format Rules
No account needed for your first conversions. We never store your bank login.
Short answer: QuickBooks Online accepts a bank-transaction CSV in one of two layouts: a 3-column file (Date, Description, Amount) or a 4-column file (Date, Description, Credit, Debit). The file must be in English, 350 KB or smaller, and 1,000 rows or fewer per upload, with every date in one consistent format. Intuit publishes no official template, so we made one: download the free pre-formatted 3-column and 4-column templates below, or skip the formatting entirely by converting the CSV to a .qbo file that QuickBooks reads natively.
Free QuickBooks CSV import template (ready to use)
Both files are pre-formatted to the exact layout QuickBooks Online accepts, with example rows you replace with your own transactions.
Download 3-column template (.csv)Download 4-column template (.csv)
Most CSV import problems in QuickBooks are really format problems. The data is fine, but the columns, headers, dates, or amount signs do not match what QuickBooks expects, so the upload fails or posts garbage. This guide lays out the exact CSV template QuickBooks Online wants, the rules that trip people up, and how to avoid the formatting entirely by handing QuickBooks a file it already understands.
One quick clarification first. When people search for the QuickBooks Import Excel and CSV Toolkit, that tool is for importing lists like customers, vendors, and items into QuickBooks Desktop. It does not import bank or credit card transactions. This page is about the transaction CSV format used by the bank feed, which is a different thing with its own rules.
Here is the column layout QuickBooks Online expects for each of the two accepted formats, with an example row for each.
| Format | Required columns (in order) | Example row | When to use it |
|---|---|---|---|
| 3-column | Date, Description, Amount | 06/15/2026, Office Depot, -84.20 | Your export lists one signed amount per line (minus sign for money out) |
| 4-column | Date, Description, Credit, Debit | 06/15/2026, Customer deposit, 1200.00, (blank) | Your export keeps money in and money out in separate columns |
What format does QuickBooks need for a CSV import?
QuickBooks Online needs a CSV with either three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit). The file has to be in English, 350 KB or smaller, and no more than 1,000 rows. Dates must all use the same format, and amount cells should contain numbers only, with no currency symbols.
Does QuickBooks have a CSV import template I can download?
Intuit does not publish one, but you can grab the free templates above: they match the 3-column and 4-column layouts QuickBooks Online accepts, with example rows showing the date and amount formatting. Because small column or header mistakes are still easy to make when pasting in real data, many users convert the CSV to a .qbo file instead.
What is the difference between the 3-column and 4-column CSV format?
The 3-column format puts every transaction in a single Amount column, using a minus sign for money leaving the account. The 4-column format splits the value into a Credit column for money in and a Debit column for money out, leaving the unused cell blank. Pick whichever matches how your bank exported the file, and do not mix the two.
What date format should the CSV use?
Use one consistent date format across every row, with forward slashes and a four-digit year. US QuickBooks accounts expect MM/DD/YYYY, and QuickBooks asks you to confirm the date order during the upload. Avoid text month names, two-digit years, and backslashes, since any of those can make QuickBooks reject the date or read it wrong.
Does the CSV file need a header row?
A header row is optional. During the upload QuickBooks Online shows your columns and asks whether the first row is a header, so you can include one like Date, Description, Amount or leave it out. What matters more is that the columns sit in the right order and that you remove the literal word "amount" from the Credit and Debit headers.
Why won't QuickBooks import my CSV file?
The usual causes are format, not content: the wrong number of columns, an extra column QuickBooks cannot map, dates in a format it does not recognize, currency symbols or text inside amount cells, a file over 350 KB or 1,000 rows, or a stray blank row. Fixing the layout to match the 3-column or 4-column template usually clears the error.
Can QuickBooks Online import an Excel (.xlsx) file?
Not for bank transactions. The bank-feed upload accepts .csv, .qbo, .qfx, and .ofx files, but not .xlsx or .xls. If your data is in Excel, use Save As to export a .csv first, or convert the spreadsheet to a .qbo file with the Excel to QBO converter. Saving as CSV also strips the formulas and formatting that often break a direct import.
How many transactions can I import in one CSV file?
QuickBooks Online caps each CSV upload at 1,000 rows and 350 KB. If your file is larger, split it into batches, for example by month, and upload each piece separately. The full breakdown of both caps, including how to split a big export without creating duplicates at the seams, is in our guide to the QuickBooks CSV import limit. Firms that import many client files often skip the hand-splitting entirely by converting to .qbo and processing files in bulk.
What file types can QuickBooks Online import for bank transactions?
QuickBooks Online accepts four file types for a manual bank-transaction upload: CSV, QBO (Web Connect), QFX, and OFX. CSV needs the column formatting described above, while QBO, QFX, and OFX carry the dates and amounts in a fixed structure that imports without any column mapping. That structure is why converting a CSV to .qbo removes most format errors.
Where do I upload a CSV file in QuickBooks Online?
Go to Transactions, then Bank transactions. Open the Link account dropdown and choose Upload from file. Drag in your CSV, pick the account to import into, match your columns to Date, Description, and Amount or Credit and Debit, then review and import. QuickBooks shows a preview before posting so you can catch a misread column.
How do I import a CSV file into QuickBooks Enterprise?
You cannot import a bank CSV into Enterprise directly. Enterprise uses the same Bank Feeds importer as every other Desktop edition, and that reads a .qbo Web Connect file only. Convert the CSV first, then load it under Banking, Bank Feeds, Import Web Connect File. The full process is in import CSV into QuickBooks Enterprise.
Is there a CSV import template for QuickBooks Desktop transactions?
No. QuickBooks Desktop has no native CSV import for bank or credit card transactions, so there is no transaction CSV template for it. Desktop reads transactions through Web Connect, which means a .qbo file. To get CSV data into Desktop, convert the CSV to .qbo and import it through File, Utilities, Import, Web Connect Files.
How do I skip CSV formatting entirely?
Convert the CSV to a .qbo file. A .qbo (Web Connect) file stores each date and amount in a fixed machine format, so QuickBooks reads it the same way every time with no column mapping, no header questions, and no date ambiguity. You upload it the same way as a CSV, and it works in both QuickBooks Online and Desktop.
Related guides: Skip the template and convert with the CSV to QuickBooks Online converter or the CSV to QuickBooks Desktop converter. Got an Excel file? Use the Excel to QBO converter or follow the step-by-step guide to converting Excel to QBO. Compare tools on the best CSV to QBO converter roundup. For column matching see how to map CSV columns to QuickBooks, for date rules see the QuickBooks CSV date format guide, and for the full walkthrough read how to convert a CSV to QBO.
What is the correct CSV import format for QuickBooks?
QuickBooks Online accepts two layouts. The three column format is date, description, amount, with money out written as a negative number. The four column format is date, description, and then separate debit and credit columns. Headers can be named anything, because you map them during the upload, but the file must be a plain CSV, one transaction per row, with no blank rows, no merged cells, no running balance column mapped to amount, and no totals row at the bottom.
What file format does QuickBooks Desktop need instead?
QuickBooks Desktop does not import CSV bank transactions at all. Its Bank Feeds importer reads .qbo (Web Connect), .qfx and .ofx files only, so no amount of template formatting will get a CSV into a Desktop register. Convert the same CSV to a .qbo and import it through File, Utilities, Import, Web Connect Files. See QuickBooks file extensions explained for which format each edition takes.
Why does QuickBooks reject my CSV even when it matches the template?
Nearly always the dates or the amounts. QuickBooks reads 03/04/2026 as March 4 by default, so a bank exporting day first silently shifts every transaction. Amounts carrying a dollar sign, a thousands separator, or parentheses for negatives come in as text and get dropped. Large exports also hit a file size ceiling. A converted .qbo sidesteps all four, because the format carries dates and signed amounts unambiguously.
What do the QuickBooks CSV import error messages actually mean?
QuickBooks reports almost every CSV problem with one of four vague messages, and none of them name the offending row. The table below maps each message to what is really wrong and the fix that clears it. Work down it in order, because a file usually fails for the first reason on the list and then fails again for the second.
| Error message QuickBooks shows | What is actually wrong | Fix |
|---|---|---|
| Some info may be missing from your file | The column layout is not exactly 3 (Date, Description, Amount) or 4 (Date, Description, Credit, Debit) columns. An extra balance or check-number column is the usual culprit. | Delete every column except the three or four QuickBooks accepts, including trailing blank columns Excel leaves behind. |
| We can't read this file | The file is not really a CSV, is larger than 350 KB, or was saved as an Excel workbook with a .csv name. | Re-save as CSV UTF-8 and split the date range so the file stays under 350 KB and 1,000 rows. |
| The file was uploaded but no transactions appear | Every row was rejected silently, nearly always because the dates parsed as invalid. A DD/MM/YYYY export read as MM/DD/YYYY dies on any day above the 12th. | Reformat the date column to a single consistent MM/DD/YYYY and re-upload. |
| Invalid amount or the amounts import with the wrong sign | Currency symbols, thousands separators, or parentheses for negatives. QuickBooks wants a plain number, and it wants money out to be negative in a 3-column file. | Strip $ and commas, convert (45.00) to -45.00, and check the sign convention before you upload. |
What happens if I upload the wrong CSV by mistake?
Nothing posts to your books immediately. Uploaded rows land in the For review tab, so a bad file is recoverable: select the rows, exclude them, then delete them from the Excluded tab. The full recovery path, including how to undo transactions you already added, is in delete imported bank transactions in QuickBooks.
Will the Direct Connect retirement force me to import CSVs manually?
For some accounts, yes. Intuit retires Direct Connect on October 30, 2026, so QuickBooks Desktop users who lose that two-way feed will download files instead. Where a bank offers a .qbo, you import that directly; where it only offers a CSV, you convert the CSV to a .qbo and import it. Either way the same formatting rules on this page apply, so a converted file skips the manual template work. See Direct Connect vs Web Connect for the switch.
If your transactions are not in a CSV yet, fix that upstream first. You can turn a PDF bank statement into a clean CSV or Excel file, then format it for QuickBooks. When the source is a PDF rather than a spreadsheet, it is faster to convert the PDF statement straight to QBO or send a full bank statement to QuickBooks without the spreadsheet step at all.
If you would rather skip the template entirely, upload the bank's raw CSV to the CSV to QBO converter and import the .qbo it returns, or read how to manually import bank transactions into QuickBooks Online for the upload screen step by step. If the upload keeps failing, the checklist in QuickBooks CSV import not working pinpoints the exact cause, and if you are unsure whether your edition even supports it, start with can QuickBooks import CSV files.
My bank said to switch to Express Web Connect. Does that replace the CSV import?
Only if you are on QuickBooks Online. Express Web Connect is Intuit's aggregation based feed, and Intuit lists it for QuickBooks Online, Credit Karma and Quicken, not QuickBooks Desktop, whose bank feeds setup offers just Direct Connect and Web Connect. A Desktop user following that advice will not find the option. The detail is in Express Web Connect in QuickBooks Desktop and Online. Even on QuickBooks Online the feed pulls roughly 90 days on a first connect, so a CSV or converted .qbo is still how older months get in.
Should expenses be negative or positive in the QuickBooks CSV?
In a single amount column, money in is positive and money out is negative. A deposit of 1,200 is 1200 and a payment of 84.50 is -84.50. Write the minus sign in front of the number: QuickBooks does not read accounting style parentheses, so (84.50) imports as a rejected row or as a positive. Drop currency symbols too, and leave thousands separators out if you can.
Does a credit card CSV use the same import template?
The columns are the same, but the meaning of the sign flips, because a credit card is a liability rather than an asset. Card statements usually list a purchase as a positive charge and a payment as a credit, which is the reverse of what a bank export shows. Upload it to the credit card account in QuickBooks, never a bank account, then check one known purchase before you categorize anything.
What do I do if every amount imported with the wrong sign?
Exclude the whole batch instead of editing rows one at a time. In QuickBooks Online, select the transactions in the For review tab, choose Exclude, then delete them from the Excluded tab. Multiply the amount column by -1 in your spreadsheet, save, and upload again. A converted .qbo avoids the round trip entirely, because the sign is resolved when the file is built.
Reviewed July 2026 against Intuit's current QuickBooks Online CSV upload limits, its bank connectivity types and the Direct Connect retirement timeline.