Electronic Banking

How Do I...

You can export Sage 50 transaction data for the purposes of automating bank account reconciliation in certain electronic banking programs. You can export payments, payroll checks, receipts (deposits), and general journal entries by account number and date range.

To export electronic banking data

• From the File menu, select Import/Export. In the Select Import/Export window, select the Account Reconciliation program area, and click Electronic Banking.

Business Express/PC

This is an electronic banking program that can accept exported Sage 50 transactions. Below are the fields that Business Express/PC requires:

Business Express/PC Fields	Business Express/PC Field Requirements	Equivalent Sage 50 Fields
Date	8 characters	Date or Check Date
Reference	Up to 10 characters	Check Number, Deposit Ticket ID, or Reference #
Amount	Up to 8.2 characters	Net Check or Deposit Amount
Payee Name	Up to 25 characters	Name field

Related topics

Select Import/Export window

Import/Export filter and field options

Definitions of files, records, and fields

Import/Export field definition lists

Import/Export tips

What do you want to do next?

• Import data into Sage 50
• Export data from Sage 50
• Rebuild a company
• Perform other import/export tasks
• Read the import/export overview

Published: March 21, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks