Running a Year End in Microsoft Dynamics NAV

The Microsoft Dynamics NAV year end process helps to make the closing off of your income statement a little less painful.

This blog post will run you through the basic process of running a year end in Microsoft Dynamics NAV, followed with the year close.

Close Year:
First up, we will need to check the already closed dates, search and open the “Accounting Periods” page and run down the list. You should see that the year just past still shows up as open, but previous years are all closed.

You also want to confirm that there are months filled in for the coming year.

Next, press the “Close Year” button at the top of the Accounting Periods Screen.  This will lock the year and prepare it to be transferred to retained earnings.

Running a year end in Microsoft Dynamics NAV image1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Create Retained Earnings Journal:
1. Search for “Close Income Statement”.

2. On the screen that opens, check the end date of the year to be closed.

3. Fill in the template of GENERAL and the batch of DEFAULT. Check that this batch in the general journal is empty so that you don’t mix up with these new transactions.

4. Fill in the GL account number for Retained Earnings in your GL.

5. Lastly, specify any Dimensions that need to be included in the close. If you have any GL accounts set to “Dimension Mandatory” in your income statement or the retained earnings account, you will need to include that dimension in the list of close dimensions (otherwise the system will not let you post your close journal). You should also include any dimensions that you use in income statement financial reports so that the report will tie up with the new GL values.

6. Pressing the “Ok” button will create the journal.

Running a year end in Microsoft Dynamics NAV image2

 

 

 

 

 

 

 

 

 

 

Posting the journal:
Next, head over to the General journal and check the created journal.  You should run a test report and ensure that you are happy with the retained earnings amount. Then post the journal.

Dates with a “C”:
All entries created with this batch will have a rate starting with a “C”. These show that they are closing entries and also allow financial reports to exclude the closing entries.  This could allow you, for example, to run income statement reports across multiple years and exclude the closing entries.

Running a year end in Microsoft Dynamics NAV image3

 

 

 

 

 

 

Changing a closed year:
In some circumstances you may need to change entries in a closed year.  If possible, you should post them on the first day of the new year.

If you do post to a closed period you will need to re-run the close income statement portion to transfer any balances to the retained earnings account.

This blog was written by Neville Foyn, Lead ERP Consultant at EBS.

 

If you have out-dated business software that’s limited in its reporting and analytical capabilities – then you should to talk to EBS about a powerful business management software solution – Microsoft Dynamics NAV. To find out more about Microsoft Dynamics NAV or other Microsoft business management software solutions, please call Paul Woods at EBS for an obligation free discussion on 1300 303 973, email info@ebsys.com.au or visit ebsys.com.au

Microsoft Dynamics NAV is global enterprise resource planning (ERP) software that helps more than 100,000 companies worldwide manage their accounting and finances, supply chain, and operations. Start with what you need now, and easily adapt as your business needs change. In the Microsoft cloud or on your servers—the choice is yours.

Evolution Business Systems (EBS) specialises in business management solutions that give you the freedom to focus on your business. Melbourne based EBS does this by automating your core business processes and integrating your specialist business applications to deliver the right financial management solution. With deep expertise in leading financial applications including Microsoft Dynamics NAV, EBS works beside clients to ensure their software solves problems rather than creating more. EBS has a detailed implementation strategy that is tailored to customers in terms of timelines, requirements, risks and responsibilities.

Subscribe here to get our free EBS monthly enewsletter to get valuable blog articles from EBS and the latest updates on Microsoft Dynamics NAV.