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.

Download Excel model

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

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
120£0£0£22,500£14,952£37,452£15,120
222£14,360£0£5,640£16,447£37,039£31,752
324£15,796£0-£12,656£17,942£36,686£49,896
426£17,232£0-£32,387£19,438£36,392£69,552
528£18,668£0-£53,555£20,933£36,157£90,720
630£20,104£0-£76,159£22,428£35,981£113,400
732£21,540£16,800-£83,399£25,496£37,437£122,472
834£22,976£18,480-£90,394£27,148£39,110£131,544
936£24,412£20,160-£97,146£28,801£40,999£140,616
1038£25,848£21,840-£103,654£30,453£43,105£149,688
1140£27,284£23,520-£109,917£32,106£45,427£158,760
1240£28,720£25,200-£115,937£32,263£46,471£166,320
1340£28,720£26,880-£120,276£32,420£47,671£172,368
1440£28,720£28,560-£122,936£32,578£49,029£176,904
1540£28,720£30,240-£123,916£32,735£50,545£179,928
1640£28,720£31,920-£123,215£32,892£52,217£181,440
1740£28,720£33,600-£120,835£33,049£54,047£181,440
1840£28,720£33,600-£118,454£33,049£55,877£181,440
1940£28,720£33,600-£116,074£33,049£57,707£181,440
2040£28,720£33,600-£113,694£33,049£59,536£181,440
2140£28,720£33,600-£111,313£33,049£61,366£181,440
2240£28,720£33,600-£108,933£33,049£63,196£181,440
2340£28,720£33,600-£106,552£33,049£65,026£181,440
2440£28,720£33,600-£104,172£33,049£66,856£181,440
2540£28,720£33,600-£101,792£33,049£68,685£181,440
2640£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.

Worked example: the agency and its funding quote
InputExample figure
Temps on assignment20 in week 1, 2 more each week, up to 40
Hours per temp per week40
Pay rate£14.00 an hour, before holiday pay
Charge rate to the client£21.00 an hour, net of VAT
Pay day1 week in arrears
Client terms30 days from invoice, paid on average 7 days late
Overheads£2,500 a week
Opening cash£25,000
Share of temps enrolled in the pension70%
Funding: advance rate90% of each invoice
Funding: service fee1% of invoice value
Funding: discount charge3% 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.
Worked example: one temp for one week, £840.00 charged
LinePer 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 cost104.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.
Worked example results: £123,916 needed without funding, £0 with it
ResultValue
Weeks from week worked to client payment6 (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 margin11.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.
Worked example: 26 weeks of cash, 20 to 40 temps
WeekTempsPayroll paidCash in, no fundingClosing cash, no fundingCash in, fundedClosing cash, fundedFunding drawn
120£0£0£22,500£14,952£37,452£15,120
222£14,360£0£5,640£16,447£37,039£31,752
324£15,796£0-£12,656£17,942£36,686£49,896
426£17,232£0-£32,387£19,438£36,392£69,552
528£18,668£0-£53,555£20,933£36,157£90,720
630£20,104£0-£76,159£22,428£35,981£113,400
732£21,540£16,800-£83,399£25,496£37,437£122,472
834£22,976£18,480-£90,394£27,148£39,110£131,544
936£24,412£20,160-£97,146£28,801£40,999£140,616
1038£25,848£21,840-£103,654£30,453£43,105£149,688
1140£27,284£23,520-£109,917£32,106£45,427£158,760
1240£28,720£25,200-£115,937£32,263£46,471£166,320
1340£28,720£26,880-£120,276£32,420£47,671£172,368
1440£28,720£28,560-£122,936£32,578£49,029£176,904
1540£28,720£30,240-£123,916£32,735£50,545£179,928
1640£28,720£31,920-£123,215£32,892£52,217£181,440
1740£28,720£33,600-£120,835£33,049£54,047£181,440
1840£28,720£33,600-£118,454£33,049£55,877£181,440
1940£28,720£33,600-£116,074£33,049£57,707£181,440
2040£28,720£33,600-£113,694£33,049£59,536£181,440
2140£28,720£33,600-£111,313£33,049£61,366£181,440
2240£28,720£33,600-£108,933£33,049£63,196£181,440
2340£28,720£33,600-£106,552£33,049£65,026£181,440
2440£28,720£33,600-£104,172£33,049£66,856£181,440
2540£28,720£33,600-£101,792£33,049£68,685£181,440
2640£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

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.

FigureValueSource
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.

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.

AP

Adam Parker

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:

Short of Cash for Payroll?

If the model shows your desk running out of cash as it grows, tell us about your business. We pass your details to one or more of the finance partners we work with, who come back to you with quotes. Free, no obligation.

Step 1 of 3 · Your business

Start typing and we'll search Companies House.

Free to you. We may be paid by the finance partners we introduce you to. This could be a fee or commission, depending on the partner and the finance arranged. It does not change what you pay. See our privacy policy.

Free · No obligation · Nothing to pay us

How we make money: Market Invoice is an independent comparison service, not a lender. We may be paid by the finance partners we introduce you to. This could be a fee or commission, depending on the partner and the finance arranged. It does not change what you pay. How we are funded.

Recruitment Payroll Cash Model FAQ

Why does a growing temp desk run out of cash even when every placement makes money?

Because temps are paid weekly and clients pay weeks later. In the worked example each temp earns a gross margin of £122.01 a week, but pay leaves 1 week after the work and the client's money arrives 6 weeks after it. Every temp you add needs about 5 weeks of employment cost funded before their first invoice is paid, so the faster the desk grows the deeper the hole. Without funding the example agency would need £123,916 more cash by week 15.

What is the single number to check on a payroll funding quote?

Whether the advance on a week's invoice, after the service fee, covers that week's employment cost. The model shows it as a percentage. At 90% the example agency's advance covers 104.1% of each temp's cost, so funding keeps pace with growth. At 75% it covers 86.6%: each new temp still takes cash out of the business until their client pays.

Which holiday pay figure should I use?

GOV.UK sets rolled-up holiday pay at 12.07% of pay for irregular hours and part-year workers, for leave years starting on or after 1 April 2024. Many temps fit that description, but not all. If you accrue holiday and pay it when it is taken, the cash leaves later and in lumps rather than every week; set the holiday figure to match how you actually pay.

Why is VAT left out?

VAT you charge the client is not your money: you collect it and pay it on to HMRC. If your funder advances against the VAT-inclusive invoice, that gives you extra cash for a while and then takes it back when the VAT return is due, so do not treat it as headroom. Leaving VAT out keeps the model to the cash you can actually spend.

My contractors invoice through their own limited companies. Does the model still work?

Yes, with changes. For a contractor working through their own limited company outside IR35, or through an umbrella company (which employs the worker and builds those costs into the rate it charges you), you do not run employer NICs, pension or holiday pay yourself.

Set those three figures to zero and enter the rate you pay the contractor or umbrella as the pay rate. Where the off-payroll working rules apply and the agency is the deemed employer, HMRC guidance says it must deduct tax and pay employer NICs, so keep NICs in for those workers. The timing of the cash gap is the same either way.

Does the model include the Employment Allowance or the Apprenticeship Levy?

No. The Employment Allowance can cut an eligible employer's NICs bill by up to £10,500 a year, and the Apprenticeship Levy of 0.5% applies only to pay bills over £3 million. Both depend on your whole business, not the temp desk, so the model leaves them out. Leaving the allowance out makes the cash position look slightly worse than it will be.