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

Bank reconciliation error

(7) Share

Report

Posted on by AH-14052336-0

Hi members,

I’m encountering an issue during bank reconciliation. I have a bank statement line for $5,818.15, and the related bank account ledger entries are $4000, $1920 and $-101.85 (bank fee). The $1,920 entry shows a Remaining Amount of $101.85, so I’m unable to fully match/reconcile it (screenshot attached)

My questions:

1. What does “Remaining Amount” represent for in Bank account ledger entries, as I'm unable to find any entries

2. How can I identify where part of the 1,920 has already been used or reconciled?

Your help will be much appreciated. Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Mansi Soni 10,178 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

Can you please clarify which Dynamics 365 Product are you using like Business Central, F&O or other..?

Regards,
Mansi Soni

Was this reply helpful? Yes No
AH-14052336-0 20 on at

Like (2)

Report
Copy link

Link copied!

Hi Mansi,

We are using business central.

Regards,

Abdul

Was this reply helpful? Yes No
Mansi Soni 10,178 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Moved from Dynamics 365 General Forum to Dynamics 365 Business Central Forum for better reach.

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 10,178 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello Abdul,
Remaining Amount in the Bank Account Ledger Entry represents the portion of that bank transaction which is still open/unapplied for reconciliation or application purposes. In your case, the $1920 entry showing a Remaining Amount of $101.85 means that $1818.15 has already been applied/reconciled somewhere, and only $101.85 is still available to match.

To identify where the $1818.15 was used, open the specific Bank Account Ledger Entry and check fields such as Statement No., Statement Line No., and Statement Status. You can also review the related Bank Account Reconciliation entries or navigate through the Applied Entries/Posted Reconciliation history to see in which reconciliation the amount was consumed. Most likely, the bank fee of $101.85 was partially adjusted earlier, which is why the full amount is no longer available for matching.

https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-reconcile-bank-accounts-separately

Hope this answer will help you! If Yes, Kindly mark it as Verified answer.

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 17,676 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hello,
the Remaining Amount in the Bank Account Ledger Entries pane is basically the part of that bank ledger entry that is still available to be matched in the current reconciliation; in your screenshot, the $1,920 line showing Remaining Amount = 101.85 strongly indicates that $1,818.15 has already been matched/applied somewhere else, either to another bank statement line in the same bank reconciliation or from a previous/partial matching action. To find it, check the Bank Statement Lines side for lines marked Applied, use filters/search around the amount 1,818.15 / 101.85 / 1,920, and review/remove the existing match if needed; then manually match the statement line $5,818.15 against the three entries 4,000 + 1,920 - 101.85 = 5,818.15. If this was already posted before, open the related Bank Account Ledger Entry and check statement/reconciliation fields such as statement number/status, or look at posted bank reconciliations for the bank account. Microsoft’s docs confirm that reconciliation is done by matching bank statement lines to bank account ledger entries, and that the Applied checkbox identifies entries already matched.
Regards, Oussama Sabbouh

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,280 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Applying Payments Automatically and Reconciling Bank Accounts

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 2,544 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, Remaining Amount on Bank Account Ledger Entries shows the portion of that entry which is still not matched/applied in a bank reconciliation. So in your case the 1,920 entry already had 1,818.15 reconciled in a previous bank rec, and only 101.85 is left open. That is why the entry still shows as Open and you cannot match it fully against the 5,818.15 statement line.

To find where the 1,818.15 went, look at posted bank reconciliations on that bank account, or check the Statement No. / Statement Line No. fields on the entry itself — they will point to the bank rec that consumed part of it. You can also drill from the Bank Account Statement list.

Most common cause is someone matched part of this entry in an earlier reconciliation by mistake, or the entry was used as partial match. If is wrong, you may need to unapply by reversing the bank rec line, depending on your version.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards

Gregory Mavrogeorgis

Work: GMSOFT Limited
Blog: Inside Business Central
LinkedIn: www.linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

https://erpsoftwareblog.com/2025/06/how-to-enter-opening-bank-balances-in-business-central/

Thanks.

ZHU

Was this reply helpful? Yes No