How to use the Business Intelligence Centre (BIC) for Reporting (Part 1)

A thief was caught after stealing some paintings from the Louvre in Paris, when his getaway van ran out of fuel. Given bail at his first hearing, a reporter asked him on the steps of the courthouse how he forgot such a vital part of his plan.
“Simple,” said the thief, “I had no Monet for Degas to make the Van Gogh.”  (Ack CB)

I really enjoy this little story as it demonstrates the natural requirement for proper preparation or planning.  Something that is such a fundamental function which is so often not implemented on a daily basis, resulting in additional costs for corrective actions and much retrospective umm’ng and ahhh’ng .  So, how can we make this planning process fit into our daily lives, and, how can we get that information so that we can avoid as many ‘I’ll informed’ decisions as possible?  I’m glad you asked (well, you’re thinking it aren’t you… J ).  Softline have long known the importance of these decisions and the necessary tools to make them.  They’re so committed to providing their clients (you guys) with these tools, that they’ve purchased Alchemex, the company responsible for the creation of the Business Intelligence Centre module, and brought them ‘in house’.

Over the next couple of weeks, or maybe even longer (if there is a demand), I’m going to be writing a sequence of Blogs on ‘How to use the Business Intelligence Centre (BIC) for Reporting’ within your business, along with some tips on how to make it really work for you.

Today’s Blog will be about the Dashboard report.  It’s a standard report that ships with the BIC module, and, at the click of a button will give you a quick summary overview of your business, including:

1                     Your Profit & Loss at a glance (including Budget, Variance, &, YTD with variance)

  1. This gives you a quick look at whether or not your bottom line is in the red, or, the black.  And, you can see whether or not you’re on your projected YTD figures.

2                     Your Top 5 Expenses (including Budget, Variance, &, YTD with variance)

  1. Knowing your Top 5 Expenses with their Budgets and Variances gives you the opportunity to quickly spot anomalies in your companies spending.  The quicker any expense anomalies are spotted, the sooner they can be attended too.

3                     Your top 5 Customers & Customer Categories

  1. Knowing who your top performers are, or, which Category of client is generating your most income, is an important part of understanding your business.

4                     Your top 5 selling Inventory items & Item Categories

5                     Your bottom 5 selling inventory items & Item Groups

(click image to enlarge)

(the figures displayed in this report are from a demo company)

The information that is supplied by this report at a glance, will assist you with quickly identifying Key Performance Indicators (KPI’s) and identify area’s of concern, so that you can make the necessary decisions based on realtime information.

As with most reports, this Dashboard report can of course be customised to include other KPI’s within your organisation.

In my next Blog, I’ll cover the Management Pack (Income Statement & Balance Sheet) options.  I’ll even give you a couple of tips to customise it by Branch/Department 🙂

Happy reporting….


Our suite of Pastel Accounting related Professional Services include:
Business Consulting
Pastel Payroll Sales & Support
Pastel Payroll SARS Submission assistance
Pastel Payroll Outsourcing
Pastel Accounting Software Sales & Support
Pastel Accounting Software Implementation & Project Management
Pastel Accounting Troubleshooting & Datafixing
Excel Reporting
3rd Party Application Development

End 2 End Business Solutions

One of my favourite quotes:

“Nothing will ever be attempted if all possible objections must first be overcome”
Samuel Johnson

About the Author

Garth Kahn – who has written posts on End 2 End Business Solutions.

1 reply
  1. Brian
    Brian says:

    Oh, I forgot to mention one of the key factors of the Business Intelligence Centre (BIC) Module, it outputs to Excel so you can manipulate the output report and customise it to your layout requirements.



Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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