Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
What do i do in my next bank reconciliation if the closing balance as per bank statement is different from Nav.
This shouldn't be the case normally, because the Ledger Entries of the Bank Account should reflect the statement always.
You are able to amend the ending balance of the last statement in the top of the Bank Reconciltiona-page.
What do I do if the closing bank statement in Nav is more than the actual bank statement balance?
How do I import bank statements into Navision?
I am giving you a brief process which should start you up.
The first process is to check that your G/L bank balances match with Sub ledger Bank balances (This is a must as the bank recon is done with the Sub ledger bank balances). Correct them first if they are not matching (normally errors come due to some one tampering the posting groups)
The second step is to go to General ledger -> periodic routines --> bank account recon which will open up a screen.
In the bank account number put the bank which you want to reconcile.
In Balance last statement, the amount should be previous period of the bank's statement. (you can go to bank card to put this amount first time).
In statement ending balance, put the closing balance of the bank;s statement for which period it is being reconciled.
Now we come to the reconciliation part in the lower part of the screen. There are two methods here, but I suggest using the Function ->Suggest lines.
When a screen pops up, put the starting date. As a rule the beginning of when you installed the system (this helps in pulling all the open items if any unreconciled in previous periods) is the date that is put. Ending date is usually the last date of the bank's statement for which recon is being done. in include checks put a tick.
Upon OK, all the open (unreconciled) items will be brought on to the screen. (Note: when the system brings it on the screen, it tick marks all the entries as applied in anticipation that everything will be reconciled. So it is your task to remove which is not to be applied). Just a couple of definitions before we proceed.
Statement Account column - represents amounts in bank statement
Applied Amount column - represents system's bank account.
Difference - represents differences if any (at the beginning it will all be zero) that will later on be posted as a General journal when you do reconciliation.
Applied entries - These all will have to be 1. Otherwise the system will not allow you to post.
Total Balance - The value all the amounts applied. This should match finally with the Ending balance statement of Bank which was entered above.
Let us now get back to reconciliation.
Now you have to amend the reconciliation. First delete all those lines which are not yet appearing on the bank statement. (Thus, if you have issued a check for 50$ and it is not reflected in bank statement, but will be displayed above delete the line). Second add fresh lines for bank charges/interest which appears in bank statement but not in the list above. Third is reflect the correct bank's statement amount in the Statement balance (You may have deposited a cheque for 100$, but the bank statement shows 96$ after deducting charges. So the statement amount column should be changed to 96 and there will be a difference of 4).
Once you adjust the statement amount line by line, the reconciliation statement will be nothing but a mirror image of your bank statement with the ending total balance at the bottom of the screen matching your bank statment.
Then go to Function and select transfer to general journal. Select the appropriate template and batch. (NOTE: Please ensure that the journal at
the receiving end is blank as it may overwrite an existing unposted journal there). Say OK. All the differences will be transferred to the general journal along with the bank account number. Verify and post the general journal. When you come back to the reconciliation statement, the difference column should all be zero (as you posted those entries through G/L).
Click the Posting Button. This should generate a reconciled statement which can then be viewed from General Ledger -> reports- Bank reconciliation. Fill in the filters and you should have the bank recon. statement.
Hope this helps
Business Applications communities