QuickBooks CSV Import Template and Format Requirements
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. There is no official downloadable template, so the safer route for most people is to convert the CSV to a .qbo file that QuickBooks reads natively and skip the formatting work entirely.
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?
No. Intuit does not publish a downloadable CSV template file. You build the file yourself to match the 3-column or 4-column layout, or you export it from your bank and clean it up. Because there is no official template to copy, small column or header mistakes are common, which is why 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. 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. Firms that import many client files often skip this limit by converting to .qbo and processing files in bulk rather than hand-splitting every spreadsheet.
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.
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. 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.
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.