Cosmovex/tools

Convert a bank statement PDF to a CSV for Xero bank statement import

Xero import CSV with Statement to Spreadsheet

This page opens with the Xero layout: *Date, *Amount, Payee, Description and Reference, with a single signed amount where money out is negative. It follows the column headings of Xero's bank statement CSV template. Choose the date format your Xero organisation uses before you download.

  1. Drop your statement PDF on the tool. It is read in your browser and never uploaded.
  2. Check the preview and the balance check, and tick or fix any amber rows.
  3. Leave Columns on the Xero layout and set Dates to the format your Xero organisation uses.
  4. Press Download CSV and import it in Xero as a bank statement file.
bank statement to xero csv convert pdf bank statement to xeroxero bank statement csv formatxero import csv date amount payee descriptionstatement pdf to csv for xero
Open Statement to Spreadsheet Free to start · no account

What to know

Xero's bank statement import needs two columns at minimum, a date and an amount, and accepts optional ones such as Payee, Description and Reference. The file this page writes uses the template's headings, with an asterisk marking the required columns, so Xero's import screen recognises each column without remapping. The statement's text goes into Description; Payee and Reference are left empty because a PDF does not reliably separate them.

The amount is a single signed number: money in is positive and money out is negative, which is the convention Xero uses for statement lines. A statement with separate Withdrawal and Deposit columns is combined into this one column, so you do not have to subtract by hand.

As with any import, the date format matters. Choose the one your Xero organisation expects, and import a short test file first if you are unsure. Rows the tool could not read stay out of the file until you tick them, and the balance check above the preview points out rows where a missed or misread amount breaks the running total.

Updated · Cosmovex

Questions

Which columns does the Xero CSV have?

*Date, *Amount, Payee, Description and Reference. Date and Amount are filled in, the statement text goes to Description, and Payee and Reference are left empty.

How are debits and credits shown?

As one signed amount: money in is positive and money out is negative. Statements with separate Withdrawal and Deposit columns are combined for you.

Which date format does Xero need?

The one your Xero organisation is set to. Pick dd/mm/yyyy, mm/dd/yyyy or yyyy-mm-dd under Dates, and test with a small import first if you are unsure.

Does this connect to my Xero account?

No. It only produces the CSV in your browser. You import the file yourself in Xero, so no login or bank feed is involved.

Is the PDF uploaded to a server?

No. The statement is read and the CSV built in your browser. Nothing from it is sent to our servers.

The free plan covers everything on this page. Statement to Spreadsheet Pro ($9/mo, billed monthly) is described on the Statement to Spreadsheet page.