Common Financial KPIs - It's just the Beginning of the Story

Jet Essentials and Jet Enterprise are great softwares sold by Jet Reports.  If you grab the body of free reports available in their online library, arguably you're well on your way to a complete solution!  But the conversation doesn't with a purchase and a few hours of training.  We are just the start of the journey!

Which KPI's are important to you and the way you run your company?  If AP Turnover increases this month, do you have reports available to answer "Why"?  Similarly, if increasing Gross Profit Margin is a company-wide goal, which reports exist to identify and track the factors that have greatest influence on profit margin?

Let me start by saying, I am not an accountant!  I ask questions and then I build reports.

Here at Onyx we ask questions like: 

• What are your business goals?
• Which reports exist to support strategic and operational goals?
• Which business activities add the most value to your business model?  Least value?  Tedium?
• Which activities drive growth.
• Which metrics can predict trouble in a department? With a customer?  Vendor?

From there, let's get to work.  Let's build reports to help you keep on top of the game.  KPI's are nice gauges of health, while automated exception reports help your operational team take action.  

Built using Microsoft Excel Template and Jet Essentials

I recently chatted with some accountant friends and asked, "What are some common Financial KPI's and reports?"  I distilled the results to the following list.

Common Financial KPIs
Current Ratio	Quick Ratio / Acid Test
Working Capital	Return on Equity
AP / AR Turnover	AP / AR Days
Inventory Turnover	Inventory Days
Gross / Net Profit Margin	Revenue YTD
Debt to Equity Ratio

After recognizing some of the KPI's from Microsoft's Balance Sheet template, I rebuilt it as a Jet report which would run against my NAV sample database (pictured above).  I then explored building some of those same KPI's into the stock Jet Enterprise Financial cube as calculated measures.  Here are the fruits of my labor as a PivotChart.

Built using custom Jet Enterprise Financial Cube & MS Excel Pivot Tables

This vision of automated reporting and easy analysis is why I formed Onyx Reporting around the Jet Enterprise and Jet Essentials softwares.  So don't wait.  Shoot me an email at Jae@OnyxReporting.com or just start a chat in the widget below.