• About Us
  • Advertise with Us
  • Contact Us
  • Events
  • Newsletter
  • Podcasts
  • Digital Magazine
  • Home
  • News
  • Opinion
  • Entrepreneurship
  • Self Development
  • Growth
  • Finance
  • Marketing
  • Technology
  • Sustainability
  • About Us
  • Advertise with Us
  • Contact Us
  • Events
  • Newsletter
  • Podcasts
  • Digital Magazine
NZBusiness Magazine

Type and hit Enter to search

Linkedin Facebook Instagram Youtube
  • Home
  • News
  • Opinion
  • Entrepreneurship
  • Self Development
  • Growth
  • Finance
  • Marketing
  • Technology
  • Sustainability
NZBusiness Magazine
  • News
  • Opinion
  • Entrepreneurship
  • Self Development
  • Growth
  • Finance
  • Marketing
  • Technology
  • Sustainability
Management

How to get the reports you want

Elliot Cooper says even the smallest business has the power to generate reports that deliver…

Glenn Baker
Glenn Baker
April 6, 2017 3 Mins Read
346

‘Reporting’ is just a code word for getting the information you need to be in control and make smart decisions. Elliot Cooper says even the smallest business has the power to generate reports that deliver profit-boosting insights. 

Effective reporting drives your key performance indicators (KPIs), which is a fancy way of saying ‘things you could really benefit from knowing’. In essence you want to track your KPIs; identify trends; and find any outliers. 
Reporting is the single biggest pain point for businesses. It is important to base your business decisions on the best science you can muster. Doing it badly represents lost money and lost opportunity. Here’s how you can get the reports you want – without needing a degree in statistics. 

Three steps to get decent reporting quickly and cost effectively

  1. Get clear on what you want to know. Retailers may want the average spend per customer through the door; Manufacturing firms the cause and quantity of downtime. Data comparisons are essential to understanding your own data – common examples are company sales vs. total industry sales; and comparisons of your data vs. industry standard.
  2. Capture the data before you can report on it. To report on sales per metre of floor space, your system needs to know floor space quantity.
  3. Find your most cost effective delivery method. If your business employs less than ten people, the best options are usually either the in-house reporting engine in your accounting system; Microsoft Excel; or Microsoft Power BI.

Cracking delivery
You may have to change the accounting platform you’re running to make your data available to a variety of different reporting tools. Making your data more accessible can deliver rich reporting gains. If you’re lucky, you are already running an accounting system that can make your data available to a reporting tool that suits you. If your accounting system runs on SQL Server you can connect to almost any third party reporting tool. Some cloud accounting products – like MYOB Advanced – use O-Data feeds that are easily accessed by third party reporting tools. 

Third party reporting tools for all budgets
At the top end of town you have third party products like Cognos, Halo and Theta. They are generally not suitable for very small businesses. Small to medium-sized businesses may be better off looking at products like Alchemex, which are faster to implement. 
Cheapest of all? Use the in-house reporting engine contained in the accounting system you’re running.  Microsoft Excel is another reporting tool you have probably already used. Microsoft Power BI is a pretty decent third party tool that’s cheap as chips at around $12 per user per month.

Making it happen

  • Create a mock-up of the report(s) in Excel or on paper.  This allows you to play around with the layout and gives insight into potential issues with readability.  Choosing the correct chart type is key to understanding data and drawing accurate conclusions.  
  • Talk to your accounting system service provider.  They should be able to create the report you require or direct you to a suitable standard report.  
  • Validate the data.  Is the data presented correct, and is it meeting your objective for commissioning the report? Does additional information need to be presented, or do you need an alternative report to interpret the information presented? Rome wasn’t built in a day and the best reports often require tweaking before they’re 100 percent.  If you make a change to your system, ask yourself if this will affect your reports.

Elliot Cooper is CEO, co-founder and executive director of listed company Enprise Group (NZAX: ENS). He’s a chartered accountant who has worked on many capital raises, as well as multiple trade sales totalling more than $50 million. 

Share Article

Glenn Baker
Follow Me Written By

Glenn Baker

Glenn is a professional writer/editor with 50-plus years’ experience across radio, television and magazine publishing.

Other Articles

Why reporting and accountability will revolutionise your team
Previous

Why reporting and accountability will revolutionise your team

Trineo - Dan Fowlie and Abhinav Keswani
Next

Trineo a great example of post-quake success

Next
Trineo - Dan Fowlie and Abhinav Keswani
April 6, 2017

Trineo a great example of post-quake success

Previous
April 4, 2017

Why reporting and accountability will revolutionise your team

Why reporting and accountability will revolutionise your team

Subscribe to our newsletter

NZBusiness Digital Issue – March 2025

READ MORE

The Latest

From redundancy to resilience

May 16, 2025

Episode 16: Bryce Marsden on sustainable impact through education, youth and environment

May 15, 2025

The high cost of leadership neglect

May 14, 2025

Why making Auckland a Tech Hub makes sense

May 14, 2025

Is AI making us happier? Why some Kiwi leaders would trade coffee for Generative AI

May 13, 2025

Step back to move forward – how Kiwi business owners can unlock growth

May 12, 2025

Most Popular

NZBusiness Digital Issue – June 2024
Understanding AI
Navigating economic headwinds: Insights for SME owners
How much AI data is generated every 60 seconds? New report reveals global AI use
Nourishing success: Sam Bridgewater on his entrepreneurship journey with The Pure Food Co

Related Posts

Stop stressing and get your life back

Stop stressing and get your life back

March 20, 2017
Succession planning begins with life goals

Succession planning begins with life goals

March 20, 2017
NZBusiness Magazine

New Zealand’s leading source for business news, training guides and opinion from small businesses to multi-national corporations.

© Pure 360 Limited.
All Rights Reserved.

Quick Links

  • Advertise with us
  • Magazine issues
  • About us
  • Contact us
  • Privacy policy
  • Sitemap

Categories

  • News
  • Entrepreneurship
  • Growth
  • Finance
  • Education & Development
  • Marketing
  • Technology
  • Sustainability

Follow Us

LinkedIn
Facebook
Instagram
YouTube
  • Home
  • News
  • Opinion
  • Entrepreneurship
  • Self Development
  • Growth
  • Finance
  • Marketing
  • Technology
  • Sustainability