TL;DR - Quick Summary
- Who it is for: Businesses importing bank statements into Sage 50, Sage Business Cloud Accounting, or Sage Intacct.
- CSV format: Sage 50 accepts Date, Reference, Description, and Amount, imported through Banking, Bank Accounts, Import Bank Statement.
- Watch out for: With a single Amount column Sage reads the sign, so withdrawals shown as positive figures import as receipts.
- Catching up: Import the oldest statement first and finish its bank reconciliation before importing the next month.
- Start: Convert your statement at /pdf-to-csv.
Sage Bank Import
Import bank statements into all Sage accounting products. Our converter creates CSV files compatible with Sage 50, Sage Business Cloud, and Sage Intacct.
All Sage Versions
Works with Sage 50, Business Cloud, Intacct
Fast Reconciliation
Speed up bank rec with automated imports
Audit Trail
Maintain complete transaction history
Sage Version Compatibility
Sage 50 (Peachtree)
Full CSV import support
Most popular for small-medium businesses
Sage Business Cloud Accounting
Cloud-based bank import
Modern online accounting solution
Sage Intacct
Enterprise CSV import
Advanced features for large organizations
Convert for Sage
Step 1: Download Bank Statement PDF
Get your statement from online banking.
Step 2: Convert to Sage Format
Convert for SageImport to Sage
Sage 50 Import Process
- 1.Open Sage 50 and go to Banking → Bank Accounts
- 2.Select Import Bank Statement
- 3.Choose your CSV file and follow import wizard
- 4.Review and post transactions
Why did Sage import my payments as receipts?
With a single Amount column, Sage reads the sign of each number to decide whether money came in or went out. If the converted file shows withdrawals as positive figures, everything lands on the wrong side. Either flip the sign of the debit rows in Excel before importing, or switch to a layout with separate money-in and money-out columns if your Sage edition offers that mapping. Credit card statements are the usual culprit, since the card issuer prints purchases as positive amounts.
What should go in the Reference column?
Use the check number for checks and the bank's own transaction reference for everything else, if the statement prints one. That is the field you will search on when matching a payment to a supplier invoice, so a consistent value saves time later. Sage reference fields have length limits, so trim long bank references to the part that identifies the payment rather than letting the import cut them off.
Does the order I import old statements in matter?
Yes, when you are catching up several months. Import the oldest statement first and complete its bank reconciliation in Sage before importing the next one. Each reconciliation then starts from a balance you have already agreed to the bank, and if a month does not balance you know the problem is in that month's file instead of somewhere in a stack of unreconciled imports.
Frequently Asked Questions
Convert for Sage Now
simplify your Sage accounting with automated bank statement imports.
Start Free Conversion