You are using the Trial Balance reports from the sub ledgers, correct?

If you are using the AR & AP agings & inventory valuation report, it's not going to work.

I am comparing the AR and AP Agings and the Inventory valuation report to the balances on the Balance Sheet.

Make sure there are no daily transaction registers unposted. Go To General ledger > Main > Daily Transaction Register. Run that and post anything that is there. Then go back to your reports and see if the work. Remember, the aging reports work best when you are comparing current totals. To go back in time it is best to use the AR and AP Trial Balance reports.

Thanks for the help. I'll give that a try.

Also verify that no transactions were posted directly in GL that should have been posted in the subsidiary module. As was stated previously...the Trial Balance is the report to use for reconciliation

The Aging reports are NOT intended to tie to the GL Balance Sheet. You need to run the Trial Balance in each module. That is designed to tie to the GL.

Thank you for your response. I appreciate it.

Thank you for your response. I appreciate it.

A bit of a clarification on this.

The A/R trial balance and the A/P trial balance "should" agree to the general ledger at all times as long as general journal entries have not been against the control accounts. They display based on the general ledger posting dates.

The A/R aged invoice report has an option to display based on the general ledger posting dates or the invoice dates. Ideally they should be the same however, if you accidentally record an invoice that has a invoice date of 2//5/17 and post it to the general ledger on 1/31/17, the two options will give different results.

The A/P aged invoice report always reports based upon the invoice date. There is no option like there is in A/R. The A/P trial balance always reports based on general ledger posting date.

I understand why the A/P module allows for mismatched dates, but I don't really understand why A/R should allow for mismatching dates. I really wish we could get an option in A/R that would prevent (or at least warn of) mismatching dates. I would love that for checks as well.