Map CSV Columns to QuickBooks: 3-Column and 4-Column Setup
No account needed for your first conversions. We never store your bank login.
To map CSV columns to QuickBooks, open Bank transactions in QuickBooks Online, choose Upload from file, and on the Map CSV columns screen match QuickBooks' Date, Description, and Amount fields to the matching columns in your file. QuickBooks Online accepts two layouts: a 3-column file with Date, Description, and a single Amount, or a 4-column file with Date, Description, Credit, and Debit. Pick the layout that matches your bank export, map each field, and any extra columns are ignored.
Mapping sounds trivial, but it is where most failed imports start. Map the wrong column to Amount and every transaction lands as zero. Leave dollar signs or thousands commas in the Amount column and QuickBooks reads the value as text. Map one Amount column when your bank actually splits money in and money out across two columns, and the signs come through backwards. The fix is to get the layout and the mapping right before you upload, or to skip the manual mapping step with a converter.
| QuickBooks field | Maps from your CSV | Format that works | Common mistake |
|---|---|---|---|
| Date | Your transaction date column | MM/DD/YYYY (also MM-DD-YYYY or YYYY-MM-DD) | DD/MM/YYYY read as the wrong month |
| Description | The payee or memo column | Plain text | Mapping a reference-number column instead |
| Amount (3-column) | One signed amount column | -125.40 (no $ sign, no commas) | $ signs or commas turn the value to text |
| Credit / Debit (4-column) | Separate money-in and money-out columns | Positive numbers in each | Swapping which column is which |
What columns does QuickBooks need to import a CSV?
QuickBooks Online needs at least three columns: a Date, a Description, and an Amount. That is the 3-column format. The alternative 4-column format replaces the single Amount with separate Credit and Debit columns for money in and money out. Any other columns in your file, like balance or check number, are ignored during the mapping step.
How do I map CSV columns in QuickBooks Online?
Go to Transactions, then Bank transactions, select your account, and choose Upload from file. After you pick the CSV, the Map CSV columns screen appears. Match each QuickBooks field, Date, Description, and Amount, to the right column header from your file, confirm the date format shown, and continue to the preview before you import.
What is the difference between a 3-column and 4-column CSV in QuickBooks?
A 3-column CSV has one Amount column where deposits are positive and withdrawals are negative. A 4-column CSV splits those into a Credit column for money in and a Debit column for money out. Use whichever matches how your bank exported the file, because forcing the wrong layout is what flips the signs on every transaction.
Why are my CSV amounts importing as zero or as text in QuickBooks?
Usually the Amount column still contains dollar signs, thousands commas, or parentheses, so QuickBooks reads it as text and stores zero. Strip the $ and the commas, write negatives with a minus sign instead of parentheses, and confirm you mapped the real amount column and not a running balance or reference column.
Why does QuickBooks say my CSV columns are not valid?
QuickBooks rejects the file when the required columns are missing, mislabeled, or mapped to the wrong fields, or when it is not a true .csv. Open it in a spreadsheet, confirm you have Date, Description, and Amount (or Credit and Debit), delete blank or text rows above the data, and re-save as CSV before uploading again.
Can I map CSV columns in QuickBooks Desktop?
Not for bank transactions. QuickBooks Desktop has no Map CSV columns screen for importing bank or credit card activity; that flow exists only in QuickBooks Online. For Desktop, the supported path is a .qbo Web Connect file, so convert your CSV to .qbo first and import it under File, Utilities, Import, Web Connect Files.
What date format should the CSV use?
For US QuickBooks accounts, use MM/DD/YYYY. QuickBooks Online also accepts MM-DD-YYYY and YYYY-MM-DD, but MM/DD/YYYY is the most reliable. Avoid DD/MM/YYYY, because a date like 03/04/2026 gets read as March 4 and silently lands transactions in the wrong month without throwing an error.
Do I have to delete extra columns from my CSV?
No. QuickBooks ignores any column you do not map, so a balance, category, or check-number column will not break the import. It is still worth deleting obvious clutter and any text rows above the headers, since stray rows are a common reason the Map CSV columns screen reads the wrong line as your header row.
How do I avoid mapping CSV columns every time?
Convert the CSV to a .qbo file instead. A converter reads the Date, Description, and Amount columns automatically, with no rigid template to match and no manual mapping screen, then gives you a .qbo that QuickBooks imports as a bank feed. Use the converter at the top of this page, then import the downloaded file.
Can I import debits and credits in one CSV?
Yes. Use the 4-column format with separate Credit and Debit columns, then map Credit to money in and Debit to money out on the mapping screen. If your bank already exports a single signed Amount column, keep the 3-column format instead, because mixing both layouts in one file is what confuses the import.
Once your columns are clean, send them to the right destination: the CSV to QuickBooks Online guide walks through the upload and bank-feed match, CSV to QuickBooks Desktop covers the .qbo Web Connect route, and the Excel to QBO converter handles .xlsx workbooks. If the amounts came in backwards, the credit card CSV to QuickBooks page explains the sign flip, and the QuickBooks CSV import date format guide fixes date errors. You can also convert your CSV to QBO right here.
This guide assumes your transactions already sit in a CSV. If they are stuck in a PDF, export the PDF bank statement to a clean Excel or CSV file first so the columns line up before you map them. For vendor paperwork, you can convert any PDF table into an Excel spreadsheet or pull invoice data into Excel and CSV with the date, description, and amount fields already separated, which makes the QuickBooks mapping step far quicker.