Consulting Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the Client & AR Tracker — enter every active client: the engagement type, billing rate or retainer amount, invoice frequency, and current open invoice balance with the invoice date. For hourly and project clients, also enter the expected payment date based on how that client typically pays (check their last 3–6 invoices to estimate their real payment pattern rather than using the contract terms alone — many clients pay on net-45 regardless of net-30 terms). This step takes 20–30 minutes for most consulting businesses and immediately surfaces your total AR outstanding, your aging breakdown, and your expected cash inflows for the next 30 days. That three-number summary — AR total, aging distribution, and near-term expected receipts — tells you more about your short-term cash position than a bank balance alone, especially for firms where a single client might owe $30,000 in outstanding invoices.

Consulting businesses have a cash flow structure defined by two structural tensions: the gap between when work is delivered and when clients pay, and the difference between the smooth monthly cost base and the lumpy, milestone-driven revenue pattern. A consulting firm delivering $250,000 of work per year on net-30 terms carries roughly $20,000 in outstanding receivables at any given time — and a firm on net-45 terms carries $30,000. That receivables balance isn't optional; it's the direct cost of offering credit to clients. When a single large project completes and the final milestone invoice goes out for $40,000 on net-45, the firm has delivered the work, paid its contractors, and continues to pay overhead — but won't receive the cash for six weeks. Cash flow management in consulting is largely accounts receivable management.

Key Performance Indicators