Skip to content

Training Budget Templates

    Six free training budget templates for planning a year of staff development, a single programme, or the compliance training you have no choice about. The thing that derails most training budgets is not the price of courses — it is that the course fee is usually the smaller half of what a course actually costs.

    • Templates6 designs
    • FormatEditable Office files
    • CoversDirect and indirect costs
    • CostFree, no signup

    The course fee is the smaller half

    Take a two-day external course at $900 a place, for an employee on a $65,000 salary. Their loaded hourly cost is $31.25, so two working days of their time is $500 in salary, or about $640 once employer taxes, pension and insurance are counted at a typical 28% loading.

    Line Cost Share
    Course fee $900 40%
    Employee time, 16 hours loaded $640 28%
    Travel $400 18%
    Accommodation, two nights $220 10%
    Meals and incidentals $90 4%
    True cost $2,250 —

    The fee is 40% of it. The other $1,350 is real money or real lost output, and a budget built from course prices alone will be short by roughly the amount it contains. Figures are illustrative — substitute your own salaries and travel costs and the proportions will shift, but the shape rarely does.

    Two lines that get left out even by people who know to include travel:

    • Cover or backfill. If someone has to be paid overtime, or a shift has to be filled, that is a training cost. In a small team it can exceed the fee.
    • Internal trainers are not free. A manager delivering two days of induction is two days not doing their job. “We’ll do it in-house” moves a cost off the invoice, not out of the business, and budgets that treat internal delivery as costless are the ones that quietly stop happening when things get busy.

    The templates

    Six layouts for recording planned and actual training spend. Each download is a zip file — extract it before opening.

    Training budget template 1Template 1Download
    Training budget template 2Template 2Download
    Training budget template 3Template 3Download
    Training budget template 4Template 4Download
    Training budget template 5Template 5Download
    Training budget template 6Template 6Download

    Public course or in-house cohort?

    This is the decision that moves a training budget most, and it has a crossover point you can calculate rather than argue about.

    A public course charges per head: $900 a place in the example above. An in-house course is almost all fixed cost — say a trainer at $4,500 a day for two days plus $800 of venue and materials, which is $9,800 whether six people attend or fifteen.

    Attendees Public, at $900 each In-house, fixed Cheaper
    4 $3,600 $9,800 Public, by $6,200
    8 $7,200 $9,800 Public, by $2,600
    11 $9,900 $9,800 In-house, by $100
    15 $13,500 $9,800 In-house, by $3,700

    So on delivery cost alone, $9,800 divided by $900 gives a crossover just under 11 — in-house wins from the eleventh attendee, and at fifteen it works out at $653 a head against $900.

    But add travel back in. Each person sent to a public course also costs the $710 of travel, accommodation and meals from the first table, so the real comparison is $1,610 a head against a fixed $9,800. That moves the crossover down to seven people. If you have seven or more people who need the same training, bringing the trainer to them is usually cheaper — and that is before counting the travel time you are also paying for.

    Which means the most useful thing a training budget can do is group people by need rather than list courses by person. If the sheet is organised one row per employee, those sevens are invisible.

    Ring-fence the training you have no choice about

    Split the budget in two before you start filling it in, because one half is not really a budget at all.

    Category What it contains
    Mandatory Health and safety, licences and certifications with renewal dates, regulatory and sector-specific requirements, the induction without which someone cannot start. Non-negotiable, and the dates are set by someone other than you.
    Discretionary Skills development, leadership programmes, conferences, qualifications, anything with a business case rather than a legal obligation.

    Keep them as separate totals. If they sit in one pot and the budget gets trimmed mid-year, the cut lands on development by default, because the compliance items cannot move — and nobody decided that, it just happened. Separating them makes the trade-off explicit, which is also the argument you need when asking for the money back.

    Certifications are worth their own column for renewal dates. An expired certificate can stop someone working, and the cost of noticing late is never just the course fee. The same logic applies to cross-training: if one person is the only one who can do something, that is a risk your business continuity plan should already name, and the training that fixes it belongs in this budget rather than being rediscovered during an incident.

    Building the budget

    1. Start from needs, not from courses

      List the gaps first — by role, by team, by compliance deadline — and only then look at what it would cost to close them. Starting from a catalogue of courses produces a budget for things that happened to be available. Individual personal development plans are the natural input here, and an organisation chart is a quick way to spot which roles were never covered at all.

    2. Group the needs before pricing them

      Sort by what is being learned rather than by who is learning it. This is where the cohort arithmetic above pays off, and it usually changes the total by more than any negotiation with a supplier will.

    3. Price the full cost of each line

      Fee, trainer, time, travel, cover, materials, platform or licence fees, exam and re-sit fees. Count what you already own — a room, projection equipment, an existing learning platform — as zero in cash terms but note it, because it is the reason an in-house option is viable and the first thing to check before someone books a venue.

    4. Put each line in the month it falls

      Training spend is lumpy. Certification renewals have fixed dates, onboarding follows the hiring plan, and most organisations cannot release half a team in the same week. Spreading an annual figure evenly across twelve months produces a budget that is wrong every month, which is the commonest fault in a budget spreadsheet of any kind.

    5. Leave a contingency line, explicitly

      Around 10% of the discretionary half, as its own row rather than padding spread across the others. Someone will join, something will be re-scoped, an exam will be failed and re-sat. A named contingency gets spent on those; padding gets spent invisibly and teaches you nothing for next year.

    6. Take it for approval with the cost per head, not just the total

      A total invites a percentage cut. A cost per head against a named gap invites a decision about which gaps stay open, which is a better conversation and a more defensible one. Bring the in-house versus public comparison with you — it shows the number has been worked rather than requested.

    Tracking it, and why underspending is not a win

    Record actuals against budget monthly, in the same sheet, with a variance column. Three metrics are worth keeping because they survive comparison year to year:

    • Spend per employee — total divided by headcount.
    • Spend as a share of payroll — the figure finance will ask for.
    • Formal learning hours per employee — which catches the case where spend rose but delivery did not.

    Industry benchmarks for these are published annually, by the Association for Talent Development among others, but they vary so widely by sector and company size that an average is weak evidence either way. Your own previous year is the more useful comparison, and if you do want an external number, take it from the current report rather than from whatever figure is circulating — much of what gets quoted online is several years old.

    A training budget that comes in well under is usually read as a budget that was not needed, and gets reduced next year. If the money went unspent because courses were cancelled or people could not be released, record that reason in the sheet as you go. It is the difference between asking for the same budget again and being told you did not use the last one.

    For measuring whether the training worked rather than whether it was delivered, the long-standing framework is Donald Kirkpatrick’s four levels, set out in the 1950s: did participants react well, did they learn, did their behaviour change, and did business results move. Most organisations evaluate the first level and claim the fourth. Picking one programme a year and following it properly through to level three is more convincing than a feedback form on everything.

    Common questions

    Do I need Microsoft Office?

    No. These open in Google Docs and Google Sheets, or in LibreOffice. If a file contains formulas, check the totals after opening, as ranges occasionally shift between applications. Extract the zip first either way.

    Should the training budget sit inside HR or inside each department?

    Both arrangements are common. Centralised is easier to protect and easier to benchmark; devolved gets the spending closer to the need. What causes trouble is a hybrid where nobody owns the total, so agree where the mandatory half lives before the year starts, since that is the half with deadlines attached.

    How do I budget for e-learning or a subscription platform?

    As a fixed annual cost with a per-seat element, and note the renewal date. The figure to watch is licences against actual active users, which tends to drift apart after the first year. Platform cost belongs in this budget, not in IT, or it stops being visible as training spend.

    Should employee time be a cash line in the budget?

    Usually not, since the salary is already budgeted elsewhere and counting it twice overstates the cash you need. Keep it in a separate column as the true-cost figure. It is the number that justifies choosing a shorter or in-house option, so it is worth having even when it is not being spent from your budget.

    Where does this fit in the wider budget?

    As an operating cost line, usually under administration or people costs. Our annual budget sheets cover the surrounding structure and the budget-versus-actual columns this one should feed into.

    Can I use these commercially?

    Yes, inside a business or for client work. You may not resell or redistribute the template files themselves. See our Terms of Use.