Importing bank transactions into Sage BusinessWorks.

Many people can download files directly from your bank that lists out all the transactions that have been cleared from the period you selected.

Sage BusinessWorks allows you to import that file into your bank reconciliation to automatically check or clear all the transactions that are listed in that file.

First, access your Bank Reconciliation: 

  • Cash Management > Transactions > Reconcile Checking Account.

Cash Management > Transactions > Reconcile Checking Account

  • Select the correct Cash account, Statement and Reconciliation Dates as well as the Statement Beginning and Ending Balances.

Reconcile Cash Account Screen

  • At the bottom of the Reconciliation screen, select Import Transaction Status.

Reconcile Screen - Import Transaction Status

You may get a note that says you do not have import formats.

  • Click OK.

No Imports Message - Click OK

In that case you will need to create an import format.

How to Create an Import Format: 

  • Click on Create Import Format button.

Import Transaction Status Screen - Create Import Format

  • Name this Import Format (you can name this for the bank it is for) > Load Columns.

Name Import Format - Load Columns

Load Columns allows you to select the file that was downloaded from the bank.

  • Select the downloaded file > Open.

Import File Selection - Select your file - Open

The file will then show you the first valid import line. With each field being separated by a comma.

Import Format screen - First valid import file

  • Fill out the Import Data Type and the Mapped To.

Import Format screen - Fill out data and mapped to

  • Click Save.

Import Format screen - Save

  • Close out of the screen after saving.

Import Format screen - Close screen

Import Transaction Status Screen: 

  • Click Browse.

Import Transaction Status Screen - Browse

  • Select your import file > Open.

Import File Selection - Select your file - Open

  • Click OK.

Import Transaction Status Screen - Click OK

The report engine will be loaded and will let you know what exactly happened with the import file.

Import Bank Transaction Status Log - Open Report

Note: If your bank has column headers on the first line then in this import bank transaction status log your line one may indicate that it’s an invalid file format but that is okay. It’s not going to import it’s just because it’s column headers so you can just ignore that and then make sure all the others are going to import.

  • Close out of status log report.

Import Bank Transaction Status Log - Close Report

Your bank reconciliation screen will automatically refresh.

Before Cleared Transaction

After Cleared Transaction

This should make your bank reconciliation much easier, especially if you have many transactions to clear.

If you have questions or need assistance with your Sage BusinessWorks software at any time, please contact our BusinessWorks support team at 260.423.2414.

Register for our Sage BusinessWorks newsletter today!

More Sage BusinessWorks Software Tips

Copyright 2025 DWD Technology Group | All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.

About the Author: Mary Hildinger

Mary Hildinger has been with DWD Technology Group since 1996. Mary is a Sage 100 Certified Consultant with over 29 years of experience. She has extensive experience with new software implementations (with a focus on core accounting, distribution and payroll), upgrades, training, and custom Crystal Report writing.

Recent DWD Tech Blog Posts

DWD Tech Blog Categories