How is a cash flow statement prepared?
First the current balance in the accounts is entered. Then expected inflows (due dates of open invoices, cheque and promissory note collections, bank loan drawdowns) and expected outflows (supplier payments, salaries, taxes, rent, loan installments) are added in date order. The projected balance at the end of each day or week is calculated. In ERP, due dates come from the customer/supplier account, payment commitments from purchasing, and payroll and the tax calendar from the relevant modules. That is why the report stays more current than a manually prepared table.