EU Programmes

Horizon Europe Lump-Sum Budgets: The Detailed Budget Table, Worked Example

How a Type 2 lump sum is built, sheet by sheet, how evaluators check it, and how it is paid. Every rule is quoted from the Commission’s guidance, and every number in the example adds up to the euro.

Last reviewed September 2026 · rules from the EC lump-sum guide v3.0 and the 2026 online-table transition

About half of the 2026-27 Horizon Europe call budgets are now paid as lump sums. For a coordinator that changes when the hard budgeting work happens: instead of reporting actual costs for four years, the consortium estimates them once, in detail, before submission, and the resulting amounts are fixed per beneficiary and per work package in the grant agreement. This page explains the mechanics and then builds a complete budget for SALTMARSH, the fictional eight-partner, 42-month project whose work plan is laid out in the work packages and Gantt worked example.

What a lump-sum grant is, and is not

A lump-sum grant sets one share of the lump sum for each work package. When the work package is completed, that share is paid. The Commission’s guide is explicit about what completion means: “The completion of work packages is not based on a successful outcome, but on the completion of activities as described in the description of action.” A failed experiment that was carried out as planned is a completed work package.

Everything else about the proposal stays the same. You use the standard application form, you address the same three evaluation criteria, and the page limit rises only slightly, to 45 pages for RIA and IA topics, with section 3.1 given an indicative 17 pages instead of 12 so there is room for the fuller work plan. What disappears is actual-cost reporting: there are no financial checks or audits by the Commission, and no timesheets, payslips or invoices to show the EU. Technical reviews, and checks on IP, ethics, open science and dissemination obligations, still apply.

Actual-cost grant versus lump-sum grant
AspectActual-cost grantLump-sum grant
What triggers paymentEligible costs incurred and reportedWork packages declared completed and accepted
Budget at proposal stageEstimated per beneficiary in Part AEstimated per beneficiary and per work package in the detailed budget table (Type 2)
Financial reportingCost statements per beneficiaryGenerated automatically from accepted work packages
Financial audits by the CommissionYes, ex-postNo
Records for the EUTimesheets, payslips, invoicesTechnical evidence that the work was done
Effect of price changesAbsorbed within the budgetLump sum not questioned
Moving moneyBetween cost categories and beneficiaries within limitsBetween incomplete work packages, when justified; amendment to reflect it in the grant agreement
Main risk for the consortiumIneligible costs found at auditA work package that cannot be declared complete
Source: European Commission, Lump sum funding: what do I need to know?, v3.0, and the lump-sum Model Grant Agreement.

Type 1 and Type 2

The topic text states which of the two lump-sum options applies. They differ in who sets the amount and therefore in what you have to submit.

The two lump-sum options in Horizon Europe
Type 1Type 2
Who sets the lump sumThe Commission, in the callThe consortium, in the proposal
What you submit about the budgetThe split of the fixed amount across beneficiaries and work packagesA detailed budget table with cost estimations, uploaded as an annex to Part B
What evaluators checkWhether the resources and the split allow the work to be doneWhether the estimated costs are reasonable, in line with the work and with normal practice
Grant agreementAnnex 2: shares per beneficiary per work packageAnnex 2: shares per beneficiary per work package; the Excel table itself is not part of the grant agreement
Source: European Commission, Lump sum funding: what do I need to know?, v3.0.

The detailed budget table, sheet by sheet

For Type 2 topics you download the Excel file from the submission system, fill it, and upload it with Part B. Cost estimations must be in line with the beneficiary’s normal practices, reasonable, in line with the proposed activities, and subject to the normal eligibility rules: a cost can be estimated only if the same type of cost would be eligible in an actual-cost grant.

What you enter, and what the table calculates
Sheet or sectionWhat you enterCalculated automaticallyRule to remember
BE listName, acronym, country and funding rate of each beneficiary and affiliated entityOne BEx sheet per beneficiary after Apply changesRIA and CSA 100%; IA 70% (exceptionally 60%), non-profit entities 100%
WP listWork packages in the same order as Part BOne section per work package in every BEx sheetSplit long work packages here if you split them in Part B
BEx: personnel (A)Number of items and average cost per item per staff categoryTotal personnel cost1 item = 1 person-month; the A4 SME-owner rate is predefined
BEx: subcontracting (B)Number of subcontracted tasks and average cost per taskTotal subcontractingOne line per beneficiary per work package; tasks described and justified in table 3.1g
BEx: purchase costs (C)Items and average cost for travel, equipment, other goods, works and servicesTotal purchase costsAbove 15% of that beneficiary’s personnel costs, complete table 3.1h
Depreciation costs tabPurchase price, % used for the project, months used ÷ depreciation monthsDepreciation amountNot transferred automatically: copy it into the BEx equipment section by hand
BEx: other cost categories (D)Financial support to third parties, access to infrastructures, PCP/PPITotalsOnly if the topic conditions allow them
BEx: indirect costs (E)Nothing25% flat rate on eligible direct costsSubcontracting is excluded from the base
Estimated breakdown of the lump sumNothingShares per beneficiary per work package at the chosen funding rateCopy the beneficiary totals into the Part A budget table
Summary per WP; Person-months overviewNothingBoth tablesEvaluators use these; they must match Part B table 3.1f
Any commentsJustificationsExplain any personnel cost above the dashboard values
Source: European Commission, Lump sum funding: what do I need to know?, v3.0, annex on filling in the detailed budget table. Save the file as .xlsm while working because it uses macros; upload it as .xlsx or .xls, since .xlsm uploads are refused.

One change is under way. During 2026 the Commission is progressively replacing the Excel file with an online detailed budget table built into the Part A forms, and the two systems run in parallel. For the first topics on the online table, HORIZON-CL5-2026-05 topics D5-07, D5-02, D5-12 and D5-13 and HORIZON-CL5-2026-07 topics D1-01 to D1-05, there is no Excel template in the submission system at all. The level of detail and the evaluation approach are unchanged, so everything below applies to both.

Personnel costs and the Horizon dashboard

Personnel is usually the largest line, and it is the one evaluators check most directly. They are told to use the Horizon dashboard for lump-sum evaluations as an orientation: for each combination of country and organisation type it shows the distribution of average monthly personnel costs between the 20th and the 80th percentile, based on grants already signed in Horizon Europe. A rate above that band is not forbidden, but it must be explained in the Any comments tab, and if the budget as a whole is unfit for purpose or strongly overestimated the Implementation score drops. Consultants commonly advise treating anything above the 80th percentile as needing an explicit justification.

The person-month itself is simple: one person working full time for one month, and in the table one person-month is one item. The glossary entry on person-months covers the working-day conventions, and the budget calculator converts person-months to costs per partner.

Copy-paste template: justifying personnel costs in the Any comments tab

[Beneficiary short name], personnel category [A1 employees]:
The average monthly cost of [€X] per person-month is above the Horizon dashboard
range for [organisation type] in [country]. It reflects [the salary scale set by
the national collective agreement / the seniority mix: N senior researchers
(grade) and N postdocs] required for [task numbers], and includes [employer
social contributions of Y% required by law]. The figure is the average of the
actual monthly costs of the named staff in [year], consistent with the
beneficiary's usual cost accounting practice.

Worked example: the SALTMARSH budget

SALTMARSH is a Research and Innovation Action at a 100 percent funding rate: eight beneficiaries, six work packages, 424 person-months over 42 months. Its work plan, deliverables and staff-effort matrix are in the companion worked example; here the same person-months become money.

Step 1: personnel rates

These rates are illustrative placeholders, not dashboard values. They were chosen to look plausible for each country and organisation type so the arithmetic is realistic. Before you budget, read the current Horizon dashboard for your own country and organisation type and use your institution’s actual average costs.
SALTMARSH beneficiaries, person-months and illustrative monthly personnel rates
BeneficiaryCountryOrganisation typePerson-monthsIllustrative rate per PMPersonnel cost
AegCRIGreeceResearch organisation74€4,600€340,400
ULVSpainUniversity64€4,900€313,600
DELTANetherlandsSME75€7,400€555,000
ILVItalyPublic research body69€5,200€358,800
BWTEstoniaNGO31€3,300€102,300
NORSNorwayLarge enterprise51€8,900€453,900
RAVItalyPublic body29€4,400€127,600
AEAPortugalPublic body31€4,000€124,000
Total424€2,375,600
Personnel cost = person-months × average monthly cost. Person-months per beneficiary match table 3.1f of the companion work-plan example.

Step 2: the other cost categories

Two beneficiaries subcontract: DELTA buys €120,000 of marine works for the pilot installations in WP4, and BWT buys €30,000 of video production in WP6. Both tasks are support work, not core research, and both are described in table 3.1g. Purchase costs cover travel to meetings and pilot sites, sensors and pilot materials, events and open-access fees. DELTA also needs a hydrodynamic test rig for the design work in WP3, and here the depreciation rule matters: only the share used by the project is eligible.

Depreciation tab, DELTA, WP3, equipment

Purchase cost €60,000 × 60% used for the project × (24 months used ÷ 60-month depreciation period) = €14,400

The tab calculates this, but it does not copy it into the BEx sheet. Enter 1 item at €14,400 in DELTA’s WP3 equipment section yourself.

SALTMARSH estimated costs per beneficiary by cost category
BeneficiaryA. PersonnelB. SubcontractingC. Purchaseof which travelof which equipmentof which other goods and servicesE. Indirect (25%)Total
AegCRI€340,400€0€113,000€58,000€0€55,000€113,350€566,750
ULV€313,600€0€42,000€24,000€0€18,000€88,900€444,500
DELTA€555,000€120,000€56,400€28,000€14,400€14,000€152,850€884,250
ILV€358,800€0€115,000€20,000€0€95,000€118,450€592,250
BWT€102,300€30,000€43,000€17,000€0€26,000€36,325€211,625
NORS€453,900€0€34,000€12,000€0€22,000€121,975€609,875
RAV€127,600€0€54,000€6,000€0€48,000€45,400€227,000
AEA€124,000€0€59,000€7,000€0€52,000€45,750€228,750
Total€2,375,600€150,000€516,400€172,000€14,400€330,000€723,000€3,765,000
Indirect costs = 25% × (personnel + purchase), calculated per beneficiary and work package; subcontracting is excluded from the base. No other cost categories are used. At a 100% funding rate the total cost equals the requested EU contribution.

Lump-sum budget builder

Indirect costs at a flat 25.0% of personnel plus purchase, subcontracting excluded from the base. Opens with the SALTMARSH figures from this page.

Short nameCountryPM€/PMSubcontr.TravelEquipmentOther G&SPersonnelIndirectTotal3.1h?Remove
€340,400€113,350€566,750yes · 33.2%
€313,600€88,900€444,50013.4%
€555,000€152,850€884,25010.2%
€358,800€118,450€592,250yes · 32.1%
€102,300€36,325€211,625yes · 42.0%
€453,900€121,975€609,8757.5%
€127,600€45,400€227,000yes · 42.3%
€124,000€45,750€228,750yes · 47.6%
Total424€150,000€172,000€14,400€330,000€2,375,600€723,000€3,765,000

Country shares

  • Netherlands€884,250 · 23.5%
  • Italy€819,250 · 21.8%
  • Norway€609,875 · 16.2%
  • Greece€566,750 · 15.1%
  • Spain€444,500 · 11.8%
  • Portugal€228,750 · 6.1%
  • Estonia€211,625 · 5.6%

Equipment depreciation

The portal computes this but does not copy it into the BEx sheet — enter the result by hand.

Enter €14,400 as one equipment item.

  • Table 3.1h is required for 5 of 8 beneficiaries, whose purchase costs exceed 15% of personnel costs: AegCRI, ILV, BWT, RAV, AEA.

Table 3.1h is required where purchase costs exceed 15.0% of a beneficiary's personnel costs. The country-concentration and subcontracting warnings are consultant heuristics, not Commission rules. Figures are estimates for building the detailed budget table; the binding amounts are the ones fixed in the grant agreement.

Step 3: the checks evaluators will run

Two checks fall straight out of the table. The first is the 15 percent rule: any beneficiary whose purchase costs exceed 15 percent of its personnel costs must complete table 3.1h in Part B. In SALTMARSH that is five of eight beneficiaries, mostly the pilot hosts buying sensors and materials, which is normal for a project with physical pilots and exactly what 3.1h exists to explain.

The 15% purchase-cost check
BeneficiaryPurchase costsPersonnel costsPurchase as % of personnelTable 3.1h needed?
AegCRI€113,000€340,40033.2%Yes
ULV€42,000€313,60013.4%No
DELTA€56,400€555,00010.2%No
ILV€115,000€358,80032.1%Yes
BWT€43,000€102,30042.0%Yes
NORS€34,000€453,9007.5%No
RAV€54,000€127,60042.3%Yes
AEA€59,000€124,00047.6%Yes
Rule as stated in the Commission's lump-sum guide v3.0, which refers to purchase costs. The Part B template v5.1 words the same trigger as equipment costs above 15% of personnel costs. If only travel and consumables push a partner over the line, check the topic conditions or ask your NCP; completing table 3.1h when unsure costs a few lines.

The second is balance. No country holds more than 23.5 percent of the budget (the Netherlands, driven by DELTA’s engineering role), comfortably below the 40 percent level that consultants treat as a sign of an unbalanced consortium; that threshold is a heuristic, not a Commission rule. Subcontracting is 4 percent of the total, well under the 15 to 20 percent that the same consultants advise as a ceiling.

SALTMARSH budget share by country of the beneficiary
CountryBeneficiariesShare of total
NetherlandsDELTA23.5%
ItalyILV, RAV21.8%
Norway (associated)NORS16.2%
GreeceAegCRI15.1%
SpainULV11.8%
PortugalAEA6.1%
EstoniaBWT5.6%

Step 4: the lump-sum breakdown

This is the table that matters most, because it becomes Annex 2 of the grant agreement: one amount per beneficiary per work package. The Excel sheet generates it; the Part A budget table is then filled from its beneficiary totals.

SALTMARSH estimated breakdown of the lump sum (EU contribution per beneficiary per work package)
BeneficiaryWP1WP2WP3WP4WP5WP6Total
AegCRI€196,750€46,000€57,500€145,500€69,000€52,000€566,750
ULV€17,250€36,750€49,000€68,750€248,250€24,500€444,500
DELTA€23,500€55,500€418,000€304,000€55,500€27,750€884,250
ILV€18,000€52,000€65,000€372,750€65,000€19,500€592,250
BWT€7,875€16,500€8,250€24,750€16,500€137,750€211,625
NORS€14,875€261,250€133,500€89,000€89,000€22,250€609,875
RAV€8,000€16,500€33,000€142,000€16,500€11,000€227,000
AEA€7,500€15,000€40,000€131,250€25,000€10,000€228,750
Total€293,750€499,500€804,250€1,278,000€584,750€304,750€3,765,000
WP1 Project management; WP2 Baseline mapping and data; WP3 Nature-based solution design; WP4 Pilot deployment; WP5 Monitoring, modelling and policy evidence; WP6 Dissemination, exploitation and communication. Rows and columns reconcile to the euro.

Splitting long work packages by reporting period

A work package is paid at the end of the reporting period in which it is declared complete. In SALTMARSH the reporting periods are months 1 to 18, 19 to 36 and 37 to 42. Management (WP1) and dissemination (WP6) run the full 42 months, so as single work packages they would only be paid at the very end. The Commission’s guide says work packages with a long duration may be split along the reporting periods, with the same content, precisely so that activities can be declared and paid earlier; each split work package then needs its own description in table 3.1b. Splitting WP1 and WP6 pro rata to months turns six work packages into ten.

SALTMARSH after splitting WP1 and WP6 along the reporting periods
Work packageMonthsPaid at end ofLump-sum share
WP1a ManagementM1-M18RP1€125,892
WP2 Baseline mappingM1-M12RP1€499,500
WP6a DisseminationM1-M18RP1€130,608
WP1b ManagementM19-M36RP2€125,895
WP3 NbS designM4-M24RP2€804,250
WP4 Pilot deploymentM13-M36RP2€1,278,000
WP6b DisseminationM19-M36RP2€130,605
WP1c ManagementM37-M42RP3€41,963
WP5 Monitoring and policyM13-M42RP3€584,750
WP6c DisseminationM37-M42RP3€43,537
Total€3,765,000
WP1 and WP6 split per beneficiary in the proportion 18/42, 18/42 and 6/42 of months, rounded to whole euros so that each beneficiary's three parts add back exactly to its original share.
SALTMARSH payments for completed work packages, by reporting period
Reporting periodWork packages completedPayable for the periodCumulativeShare of total
RP1 (M1-M18)WP1a, WP2, WP6a€756,000€756,00020.1%
RP2 (M19-M36)WP1b, WP3, WP4, WP6b€2,338,750€3,094,75062.1%
RP3 (M37-M42)WP1c, WP5, WP6c€670,250€3,765,00017.8%
Amounts earned by completed work packages. Actual cash flow also includes a pre-financing payment at the start, whose level is set in the grant agreement and cleared against later payments, and 5% of the maximum grant (€188,250 here) retained for the Mutual Insurance Mechanism and released with the payment of the balance.

The trade-off is more tables in Part B and more work packages to declare, in exchange for interim payments that follow the work. Without the split, the RP1 payment would fall from €756,000 to the €499,500 of WP2 alone. The heavy RP2 payment is a consequence of the pilot design, not of the split: WP3 and WP4 together are more than half the budget and both end in the second period. The Mutual Insurance Mechanism and reporting period are defined in the glossary.

What happens when a work package is not completed

At the end of each reporting period the coordinator declares each work package Completed or Not Completed, supported by the technical periodic report, and the financial statement is generated automatically from the accepted work packages. The Commission’s own example shows the arithmetic: four beneficiaries, five work packages worth €350,000, €470,000, €350,000, €200,000 and €300,000, of which the first and third are completed in the period.

Payment = 350,000 + 0 + 350,000 + 0 = €700,000
  • An incomplete work package is simply paid later, at the end of any subsequent reporting period in which it is completed.
  • A work package can be accepted when all essential tasks were completed, when equivalent tasks were carried out, or when deviations are justified. Amendments to reflect scientific or technical changes are also possible.
  • Before a work package you declared completed is rejected, you are invited to respond to the project officer’s observations. If the rejection stands, that share is not paid at that point.
  • Only at the final reporting period can a work package be declared Partially Completed with a percentage. If it cannot be finished, for technical reasons or force majeure, the lump sum is paid partially in line with the degree of completion, decided case by case.

The practical lesson for design is to keep every work package completable by the consortium itself. A work package that can only be declared complete once an external authority grants a permit is a payment risk; put the permitting activity in its own task with a mitigation in table 3.1e, and define completion as the activities carried out.

From evaluation to grant agreement

The no-negotiation principle applies: the grant agreement is prepared from the proposal as submitted, with only obvious errors corrected, changes required by the rules, and the lump sum adjusted to the amount in the Evaluation Result Letter. The breakdown per beneficiary and per work package becomes Annex 2; the detailed budget table you submitted is not part of the grant agreement. Once fixed, the lump sum is not questioned if prices for goods or services change. Inside the consortium you may use the money as you see fit, since the Commission does not see the actual distribution, but moving shares between work packages in the grant agreement requires that the work packages are not yet completed, that the move is justified by the implementation, and an amendment. How the consortium agreement should handle that internally is covered in the consortium survival guide.

Eight mistakes evaluators flag

  1. Personnel costs above the dashboard with no comment. Use the Any comments tab and the template above.
  2. Core tasks subcontracted. Subcontracting is for support tasks, one line per beneficiary per work package, each justified in table 3.1g.
  3. Work packages whose completion depends on third parties. Permits, regulators or recruitment outside your control make the share unpayable.
  4. One management work package spanning the whole project. It will not be paid until the end; split it along the reporting periods.
  5. Equipment at full price. Enter depreciation for the share and period used, unless the work programme explicitly allows full capitalised costs.
  6. Purchase costs above 15% of personnel with no table 3.1h. The rule applies per beneficiary.
  7. A budget concentrated in one country. Consultants flag more than 40% as a sign of imbalance; it is a heuristic, but evaluators notice.
  8. Part A not matching the Excel file. Copy the beneficiary totals from the estimated breakdown of the lump sum, and keep table 3.1f consistent with the person-months overview.

For the Part B side of these checks, see the Part B template walkthrough; for writing the narrative that justifies the numbers, see budget narrative mastery and budget justification. On whether lump-sum topics are less competitive, an earlier Commission assessment reported higher success rates, discussed in Horizon Europe’s hidden instruments; treat it as indicative rather than a current programme-wide figure. For quick per-partner estimates before you open the Excel file, try the quick budget calculator.

Frequently asked questions

What is the difference between Type 1 and Type 2 lump sums?
In Type 1 the Commission fixes the lump sum in the call and you propose how to split it across beneficiaries and work packages. In Type 2 you define the amount yourself by submitting a detailed budget table with cost estimations as an annex to Part B. The topic text tells you which type applies.
Do I still need timesheets in a lump-sum project?
Not for the Commission. The lump-sum model grant agreement removes actual-cost reporting and financial audits, so timesheets, payslips and invoices are not required to prove costs to the EU. You must still keep technical evidence that the work was done, and national law or your own institution may require financial records anyway.
How are indirect costs calculated in the detailed budget table?
Automatically, at a flat 25 percent of eligible direct costs. Subcontracting, financial support to third parties and certain other items are excluded from the base, so a beneficiary with large subcontracts receives proportionally less in indirect costs.
What happens if a work package is only partly done at the end of the project?
At the final reporting period the coordinator can declare it Partially Completed and enter a percentage of completion. The Commission decides the partial payment case by case, including where completion was prevented by technical reasons or force majeure, and you can submit observations before the decision.
How do evaluators judge whether a lump sum is reasonable?
They read the detailed budget table against the work described in Part B and compare personnel costs with the Horizon dashboard for lump-sum evaluations, which shows monthly personnel costs by country and organisation type between the 20th and 80th percentile. Serious problems, such as a budget unfit for purpose or strongly overestimated costs, lower the Implementation score.
Is the Excel detailed budget table still used in 2026?
Yes, for most topics. During 2026 the Commission is progressively replacing it with an online table inside the Part A forms, and both systems run in parallel. For the first topics using the online table, such as several Cluster 5 2026 topics, no Excel template is available in the submission system.
Can the lump sum change after the grant is signed?
The amount is not questioned if prices change later. You can move money between work packages that are not yet completed when the change is justified by the scientific or technical implementation, and an amendment is needed if you want the grant agreement to reflect it.
Are lump-sum proposals easier to win?
Possibly on some topics, because risk-averse institutions avoid them, but there is no current programme-wide figure that proves it. An earlier Commission assessment reported notably higher success rates on lump-sum topics; see our discussion of hidden instruments and treat the figure as indicative.

Sources

  1. European Commission, Lump sum funding: what do I need to know? A guide for participantsPDF, version 3.0, 24 June 2024; all rules on the detailed budget table, the dashboard, payments and completion quoted on this page
  2. European Commission, Model Grant Agreement for lump-sum grantsArticles 5.4, 5.5, 20, 22 and 25 on the budget, flexibility, records, payments and controls
  3. European Commission, Detailed budget table for lump-sum proposals (Horizon Europe and Euratom)Excel template, for information; always use the file from the submission system
  4. European Commission, How to manage your lump sum grantsPDF, last updated October 2025
  5. European Commission, Assessment of lump sum funding in Horizon 2020 and Horizon EuropePDF, 3 September 2024
  6. European Commission, Best practices for lump sum grantsPDF
  7. European Commission, Standard Application Form (HE RIA and IA), Part BPDF, version 5.1, 22 January 2026; 45-page limit for lump-sum topics, section 3.1 at 17 pages, tables 3.1g and 3.1h
  8. Horizon Europe NCP Portal, Lump sum funding resource hubLinks to the MGA, the Excel table, guides and the February 2026 webinar
  9. Horizon Europe portal (Czech NCP), Online lump-sum budget table replaces Excel4 February 2026; topics already using the online table
  10. accelopment, Budget planning and work package design in Horizon Europe lump-sum proposals28 August 2026; share of lump-sum topics and splitting long work packages
  11. GetGrant, Work packages in Horizon Europe: deliverables, milestones and person-monthsConsultant heuristics on country concentration, subcontracting share and dashboard percentiles
  12. EMDESK, Horizon Europe lump sum funding: complete guide for project coordinatorsProject management perspective

Plan your budget

Turn person-months into a per-work-package budget before you touch the Excel file, then let Proposia draft the work plan narrative that justifies it.

EG

Founder & CEO, Proposia.ai

PhD researcher and Associate Professor in Computer Science, working at the intersection of algorithm design, applied mathematics, and machine learning. With Proposia.ai, I aim to transform research ideas into scalable AI solutions that support innovation and discovery.