How to Get a Scanned Bank Statement into Xero
A scanned or photographed bank statement won't import into Xero. Convert it to OFX or CSV with OCR — every balance verified so misreads get caught — then import.
Xero imports bank statements as OFX, CSV, or QIF — never a PDF, and definitely not a scan or a phone photo. But scanned statements are exactly what you end up with for older periods, closed accounts, or a client who mailed you paper. Here's how to get a scanned statement into Xero cleanly.
Why scanned statements are the hard case
A digital PDF has a text layer you can extract. A scan or photo has no text — it's just an image, so it needs OCR (optical character recognition) before any of the numbers exist as data. And OCR is where accuracy quietly breaks: an "8" reads as a "3", a decimal drifts, and the export looks fine until Xero won't reconcile weeks later.
That's the whole reason to verify, not just convert.
Convert the scan (with a balance check)
- Open Convert Bank Statements and drop in the scanned PDF or photo.
- OCR reads every transaction — dates, descriptions, amounts, running balance.
- The balance check is the safety net: each account is reconciled (beginning balance + deposits − withdrawals = printed ending balance). If OCR misread a digit, the math breaks and the row is flagged for review instead of silently exported. (More on the balance-verification logic.)
- Export as OFX (best for Xero) or CSV.
Import into Xero
- In Xero go to Accounting → Bank accounts, pick the account.
- Choose Manage account → Import a statement.
- Upload the OFX file — Xero maps the fields automatically. (For CSV, you map Date / Amount / Payee once and Xero remembers it.)
- Review and confirm. The transactions land in the bank account ready to reconcile.
Tips for scans specifically
- Straighten and crop before uploading — a flat, full-page scan OCRs far better than a skewed phone photo.
- Include the summary line (beginning and ending balance). That printed total is what makes the balance check possible — without it there's nothing to verify against.
- Multi-account or credit-card scans are split per account with the correct sign convention, so Xero doesn't read a card purchase as money in.
- Prefer OFX over CSV for Xero — it carries the fields Xero expects, so there's less manual mapping.
Is it accurate enough to trust?
That's the point of reconciling every account. A clean scan that balances to the cent is safe to import; one that doesn't tie tells you exactly which line to check. A misread digit can't sneak into Xero unnoticed. Your file is auto-deleted in 24 hours and never used to train AI — see our security page.
FAQ
Can I import a phone photo of a statement? Yes — a clear, flat photo works. Straighten it first; better image quality means better OCR.
OFX or CSV for Xero? OFX. It maps automatically; CSV needs a one-time column mapping.
How much does it cost? 15 free pages on sign-up. Page packs start at $12 and never expire. See pricing.
Convert a scanned statement for Xero →
Related guides
- Import a bank statement PDF into Xero (OFX or CSV)
- Convert a scanned bank statement (OCR)
- The check every bank-statement converter skips
- Catch-up bookkeeping: convert a year of statements
Not affiliated with or endorsed by Xero. Xero is a trademark of Xero Limited.
More Posts
How to Convert an Ally Bank Statement to Excel or QuickBooks
Turn an Ally Bank statement PDF into Excel, CSV, or a QuickBooks .QBO file — checking, savings, or money market, single account or several. Every balance verified.
How to Import a Bank Statement into Sage (Sage 50 & Business Cloud)
Sage can't read a PDF. Convert your bank statement to CSV or OFX — with every balance verified — and import it into Sage 50 or Sage Business Cloud Accounting.
How to Convert a Barclays Statement to Excel, Xero or QuickBooks
Turn a Barclays statement PDF into Excel, CSV, or a Xero/QuickBooks-ready file — every balance verified — including older statements you can only download as PDFs.
Newsletter
Join the community
Subscribe to our newsletter for the latest news and updates