Dynamics 365 Finance and Operations Fiscal Year-end Close without Multi-currency

By Sharlene Boots | December 14, 2021

interview blog 1

Year-end close is a necessary process no matter what finance and accounting solution you are using. For Dynamics 365 Finance and Operations users we have outlined the steps for you.

Below are highlights for a year-end close in D365 Finance:

  1. All Sub-ledgers should be balanced with the General Ledger and in an “On Hold” status
  2. Review your Fiscal year close parameters 
  3. Validate that you have a main account listed for your Year-end result automatic transaction. This should be your retained earnings account.
  4. Validate to make sure you have a fiscal calendar created for the new year
  5. Now we are ready to proceed to the Yearend close process and setup the parameters
  6. Run the Fiscal year end process
  7. Run or view the Close-of-year transactions report
  8. Once you have validated your final close for the year, change the status of period 12 to “On Hold”
  9. Run your Financial reports

Detail:

1. All Sub-ledgers should be balanced with the General Ledger and in an “On Hold” status

 

2. Review your Fiscal year close parameters

Navigate to General ledger> Ledger setup> General ledger parameters

There are three settings you want to pay attention to:

  • Delete close-of-year transactions during transfer
    • Set this to be Yes as it will delete the opening transactions if you decided to rerun the fiscal year close process
    • Note that you can run the fiscal year close process as many times as needed.
  • Set fiscal year status to permanently closed
    • This should be set to Noas it would close all the periods in your prior fiscal year, which would prevent you from making any transactions in those periods again.
  • Voucher number must be filled in
    • It is considered best practice to set this to Yes so you can recognize the opening transactions in your trial balance and other GL reporting.

blog 1

 3. Validate that you have a main account listed for your Year-end result automatic transaction. This should be your retained earnings account.

Navigate to General ledger->Posting setup->Accounts for automatic transactions

blog 3

4. Validate to make sure you have a fiscal calendar created for the new year (2022 in this case). If the new year is not there, then create one by clicking on New Year and populate the fields. See print screen below. 

Navigate to General ledger->Period close->Fiscal calendars

  • Note, when you create a new year, all the periods with have a status of “Open”. Put the periods on a “On Hold” status via the Ledger Calendars, as needed.

blog 4

    5. Now we are ready to proceed to the Yearend close process and setup the parameters

Navigate to General ledger->Period close->Year end close

  • Click New -> Enter a Group Name -> Enter a Fiscal Calendar -> Click on Save
  • Add Legal entities that you want to include in the Group
    • There is a new feature where you can select multiple legal entities when running the fiscal year close process.

blog 5

  • Setup how you want the financial dimensions posted for Balance Sheet accounts and P&L Accounts
    • Best practice is to have Transfer balance sheet dimensions = Yes
    • Close Single – Retained earnings account closes to 1 number for that dimension
    • Close All – Retained earnings account closes to every combination for that dimension

blog 5b

6. Run the Fiscal year end process

Click on Run fiscal close -> Check the Legal entities to be included in the closing -> Click OK

blog 6

Enter the Fiscal year you are closing -> Enter a Voucher # -> Batch processing = Yes -> Click OK

blog 6b

 7. Run or view the Close-of-year transactions report

Navigate to General Ledger->Inquiries and reports->Period end reports->Close-of-year transactions report

Example shown below.

blog 7

8. Once you have validated your final close for the year, change the status of period 12 to “On Hold” for the Legal entities you ran the closing process for.

Navigate to General ledger->Period close->Ledger calendars

blog 8

If you need help with year-end close or getting the most from your Dynamics 365 Finance solution, reach out to our team!

 

Related Posts

Recommended Reading:

6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Organize and Prioritize Your Resources with Dynamics 365 Field Service

As a manager, Dynamics 365 Field Service lets you optimize the use of your employees, their skillsets, and other resources […]

Read the Article

Stoneridge Software Cracks the Top 20 on Bob Scott’s Top 100 VARs 2022

Stoneridge Software is ranked at #20 on Bob Scott’s Top 100 VARs for 2022. Each year, industry publisher, Bob Scott, […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X