Rename CSV Headers for Xero Bank Import

How to rename csv headers to match xero bank import format

Step 1
Check Xero's required CSV column names — In Xero, go to Accounting → Bank Accounts → Import a Statement and note the required headers.
Step 2
Export your bank statement as CSV — Download the statement export from your online banking portal.
Step 3
Drop the CSV into Header Rename — Rename each header to its Xero equivalent: 'Transaction Date' → 'Date', 'Net Amount' → 'Amount'.
Step 4
Import into Xero — Upload the renamed CSV through Xero's Import a Statement feature.

What exact headers does Xero require?+

Xero expects at minimum: Date and Amount. Optional columns: Payee, Description, Reference, Cheque Number.

Will renaming headers affect my transaction reconciliation?+

No. Only the column names change. Dates, amounts, and payee names are untouched.

Does this work for Xero's manual import and bank feeds?+

It works for the manual CSV import. Bank feeds connect via Open Banking and do not use CSV files.

Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.

How to rename csv headers to match xero bank import format

Step 1

Check Xero's required CSV column names — In Xero, go to Accounting → Bank Accounts → Import a Statement and note the required headers.

Step 2

Export your bank statement as CSV — Download the statement export from your online banking portal.

Step 3

Drop the CSV into Header Rename — Rename each header to its Xero equivalent: 'Transaction Date' → 'Date', 'Net Amount' → 'Amount'.

Step 4

Import into Xero — Upload the renamed CSV through Xero's Import a Statement feature.

Frequently asked questions