A/R Aged Trial Balance does not reconcile to GL Trial balance, differs every month

I have read all of the questions on here about the reconciliation of the A/R Trial balance to the GL Trial balance.

I have run countless reports, and excel files trying to find the differences.

Things I know:  There are zero postings to the A/R GL account from anything other than the A/R sub ledger.  No adjustments, and no reverse batches.

I ran the report all the way out to end of 2018 and I'm still out of balance so it doesn't look like an aging issue.  

Invoice from sales statistics add up in the GL and in the A/R trial balance, so it is not an issue with invoices. I can't get credits to balance so  I am leaning towards an issue with the way credits and or applying them are done. Tracing down the payments is a much harder task than invoices.  

Any other ideas on reports to run, or where to look? This is a consitent issue so I'm wondering if its something ingerent in the software set up.. We are only 2 years in to using Sage 300.

Thank you!

  • 0

    Program is not the problem.  Since you only have 2 years of data, what about previous year end?  Did it balance?  What about after first month, did it balance?  When did it start?

    Go back to the beginning and run each month's trial balance and agree to GL.

  • 0

    What about prepayments?
    Also have you run the "Create GL Transactions" icon
    Has somebody coded an credit note to the AR control account rather than to an income account? So the effect on AR is a decrease but in the GL there is nil effect because the entry is Dr Debtors Cr Debtors.  The way to check this one is to export out all the credit notes, even with applications for every credit note, there should be a net negative transaction against the control account, if it is nil, there's your problem