Cash Flow Prediction
Cash flow prediction is shorter-term planning of how money could move in the next 30 or 60 days, based on the currently outstanding invoices and other expenses/income from the previous month.
Report
This report has been added to the report generator so that it can be added to the main page as a graph later on, enabling the data to be processed better.
To open the report, go to Reports -> Report Generator and select “Cash Flow Prediction” from the tables.
- Output: you can select anything except type.
- Show in groups: do not select anything initially, then you can insert a week or a month, depending on your needs.
For example, if you select the month of August, it will show real outstanding invoices, real bank balances and other incoming and outgoing payments taken from the previous month.
The report is based on the cash balance on the company’s account on that day.
Next
- add cash in – actual outstanding invoices according to the due date.
- deduct cash out – actual outstanding purchase invoices according to the due date.
- add other income from the previous month. You can see these by going to Sales -> Cash in. There cannot be a customer attached to the payment, as this indicates a normal “Other type” of income (e.g. loan installments received, etc.).
- deduct other expenses. You will find the Purchases -> Cash out (for example, 500 was paid out on 15 July). This here is a VAT payment and the system assumes that such a payment will also be made on 15 August.