During a new implementation of Dynamics NAV (Navision), most Dynamics NAV (Navision) consultants understand how to load in A/R and A/P beginning balances. However, when it comes to bank beginning balance. The subject is usually more murky. On one hand, you need to put in the bank balance so it shows up on the bank ledger, on the other hand, if you put in just a lump sum, doing the first bank reconciliation will be a nightmare.
The goal when entering a beginning bank balance, is to update the bank ledger to ensure the amounts are correct. In addition, the bank transactions that are not cleared needs to be come up so it can be properly reconciled.
In this example, we're going to assume the Navision client is going live on 1/1/2010.
Here's the information we need from the client:1. The G/L bank ending balance as of 12/31/20092. The last bank statement (from the bank obviously) on 12/31/093. The beginning G/L balance
First of all, the Dynamics NAV (Navision) client or the consultant needs to itemize what checks are outstanding (not cleared yet as of the 12/31/09 bank statement).
We all know that to load in beginning G/L balance, we use the General Journal. We typically use loading of beginning balance as the same step as we load in the bank balance.
Let's say the Dynamics NAV (Navision) client has the following:Bank Balance on 12/31/09: $10,000.00Outstanding Check #123: -$2,500.00Outstanding Check #124: -$500.00Deposit on Hold: $1,000.00
While we load in the beginning balance, we set the Account Type as Bank Account. Doing this will automatically update the bank ledger and the G/L ledger based on your Bank Account Posting Group.
So your beginning G/L balance would look like the following:
Assuming you received a bank statement on 1/31/2010. There were no transactions that were cleared and no additional transaction made to the bank. Your bank rec would look like the following:Doing so, the transactions will match exactly to the bank statement and to the G/L.
In conclusion, you can say that the bank beginning balance is the Bank Balance + Outstanding Checks - Deposits on hold.
Your opening sentence says it all, it's quite amazing how many Navision implementations I come across where the partner did not have a clue how to enter opening bank balances, ad so just "left them till later".
This is a great step by step to show how simple it is.
you already written for Inventory opening, Bank opening .
same way update the opening balances for A/R/ A/ P.
Thank you. Your posts are always very helpful. I remember when I started working as a Navision consultant (yes I wasn't programming the first 2 years) back in 1990 the first thing I learned was how to enter the beginning balances. But back then there was nothing such as a Bank Ledger, so I didn't even consider this before. But you have some good points.
The next topic I'm considering is a beginning balance for Fixed Assets. That's another one of those murky areas where a lot of consultants have problems with.
A/R and A/P seems questionable for topic because it's so basic. If anything, the blog about loading beginning A/R and A/P helps people that should not be implementing NAV in the first place.
Setting up beginning balances for Fixed assets would a great idea! In fact fixed assets is an area that is most often neglected by most Navision consultants. Often because they don't know how strong this module actually is.
Where shd i need to work inorder to post the Jnls for opening bal without Bal.Account No.??