How to Import Bank Statements into Sage from a PDF
Sage does not read PDF bank statements. It imports CSV, OFX, QIF and spreadsheet files — and a CSV only works when its columns sit in the exact order Sage expects. That gap is where most Sage imports fail: the statement itself is fine, but the file handed to Sage has the wrong shape. The fix is a short pipeline: convert the PDF with a bank statement converter, shape the CSV to Sage's template, import it, and check the result against the printed balances. This guide walks through each step for Sage Accounting, with notes for Sage 50 where the screens differ.
What Sage accepts, and what it refuses
Sage Accounting imports bank statements through Banking, then Actions on the bank account, then Import statement. The accepted file types are CSV, OFX, ASO, QIF, XLS and XLSX, plus BAI2 and CAMT.053 in some regions. A PDF is on none of those lists, so the PDF has to become a CSV first — there is no upload-PDF-and-hope route.
Two more limits decide whether an import succeeds. Sage imports transactions for one bank account at a time: if a file holds two accounts, only the first is read and the rest is ignored. And a foreign-currency bank statement cannot be imported at all, nor can transactions dated before your Accounts Start Date. Check both before you convert, because no amount of reformatting fixes a file Sage is not allowed to take.
Step 1: Convert the PDF to Sage's CSV shape
Sage's CSV template comes in two layouts, and you must pick one before converting — a file that mixes the two is rejected. The three-column layout is Date, Description, Amount, with money out as a negative number. The four-column layout is Date, Description, Money in, Money out, with both amounts positive and the empty side left blank. Either layout works; the four-column version is easier to read back later, because a sign error shows up as money on the wrong side instead of a wrong total.
| Layout | Columns in order | How money out is shown |
|---|---|---|
| Three columns | Date, Description, Amount | Negative number in the Amount column |
| Four columns | Date, Description, Money in, Money out | Positive number in the Money out column, Money in left blank |
Convert the PDF with the bank statement converter: upload the statement, check the conversion against the printed opening and closing balances, and download the CSV in the layout you chose. One file per account — if the PDF covers two accounts, split it first. Our guide on how to check a bank statement conversion covers the balance check in detail; never import a file that has not passed it, because an import of bad data is far harder to undo than a conversion you redo.
Step 2: Tidy the CSV before Sage sees it
A converted CSV is almost import-ready, but three details still trip people up. First, dates: Sage asks you to confirm the date format at import time, so decide which order your file uses and keep it consistent — mixed formats in one file are the most common cause of transactions landing in the wrong month. Second, remove anything that is not a transaction: running balances, opening and closing balance rows, and the account number. Third, if you are importing a spreadsheet instead of a CSV, remember Sage reads only the first tab of an XLS or XLSX file.
- One account, one period, one file — never two accounts in a single import.
- Dates in one format throughout, with slashes, for example 04/01/2026.
- No balance column, no summary rows, no currency symbols inside numbers.
- Descriptions trimmed to 100 characters or fewer.
- Money out negative in the three-column layout, positive in the Money out column in the four-column layout — never both.
Step 3: Import bank statements into Sage
With the CSV ready, the import itself takes a few minutes. The steps below are for Sage Accounting; Sage 50 Accounts starts from the Bank Feeds module instead, but the file rules are the same.
- In Sage Accounting, open Banking and find the bank account the statement belongs to.
- Select Actions, then Import statement, and choose your CSV file.
- Select the file type, then confirm the date format your file uses.
- Choose Review transactions and read the preview: dates, descriptions and amounts should match the statement.
- Confirm the import. Sage remembers the settings from the first import to an account, so later files can go in with Import without review.
Read the preview before you confirm. The preview is the last cheap place to catch a flipped sign or a shifted column — after the import, fixing the same error means deleting transactions one by one or restoring a backup. If a row looks wrong in the preview, stop, fix the CSV, and import again.
Step 4: Check the import against the statement
An import that finishes without an error is not automatically a correct import. Compare the imported transactions with the PDF: the row count should match the statement's transaction count, the first and last dates should match, and the closing balance in Sage should equal the statement's closing balance. If Sage shows a different balance, the difference is usually one of three things: a row the conversion dropped, a sign flipped in the CSV, or a summary row that slipped through as a transaction.
When the balances disagree, do not adjust the Sage side to match. Go back to the conversion and find the missing or doubled row — our guide on why a converted bank statement does not balance works through the same hunt. Once the CSV balances on its own, re-import it; a clean second import beats a patched first one every time.
When the import fails
| Symptom | Likely cause | Fix |
|---|---|---|
| File rejected outright | Columns in the wrong order, or a header Sage does not recognise | Rebuild the CSV in the 3- or 4-column layout, headers exactly as Sage lists them |
| Transactions in the wrong month | Date format confirmed incorrectly at import | Re-import and pick the date order your file actually uses |
| Only some transactions appear | File held two accounts, or transactions predate the Accounts Start Date | Split the file per account; exclude pre-start-date rows |
| Import blocked, no transactions | Foreign-currency statement, or Cash in Hand / Loan account type | Import into the matching currency account, or post the lines manually |
| Amounts look right but balance is off | Sign flip, or a summary row imported as a transaction | Check the CSV against the statement and re-import |
The same PDF-to-CSV workflow feeds the other accounting tools too: if you also keep books in QuickBooks or Xero, the conversion step is identical and only the target layout changes. See our guides on importing bank statements into QuickBooks and importing bank statements into Xero for those layouts. And once the import lands, the monthly job is the reconciliation — our guide on reconciling a bank statement in Excel after converting PDF to CSV covers the matching routine that keeps the books honest.
A monthly routine that sticks
Convert each statement the week it arrives, import it the same day, and check the closing balance before you close the file. Sage remembers the import settings per account, so the second month is faster than the first — the only work left is the conversion check and the preview read. Keep the PDF, the CSV and a note of the import date together; when the accountant asks where a transaction came from, the answer is a folder, not a memory.
Sources and further reading
- Sage Accounting — Supported file formats for bank statement imports (Sage Knowledgebase)
- Sage Bank Statement Import: CSV Format and Steps — ZeraBooks
Put it into practice
Convert a statement now and watch the balance check run on your own file. The first 10 pages each month are free, and exports are never cut short.
More guides
How to Convert a Bank Statement PDF to CSV · How to Convert a Bank Statement PDF to Excel · How to Import Bank Statements into QuickBooks (QBO Files) · OFX vs. QBO vs. QIF: Which Format Should You Download? · Why a Converted Bank Statement Does Not Balance — and How to Fix It · How to Check a Converted Bank Statement Is Correct · Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not · How to Convert a Password-Protected Bank Statement PDF · How to Convert Many Bank Statements at Once (and Merge Them Cleanly) · Is It Safe to Convert Bank Statements Online? A Privacy Checklist · How to Import Bank Statements into Xero · How to Reconcile a Bank Statement in Excel After Converting PDF to CSV