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”.
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.