Construction Cash Flow Template

Start with the Weekly Cash Flow sheet. Download the file and open it in Excel or Google Sheets — no macros or plugins needed. Enter your current cash balance in the starting balance cell, then fill in expected cash inflows for the next 13 weeks: scheduled draw payments from owners, any retainage releases due, and other income. The categories are pre-loaded with construction-specific line items, so most contractors can complete this in about 20 minutes using their draw schedule and accounts payable aging report.

Set up the Project Cash Flow sheet for each active job. Enter the contract value, the draw schedule (milestone or monthly), and the projected cost timing for materials, labor, and subs. The sheet will show you, week by week, when each project is cash-positive vs. cash-negative. This is where most contractors find surprises — a project that looks profitable on paper is often cash-negative for the first 60–90 days while material and sub costs run ahead of billings.

Use the Retainage Tracker to see the full picture of money owed to you. Enter each project's total retainage withheld and the expected release date. For most contractors, this is the single biggest unlock — seeing $300K or $500K of retainage outstanding in one place often changes how an owner thinks about line of credit draws, equipment purchases, and hiring decisions. Update this monthly as new draws are processed and retainage is released.

Construction is one of the few industries where a profitable company can run out of cash. The core problem is timing: material costs, subcontractor payments, and payroll run on weekly or monthly cycles, while owner draws often follow 30–60 day billing schedules and retainage sits locked up until project completion. A $2M project with a 15% gross margin looks fine on a P&L, but if the owner pays 45 days after billing and you're fronting $80K in materials upfront, you need $80K of working capital to bridge the gap — per project, every month.

The numbers that matter most in construction cash flow are different from general business. Retainage outstanding tells you how much money is technically yours but not yet collectable — for contractors doing $5M+ in annual revenue, this figure often exceeds $300K and represents a meaningful liquidity risk if projects stall or owners dispute final payment. Accounts receivable aging beyond 60 days is another warning sign, since construction payment disputes and slow-paying owners are the most common cause of contractor insolvency even when backlog looks healthy. A proper cash flow template surfaces both of these in one place.

The best way to use this template is as a forward-looking tool, not just a record of what happened. Plug in your draw schedule for the next 13 weeks, enter your committed costs by week, and let the model show you when your ending balance dips. Then you can act: accelerate a billing, draw on your line of credit, negotiate a payment extension with a supplier, or time an equipment purchase differently. Contractors who run this projection weekly say it shifts them from reactive firefighting to planned decisions — which is the whole point.