Share via

Bank reconciliation error

Abdul Haseeb 0 Reputation points
2026-05-14T00:30:31.74+00:00

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 below)

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?
  3. Bank rec issue Your help will be much appreciated. Regards
Community Center | Not monitored
0 comments No comments

2 answers

Sort by: Most helpful
  1. Gérard Oomens 123.1K Reputation points Volunteer Moderator
    2026-05-14T09:42:20.6033333+00:00

    Post/ask in the Dynamics forum:

    https://community.dynamics.com/

    Was this answer helpful?

    0 comments No comments

  2. AI answer

    2026-05-14T00:30:50.8666667+00:00

    In Business Central bank reconciliation, “Remaining Amount” on a bank account ledger entry is the part of the original entry amount that is not yet matched (applied) to any bank statement line in reconciliations.

    In the example:

    • Amount = 1,920.00
    • Remaining Amount = 101.85

    This means 1,818.15 of that 1,920.00 has already been matched in one or more reconciliations, and only 101.85 is still available to be matched.

    To understand and fix the situation:

    1. Because a bank reconciliation cannot be posted if a line has a non‑zero Difference, all partial matches must be cleared or completed before posting. Any lines that still show a Difference will remain on the Bank Acc. Reconciliation page after posting and must be resolved before the bank account can be fully reconciled.
    2. To see where part of the 1,920.00 has already been used, review prior bank reconciliations for that bank account and look for the same document number/description. Those reconciliations will show the earlier matches that reduced the Remaining Amount from 1,920.00 down to 101.85.
    3. If the 101.85 is a bank fee that does not yet exist as a ledger entry, create it first and then match it:
      • On Bank Acc. Reconciliation, use Transfer to General Journal to create a general journal line for the missing fee entry.
      • Complete the journal line (for example, set the balancing account) and post it.
      • Refresh or reopen Bank Acc. Reconciliation so the new bank account ledger entry appears.
      • Manually match the bank statement line(s) to the relevant bank account ledger entries (4,000.00, 1,920.00, and the -101.85 fee) using Match Manually.
    4. If the 1,920.00 entry has been incorrectly partially matched in a previous reconciliation, unmatch or correct those earlier reconciliations as needed so that the Remaining Amount reflects what should still be outstanding.

    Once the 5,818.15 statement line is fully matched and all Difference values are zero, the reconciliation can be posted.


    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.