ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Clients First Business Solutions

Microsoft Dynamics NAV (Navision) Year End Closing Procedures


Email | Print

Microsoft Dynamics NAV Year End Closing

It's that time of the year again as we are in the middle of the 4th quarter for many companies.  Below is our short check list for you to quickly and efficiently close your Microsoft Dynamics NAV (formally known as Navision) ERP Software.  Feel free to contact us if you have further questions on this.

 

Clients First Microsoft Dynamics NAV – Year End Checklist

  1. Post All Open Journals – Payments, Deposits, Cash Receipts, Payroll.
  2. Post Recurring Entries for the year to be closed
  3. INVENTORY RECONCILIATION – As of End of Fiscal Year DateINVENTORY REVALUATION - Depending on your Industry – or to correct errors, you may be able to re-value inventory as part of the year end process.  Now is the time.
    1. Run the Adjust Cost Routine
    2. Run the Post Cost to G/L Routine
    3. Run the Inventory Reconcile to G/L Report – By Inventory Posting Group
    4. Tie the Received Not Invoiced Posted to G/L to your Inventory Accrual Account (Liability)
    5. Tie the Shipped Not Invoiced Posted to G/L to your Accrued COGS Account (Contra Asset)
    6. Tie the Net Inventory Interim Posted to G/L to your Inventory Interim Account (Asset)
    7. Tie the Inventory Posted to G/L  to the Inventory Asset Account
  4. ACCOUNTS RECEIVABLE RECONCILIATION -Tie the Customer Trial Balance Report to the A/R Account – By Customer Posting Group (This report ties to the G/L – Aged A/R may not tie if you use Foreign Currency)
  5. ACCOUNTS PAYABLE RECONCILIATION - Tie the Vendor Trial Balance Report to the A/P Account – By Vendor Posting Group (This report pies to the G/L – Aged A/P may not tie of you use Foreign Currency)
  6. FIXED ASSETS - Calculate Depreciation and Post Depreciation to the G/L
  7. MANUFACTURING - Complete all “Finished” Production Orders and reconcile WIP values
  8. BANK ACCOUNTS - Reconcile each Bank Account using the Bank Reconciliation Module.  Compare the Book Values to the Chart of Accounts for each Bank Account Posting Groups G/L Account
  9. MULTI-CURRENCY
    1. Enter the Currency Conversion Rates that will be used for gain/loss valuation at the end of the fiscal year.
    2. Run the Gain / Loss conversion routines – One Currency at a time – for Customers, Vendors and Bank Accounts.
  10. LOCK OUT POSTING TO YEAR THAT WILL BE CLOSED
    1. Change the Posting Dates in G/L Setup
    2. Check User Posting Setups – Only Set Values for users that are Exceptions
  11. YEAR END CLOSE
    1. Verify that the upcoming Fiscal Year calendar exists in the Accounting Periods setups, and that it is correct. If it is not there, or not correct- create the periods for the next year or two.
    2. Close the Accounting Periods for the Year to be closed
    3. Close the Income Statement – By Dimension
    4. Open the General  Journal and Enter the Retained Earnings Account(s), Post the Closing Entry using a Closing Date
    5. Verify the P&L Accounts have zero balance for new Fiscal period.
  12. FINANCIAL STATEMENTS AND BUDGETS - Create the Budget for the upcoming Fiscal Year – following your organizations business rules.
    1. Run the Year End Balance Sheet
    2. Run the Year End Income Statement
    3. Run any Statements of Operations
    4. Run the Trial Balance Report and verify balances
    5. Run Statement of Cash Flows

 

 

 

Ask This Expert a Question / Leave a Comment

 

 
 
Live chat by BoldChat