web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Manual Bank Account Re...
Microsoft Dynamics NAV (Archived)

Manual Bank Account Reconciliation

(0) ShareShare
ReportReport
Posted on by Sarav 443

Hi All,

The entry in Bank account ledger entry is made as a single sum entry for the Bank charges (eg. 1000 = 100,400,500) by the accounts team but in the bank statement it is three different individual entries.

I'm importing a Bank statement into Bank Account reconciliations and then trying to manually match 3 entries to 1 entry in NAV but it is matching to the first single entry only.

Is there anything I'm missing or any alternative to achieve it. Kindly provide your valuable suggestions.

*This post is locked for comments

I have the same question (0)
  • ManishS Profile Picture
    ManishS 86 on at
    RE: Manual Bank Account Reconciliation

    How are you manually matching, are you selecting one by one entry or what ?

  • Sarav Profile Picture
    Sarav 443 on at
    RE: Manual Bank Account Reconciliation

    Hi Manish Sharma,

    Bank statement lines - LEFT SIDE

    Bank Account Ledger Entry - RIGHT SIDE

    In my left side, I select multiple records and the records get highlighted and then I click the particular record on right side and click on 'Match Manually'.

  • ManishS Profile Picture
    ManishS 86 on at
    RE: Manual Bank Account Reconciliation

    I dough it will work, rather than try selecting one by one.

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,004 on at
    RE: Manual Bank Account Reconciliation

    Hi Saravanan,

    it works other way round - having multiple entries in NAV with matching single entry in the statement. In you case you just need to match one of them from the statement side (for example the first one) to the NAV side. System will generate the 'Difference' on this matching (-900), but the other two entries will have the difference of 400 and 500, so in total the Difference will be zero. System will allow to process (post) such statement.

    Hope that helps.

    Robertas

  • Sarav Profile Picture
    Sarav 443 on at
    RE: Manual Bank Account Reconciliation

    Hi Robertas,

    Thanks for the info. As you said, the value in the Difference of first row and the sum of the difference in the rest of the rows matches but isn't it required to match / Apply the entries to both the sides like offsetting.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans