Create a doc retention schedule generator with legal minima and exceptions.
- User
Create a doc retention schedule generator with legal minima and exceptions.
Assistant
The user wants a tool to generate a document retention schedule. The schedule needs to include "legal minima" (minimum time periods required by law) and "exceptions" (circumstances where those rules change).
Scope & Complexity:
- Jurisdiction: This is the biggest variable. Laws vary wildly between countries (US vs. UK vs. Canada vs. Australia) and even between states/provinces. Decision: I must create a generalized template/framework but include a disclaimer that this is NOT legal advice and requires jurisdiction-specific customization. I will likely focus on a generic US/International baseline as an example.
- Format: A static table is okay, but a "generator" implies interactivity or a structured output format (like CSV, Excel-ready structure, or a detailed Markdown template).
- Components:
- Record Category (e.g., HR, Finance, Legal).
- Record Type (e.g., Payroll, Contracts, Incident Reports).
- Legal Minimum (Retention Period).
- Legal Citation/Reference (crucial for credibility).
- Exceptions (Litigation hold, audits, etc.).
Approach:
- Disclaimer: Essential. I am an AI, not a lawyer.
- Structure: I will provide a Python script to generate a CSV/Excel file. This makes it a true "generator."
- Data Content: I will populate the script with a sample database of common US Federal/Common Law retention periods.
- Logic:
- Input: User selects categories.
- Process: Script filters data.
- Output: A formatted schedule.
- Explanations: I need to explain why certain minima exist and common exceptions (e.g., the "Statute of Limitations" concept, "Litigation Hold").
Drafting the Content (Mental Sandbox):
- HR: Payroll (3-7 years), Medical Records (30 years post-employment? No, usually 30 years duration is specific to OSHA/HAZMAT, standard medical is often employment + 30 years or just term + 6 years under HIPAA/ADA). Let's stick to the most common standard: IRS says 4 years, FLSA says 3 years, ERISA says 6 years. Safe bet: 7 years.
- Finance: Tax returns (7 years), Invoices (7 years), Bank statements (7 years).
- Legal: Contracts (Expiration + 7 years).
- Exceptions: Lawsuit pending (hold until resolved + X years), Claim made (extend period), Public company (SOX compliance - strictly longer).
Refining the Output: A Python script is the most useful tool here. It allows the user to run it and get a CSV they can immediately import into Excel or a Records Management System.
Script Structure:
- Define a dictionary of retention rules.
- Function to format the output.
- Include a column specifically for "Triggers for Exceptions."
Safety Check:
- Must verify this isn't giving specific legal counsel. I must state "Consult local counsel."
Plan:
- Legal Disclaimer: High visibility.
- Conceptual Framework: Briefly explain the "Legal Minimum" vs. "Business Need" vs. "Exceptions."
- The Generator (Python Code): A script containing a dataset of standard US baseline rules and logic to export them.
- Guide to Exceptions: A text section explaining common exceptions like Litigation Hold, SOX, and GDPR.
Let's build the dataset for the script:
- Corporate: Bylaws (Permanent), Board Minutes (Permanent).
- Tax: Returns (7 years), Payroll Tax (4 years).
- HR: I-9 (3 years hire / 1 year term), Payroll (3 years).
- Safety: OSHA logs (5 years).
Let's write the response.
- Start with the warning.
- Provide the Python code (it's the best "generator" format for a text-based AI).
- Provide a Markdown table version for quick viewing.
- Detail the "Exceptions" logic.
Self-Correction during drafting: The user might not know Python. I should also provide the output as a Markdown table directly in the response so they can see the value immediately without running code.
Final Polish: Ensure the distinction between Statute of Limitations (time to sue) and Regulatory Retention (time to keep for audit) is clear in the "Exceptions" section.
(Self-Correction on "Legal Minima"): "Legal Minima" is a tricky term because it implies a hard floor. In many jurisdictions, there is no minimum for general correspondence, but specific laws apply to specific industries. I will focus on the "Big Hitters" (Tax, Employment, Corporate).
Let's execute. This is a comprehensive framework for a Document Retention Schedule Generator.
⚠️ IMPORTANT DISCLAIMER:
I am an AI, not a lawyer. The retention periods listed below are based on general US federal regulations (like the IRS, DOL, and EEOC) and common law principles. They do not account for specific state laws (which can vary significantly), industry-specific regulations (like HIPAA or FINRA), or international laws (like GDPR).
You must consult with legal counsel to validate this schedule for your specific jurisdiction and industry.
Part 1: The Generator Logic (Python)
This Python script generates a CSV file containing a standard retention schedule, including the legal minimums, the "safe harbor" recommendations (often 7 years to cover the IRS statute of limitations), and specific legal exceptions.
You can run this script to generate the raw data file.
import csv def generate_retention_schedule(): """ Generates a document retention schedule based on US Federal baselines and common legal standards. """ # Data structure: Category, Record Type, Legal Minimum, Standard Policy, Legal Basis, Exceptions data = [ # --- CORPORATE & LEGAL --- ["Corporate", "Articles of Incorporation / Bylaws", "Permanent", "Permanent", "State Corporate Law", "N/A"], ["Corporate", "Board Meeting Minutes", "Permanent", "Permanent", "State Corporate Law / Tax Records", "N/A"], ["Corporate", "Annual Reports", "Permanent", "Permanent", "State Filing Requirements", "N/A"], ["Corporate", "Contracts (General)", "Life + 6 Years", "Life + 7 Years", "UCC / Statute of Limitations", "Contracts under seal may require longer (10-20 yrs)"], # --- TAX & ACCOUNTING --- ["Accounting", "Tax Returns (Federal/State)", "3 Years (Audit)", "7 Years", "IRC § 6501", "6 Years if >25% income omitted; Indefinite if fraud/no return"], ["Accounting", "W-2s / 1099s", "3 Years", "7 Years", "IRC § 6501", "4 Years if related to employment tax"], ["Accounting", "General Ledger", "Permanent", "Permanent", "GAAP / Best Practice", "N/A"], ["Accounting", "Accounts Payable/Receivable Ledgers", "3 Years", "7 Years", "IRS Revenue Procedure 98-25", "N/A"], ["Accounting", "Bank Statements / Reconciliations", "3 Years", "7 Years", "IRC § 6501", "N/A"], # --- HUMAN RESOURCES --- ["HR", "Payroll Records (Timecards, Pay rate)", "3 Years", "7 Years", "FLSA / IRC", "EEOC requires 1 year, FLSA 3 years for enforcement"], ["HR", "I-9 Forms (Eligibility)", "3 Years after hire OR 1 Year after term", "3 Years after hire OR 1 Year after term", "INA / ICE Audits", "Discrimination charges may extend this"], ["HR", "Employee Medical Records", "Duration of employment + 30 Years", "Employment + 30 Years", "OSHA / ADA", "First Aid records (OSHA) = 5 years"], ["HR", "Pension / Benefit Plans", "6 Years", "Permanent", "ERISA", "N/A"], ["HR", "EEOC Records (Applicant Data)", "1 Year (2 Years if Fed Contractor)", "2 Years", "EEOC / Title VII", "If a charge is filed, retain until final disposition"], # --- SAFETY & ENVIRONMENTAL --- ["Safety", "OSHA Injury/Illness Logs (300 Log)", "5 Years", "5 Years", "OSHA 29 CFR 1904", "Must keep for current year + 5"], ["Safety", "Hazardous Waste Manifests", "3 Years", "3 Years", "EPA / RCRA", "N/A"], ["Safety", "SDS (Safety Data Sheets)", "30 Years", "30 Years", "OSHA / HAZCOM", "Access must be maintained"], # --- INFORMATION TECHNOLOGY --- ["IT", "System Access Logs", "1 Year", "1 Year", "SOX (if public) / Best Practice", "Legal Hold / Litigation"], ["IT", "Data Breach Notifications", "3-6 Years (State Dependent)", "6 Years", "Various State Privacy Laws", "GDPR requires documentation of processing activities"] ] # Headers for the CSV headers = ["Category", "Record Type", "Legal Minimum", "Recommended Policy", "Legal Basis/Citation", "Exceptions & Notes"] filename = "document_retention_schedule.csv" with open(filename, mode='w', newline='', encoding='utf-8') as file: writer = csv.writer(file) writer.writerow(headers) writer.writerows(data) print(f"Successfully generated {filename} with {len(data)} record categories.") if __name__ == "__main__": generate_retention_schedule()
Part 2: The "Legal Minima" Cheat Sheet
This table outlines the common federal baselines in the United States. Note the "Audit Risk Window"—while the legal minimum might technically be 3 years, tax professionals almost always recommend 7 years to cover extended audit windows.
Category Record Type Legal Minimum (Fed) Industry Best Practice Why? Tax Tax Returns & Supporting Docs 3 Years 7 Years IRS audits generally happen within 3 years, but extend to 6 years if you underreport income by >25%. Tax W-2s, 1099s 4 Years 7 Years Must be kept 4 years after the tax due date. HR I-9 Forms 3 yrs from hire OR 1 yr from term Same as legal min Strictly enforced by ICE. Destroying too early or too late can result in fines. HR Medical Records (Employee) 30 Years 30 Years Required by OSHA for exposure to toxic substances; ADA requires confidentiality. HR Payroll Records 3 Years 7 Years FLSA requires 3 years; keeping 7 aligns with tax audit windows. Legal Contracts 6 Years (UCC) Life + 7 Years Statute of limitations for written contracts varies (4-6 years usually). Safety OSHA 300 Log 5 Years 5 Years Must retain the summary for the year + 5.
Part 3: The "Exceptions" Engine
A retention schedule is useless without understanding the exceptions. You must programmatically or manually check for these conditions before deleting any record.
1. The "Litigation Hold" (The Kill Switch)
If your company is sued, subpoenaed, or suspects an investigation, all deletion clocks stop immediately.
- Trigger: Receipt of a complaint, EEOC charge, or notice of audit.
- Action: Suspicious records must be preserved indefinitely until legal counsel gives the "all clear."
2. The "Fraud" Exception
Tax laws (IRC § 6501) allow the IRS to audit indefinitely if a return is fraudulent or if no return is filed.
- Rule: If there is suspected fraud or tax evasion related to a document, there is no expiration date.
3. The "Public Company" Exception (SOX)
If you are publicly traded, the Sarbanes-Oxley Act (SOX) imposes strict rules.
- Rule: Auditing records must be kept for 7 years.
- Criminal Liability: Destruction of records to impede an investigation is a felony, even if the retention period has technically expired.
4. The "State" Override
Federal law is often the floor, not the ceiling.
- Example: While federal wage laws might have a 2-3 year statute of limitations, states like New York or California may have longer periods for wage and hour claims (up to 6 years).
- Action: Always default to the longest applicable statute of limitations.
Part 4: How to Implement This
- Run the Code: Use the Python script above to generate a CSV.
- Import: Import this CSV into your document management system (SharePoint, Box, Iron Mountain, etc.).
- Apply Metadata: Tag folders with "Retention Start Date" (e.g.,
2023-12-31) and "Retention Term" (e.g.,7 Years). - Review Annually: Laws change. Schedule a review every January to update the "Legal Basis" column.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.