Small and medium business | Business Central, N...

Bank Account Ledger Entries not in the General Ledger

(5) Share

Report

Posted on by JE-20081519-0

3,898

Hi:

This is different from the previous question that I asked, in a way. :)

In Business Central, how is it possible for data in the Bank Account Ledger to not exist correspondingly in the General Ledger?

Too, is there a fix other than manual entries in the General Ledger?

And, is there a means of preventing this from happening again?

The General Ledger account in the Bank Account Posting Group does not have "Direct Posting" or "Reconciliation Account" enabled in the Chart of Accounts.

There is at least one third-party extension installed, yes. But, trying to find out which could be causing this issue is going down a rabbit hole.

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

OussamaSabbouh 15,188 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

In the normal world, each bank account ledger entry should have related g/l entry and they will have the same entry no., unless as you said there is an extension causing that, to be able to check, i propose to track the insertion of bank account ledger entries on the trigger oninsert and to create a table where you can check who created and at what time

Regards,

Oussama

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,790 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
Hi,
Bank Account Ledger entries are created by bank-related processes (payments, reconciliations, imports).
If a third-party extension posts directly to the Bank Account Ledger without going through standard journals, the corresponding G/L entries may not be created.
This can also happen if:

Posting routines were interrupted.

Customizations bypass standard posting codeunits.

Fix

There’s no standard automatic fix if G/L entries were never created.

As per my knowledge, you can Reverse from GL entries page and repost transactions using journals.

Or you can use configuration package to repost transactions if the volume is huge.

Suggestion

Check Preview posting and reconciliation checks before posting.

Try to check what kind of entries or is there any uniqueness in these entries

Please mark it “Verified” if it helps.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 3,424 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi John,

I don't think any third-party app would intentionally stop G/L Entries from being created, as they’re essential for maintaining transaction history. Sometimes, if the Document No. differs between the Bank Ledger Entry and the G/L Entry, you won’t see them linked in Find Entries.

You can check the G/L Registers — they’re independent of document numbers and show all postings for each document.

If the G/L Entries truly weren’t created, try manually posting through a General Journal to correct the balance. I’d also recommend having your technical team debug the posting process line by line to identify where the GL Entry might be skipped or Document No. is changed.

Lastly, confirm whether you’re checking the General Ledger before or after posting — that can make a difference in understanding what happened. If you are checking the Gen Ledger before posting, then there won't be any entries.

Hope this helps.

Aman K

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Gregory Mavrogeorgis 1,238 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

In standard BC, any Bank Account post also creates matching G/L entries. If you see bank ledger lines without G/L, it’s usually:

you’re looking at the wrong G/L (posting group changed or shared), or

a non-standard process/extension bypassed the posting engine.

What to do:

Take one example → Find entries from the bank ledger line (or check G/L Register) using the same Document No. and Posting Date.

If G/L shows up in a different account → fix is just mapping/filters.

If there’s truly no G/L → best is reverse and re-post. If it was injected by an extension, use a small corrective General Journal (same doc no./date/dimensions).

Prevent it:

Keep Bank Account → Posting Group → G/L as 1:1.

Keep Direct Posting = No on the bank’s G/L (you already do).

Audit extensions (ensure they use standard posting, not direct table writes).

Enable Change Log on Bank Ledger & G/L Entry to spot the source fast.

If you found this helpful please mark it as verified

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, Is the amount different a lot?

You can export the following details separately for comparison.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sahan Hasitha 2,683 on at

Like (2)

Report
Copy link

Link copied!

it’s possible for data to appear in the Bank Account Ledger without a corresponding entry in the General Ledger when something bypasses the standard posting process. This usually happens when a third-party extension or customization inserts Bank Account Ledger Entries directly instead of using the normal posting routines that create matching G/L entries. It can also occur if posting was interrupted, or if the Bank Account Posting Group was misconfigured during posting. Since there’s no built-in tool to automatically repair missing G/L entries, the cleanest solution is to post correcting General Journals to bring balances back in line. To prevent this from happening again, ensure all bank transactions go through the standard posting routines, review any third-party extensions that may modify posting behavior, and regularly reconcile Bank Ledger balances with the related G/L accounts to detect mismatches early.

Was this reply helpful? Yes No