Sage is widely used in the UK. It does not accept a PDF bank statement as structured transaction data, so a sole trader importing their own statement needs a suitable CSV or Excel file first.
Sage accepts these formats: CSV, OFX, QIF, and Excel (XLS/XLSX). Sage does not accept PDF files as transaction imports, so verify the converted data 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: Gives you control but becomes repetitive and is vulnerable to missed or shifted rows.
- Bank or PDF export: Use a suitable export when available, then check dates, descriptions and amounts against the source.
- AI-assisted conversion: BankScan AI can prepare a working file from supported formats. Review every row and adapt it to your Sage product's current import rules.
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 Your Own Business Statements
The £3.99/month Sole Trader plan is for one UK sole trader or owner-operated small business that keeps sole-trader records. AI usage follows the monthly allowance shown in the app.
Start 7-day trial →Last updated: 8 May 2026. Sage, Sage 50, and Sage Business Cloud are trademarks of Sage Group plc.