Bank account card balance is different than the balance of the associated G/L account - how to correct?

(1) Share

Report

Posted on by Steve Simon

348

I made 4 Journal Entries to the G/L Account which is tied to my bank account, but the entries only show up in the G/L balance for that account. Thus the Bank Card is short by those 4 deposits. When I try to reverse the G/L entries, both the G/L Account and the Bank Account are affected, so the out-of-balance situation is the same. I reconciled the bank account manually. The G/L account is correctly matching the actual bank balance now. The Deposits and Payments in transit are correct. However, the Bank Account card still is off the same amount as it was before.

How do I make an entry to the bank account ledger without simultaneously making an entry to the G/L account ledger?

Thanks,

Steve Simon

PDG Consultants

I have the same question (0)

All responses (5)

Answers (1)

Thomas Tian on at

Like (1)

Report

Hi Steve,

do you mean the balance between the Bank Account and Main Account I have boxed(illustration 1) is different? just confirm when you do a GL whice one you have used, bank account or Main Account?

we usually use bankAccount, and set the associate main account do not allow manual entry to true(illustration 2).

Was this reply helpful? Yes No
Verified answer

Dirk on at

Like (1)

Report

What you can try is the following:

Set "Direct Posting" to yes/true for the G/L Account associated with the Bank Account (Bank Posting Group).

Then add a G/L Journal Line and use

a.) the G/L Account as "Account"

b.) the Bank Account as "Bal. Account".

When you post this line this should give you two G/L Entries for the G/L account (neutral / 0,00 in balance) and only one Bank Leger Entry (which should give you the desired result)

After the correction set "Direct Posting" to no/false for the G/L Account associated with the Bank Account (Bank Posting Group).

Was this reply helpful? Yes No
Steve Simon 348 on at

Like (0)

Report

Thank you so much, Dirk. It was mojo to me, but it worked. My bank account had been $2051.10 less than the G/L. I entered a negative -2051.10 against my G/L account, with the Bank Account as the balancing account. The G/L didn't change, but the bank came up + 2051.10, which was the effect I wanted to achieve. My original mistake was allowing posting to the G/L account, which is now turned off.

Was this reply helpful? Yes No
Steve Simon 348 on at

Like (0)

Report

Thomas,

Yes, my mistake was that I had set the G/L account (Main Account above) to Direct Posting Allowed. That was a mistake and caused an out of balance condition between the Main account and the Bank Account. I followed Dirk's advice below to correct the situation.

Was this reply helpful? Yes No
JSTM on at

Like (0)

Report

Thanks, Dirk, this was so helpful. My Bank account G/L was in Direct Posting Enable. My payment method was (Bal. Account Type) = G/L ACCOUNT and the (Bal. Account No.)= G/L Bank Account. That was my error setting up the payment method, it should have been a (Bal. Account Type) = Bank Account and the (Bal. Account No.)= the bank account card.

I created the G/L entry like you said:
Then add a G/L Journal Line and use

a.) the G/L Account as "Account"

b.) the Bank Account as "Bal. Account".
The number changed in my Bank Account Card, but in the G/L account it stayed the same. I was able to balance the Bank Account Card and the G/L account. However, I use Credit to balance these things, I will see how my Bank Reconciliation changes.

Was this reply helpful? Yes No