Sage imports bank transactions from CSV, and the converted export is shaped for it: one signed amount column, ISO dates, full descriptions. (New here? Start at the Sage converter page.)
Step by step
- Convert your statement and download the CSV export.
- In Sage Business Cloud Accounting, open Banking, select the account, and choose the statement import option.
- Select the CSV and map the columns: Date → date, Description → description, Amount → amount. The balance column is for your own reconciliation and can be ignored by the import.
- Confirm, then match and categorise.
Which Sage?
- Sage Business Cloud Accounting imports CSV directly as above.
- Sage 50 takes CSV through its bank record import routines; the same column layout applies.
Dates and signs
Exports use ISO dates (YYYY-MM-DD) and signed amounts — money out negative, money in positive. That removes the two classic Sage import headaches: ambiguous day/month order and separate debit/credit columns.
After the import
The imported period ties out to the statement's printed closing balance — every conversion is balance-checked before export. Reconcile in Sage as you would against a feed.