Skip to content
logo Knowledgebase

Statement Beginning Balance in 1-5 Bank Reconciliation has changed

Created on  | Last modified on 

Summary

The Statement Beginning Balance in the Sage 100 Contractor's Bank Reconciliation window doesn't match the previous month's Statement Ending Balance.

Cause

  • Audit errors are present in the General Ledger
  • The date of the cleared transaction succeeds the Statement Cutoff Date
  • Changing the Status of a cleared transaction after it's reconciled
     NOTE: Changed transactions appear in the color red
  • There's a cleared ledger transaction that transferred funds between bank accounts
     NOTE: These records, when recorded on a single journal entry, will clear the transaction in both bank accounts 

Resolution

1. Check for General Ledger Audit Errors

☐ Connect to the company database with Administrator rights and open the company exclusively
☐ Go to Menu 1-6: Period/Fiscal Year Management
☐ Click Recalculate Balances

2. Find Cleared Ledger Transactions After Statement Cutoff

☐ Open Menu 1-5: Bank Reconciliation
☐ Enter bank account number in Account# box
☐ Leave Statement Cutoff Date blank
☐ Click Display Items
☐ Compare Statement Beginning Balance to the previous month’s Statement Ending Balance

3. Check for Transactions That Changed Status

☐ From Menu 1-5: Bank, Reconciliation, choose Previous Reconciliations → Saved Reconciliations
☐ Review saved bank reconciliations for transactions flagged in red
☐ Compare with the saved PDF report
☐ Ensure 1-Open status transactions match.  Run the Queries to identify transactions by status

4. Find Cleared Ledger Transactions for Bank Transfers

☐ Run the Queries to identify transactions by status

Bank Reconciliation Tips

☐ Always start with a backup before troubleshooting
☐ Leave Statement Cutoff Date blank for initial checks
☐ Match Statement Beginning Balance to the previous month’s Ending Balance
☐ Use Previous Reconciliations and PDF reports for clues
☐ Verify Status 2-Cleared transactions have correct dates
☐ Recalculate balances after fixing errors
☐ Document your reconciliation process for audits

Related Solutions