Xero's bank import accepts CSV in a fixed schema: Date, Amount, Payee, Description, Reference, Cheque Number, Analysis Code. This hub covers exactly how to get a PDF bank statement into that schema cleanly — by bank, by country, and across reconciliation, statement lines, and bank rules.
Last updated 2026-07-24
Xero's manual statement import accepts: Date (DD/MM/YYYY for AU/UK/NZ/IE, MM/DD/YYYY for US), Amount (signed, negative for spend), Payee, Description, Reference, Cheque Number, Analysis Code. Date and Amount are mandatory; the rest are optional but strongly recommended for reconciliation.
ClearlyLedger's Xero CSV export emits this schema directly. The Payee column is trimmed to Xero's 30-character display limit and the Amount column carries the signed value so reconciliation works on first pass.
Xero supports direct bank feeds for many banks (yodlee-based or direct API). When a feed is unavailable, broken, or covers a closed-month gap, manual CSV import is the fallback — that's where converted PDFs come in.
Use ClearlyLedger to fill historical periods, audit-trail months, or accounts where the live feed missed transactions.
Once a statement is imported, Xero presents Statement Lines that need to be reconciled against Bank Transactions. Clean Payee and Description text — preserved by ClearlyLedger from the source PDF — is what makes Xero's suggested matches and bank rules fire correctly.
Xero's largest markets — Australia, New Zealand, the UK, Ireland, the US, Canada — each have country-specific bank statement layouts. The country hubs below cover the format quirks per region.
Xero's manual statement import requires Date and Amount as mandatory columns, with optional Payee, Description, Reference, Cheque Number, and Analysis Code. Date format follows your organisation's locale. ClearlyLedger emits this schema directly.
When a feed is available, working, and covers the period you need, use it. PDF conversion fills the gaps — historical months before the feed was active, closed periods that need re-import, accounts on banks Xero can't feed, or audit reconstructions.
Yes — Payee and Description text is preserved from the PDF source so Xero's suggested matches and bank rules fire on the imported Statement Lines. Date and Amount precision matches the source statement.
Yes. MYOB AccountRight and Business accept a similar CSV shape (Date, Description, Amount). The same export works for both MYOB and Xero with format choice at download time.
PDF Bank Statement to Xero — the complete guide explains how ClearlyLedger converts bank statement PDFs into spreadsheet-ready data while preserving transaction dates, descriptions, debit amounts, credit amounts and balances. The page is written for accountants, bookkeepers, finance teams and business owners who need reliable Excel or CSV output instead of manual copy-paste.
The converter checks extracted rows against statement balances wherever the PDF provides enough information. That means opening balance plus credits minus debits should reconcile to the closing balance before you use the exported file in bookkeeping, tax preparation, lending review or account reconciliation.
ClearlyLedger exports clean Excel and CSV files for spreadsheet review and accounting workflows. Source PDFs are processed securely, are not used to train AI models, and are deleted after processing according to the site's data-retention policy. The same conversion workflow supports recurring close, tax, lending and reconciliation review.
The extraction flow separates statement chrome from transaction rows, normalizes date and amount formats, preserves long descriptions, and flags rows that need human review. The goal is not only to create a spreadsheet, but to create an audit-friendly file that can be filtered, sampled, and reconciled before it enters QuickBooks, Xero, Excel, or a lender review pack.
Accountants use ClearlyLedger when clients send historical PDFs instead of bank feeds. Bookkeepers use it for monthly close and catch-up work. Finance teams use it for reconciliation, cash-flow analysis, loan applications, tax preparation, and multi-bank review where manual copy-paste would be slow and error-prone.
Before importing the file into accounting software, review the statement period, opening and closing balances, any low-confidence rows, and the first and last transaction on each page boundary. These checks catch the mistakes most common in PDF extraction: repeated headers, skipped wrapped descriptions, subtotal rows, sign reversals, and dates that were inferred from a statement period rather than printed on every row.
For client work, keep the original PDF beside the exported spreadsheet during review. The PDF remains the source document, while the Excel or CSV file becomes the working ledger used for filtering, coding, reconciliation, and upload into downstream bookkeeping systems.
Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.
Loading interactive converter… Try ClearlyLedger free