Accounting imports · Sage
Bank statement PDF to Sage
Sage Accounting can import bank transactions from a file. Convert your PDF statement here, then map the columns in Sage.
or drop it here
Read in this browser. Your file is never uploaded.
Rows wrong or missing?
Send us the shape of this statement, not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Date | Description | Paid in | Paid out | Balance |
|---|
Send us the shape of , not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Check | Result | What we found |
|---|
Statements
| Period | File | Opening | Closing | Rows | Used as |
|---|
| Date | Description | Paid in | Paid out | Balance | From |
|---|
Works with text PDFs that have Date, Description, Paid in / Paid out (or Amount) and Balance columns. Scanned or photographed statements are not supported yet. The samples are fictional test data.
Which Sage?
“Sage” covers several products. Sage Accounting (the cloud product for small businesses) can import bank transactions from files such as CSV, OFX and QIF, and lets you match the columns of a CSV to its own fields. Sage 50 (desktop) has its own bank import routes, which vary by version. This page focuses on Sage Accounting; for Sage 50, check Sage’s help for your version.
Which export to use
Sage Accounting’s import can work with either a single amount column or separate money in and money out columns, depending on how you map it. Both converter exports work:
- CSV for Excel: Date, Description, Paid in, Paid out, Balance. Map Paid in to money received and Paid out to money paid. Leave Balance unmapped.
- QuickBooks CSV: Date, Description, Amount, with money out negative. Use this if you prefer a single amount column.
Steps
- Convert the statementChoose the PDF above and check it says “Verified”.
- Download a CSVThe CSV for Excel or the QuickBooks CSV, as above.
- Open the bank account in SageGo to Banking and select the account the statement belongs to.
- Import the fileChoose the option to import transactions or a statement, select the CSV, and match each column to Sage’s fields. Choose dd/mm/yyyy dates.
- Review and reconcileCheck the imported transactions, then reconcile against the statement’s closing balance.
Sage’s menus and import options change between versions. If something doesn’t match, search Sage’s help for “import bank transactions”.
Year-end catch-up
If you’re bringing a year into Sage from PDF statements, use “Several statements” first. The whole-year check makes sure no month is missing, that duplicate downloads are only counted once and that each statement’s opening balance follows on from the last, so the bank reconciliation in Sage comes out right at year end.
Questions people ask
Can Sage import a PDF bank statement?
No. Sage imports files such as CSV, OFX and QIF. Convert the PDF to CSV first.
Should I use one amount column or two?
Either works in Sage Accounting’s column matching. Use whichever you find easier to check.
Does this work with Sage 50?
Sage 50’s import options depend on the version. The CSV files are standard, but check Sage’s help for your version.
Is the Excel CSV free?
Yes. The CSV for Excel is free for single statements. The QuickBooks CSV is a Pro feature, free during the beta.