The QuickBooks Online CSV format for bank upload is one row per transaction in either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit). Dates follow one consistent pattern, payments are negative in the 3-column layout, zero cells are left blank, and the file stays in English, under 350 KB and within 1,000 lines.
Which columns does a QuickBooks Online bank CSV require?
A QuickBooks Online bank CSV requires a date, a description and the money, either as one signed Amount column or as separate Credit and Debit columns. Intuit's article Manually upload transactions into QuickBooks Online says each file needs either those 3 columns or those 4.
Intuit's article Common errors for importing bank transactions using CSV puts it more bluntly: QuickBooks requires only Date, Description and Amount. It advises deleting columns you do not need and renaming the remaining headers to match the QuickBooks field titles. A bank download often carries more: a running balance, a check number, a transaction type code, a category the bank guessed. Those extra columns are the first thing to remove.
The table below covers each column, the format Intuit's articles ask for, and what goes wrong when it is off. The "what goes wrong" column quotes or paraphrases the Intuit articles cited in this post.
| Column | Accepted format | What goes wrong when it is off |
|---|---|---|
| Date | One pattern for every row; Intuit recommends dd/mm/yyyy | Dates that do not match the format chosen during mapping are listed by Intuit as a formatting error |
| Description | Text; Intuit says to correct cells where the description shows numbers | Special characters are listed by Intuit as a formatting problem |
| Amount (3-column) | Negative for money out, positive for money in, no currency symbols or commas | Currency symbols and commas are a listed formatting error; an amount of 12 or more digits triggers "The uploaded file contains invalid transaction amount information" |
| Credit and Debit (4-column) | Headers read only "Credit" and "Debit"; each row has an amount in one column, the other left blank | A file with only money-out rows may fail to upload |
Which of the two layouts to use, and how to tell which one your bank's download already is, has its own post: what the 3-column QuickBooks CSV layout looks like compares them side by side.
The header names matter more than their order. Intuit's articles ask for the headers to match the field names. Intuit's Format CSV files in Excel to get bank transactions into QuickBooks gives one specific case: if a bank labels its columns "Credit amount" and "Debit amount," remove the word "amount" so they read Credit and Debit.
Date formats QuickBooks Online bank uploads accept
QuickBooks Online bank uploads need every date in the file to follow the same pattern. Intuit's manual upload article recommends dd/mm/yyyy. The mapping screen asks which date format the file uses, so the real rule is consistency: whatever pattern you choose there, every row must match it.
Mixed dates are the usual failure. A file built by pasting two downloads together can carry 03/04/2026 in one block and 2026-03-04 in another. QuickBooks reads them against one pattern, so one block comes through wrong or not at all. Intuit's common errors article says to make sure dates match the format chosen during mapping, and suggests setting the date column's number format to Short Date in Excel.
Day names are another trap. Some banks print dates such as "20/11/2018 TUE." Intuit's formatting article says to split the day into its own column with Excel's Data, Text to Columns, using Delimited, a Space delimiter and General as the column data format. Microsoft's article Split text into different columns with the Convert Text to Columns Wizard has the general steps. Delete the day column afterward.
Ambiguous dates deserve a check. Under day-first and month-first patterns, 03/04/2026 is either 3 April or 4 March. Pick a row with a day above 12, such as 03/27/2026, and confirm it parses. A date like that cannot be read both ways, so it tells you which pattern the file really uses.
Excel can change dates on open. Microsoft's article Import or export text (.txt or .csv) files says Excel uses its current default data format settings to interpret each column when it opens a text file. If a bank file is in a different date order than Excel's default, open it through the import wizard and set the date column's format by hand.
How should amounts be signed in a QuickBooks bank CSV?
Amounts in a QuickBooks bank CSV are signed by layout. In the 3-column layout, Intuit's formatting article shows payments as negative and deposits as positive in one Amount column. In the 4-column layout, each amount goes in either the Credit or the Debit column, not both, and the other cell stays blank.
Three conversions come up often:
- Parentheses. Accounting formats show money out as (86.40). Convert that to -86.40 so the sign is a minus sign. Microsoft's Top ten ways to clean your data covers fixing numbers stored as text and adjusting negative sign formatting.
- Trailing signs or DR/CR text. Some exports print 86.40- or 86.40 DR. Move the sign to the front and drop the letters.
- Currency formatting. Intuit's common errors article says to keep the amount column simple: right-click it, choose Format Cells, and change the category from Currency to General, which removes symbols and thousands commas.
Zeros are their own rule. Intuit's formatting article says to remove zeros and leave those cells blank. In a 4-column file, a row with 86.40 in Debit and 0.00 in Credit should have an empty Credit cell instead.
Card accounts can arrive with the signs reversed. Intuit's formatting article warns that credit card files may show deposits as negative amounts. If the preview shows payments as deposits, Intuit's video guide How to upload transactions manually says to select Reverse all values. The flipped-sign case gets a full section in the post on 3- and 4-column layouts.
Header rows, blank lines and other QuickBooks CSV file rules
QuickBooks CSV file rules cover everything around the transactions: one header row, nothing above it, one transaction per line, English text, a size under 350 KB and no more than 1,000 lines. Intuit's manual upload article sets the size and line limits. Breaking any of these rules usually stops the upload before mapping.
Go through the file from top to bottom:
- Title lines. Bank exports often start with the account name, the date range and a blank line before the header. Delete everything above the header row.
- One header row. The header names each column once. A file built from several downloads may repeat the header mid-file; remove the repeats.
- One transaction per line. Intuit's manual upload article counts the 1,000-line limit as one transaction per line. Delete blank lines, subtotal lines, and the beginning and ending balance lines a statement prints.
- Size. Keep the file at 350 KB or less. The article says to shorten the date range for large uploads.
- Language. The upload file must be in English.
- Saved as CSV. On a Mac, Intuit's formatting article says to save the file as a Windows CSV.
- A blank-sheet copy. For a file that still fails on formatting, Intuit's common errors article suggests copying its contents straight into a blank spreadsheet.
Microsoft's import and export article also warns that saving as CSV saves only the current worksheet and that some Excel features are lost. That is fine for a bank file, which should be one plain sheet anyway. The post on which rows to delete from a CSV before QuickBooks sees it has the full cleanup order.
QuickBooks bank CSV edge cases: pending items, foreign currency, split lines
QuickBooks bank CSV edge cases are rows that look like transactions but should not go into the file as they are. Pending items have not posted yet, foreign-currency rows can carry two amounts, and split lines break one bank transaction into several rows. Each one needs a decision before upload, not after.
Pending items. A download taken from online banking can include pending card transactions. A pending row has not posted to the account, so it will not appear on the statement and cannot be checked against one. Leave pending rows out and pick them up in the next file, once they show as posted.
Foreign currency. A purchase made abroad may show the original amount in euros or pounds next to the dollar amount posted to the account. Keep only the posted amount, the one that moved the account balance, and delete the original-currency column. A foreign-currency fee the bank charged as a separate line is its own transaction and stays in.
Split lines. Some exports break one deposit into its parts, such as several checks on one deposit slip. The statement shows one deposit, so the file should too. Keep one row per transaction as the bank posted it, and do the categorizing in QuickBooks during review.
Very large amounts. Intuit's article Fix bank upload errors says a transaction with 12 or more digits cannot upload. Remove it from the file and enter it by hand.
Money out only. A 4-column file with no deposits at all may fail. Intuit's common errors article suggests adding one line with a positive amount and unticking it on the final screen.
A sample QuickBooks Online bank CSV you can copy
A sample QuickBooks Online bank CSV is the quickest way to test a client's file: build your file to the same shape, upload it, and compare. Below are the same five example transactions in both layouts. The dates use month, day, year; set the mapping screen's date format to match, or change them to Intuit's recommended day-first pattern.
The 3-column version, with one signed Amount column. All names and amounts are examples.
Date,Description,Amount
04/01/2026,Deposit Ridgeline Studio,3850.00
04/03/2026,Card purchase Example Hardware,-142.75
04/10/2026,ACH Example Utilities,-218.30
04/16/2026,Transfer from savings,1000.00
04/28/2026,Monthly service fee,-12.00
The 4-column version of the same five transactions. Each row has one amount, and the other cell is empty. The columns follow the placement in Intuit's own 4-column example, which puts a payment under Credit and a deposit under Debit. Banks label these columns differently, so check the signs in the upload preview and use Reverse all values if they come out backwards.
Date,Description,Credit,Debit
04/01/2026,Deposit Ridgeline Studio,,3850.00
04/03/2026,Card purchase Example Hardware,142.75,
04/10/2026,ACH Example Utilities,218.30,
04/16/2026,Transfer from savings,,1000.00
04/28/2026,Monthly service fee,12.00,
Both files net to the same change in the account: 4,850.00 in, 373.05 out, a net increase of 4,476.95. Checking that net figure against the statement's opening and closing balances after upload is a fast way to confirm nothing was dropped or flipped.
Building this file from a client's PDF statements is the slow part. Schema CPA reads checking, savings and credit card statements and exports the transactions to Excel or CSV, which the firm then shapes to one of these layouts and uploads itself. The hours calculator on the homepage shows what that manual entry costs today. For getting statement data into a spreadsheet in the first place, see the bank statements to Excel category.
If a file built to this shape still fails, the cause is almost always in the data rather than the layout. The post on cleaning a CSV before importing it to QuickBooks goes through the fixes in order.