Home › Guides › Xero bank statement CSV template

Xero bank statement CSV template

A Xero bank statement CSV needs Date and Amount in one file, with income and expenses in the same Amount column (income positive, expenses negative). Xero’s own template marks those fields as *Date and *Amount and also includes Payee, Description, Reference and Cheque Number. Download the sample file below, or convert a PDF statement to that layout in your browser. This is a manual statement import, not a precoded file with account codes or tax rates.

Updated November 10, 2026

Download a sample Xero statement CSV

This fictional three-row file uses the same headings as Xero’s statement import template, including the asterisks that mark mandatory fields, plus Cheque Number. Dates are DD/MM/YYYY (for example 15/10/2026), which is one of the formats Xero lists. When you import, select that date format if Xero asks. The rows are made up; they are not a real account.

Download the sample Xero CSV template

*Date,*Amount,Payee,Description,Reference,Cheque Number
15/10/2026,-84.60,Stationery supplier,Office supplies,Receipt A,
16/10/2026,1200.00,Example client,Invoice payment,Invoice B,
18/10/2026,-250.00,Example landlord,Office rent,Cheque 1042,1042

Only *Date and *Amount are required to create statement lines. If your bank already offers a suitable OFX, QFX, QIF or QuickBooks (QBO) download, Xero can import those files; you do not need to build a CSV only for its own sake.

What belongs in each column?

ColumnPurposeCommon mistake
*DateStatement transaction date in one supported format, used consistently in every rowMixing day-first and month-first dates in the same file
*AmountOne signed column: income positive, expenses negative (minus sign or brackets)Leaving separate Debit and Credit columns, or using a comma as the decimal separator
PayeeWho paid or was paid. Match an existing Xero contact name exactly when you canSlight spelling differences that create duplicate contacts
DescriptionTransaction detail; after import this appears under Particulars in the Bank statements tabPutting a running balance in this column
ReferenceA bank or business referenceTreating it as a required account code
Cheque NumberThe cheque number when there is oneLeaving a cheque number only in the description when you want it in its own field

Xero also lets you add two optional columns: Analysis code (the bank’s analysis code, which is not the chart-of-accounts code) and Transaction Type (shown on the reconciliation screen). The sample file omits them because they are not required to create statement lines. Do not use a comma as the decimal separator. Preserve commas inside text with proper CSV quoting.

Supported date formats listed in the same Xero article include DD/MM/YYYY, MM/DD/YYYY, YYYY/MM/DD, two-digit-year variants, DD/MMM/YYYY, and dates with spaces, hyphens or dots. Use one format for the whole file. Xero says you cannot import a CSV with more than 100,000 rows.

Statement template versus a precoded workflow

This is a manual bank statement file. It creates unreconciled statement lines. It is not a promise that transactions arrive already posted to your chart of accounts.

Xero also describes a separate precoded CSV import, in which each line can carry an account code and tax rate so Xero can code the line as it is imported. We were not able to retrieve the current official “precoded” help article as a fully rendered page on November 10, 2026 (Xero Central loads in the browser), so this page does not invent those column names or rules. If you need a precoded file, download Xero’s own precoded template from your organisation and confirm account codes and tax-rate display names there.

CSVLedger’s Xero CSV export writes *Date, *Amount, Payee, Description, Reference and Cheque Number — the statement template, not a precoded file. It does not choose tax rates or account codes. You still reconcile (or finish coding) in Xero.

Clean the file, then import

  1. Keep a separate file for each bank account.
  2. Put unique column headings in row 1. Xero can map a file without headings, but headings make mapping easier.
  3. Remove opening and closing balance columns, the bank account number, and empty rows, as Xero instructs. Keep the original statement for balance checks.
  4. In Xero, go to Accounting → Bank accounts, open the matching account’s menu, and choose Import a Statement. You need the administrator role or a standard user with bank accounts access.
  5. Map the columns, confirm the date format, inspect the preview, then finish the import and reconcile the lines.

Menu labels and regional template headings can vary (Xero notes that the in-product template language follows the browser language, defaulting to New Zealand English if it cannot tell). Follow the current official article if your screen differs.

Convert your PDF statement to Xero CSV

Only have a PDF statement? CSVLedger converts the PDF in your browser (the file is not uploaded), checks opening balance + credits − debits against the printed closing balance, and exports a Xero statement CSV with the columns above. You pick the date format (MM/DD/YYYY, DD/MM/YYYY or YYYY-MM-DD) before you download. It does not create a precoded file, and it does not turn an existing CSV into a Xero file.

Convert your PDF statement to Xero CSV

Create a free account See plans

Free: 10 pages per day in this browser, no account. An account uses only your email and a one-time code; paid plans attach to that account. A balance check helps spot extraction issues; it does not replace your review or Xero reconciliation.

Bank-format pages that often lead here

If you still have a bank login, check whether a native download already exists before converting a PDF. These pages are sourced from each bank’s own help:

Related guides

Sources and scope

Based on Xero Central’s article “Import a bank statement in CSV format”, checked November 10, 2026. That article is the official source for the statement-template columns, sign rules, date formats, 100,000-row limit, and the Analysis-code distinction. We could not load a fully rendered official precoded-import article on that date, so precoded column requirements are not stated as fact here. Examples are fictional. These instructions are documentation-based, not a claim that we completed a live import into a Xero organisation on this date. CSVLedger is not affiliated with Xero Limited.

Frequently asked questions

Are Payee and Description required in a Xero statement CSV?

No. Xero’s “Import a bank statement in CSV format” article says only Date and Amount are required to create bank statement lines. Payee, Description, Reference and Cheque number make reconciliation easier. Mandatory fields are marked with an asterisk in Xero’s own template (*Date, *Amount).

Can Xero use separate Debit and Credit columns?

The documented statement CSV uses one Amount column for both income and expenses: income positive, expenses negative (a minus sign or brackets, for example -30.00 or (30.00)). Prepare that signed column before importing. Do not use a comma as the decimal separator.

Is this the same as a precoded Xero import?

No. The file on this page is a manual bank-statement template: it creates statement lines for you to reconcile. A precoded import is a separate Xero workflow that also carries account codes and tax rates so lines can be coded as they import. CSVLedger’s Xero CSV export matches the statement template (*Date, *Amount, Payee, Description, Reference, Cheque Number). It does not add account codes or tax rates, and it does not choose categories for you.

Is Analysis code the chart-of-accounts code?

No. Xero states that a bank Analysis code (an optional extra column you can add) is different from the account code a transaction is reconciled to in Xero.

Does CSVLedger convert an existing CSV into a Xero file?

No. CSVLedger converts PDF bank and credit card statements in your browser. It does not rewrite an existing bank CSV. If you already have a CSV, shape it to the template below, or if your bank offers OFX, QIF, QBO or QFX, Xero can import those formats too.