FAQs: Year-End Closing in Dynamics NAV

by | Updated January 16, 2019 | Dynamics 365 Business Central, Dynamics NAV, Financials

The steps required to close a fiscal year in Dynamics NAV are relatively simple.  First, accounting periods need to be closed via the “Close Year” function on the “Accounting Periods” page.  Secondly, a journal needs to be created via the “Close Income Statement” process. The closing general journal that is created should be reviewed, then posted. If no future entries need to be back-posted into the closed year, then the process of closing your income statement into retained earnings is complete. Below I’ve listed some frequently asked questions (FAQs) that seem to come up each year as our customers conduct the closing process.

9 FAQs for Year-End Closing in NAV:

1:  Does closing accounting periods restrict users from posting into those “closed” periods?

Actually, no. Closing the accounting periods is a way of letting NAV know that you are ready to run the “Close Income Statement” routine for the most recently closed year. Closing accounting periods in no way restricts users from making postings into these closed periods. Instead, use the general ledger setup and/or user setup’s posting date restrictions to restrict users from posting into the closed fiscal year.

2:  Do I close accounting periods one month at a time?

No. In NAV, all periods within the fiscal year are closed at the same time when you run the “Close Year” function from the “Accounting Periods” page. Periods in NAV are not closed per month.

3:  What do I do if I need to make additional back-postings to a closed year?

Open the posting date restriction up for your user setup record so that you are allowed to post into the closed year. Next, make the necessary back-postings. If any of these postings hit income statement accounts, you’ll need to re-run the “Close Income Statement” routine again to wash these back-postings into retained earnings. Note that all G/L entries posted into a closed year will have a checkmark in the “Prior-Year Entry” field so that you can later run a report filtered to only back-posted entries.

4:  Why does NAV put a “C” in front of the posting date it assigns to the closing journal?

NAV posts the closing entries with a fictitious date that resides one day after your fiscal year ending date and one day before your next fiscal year starting date.  For example, if you operate under a calendar year, NAV will post the closing entries on C12/31/XX rather than 12/31/XX.  NAV posts the closing entries on this “C” date so that you can utilize a setting that can be found throughout NAV called “Include Closing Entries”.  This feature allows you to be able to include/exclude closing date postings when running reports and pages that display financial data.  So, for example, you could run an income statement as of 12/31 or C12/31 to get a “before” and “after” snapshot of the data pre and post close.

5:  Should I close by dimension?

Closing by dimensions allows you the ability to close your income statement accounts into retained earnings more granularly (by dimension).   Closing by dimension can result in a dramatically larger closing journal, especially if your company utilizes many dimensions.  However, the upside of closing by dimension is that the posting will not only result in closing of the income statement by G/L account balance, but it will also do the same for each G/L Account/Dimension combination.  For example, a company that closes by dimension can later run an income statement for a single department (dimension) and show a zero dollar balance per income statement account per the single department.

6: Why didn’t NAV close out all of my income statement accounts?

NAV will close out all G/L accounts that have an “Income/Balance” value of “Income Statement”.  Prior to starting the closing process, it is very important to check the entire chart to make sure that all income statement accounts are marked as “Income Statement” and all balance sheet accounts are marked as “Balance Sheet”.  Failure to do so can result in income statement accounts that NAV doesn’t close or worse yet, balance sheet accounts that get washed into retained earnings.

7: NAV seemed to have double closed my income statement accounts.

The double closing of the income statement occurs when the “Close Income Statement” function is run twice by accident.  In such cases, the general journal’s closing entries are repeated a second time in the closing journal.  Failure to notice these duplicate entries (and remove them) will result in a double set of closing entries being posted.

8:  Why do my account schedules stop working when I run financial reports in the new fiscal year?

NAV’s account schedules count on there being accounting periods setup in the “Accounting Periods” page so that they can, for example, translate “period 1” = 01/01/15..01/31/15.  So, as a general rule, each year when running the “Close Accounting Periods” function, you should also run the “Create Year” function as well (to create next year’s periods).

9: Will I be able to review the closing general journal prior to posting it?

In most cases, the answer is “yes.”  Most of the accountants I work with like to review the closing general journal batch prior to posting it. It’s a good idea to check the posting dates and dimension values within the journal  (see number 4 and 5 above).  I’d also advise confirmation that all of your income statement accounts are accounted for within the batch (see number 6).

However, if your company happens to be maintaining an additional reporting currency, NAV will go ahead and post the closing batch automatically and you won’t have a chance to review the journal prior to posting. If you are unsure of whether or not your organization is using an additional reporting currency, you can check the “General Ledger Setup” page which holds the “Additional Reporting Currency” field. Depending on what version of NAV you are running, if you are using an additional reporting currency, you may have to temporarily remove any dimension value posting rules you have in place on your retained earnings G/L account until after the closing posting is complete.

Since the “General Ledger Setup” page is unique per NAV company, keep in mind that your organization may be tracking an additional reporting currency in some companies but not in others.  Thus you may see different results when closing across different companies.

 

*This post was written for Dynamics NAV but the content directly applies to Dynamics 365 Business Central, which is the cloud product based on Dynamics NAV. 

Related Posts

2 Comments

  1. Bibi

    Hi,

    I just need clarity on the following, when doing the year end procedure for example for the year 2016, does it have an effect on 2016 production jobs that have not been closed?

  2. Brandon Carmichael

    Hello Bibi:

    I’m not completely sure if you are asking about NAV’s jobs or NAV’s production orders.

    Either way doing the fiscal year close will simply move income statement general ledger balances into the retained earnings account. If you are calculating and posting WIP related to NAV jobs, then those processed can be run at the end of the month as you normally would, but closing the income statement won’t impact these jobs. Hope this helps.

    Thanks,
    Brandon

Submit a Comment

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

Upcoming Events

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

02sep12:00 pm12:30 pmBest Practices for Work Order Planning and Routing for Field Service Companies

09sep10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

09sep12:00 pm12:30 pmOverview of Microsoft Promotion for NAV and GP Clients

10sep11:00 am12:00 pmConfab with Stoneridge - Livestream - Field Service Comparisons

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

16sep12:00 pm12:30 pmHow to Upgrade to Dynamics 365 Finance and Operations: Examining Custom Code and ISV Implications

16sep2:00 pm2:30 pmScheduling and Dispatching for the Modern Field Service Company

23sep12:00 pm1:00 pmDynamics 365 Business Central Wave 2 Release Preview - An Overview of the Most Exciting New Features Coming in October

24sep11:00 am12:00 pmConfab with Stoneridge - Livestream - The Modern Workplace: Teams, Sharepoint, Outlook, Office, and AI Integration

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

30sep12:00 pm12:30 pmEmpowering Your Field Service Technicians with a Mobile Solution

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Orders

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X