You’re offline. This is a read only version of the page.
5
Hi, we use the bank reconciliation module, and record all cash entries as either a reconciliation transaction or a bank transaction.
(1) No variance within the Bank Rec Module:
(2) G/L account is off by $887K
(3) I know the main difference, which is a Purchasing item. HATB and G/L for AP tie. I have run all suggested fixes. If I need to book at adjusting JE to the GL, what other side do I use, since the AP subledger matches the GL?
Hello Susan B.
Since the Bank Reconciliation matches the Bank statement, you can't post anything in Bank Rec. That ties. However, the GL cash account is over by the amount of a check that you have identified. Normally when a check is posted, it credits the GL cash account (which is what you need) and debits the A/P account, but you can't hit that because that ties to GL. So you stated that you know you need to credit the GL Cash account, but want to know what GL account to debit?
What you need to do is to go to Purchasing and drill back on the check, and see what GL accounts were used. It should have credited cash and debited AP. So if it did not credit cash, see what account was credited, and that will now be the account that you need to debit or reverse out in your adjusting JE, so you can credit Cash. So look up what the original JE was when the check was posted and that will give you what account needs to be used as your offset.
Hope that helps!
Cheryl
Microsoft Dynamics GP Support
Most likely the issue is on the dates, void date specifically.
I suggest you look for a BR transaction on that amount, that had been cleared but voided after it got cleared or something like that...
But if you want a quick fix and is just looking for the GL contra account for the BR transaction, usually, you can use the same Cash account so it will only affect BR and not GL.
Have you run the Reconcile to GL for the Checkbook? (Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL.)
Was the check voided? I find the most common issue is when a check is voided that had cleared the bank and/or there is a problem with the void date versus the GL posting date.
[I'm unclear on some of your screen captures: Do they account for outstanding items? The difference in the first screen capture doesn't match the second screen capture.]
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,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (