Recruitment Payroll Funding Weekly Cash Model
A free spreadsheet that shows, week by week, what paying temps every week does to an agency's bank balance while clients take a month or more to pay. Enter your headcount plan, pay and charge rates, client terms and overheads. It adds rolled-up holiday pay, employer NICs and pension at the 2026 to 2027 rates, then runs 26 weeks of cash twice: once on your own money and once with payroll funding on the terms in your quote. On the worked example below, a desk growing from 20 to 40 temps would need £123,916 more cash without funding; with a 90% advance it never goes below £35,981. No email needed to download.
Download the model
Excel workbook (.xlsx), opens in Excel, Google Sheets, LibreOffice or Numbers. Four sheets: how to use, inputs (with the statutory figures and their sources), results, and 26 weeks of workings. Type over any week's headcount. Free under a Creative Commons Attribution licence.
Want the numbers without formulas? The CSV version has the worked example's 26 weeks of cash.
To model weekly cash for a temp recruitment desk: employment cost per temp per week = hours x pay rate x (1 + holiday pay %) + employer NICs (15% of pay above £96 a week in 2026 to 2027) + employer pension (at least 3% of pay between £120 and £967 a week, for enrolled workers). It is paid a week or so after the work. The client invoice (hours x charge rate) is paid terms plus any late days after it is raised. The gap between the two, multiplied by headcount, is the cash the desk needs. With payroll funding, the advance less the service fee arrives when the invoice is raised; if it is at least the week's employment cost, growth no longer drains cash. More detail and scope
This page covers:
Week-by-week cash for a temporary recruitment desk that pays temps weekly and invoices clients on credit terms, with and without payroll funding or invoice finance.
Not covered here:
Comparing provider quotes over a year (see Invoice Finance Fee Comparison Spreadsheet), the true annual cost of a facility (see Invoice Finance APR Calculator), choosing a recruitment funder (see Best Invoice Finance for Recruitment Agencies), and published provider rates (see Invoice finance rates)
Why weekly payroll opens a cash gap
A temp desk pays out before it gets paid. The temp works Monday to Friday, submits a timesheet, and expects pay the following week. The client gets an invoice for the same hours and pays it on 30 days, or 45, or whenever its payment run falls. For every week of that gap you are carrying the whole cost of the temp: pay, holiday pay, employer NICs and pension.
On a steady desk the gap is a fixed amount you fund once. On a growing desk it gets bigger every week, because each new temp adds several weeks of cost before their first invoice is paid. That is why recruitment agencies that are winning work are often the ones short of cash, and why payroll funding (a form of invoice factoring or discounting built around weekly timesheets) exists.
The model makes the timing visible. It does not tell you which funder to use. Our guides to payroll finance for recruitment agencies and weekly payroll funding cover how the products work.
Try it in your browser
The same model runs below, starting with the worked example. Overwrite any figure and the results and the 26 weeks update. The download also lets you type a different headcount for any single week. We note the figures you enter and the result, so we can see whether the tool helps; this is never linked to an enquiry (see our privacy policy).
Your temp desk
Statutory figures, 2026 to 2027
Terms from your funding quote
That pay rate is below the National Living Wage for workers aged 21 and over (£12.71 an hour from 1 April 2026). Check it is right for the temps' ages.
Per temp per week
| Pay including rolled-up holiday pay | £627.59 |
|---|---|
| Employer NICs | £79.74 |
| Employer pension (averaged over all temps) | £10.66 |
| Employment cost | £717.99 |
| Charged to the client | £840.00 |
| Gross margin | £122.01 (14.5% of the charge) |
| Advance per temp after service fee, as % of employment cost | 104.1% |
Results over 26 weeks
| Weeks from week worked to client payment | 6 (37 days, rounded up to whole weeks) |
|---|---|
| Total invoiced over 26 weeks | £781,200 |
| Total employment cost | £667,731 |
| Total gross margin | £113,469 |
| Service fees | £7,812 |
| Discount charges | £4,989 |
| Total funding fees | £12,801 |
| Funding fees as % of gross margin | 11.3% |
| Funding fees per temp per week | £13.76 |
| Lowest cash balance without funding | -£123,916 (week 15) |
| Cash you would need to put in without funding | £123,916 |
| Lowest cash balance with funding | £35,981 (week 6) |
| Cash you would still need to put in with funding | £0 |
| Most funding drawn | £181,440 (week 16) |
| Debtors at the end of week 26 | £201,600 |
Week by week
| Week | Temps | Payroll paid | In, no funding | Cash, no funding | In, funded | Cash, funded | Funding drawn |
|---|---|---|---|---|---|---|---|
| 1 | 20 | £0 | £0 | £22,500 | £14,952 | £37,452 | £15,120 |
| 2 | 22 | £14,360 | £0 | £5,640 | £16,447 | £37,039 | £31,752 |
| 3 | 24 | £15,796 | £0 | -£12,656 | £17,942 | £36,686 | £49,896 |
| 4 | 26 | £17,232 | £0 | -£32,387 | £19,438 | £36,392 | £69,552 |
| 5 | 28 | £18,668 | £0 | -£53,555 | £20,933 | £36,157 | £90,720 |
| 6 | 30 | £20,104 | £0 | -£76,159 | £22,428 | £35,981 | £113,400 |
| 7 | 32 | £21,540 | £16,800 | -£83,399 | £25,496 | £37,437 | £122,472 |
| 8 | 34 | £22,976 | £18,480 | -£90,394 | £27,148 | £39,110 | £131,544 |
| 9 | 36 | £24,412 | £20,160 | -£97,146 | £28,801 | £40,999 | £140,616 |
| 10 | 38 | £25,848 | £21,840 | -£103,654 | £30,453 | £43,105 | £149,688 |
| 11 | 40 | £27,284 | £23,520 | -£109,917 | £32,106 | £45,427 | £158,760 |
| 12 | 40 | £28,720 | £25,200 | -£115,937 | £32,263 | £46,471 | £166,320 |
| 13 | 40 | £28,720 | £26,880 | -£120,276 | £32,420 | £47,671 | £172,368 |
| 14 | 40 | £28,720 | £28,560 | -£122,936 | £32,578 | £49,029 | £176,904 |
| 15 | 40 | £28,720 | £30,240 | -£123,916 | £32,735 | £50,545 | £179,928 |
| 16 | 40 | £28,720 | £31,920 | -£123,215 | £32,892 | £52,217 | £181,440 |
| 17 | 40 | £28,720 | £33,600 | -£120,835 | £33,049 | £54,047 | £181,440 |
| 18 | 40 | £28,720 | £33,600 | -£118,454 | £33,049 | £55,877 | £181,440 |
| 19 | 40 | £28,720 | £33,600 | -£116,074 | £33,049 | £57,707 | £181,440 |
| 20 | 40 | £28,720 | £33,600 | -£113,694 | £33,049 | £59,536 | £181,440 |
| 21 | 40 | £28,720 | £33,600 | -£111,313 | £33,049 | £61,366 | £181,440 |
| 22 | 40 | £28,720 | £33,600 | -£108,933 | £33,049 | £63,196 | £181,440 |
| 23 | 40 | £28,720 | £33,600 | -£106,552 | £33,049 | £65,026 | £181,440 |
| 24 | 40 | £28,720 | £33,600 | -£104,172 | £33,049 | £66,856 | £181,440 |
| 25 | 40 | £28,720 | £33,600 | -£101,792 | £33,049 | £68,685 | £181,440 |
| 26 | 40 | £28,720 | £33,600 | -£99,411 | £33,049 | £70,515 | £181,440 |
The example agency and its funding terms are invented to show how the model works, not any provider's pricing. Money is net of VAT and fees are shown without VAT. PAYE and NICs are treated as paid on pay day, which is earlier than HMRC collects them.
Worked example
A temp desk starts the half year with 20 temps on assignment and wins 2 more each week until it reaches 40 in week 11. Every temp works 40 hours at £14.00 an hour, which is above the £12.71 National Living Wage, and is charged to the client at £21.00. The agency, its clients and its funding terms are invented to show how the model behaves, and they are the example inputs in the download.
| Input | Example figure |
|---|---|
| Temps on assignment | 20 in week 1, 2 more each week, up to 40 |
| Hours per temp per week | 40 |
| Pay rate | £14.00 an hour, before holiday pay |
| Charge rate to the client | £21.00 an hour, net of VAT |
| Pay day | 1 week in arrears |
| Client terms | 30 days from invoice, paid on average 7 days late |
| Overheads | £2,500 a week |
| Opening cash | £25,000 |
| Share of temps enrolled in the pension | 70% |
| Funding: advance rate | 90% of each invoice |
| Funding: service fee | 1% of invoice value |
| Funding: discount charge | 3% a year over base rate (7.00% with base rate at 4%) |
Invented agency and illustrative funding terms. Not any provider's pricing. Base rate from the Bank of England.
View as plain-text Markdown
### Worked example: the agency and its funding quote | Input | Example figure | | --- | --- | | Temps on assignment | 20 in week 1, 2 more each week, up to 40 | | Hours per temp per week | 40 | | Pay rate | £14.00 an hour, before holiday pay | | Charge rate to the client | £21.00 an hour, net of VAT | | Pay day | 1 week in arrears | | Client terms | 30 days from invoice, paid on average 7 days late | | Overheads | £2,500 a week | | Opening cash | £25,000 | | Share of temps enrolled in the pension | 70% | | Funding: advance rate | 90% of each invoice | | Funding: service fee | 1% of invoice value | | Funding: discount charge | 3% a year over base rate (7.00% with base rate at 4%) | Invented agency and illustrative funding terms. Not any provider's pricing. Base rate from the Bank of England.
| Line | Per temp per week |
|---|---|
| Pay including rolled-up holiday pay | £627.59 |
| Employer NICs | £79.74 |
| Employer pension (averaged over all temps) | £10.66 |
| Employment cost | £717.99 |
| Charged to the client | £840.00 |
| Gross margin | £122.01 (14.5% of the charge) |
| Advance per temp after service fee, as % of employment cost | 104.1% |
Holiday pay rolled up at 12.07%. Employer NICs at 15% above £96 a week. Pension at 3% of pay between £120 and £967 a week, for the 70% of temps enrolled.
View as plain-text Markdown
### Worked example: one temp for one week, £840.00 charged | Line | Per temp per week | | --- | --- | | Pay including rolled-up holiday pay | £627.59 | | Employer NICs | £79.74 | | Employer pension (averaged over all temps) | £10.66 | | Employment cost | £717.99 | | Charged to the client | £840.00 | | Gross margin | £122.01 (14.5% of the charge) | | Advance per temp after service fee, as % of employment cost | 104.1% | Holiday pay rolled up at 12.07%. Employer NICs at 15% above £96 a week. Pension at 3% of pay between £120 and £967 a week, for the 70% of temps enrolled.
| Result | Value |
|---|---|
| Weeks from week worked to client payment | 6 (37 days, rounded up to whole weeks) |
| Total invoiced over 26 weeks | £781,200 |
| Total employment cost | £667,731 |
| Total gross margin | £113,469 |
| Service fees | £7,812 |
| Discount charges | £4,989 |
| Total funding fees | £12,801 |
| Funding fees as % of gross margin | 11.3% |
| Funding fees per temp per week | £13.76 |
| Lowest cash balance without funding | -£123,916 (week 15) |
| Cash you would need to put in without funding | £123,916 |
| Lowest cash balance with funding | £35,981 (week 6) |
| Cash you would still need to put in with funding | £0 |
| Most funding drawn | £181,440 (week 16) |
| Debtors at the end of week 26 | £201,600 |
Source: Market Invoice recruitment payroll funding cash model
Computed by the model on this page from the inputs above. Fees are on every invoice raised in the 26 weeks, including those paid after week 26.
View as plain-text Markdown
### Worked example results: £123,916 needed without funding, £0 with it | Result | Value | | --- | --- | | Weeks from week worked to client payment | 6 (37 days, rounded up to whole weeks) | | Total invoiced over 26 weeks | £781,200 | | Total employment cost | £667,731 | | Total gross margin | £113,469 | | Service fees | £7,812 | | Discount charges | £4,989 | | Total funding fees | £12,801 | | Funding fees as % of gross margin | 11.3% | | Funding fees per temp per week | £13.76 | | Lowest cash balance without funding | -£123,916 (week 15) | | Cash you would need to put in without funding | £123,916 | | Lowest cash balance with funding | £35,981 (week 6) | | Cash you would still need to put in with funding | £0 | | Most funding drawn | £181,440 (week 16) | | Debtors at the end of week 26 | £201,600 | Source: Market Invoice recruitment payroll funding cash model Computed by the model on this page from the inputs above. Fees are on every invoice raised in the 26 weeks, including those paid after week 26.
| Week | Temps | Payroll paid | Cash in, no funding | Closing cash, no funding | Cash in, funded | Closing cash, funded | Funding drawn |
|---|---|---|---|---|---|---|---|
| 1 | 20 | £0 | £0 | £22,500 | £14,952 | £37,452 | £15,120 |
| 2 | 22 | £14,360 | £0 | £5,640 | £16,447 | £37,039 | £31,752 |
| 3 | 24 | £15,796 | £0 | -£12,656 | £17,942 | £36,686 | £49,896 |
| 4 | 26 | £17,232 | £0 | -£32,387 | £19,438 | £36,392 | £69,552 |
| 5 | 28 | £18,668 | £0 | -£53,555 | £20,933 | £36,157 | £90,720 |
| 6 | 30 | £20,104 | £0 | -£76,159 | £22,428 | £35,981 | £113,400 |
| 7 | 32 | £21,540 | £16,800 | -£83,399 | £25,496 | £37,437 | £122,472 |
| 8 | 34 | £22,976 | £18,480 | -£90,394 | £27,148 | £39,110 | £131,544 |
| 9 | 36 | £24,412 | £20,160 | -£97,146 | £28,801 | £40,999 | £140,616 |
| 10 | 38 | £25,848 | £21,840 | -£103,654 | £30,453 | £43,105 | £149,688 |
| 11 | 40 | £27,284 | £23,520 | -£109,917 | £32,106 | £45,427 | £158,760 |
| 12 | 40 | £28,720 | £25,200 | -£115,937 | £32,263 | £46,471 | £166,320 |
| 13 | 40 | £28,720 | £26,880 | -£120,276 | £32,420 | £47,671 | £172,368 |
| 14 | 40 | £28,720 | £28,560 | -£122,936 | £32,578 | £49,029 | £176,904 |
| 15 | 40 | £28,720 | £30,240 | -£123,916 | £32,735 | £50,545 | £179,928 |
| 16 | 40 | £28,720 | £31,920 | -£123,215 | £32,892 | £52,217 | £181,440 |
| 17 | 40 | £28,720 | £33,600 | -£120,835 | £33,049 | £54,047 | £181,440 |
| 18 | 40 | £28,720 | £33,600 | -£118,454 | £33,049 | £55,877 | £181,440 |
| 19 | 40 | £28,720 | £33,600 | -£116,074 | £33,049 | £57,707 | £181,440 |
| 20 | 40 | £28,720 | £33,600 | -£113,694 | £33,049 | £59,536 | £181,440 |
| 21 | 40 | £28,720 | £33,600 | -£111,313 | £33,049 | £61,366 | £181,440 |
| 22 | 40 | £28,720 | £33,600 | -£108,933 | £33,049 | £63,196 | £181,440 |
| 23 | 40 | £28,720 | £33,600 | -£106,552 | £33,049 | £65,026 | £181,440 |
| 24 | 40 | £28,720 | £33,600 | -£104,172 | £33,049 | £66,856 | £181,440 |
| 25 | 40 | £28,720 | £33,600 | -£101,792 | £33,049 | £68,685 | £181,440 |
| 26 | 40 | £28,720 | £33,600 | -£99,411 | £33,049 | £70,515 | £181,440 |
Payroll paid is the previous week's employment cost. Cash in with funding is the advance on this week's invoice after the service fee, plus balances released on invoices clients paid this week, after the discount charge.
View as plain-text Markdown
### Worked example: 26 weeks of cash, 20 to 40 temps | Week | Temps | Payroll paid | Cash in, no funding | Closing cash, no funding | Cash in, funded | Closing cash, funded | Funding drawn | | --- | --- | --- | --- | --- | --- | --- | --- | | 1 | 20 | £0 | £0 | £22,500 | £14,952 | £37,452 | £15,120 | | 2 | 22 | £14,360 | £0 | £5,640 | £16,447 | £37,039 | £31,752 | | 3 | 24 | £15,796 | £0 | -£12,656 | £17,942 | £36,686 | £49,896 | | 4 | 26 | £17,232 | £0 | -£32,387 | £19,438 | £36,392 | £69,552 | | 5 | 28 | £18,668 | £0 | -£53,555 | £20,933 | £36,157 | £90,720 | | 6 | 30 | £20,104 | £0 | -£76,159 | £22,428 | £35,981 | £113,400 | | 7 | 32 | £21,540 | £16,800 | -£83,399 | £25,496 | £37,437 | £122,472 | | 8 | 34 | £22,976 | £18,480 | -£90,394 | £27,148 | £39,110 | £131,544 | | 9 | 36 | £24,412 | £20,160 | -£97,146 | £28,801 | £40,999 | £140,616 | | 10 | 38 | £25,848 | £21,840 | -£103,654 | £30,453 | £43,105 | £149,688 | | 11 | 40 | £27,284 | £23,520 | -£109,917 | £32,106 | £45,427 | £158,760 | | 12 | 40 | £28,720 | £25,200 | -£115,937 | £32,263 | £46,471 | £166,320 | | 13 | 40 | £28,720 | £26,880 | -£120,276 | £32,420 | £47,671 | £172,368 | | 14 | 40 | £28,720 | £28,560 | -£122,936 | £32,578 | £49,029 | £176,904 | | 15 | 40 | £28,720 | £30,240 | -£123,916 | £32,735 | £50,545 | £179,928 | | 16 | 40 | £28,720 | £31,920 | -£123,215 | £32,892 | £52,217 | £181,440 | | 17 | 40 | £28,720 | £33,600 | -£120,835 | £33,049 | £54,047 | £181,440 | | 18 | 40 | £28,720 | £33,600 | -£118,454 | £33,049 | £55,877 | £181,440 | | 19 | 40 | £28,720 | £33,600 | -£116,074 | £33,049 | £57,707 | £181,440 | | 20 | 40 | £28,720 | £33,600 | -£113,694 | £33,049 | £59,536 | £181,440 | | 21 | 40 | £28,720 | £33,600 | -£111,313 | £33,049 | £61,366 | £181,440 | | 22 | 40 | £28,720 | £33,600 | -£108,933 | £33,049 | £63,196 | £181,440 | | 23 | 40 | £28,720 | £33,600 | -£106,552 | £33,049 | £65,026 | £181,440 | | 24 | 40 | £28,720 | £33,600 | -£104,172 | £33,049 | £66,856 | £181,440 | | 25 | 40 | £28,720 | £33,600 | -£101,792 | £33,049 | £68,685 | £181,440 | | 26 | 40 | £28,720 | £33,600 | -£99,411 | £33,049 | £70,515 | £181,440 | Payroll paid is the previous week's employment cost. Cash in with funding is the advance on this week's invoice after the service fee, plus balances released on invoices clients paid this week, after the discount charge.
What the example shows
- Profitable temps, falling bank balance. Every temp makes £122.01 a week, 14.5% of the charge. But on its own money the agency's cash turns negative in week 3 and bottoms out at -£123,916 in week 15. Clients pay in week 7 for work done in week 1, so the agency funds 5 weeks of payroll for every temp before any money comes back.
- The advance has to cover the payroll. A 90% advance on £840.00, less the service fee, is 104.1% of the £717.99 a temp costs. Because it is over 100%, the funded balance stays positive all the way through the growth, lowest at £35,981 in week 6. At a 75% advance the same desk still gets by, but only just: the advance covers 86.6% of the cost, and the balance drops to £17,043 in week 7.
- The facility limit matters as much as the price. Funding drawn peaks at £181,440 once the desk reaches 40 temps. A facility with a lower limit would stop funding new invoices partway through the growth, so check the limit in your quote against this figure, not just the fee rates.
- Slow clients cost more than time. If clients paid 14 days later on average, the cash needed without funding would rise from £123,916 to £186,355, the funding drawn would peak at £241,920 rather than £181,440, and fees would go up from £12,801 to £14,689.
- Fees take a share of margin, not of turnover. £12,801 of fees is 11.3% of the desk's gross margin over the half year, about £13.76 per temp per week. That is the figure to weigh against the growth the funding pays for.
Statutory figures used
The model starts with these figures for the 2026 to 2027 tax year. Each one is editable, because they change every April and because your own payroll may treat some workers differently.
| Figure | Value | Source |
|---|---|---|
| Employer NICs rate | 15% | |
| NICs secondary threshold | £96 a week (£5,000 a year) | |
| Employer pension minimum | 3% of qualifying earnings | |
| Qualifying earnings band | £120 to £967 a week (£6,240 to £50,270 a year) | |
| Rolled-up holiday pay | 12.07% of pay in the pay period | |
| National Living Wage (21 and over) | £12.71 an hour from 1 April 2026 | |
| Bank of England base rate | 4% |
How each line is calculated
Every figure in the workbook is a visible formula on the Results and Weekly sheets, so you can check it.
- Pay per temp = hours x pay rate x (1 + holiday pay %), with holiday pay rolled up into each week's pay.
- Employer NICs = NICs rate x (pay per temp minus the weekly secondary threshold), never below zero.
- Employer pension = share of temps enrolled x employer rate x (pay per temp, capped at the upper limit, minus the lower limit), never below zero.
- Employment cost = pay + employer NICs + employer pension, paid in the week worked plus the pay lag.
- Invoice = temps x hours x charge rate, net of VAT, raised at the end of the week worked.
- Collection week = week worked + (client terms + days late) / 7, rounded up to a whole week.
- Cash in without funding = invoices whose collection week is this week.
- Cash in with funding = this week's invoice x (advance rate minus service fee), plus, for invoices collected this week, the invoice less the advance less the discount charge.
- Discount charge = advance x (base rate + margin) x (terms + days late) / 365.
- Funding drawn = advances on invoices raised and not yet paid.
What it does not cover
The model is a cash timing tool, not a payroll. It treats PAYE and NICs as leaving on pay day, although HMRC collects them later, which makes the cash position look a little worse than it will be. It leaves out VAT, the Employment Allowance and the Apprenticeship Levy (see the FAQ), statutory sick pay, bad debts, credit notes, disputed timesheets and any minimum fee in your funding agreement.
It assumes every client pays on the same terms; if one large client pays much later than the rest, run it as a separate desk. Funding quotes are not all built this way: some charge a single all-in percentage, some price the payroll service separately. Set the fee inputs to match your quote's wording.
If you are comparing funders, the fee comparison model lines up three quotes over a year, and the APR equivalent calculator turns a quote into an annual cost. Our best invoice finance for recruitment agencies page compares the specialist providers, the recruitment payroll funding statistics give the market context, and the recruitment finance hub links the rest.
Founder & Managing Director, Muswell Rose, founder and PSC of Best Business Loans Ltd
Adam was managing director of Penny, a UK invoice finance business, from July 2020 to November 2023. His career runs through insurance, mortgages, commercial finance and fintech lending. He writes the Market Invoice library. Career record.
Last updated: