Blog · Territory, capacity and quota planning
Project cash flow places customer receipts and project payments on the dates cash moves. Build a weekly schedule from existing exports, compare milestone timing with the plan, and calculate the temporary funding needed before collections arrive.
Project cash flow compares milestone receipts with payroll and supplier payments on the dates cash moves. The important result is the lowest cumulative balance before financing. A project can finish with a cash surplus and still need temporary funding along the way.
Net project cash movement = Customer receipts - Project cash payments
Unfunded closing balance = Available opening project cash + Cumulative net project cash movement
Additional funding needed = Maximum of zero and Required cash floor minus Lowest unfunded balance
An unfunded balance is a planning calculation. A negative number identifies cash that must come from treasury or another approved source; it is not an assertion that a bank account can spend money it does not have.
Include cash the company expects to collect and payments it expects to make for the defined project. Keep corporate funding transfers separate from customer receipts. Record shared payroll allocations only when they represent the cash requirement assigned to this project, and document how those allocations reconcile to the company payroll file.
The opening-cash-plus-inflows-minus-outflows identity also appears in New York City Small Business Services' cash worksheet. A project schedule adds project IDs, milestone references and ownership of expected dates.
This is an operational funding view. A project-finance cash flow waterfall addresses a different job: contractual priority among reserves, debt service and distributions.
Bring the invoice and collections register, supplier payment schedule, payroll calendar and milestone plan to the same reporting date. Use one row per expected receipt or payment, with these fields:
| Field | What to keep |
|---|---|
| Project | Stable project ID |
| Reference | Invoice, milestone, supplier bill or payroll reference |
| Kind | Receipt, Payroll or Supplier |
| Amount | Positive USD amount; the summary subtracts payment kinds |
| Planned date | Date from the approved cash plan |
| Cash date | Date used by the selected version: planned, actual or latest expected |
| Version | Plan, Actual or Latest forecast |
| Owner and evidence | Person confirming the date and supporting reference |
Preserve the approved plan so revised dates do not erase the variance. For elapsed weeks, use actual bank-cleared cash. For future weeks, use the latest supported expected date, not an overdue invoice's original due date.
Revenue recognition dates are a different field. The IRS's accounting-method explanation distinguishes cash receipt and payment from accrual income and expense timing. That distinction explains why copying a project income statement does not produce a cash schedule; the company's financial reporting policy still governs its accounting records.
Consider an illustrative US consulting company's client onboarding project. On October 2, 2026, treasury assigns $20,000 of available opening cash. The cash plan below includes customer milestone receipts, project payroll and supplier payments. All amounts are USD, with no rounding needed.
| Week ending | Receipt (USD) | Payroll (USD) | Supplier (USD) | Net movement (USD) | Unfunded closing balance (USD) |
|---|---|---|---|---|---|
| October 9, 2026 | 20,000 | 15,000 | 10,000 | -5,000 | 15,000 |
| October 16, 2026 | 0 | 20,000 | 15,000 | -35,000 | -20,000 |
| October 23, 2026 | 40,000 | 20,000 | 10,000 | 10,000 | -10,000 |
| October 30, 2026 | 0 | 20,000 | 5,000 | -25,000 | -35,000 |
| November 6, 2026 | 60,000 | 15,000 | 0 | 45,000 | 10,000 |
| November 13, 2026 | 30,000 | 10,000 | 0 | 20,000 | 30,000 |
| Total | 150,000 | 100,000 | 40,000 | 10,000 | 30,000 ending |
Total receipts of $150,000 exceed payments of $140,000 by $10,000. Add the $20,000 opening allocation and ending cash is $30,000. That is the cash reconciliation, not a claim about project accounting profit.
The lowest unfunded balance is negative $35,000 in the week ending October 30. To avoid falling below zero, treasury must supply at least $35,000 by the relevant payment dates. If the required minimum cash floor is $10,000, additional funding is $10,000 - (-$35,000) = $45,000.
The weekly table can still conceal a shortage within the week if payroll clears before a customer pays. Before releasing payments, inspect daily timing around the tightest week. A company-wide 13-week cash flow template provides the wider context for competing projects and shared obligations.
Store the dated rows in an Excel table named Cash. Put the project ID in J1, the selected version in J2 and opening cash of 20000 in J3. With the weekly summary starting at A1, columns B through D collect receipts, payroll and supplier payments. Dates in A2:A7 are actual spreadsheet dates.
Enter these formulas in B2, C2 and D2, then fill down:
=SUMIFS(Cash[Amount],Cash[Project],$J$1,Cash[Version],$J$2,Cash[Kind],"Receipt",Cash[CashDate],">="&(A2-6),Cash[CashDate],"<"&(A2+1))
=SUMIFS(Cash[Amount],Cash[Project],$J$1,Cash[Version],$J$2,Cash[Kind],"Payroll",Cash[CashDate],">="&(A2-6),Cash[CashDate],"<"&(A2+1))
=SUMIFS(Cash[Amount],Cash[Project],$J$1,Cash[Version],$J$2,Cash[Kind],"Supplier",Cash[CashDate],">="&(A2-6),Cash[CashDate],"<"&(A2+1))
These date limits collect the seven calendar days ending on A2, including any payment timestamps during the final day. Microsoft's SUMIFS documentation explains the multiple-criteria syntax. Covirage is not affiliated with Microsoft.
Calculate net movement in E2, unfunded closing balance in F2 and funding needed against a $10,000 floor:
=B2-C2-D2
=$J$3+SUM($E$2:E2)
=MAX(0,10000-MIN($J$3,F2:F7))
Fill the first two formulas down through row 7. The funding formula includes opening cash as well as weekly closing balances. Investigate blanks in expected dates before relying on the result; a date-based sum can omit an undated payment entirely.
At the October 16 review, the project manager expects the $40,000 collection to move from October 23 to October 30. Nothing else changes. Keep the approved plan and update only that receipt date in the latest forecast.
| Week ending | Planned receipt (USD) | Updated receipt (USD) | Planned unfunded balance (USD) | Updated unfunded balance (USD) |
|---|---|---|---|---|
| October 9 | 20,000 | 20,000 | 15,000 | 15,000 |
| October 16 | 0 | 0 | -20,000 | -20,000 |
| October 23 | 40,000 | 0 | -10,000 | -50,000 |
| October 30 | 0 | 40,000 | -35,000 | -35,000 |
| November 6 | 60,000 | 60,000 | 10,000 | 10,000 |
| November 13 | 30,000 | 30,000 | 30,000 | 30,000 |
The ending balance stays $30,000 because total receipts are unchanged. The low point becomes negative $50,000 on October 23, so funding against the $10,000 floor rises to $60,000. One date change increases peak funding by $15,000 and brings the low point forward.
The project manager owns milestone evidence; accounts receivable confirms customer payment expectations; payroll and accounts payable confirm disbursements. Treasury owns funding availability. Finance reconciles actual cash by reference and explains amount changes separately from date changes.
For contract-specific timing such as retainage, use construction project cash flow alongside the general receipt-and-payment method.
Bring a dated project receipts-and-payments export and its supplied cash plan to Covirage. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See project cost control for the supporting context.
Profit uses recognized revenue and costs for the accounting period. Cash flow uses receipts and payment dates. An earned milestone can add revenue before its invoice is paid, while a supplier deposit can use cash before its cost reaches the income statement.
Show operating project receipts and payments before funding, then add a separately labeled financing section when needed. That preserves the underlying funding gap. Combining a corporate cash transfer with customer collections can hide the amount treasury supplied to keep the project funded.
Match the update frequency to payment decisions and milestone risk. A weekly view is useful when payroll and customer approvals drive near-term needs. Replace elapsed weeks with reconciled actual receipts and payments, then refresh the remaining expected dates with their owners.
Yes. Early payroll and supplier payments may fall due before later customer collections. The required temporary funding comes from the lowest cumulative balance, adjusted for available opening cash and any required minimum cash floor, rather than the final net cash total.