Key Takeaway: A service firm’s cash forecast should connect expected receipt dates with actual payment obligations. Start with reconciled available cash, avoid overlapping collection estimates, set a minimum cash policy, and test delays. Keep client funds, tax reserves, owner distributions, and entity obligations clearly identified.
This article is part of our guide to cash flow forecasting and financial planning.
A full project calendar does not establish that next week’s payroll is funded. Work can be performed before an invoice is permitted, and an invoice can remain unpaid after its due date. Meanwhile, employees, contractors, tax authorities, lenders, and suppliers have different payment schedules.
The forecast’s purpose is to identify how much cash is expected to be available on the dates it is needed. Profit, billings, backlog, and bank receipts provide different information. Use them together without treating any one of them as a substitute for the others.
Define the cash included in the forecast
List the included accounts and reconcile their starting balances. Account for payments already issued but not yet cleared, bank holds, deposits still in transit, and duplicate or incorrect entries. If an outstanding payment has already reduced starting available cash, do not subtract it again as a new forecast payment when it clears.
Exclude client-owned trust money and other restricted funds from the cash available to operate the firm. Track customer advances according to their actual contractual and legal treatment; the word “retainer” alone does not establish that money is unrestricted or earned. A deposit available in an operating account may still carry future service or refund obligations.
Business-owned tax reserves may be designated for a purpose without being legally restricted. Show the reserve separately when assessing discretionary spending. If your forecast combines operating and reserve accounts, a transfer between them does not reduce total cash. If it covers only the operating account, show the transfer out and reconcile the reserve account separately.
The OpenStax cash-budget framework brings receipt and payment schedules together with capital and financing cash flows. It excludes noncash expenses such as depreciation from cash payments. Use the same clear boundary for every week of your forecast.
Connect engagements to receipts without counting them twice
Maintain one schedule at the engagement and payment-milestone level. An amount should move through the schedule as its status changes, rather than remain in several overlapping totals. Assign an expected invoice date and receipt date separately.
| Item | Forecast treatment | Control against duplication |
|---|---|---|
| Open invoice | Forecast the unpaid balance using current collection evidence. | Remove payments and credits already applied. |
| Recurring engagement payment | Use the agreed cycle and actual customer payment behavior. | If already invoiced, link to that invoice rather than adding a second receipt. |
| Performed but unbilled work | Identify the contractual billing trigger, invoice date, and likely receipt date. | Remove it from the unbilled receipt estimate once included in receivables. |
| Customer advance | Forecast only an advance not yet received; track its application to later billings. | Subtract an applied advance from the remaining amount the client must pay. |
| Prospective work | Show separately with assumptions about winning, starting, billing, and collecting. | Do not include the same opportunity again after it becomes an accepted engagement. |
Suppose a $30,000 engagement has a $10,000 advance already received, a further $8,000 invoiced and unpaid, and $12,000 not yet billable. Future receipts total $20,000 under full-collection assumptions, not $30,000 plus the $8,000 invoice. The original advance is already part of cash history and may have been partly spent.
Use payment history alongside current facts. An established customer may now dispute an invoice; a historically slow payer may confirm a specific payment. Record the evidence and next follow-up date. Aging alone does not establish a universal recovery percentage.
For related guidance, our article on Backlog Revenue Forecasting walks through this in “Backlog Reporting: Turning Signed Work Into a Revenue Forecast.”
Place payments on the dates cash is needed
Schedule net payroll, payroll-tax remittances, benefit payments, contractor invoices, rent, software, insurance, debt service, capital spending, and other commitments. Reconcile the detailed payroll schedule so employee withholding is not counted once inside gross wages and again as an additional expense or payment on top of the same gross amount.
Separate required payments from discretionary purchases and proposed distributions. An optional owner draw is not equivalent to wages already earned by employees, a tax deposit due, or a contractual payment. Review any legal, contractual, and governance constraints before changing a distribution or payment plan.
For borrowing, distinguish principal, interest, fees, expected drawdowns, and repayments. Cash received from a loan is financing, not service revenue. Paying principal reduces cash and debt; it is not a second operating expense.
Related reading: “Debt-Service Coverage: What Lenders and Owners Should Monitor” covers Debt-Service Coverage in more detail.
Use a rolling 13-week view alongside a longer plan
A weekly 13-week schedule is a useful operating tool for seeing payment clusters and near-term collection exposure. Update it each week and add a new week at the end. Preserve the previous version so actual results can be compared with what was forecast at the time.
Pair that view with a monthly medium-term plan for annual renewals, hiring, equipment, and growth commitments outside the current quarter. Longer forecasts can be useful when assumptions are explicit and updated; uncertainty does not make every forecast beyond thirteen weeks meaningless.
A hypothetical 13-week cash forecast
The following values are illustrative, not client results or market benchmarks. Starting cash of $80,000 is already reconciled available operating cash. Client trust and other restricted balances are excluded, and no separate opening tax reserve outside this amount funds the listed payments.
Assume this example’s income-tax payment belongs to the entity and is due in Week 7; the actual date must be assigned from its tax calendar. That week’s $32,000 of other payments consists of $9,000 of ordinary payments plus $23,000 of estimated tax. Other payments elsewhere include the modeled operating, debt, and separately tracked discretionary distribution amounts. The supporting schedule must retain that detail.
For illustration, management sets a $40,000 minimum available cash balance. This is a chosen planning threshold, not a legal rule or industry benchmark. The formula is opening cash plus receipts minus payments, and each ending balance becomes the next week’s opening balance.
| Week | Opening cash | Client receipts | Payroll and contractors | Other payments | Net change | Ending cash |
|---|---|---|---|---|---|---|
| 1 | $80,000 | $42,000 | $38,000 | $9,000 | ($5,000) | $75,000 |
| 2 | $75,000 | $18,000 | $0 | $8,500 | $9,500 | $84,500 |
| 3 | $84,500 | $40,000 | $38,000 | $9,000 | ($7,000) | $77,500 |
| 4 | $77,500 | $22,000 | $0 | $8,500 | $13,500 | $91,000 |
| 5 | $91,000 | $38,000 | $38,000 | $9,000 | ($9,000) | $82,000 |
| 6 | $82,000 | $16,000 | $0 | $8,500 | $7,500 | $89,500 |
| 7 | $89,500 | $30,000 | $38,000 | $32,000 | ($40,000) | $49,500 |
| 8 | $49,500 | $20,000 | $0 | $8,500 | $11,500 | $61,000 |
| 9 | $61,000 | $44,000 | $38,000 | $9,000 | ($3,000) | $58,000 |
| 10 | $58,000 | $19,000 | $0 | $8,500 | $10,500 | $68,500 |
| 11 | $68,500 | $41,000 | $38,000 | $9,000 | ($6,000) | $62,500 |
| 12 | $62,500 | $24,000 | $0 | $8,500 | $15,500 | $78,000 |
| 13 | $78,000 | $39,000 | $38,000 | $9,000 | ($8,000) | $70,000 |
Total receipts are $393,000. Payroll and contractor payments total $266,000, and other payments total $137,000. Cash therefore falls by $10,000 across the period, from $80,000 to $70,000.
The lowest projected week-end balance is $49,500 in Week 7, leaving $9,500 above the illustrative minimum. That conclusion concerns week-end balances only. If Week 7’s $70,000 of payments leaves before its $30,000 of receipts arrives, cash temporarily falls from $89,500 to $19,500, below the minimum. Review daily timing in tight weeks.
Test the effect of one delayed collection
Keep every other assumption unchanged, but move the $44,000 receipt from Week 9 to Week 11. Do not remove it permanently or add it in Week 11 while leaving it in Week 9.
| Week | Receipts after delay | Payments | Ending cash | Position against $40,000 minimum |
|---|---|---|---|---|
| 9 | $0 | $47,000 | $14,000 | $26,000 short |
| 10 | $19,000 | $8,500 | $24,500 | $15,500 short |
| 11 | $85,000 | $47,000 | $62,500 | $22,500 above |
The delayed payment returns the forecast to its original Week 11 closing balance because this scenario assumes a timing change only. It creates a funding gap in the intervening weeks. A nonpayment scenario would have a different ending result and should be modeled separately where relevant.
Also test a case with no new pipeline wins. A prospective $20,000 payment with a 50% win assumption has a $10,000 probability-weighted value, but it may produce either $20,000 or nothing, and timing may vary even after a win. Do not treat the $10,000 average as committed payroll funding.
Build tax reserves from the relevant tax projection
The IRS estimated-tax guidance bases calculations on expected income, deductions, credits, withholding, and other relevant tax facts. Recalculate when those facts change. A fixed percentage of gross collections can overfund or underfund the amount needed, because collections are not the same as taxable profit or the owner’s total taxable income.
Identify whose tax is being paid. An LLC is a state-law form and can have different federal classifications. A payment for an owner’s pass-through income tax is distinct from the entity’s own income, employment, or other tax obligation. In a business-only forecast, an owner tax distribution leaves the business once; do not then count the owner’s personal remittance as a second business outflow.
For individual estimated tax, review the applicable current-year or prior-year safe-harbor calculation, higher-income rules, withholding, and payment timing using the IRS estimated-tax FAQs. A safe harbor concerns underpayment-penalty exposure; it does not necessarily fund the final year’s entire tax liability. Corporate and employment-tax rules require their own calculations and dates.
Maintain a reserve target and a payment schedule. A transfer into an included reserve account changes earmarked cash, while the eventual payment to a tax authority changes combined cash. If reserve funds are excluded from the operating forecast, show their payments in the separate reserve schedule so the same tax is not funded twice.
Respond to gaps before committing additional cash
Confirm the underlying receipt and payment dates first. Then review permitted invoicing, overdue-collection follow-up, discretionary purchases, and proposed owner distributions. More frequent billing may help when the contract permits it and the customer pays; sending an invoice earlier does not guarantee an earlier receipt.
Evaluate financing with enough lead time to obtain actual terms. Availability, pricing, collateral, guarantees, covenants, and draw conditions depend on the lender and borrower. An early application does not guarantee a cheaper loan or approval. Include a proposed line of credit in a funding case only with its status and assumptions clearly identified.
For a new hire or contractor commitment, combine the cash forecast with workload and capacity analysis. Signed work may justify delivery resources without providing cash before the first payroll date. Compare the expected case with delayed collections and a no-new-wins case before deciding what level of commitment is affordable.
Make the weekly review accountable
- Freeze the prior forecast. Preserve its assumptions and the date it was prepared.
- Enter actual receipts and payments. Reconcile them to the included accounts and remove cleared forecast items.
- Explain material differences. Distinguish timing shifts, missed collections, changed scope, new costs, and errors.
- Update future dates. Obtain current information from billing, project managers, payroll, and the person approving spending.
- Assign actions. Identify the owner, deadline, and expected effect of each collection follow-up, spending decision, or funding step.
A one-week payment delay is evidence to investigate, not necessarily proof that every future invoice should move by the same interval. Update assumptions based on what changed, preserve the supporting explanation, and check the remaining balances for duplicates.
For a review with CPA Firm South Florida’s fractional CFO team, bring reconciled bank balances, receivables, engagement schedules, payroll and tax calendars, debt terms, and proposed spending. Confirm whether the engagement includes preparing the forecast, weekly updates, tax projections, or other advisory work. Clear responsibilities are as useful as the spreadsheet itself.
Frequently asked questions
Is the current bank balance the right starting cash figure?
Only after reconciliation and a clear definition of the included accounts. Account for outstanding payments, holds, and restricted or client-owned funds, and track designated tax reserves separately from cash available for discretionary spending.
How should unpaid invoices be forecast?
Assign an expected receipt date using invoice status, customer confirmation, disputes, and payment history. Track partial payments and credits, and avoid counting the same amount again in a retainer, work-in-progress, or pipeline line.
Should pipeline opportunities fund planned payroll?
Show prospective receipts separately and test a case with no wins or delayed receipts. A probability-weighted amount is an expected-value calculation, not committed money available on payday.
Does transferring money to a tax reserve reduce total business cash?
Not when both accounts are included in the same forecast. It changes the allocation of cash. A payment outside the included accounts reduces that forecast balance; record the scope consistently and count each actual external payment once.
What should happen when projected cash falls below the minimum?
Identify the date and size of the gap, verify collection assumptions, review discretionary spending and distributions, and evaluate available funding or agreed payment changes. Do not assume borrowing will be approved or that required payroll, tax, or contract payments may simply be deferred.