Finance | Project Operations, Human Resources, ...

Bank Reconciliation Module Does Not Tie to G/L

(0) Share

Report

Posted on by Susan B

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?

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Suggested answer

Cheryl Waswick on at

Like (0)

Report

RE: Bank Reconciliation Module Does Not Tie to G/L

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
Leng Papio 855 on at

Like (0)

Report

RE: Bank Reconciliation Module Does Not Tie to G/L

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.
Suggested answer

Lisa at AonC.com 3,143 on at

Like (0)

Report

RE: Bank Reconciliation Module Does Not Tie to G/L

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.]