Data Analytics and Microsoft Management Reporter – The Art of the Possible

by | Mar 20, 2020 | Dynamics GP, Management Reporter

Management Reporter - the Art of the Possible

My introduction to the financial reporting opportunities within GP Dynamics came from the old FRx platform. I was given a five-minute lesson on how-tos and sent on my merry way. I practiced and perfected the skills needed to build, produce and schedule financial reports that were timely and relevant. But I always felt like I could do more.

I worked in a mid-size company with a moderately resourced accounting department. We closed the month, produced high-quality financials and got through year-end audits unscathed. We were also the impromptu finance department as well, so a colleague and I started working to develop ad-hoc reports with our operations leadership team. We wanted their feedback. We included charts, graphs, statistics and dashboards, anything to get their attention. While a lot of it failed to impress, some of it stuck and became an integral part of their managerial tools.

I had grown weary of sending reports ten days after our month-end when there was no way to incorporate mid-month strategy to improve results. I wanted the numbers to allow leadership to be proactive instead of reactive. We had smart people running the business who were not getting the full picture.

Today, I have seen the power of what an effective financial analysis and planning (FP&A) department can have. There are tools today that slice and dice the general ledger into a storyboard and uncover trends that can change the trajectory of earnings and turn a poor month into a winner.

But those are expensive tools that not all organizations can afford. That doesn’t mean you just give up, you just have to work with the applications you already have in your toolbox.

FRx eventually gave way to Management Reporter, which currently is the report writer application for GP Dynamics. While it lacks the slick functionality of the Power BI solutions on the market, it still has a vast area of untapped potential.

When I consult with a client, I want them to take on a new thought process, I call it the “Art of the Possible.” What can I create in Management Reporter that would give a fresh angle on our business? I preached on many occasions to controllers and senior-level accountants to stop being a bookkeeper and take on the deeper role of an analyst.

So how can you marry the two? How can you take a creative approach to using a standard piece of Microsoft functionality in the Management Reporter (MR) platform?

1. Step Out of Your Comfort Zone

I have been an accountant for 32 years, I know the comfort of debits and credits and balanced ledgers. Go further, starting creating new scenarios in MR that produce analytics. How much does our warehouse pay for monthly utilities by the square foot and how does that compare to plan? You can produce that easily with a calculation within MR. Start thinking of the numbers as holding tiny keys to a myriad of business decisions and see what your creative mind dreams up.

2. Listen to Your Leadership

Have discussions with your operations leadership team. What metrics do they look for? Do they do calculations based on the information they are provided already? If so, build those in your report formats. Build in a chart or graph. You will be surprised at how much respect the accounting team will get when they attempt to better understand some of the thoughts behind daily business decisions.

3. Realize that Dashboards are Your Friend

Dashboards quickly become the craze, busy leaders want to see key performance indicators (KPIs) on a daily basis. Build them something, you can create a report that is automatically generated and waiting for them on their desktop every morning. They can view their KPIs along with their morning coffee.

4. Include as Many Statistics as Possible

Search high and low for measurables – hours worked, acres owner, square feet included, gallons used from a water invoice, property tax per location. Dig through your files and invoices and start accumulating data. If you add this information into statistical accounts in GP Dynamics, there is no limit to your analysis.

5. Utilize Budgets, Forecasts, and Benchmarks

Most reporting packages I have seen include actual, budget and comparison, but you don’t have to stop there. You can have multiple budgets or forecasts which can be updated or restated. Perhaps you have benchmarked financial information for your industry. There is no limit to the number of these you can add to GP Dynamics and then pull into your reporting.

The bottom line to all of this is creativity. I know that is not a word that comes to mind when you think of accountants, but that’s what it takes. Start thinking about what you can do instead of simply what has been done in the past. You will surprise yourself in the end, and probably end up with something bigger than your current role. There is definitely power in the ability to create, read and analyze the data, start those creative juices flowing.

 

 

Related Posts

0 Comments

Submit a Comment

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

Upcoming Events

june

02jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Conference Room Pilots

03jun10:00 am10:30 amWhy Levridge Grain? Streamlining Sales Contracts

04jun11:00 am12:00 pmConfab With Stoneridge - Livestream - Customer Insights

04jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Dealing with Challenges Mid-Project

09jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Customizations vs Configurations and How You Manage Them

10jun10:00 am11:00 amOn the Job with Dynamics 365 - Manufacturing Buyer

11jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Data Migration - Early and Often

15jun(jun 15)9:00 am16(jun 16)4:00 pmDynamics 365 Finance and Supply Chain Management Training for AX 2012 Developers

16jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Environment Management and Deployments

17jun10:00 am10:30 amWhy Levridge Grain? Best Practices for Managing Load Orders for Grain Processors

17jun12:00 pm1:00 pmMobilizing an efficient, streamlined AP department with AP Automation

17jun2:00 pm3:00 pmGuide for B2B Businesses: Tackling Supply Chain Optimization and Customer Experience Challenges

18jun11:00 am12:00 pmConfab with Stoneridge - Livestream - Enterprise Asset Management and Preventative Maintenance

18jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Testing - Definition and Activities

23jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Training for All

24jun10:00 am11:00 amOn the Job with Dynamics 365 - Manufacturing Production Manager

25jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Going Live

30jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Hypercare

july

01jul10:00 am10:30 amWhy Levridge Grain? How to Achieve Efficient and Accurate Scale Tickets

02jul11:00 am12:00 pmConfab with Stoneridge - Livestream - Power Automation Virtual Hour

02jul1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Support and Enhance Your Project

07jul1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Bringing It All Together

08jul10:00 am11:00 amOn the Job with Dynamics 365 - Manufacturing Planner

22jul10:00 am11:00 amOn the Job with Dynamics 365 - Manufacturing Material Handler

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