Bank Statement CSV Format: Columns, Signs and Date Styles

Quick Answer: A bank statement CSV is a plain-text file with one transaction per line and commas between fields. Almost every one has a date, a description and either a single signed amount (negative for money out) or separate debit and credit columns; many add a running balance, a reference and a transaction type. The exact headers, sign convention and date style vary by bank and must match what your accounting software expects.

A bank CSV file is the transaction list from your account saved as comma-separated values: a header row naming the columns, then one row per transaction. It is the most widely accepted import format in personal finance and accounting software. Its weakness is that no standard fixes the columns, so two banks' CSVs for the same kind of account can look quite different.

What columns does a bank statement CSV usually have?

A small example in the single-amount style:

Date,Description,Amount,Balance
03/14/2026,"OFFICE DEPOT 1123, AUSTIN TX",-45.67,2404.51
03/15/2026,CLIENT PAYMENT ACME LTD,1250.00,3654.51

The quotation marks around the first description are there because it contains a comma. That rule, along with how to escape quotes inside a field, comes from the common CSV conventions written up in RFC 4180. Banks that ignore it produce files where descriptions spill into the amount column.

Should amounts be signed or split into debit and credit?

Both styles are legitimate, and converting between them is simple, but you must know which one you have.

Single signed amount. Money out is negative, money in positive: -45.67 and 1250.00. This is the easiest layout for formulas, since summing the column gives the net change. A few banks reverse the convention on credit card exports, showing charges as positive because they increase what you owe. Check one known purchase before importing.

Debit and credit columns. Two columns of positive numbers, with the other left blank on each row. Convert to a signed amount with =N(C2)-N(B2) where B is debit and C is credit. Watch for zeros instead of blanks, which some importers misread.

A few banks add a third style: a single positive amount plus a Type column saying DEBIT or CREDIT. Use an IF formula to apply the sign from the type.

Why do dates cause the most import errors?

Because 03/04/2026 means 4 March in the United States and 3 April in most other places, and the CSV does not say which. Common styles you will meet:

• MM/DD/YYYY, typical of US banks
• DD/MM/YYYY, typical of UK, Australian, Indian and many other banks
• YYYY-MM-DD, the unambiguous ISO style some banks and apps use
• DD-Mon-YYYY such as 14-Mar-2026, unambiguous but needs parsing

When Excel opens a CSV, it interprets dates using your computer's regional settings, so a UK-style file opened on a US machine can silently swap day and month for the first twelve days of every month. Open the CSV through Data > From Text/CSV instead, where you can set the file's date locale, or check rows with a day greater than 12 to confirm the format. Our explainer on statement date formats goes deeper.

What format do QuickBooks, Xero and Quicken expect?

Each import target has its own rules, and the bank's CSV rarely matches all of them.

QuickBooks Online. Intuit's upload article accepts a three-column file (Date, Description, Amount) or a four-column file (Date, Description, Credit, Debit), up to 350 KB and 1,000 lines. Intuit's CSV formatting tips add: keep one date format, leave blank cells instead of zeros, keep descriptions as text, and drop currency symbols. You map columns during upload, so header names need not match exactly. Our Excel template for QuickBooks import lays this out.

Xero. Xero's bank statement import maps your CSV columns to its statement fields during upload, and Xero Central offers a CSV template with matching headings. Filling in payee, description and reference, not just the amount, gives Xero's reconciliation suggestions more to match on. See the import guides on Xero Central for the current field list.

Quicken for Windows. Much stricter. Quicken's CSV import article requires columns in a fixed order (Date, Payee, FI Payee, Amount, Debit/Credit, Category, Account, then optional Tag, Memo and Chknum), dates as mm/dd/yyyy, and every required column present even when empty.

How do you download a bank CSV file?

In most online banking sites, open the account, go to its activity or transactions view, and look for a Download, Export or arrow icon. Choose CSV (sometimes labelled Excel or spreadsheet), pick a date range, and save. Things to know:

• History limits. Many banks offer CSV for only the last 90 days to two years. Older periods may exist only as PDF statements.
• Pending transactions. Some exports include pending items that later change or disappear. Exclude them if you can.
• Statement versus activity. An activity export covers whatever range you pick; it is not the same as the monthly statement and may not start at a statement opening balance.
• Mobile apps often lack the export option, so use the website.

Our bank guides list export steps for specific banks.

What other quirks turn up in bank CSV files?

Beyond signs and dates, these are the oddities that most often break an import:

• Preamble lines. Some banks put the account name, number and date range in the first few lines, above the real header row. Delete them so the header is line one.
• Summary lines at the end. Totals or a closing balance row at the bottom get imported as a transaction.
• Semicolons and decimal commas. Many European banks separate fields with semicolons and write amounts as 1.250,00. Tell the importer the delimiter, or convert the file before importing into software set up for US-style numbers.
• Thousands separators and currency symbols inside amounts, such as $1,250.00, which some importers read as text.
• Encoding. Accented payee names can turn into garbled characters if the file is saved in one encoding and read as another. UTF-8 is the safest choice when you resave.
• Leading zeros and long numbers. Reference and account numbers can lose zeros or turn into scientific notation when Excel opens the file. Keep the original CSV untouched and work on a copy.

What if your bank gives you only PDF statements?

That is common for older periods, closed accounts and some business accounts. You then have to build the CSV from the PDF. QuickBankConvert produces one in the single-signed-amount style, with date, description, category, amount and the running balance where the statement prints one, and it also writes a Xero-ready CSV on paid plans. The PDF to CSV page shows the columns. For when to use a CSV and when a spreadsheet makes more sense, see our CSV vs Excel comparison.

Related guides

• CSV or Excel for statement data
• A QuickBooks-ready Excel layout
• Reading statement date formats correctly
• Building a CSV from a statement PDF