Explore the finance pack / Professional services
Professional services.
The numbers behind the decisions.
Are the right grades doing the work, are fees recovering their cost, and where is completed work waiting to be billed or collected?
Fictional company, records and figures. Real platform names identify example systems, without implying client relationships or partnerships.
Base forecast selected. Historical figures and the original budget stay unchanged.
Engagement economics and cash
August revenue is €276,874, with 92.5% chargeable utilisation. Net unbilled work of €176,942 needs separate attention from invoiced receivables.
Base scheduled cash reaches €150,240 on 2026-10-26. The reserve is €100,000. The daily schedule remains above the minimum reserve.
August revenue€276,874Invented actuals
August EBITDA€99,465After payroll and operating overheads
Net unbilled work€176,942At 31 August
Lowest daily cash€150,2402026-10-26
| Metric | Actual | Original budget | Variance |
|---|---|---|---|
| Revenue | €276,874 | €284,889 | −€8,016 |
| Gross profit | €166,965 | €174,232 | −€7,266 |
| EBITDA | €99,465 | €109,157 | −€9,691 |
| Net profit | €76,573 | €84,326 | −€7,753 |
| Engagement | Service | Hours | Rate/hour | Realisation | Revenue | Allocated payroll | Contribution | Net unbilled |
|---|---|---|---|---|---|---|---|---|
| PS-01 | Strategy retainer | 280 | €140 | 97.0% | €38,024 | €13,694 | €24,330 | €27,681 |
| PS-02 | Finance transformation | 460 | €130 | 94.0% | €56,212 | €19,766 | €36,446 | €28,331 |
| PS-03 | Regulatory advisory | 310 | €125 | 96.0% | €37,200 | €13,853 | €23,347 | €26,559 |
| PS-04 | Transaction support | 380 | €160 | 92.0% | €55,936 | €19,238 | €36,698 | €30,635 |
| PS-05 | Analytics programme | 460 | €110 | 95.0% | €48,070 | €18,141 | €29,929 | €35,129 |
| PS-06 | Technology advisory | 330 | €135 | 93.0% | €41,432 | €14,180 | €27,252 | €28,607 |
All businesses, records and figures are fictional. The example demonstrates reporting method, not client results.
Performance against the original plan
Year-to-date revenue is €1,894,470 versus €1,947,469 budget. The full-year base outlook is €3,006,269 revenue and €874,117 EBITDA.
Revenue variance reflects hours, rates and realised value. Unbilled recoverability is a separate expense, while all paid staff remain in direct payroll regardless of utilisation.
| Metric | YTD actual | YTD budget | YTD variance | Full-year outlook | Full-year budget | FY variance |
|---|---|---|---|---|---|---|
| Revenue | €1,894,470 | €1,947,469 | −€53,000 | €3,006,268 | €3,091,244 | −€84,976 |
| Gross profit | €1,017,964 | €1,066,122 | −€48,157 | €1,692,617 | €1,769,757 | −€77,140 |
| EBITDA | €491,964 | €558,822 | −€66,857 | €874,117 | €980,382 | −€106,265 |
| Net profit | €372,365 | €425,850 | −€53,486 | €664,416 | €749,428 | −€85,012 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | €193,550 | €207,712 | €220,716 | €230,429 | €242,210 | €258,795 | €264,183 | €276,874 | €279,310 | €279,538 | €281,002 | €271,948 |
| Direct payroll | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€103,525 | −€103,525 | −€103,525 | −€103,525 |
| Materials | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Subcontractors | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Direct systems and software | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,800 | −€7,800 | −€7,800 | −€7,800 |
| Unbilled recoverability charge / (release) | −€1,187 | −€1,307 | −€1,436 | −€1,495 | −€1,615 | −€1,748 | −€1,809 | −€1,908 | €574 | €576 | €578 | €6,426 |
| Direct costs | −€109,187 | −€109,307 | −€109,436 | −€109,495 | −€109,615 | −€109,748 | −€109,809 | −€109,908 | −€110,751 | −€110,749 | −€110,747 | −€104,899 |
| Gross profit | €84,363 | €98,406 | €111,280 | €120,934 | €132,596 | €149,047 | €154,374 | €166,965 | €168,559 | €168,789 | €170,255 | €167,050 |
| Gross margin | 43.6% | 47.4% | 50.4% | 52.5% | 54.7% | 57.6% | 58.4% | 60.3% | 60.3% | 60.4% | 60.6% | 61.4% |
| Management and administration payroll | −€45,000 | −€45,500 | −€46,000 | −€46,500 | −€47,000 | −€47,500 | −€48,000 | −€48,500 | −€51,000 | −€51,500 | −€52,500 | −€53,500 |
| Business development | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€13,000 | −€13,000 | −€13,000 | −€13,000 |
| Office, insurance and general costs | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€8,000 | −€8,000 | −€8,000 | −€8,000 |
| Operating expenses | −€64,000 | −€64,500 | −€65,000 | −€65,500 | −€66,000 | −€66,500 | −€67,000 | −€67,500 | −€72,000 | −€72,500 | −€73,500 | −€74,500 |
| EBITDA | €20,363 | €33,906 | €46,280 | €55,434 | €66,596 | €82,547 | €87,374 | €99,465 | €96,559 | €96,289 | €96,755 | €92,550 |
| EBITDA margin | 10.5% | 16.3% | 21.0% | 24.1% | 27.5% | 31.9% | 33.1% | 35.9% | 34.6% | 34.4% | 34.4% | 34.0% |
| Depreciation | −€2,193 | −€2,277 | −€2,443 | −€2,568 | −€2,756 | −€2,860 | −€3,027 | −€3,152 | −€3,527 | −€3,652 | −€3,777 | −€3,902 |
| EBIT | €18,170 | €31,629 | €43,837 | €52,865 | €63,840 | €79,687 | €84,348 | €96,314 | €93,033 | €92,637 | €92,979 | €88,648 |
| Interest | −€710 | −€694 | −€678 | −€662 | −€646 | −€630 | −€614 | −€598 | −€582 | −€566 | −€550 | −€534 |
| Profit before tax | €17,460 | €30,935 | €43,158 | €52,203 | €63,194 | €79,057 | €83,734 | €95,716 | €92,451 | €92,071 | €92,429 | €88,114 |
| Illustrative current tax | −€3,492 | −€6,187 | −€8,632 | −€10,441 | −€12,639 | −€15,811 | −€16,747 | −€19,143 | −€18,490 | −€18,414 | −€18,486 | −€17,623 |
| Net profit | €13,968 | €24,748 | €34,527 | €41,762 | €50,555 | €63,246 | €66,987 | €76,573 | €73,961 | €73,657 | €73,943 | €70,491 |
Linked financial statements
Earned revenue, billings and cash are distinct. Gross unbilled work less its recoverability allowance flows to the balance sheet. Its net change forms part of the indirect cash-flow reconciliation.
December closing cash is €472,677. No new borrowing is assumed.
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash / (unfunded cash requirement) | €86,112 | €13,525 | €27,521 | €32,266 | €58,374 | €68,057 | €122,069 | €171,657 | €210,930 | €302,987 | €394,471 | €472,677 |
| Trade receivables | €174,195 | €253,706 | €243,500 | €262,689 | €267,213 | €295,026 | €291,454 | €305,454 | €333,507 | €334,364 | €337,671 | €414,502 |
| Contract asset / net unbilled work | €18,168 | €37,633 | €58,268 | €79,815 | €102,421 | €126,553 | €151,163 | €176,942 | €169,137 | €161,326 | €153,474 | €64,718 |
| Retention receivables | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Prepayments | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 |
| Current tax prepayment | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Current assets | €292,475 | €318,864 | €343,288 | €388,770 | €442,009 | €503,636 | €578,686 | €668,053 | €727,574 | €812,677 | €899,617 | €965,898 |
| Fixed assets at cost | €136,000 | €140,000 | €148,000 | €154,000 | €163,000 | €168,000 | €176,000 | €182,000 | €200,000 | €206,000 | €212,000 | €218,000 |
| Accumulated depreciation | €41,193 | €43,470 | €45,913 | €48,481 | €51,237 | €54,097 | €57,123 | €60,275 | €63,801 | €67,453 | €71,229 | €75,131 |
| Net fixed assets | €94,807 | €96,530 | €102,087 | €105,519 | €111,763 | €113,903 | €118,877 | €121,725 | €136,199 | €138,547 | €140,771 | €142,869 |
| Total assets | €387,282 | €415,394 | €445,375 | €494,289 | €553,772 | €617,540 | €697,563 | €789,778 | €863,773 | €951,224 | €1,040,388 | €1,108,767 |
| Trade payables | €6,323 | €7,000 | €6,323 | €6,533 | €6,323 | €6,533 | €6,323 | €6,323 | €9,366 | €8,246 | €8,481 | €8,246 |
| Payroll accruals | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 |
| Contract liabilities / customer advances | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Current tax payable | €17,492 | €23,679 | €23,311 | €33,751 | €46,390 | €50,201 | €66,948 | €86,091 | €86,581 | €104,995 | €123,481 | €125,104 |
| Current operating liabilities | €38,815 | €45,679 | €44,633 | €55,284 | €67,712 | €71,735 | €88,271 | €107,414 | €110,948 | €128,242 | €146,963 | €148,351 |
| Debt | €151,500 | €148,000 | €144,500 | €141,000 | €137,500 | €134,000 | €130,500 | €127,000 | €123,500 | €120,000 | €116,500 | €113,000 |
| Total liabilities | €190,315 | €193,679 | €189,133 | €196,284 | €205,212 | €205,735 | €218,771 | €234,414 | €234,448 | €248,242 | €263,463 | €261,351 |
| Share capital | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 |
| Retained earnings | €146,968 | €171,715 | €206,242 | €248,005 | €298,559 | €361,805 | €428,792 | €505,365 | €579,325 | €652,982 | €726,925 | €797,416 |
| Equity | €196,968 | €221,715 | €256,242 | €298,005 | €348,559 | €411,805 | €478,792 | €555,365 | €629,325 | €702,982 | €776,925 | €847,416 |
| Liabilities and equity | €387,282 | €415,394 | €445,375 | €494,289 | €553,772 | €617,540 | €697,563 | €789,778 | €863,773 | €951,224 | €1,040,388 | €1,108,767 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Net profit | €13,968 | €24,748 | €34,527 | €41,762 | €50,555 | €63,246 | €66,987 | €76,573 | €73,961 | €73,657 | €73,943 | €70,491 |
| Depreciation add-back | €2,193 | €2,277 | €2,443 | €2,568 | €2,756 | €2,860 | €3,027 | €3,152 | €3,527 | €3,652 | €3,777 | €3,902 |
| Change in trade receivables | −€174,195 | −€79,511 | €10,206 | −€19,189 | −€4,524 | −€27,813 | €3,573 | −€14,000 | −€28,053 | −€856 | −€3,308 | −€76,831 |
| Change in contract assets / net unbilled work | −€18,168 | −€19,464 | −€20,635 | −€21,547 | −€22,606 | −€24,132 | −€24,610 | −€25,779 | €7,805 | €7,811 | €7,852 | €88,756 |
| Change in retentions | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Change in trade payables | −€16,677 | €677 | −€677 | €211 | −€211 | €211 | −€211 | −€0.000645 | €3,044 | −€1,120 | €235 | −€235 |
| Change in customer advances | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Change in net current tax | €3,492 | €6,187 | −€368 | €10,441 | €12,639 | €3,811 | €16,747 | €19,143 | €490 | €18,414 | €18,486 | €1,623 |
| Operating cash flow | −€189,388 | −€65,087 | €25,495 | €14,245 | €38,609 | €18,183 | €65,513 | €59,088 | €60,773 | €101,557 | €100,985 | €87,706 |
| Capital expenditure | −€6,000 | −€4,000 | −€8,000 | −€6,000 | −€9,000 | −€5,000 | −€8,000 | −€6,000 | −€18,000 | −€6,000 | −€6,000 | −€6,000 |
| Investing cash flow | −€6,000 | −€4,000 | −€8,000 | −€6,000 | −€9,000 | −€5,000 | −€8,000 | −€6,000 | −€18,000 | −€6,000 | −€6,000 | −€6,000 |
| Debt principal repayment | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 |
| Financing cash flow | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 |
| Net cash change | −€198,888 | −€72,587 | €13,995 | €4,745 | €26,109 | €9,683 | €54,013 | €49,588 | €39,273 | €92,057 | €91,485 | €78,206 |
| Opening cash | €285,000 | €86,112 | €13,525 | €27,521 | €32,266 | €58,374 | €68,057 | €122,069 | €171,657 | €210,930 | €302,987 | €394,471 |
| Closing cash | €86,112 | €13,525 | €27,521 | €32,266 | €58,374 | €68,057 | €122,069 | €171,657 | €210,930 | €302,987 | €394,471 | €472,677 |
Rates, realisation and team capacity
August loaded payroll is €101,000. €98,871 is allocated through grade mix; €2,129 remains unallocated and stays in the P&L.
Aggregate utilisation hides a senior-grade constraint. August Partner demand is 197.7 hours against 160 available; Manager demand is 575.0 hours against 480. The delivery plan needs reallocation, added senior capacity or an agreed overtime response. No automatic overtime premium is assumed.
| Grade | Aug paid FTE | Aug loaded monthly pay | Aug hours available | Aug hours allocated | Aug utilisation | Dec hours available | Dec hours allocated | Dec utilisation |
|---|---|---|---|---|---|---|---|---|
| Partner | 1 | €12,000 | 160 | 197.7 | 123.6% | 160 | 197.6 | 123.5% |
| Manager | 3 | €8,500 | 480 | 575 | 119.8% | 480 | 565 | 117.7% |
| Consultant | 7 | €6,500 | 1,120 | 1,023.3 | 91.4% | 1,120 | 1,001.4 | 89.4% |
| Analyst | 4 | €4,500 | 640 | 424 | 66.2% | 640 | 416 | 65.0% |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Paid FTE | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 |
| Available hours | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 |
| Chargeable hours | 1,570 | 1,680 | 1,780 | 1,860 | 1,950 | 2,080 | 2,120 | 2,220 | 2,240 | 2,240 | 2,250 | 2,180 |
| Utilisation | 65.4% | 70.0% | 74.2% | 77.5% | 81.2% | 86.7% | 88.3% | 92.5% | 93.3% | 93.3% | 93.8% | 90.8% |
| Total loaded payroll | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €103,525 | €103,525 | €103,525 | €103,525 |
| Payroll attributed to engagements | €69,534 | €74,532 | €79,058 | €82,537 | €86,634 | €92,508 | €94,380 | €98,871 | €102,248 | €102,344 | €102,888 | €99,648 |
| Unallocated payroll | €31,466 | €26,468 | €21,942 | €18,463 | €14,366 | €8,492 | €6,620 | €2,129 | €1,277 | €1,181 | €637 | €3,877 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 240 | 250 | 250 | 260 | 260 | 270 | 270 | 280 | 290 | 290 | 300 | 300 |
| Contract rate | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 |
| Realisation | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% |
| Revenue | €32,592 | €33,950 | €33,950 | €35,308 | €35,308 | €36,666 | €36,666 | €38,024 | €39,382 | €39,382 | €40,740 | €40,740 |
| Invoices issued | €29,333 | €30,555 | €30,555 | €31,777 | €31,777 | €32,999 | €32,999 | €34,222 | €40,563 | €40,563 | €41,962 | €54,999 |
| Net unbilled work | €3,194 | €6,521 | €9,848 | €13,308 | €16,769 | €20,362 | €23,955 | €27,681 | €26,524 | €25,366 | €24,168 | €10,194 |
| Engagement contribution | €20,854 | €21,723 | €21,723 | €22,592 | €22,592 | €23,461 | €23,461 | €24,330 | €24,845 | €24,845 | €25,701 | €25,701 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 150 | 190 | 250 | 300 | 350 | 400 | 420 | 460 | 450 | 430 | 400 | 350 |
| Contract rate | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 |
| Realisation | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% |
| Revenue | €18,330 | €23,218 | €30,550 | €36,660 | €42,770 | €48,880 | €51,324 | €56,212 | €54,990 | €52,546 | €48,880 | €42,770 |
| Invoices issued | €16,497 | €20,896 | €27,495 | €32,994 | €38,493 | €43,992 | €46,192 | €50,591 | €56,640 | €54,122 | €50,346 | €57,740 |
| Net unbilled work | €1,686 | €3,822 | €6,633 | €10,006 | €13,941 | €18,438 | €23,159 | €28,331 | €26,813 | €25,363 | €24,014 | €10,242 |
| Engagement contribution | €11,885 | €15,054 | €19,808 | €23,769 | €27,731 | €31,692 | €33,277 | €36,446 | €35,171 | €33,608 | €31,263 | €27,355 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 260 | 270 | 270 | 280 | 280 | 300 | 300 | 310 | 310 | 320 | 320 | 320 |
| Contract rate | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 |
| Realisation | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% |
| Revenue | €31,200 | €32,400 | €32,400 | €33,600 | €33,600 | €36,000 | €36,000 | €37,200 | €37,200 | €38,400 | €38,400 | €38,400 |
| Invoices issued | €28,080 | €29,160 | €29,160 | €30,240 | €30,240 | €32,400 | €32,400 | €33,480 | €38,316 | €39,552 | €39,552 | €51,840 |
| Net unbilled work | €3,042 | €6,201 | €9,360 | €12,636 | €15,912 | €19,422 | €22,932 | €26,559 | €25,471 | €24,348 | €23,224 | €10,120 |
| Engagement contribution | €19,581 | €20,334 | €20,334 | €21,088 | €21,088 | €22,594 | €22,594 | €23,347 | €23,001 | €23,742 | €23,742 | €23,742 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 220 | 250 | 280 | 280 | 310 | 340 | 360 | 380 | 380 | 390 | 400 | 380 |
| Contract rate | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 |
| Realisation | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% |
| Revenue | €32,384 | €36,800 | €41,216 | €41,216 | €45,632 | €50,048 | €52,992 | €55,936 | €55,936 | €57,408 | €58,880 | €55,936 |
| Invoices issued | €29,146 | €33,120 | €37,094 | €37,094 | €41,069 | €45,043 | €47,693 | €50,342 | €57,614 | €59,130 | €60,646 | €75,514 |
| Net unbilled work | €2,785 | €5,950 | €9,494 | €13,039 | €16,963 | €21,267 | €25,825 | €30,635 | €29,192 | €27,711 | €26,192 | €9,355 |
| Engagement contribution | €21,246 | €24,144 | €27,041 | €27,041 | €29,938 | €32,836 | €34,767 | €36,698 | €36,218 | €37,171 | €38,124 | €36,218 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 420 | 430 | 430 | 440 | 440 | 450 | 450 | 460 | 470 | 470 | 480 | 480 |
| Contract rate | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 |
| Realisation | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% |
| Revenue | €43,890 | €44,935 | €44,935 | €45,980 | €45,980 | €47,025 | €47,025 | €48,070 | €49,115 | €49,115 | €50,160 | €50,160 |
| Invoices issued | €39,501 | €40,442 | €40,442 | €41,382 | €41,382 | €42,322 | €42,322 | €43,263 | €50,588 | €50,588 | €51,665 | €67,716 |
| Net unbilled work | €4,191 | €8,483 | €12,774 | €17,165 | €21,556 | €26,047 | €30,538 | €35,129 | €33,722 | €32,314 | €30,877 | €14,111 |
| Engagement contribution | €27,326 | €27,977 | €27,977 | €28,628 | €28,628 | €29,278 | €29,278 | €29,929 | €30,116 | €30,116 | €30,757 | €30,757 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 280 | 290 | 300 | 300 | 310 | 320 | 320 | 330 | 340 | 340 | 350 | 350 |
| Contract rate | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 |
| Realisation | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% |
| Revenue | €35,154 | €36,410 | €37,665 | €37,665 | €38,920 | €40,176 | €40,176 | €41,432 | €42,687 | €42,687 | €43,942 | €43,942 |
| Invoices issued | €31,639 | €32,769 | €33,898 | €33,898 | €35,028 | €36,158 | €36,158 | €37,288 | €43,968 | €43,968 | €45,261 | €59,322 |
| Net unbilled work | €3,269 | €6,655 | €10,158 | €13,661 | €17,281 | €21,017 | €24,753 | €28,607 | €27,416 | €26,225 | €24,999 | €10,695 |
| Engagement contribution | €23,123 | €23,949 | €24,774 | €24,774 | €25,600 | €26,426 | €26,426 | €27,252 | €27,712 | €27,712 | €28,527 | €28,527 |
Receivables, payables and cash conversion
€155,782 of August trade receivables is overdue. €1,201 of supplier invoices remains pending approval, review or hold release. The liabilities remain on the balance sheet even when excluded from scheduled payments.
Unbilled work is separate from invoice ageing. Billing entitlement, client acceptance and recoverability are reviewed by engagement before a balance becomes an invoice.
| Age bucket | Outstanding |
|---|---|
| Current | €149,672 |
| 1–30 | €76,364 |
| 31–60 | €42,764 |
| 61–90 | €36,654 |
| 90+ | €0 |
| Invoice | Customer | Issued | Due | Outstanding | Planned receipt | Case receipt | Days overdue |
|---|---|---|---|---|---|---|---|
| AR-01 | Fictional customer 01 | 2026-05-20 | 2026-06-19 | €36,654 | 2026-09-04 | 2026-09-04 | 73 |
| AR-02 | Fictional customer 02 | 2026-06-18 | 2026-07-18 | €42,764 | 2026-09-08 | 2026-09-08 | 44 |
| AR-03 | Fictional customer 03 | 2026-07-06 | 2026-08-05 | €27,491 | 2026-09-11 | 2026-09-11 | 26 |
| AR-04 | Fictional customer 04 | 2026-07-20 | 2026-08-19 | €48,873 | 2026-09-15 | 2026-09-15 | 12 |
| AR-05 | Fictional customer 05 | 2026-08-02 | 2026-09-01 | €30,545 | 2026-09-18 | 2026-09-18 | 0 |
| AR-06 | Fictional customer 06 | 2026-08-10 | 2026-09-09 | €39,709 | 2026-09-22 | 2026-09-22 | 0 |
| AR-07 | Fictional customer 07 | 2026-08-18 | 2026-09-17 | €33,600 | 2026-09-25 | 2026-09-25 | 0 |
| AR-08 | Fictional customer 08 | 2026-08-25 | 2026-09-24 | €45,818 | 2026-10-02 | 2026-10-02 | 0 |
| Invoice | Supplier | Original invoice | Paid to date | Outstanding | Approval | Review | Hold | Payment date |
|---|---|---|---|---|---|---|---|---|
| AP-01 | Fictional supplier 01 | €3,222 | €2,400 | €822 | Approved | Complete | No | 2026-09-04 |
| AP-02 | Fictional supplier 02 | €569 | €0 | €569 | Pending | Complete | Yes | Awaiting prerequisites |
| AP-03 | Fictional supplier 03 | €2,148 | €1,200 | €948 | Approved | Complete | No | 2026-09-11 |
| AP-04 | Fictional supplier 04 | €632 | €0 | €632 | Approved | Pending | No | Awaiting prerequisites |
| AP-05 | Fictional supplier 05 | €4,212 | €3,200 | €1,012 | Approved | Complete | No | 2026-09-18 |
| AP-06 | Fictional supplier 06 | €759 | €0 | €759 | Approved | Complete | No | 2026-09-22 |
| AP-07 | Fictional supplier 07 | €695 | €0 | €695 | Approved | Complete | No | 2026-09-25 |
| AP-08 | Fictional supplier 08 | €2,685 | €1,800 | €885 | Approved | Complete | No | 2026-10-02 |
| Item | Amount |
|---|---|
| Original invoice totals | €14,923 |
| Paid to date | €8,600 |
| Outstanding payables | €6,323 |
| Pending, held or not reviewed | €1,201 |
| Eligible for scheduled payment | €5,121 |
| Engagement | Earned to date | Billed to date | Gross unbilled | Allowance | Net unbilled | Customer advances |
|---|---|---|---|---|---|---|
| PS-01 | €282,464 | €254,218 | €28,246 | €565 | €27,681 | €0 |
| PS-02 | €307,944 | €277,150 | €30,794 | €2,464 | €28,331 | €0 |
| PS-03 | €272,400 | €245,160 | €27,240 | €681 | €26,559 | €0 |
| PS-04 | €356,224 | €320,602 | €35,622 | €4,987 | €30,635 | €0 |
| PS-05 | €367,840 | €331,056 | €36,784 | €1,655 | €35,129 | €0 |
| PS-06 | €307,598 | €276,838 | €30,760 | €2,153 | €28,607 | €0 |
Dated cash forecast and funding exposure
Lowest scheduled daily cash is €150,240 on 2026-10-26. Lowest weekly closing cash is €154,659. Later-week receipts can conceal a cash need earlier in the week.
Opening cash is the completed 31 August close. The first week covers 1–6 September and the period ends 29 November. Dated cash reconciles to the monthly statements. No automatic funding is assumed.
Closing cashMinimum cash reserve €100,000
| Metric | 1–6 Sep | 07 Sept | 14 Sept | 21 Sept | 28 Sept | 05 Oct | 12 Oct | 19 Oct | 26 Oct | 02 Nov | 09 Nov | 16 Nov | 23 Nov |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening cash | €171,657 | €207,490 | €237,562 | €315,968 | €215,012 | €255,863 | €228,863 | €309,684 | €154,659 | €302,987 | €296,987 | €372,726 | €372,726 |
| Customer receipts | €36,654 | €70,254 | €79,418 | €73,309 | €45,818 | €0 | €84,437 | €0 | €156,812 | €0 | €100,144 | €0 | €185,981 |
| Supplier payments | −€822 | −€1,182 | −€1,012 | −€1,740 | −€885 | €0 | −€3,616 | €0 | −€4,419 | €0 | −€3,404 | €0 | −€4,161 |
| Payroll | €0 | €0 | €0 | −€154,525 | €0 | €0 | €0 | −€155,025 | €0 | €0 | €0 | €0 | −€156,025 |
| Operating overheads | €0 | −€21,000 | €0 | €0 | €0 | −€21,000 | €0 | €0 | €0 | €0 | −€21,000 | €0 | €0 |
| Current tax | €0 | €0 | €0 | −€18,000 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Interest | €0 | €0 | €0 | €0 | −€582 | €0 | €0 | €0 | −€566 | €0 | €0 | €0 | −€550 |
| Capital expenditure | €0 | −€18,000 | €0 | €0 | €0 | −€6,000 | €0 | €0 | €0 | −€6,000 | €0 | €0 | €0 |
| Debt repayment | €0 | €0 | €0 | €0 | −€3,500 | €0 | €0 | €0 | −€3,500 | €0 | €0 | €0 | −€3,500 |
| Net cash change | €35,833 | €30,072 | €78,406 | −€100,956 | €40,851 | −€27,000 | €80,822 | −€155,025 | €148,327 | −€6,000 | €75,739 | €0 | €21,745 |
| Closing cash | €207,490 | €237,562 | €315,968 | €215,012 | €255,863 | €228,863 | €309,684 | €154,659 | €302,987 | €296,987 | €372,726 | €372,726 | €394,471 |
| Minimum reserve | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 |
| Reserve headroom / (shortfall) | €107,490 | €137,562 | €215,968 | €115,012 | €155,863 | €128,863 | €209,684 | €54,659 | €202,987 | €196,987 | €272,726 | €272,726 | €294,471 |
| Date | Opening cash | Receipts | Payments | Net change | Closing cash | Reserve headroom |
|---|---|---|---|---|---|---|
| 2026-09-04 | €171,657 | €36,654 | −€822 | €35,833 | €207,490 | €107,490 |
| 2026-09-08 | €207,490 | €42,764 | −€18,000 | €24,764 | €232,253 | €132,253 |
| 2026-09-10 | €232,253 | €0 | −€21,000 | −€21,000 | €211,253 | €111,253 |
| 2026-09-11 | €211,253 | €27,491 | −€948 | €26,542 | €237,796 | €137,796 |
| 2026-09-12 | €237,796 | €0 | −€234 | −€234 | €237,562 | €137,562 |
| 2026-09-15 | €237,562 | €48,873 | €0 | €48,873 | €286,434 | €186,434 |
| 2026-09-18 | €286,434 | €30,545 | −€1,012 | €29,534 | €315,968 | €215,968 |
| 2026-09-21 | €315,968 | €0 | −€18,000 | −€18,000 | €297,968 | €197,968 |
| 2026-09-22 | €297,968 | €39,709 | −€759 | €38,950 | €336,918 | €236,918 |
| 2026-09-25 | €336,918 | €33,600 | −€155,220 | −€121,621 | €215,298 | €115,298 |
| 2026-09-26 | €215,298 | €0 | −€286 | −€286 | €215,012 | €115,012 |
| 2026-09-28 | €215,012 | €0.000000 | −€4,082 | −€4,082 | €210,930 | €110,930 |
| 2026-10-02 | €210,930 | €45,818 | −€885 | €44,933 | €255,863 | €155,863 |
| 2026-10-08 | €255,863 | €0 | −€6,000 | −€6,000 | €249,863 | €149,863 |
| 2026-10-10 | €249,863 | €0 | −€21,000 | −€21,000 | €228,863 | €128,863 |
| 2026-10-12 | €228,863 | €0 | −€3,616 | −€3,616 | €225,247 | €125,247 |
| 2026-10-15 | €225,247 | €84,437 | €0 | €84,437 | €309,684 | €209,684 |
| 2026-10-25 | €309,684 | €0 | −€155,025 | −€155,025 | €154,659 | €54,659 |
| 2026-10-26 | €154,659 | €0 | −€4,419 | −€4,419 | €150,240 | €50,240 |
| 2026-10-28 | €150,240 | €156,812 | −€4,066 | €152,746 | €302,987 | €202,987 |
| 2026-11-08 | €302,987 | €0 | −€6,000 | −€6,000 | €296,987 | €196,987 |
| 2026-11-10 | €296,987 | €0 | −€21,000 | −€21,000 | €275,987 | €175,987 |
| 2026-11-12 | €275,987 | €0 | −€3,404 | −€3,404 | €272,582 | €172,582 |
| 2026-11-15 | €272,582 | €100,144 | €0 | €100,144 | €372,726 | €272,726 |
| 2026-11-25 | €372,726 | €0 | −€156,025 | −€156,025 | €216,701 | €116,701 |
| 2026-11-26 | €216,701 | €0 | −€4,161 | −€4,161 | €212,540 | €112,540 |
| 2026-11-28 | €212,540 | €185,981 | −€4,050 | €181,931 | €394,471 | €294,471 |
Reserve: €100,000. Funding to avoid negative cash: €0. Funding to restore the reserve at the trough: €0.
Reconciliations and accounting assumptions
Financial totals connect to operating schedules. Reconciliation differences are evaluated in each case and shown at cent precision in the workbook.
Indirect taxes, FX and jurisdiction-specific tax rules are excluded explicitly. The illustrative tax calculation is not a local filing calculation.
| Check | Difference | Tolerance | Result |
|---|---|---|---|
| Balance sheet equation | €0.000000 | €0.01 | Pass |
| Direct cash versus indirect cash flow | €0.000000 | €0.01 | Pass |
| Monthly cash schedule reconciliation | €0.000000 | €0.01 | Pass |
| August AR detail reconciliation | €0 | €0.01 | Pass |
| August AP detail reconciliation | €0 | €0.01 | Pass |
| Daily versus weekly final cash | €0.000000 | €0.01 | Pass |
| Cost / asset consistency | €0 | €0.01 | Pass |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fixed assets at cost | €136,000 | €140,000 | €148,000 | €154,000 | €163,000 | €168,000 | €176,000 | €182,000 | €200,000 | €206,000 | €212,000 | €218,000 |
| Accumulated depreciation | €41,193 | €43,470 | €45,913 | €48,481 | €51,237 | €54,097 | €57,123 | €60,275 | €63,801 | €67,453 | €71,229 | €75,131 |
| Net fixed assets | €94,807 | €96,530 | €102,087 | €105,519 | €111,763 | €113,903 | €118,877 | €121,725 | €136,199 | €138,547 | €140,771 | €142,869 |
| Debt principal | €151,500 | €148,000 | €144,500 | €141,000 | €137,500 | €134,000 | €130,500 | €127,000 | €123,500 | €120,000 | €116,500 | €113,000 |
| Interest expense | −€710 | −€694 | −€678 | −€662 | −€646 | −€630 | −€614 | −€598 | −€582 | −€566 | −€550 | −€534 |
| Current tax payable | €17,492 | €23,679 | €23,311 | €33,751 | €46,390 | €50,201 | €66,948 | €86,091 | €86,581 | €104,995 | €123,481 | €125,104 |
| Current tax prepayment | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Area | Convention |
|---|---|
| Assumption 1 | January–August 2026 are invented actuals. September–December use one Base/Downside selector. Original budget is a separate fixed plan. |
| Assumption 2 | Amounts are EUR. Expenses and cash outflows are negative. Assets and liabilities are positive; accumulated depreciation is subtracted. |
| Assumption 3 | Revenue is chargeable hours × contract rate × realisation. Invoice timing is separate. The gap between cumulative earned revenue and billings is unbilled work or a customer advance. Recoverability reserves reduce unbilled work and are expensed. |
| Assumption 4 | Loaded payroll is paid FTE × monthly pay. Grade mix attributes cost to engagements. Unallocated payroll stays in direct cost. Hours above grade capacity require overtime or reallocation; no automatic overtime premium or added staffing is assumed. |
| Assumption 5 | Realisation discounts reduce revenue. The separate recoverability allowance applies only to remaining unbilled assets, not invoiced receivables. |
| Assumption 6 | Forecast receivables use target days, subject to a floor for unpaid opening invoices and a cap preventing negative new receipts. Implied days may differ from the target. AP includes new vendor expense × days plus unpaid opening invoices. |
| Assumption 7 | Opening supplier invoices require approval, completed review and no hold before payment. Pending invoices remain liabilities but are not scheduled. |
| Assumption 8 | Ledger and cash both exclude VAT and other indirect taxes. Tax is a fictional 20% of positive monthly profit before tax, without loss carry-forward or deferred tax. This is not jurisdiction-specific tax advice. |
| Assumption 9 | Opening assets depreciate over a remaining 44 months. New additions depreciate over 48 months from the full purchase month. Principal is capped at debt outstanding. Annual interest is 5.5% on opening monthly debt. |
| Assumption 10 | The 13-week period starts 1 September after the 31 August close and ends 29 November. Daily cash groups receipts and payments by date, not intraday execution order. Full monthly statements include all month-end activity. |
| Assumption 11 | Residual new collections occur 35% on day 15 and 65% on day 28. Vendor payments split 45% on day 12 and 55% on day 26. Payroll is day 25 and overheads day 10. Dates are fictional schedule assumptions. |
| Assumption 12 | Negative forecast cash is an unfunded requirement, not an authorised overdraft. No automatic borrowing, interest on cash, FX or dividends are modelled. |
| Assumption 13 | Blue numbers in amber cells are editable. Missing selected forecast drivers produce unavailable results; zero remains valid. JSON is an evaluated case snapshot and needs regeneration after edits. |
CFO review and accountable actions
The review connects demand, staffing, realised fees, invoice timing and collections. The grade-level capacity view exposes senior staffing constraints that aggregate utilisation misses.
Each action has a financial basis, owner and date. The operating reserve is €100,000.
| Priority | Financial finding | Action | Owner | Target date | Status |
|---|---|---|---|---|---|
| High | €176,942 net unbilled work | Agree invoice milestones and clear billing holds. | Engagement partners | 4 September 2026 | In progress |
| High | €150,240 lowest scheduled cash | Confirm receipts before discretionary spending. | CFO | 3 September 2026 | Open |
| High | €12,505 unbilled allowance | Document recovery expectations by engagement. | Finance lead | 7 September 2026 | Open |
| High | Partner utilisation 123.6%; Manager 119.8% | Rebalance senior-grade hours and agree capacity before accepting more work. | Resource manager | 8 September 2026 | Open |
| High | €155,782 overdue invoices | Obtain written payment dates and escalate disputed balances. | Collections lead | 3 September 2026 | In progress |
Engagement economics and cash
August revenue is €276,874, with 92.5% chargeable utilisation. Net unbilled work of €176,942 needs separate attention from invoiced receivables.
Downside scheduled cash reaches €-21,509 on 2026-11-26. The reserve is €100,000. The unfunded requirement is €21,509 before providing the reserve.
August revenue€276,874Invented actuals
August EBITDA€99,465After payroll and operating overheads
Net unbilled work€176,942At 31 August
Lowest daily cash−€21,5092026-11-26
| Metric | Actual | Original budget | Variance |
|---|---|---|---|
| Revenue | €276,874 | €284,889 | −€8,016 |
| Gross profit | €166,965 | €174,232 | −€7,266 |
| EBITDA | €99,465 | €109,157 | −€9,691 |
| Net profit | €76,573 | €84,326 | −€7,753 |
| Engagement | Service | Hours | Rate/hour | Realisation | Revenue | Allocated payroll | Contribution | Net unbilled |
|---|---|---|---|---|---|---|---|---|
| PS-01 | Strategy retainer | 280 | €140 | 97.0% | €38,024 | €13,694 | €24,330 | €27,681 |
| PS-02 | Finance transformation | 460 | €130 | 94.0% | €56,212 | €19,766 | €36,446 | €28,331 |
| PS-03 | Regulatory advisory | 310 | €125 | 96.0% | €37,200 | €13,853 | €23,347 | €26,559 |
| PS-04 | Transaction support | 380 | €160 | 92.0% | €55,936 | €19,238 | €36,698 | €30,635 |
| PS-05 | Analytics programme | 460 | €110 | 95.0% | €48,070 | €18,141 | €29,929 | €35,129 |
| PS-06 | Technology advisory | 330 | €135 | 93.0% | €41,432 | €14,180 | €27,252 | €28,607 |
All businesses, records and figures are fictional. The example demonstrates reporting method, not client results.
Performance against the original plan
Year-to-date revenue is €1,894,470 versus €1,947,469 budget. The full-year downside outlook is €2,781,459 revenue and €642,953 EBITDA.
Revenue variance reflects hours, rates and realised value. Unbilled recoverability is a separate expense, while all paid staff remain in direct payroll regardless of utilisation.
| Metric | YTD actual | YTD budget | YTD variance | Full-year outlook | Full-year budget | FY variance |
|---|---|---|---|---|---|---|
| Revenue | €1,894,470 | €1,947,469 | −€53,000 | €2,781,459 | €3,091,244 | −€309,786 |
| Gross profit | €1,017,964 | €1,066,122 | −€48,157 | €1,451,453 | €1,769,757 | −€318,304 |
| EBITDA | €491,964 | €558,822 | −€66,857 | €642,953 | €980,382 | −€337,429 |
| Net profit | €372,365 | €425,850 | −€53,486 | €479,685 | €749,428 | −€269,743 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | €193,550 | €207,712 | €220,716 | €230,429 | €242,210 | €258,795 | €264,183 | €276,874 | €223,040 | €223,007 | €223,999 | €216,944 |
| Direct payroll | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€101,000 | −€103,525 | −€103,525 | −€103,525 | −€103,525 |
| Materials | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Subcontractors | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Direct systems and software | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,000 | −€7,800 | −€7,800 | −€7,800 | −€7,800 |
| Unbilled recoverability charge / (release) | −€1,187 | −€1,307 | −€1,436 | −€1,495 | −€1,615 | −€1,748 | −€1,809 | −€1,908 | −€21,866 | €923 | €975 | €11,768 |
| Direct costs | −€109,187 | −€109,307 | −€109,436 | −€109,495 | −€109,615 | −€109,748 | −€109,809 | −€109,908 | −€133,191 | −€110,402 | −€110,350 | −€99,557 |
| Gross profit | €84,363 | €98,406 | €111,280 | €120,934 | €132,596 | €149,047 | €154,374 | €166,965 | €89,848 | €112,605 | €113,649 | €117,387 |
| Gross margin | 43.6% | 47.4% | 50.4% | 52.5% | 54.7% | 57.6% | 58.4% | 60.3% | 40.3% | 50.5% | 50.7% | 54.1% |
| Management and administration payroll | −€45,000 | −€45,500 | −€46,000 | −€46,500 | −€47,000 | −€47,500 | −€48,000 | −€48,500 | −€51,000 | −€51,500 | −€52,000 | −€52,000 |
| Business development | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,500 | −€11,000 | −€11,000 | −€11,000 | −€11,000 |
| Office, insurance and general costs | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€7,500 | −€8,000 | −€8,000 | −€8,000 | −€8,000 |
| Operating expenses | −€64,000 | −€64,500 | −€65,000 | −€65,500 | −€66,000 | −€66,500 | −€67,000 | −€67,500 | −€70,000 | −€70,500 | −€71,000 | −€71,000 |
| EBITDA | €20,363 | €33,906 | €46,280 | €55,434 | €66,596 | €82,547 | €87,374 | €99,465 | €19,848 | €42,105 | €42,649 | €46,387 |
| EBITDA margin | 10.5% | 16.3% | 21.0% | 24.1% | 27.5% | 31.9% | 33.1% | 35.9% | 8.9% | 18.9% | 19.0% | 21.4% |
| Depreciation | −€2,193 | −€2,277 | −€2,443 | −€2,568 | −€2,756 | −€2,860 | −€3,027 | −€3,152 | −€3,527 | −€3,610 | −€3,693 | −€3,777 |
| EBIT | €18,170 | €31,629 | €43,837 | €52,865 | €63,840 | €79,687 | €84,348 | €96,314 | €16,322 | €38,495 | €38,956 | €42,610 |
| Interest | −€710 | −€694 | −€678 | −€662 | −€646 | −€630 | −€614 | −€598 | −€582 | −€566 | −€550 | −€534 |
| Profit before tax | €17,460 | €30,935 | €43,158 | €52,203 | €63,194 | €79,057 | €83,734 | €95,716 | €15,740 | €37,929 | €38,406 | €42,076 |
| Illustrative current tax | −€3,492 | −€6,187 | −€8,632 | −€10,441 | −€12,639 | −€15,811 | −€16,747 | −€19,143 | −€3,148 | −€7,586 | −€7,681 | −€8,415 |
| Net profit | €13,968 | €24,748 | €34,527 | €41,762 | €50,555 | €63,246 | €66,987 | €76,573 | €12,592 | €30,343 | €30,724 | €33,661 |
Linked financial statements
Earned revenue, billings and cash are distinct. Gross unbilled work less its recoverability allowance flows to the balance sheet. Its net change forms part of the indirect cash-flow reconciliation.
December closing cash is €84,852. No new borrowing is assumed.
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash / (unfunded cash requirement) | €86,112 | €13,525 | €27,521 | €32,266 | €58,374 | €68,057 | €122,069 | €171,657 | €109,075 | €96,532 | €100,818 | €84,852 |
| Trade receivables | €174,195 | €253,706 | €243,500 | €262,689 | €267,213 | €295,026 | €291,454 | €305,454 | €374,070 | €420,184 | €451,515 | €554,249 |
| Contract asset / net unbilled work | €18,168 | €37,633 | €58,268 | €79,815 | €102,421 | €126,553 | €151,163 | €176,942 | €153,717 | €153,067 | €152,283 | €101,821 |
| Retention receivables | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Prepayments | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 | €14,000 |
| Current tax prepayment | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Current assets | €292,475 | €318,864 | €343,288 | €388,770 | €442,009 | €503,636 | €578,686 | €668,053 | €650,863 | €683,782 | €718,615 | €754,922 |
| Fixed assets at cost | €136,000 | €140,000 | €148,000 | €154,000 | €163,000 | €168,000 | €176,000 | €182,000 | €200,000 | €204,000 | €208,000 | €212,000 |
| Accumulated depreciation | €41,193 | €43,470 | €45,913 | €48,481 | €51,237 | €54,097 | €57,123 | €60,275 | €63,801 | €67,411 | €71,104 | €74,881 |
| Net fixed assets | €94,807 | €96,530 | €102,087 | €105,519 | €111,763 | €113,903 | €118,877 | €121,725 | €136,199 | €136,589 | €136,896 | €137,119 |
| Total assets | €387,282 | €415,394 | €445,375 | €494,289 | €553,772 | €617,540 | €697,563 | €789,778 | €787,062 | €820,371 | €855,511 | €892,041 |
| Trade payables | €6,323 | €7,000 | €6,323 | €6,533 | €6,323 | €6,533 | €6,323 | €6,323 | €9,366 | €8,246 | €8,481 | €8,246 |
| Payroll accruals | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 | €15,000 |
| Contract liabilities / customer advances | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €7,189 |
| Current tax payable | €17,492 | €23,679 | €23,311 | €33,751 | €46,390 | €50,201 | €66,948 | €86,091 | €71,239 | €78,825 | €86,506 | €85,921 |
| Current operating liabilities | €38,815 | €45,679 | €44,633 | €55,284 | €67,712 | €71,735 | €88,271 | €107,414 | €95,605 | €102,071 | €109,987 | €116,356 |
| Debt | €151,500 | €148,000 | €144,500 | €141,000 | €137,500 | €134,000 | €130,500 | €127,000 | €123,500 | €120,000 | €116,500 | €113,000 |
| Total liabilities | €190,315 | €193,679 | €189,133 | €196,284 | €205,212 | €205,735 | €218,771 | €234,414 | €219,105 | €222,071 | €226,487 | €229,356 |
| Share capital | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 |
| Retained earnings | €146,968 | €171,715 | €206,242 | €248,005 | €298,559 | €361,805 | €428,792 | €505,365 | €517,956 | €548,299 | €579,024 | €612,685 |
| Equity | €196,968 | €221,715 | €256,242 | €298,005 | €348,559 | €411,805 | €478,792 | €555,365 | €567,956 | €598,299 | €629,024 | €662,685 |
| Liabilities and equity | €387,282 | €415,394 | €445,375 | €494,289 | €553,772 | €617,540 | €697,563 | €789,778 | €787,062 | €820,371 | €855,511 | €892,041 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Net profit | €13,968 | €24,748 | €34,527 | €41,762 | €50,555 | €63,246 | €66,987 | €76,573 | €12,592 | €30,343 | €30,724 | €33,661 |
| Depreciation add-back | €2,193 | €2,277 | €2,443 | €2,568 | €2,756 | €2,860 | €3,027 | €3,152 | €3,527 | €3,610 | €3,693 | €3,777 |
| Change in trade receivables | −€174,195 | −€79,511 | €10,206 | −€19,189 | −€4,524 | −€27,813 | €3,573 | −€14,000 | −€68,616 | −€46,113 | −€31,331 | −€102,734 |
| Change in contract assets / net unbilled work | −€18,168 | −€19,464 | −€20,635 | −€21,547 | −€22,606 | −€24,132 | −€24,610 | −€25,779 | €23,224 | €651 | €784 | €50,462 |
| Change in retentions | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Change in trade payables | −€16,677 | €677 | −€677 | €211 | −€211 | €211 | −€211 | −€0.000645 | €3,044 | −€1,120 | €235 | −€235 |
| Change in customer advances | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €7,189 |
| Change in net current tax | €3,492 | €6,187 | −€368 | €10,441 | €12,639 | €3,811 | €16,747 | €19,143 | −€14,852 | €7,586 | €7,681 | −€585 |
| Operating cash flow | −€189,388 | −€65,087 | €25,495 | €14,245 | €38,609 | €18,183 | €65,513 | €59,088 | −€41,082 | −€5,044 | €11,786 | −€8,466 |
| Capital expenditure | −€6,000 | −€4,000 | −€8,000 | −€6,000 | −€9,000 | −€5,000 | −€8,000 | −€6,000 | −€18,000 | −€4,000 | −€4,000 | −€4,000 |
| Investing cash flow | −€6,000 | −€4,000 | −€8,000 | −€6,000 | −€9,000 | −€5,000 | −€8,000 | −€6,000 | −€18,000 | −€4,000 | −€4,000 | −€4,000 |
| Debt principal repayment | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 |
| Financing cash flow | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 | −€3,500 |
| Net cash change | −€198,888 | −€72,587 | €13,995 | €4,745 | €26,109 | €9,683 | €54,013 | €49,588 | −€62,582 | −€12,544 | €4,286 | −€15,966 |
| Opening cash | €285,000 | €86,112 | €13,525 | €27,521 | €32,266 | €58,374 | €68,057 | €122,069 | €171,657 | €109,075 | €96,532 | €100,818 |
| Closing cash | €86,112 | €13,525 | €27,521 | €32,266 | €58,374 | €68,057 | €122,069 | €171,657 | €109,075 | €96,532 | €100,818 | €84,852 |
Rates, realisation and team capacity
August loaded payroll is €101,000. €98,871 is allocated through grade mix; €2,129 remains unallocated and stays in the P&L.
Aggregate utilisation hides a senior-grade constraint. August Partner demand is 197.7 hours against 160 available; Manager demand is 575.0 hours against 480. The delivery plan needs reallocation, added senior capacity or an agreed overtime response. No automatic overtime premium is assumed.
| Grade | Aug paid FTE | Aug loaded monthly pay | Aug hours available | Aug hours allocated | Aug utilisation | Dec hours available | Dec hours allocated | Dec utilisation |
|---|---|---|---|---|---|---|---|---|
| Partner | 1 | €12,000 | 160 | 197.7 | 123.6% | 160 | 161.73 | 101.1% |
| Manager | 3 | €8,500 | 480 | 575 | 119.8% | 480 | 475.92 | 99.2% |
| Consultant | 7 | €6,500 | 1,120 | 1,023.3 | 91.4% | 1,120 | 859.95 | 76.8% |
| Analyst | 4 | €4,500 | 640 | 424 | 66.2% | 640 | 360 | 56.2% |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Paid FTE | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 |
| Available hours | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 | 2,400 |
| Chargeable hours | 1,570 | 1,680 | 1,780 | 1,860 | 1,950 | 2,080 | 2,120 | 2,220 | 1,910.4 | 1,908.8 | 1,916 | 1,857.6 |
| Utilisation | 65.4% | 70.0% | 74.2% | 77.5% | 81.2% | 86.7% | 88.3% | 92.5% | 79.6% | 79.5% | 79.8% | 77.4% |
| Total loaded payroll | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €101,000 | €103,525 | €103,525 | €103,525 | €103,525 |
| Payroll attributed to engagements | €69,534 | €74,532 | €79,058 | €82,537 | €86,634 | €92,508 | €94,380 | €98,871 | €86,823 | €86,825 | €87,220 | €84,535 |
| Unallocated payroll | €31,466 | €26,468 | €21,942 | €18,463 | €14,366 | €8,492 | €6,620 | €2,129 | €16,702 | €16,700 | €16,305 | €18,990 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 240 | 250 | 250 | 260 | 260 | 270 | 270 | 280 | 255.2 | 255.2 | 264 | 264 |
| Contract rate | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 | €140 |
| Realisation | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 97.0% | 91.5% | 91.5% | 91.5% | 91.5% |
| Revenue | €32,592 | €33,950 | €33,950 | €35,308 | €35,308 | €36,666 | €36,666 | €38,024 | €32,691 | €32,691 | €33,818 | €33,818 |
| Invoices issued | €29,333 | €30,555 | €30,555 | €31,777 | €31,777 | €32,999 | €32,999 | €34,222 | €31,640 | €31,640 | €32,731 | €42,899 |
| Net unbilled work | €3,194 | €6,521 | €9,848 | €13,308 | €16,769 | €20,362 | €23,955 | €27,681 | €25,196 | €26,101 | €27,036 | €19,227 |
| Engagement contribution | €20,854 | €21,723 | €21,723 | €22,592 | €22,592 | €23,461 | €23,461 | €24,330 | €19,898 | €19,898 | €20,584 | €20,584 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 150 | 190 | 250 | 300 | 350 | 400 | 420 | 460 | 396 | 378.4 | 352 | 308 |
| Contract rate | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 | €130 |
| Realisation | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 94.0% | 88.5% | 88.5% | 88.5% | 88.5% |
| Revenue | €18,330 | €23,218 | €30,550 | €36,660 | €42,770 | €48,880 | €51,324 | €56,212 | €45,560 | €43,535 | €40,498 | €35,435 |
| Invoices issued | €16,497 | €20,896 | €27,495 | €32,994 | €38,493 | €43,992 | €46,192 | €50,591 | €44,179 | €42,215 | €39,270 | €45,037 |
| Net unbilled work | €1,686 | €3,822 | €6,633 | €10,006 | €13,941 | €18,438 | €23,159 | €28,331 | €25,740 | €26,796 | €27,778 | €20,097 |
| Engagement contribution | €11,885 | €15,054 | €19,808 | €23,769 | €27,731 | €31,692 | €33,277 | €36,446 | €28,119 | €26,869 | €24,994 | €21,870 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 260 | 270 | 270 | 280 | 280 | 300 | 300 | 310 | 272.8 | 281.6 | 281.6 | 281.6 |
| Contract rate | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 | €125 |
| Realisation | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 96.0% | 90.5% | 90.5% | 90.5% | 90.5% |
| Revenue | €31,200 | €32,400 | €32,400 | €33,600 | €33,600 | €36,000 | €36,000 | €37,200 | €30,860 | €31,856 | €31,856 | €31,856 |
| Invoices issued | €28,080 | €29,160 | €29,160 | €30,240 | €30,240 | €32,400 | €32,400 | €33,480 | €29,886 | €30,851 | €30,851 | €40,435 |
| Net unbilled work | €3,042 | €6,201 | €9,360 | €12,636 | €15,912 | €19,422 | €22,932 | €26,559 | €24,123 | €24,983 | €25,842 | €18,507 |
| Engagement contribution | €19,581 | €20,334 | €20,334 | €21,088 | €21,088 | €22,594 | €22,594 | €23,347 | €18,365 | €18,957 | €18,957 | €18,957 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 220 | 250 | 280 | 280 | 310 | 340 | 360 | 380 | 273.6 | 280.8 | 288 | 273.6 |
| Contract rate | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 | €160 |
| Realisation | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 92.0% | 86.5% | 86.5% | 86.5% | 86.5% |
| Revenue | €32,384 | €36,800 | €41,216 | €41,216 | €45,632 | €50,048 | €52,992 | €55,936 | €37,866 | €38,863 | €39,859 | €37,866 |
| Invoices issued | €29,146 | €33,120 | €37,094 | €37,094 | €41,069 | €45,043 | €47,693 | €50,342 | €44,939 | €46,122 | €47,304 | €58,901 |
| Net unbilled work | €2,785 | €5,950 | €9,494 | €13,039 | €16,963 | €21,267 | €25,825 | €30,635 | €21,127 | €15,755 | €10,246 | €0 |
| Engagement contribution | €21,246 | €24,144 | €27,041 | €27,041 | €29,938 | €32,836 | €34,767 | €36,698 | €23,669 | €24,292 | €24,915 | €23,669 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 420 | 430 | 430 | 440 | 440 | 450 | 450 | 460 | 413.6 | 413.6 | 422.4 | 422.4 |
| Contract rate | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 | €110 |
| Realisation | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 95.0% | 89.5% | 89.5% | 89.5% | 89.5% |
| Revenue | €43,890 | €44,935 | €44,935 | €45,980 | €45,980 | €47,025 | €47,025 | €48,070 | €40,719 | €40,719 | €41,585 | €41,585 |
| Invoices issued | €39,501 | €40,442 | €40,442 | €41,382 | €41,382 | €42,322 | €42,322 | €43,263 | €39,459 | €39,459 | €40,299 | €52,818 |
| Net unbilled work | €4,191 | €8,483 | €12,774 | €17,165 | €21,556 | €26,047 | €30,538 | €35,129 | €31,767 | €32,819 | €33,893 | €24,513 |
| Engagement contribution | €27,326 | €27,977 | €27,977 | €28,628 | €28,628 | €29,278 | €29,278 | €29,929 | €24,000 | €24,000 | €24,510 | €24,510 |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chargeable hours | 280 | 290 | 300 | 300 | 310 | 320 | 320 | 330 | 299.2 | 299.2 | 308 | 308 |
| Contract rate | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 | €135 |
| Realisation | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 93.0% | 87.5% | 87.5% | 87.5% | 87.5% |
| Revenue | €35,154 | €36,410 | €37,665 | €37,665 | €38,920 | €40,176 | €40,176 | €41,432 | €35,343 | €35,343 | €36,382 | €36,382 |
| Invoices issued | €31,639 | €32,769 | €33,898 | €33,898 | €35,028 | €36,158 | €36,158 | €37,288 | €34,295 | €34,295 | €35,303 | €46,271 |
| Net unbilled work | €3,269 | €6,655 | €10,158 | €13,661 | €17,281 | €21,017 | €24,753 | €28,607 | €25,764 | €26,614 | €27,488 | €19,478 |
| Engagement contribution | €23,123 | €23,949 | €24,774 | €24,774 | €25,600 | €26,426 | €26,426 | €27,252 | €22,165 | €22,165 | €22,817 | €22,817 |
Receivables, payables and cash conversion
€155,782 of August trade receivables is overdue. €1,201 of supplier invoices remains pending approval, review or hold release. The liabilities remain on the balance sheet even when excluded from scheduled payments.
Unbilled work is separate from invoice ageing. Billing entitlement, client acceptance and recoverability are reviewed by engagement before a balance becomes an invoice.
| Age bucket | Outstanding |
|---|---|
| Current | €149,672 |
| 1–30 | €76,364 |
| 31–60 | €42,764 |
| 61–90 | €36,654 |
| 90+ | €0 |
| Invoice | Customer | Issued | Due | Outstanding | Planned receipt | Case receipt | Days overdue |
|---|---|---|---|---|---|---|---|
| AR-01 | Fictional customer 01 | 2026-05-20 | 2026-06-19 | €36,654 | 2026-09-04 | 2026-09-18 | 73 |
| AR-02 | Fictional customer 02 | 2026-06-18 | 2026-07-18 | €42,764 | 2026-09-08 | 2026-09-22 | 44 |
| AR-03 | Fictional customer 03 | 2026-07-06 | 2026-08-05 | €27,491 | 2026-09-11 | 2026-09-25 | 26 |
| AR-04 | Fictional customer 04 | 2026-07-20 | 2026-08-19 | €48,873 | 2026-09-15 | 2026-09-29 | 12 |
| AR-05 | Fictional customer 05 | 2026-08-02 | 2026-09-01 | €30,545 | 2026-09-18 | 2026-10-02 | 0 |
| AR-06 | Fictional customer 06 | 2026-08-10 | 2026-09-09 | €39,709 | 2026-09-22 | 2026-10-06 | 0 |
| AR-07 | Fictional customer 07 | 2026-08-18 | 2026-09-17 | €33,600 | 2026-09-25 | 2026-10-09 | 0 |
| AR-08 | Fictional customer 08 | 2026-08-25 | 2026-09-24 | €45,818 | 2026-10-02 | 2026-10-16 | 0 |
| Invoice | Supplier | Original invoice | Paid to date | Outstanding | Approval | Review | Hold | Payment date |
|---|---|---|---|---|---|---|---|---|
| AP-01 | Fictional supplier 01 | €3,222 | €2,400 | €822 | Approved | Complete | No | 2026-09-04 |
| AP-02 | Fictional supplier 02 | €569 | €0 | €569 | Pending | Complete | Yes | Awaiting prerequisites |
| AP-03 | Fictional supplier 03 | €2,148 | €1,200 | €948 | Approved | Complete | No | 2026-09-11 |
| AP-04 | Fictional supplier 04 | €632 | €0 | €632 | Approved | Pending | No | Awaiting prerequisites |
| AP-05 | Fictional supplier 05 | €4,212 | €3,200 | €1,012 | Approved | Complete | No | 2026-09-18 |
| AP-06 | Fictional supplier 06 | €759 | €0 | €759 | Approved | Complete | No | 2026-09-22 |
| AP-07 | Fictional supplier 07 | €695 | €0 | €695 | Approved | Complete | No | 2026-09-25 |
| AP-08 | Fictional supplier 08 | €2,685 | €1,800 | €885 | Approved | Complete | No | 2026-10-02 |
| Item | Amount |
|---|---|
| Original invoice totals | €14,923 |
| Paid to date | €8,600 |
| Outstanding payables | €6,323 |
| Pending, held or not reviewed | €1,201 |
| Eligible for scheduled payment | €5,121 |
| Engagement | Earned to date | Billed to date | Gross unbilled | Allowance | Net unbilled | Customer advances |
|---|---|---|---|---|---|---|
| PS-01 | €282,464 | €254,218 | €28,246 | €565 | €27,681 | €0 |
| PS-02 | €307,944 | €277,150 | €30,794 | €2,464 | €28,331 | €0 |
| PS-03 | €272,400 | €245,160 | €27,240 | €681 | €26,559 | €0 |
| PS-04 | €356,224 | €320,602 | €35,622 | €4,987 | €30,635 | €0 |
| PS-05 | €367,840 | €331,056 | €36,784 | €1,655 | €35,129 | €0 |
| PS-06 | €307,598 | €276,838 | €30,760 | €2,153 | €28,607 | €0 |
Dated cash forecast and funding exposure
Lowest scheduled daily cash is €-21,509 on 2026-11-26. Lowest weekly closing cash is €64,285. Later-week receipts can conceal a cash need earlier in the week.
Opening cash is the completed 31 August close. The first week covers 1–6 September and the period ends 29 November. Dated cash reconciles to the monthly statements. No automatic funding is assumed.
Closing cashMinimum cash reserve €100,000
| Metric | 1–6 Sep | 07 Sept | 14 Sept | 21 Sept | 28 Sept | 05 Oct | 12 Oct | 19 Oct | 26 Oct | 02 Nov | 09 Nov | 16 Nov | 23 Nov |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening cash | €171,657 | €170,835 | €132,653 | €168,296 | €64,285 | €138,736 | €189,045 | €241,325 | €86,300 | €96,532 | €92,532 | €138,177 | €138,177 |
| Customer receipts | €0 | €0 | €36,654 | €70,254 | €79,418 | €73,309 | €55,896 | €0 | €18,717 | €0 | €68,049 | €0 | €126,377 |
| Supplier payments | −€822 | −€1,182 | −€1,012 | −€1,740 | −€885 | €0 | −€3,616 | €0 | −€4,419 | €0 | −€3,404 | €0 | −€4,161 |
| Payroll | €0 | €0 | €0 | −€154,525 | €0 | €0 | €0 | −€155,025 | €0 | €0 | €0 | €0 | −€155,525 |
| Operating overheads | €0 | −€19,000 | €0 | €0 | €0 | −€19,000 | €0 | €0 | €0 | €0 | −€19,000 | €0 | €0 |
| Current tax | €0 | €0 | €0 | −€18,000 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Interest | €0 | €0 | €0 | €0 | −€582 | €0 | €0 | €0 | −€566 | €0 | €0 | €0 | −€550 |
| Capital expenditure | €0 | −€18,000 | €0 | €0 | €0 | −€4,000 | €0 | €0 | €0 | −€4,000 | €0 | €0 | €0 |
| Debt repayment | €0 | €0 | €0 | €0 | −€3,500 | €0 | €0 | €0 | −€3,500 | €0 | €0 | €0 | −€3,500 |
| Net cash change | −€822 | −€38,182 | €35,643 | −€104,011 | €74,451 | €50,309 | €52,281 | −€155,025 | €10,232 | −€4,000 | €45,645 | €0 | −€37,359 |
| Closing cash | €170,835 | €132,653 | €168,296 | €64,285 | €138,736 | €189,045 | €241,325 | €86,300 | €96,532 | €92,532 | €138,177 | €138,177 | €100,818 |
| Minimum reserve | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 | €100,000 |
| Reserve headroom / (shortfall) | €70,835 | €32,653 | €68,296 | −€35,715 | €38,736 | €89,045 | €141,325 | −€13,700 | −€3,468 | −€7,468 | €38,177 | €38,177 | €818 |
| Date | Opening cash | Receipts | Payments | Net change | Closing cash | Reserve headroom |
|---|---|---|---|---|---|---|
| 2026-09-04 | €171,657 | €0 | −€822 | −€822 | €170,835 | €70,835 |
| 2026-09-08 | €170,835 | €0 | −€18,000 | −€18,000 | €152,835 | €52,835 |
| 2026-09-10 | €152,835 | €0 | −€19,000 | −€19,000 | €133,835 | €33,835 |
| 2026-09-11 | €133,835 | €0 | −€948 | −€948 | €132,887 | €32,887 |
| 2026-09-12 | €132,887 | €0 | −€234 | −€234 | €132,653 | €32,653 |
| 2026-09-18 | €132,653 | €36,654 | −€1,012 | €35,643 | €168,296 | €68,296 |
| 2026-09-21 | €168,296 | €0 | −€18,000 | −€18,000 | €150,296 | €50,296 |
| 2026-09-22 | €150,296 | €42,764 | −€759 | €42,005 | €192,300 | €92,300 |
| 2026-09-25 | €192,300 | €27,491 | −€155,220 | −€127,730 | €64,571 | −€35,429 |
| 2026-09-26 | €64,571 | €0 | −€286 | −€286 | €64,285 | −€35,715 |
| 2026-09-28 | €64,285 | €0.000000 | −€4,082 | −€4,082 | €60,203 | −€39,797 |
| 2026-09-29 | €60,203 | €48,873 | €0 | €48,873 | €109,075 | €9,075 |
| 2026-10-02 | €109,075 | €30,545 | −€885 | €29,660 | €138,736 | €38,736 |
| 2026-10-06 | €138,736 | €39,709 | €0 | €39,709 | €178,445 | €78,445 |
| 2026-10-08 | €178,445 | €0 | −€4,000 | −€4,000 | €174,445 | €74,445 |
| 2026-10-09 | €174,445 | €33,600 | €0 | €33,600 | €208,045 | €108,045 |
| 2026-10-10 | €208,045 | €0 | −€19,000 | −€19,000 | €189,045 | €89,045 |
| 2026-10-12 | €189,045 | €0 | −€3,616 | −€3,616 | €185,429 | €85,429 |
| 2026-10-15 | €185,429 | €10,078 | €0 | €10,078 | €195,507 | €95,507 |
| 2026-10-16 | €195,507 | €45,818 | €0 | €45,818 | €241,325 | €141,325 |
| 2026-10-25 | €241,325 | €0 | −€155,025 | −€155,025 | €86,300 | −€13,700 |
| 2026-10-26 | €86,300 | €0 | −€4,419 | −€4,419 | €81,881 | −€18,119 |
| 2026-10-28 | €81,881 | €18,717 | −€4,066 | €14,651 | €96,532 | −€3,468 |
| 2026-11-08 | €96,532 | €0 | −€4,000 | −€4,000 | €92,532 | −€7,468 |
| 2026-11-10 | €92,532 | €0 | −€19,000 | −€19,000 | €73,532 | −€26,468 |
| 2026-11-12 | €73,532 | €0 | −€3,404 | −€3,404 | €70,127 | −€29,873 |
| 2026-11-15 | €70,127 | €68,049 | €0 | €68,049 | €138,177 | €38,177 |
| 2026-11-25 | €138,177 | €0 | −€155,525 | −€155,525 | −€17,348 | −€117,348 |
| 2026-11-26 | −€17,348 | €0 | −€4,161 | −€4,161 | −€21,509 | −€121,509 |
| 2026-11-28 | −€21,509 | €126,377 | −€4,050 | €122,327 | €100,818 | €818 |
Reserve: €100,000. Funding to avoid negative cash: €21,509. Funding to restore the reserve at the trough: €121,509.
Reconciliations and accounting assumptions
Financial totals connect to operating schedules. Reconciliation differences are evaluated in each case and shown at cent precision in the workbook.
Indirect taxes, FX and jurisdiction-specific tax rules are excluded explicitly. The illustrative tax calculation is not a local filing calculation.
| Check | Difference | Tolerance | Result |
|---|---|---|---|
| Balance sheet equation | €0.000000 | €0.01 | Pass |
| Direct cash versus indirect cash flow | €0.000000 | €0.01 | Pass |
| Monthly cash schedule reconciliation | €0.000000 | €0.01 | Pass |
| August AR detail reconciliation | €0 | €0.01 | Pass |
| August AP detail reconciliation | €0 | €0.01 | Pass |
| Daily versus weekly final cash | −€0.000000 | €0.01 | Pass |
| Cost / asset consistency | €0 | €0.01 | Pass |
| Metric | Jan 26 A | Feb 26 A | Mar 26 A | Apr 26 A | May 26 A | Jun 26 A | Jul 26 A | Aug 26 A | Sept 26 F | Oct 26 F | Nov 26 F | Dec 26 F |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fixed assets at cost | €136,000 | €140,000 | €148,000 | €154,000 | €163,000 | €168,000 | €176,000 | €182,000 | €200,000 | €204,000 | €208,000 | €212,000 |
| Accumulated depreciation | €41,193 | €43,470 | €45,913 | €48,481 | €51,237 | €54,097 | €57,123 | €60,275 | €63,801 | €67,411 | €71,104 | €74,881 |
| Net fixed assets | €94,807 | €96,530 | €102,087 | €105,519 | €111,763 | €113,903 | €118,877 | €121,725 | €136,199 | €136,589 | €136,896 | €137,119 |
| Debt principal | €151,500 | €148,000 | €144,500 | €141,000 | €137,500 | €134,000 | €130,500 | €127,000 | €123,500 | €120,000 | €116,500 | €113,000 |
| Interest expense | −€710 | −€694 | −€678 | −€662 | −€646 | −€630 | −€614 | −€598 | −€582 | −€566 | −€550 | −€534 |
| Current tax payable | €17,492 | €23,679 | €23,311 | €33,751 | €46,390 | €50,201 | €66,948 | €86,091 | €71,239 | €78,825 | €86,506 | €85,921 |
| Current tax prepayment | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 | €0 |
| Area | Convention |
|---|---|
| Assumption 1 | January–August 2026 are invented actuals. September–December use one Base/Downside selector. Original budget is a separate fixed plan. |
| Assumption 2 | Amounts are EUR. Expenses and cash outflows are negative. Assets and liabilities are positive; accumulated depreciation is subtracted. |
| Assumption 3 | Revenue is chargeable hours × contract rate × realisation. Invoice timing is separate. The gap between cumulative earned revenue and billings is unbilled work or a customer advance. Recoverability reserves reduce unbilled work and are expensed. |
| Assumption 4 | Loaded payroll is paid FTE × monthly pay. Grade mix attributes cost to engagements. Unallocated payroll stays in direct cost. Hours above grade capacity require overtime or reallocation; no automatic overtime premium or added staffing is assumed. |
| Assumption 5 | Realisation discounts reduce revenue. The separate recoverability allowance applies only to remaining unbilled assets, not invoiced receivables. |
| Assumption 6 | Forecast receivables use target days, subject to a floor for unpaid opening invoices and a cap preventing negative new receipts. Implied days may differ from the target. AP includes new vendor expense × days plus unpaid opening invoices. |
| Assumption 7 | Opening supplier invoices require approval, completed review and no hold before payment. Pending invoices remain liabilities but are not scheduled. |
| Assumption 8 | Ledger and cash both exclude VAT and other indirect taxes. Tax is a fictional 20% of positive monthly profit before tax, without loss carry-forward or deferred tax. This is not jurisdiction-specific tax advice. |
| Assumption 9 | Opening assets depreciate over a remaining 44 months. New additions depreciate over 48 months from the full purchase month. Principal is capped at debt outstanding. Annual interest is 5.5% on opening monthly debt. |
| Assumption 10 | The 13-week period starts 1 September after the 31 August close and ends 29 November. Daily cash groups receipts and payments by date, not intraday execution order. Full monthly statements include all month-end activity. |
| Assumption 11 | Residual new collections occur 35% on day 15 and 65% on day 28. Vendor payments split 45% on day 12 and 55% on day 26. Payroll is day 25 and overheads day 10. Dates are fictional schedule assumptions. |
| Assumption 12 | Negative forecast cash is an unfunded requirement, not an authorised overdraft. No automatic borrowing, interest on cash, FX or dividends are modelled. |
| Assumption 13 | Blue numbers in amber cells are editable. Missing selected forecast drivers produce unavailable results; zero remains valid. JSON is an evaluated case snapshot and needs regeneration after edits. |
CFO review and accountable actions
The review connects demand, staffing, realised fees, invoice timing and collections. The grade-level capacity view exposes senior staffing constraints that aggregate utilisation misses.
Each action has a financial basis, owner and date. The operating reserve is €100,000.
| Priority | Financial finding | Action | Owner | Target date | Status |
|---|---|---|---|---|---|
| High | €176,942 net unbilled work | Agree invoice milestones and clear billing holds. | Engagement partners | 4 September 2026 | In progress |
| High | €-21,509 lowest scheduled cash | Confirm receipts before discretionary spending. | CFO | 3 September 2026 | Open |
| High | €12,505 unbilled allowance | Document recovery expectations by engagement. | Finance lead | 7 September 2026 | Open |
| High | Partner utilisation 123.6%; Manager 119.8% | Rebalance senior-grade hours and agree capacity before accepting more work. | Resource manager | 8 September 2026 | Open |
| High | €155,782 overdue invoices | Obtain written payment dates and escalate disputed balances. | Collections lead | 3 September 2026 | In progress |
Inspect the formulas behind the review.
Download the linked statements, assumptions, operating schedules and controls. Change the model inputs to examine the forecast.
This example shows the depth available across our finance work. Your engagement defines the models, reports and strategic deliverables included; every advanced module is not automatically included in either starting fee. Compare engagement scope.
Start with a conversation
Build the finance function
your next stage needs.
Tell us where the business stands. We’ll show you how we would run the finance function, the priorities we would address and the team behind the work.
Book a free introductionExplore the engagement and pricing