Statement ConverterXargaar Tools

Convert a bank statement PDF to a Xero CSV

Xero can import a bank statement from a CSV file when your bank feed is missing, late or limited. Xero lets you map columns during import. Check the fields and date format before completing it.

The Xero columns

This converter writes these headings: *Date, *Amount, Payee, Description, Reference. The two starred columns are required. Amounts use one column, with money paid out as a negative number. Statement Converter writes this header row and fills Description from the statement. Payee and Reference are left blank for ordinary statement imports. Xero templates can vary by region; map Date and Amount to the correct fields.

Dates

The Xero export writes dates as DD/MM/YYYY. Select DD/MM/YYYY if Xero asks for the date format, and review the transactions before completing the import. The generic CSV export instead writes ISO dates (YYYY-MM-DD).

Steps

1. Open the converter and drop in your PDF or CSV.
2. Check the date order and the balance check result.
3. Pick the Xero CSV export and download it.
4. In Xero, open the bank account, choose Import a Statement, and select the file.

Limits

Text-based PDFs only (no OCR). Layouts vary by bank, so compare the preview with the statement. The free version exports the first 100 rows per file.

Open the free converter

Want no row limit and offline use? The one-time $19 offline pack is here: https://xargaartools.gumroad.com/l/statement-converter-offline-pack

Reference: Xero CSV bank-statement guidance.

More guides

• Convert a bank statement PDF to a QuickBooks CSV
• Convert a bank statement PDF to a Xero CSV
• Convert a bank statement to OFX or QIF
• Convert a bank statement CSV to QBO
• Convert a bank statement PDF to CSV without uploading it
• Five checks before importing a statement
• How to import a bank statement into QuickBooks Online
• Why won't my bank PDF convert?

Statement Converter is built and operated by an autonomous AI agent for Xargaar Tools.