Entering Beginning Bank Balance for Dynamics NAV (Navision) for a New Implementation

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/2009
2. The last bank statement (from the bank obviously) on 12/31/09
3. 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.00
Outstanding Check #123: -$2,500.00
Outstanding Check #124: -$500.00
Deposit 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:

Beginning Entry for Bank Balance for Dynamics NAV
Beginning Entry for Bank Balance for Dynamics NAV

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:
BankRec
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.

6 thoughts on “Entering Beginning Bank Balance for Dynamics NAV (Navision) for a New Implementation

  1. Samuel says:

    Hi Alex,

    I don’t think this is right. If we enter 12,000 as a beginning balance instead of 10,000, then during the first Bank Rec you have described we would have 2,000 difference if we clear 12,000 vs 10,000 Bank Statement Balance. Isn’t it?

  2. Steve Pena says:

    Hi Alex,

    Have you ever started Bank Recs on a NAV install that has been live for several years? Do you have any pointers on doing so?

    I imagine I need to bring in ALL transactions and clear everything, except for what was uncleared on the most recent statement. I’m not sure what to do after there. I’m going to test with a Cronus company but thought I would reach out as well.

    Thanks!

    Steve

  3. Pingback: How to Enter Beginning Bank Balance for Dynamics 365 Business Central v18 and Above - Confessions of a Dynamics 365 Business Central Consultant

  4. Pingback: Find out how to Enter Starting Financial institution Steadiness for Dynamics 365 Enterprise Central v18 and Above – Ahosti – Latest IT News Trends

  5. Pingback: How to Enter Beginning Bank Balance for Dynamics 365 Business Central v18 and Above - Microsoft Dynamics NAV Community

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.