Statement to SheetStatement to Sheet › Xero
Convert a bank statement PDF to a Xero CSV
Xero can import bank statements from a CSV file. Make that file from your PDF statement here, without uploading the PDF.
| # | Date | Description | Amount | Balance | Check |
|---|
Did your statement not convert correctly? Download an anonymised layout file and email it to us. It keeps only where text sits on the page: every letter becomes x and every digit becomes 9, so no names, numbers or amounts are included.
Saved. Attach the -layout.json file to the email. Open it first if you want to check what it contains.
Xero's manual statement import accepts a CSV with a date, an amount, a payee, a description and a reference. The converter fills the date, amount and description from your statement, with dates as DD/MM/YYYY, so you can fill gaps in a bank feed or bring in an account that has no feed at all.
Because the rows are checked against the balance printed on the statement first, the closing balance in Xero should match the statement after the import.
How to get the PDF and convert it
- Drop the statement PDF into the converter above.
- Choose "Xero (precoded statement)" in Download as, then download.
- In Xero, open the bank account and choose to import a statement.
- Upload the CSV and check the column mapping.
What the converter checks
- Dates use DD/MM/YYYY.
- Amounts are signed: spent negative, received positive.
- The statement text goes into Description; Payee and Reference are left empty for you to fill if needed.
FAQ
Can I import several months?
Convert and import one statement at a time so each month's balance can be checked.
Does it work for credit card accounts in Xero?
Yes. Card statements are checked against the previous and new balance before you download.