Need to balance Bank Register to General Ledger in SAGE 100 ERP?

Fixing those annoying out of balance conditions!


Bank registers very rarely balance and can present some time consuming challenges to finding those items causing the problem. In addition to finding those out of balance items in SAGE 100 ERP there is also the task of making sure it, not only does it balance with the bank, but does it also balance with the General Ledger Module in SAGE 100 ERP. SAGE 100 ERP has made it easier than ever to balance to the monthly bank statements.

(TIP: Bank statements from your financial institution sometimes do not cut off at the end of the month. This can present challenges when preparing monthly reports that do not coincide with the date the statement ends. Financial institutions will change the statement cutoff at the end of the month if requested. It just takes a phone call and they will adjust the current month and start at the next full month). 


But despite the ease of use in SAGE 100 ERP bank register reconciliation screen it is still up to the user to find the discrepancies. When they are found however, it has been cumbersome in the past to leave the reconciliation register and make the adjustment in the General Ledger module. This is where the new enhancement in SAGE 100 ERP for version and higher have helped. 


As of version MAS 90/200 has the capability to post Bank Reconciliation transactions to the General Ledger module.


1. Go to the Bank  Reconciliation module and expand Bank Reconciliation, Main and click Checks, Deposits and Adjustments -OR- Reconcile Bank.


2. Enter all applicable check, deposit or adjustment information on the last entry line.

(These will be for items not posted in the AP register either as a manual check or through payments using the Invoice Payment Register)

3. Select the box to Select For G/L Posting (if there are general ledger account  numbers that are new they will need to be setup in the module under setups)

4. In the Distribution Account No field, select the appropriate G/L account from lookup (Note: you do not need to enter the cash G/L account number, the offset account number will be the cash account selected in Bank Code Maintenance for this Bank Code.)

5. Click Accept

6. Click the Bank Reconciliation Transaction Register button

7. Select the Bank Code from lookup

8. Enter the Bank Reconciliation Posting Date.

9. Print and update the Bank Reconciliation Transaction Register.

10. Print and update the Bank Reconciliation Daily Transaction Register. (Note: this step will update the transaction to the general ledger).


Note: Not all users will be able to perform the functions as listed above. The proper Role permissions must be selected in Role Maintenance. If the role is not assigned to the user it can easily be added by going to the role permissions and adding it for a specific role.


Now you can keep the bank reconciliation process more contained and less time consuming in SAGE 100 ERP by posting to the general ledger without leaving the bank reconciliation module. This will save considerable time particularly when there are multiple bank reconciliations to perform and for multiple companies!