About this template
Salary Budget & Personnel Cost Calculator 2026/2027 – Excel, Word, and PDF
Plan and track salary costs, employer contributions, occupational pensions, special payroll tax, insurance, and other personnel costs in one comprehensive template package. Suitable for small businesses, payroll and finance departments, HR, personnel managers, and organizations that need a cost budget for multiple positions or roles.
You receive an editable Excel tool with 40 personnel/role rows × 12 months, a clear budget dashboard, calculation models, and a separate budget-vs-actual comparison. Six Swedish/English Word working documents are included, along with corresponding searchable PDF versions. The product is a one-time purchase for 79 SEK, with no subscription.
What’s included – 13 ready-to-use files
| Document | Practical use | Format |
|---|---|---|
| Salary Budget & Personnel Cost Calculator | Eight Excel sheets with personnel register, salaries, pension assumptions, monthly costs, dashboard, budget vs. actual, scenarios, and decisions. | XLSX |
| Salary Budget – procedure & responsibility | Governance document for budget owners, control of cost categories, decision mandates, and monthly follow-up. | DOCX + PDF |
| Personnel Cost Basis – per role | Editable form for salary, FTE, active period, pension, vacation-related items, and other assumptions. | DOCX + PDF |
| Salary and Staffing Budget – decision log | Basis for establishing an annual personnel cost framework and documenting deviations and decisions. | DOCX + PDF |
| Personnel Costs – budget vs. actual | Monthly reconciliation of budgeted personnel costs against actual recorded costs. | DOCX + PDF |
| Personnel Cost Budget – English | English work form adapted to Swedish employer and accounting conditions. | DOCX + PDF |
| Detailed User Guide | Step-by-step instructions, formulas, examples, exceptions, legal sources, and English quick guide. | DOCX + PDF |
Total of 13 files: 6 DOCX, 6 searchable A4-PDFs, and 1 functional XLSX in a ZIP file. The files can be used offline in compatible office programs.
Excel – complete personnel cost budget with monthly distribution
- Dashboard: annual total personnel cost, base salaries, employer contributions, pension including special payroll tax, active roles, and monthly budget/actual graph.
- Assumptions: budget year, full standard employer contribution, special payroll tax on pension, planning assumption for pension, and salary change scenario.
- Personnel: 40 roles/employees with internal ID, position, department, monthly full-time salary, employment rate (FTE), start/end month, and separate budget items. Individual contribution and pension percentages can be specified.
- Monthly Budget: 480 prepared personnel-month combinations with automatic calculations of base salary, budgeted supplements, employer contributions, occupational pension, pension payroll tax, insurance, and other costs.
- Budget_Actual: twelve months with manually entered actual cost outcomes and automatic deviations. A positive difference means a higher cost than budgeted.
- Scenarios: overview sensitivity analysis for changed salary levels with clearly marked simplifications.
- Decision Log: responsible parties, cost decisions, deviations, and version history.
- Guide: brief instructions and links to primary legal sources.
Excel includes checks for, e.g., incorrect FTE, invalid employment months, and duplicate personnel/role IDs. New workbooks are empty of employees, with no fictitious salary data, and start at zero in the summary.
2026 contribution rates – editable input values
For most employees, the full employer contribution for 2026 is 31.42 percent. For qualified pension costs, a special payroll tax of 24.26 percent applies. The template uses these 2026 levels as visible, editable assumptions. A pension premium of 4.5 percent is an optional budget illustration, not a generally statutory pension level.
How to work with the personnel cost budget
- Select the budget year and verify the correct social security and pension tax rates in Assumptions.
- Set up personnel/role ID, monthly salary at 100 percent, employment rate, and the months for which the role is budgeted.
- Enter separately decided supplements, additional vacation costs, pension, and insurance. Check that items are not double-counted.
- Go to Monthly Budget and view the automatic total cost for each role and month.
- Review the dashboard, critical inputs, and planned staffing costs.
- Enter actual recorded personnel costs into Budget_Actual for the same period and cost scope.
- Document budget deviations and changes using the Word forms and Decision Log.
Calculation example
A role with 40,000 SEK in monthly salary, 100 percent employment rate, standard employer contribution of 31.42 percent, illustrative pension premium of 4.5 percent, and pension payroll tax of 24.26 percent results in – when no additional costs are specified – an estimated personnel cost of 54,804.68 SEK per month or 657,656.16 SEK per year. Vacation-related supplements, collective insurance, pension thresholds, and other individual terms are added as needed.
Vacation, employer contributions, and occupational pension
The Annual Leave Act (1977:480) includes, among other things, the "same pay" rule and the percentage rule. With a monthly salary, it is not correct to generally add an extra 12 percent vacation pay to all twelve monthly salaries without checking the actual applicable calculation. The template therefore has a separate field for verified additional vacation supplements or other vacation-related costs. Occupational pension and insurance depend on employment contracts, collective agreements, and employer commitments.
Sources: Swedish Tax Agency – employer contributions · Swedish Tax Agency – special payroll tax · Verksamt – calculate what an employee costs · Annual Leave Act – The Riksdag.
Frequently asked questions
Can I plan for multiple employees and months?
Yes, Excel has 40 role/personnel rows and 480 person-months with automatic compilation for twelve months.
Does Excel calculate employer contributions?
Yes, with a checked standard percentage or a manually verified individual percentage. Complex age, ceiling, and subsidy exceptions are not calculated automatically.
Are occupational pension and special payroll tax included?
Yes, as simplified editable budget assumptions. Actual pension bases, agreements, one-off allocations, and tax bases must be assessed separately.
Can I do budget vs. actual?
Yes, register the actual recorded cost per month and review the deviation against the budget in Excel.
Does the template work with Fortnox or other payroll systems?
It can be used as a standalone supplementary budget basis. No direct integration, SIE import, payroll runs, or AGI declaration are included.
Can I use the same model during 2027?
Yes, but update and verify all contribution rates, pension terms, salaries, and agreements first. The pre-filled 2026 standard rate is not a claim regarding 2027.
Is an English version included?
A separate English work form and an English quick guide are included. The other main templates are in Swedish, adapted for Swedish conditions.
Is this a duplicate of an income budget or a timesheet?
No. An income budget follows the company's overall income statement, while this product specifies the components of personnel costs per role and month. A timesheet tracks registered working hours, not calculated future employer costs.
Digital delivery and disclaimer
13 document files are delivered as a digital ZIP when the package is linked in Shopify Digital Products. No physical product is sent. The product is a budget and planning template – not a legal opinion, government form, payroll system, tax calculation, complete vacation debt model, or automated payroll processing.
In-depth guide
Read our practical walkthrough on what an employee costs in 2026 with examples, a checklist, and frequently asked questions.
