Dynamics NAV Financials

account schedules, financial reporting, dimensions, budgets and all the rest of the fun, fun world of Microsoft Dynamics NAV from a (former) Controller who still uses the software every day

  • Account Schedule Examples
  • Account Schedule Formulas
  • Popular Series
  • Services
  • About

Refresh your financial reporting in the New Year

Posted: January 7, 2013 | Author: kpeters | Filed under: Uncategorized | Tags: Account Schedules, financial statement, year end | Leave a comment

newyear2013Have you looked at your financial reporting with a fresh eye lately? Is it looking a little tired, out of date, or even irrelevant? The start of a New Year is a great time to take a good look at what you’re producing every month to make sure it is the best quality financial reporting you can be giving to your end users.

One of the reasons I like NAV account schedules for my financial reporting is this tool gives me the flexibility to change what I want when I want. One of those times is at the beginning of the new fiscal year.

Here are some of the things that I look for:

  • Primary account use and classification – Look through the accounts and categories used for your balance sheet, income statement, and other primary financial statements. Are they still the main accounts being used or are you showing small balances and tiny net changes because the accounts are no longer being used as much as they used to be? If you find some of those immaterial numbers cluttering up your statements, group them together with some other logical account. This will keep your financial statements crisp, concise, and focused on the big picture.
  • Names and labeling used –  Think about the wording used on your financial statements. Many times, we call an account, or a brand, or a team one thing on a report, but throughout the year the name we actually use in the company becomes something else. If you’re paying attention through the year, you can catch up the names used on your reports to match the more familiar uses that have currently evolved in your company and instantly make your financial reporting connect with your end users by using the same language they do.
  • New accounts – The end of the fiscal year is the most likely time for companies to add accounts. Make sure to trace those new accounts through your financial statements and make sure they’re included everywhere. This should keep you from having to track down some crazy imbalance later in the year.
  • New budgeting categories – The annual budgeting process will surface all types of new needs, especially when involving operating or management reports. Make sure new budget categories have been included in your reporting, and that you’ve designed your reports to be flexible enough to report on the coming year’s forecast as well as on the prior year’s historical information.
  • Recheck formulas – As always, whenever you make any changes to your financial statements, check and double-check that you haven’t changed or broken any calculations. Spending time now to make sure these essential elements are still working is the best way to save yourself time later.

TwitterYouTubeFacebookGoogleLinkedInEmailRSS
MVP_Logo_Preferred_Cyan300_RGB_72ppi
All Stars_NAVUG(1)
400dpiLogo

Blog Stats

  • 658,420 visits

Enter your email address to follow this blog and receive notifications of new posts.

Join 474 other subscribers

Top Posts & Pages

  • Account Schedule Formulas
  • NAV AS 101 Lesson 4: Basic Elements of Account Schedules
  • NAV AS 101 Lesson 17: Budgets with Account Schedules

Account Schedules accounts payable accounts receivable aging analysis by dimensions Analysis Reports analysis views balance at date BREP budgets chart of accounts Classic Client code mandatory column layout community comparison date formula comparison period formula consolidation Convergence CustomerSource dimensions document date dual monitors due date Dynamics ERP Excel export to excel financial reporting financial statement fiscal year general ledger global glued column increase header item ledger entries JET journal entry keyboard shortcut learning Management Reporter manuals Microsoft NAV NAV 2013 NAVUG NAVUG Academy net change networking Office2013 paperless payment terms pivot table posting accounts PowerPivot productivity query tool reconciliation account reporting tool ROI row setup RTC set base for percent setup options shortcut show opposite sign SSRS tips and tricks totaling type training trial balance user group user level configuration user poll video

Blogroll

  • Microsoft Dynamics NAV Team Blog
  • Microsoft Connect
  • Microsoft Dynamics CustomerSource
  • I Love NAV
  • Microsoft Dynamics Community
  • NAVUG

Archives

  • December 2020
  • September 2020
  • November 2019
  • October 2019
  • August 2019
  • May 2019
  • March 2019
  • April 2018
  • December 2017
  • October 2017
  • April 2017
  • March 2016
  • December 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • March 2015
  • January 2015
  • December 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
Blog at WordPress.com. Mid Mo Design.
  • Subscribe Subscribed
    • Dynamics NAV Financials
    • Join 474 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Dynamics NAV Financials
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...