You can't manage what you can't see. Before you write a single retention rule, you need to know what records you have, who creates them, and why they exist. This worksheet provides a structured method to inventory your records and gather the information needed to build defensible retention schedules.
Purpose of the Template
This inventory worksheet helps you systematically document the records your organization creates or receives. Use it to capture the content, context, and business purpose of each record series before assigning retention periods or disposition authorities.
The worksheet serves three key purposes:
Foundation for Scheduling: Your record schedule should be based on information gathered during the inventory. Without accurate data, you're guessing at retention periods, risking both over-retention (increased storage costs, eDiscovery exposure) and under-retention (compliance gaps, spoliation claims).
Audit Documentation: When regulators or auditors ask, "How do you know you're keeping everything you need to keep?", this inventory provides your answer. It shows that you've systematically identified your records and applied retention logic based on actual business requirements.
Stakeholder Engagement: The inventory process encourages conversations with business units about what they create, why it matters, and how long they need it. These discussions build the cross-departmental relationships that make your Records and Information Management program effective.
Prerequisites
Before you start inventorying:
Identify Your Scope: Will you inventory a single department, a business function, or the entire organization? Start narrow if this is your first inventory. You can expand later.
Schedule Stakeholder Interviews: You'll need 30-60 minutes with someone who actually creates or uses the records. Don't rely on assumptions. The finance manager who processes invoices knows details that won't appear in any system documentation.
Gather Existing Documentation: Pull any process maps, system diagrams, or old file plans you have. They won't be complete, but they'll give you starting points for your conversations.
Set Your Classification Approach: Will you organize by business function (procurement, HR, legal) or by department (marketing, operations, IT)? Functional classification is more stable when org charts change, but department-based inventories are easier if you're just getting started.
The Inventory Worksheet
Copy this template into a spreadsheet. Add one row per record series:
- Record Series Name: Descriptive title that business users will recognize
- Business Function: The work activity this record supports
- Creating Department/Office: Who generates or receives this record
- Record Description: What information does this record contain? Be specific about data elements, not just the form name
- Business Purpose: Why does this record exist? What decision or transaction does it document?
- Source of Information: Where does the data come from? External parties, internal systems, manual entry?
- How Information Is Used: Who references this record after creation? For what purpose?
- Format: Paper, electronic, both? If electronic, which system?
- Volume: Approximate count or linear feet. "Unknown" is acceptable for first draft
- Current Retention Practice: How long do users actually keep this now, regardless of policy?
- Legal/Regulatory Requirements: Any statute, regulation, or contract that mandates retention? Cite specific rule numbers
- Litigation/Audit History: Has this record type been requested in past legal holds or audits?
- Stakeholder Interview Date: When you gathered this information
- Stakeholder Name/Title: Who provided the information
Customizing the Worksheet
Add Fields for Your Industry: If you're in healthcare, add HIPAA applicability. In financial services, add SEC or FINRA rule references. In manufacturing, add quality system linkages.
Adjust Granularity for Your Maturity Level: If you're building your first schedule, you might combine related records into broader series (all procurement records, all HR records). As your program matures, you can break these into more specific series with tailored retention periods.
Include System Fields if You're Heavily Electronic: Add columns for: system of record, backup frequency, access controls, and whether the system has automated disposition capabilities.
Track Inventory Status: Add a "Review Status" column with values like: Not Started, Interview Scheduled, Draft Complete, Validated by Stakeholder, Approved for Scheduling. This helps you manage a multi-month inventory project.
Validation Steps
Review with the Business Owner: Send your completed row back to the stakeholder who provided the information. Ask, "Does this accurately describe what you create and why?" You're not asking them to approve retention periods yet. You're confirming you understood their work.
Check for Gaps: Compare your inventory to other sources: your business classification scheme, system inventories, litigation hold notices from the past three years. If you issued a hold for "customer complaint files" but don't see them in your inventory, you missed something.
Test Your Descriptions: Show a record description to someone in a different department. Can they understand what the record is without additional explanation? If not, add more context about the business process.
Validate Legal Citations: If you listed a regulation or statute, verify the citation. Don't write "FLSA requires seven years." Write "FLSA 29 CFR 516.5 requires three years for payroll records." Precision matters when auditors check your work.
Document Your Methodology: Write a brief memo explaining which departments you inventoried, who you interviewed, what time period you covered, and any areas you explicitly excluded. When you update this inventory in two years, you'll need to know what you actually did.
The inventory takes time. You won't finish it in a week. But every row you complete gives you one more record series you can schedule with confidence instead of guessing. Start with your highest-risk records first: those subject to litigation holds, regulatory audits, or privacy laws. Then expand systematically.
Your inventory isn't a one-time project. Plan to review and update it annually, or whenever you implement new systems or launch new business processes. Organizations with defensible records programs don't just have an inventory. They maintain it.
