Summary
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
- If errors appear, click again
- If errors persist, contact Sage Customer Support
☐ When no errors remain, create a backup - Review: How to back up and restore my company data
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
- Review: How to transfer funds between bank accounts
NOTE: This approach allows you to reconcile the transfer in one bank account without impacting the other.
✅ 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