The general ledger account balance doesn't match the subledger detail (AR, AP, inventory, fixed assets). Reconciliation in Excel is taking days every month.
Why it happens
- Manual journal entries posted to subledger control accounts
- Accounting configuration that splits postings unexpectedly
- Multi-currency revaluation entries posted only on one side
- Open documents that should have been validated and weren't
- Subledger postings stuck in error and never re-processed
Diagnostic steps
- 1. Run the standard reconciliation reports
Sage X3 provides reconciliation inquiries for AR/AP/inventory. Always start here, not in Excel.
- 2. Check for direct journal entries to control accounts
Control accounts should be locked from direct posting. If they aren't, audit recent journals.
- 3. Review automatic journal definitions
An accounting code or automatic journal misconfiguration is a common cause of small persistent differences.
- 4. Check for stuck postings
Look for failed or pending postings in the journal entries log — these can leave the subledger ahead of the GL.
Fixes
Lock control accounts
Restrict direct posting to AR, AP, inventory, and fixed-asset control accounts. Force corrections through the subledger.
Re-process stuck postings
Resolve any failed journal entries and re-post them so the subledger and GL converge.
Correct accounting codes
Fix the underlying accounting code or automatic journal definition before reversing journal entries — otherwise the variance returns next month.
Document the reconciliation procedure
A repeatable monthly procedure prevents the variance from reappearing.
Prevention
- Lock direct posting to subledger control accounts
- Monthly subledger reconciliation as part of close
- Quarterly accounting-code audit
PRH Consulting can resolve this for you
Our finance & accounting practice handles issues like this regularly. Most engagements start with a short scoping call.