Sub ledgers don't match financial statements

I am new to Sage.  I am reviewing books for a client and find that none of their sub ledgers (A/R, A/P or Inventory) match the financial statements.  In QuickBooks I know how to trouble shoot these; but not so in Sage.  Can someone point out the common mistakes clients make when recording transactions in Sage that create these discrepancies?

  • 0
    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.
  • 0 in reply to Helium
    I am comparing the AR and AP Agings and the Inventory valuation report to the balances on the Balance Sheet.
  • 0 in reply to JanT
    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.
  • 0 in reply to mvz
    Thanks for the help. I'll give that a try.
  • 0 in reply to JanT
    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
  • 0
    You should be working with your reseller. If you are new to Sage 100 it is best to have someone on hand to walk you through how to research so in the future you can do on your own. What is the open year and period on the modules?
  • 0 in reply to JanT
    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.
  • 0 in reply to BigLouie
    Thank you for your response. I appreciate it.
  • 0 in reply to JanT
    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.