Construction cash flow worksheet
Enter expected monthly receipts and payments to review a cash scenario for one project or a clearly identified shared cash pool. The worksheet carries closing cash into the next entered month and keeps negative balances visible.
The starting row is fictional. Edit it or remove it and add your own records. Inputs stay in this browser session and are not automatically saved or transmitted. Export the reviewed CSV to keep a copy.
What the cash scenario shows
Closing cash equals opening cash plus entered receipts minus entered payments. Project summaries show each project’s cash movement; they do not allocate the pool’s opening cash to separate projects.
How to use the worksheet
- Name the scenario and currency; use one currency throughout.
- Enter opening cash and each project’s monthly receipts and payments.
- Calculate and review the chronological monthly balances.
- Check missing months, duplicate entries and timing assumptions before exporting.
A worked example
With opening cash of 100, first-period receipts of 20 and payments of 50, closing cash is 70. If the next period has receipts of 10 and payments of 90, closing cash becomes −10. These illustrative values show the entered scenario, not a funding recommendation.
What to check before using the output
Missing months mean no movement was entered, not that actual movement is zero. The tool does not predict collection dates, interest, taxes, credit availability or financing needs. A shared cash pool is not a multi-entity account model.
Enter cash dates rather than earned value
Place receipts in the month you expect cash to arrive and payments in the month you expect cash to leave. Billing a period's work does not mean the money will be collected in that period. Review approval time, payment terms, retainage and known timing changes when entering the scenario. The worksheet uses the amounts you supply; it does not infer those terms.
A timing example
A fictional project bills $100,000 in January, with $10,000 retained and $90,000 expected to be received in February. Enter the expected $90,000 receipt in February and place the retained amount in a later month only when you have a stated collection assumption. If January opening cash is $50,000, receipts are zero and payments are $60,000, January closes at negative $10,000. That balance is carried into the next entered month. Changing the expected receipt month changes cash timing without changing the billed value.
Review gaps and shared pools
Include every month needed to understand the scenario, even when you explicitly enter zero movement. A missing month means no movement was entered. For a shared pool, opening cash belongs to the pool; project summaries show each project's receipts and payments without allocating that opening balance. Reconcile the scenario to actual bank and project records before relying on it. The CSV is a scenario worksheet, not a lender draw schedule or a financing commitment.