Getting a handle on operating cash

illuminis.co.uk | 01908 410 480

The Problem

A wholesaler client realised very quickly after Lockdown in March 2020 that he needed to know his operating cash position – as accurately as possible – on a daily basis and ideally, in real time.

In short, on any day, how much cash was due in from customers and when and how much cash did he need to pay suppliers, and when.

He focused on 3 key areas affecting both debtors and creditors: in essence, the amount of cash tied up in goods invoiced; goods delivered but not yet invoiced and goods ordered but not yet delivered or invoiced.

The company ERP system was giving him all of this information but it was spread across at least 6 reports, each amounting to several pages and he needed someone in his busy accounts team to pull it together for him.

This wasn’t the solution he needed: it was taking several hours to amalgamate this data via spreadsheet in order to give him an answer to the question “what’s my cash position looking like now, today, in real time”.

How illuminis was able to help

Our Octelas business reporting software accesses key business data, every day and in real time where needed. It does this automatically, pulling in the data from ERP systems as well as other data sources including spreadsheets holding sales targets; budgets; etc.

Octelas combines all of this data to populate a wide range of management information reports, tailored to the exact needs of the client, including reporting on financials such as aged debtors and creditors.

Our client got in contact to ask if we could cut through the problem so he could get a handle on his operating cash in real time.

In the event this proved to be a simple task for our data analysts: in minutes we combined all of the relevant data on debtors and creditors into a single report which the management team can access on their mobile; laptops or PCs for themselves – in real time, whenever they need to.

As a result our client is much more confident of the decisions he needs to make every day and which are critical to protecting his business during the pandemic.

“Our clients are amazing: they are constantly thinking of ways to manage their business though this extraordinary period. We are delighted to do whatever we can to help – and to share their ideas to help other businesses survive and thrive”

Paul North, Founder & Managing Director Illuminis Insight Systems Limited

illuminis team of software developers and data analysts have used their deep knowledge of the data needs of SMEs to develop the “Octelas” brand business reporting software. Since the first installation in 2012, Octelas has helped many SMEs to gain full access to and manage their business data.

For more information visit

  • 01908 410 480

  • illuminis Insight Software Limited, Luminous House, 300 South Row, Milton Keynes, MK9 2FR