Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementTraining & LearningAnnual Training Plan and Budget

SpreadsheetTraining & LearningFree

Annual Training Plan and Budget

Plan every training programme by quarter with participants, cost and hours, and track actual spend against the budget.

Shown with sample data

Colour

Annual Training Plan and Budget

Plan every training programme by quarter with participants, cost and hours, and track actual spend against the budget.

Annual budget
$95,000
Planned cost
$83,320
Excludes cancelled
Unallocated budget
$11,680
Spent to date
$23,080
Planned spend per employee
$450.38
Training hours per employee
13.3
Planned cost by quarter
  • Q1$19,800
  • Q2$13,740
  • Q3$41,800
  • Q4$7,980
Planned cost by category
  • Leadership$44,90052%
  • Technical$13,70016%
  • Soft skills$9,30011%
  • Compliance$8,40010%
  • Health and safety$5,5206%
  • Onboarding$5,1006%

How to use it

  1. 1Enter your annual training budget and headcount on the Settings sheet.
  2. 2Add each programme with category, quarter, expected participants and costs; planned cost calculates.
  3. 3Update Actual spend and Status as programmes run.
  4. 4Review the By quarter sheet monthly and move budget between programmes before anything goes over.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Build the year’s learning plan and keep it on budget. List each programme with its category, quarter, participants, cost per participant, fixed costs and hours; the plan calculates planned cost and total training hours, compares actual spend, flags programmes over budget and rolls everything up by quarter and category against your annual budget, with spend and hours per employee.

Who it’s for

  • Annual L&D budgeting and approval
  • Balancing compliance, leadership and technical training
  • Reporting training investment per employee

What’s included

  • Programmes sheet: One row per programme.
  • By quarter sheet: Planned and actual spend by quarter.
  • By category sheet: Planned cost and Training hours and the number of entries for each category.
  • Settings sheet: Budget and headcount for per-employee figures.

How to use it

  1. 1Enter your annual training budget and headcount on the Settings sheet.
  2. 2Add each programme with category, quarter, expected participants and costs; planned cost calculates.
  3. 3Update Actual spend and Status as programmes run.
  4. 4Review the By quarter sheet monthly and move budget between programmes before anything goes over.

Tips

  • Book mandatory compliance training first; it is non-negotiable and should not be squeezed by discretionary programmes.
  • Include internal costs that are easy to forget: venue, catering, travel and course design.
  • Track hours as well as money: many organisations target 20–40 learning hours per employee per year.

Questions

How much should a company spend on training per employee?

It varies widely by industry and size. Many organisations spend roughly $1,000–$1,500 per employee per year; use your own history and industry benchmarks.

What goes into an annual training plan?

The programmes you will run, who they are for, when, delivery method, provider, expected participants, costs, hours and how you will measure impact.

How do I calculate planned cost?

Participants × cost per participant, plus any fixed cost such as venue hire or course design that does not depend on numbers.

Related searchesannual training plan templatetraining budget spreadsheetlearning and development plantraining calendarl&d budgettraining plan excel

Details

Format
Spreadsheet
Category
Training & Learning
Sheets
4
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetTraining & LearningFree

Annual Training Plan and Budget

Plan every training programme by quarter with participants, cost and hours, and track actual spend against the budget.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Training & Learning
Sheets
4
Setup
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More training & learning templates

View all
Employee Training Tracker3 sheets

Overall compliance

83%

Expired or missing

4

Renewals in 60 days

2

ABCD
1EmployeeCourseCompletedCertificate no.
2Amara OkaforData protection essentialsMar 2
3Amara OkaforFire safety awarenessJan 20
4Amara OkaforHealth and safety inductionApr 2
5Amara OkaforLeading teamsMay 14BS-2291
Records
SpreadsheetTraining & Learning

Employee Training Tracker

A training matrix showing who is compliant, every course record with expiry dates and renewal alerts, and hours and spend by person.

10 min setupPreview
Skills Matrix & Training Needs Analysis2 sheets

Skills assessed

9

Priority training needs

3

Competent ratings

44%

ABCD
1EmployeeTeamSkillCurrent level 0-4
2RaviAssemblyLine changeover4
3RaviAssemblyTorque calibration1
4MinaAssemblyLine changeover2
5MinaAssemblyTorque calibration3
Skills
SpreadsheetTraining & Learning

Skills Matrix & Training Needs Analysis

Rate each person on the skills the team needs and see gaps, single points of failure and who to train.

10 min setupPreview

Training Evaluation Form

Ask learners what they thought, what they learned and what they will do differently back at work.

Course title *

Date *

Trainer

Submit evaluation
FormTraining & Learning

Training Evaluation Form

Ask learners what they thought, what they learned and what they will do differently back at work.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ