Hello,
For the last while our AP subledger GL account and aging have not balanced.
There seems to be missing amount from the aging causing it to be out of balance. I have looked at all possible options.. ran GL reports, confirmed there was no manual entry, etc.
What other causes would there be to have an amount not in aging?
Hi RB2887,
Can you please make sure you are selecting correct dates while generating these reports (Vendor Aging/Vendor balance list/Vendor to ledger reconciliation report) that could be one of the reason of mismatch.
In addition to that, please check the following:
1. Can you check "Vendor to ledger reconciliation report from GL module" Is it showing difference between GL and AP module?
2. Please also compare your vendor aging report with vendor balance list to check if both are matching or not?
3. Did Aging Report ever match with your General Ledger account? For example, If they matched last month that means beginning balances cannot be the cause of this issue.
4. Can you recheck to print the Voucher transaction report for AP account and verify where each transaction originated, you might find some mismatched transactions.
Does the GL ledger balance with the Vendor balance list report?
I would suggest to run the reports in small intervals and identify when the discrepancy started.
Once we have a date range we can review the Posted transactions on those dates.
Thanks, Kaushik
This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.
P.S:- Please mark the answer as verified if it has helped in resolving the issue.
It is about the aging report only? Or do you have a difference in balances between the vendor transactions and the GL account?
If it is about the aging, then check if there is a settlement done with a wrong date. It might be the case that someone did create a settlement incorrect. E.g. invoice posted in October; Payment in November. If the settlement date was set to October, then there could be indeed a difference on the aging report.
You need to figure our first is your AP subledger vendor balances not matching the GL account OR is the AP subledger open balances not matching the aging.
Good morning RB2887,
Have you been able to get your issue resolved in the meantime or do you need any other help / information from the community?
Would be great if you could let us know.
Many thanks and best regards,
Ludwig
This happened to me, I went back to the prior month balance, it was in balance. Then we check the check register; match each item against the GL, this was the problem. Two of the check ere not going over to the GL this was a glitch in the system.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,771
André Arnaud de Cal... 806 Super User 2025 Season 2
Sohaib Cheema 542 User Group Leader
