Bank GL account VS Bank Account Ledger Entries

(1) Share

Report

Posted on by LABoo

Is there a reason why the Bank GL account and Bank account ledger entries (while doing bank recon) does not match?

From what I understand, the bank recon module in Dynamics Nav reconciles bank statement lines against the bank account ledger entries.

For example I have a transaction which posted a debit and a credit of the same amount in the Bank GL but the debit amount shows up in the bank account ledger entries side of my recon. Should be zero or both transactions appear.

All responses (4)

Sort by

Amit Baru 3,037 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Bank Rec is used Bank Account Ledger Entries for compiling the Bank Statement.

Regards

Amit Sharma

www.erpconsultors.com
Verified answer

Dallefeld 229 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

The reason that these can be out of sync could be caused by the GL account not having direct posting turned off. With the direct posting set on, users can enter and post transactions directly to the GL account, thus bypassing the bank account ledger.
YUN ZHU 99,611 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I agree with Kim.

As shown in the image below, you may not have posted to the GIRO of the bank account, but posted directly to LCY2. This can result in inconsistent amounts.

Hope this helps as well.

Thanks.

ZHU
AndrewThomas81 532 on at

Like (0)

Report
Copy link

Link copied!

Bank account ledger entries are used when performing the bank account reconciliation.

If you have a discrepancy to the general ledger account for the bank account posting group, then it is likely you have direct postings to the general ledger account. You will need to identify these and reverse them.