Forecast cash balances by period and spot projected funding gaps.
No matching tools.
Rows are processed in the supplied order. Enter cash movement dates, not booked sales; use one currency and non-negative inflows and expense categories. Opening cash may be negative. Period labels must be unique. This is a scenario estimate, not bank reconciliation.
Opening cash 1000 plus receipts 500 less expenses 1000 leaves 500. A following period with receipts 300 and expenses 1100 ends at -300.
closing_cash = opening_cash + cash_receipts - cash_expenses