Auto Bank Reconciliation in Sage 300 ERP

By | October 6, 2012

Bank Reconciliation is one of the important processes of an ERP, which reconciles the bank statement with its own book of Account. Reconciliation means comparing ERP Account book and bank statements with a list of transactions, which is a tedious task and there is always a risk involved in making an error.

Sage 300 ERP (formerly known as Sage Accpac ERP) has an option of reconciliation with OFX statements. Still, this option is not suitable for those users who receive bank statements in the CSV (Comma separated values) format.

So we have come up with the Auto Bank Reconciliation module in Sage 300 ERP for the users who receive a statement in CSV format. Auto BR module reads the data from CSV bank statements and updates it in Sage 300 (Accpac) ERP, and then reconcile it from Bank module.

Now users can automatically reconcile the Accounts Payable (A/P) and Accounts Receivable (A/R) checks in Sage 300 (Accpac) ERP and as a result, will minimize the time spent and will also reduce the risk of making errors during bank reconciliation using the Auto Bank Reconciliation option.

Step by Step Guide to Auto Bank Reconciliation in Sage 300 ERP – Click here  

After Activating the module user will see the “Bank Reconciliation” module in Sage 300 Desktop as shown above.

Some key points:

1. A user can reconcile the bank statement in CSV format.
2. Automatic marking of cleared checks.
3. Minimize the time spent and also reduces the risk of making errors during bank reconciliation.

In our next blog, we will see How the Auto Bank reconciliation Works.

For more information on Auto Bank Reconciliation, write to us at
About Us
Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix has some unique solutions of Sage 300 integration with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services to Sage business partners, end users, and Sage PSG worldwide.
For more details on Sage 300 Services, please contact us at We will be glad to assist you.