Why does my General Ledger balance not tie to the subledger?

Discrepancies between the General Ledger (GL) and subledgers are relatively common. One of the most frequent causes is manual journal entries posted directly to the GL that are not reflected in the related subledger or schedule.

Common Scenario

If the Deferred Revenue balance on the Balance Sheet doesn't match the Deferred Revenue schedule, it's often due to manual journal entries made directly in the GL. Since these entries bypass the subledger logic, they will not appear in the schedule, leading to a mismatch.

To identify the cause of the discrepancy:

To pinpoint the issue:

1. Export the Deferred Revenue GL detail from the Account Register.

2. Filter the export by Manual JE Source.

3. Review the entries to identify manual journal entries that may be causing the variance.

This approach will help you isolate the differences between the General Ledger and the subledger.