Sage is one of the most widely used accounting platforms in the UK — particularly Sage 50 for established practices and Sage Business Cloud for smaller firms. But like all cloud accounting software, Sage won't accept PDF bank statements directly. You need a CSV or Excel file first.
Sage accepts these formats: CSV, OFX, QIF, and Excel (XLS/XLSX). Sage does not accept PDF files. If your client sends you a PDF bank statement, you need to convert it before importing.
Importing into Sage Business Cloud
- Go to Bank accounts (left sidebar)
- Click on the bank account you want to import into
- Click the Import button (top of the transaction list)
- Select your CSV or Excel file
- Sage will show a preview — map the columns: Date, Description, Amount
- Click Import
Importing into Sage 50 (Desktop)
- Open the Bank module
- Select the bank account from the list
- Click Import (toolbar)
- Browse to your CSV file and select it
- Map the fields: Date, Reference/Description, Amount
- Confirm and review imported transactions
Converting PDF Bank Statements for Sage
Three approaches, ranked by speed and accuracy:
- Manual copy-paste: Slow (15-30 min/statement) and error-prone. Sage's import is strict about formatting — a single misplaced comma can cause failures.
- Adobe Acrobat export: Faster (5-10 min) but often misaligns columns, especially on older HSBC and NatWest statements with multi-line entries.
- AI-powered conversion: BankScan AI extracts transactions in seconds, handles UK bank quirks (HSBC DR/CR indicators, Barclays dual columns, Lloyds type codes), and outputs CSV ready for Sage import.
Common Sage Import Issues
"File format not recognised"
Check your file extension — Sage expects .csv, .ofx, .qif, .xls, or .xlsx. A renamed .pdf won't work.
"Column mapping failed"
Sage couldn't identify your Date, Description, or Amount columns. Ensure your headers are clearly labelled and the data underneath is formatted correctly (dates as DD/MM/YYYY, amounts as plain numbers).
"Import incomplete — transactions skipped"
Usually caused by blank rows, multi-line descriptions split across rows, or special characters in the description field. Clean your CSV before importing.
UK bank format tip for Sage: Sage is particularly sensitive to date formats. UK banks use DD/MM/YYYY but some (like Santander) use DD MMM YY. Make sure all dates in your CSV are in a consistent DD/MM/YYYY format before importing.
Convert Any UK Bank Statement for Sage in Seconds
Upload your PDF, get a Sage-ready CSV file. No signup, no credit card.
Try Free Now →Last updated: 8 May 2026. Sage, Sage 50, and Sage Business Cloud are trademarks of Sage Group plc.