Agencies · Funding & factoring
Planning a weekly payroll cash-flow forecast
Build a weekly view of payroll, collections and available funding, with a worked example that separates confirmed receipts from assumptions.
Freelancer SupermarketPublished 3 min read
Reviewed 17 September 2026. Recheck linked official guidance and assignment-specific requirements before relying on it.
A payroll cash-flow forecast should answer a practical question: what cash will be available when the next payment is due? A monthly profit report cannot answer it on its own. The timing of approved work, invoices, collections and payroll can leave several different views of the same contract book.
Build the forecast around payment dates and update it from source records. Start with the bank position you can verify, then show how each expected movement changes that position. Keep the assumptions visible so an operations colleague can challenge them without rebuilding the spreadsheet.
Use one column per week and separate the inputs#
The opening balance should reconcile to the preceding week's closing balance. Include rows for expected client receipts, available funding drawdowns, payroll payments, provider charges, other operating payments and repayments or deductions associated with finance. Identify tax and pension payment dates with the people responsible for them; do not infer them from the gross wage total.
For each material receipt, record the invoice reference, contractual due date, current collection expectation and confidence level. An invoice becoming due and a client confirming a payment are different pieces of evidence. Maintain separate base and delayed-collection views rather than quietly changing the expected date to make the balance positive.
An illustrative three-week forecast#
These figures are invented to explain the method. They are not typical agency costs or a funding offer. Assume all amounts are cash movements and no additional facility drawdown is available.
| Cash movement | Week 1 | Week 2 | Week 3 |
|---|---|---|---|
| Opening balance | £18,000 | £10,000 | £17,000 |
| Expected client receipts | £12,000 | £28,000 | £15,000 |
| Payroll and provider payments | £18,000 | £19,000 | £20,000 |
| Other payments | £2,000 | £2,000 | £2,000 |
| Closing balance | £10,000 | £17,000 | £10,000 |
If £10,000 of the Week 2 receipts moves to Week 3, the Week 2 closing balance falls to £7,000. The final Week 3 total can still look satisfactory while the earlier week's headroom is much smaller. Put the delayed receipt in both affected weeks so the same money is not counted twice.
Keep finance availability distinct from invoice value#
Do not add the whole sales ledger to available cash. Ask the funder to confirm the amount available to draw and the conditions behind it. If an advance is already included in cash, avoid counting the associated gross customer receipt as fresh unrestricted cash when the client pays.
The British Business Bank's invoice finance overview describes funding against unpaid invoices. Your forecast still needs the actual facility's exclusions, charges and settlement mechanics, confirmed by its provider.
Turn the forecast into a weekly routine#
Set a review before the next approval cut-off. Compare last week's forecast with actual cash movements, assign reasons for differences and update the remaining weeks. Track new assignments, rate changes, client disputes and agreed payment promises as specific inputs.
Finish the review with named actions: obtain a missing approval, confirm a collection date, check available funding or escalate a forecast shortfall. A coloured cell is not an action owner.
Read the existing recruitment invoice-finance guide for the wider funding context. If the forecast reveals a recurring timing gap, use our funding service to discuss the ledger and payment cycle, with the assumptions and existing commitments available for review.