Cash Short Predictor in Details

Nori -

Cash Short Predictor is one of our core functionality, which presents the daily view of your cash flow for next 3 months, and monitors your cash flows for cash short risk.

In this document, the details of Cash Short Predictor is explained. If you are not familiar with this, you may first check out our introductory document here.

 

csp_sample.jpg

 

Short-term Forecast

This shows a graph of daily bank balance forecasts, which is consolidated for each currency. If you have multiple currency bank accounts, you will see a drop down box next to CCY to see the balance forecast with the selected currency.

If a circle in the graph is clicked, the balance detail is shown on the right of the graph, and the date is focused in Cash Short Simulation. To clear the selection, you may click "Clear" just above Short-term Forecast.

Coloured mark explained

An overall cash shortfall would happen by collection failure of prior cash-ins in 1 week, or near cash-out. E.g. You expect 10,000 cash-in on 27 April, and expected cash position on 28 April is 8,000.
In this case, the position on 28 April could be -2,000 if you miss the cash-in planned earlier, thus 28 April is marked in red.

An overall cash shortfall would happen by collection failure of prior cash-ins in 4 weeks. E.g. You expect 10,000 cash-in during 1 and 21 April, no cash-in during 22 and 28 April, and expected cash position on 28 April is 8,000. In this case, the position on 28 April could be -2,000 if you miss the cash-in planned within the 4 weeks, thus 28 April is marked in yellow.

A cash shortfall on a particular bank account (Red cross) or credit card (Yellow cross) would happen by collection failure of the same day's cash-ins or simply cash-outs, while the overall balance does not reach the total credit line.**
You can see a balance per bank account/credit card by clicking a mark in the chart.
E.g. Your company's overall balance on 27 April is 8,000 but Bank Account A's balance on that day is -1,000. Therefore 27 April is marked with a red cross.

** This mark only appears on the day when the position reaches the credit line.

 

Bank Balance Details

This shows the balance of the selected date.  Net cash flow and closing balance for each bank account are shown.

Under (i) mark, credit line of the each bank account is shown. If you click the link, then bank account list is shown, in which the settings of each bank account will be updated.

"w/o in" shows a possible lowest balance as at the date. This is calculated by adding net cash flow on the day to the opening balance, and substracting all cash in flow on the date. 

 

Cash Short Simulation

Here, you can see all cash flows of this month and the following three months and also simulation results.***

How to see simulation results

By clicking a red or yellow circle in the chart above or the table below, you will see results of the following scenarios.
The transactions which have a value date marked in red or yellow indicates cash-ins which may possibly cause an overall cash shortfall, thus those payments should be collected on the due date to avoid it.

Worst Case

This shows possible worst closing balances in case that prior cash-ins in a specific period (Red: 1 week, Yellow: 4 week) are failed to collect.

+ Overdue Cash-ins

This shows simulated closing balances in case that current overdue cash-ins are collected successfully under the worst case scenario above.
As a side note, you can see current overdue items by clicking each figure in the top of the table.
*** Please note that only cash flows in a selected currency are included.

 

Export Simulation Result

The simulation results can be exported as an Excel file by selecting "Export current simulation result" from the menu in the top right-hand corner of the page.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.