Daily users of Microsoft Dynamics NAV (Navision) or Microsoft Dynamics 365 Business Central have their routines down to a science, especially their month-end and year-end close procedures. But what if there were tips and tricks they could learn that would make their job much easier?
In this article, we’ll cover insights to help you streamline your tasks in the following areas:
If you’d rather, you can watch the webinar outlining the tips and tricks here:
Preparing for Year-End close and optimizing your process starts with familiar month-end closing tasks, such as:
There are several tricks to make the process even more seamless.
Managing User Tasks: Business Central has an out-of-the-box solution to help you and your users remember what needs to be completed. These user tasks can be found on the Business Central Dashboard. Here, you can create tasks to remind you what needs to be done. You can create them for yourself and assign them to other users or a user group. You can also have tasks assigned to you by other users in your company.
You’re required to fill in primary fields to create the task, such as subject and user assigned to. Additionally, you can add a link to a task and link a task to a report or page.
You can set these tasks to recur, saving you from having to create a new one for every month-end close. Use the recurrence button at the top of the page and define the start date recurrence. This will create alerts on the Business Central main page.
To run the report from one of these tasks and mark it complete, when you click on the task, go to ‘Task Item’. This will open the ‘Report Options’ page. Run it as you normally would. It will bring you back to the user task. There, you can use the ‘Marked Completed’ button or enter one hundred percent in ‘Percent Complete’.
When you back out of the page, the task will be marked as completed.
Managing Posting Periods: Closing the year doesn’t prevent users from posting to closed periods in Business Central. Users can post to any date if there’s no restriction. Additional configuration is required to ensure users only post to specific periods.
To use General Ledger Setup:
These posting periods apply to the company and to all users. Any date outside of the range is restricted and you'll get an error message.
You may also need to allow certain users to post in a prior month. User Setup can be used for exceptions. You can define different posting periods for specific users. These posting periods override those specified in the General Ledger Setup Page, which can be useful for audit entries that have to be made after closing.
Creating a New Year: Since you've restricted users to a new period, you need to create the new year. To do this quickly and automatically:
The fiscal month length in this case is '1M’ for monthly.
The New Fiscal Year field indicates the month your fiscal calendar year starts.
It’s best practice to have two fiscal years open at a time: the current year and the next year. This will help with deferrals or projections done for fixed assets. However, Business Central only requires one year to be created before it will allow you to close a fiscal year.
Also, you can have ’4-4-5' accounting periods (4 week/5-week period lengths). This divides a year into four quarters of 13 weeks, each quarter would consist of two four-week months and one five-week month. With this type of business process, you’d have to enter them manually in the accounting period table. So, the above process wouldn’t be helpful in this case.
Next, let’s look at how to process the year-end close.
It’s recommended to close your year on time. The close process can’t be reversed, so you won’t be able to reopen the year. But that doesn’t prevent a user from posting to a closed year. If you have any audit or post-close entries, they’ll be labeled in Business Central as a post-close entry.
When a year is over, you must close the periods that define it. To do this, you run the ‘Close Income Statement Batch’ job. To access this, go to the Chart of Accounts and under ‘Process’ select ‘Close Income Statement’. This transfers the year’s results to an account in the balance sheet and closes the income statement accounts. It’s the formal process of zeroing out your profit and loss accounts and moving the amounts to retained earnings.
Close Income Statement Batch will close accounts where the GL account type is ‘Income’. If accounts are set as ‘Balance Sheet’, the process will be off.
Business Central does make this more user-friendly and will create a general journal entry for you. But you still need to review and post this entry.
In the Close Income Statement option window, there will be fields to fill out. You must:
Once posted, you have completed your year-end close in Business Central.
To make it easier to work with the closing entries, try these reporting and analysis tips.
Data Filtering Options:
You can use the GL Account Balance list from the GL account card or the Detail Trial Balance report. As an example, you can use the option fields presented in Detail Trial Balance to simply include or exclude closing entries with a click.
How can you identify closing entries? You can use the Date Filter and specify the closing date format, such as: C12/31/2021, to search for entries with this date.
How can you tell if something is a post-close entry? When entries are made later in the general journal, after you close the year, there will be an indicator on the underlying table that will mark it as a prior-year entry. You can search for this on the GL entry table. To view it, you need to use Page Inspection, a tool that allows you to see what page and table make-up you’re looking at.
For example:
Which pre-close year-end reports are most helpful? First off, when dealing with accounts payable, two great reports are:
Aged Accounts Payable Report, which shows which payables are current, past due and potentially reaching delinquency. You can use this information for either investigating, following up on or reversing by credit memo any past-due posted payable. You can filter this report by vendor posting group and use those totals to reconcile the sub-ledger account payable balance to the corresponding payable balance in the GL.
What are the reporting options?
Reconcile AP to GL Report shows anything that has been received through purchase orders but has not been invoiced. These items will consequently not exist in your general ledger because the invoice amounts have not hit the GL.
Microsoft NAV and Microsoft Dynamics Business Central make every day processes, especially year-end close processes, faster and easier. Knowing all the tips and tricks speeds up the process and makes tasks easier to execute.
For more tips on how you can become more efficient using Microsoft NAV and Microsoft Dynamics Business Central, go to the next blog in this series, Microsoft Dynamics Year-End Close: US Payroll Edition (coming soon!).