Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementProject PlanningRequirements Traceability Matrix

SpreadsheetProject PlanningFree

Requirements Traceability Matrix

Trace every requirement to its source, design and tests, and see coverage and verification at a glance.

Shown with sample data

Colour

Requirements Traceability Matrix

Trace every requirement to its source, design and tests, and see coverage and verification at a glance.

Requirements
13
Test coverage
85%
Requirements with at least one test
Verified
46%
Tests passed
Defects or blocked
2
Must-haves not verified
5
Must be zero at go-live
Requirements verified by priority
  • Must4
  • Should2

How to use it

  1. 1Give every requirement a unique ID and record where it came from.
  2. 2Add the design reference once it is designed and the test case IDs once tests are written.
  3. 3Update Test status after each test cycle.
  4. 4Before sign-off, resolve every Gap, Defect open and Blocked item, starting with Must priorities.
  5. 5When a requirement changes, use the matrix to find the design and tests to update.

In this workbook

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

About this template

A requirements traceability matrix proves that everything agreed was built and tested, and that nothing was built that nobody asked for. Each requirement links back to its source and forward to its design reference and test cases; the matrix flags gaps, failed tests and untested must-haves and calculates coverage and verification by priority. The sample traces an HR self-service portal.

Who it’s for

  • Software and system projects with formal sign-off
  • Regulated work (medical devices, finance, public sector) that needs audit evidence
  • Change impact analysis: what does this requirement touch?
  • Go-live readiness reviews

What’s included

  • Requirements sheet: One row per requirement, traced to source, design and tests.
  • By priority sheet: Coverage and verification for each priority.

How to use it

  1. 1Give every requirement a unique ID and record where it came from.
  2. 2Add the design reference once it is designed and the test case IDs once tests are written.
  3. 3Update Test status after each test cycle.
  4. 4Before sign-off, resolve every Gap, Defect open and Blocked item, starting with Must priorities.
  5. 5When a requirement changes, use the matrix to find the design and tests to update.

Tips

  • Write one testable requirement per row. "The system shall be fast and easy to use" cannot be traced; split and quantify it.
  • Use the same IDs as your backlog or test tool so the matrix can be checked against them.
  • Coverage is not quality: a requirement covered by one weak test is still a risk. Review tests for must-haves.

Questions

What is forward and backward traceability?

Forward traceability follows requirements to design and tests, proving everything is delivered. Backward traceability follows tests and features back to requirements, proving nothing unrequested was built.

Who maintains the RTM?

Usually the business analyst or QA lead, with input from developers and testers. It must be updated at every change, not reconstructed before go-live.

Is an RTM still useful in agile projects?

Yes, especially in regulated environments. Many agile teams keep a lightweight matrix linking epics and user stories to acceptance tests.

Related searchesrequirements traceability matrixrtm templatetraceability matrix excelrequirements trackingtest coverage matrixrequirements management

Details

Format
Spreadsheet
Category
Project Planning
Sheets
2
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetProject PlanningFree

Requirements Traceability Matrix

Trace every requirement to its source, design and tests, and see coverage and verification at a glance.

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
Project Planning
Sheets
2
Setup
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More project planning templates

View all
Project Plan with Gantt Timeline
Task
W1W2W3W4W5W6W7W8W9W10
Kick-off and charter sign-off
Stakeholder interviews
Requirements document
Budget and resource plan
Plan approved
Wireframes
SpreadsheetProject Planning

Project Plan with Gantt Timeline

A real Gantt chart: tasks by phase with dates, owners, dependencies, progress bars across 16 weeks and schedule status.

10 min setupPreview
Project Tracker
Task
OctNov
Customer survey launched
Pricing page copy
Partner contract signed
Onboarding email sequence
Analytics dashboard
Sales training deck
SpreadsheetProject Planning

Project Tracker

Deliverables with owner, priority, dates, progress, health and a workload view by person.

10 min setupPreview
Work Breakdown Structure (WBS)2 sheets

Work packages

9

Total effort (hours)

386

Total cost

$42,040

ABCD
1WBS codeStageDeliverableWork package
21.11 DiscoveryRequirementsStakeholder interviews
31.21 DiscoveryRequirementsRequirements document and sign-off
42.12 DesignExperience designUser flows and wireframes
52.22 DesignVisual designDesign system and page designs
WBS
SpreadsheetProject Planning

Work Breakdown Structure (WBS)

Break a project into phases, deliverables and work packages with effort, cost and owner rolled up by phase.

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