ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

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

30/1/2015

0 Comments

 

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.  


Picture
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.
Picture
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.  
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters