55
Hello-
For the past few weeks, our AR GL and Subledger are off. I have never handles balance these accounts, what are best practices to find these variances and balance? I have posted all batches. Reconcile to GL does not seem to be working, or maybe I am approaching that wrong. Any help would be greatly appreciated.
I have the same issue with inventory, but not as bad.
Thank you
Hi Justin,
Thank you for the prompt response. I was running aged trial balance with options. Reports > Sales > Trial Balance > Aged Trial Balance w/ Options. I will run the HATB instead. I will also review the links you sent and see what I can piece together.
Thank you again for the help.
Hello Brownmed,
To start off, what are you using to compare AR to the GL?
Sometimes the problem can come down to simply using the wrong report to balance to the GL. Usually we see this in Inventory where users attempt to use the Historical Stock Status Report instead of the Historical Inventory Trial Balance report.
You already have noted one of the best tools for the job, which is the Reconcile to GL. The problem with that tool is that users expect it to be a full reconciliation, rather than a tool to help you reconcile the correct report to the GL.
For AR, you will want to be balancing the GL TB and RM(AR) HATB.
I would start with reviewing the link below, then using the Reconcile to GL tool to see if it helps you notice anything obvious:
support.microsoft.com/.../information-about-differences-when-you-reconcile-general-ledger-to-pay
Hopefully the community has some other tips and tricks to make this process easier.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (