Watch the Video

Watch this short video on how to import cleared transactions into your bank reconciliation using the Import Transaction Status feature in your Bank Reconciliation.

Follow the steps to import cleared transactions

If you prefer to follow step-by-step guidance, use the steps below.

Before you begin

• Back up the company information. If a problem occurs with the import, restore the backup, correct the import file, and complete the import process
• You must have the transactions entered into the BusinessWorks system
• Bank transactions must exist in the bank reconciliation in Sage BusinessWorks 
• Use this document for full instructions 

Import using the bank's file

1. Go to CM, Transactions, Reconcile Checking Account.
2. Select the cash account to reconcile, dates. and amounts and click Reconcile.
3. At the bottom of the next screen, click Import Transaction Status.
4. The first time you use this feature click Create Import Format and fill in the screen. This creates a format/template to use that indicates how to match the import columns for the reconciliation.
    NOTE: For EFT transactions, use EFT for the check # field.  The description can be blank as long as the check # indicates EFT and the amount is the same. 
5. Set up multiple formats or templates if you use different banks and cash accounts.
6. Click Save.
7. Complete the Import Transaction Status screen.