Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 423

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

  • Sarav Profile Picture
    Sarav 423 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.

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 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

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Manual Bank Account Reconciliation

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

  • Sarav Profile Picture
    Sarav 423 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 6,578 on at
    RE: Manual Bank Account Reconciliation

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

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans