Do you
spend a lot of time reviewing stacks of reports each month so you can get the
information you need to make decisions?
Do you find out after the fact that something went wrong in your
business and that if you had known about it sooner, you would have made
different decisions?
If so, you
might benefit from a special type of reporting called exception reporting. Exception reporting highlights red flag
areas that you need to take action on.
It contrasts with regular reporting, which lists lots of data that you
may or may not need to take action on.
Here’s an
example: How often do you check
your bank balance? You probably
check daily or even more, right?
Do you really need to?
Ask
yourself when do you really need to know about your bank balance? You need to know when it falls below a
certain amount, or when you don’t have enough to cover imminent bills, right? Why not stop checking your balance all
the time and replace it with an alert that will send you an email under the
conditions and criteria you set? This
will save you time.
Some
exception reports are already built into some accounting systems. A couple of good examples are the A/R
aging report which shows past due invoices that have not been collected and the
inventory re-order report that lists inventory items that reached their
re-order points and need to be re-ordered.
There are
many ideas to generate exception reports:
·
Missed
and upcoming deadline tracking such as project due dates, tax forms due, and
payroll due
·
Employees
on vacation
·
Bills
overdue
·
Expiration
date tracking like end of lease and insurance policy renewal dates
·
Large
variances in budget to actual reports
To take
advantage of exception reporting, here are a few steps:
1.
Identify
the reports you currently receive that you review but take no action no matter
what. Do you really need
them? If not, throw them out. If so, ask yourself what trigger would
have you taking action and change the regular report into an exception report
that reports on that trigger.
2.
Think
about what data you access all day that is not in a report or easy to use
format. Can you create an
exception report or alert out of it and save yourself time?
3.
What
information would you like to start receiving that you don’t have now? It should be something that you would
take action on if you knew about it.
Can you create an exception report for these new information needs?
Try
exception reporting, or take it to the next level of implementation in your
business, and watch your time free up and your management decisions
sharpen.