Help CenterThis article explains how you can ensure you have the correct data in your cash flow forecast in CostTracker. The cash flow forecast in CostTracker is designed to work together seamlessly with the accounting system and to ensure all cost is covered and nothing is counted twice.
In this example, we have created three transactions
- One open purchase order of 10 000 with an estimated payment date in February 2022
- One accounting transaction of 10 000 with document date and due date in January 2022
- One accounting transaction of 10 000 with document date and due date in December 2021
In the budget section, you will find these adding up to 30 000 against the budget (10 000 as open commitment and 20 000 as invoiced).
Going into the cash flow forecast, I have set the cut-off date to 31.12.2021, this is the date that defines the accounting period I am preparing the cash flow forecast from.
Since the last accounting transaction (transaction 3 above) has a document date prior to or equal to the cut-off date, you will see that this transaction is out of scope for the cash flow in CostTracker (covered by the accounting system) and you can see the cash flow profile for the remaining two transactions (transaction 1 and 2).
As a rule, the total committed cost in the budget should always equal the sum of in scope and out of scope in the cash flow forecast. Further, you will find the values that are out of scope above (total 10 000) in your accounting system prior to the cut-off date. So, in this case, I would expect to find 10 000 booked in my accounting system prior to 31.12.2021. And if it is not already paid, it should be part of the Aged accounts payables per 31.12.2021.
After doing these controls, you should then be able to export the data directly and include it in your overall cash flow forecast for the company, knowing that all cost is managed correctly.