Import Bank Statement Transactions into Sage

DocuClipper exports bank-statement transactions as a Sage CSV (or Sage Cloud CSV) file that can be imported directly into Sage Accounting or Sage Business Cloud Accounting without any manual cleanup.

Step 1: Download the Sage CSV

1. Open the project containing your converted bank statement.
2. Click Download Data (above the Summary of Reconciliation).
3. Under Output Format, select Sage CSV (desktop Sage) or Sage Cloud CSV (Sage Business Cloud).
4. Check the column list. Sage CSV writes Type, Account Reference, Nominal A/C Ref, Date, Details, Net Amount, Tax Code and Tax Amount, the layout Sage 50 imports. Sage Cloud CSV writes date, description and amount. These columns are fixed for each format.
5. Click Download Sage CSV.

How the columns are filled

Sage CSV (Sage 50 Accounts) writes one row per transaction in Sage 50's audit-trail import layout. The Type column carries the direction, so Net Amount is always a positive number:

1200 is Sage 50's default bank current account, 4000 its default sales account and 5000 its default purchases account. Tax Code is T2 with a Tax Amount of 0. If your company file uses different codes, change them in the CSV or in Sage's import mapping before importing. Details holds the transaction description.

Sage Cloud CSV (Sage Accounting) writes a single signed amount column: money in is positive and money out is negative.

Step 2: Import into Sage Business Cloud Accounting

1. In Sage, go to Banking → the bank account you want to import into.
2. Click Connect bank → Upload a statement.
3. Upload the CSV you just downloaded.
4. Sage will show a mapping preview. Map date to Date, description to Description and amount to Amount (the single-column option, where positive amounts are money in and negative amounts are money out), then continue.
5. Review and confirm. Transactions land in your reconciliation queue.

Step 2 (alternate): Import into Sage 50 / Sage Desktop

Use the Sage CSV file here, not Sage Cloud CSV.

1. Back up your Sage 50 company data. Sage cannot undo an import.
2. In Sage 50 Accounts, go to File → Import.
3. Choose Audit Trail Transactions as the record type and select the DocuClipper CSV.
4. Map each column to the Sage field of the same name (Type, Account Reference, Nominal A/C Ref, Date, Details, Net Amount, Tax Code, Tax Amount) and run the import.
5. Deposits come in as bank receipts and payments as bank payments on bank account 1200, ready to reconcile.

Tips

• Date format. Sage CSV and Sage Cloud CSV write dates in your team's saved export date format, the one picked in the Date Format dropdown under Excel; the dialog's preview shows them as they will appear in the file. To match your Sage org, set Output Format to Excel once and pick UK (DD/MM/YYYY) or US (MM/DD/YYYY); every later Sage download uses it. See Customize Date Format.
• Duplicate handling. Sage deduplicates on date + amount + description. If you re-import the same period, Sage will skip anything it already has.
• Large statements. If you hit Sage's per-import row limit, split the CSV by month and import in batches.

Related

• Downloading Bank Transactions
• Customize Date Format
• Import Bank Statement Transactions into Xero