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 never stored 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 a KeyBank Statement to Excel or QuickBooks
Turn a KeyBank statement PDF into Excel, CSV, or a QuickBooks .QBO file — including older statements KeyBank no longer offers as data downloads. Every balance verified.
How to Convert an American Express Statement to Excel or QuickBooks
Turn an Amex statement PDF into Excel, CSV, or a QuickBooks .QBO file — Business Gold, Platinum, and personal cards, with charge/payment polarity handled.
Import Bank Statements into QuickBooks Desktop (.QBO Web Connect)
QuickBooks Desktop can't read PDF statements — but it imports .QBO Web Connect files. Here's how to turn any bank statement PDF into a QBD-ready .QBO, balances verified.
Newsletter
Join the community
Subscribe to our newsletter for the latest news and updates