Understand beginning balance calculation

Sage 100 calculates the beginning balance using this formula:

• Current balance in Bank code maintenance
• Plus checks
• Plus adjustments that decrease the bank balance
• Plus bank charges
• Plus NSF charges
• Plus withdrawals
• Minus adjustments that increase the bank balance
• Minus deposits
• Minus interest

This total equals the beginning balance on the Bank Recap Report.

Correct an incorrect beginning balance

1. Select Bank reconciliation, Reports, Bank Recap Report.
2. Click Preview.
3. Calculate the difference between the ending bank statement balance and the report beginning balance.
   • Use the Ending Balance for the last month that you purged in the Bank Reconciliation module.
4. Select Bank Reconciliation, Main, Bank Code Maintenance.
5. Record the current balance before making changes.
6. Adjust the current balance by the calculated difference from step 3:
   • Increase the Current Bank Balance if the Recap Beginning Balance is too low.
   • Decrease the Current Bank Balance if the Recap Beginning Balance is too high.
7. Click Accept.
8. Reopen Bank reconciliation, Reports, Bank Recap Report.
9. Click Preview.
10. Confirm the beginning balance matches the ending bank statement balance. This will be for the last month purged in the Bank Reconciliation module.