Convert bank statements for Sage
Statement PDFs to Sage-ready CSV — unambiguous dates, signed amounts, verified before import.
Business Cloud, Sage 50, and the import details that bite
Sage Business Cloud Accounting imports statement CSVs per bank account with a simple column mapping — date, description, amount — and Sage 50 takes the same layout through its bank record import routines. The export is built for both: one signed amount column (money out negative), full descriptions for Sage's matching, and a reference balance column the import can ignore.
The details that usually bite Sage imports are dates and signs. A DD/MM file read as MM/DD silently swaps months; split debit/credit columns import as all-positive noise. Both problems are gone before the file reaches Sage — dates export as ISO, signs are inferred from the statement's columns and verified against its running balance during conversion.