How to Import a Bank Statement into Sage (Sage 50 & Business Cloud)

Sage imports bank statements as OFX, QFX, or CSV (Sage 50), and as CSV in Sage Business Cloud Accounting. Neither accepts a PDF. If a bank feed isn't connected, a client sent paper, or you're reconciling a prior year, you're converting statements by hand.

Here's the short path: turn the statement PDF into OFX (or a clean CSV), then import.

Why you're stuck with a PDF

Sage's bank feeds cover recent activity, but older periods, closed accounts, and clients who only have paper leave you with PDF statements — and Sage won't read one. For UK bookkeepers doing year-end and catch-up, that's most of the work.

Convert the statement (with a balance check)

1. Open Convert Bank Statements and drop in the PDF or scan.
2. Every transaction is extracted — date, description, amount.
3. The balance check is the safety net: each account is reconciled (opening balance + money in − money out = printed closing balance). If a digit was misread, the math breaks and the row is flagged for review instead of silently exported. (More on the balance-verification logic.)
4. Export as OFX (best for Sage 50) or CSV.

Import into Sage

Sage 50:

1. Go to Banking, select the bank account.
2. Choose Import (Bank Feeds / Import Statement) and pick your OFX/QFX or CSV file.
3. For a CSV, map the columns Sage prompts for — Date, Description, Amount — and set the date format (DD/MM/YYYY for UK).
4. Review the transactions and confirm.

Sage Business Cloud Accounting: go to Banking → the account → Import a statement, upload the CSV, map Date / Amount / Reference, and confirm.

Sage-specific tips

• Date format is the #1 cause of failed imports. UK Sage expects DD/MM/YYYY; the export gives you consistent dates, so pick the matching format on import.
• Strip nothing by hand. Common Sage failures come from currency symbols in the amount column and extra header rows — the converted file is already clean numeric amounts with one header.
• OFX over CSV for Sage 50 — it carries the fields Sage maps automatically, so there's less manual column work.
• Scanned or faxed statements work too; the balance check catches OCR misreads. See the scanned statement guide.

Is it accurate?

Every account is reconciled the way a bookkeeper would check it. If a row breaks the math, it's flagged for review instead of silently exported. Your file is never stored and never used to train AI. See our security page.

FAQ

Does Sage accept PDF bank statements? No — Sage 50 takes OFX/QFX/CSV; Sage Business Cloud takes CSV. Convert the PDF first.

Which format for Sage 50? OFX if you can — it maps automatically. CSV works with 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 statement for Sage →

Related guides

• Import a bank statement PDF into Xero (OFX or CSV)
• Import a bank statement into Wave (CSV or OFX)
• Convert a scanned bank statement (OCR)
• Catch-up bookkeeping: convert a year of statements

---

Not affiliated with or endorsed by Sage. Sage, Sage 50, and Sage Business Cloud are trademarks of The Sage Group plc.