A paralegal case management spreadsheet template works when it captures case-identifying information in the first block of columns, deadlines in the second, and status in the third, with separate tabs or sections for discovery requests, conflict checks, trust ledgers, and closed-file retention. Everything below walks through what each of those columns needs to hold and how to format them so the sheet remains the office’s reliable source of truth rather than a document people quietly stop opening.
The Columns Every Entry Needs
One row per matter. The columns that belong in that row:
- Internal file number assigned at intake, matching the firm’s billing and document systems.
- Client full legal name, phone, email, and mailing address, written the way they appear on filed pleadings.
- Opposing party name, plus opposing counsel’s name, firm, phone, and email, pulled from the initial pleading or notice of appearance.
- Court and docket or index number assigned when the initial pleading was accepted.
- Case type, controlled by a drop-down so entries stay consistent (personal injury, breach of contract, family law, and so on).
- Current phase from a fixed list: intake, pleadings, discovery, mediation, trial preparation, trial, appeal.
- Assigned lead attorney, which drives workload reporting and accountability.
- Key deadlines, which get their own column group below.
- Last activity, a short note like “Answer filed 3/12” or “Deposition of plaintiff completed” so anyone can read the status without opening the file.
Too few columns and people keep opening the physical file for basic information. Too many and nobody updates the sheet. The list above is the balance point for most litigation practices.
Deadline Columns That Prevent Malpractice
Deadlines are where the spreadsheet earns its keep. A single missed filing date can lead to court-ordered payment of the opposing party’s reasonable expenses and attorney’s fees, and in serious cases to stricken pleadings, dismissed claims, or default judgment.1Legal Information Institute. Federal Rules of Civil Procedure Rule 37 – Failure to Make Disclosures or to Cooperate in Discovery; Sanctions
Enter every date in YYYY-MM-DD format so the software sorts chronologically. Pull dates directly from the court’s scheduling order, which controls discovery cutoffs, dispositive motion deadlines, and the trial date.
Federal Deadline Math
Under federal rules, you skip the day the triggering event occurs, count every calendar day including weekends and holidays, and include the final day. If that final day lands on a Saturday, Sunday, or legal holiday, the deadline rolls to the next business day. The same roll applies when the clerk’s office is inaccessible on the last filing day. Electronic filings are due by midnight in the court’s time zone unless a local rule says otherwise.2Legal Information Institute. Federal Rules of Civil Procedure Rule 6 – Computing and Extending Time; Time for Motion Papers
One rule that trips people up: when a party is served by mail or by leaving documents with the clerk, three extra days get added to whatever the response period would otherwise be.2Legal Information Institute. Federal Rules of Civil Procedure Rule 6 – Computing and Extending Time; Time for Motion Papers State courts often calculate differently, so verify the applicable rule set before entering a computed deadline.
Statute of Limitations
The statute of limitations is the outer boundary for the case, and missing it kills the claim. Durations vary by case type and jurisdiction: personal injury claims carry a two-year deadline in most states, while breach of contract actions generally allow four to six years depending on whether the agreement was written or oral. The paralegal entering the date verifies the applicable statute for the specific jurisdiction and cause of action. Flag these dates with the highest priority color coding, because there is no procedural fix for a blown statute of limitations.
Discovery Request Tracker
Discovery produces more individual deadlines than any other phase, so give it its own section or tab. Under federal rules, a party has 30 days after being served to respond to interrogatories.3Legal Information Institute. Federal Rules of Civil Procedure Rule 33 – Interrogatories to Parties The same 30-day window applies to requests for production of documents.4Legal Information Institute. Federal Rules of Civil Procedure Rule 34 – Producing Documents, Electronically Stored Information, and Tangible Things, or Entering onto Land, for Inspection and Other Purposes Written agreement between parties or a court order can modify either deadline, so check for stipulations before entering a date.
For each request, track the type (interrogatories, document production, requests for admission), date served, calculated response due date, who is preparing the response, and the current status. Mirror the same fields for discovery your firm has sent out, so you can follow up when the other side blows a deadline. A “days remaining” formula that subtracts today’s date from the due date makes overdue items jump off the screen.
Conflict Check Columns
The spreadsheet doubles as the firm’s first line of defense against conflicts of interest. Professional responsibility rules require every firm to adopt reasonable procedures for identifying conflicts before taking on new work, and a lawyer cannot use ignorance as an excuse for a violation.5American Bar Association. ABA Model Rules of Professional Conduct Rule 1.7 – Conflict of Interest Current Clients
Structure the sheet so you can search across all current and former clients, opposing parties, and related parties like co-defendants or corporate affiliates. When a potential new client calls, run those names against the full history. Keep a column noting the outcome of each check and the date it was performed. If a conflict question surfaces later in litigation or in a bar complaint, that documentation protects the firm.
Trust Account Ledger Tab
A separate ledger tab tracks client trust activity. Professional responsibility rules require lawyers to keep complete records of all client funds held in trust and to preserve those records for five years after the representation ends.6American Bar Association. ABA Model Rules of Professional Conduct Rule 1.15 – Safekeeping Property Fees paid in advance sit in the trust account until earned, and every deposit and withdrawal needs documentation.
Link the ledger tab to the main case tracker and capture, for each transaction, the client name, matter number, date, a description of the deposit or disbursement, and a running balance. Reconcile against the bank statement on a regular schedule. Trust account rules differ by jurisdiction, but recordkeeping that ties each dollar to a specific client matter is required everywhere.
Closed-File Retention Columns
Closed cases keep generating obligations. Add a “closed date” column, a “retention deadline” column, and a “disposition” column with values like “retained,” “returned to client,” or “destroyed on [date].” The professional responsibility rules do not set a single national retention period, but most jurisdictions require or recommend holding client files for a set number of years after the matter concludes, with many setting five to seven years through court rules or ethics opinions. Files involving minors typically must be held longer, at least until the client reaches the age of majority plus the applicable statute of limitations.
When the retention period expires, log the destruction: what was destroyed, when, how, and by whom. That record answers any later inquiry from the former client without forcing the firm to keep the underlying files indefinitely.
Formatting That Keeps People Using It
Technical layout decides whether the team uses the spreadsheet or quietly starts keeping notes on the side.
Freeze Panes and Tab Structure
Freeze the header row so column labels stay visible when you scroll through hundreds of entries. Split tabs by status at minimum: active litigation, active transactional matters, closed files. Firms with multiple practice areas often split further, keeping family law separate from commercial litigation. Any team member should find a case within a few seconds.
Conditional Formatting and Data Validation
Program cells to change color based on how close a deadline is. A common setup turns a cell red within 48 hours and yellow within seven days. Anyone opening the sheet sees what needs attention today.
Data validation matters just as much. Drop-down menus for case type, current phase, and assigned attorney prevent the inconsistencies that make filtering useless. If one person types “discovery,” another types “disc.,” and a third types “Discovery Phase,” the spreadsheet cannot produce a reliable filtered view. Lock these fields to a controlled list from the start.
UTBMS Billing Codes
If your firm tracks billable time alongside case status, add a column for standardized task codes. The Uniform Task-Based Management System, UTBMS, pairs a letter with a three-digit number. For litigation, L100-level codes cover case assessment, L200 covers pre-trial pleadings and motions, L300 covers discovery, L400 covers trial preparation, and L500 covers appeals. Separate code sets exist for counseling, bankruptcy, and intellectual property work. Including codes in the sheet lets the firm produce time and cost breakdowns by phase, which many corporate clients and insurers now require.
Keeping It Current and Secure
A spreadsheet a week behind reality is worse than no spreadsheet, because the team will trust stale information. Update the entry immediately after any significant event. When a proof of service is filed, an order arrives, or discovery responses go out, the sheet should reflect that activity in the same work session.
Schedule a weekly audit comparing the deadline columns against each active case’s electronic docket. The court docket is the official record, and electronic docket data can lag filings by a day or more. Catching a discrepancy during a routine audit is a minor correction; catching it the day before a deadline is a crisis.
Every row contains privileged and confidential client information, and professional responsibility rules require lawyers to make reasonable efforts to prevent unauthorized access.7American Bar Association. ABA Model Rules of Professional Conduct Rule 1.6 – Confidentiality of Information Store the file on an encrypted server or professional cloud platform with access controls, not on someone’s desktop or an unencrypted USB drive. Restrict editing permissions to authorized personnel. If you use Google Sheets, share with specific firm email addresses rather than an open link. Version history in cloud platforms gives you an automatic audit trail of who changed what and when.
When to Move Off a Spreadsheet
Spreadsheets work for solo practitioners and small firms with manageable caseloads. They have real limits as the practice grows. They don’t send automated deadline reminders, so someone still has to open the file and look. They don’t create audit trails unless you use a cloud platform with version history. They can’t produce court-ready reports or integrate with document management and billing systems on their own. And when two people edit the same Excel file on a shared drive at once, data gets overwritten.
Dedicated case management software addresses those gaps with automated alerts, role-based access, and built-in integrations, at the cost of licensing and setup time. For a firm handling fewer than 50 active matters, a well-maintained spreadsheet is often the more practical choice. For larger caseloads, the spreadsheet can bridge the gap while the firm evaluates purpose-built software. The columns and tabs described above carry over either way. The tool changes; the information it captures does not.