Law Firm Invoice Template: Matter Codes, Fee Earners, and Client-Ready Statements

A law firm invoice template has to solve a harder problem than a solo attorney's bill: more than one fee earner, more than one matter per client, and a client-ready statement that rolls all of it up without losing the line-level detail an audit might need. Hub: Legal Invoice Template Excel: Bill Matters, Time Entries, and Client Fees.

Key takeaway: A firm-level invoice template needs a fee-earner rate table with multiple roles, a matter code system that survives dozens of open cases, and a client statement layout that groups time entries by matter without hiding any individual line.

Hub: legal invoice template excel

Fee earners, not one flat rate

Where the pillar covers the timekeeper concept generally, a firm needs a real rate table: partner, associate, paralegal, and sometimes a paid intern or contract attorney, each with a distinct hourly rate. Some firms also vary a fee earner's rate by matter type (a specialty practice area billed higher than routine work).

Fee-earner rate table example

Fee earner	Role	Typical rate range	Notes
Partner	Senior attorney	Highest tier	Often reviews and signs off on strategy
Associate	Attorney	Mid tier	Bulk of drafting and research hours
Paralegal	Support	Lower tier	Document prep, filing coordination
Contract attorney	Attorney (temporary)	Varies by engagement	Track separately for margin visibility

Keep the rate table on its own sheet or a locked header block, and pull each time entry's rate with a lookup formula against the fee earner's name — not by retyping the number on every row. That single habit prevents the most common firm-billing error: a rate change that only updates some of the entries.

Matter codes that scale past a handful of cases

A solo practice can get away with a plain matter name. A firm juggling dozens of open matters needs a matter code: a short alphanumeric identifier (client number + matter sequence, for example) that every time entry, cost line, and invoice references.

Set up a matter code system

Assign each client a short client code (initials, number, or abbreviated name).
Assign each matter under that client a sequential number (client code + matter number, e.g. SMITH-002).
Reference the matter code — not the free-text matter name — in every time entry and cost row.
Keep a Matters lookup sheet: matter code, matter name, client, responsible fee earner, status (open/closed).
Filter time entries by matter code to produce a single-matter statement in seconds.

Warning: Never let two open matters share a matter code, even temporarily. A single duplicate code can merge two clients' time entries on one statement, which is both a billing error and a confidentiality problem.

Client-ready statements across multiple matters

Some clients — a business with ongoing outside counsel, for example — receive one statement covering several matters in a single billing period. The statement needs to:

Group time entries and costs by matter code, with a matter subtotal.
Show a grand total across all matters on that statement.
Preserve enough line-level detail (date, fee earner, task, hours) that the client can still audit any one matter without requesting a separate report.

[TABLE: Multi-matter statement layout]

Section	Contents
Matter A subtotal	Time entries + costs for Matter A, subtotal line
Matter B subtotal	Time entries + costs for Matter B, subtotal line
Grand total	Sum of all matter subtotals for the statement period
Retainer/trust summary	Balances relevant to matters funded from trust, if any

A pivot table or a well-built SUMIFS formula set against matter code handles this cleanly once the time-entry log uses consistent matter codes and fee-earner names.

Free tools and practice software don't quite fit here

Generic invoice tools like InvoiceSimple or Wave Apps have no concept of a matter code or a fee-earner table, so a firm would be rebuilding structure from scratch inside a tool that was not designed for it. On the other end, practice-management platforms such as MyCase bundle billing with case management, trust accounting, and client communication — powerful, but more system than a small firm managing a modest matter count may need or want to pay for monthly.

A structured Excel workbook such as PlanoNest's Billing Invoice for Legal Services template sits in between: fee-earner table, matter fields, and time-entry log already structured, extendable with formulas for multi-matter statements. One-time purchase, instant download; current pricing on the product page.

[PRO_CON]

Practice-management software (MyCase-style)

Pros: billing + case management + trust accounting in one system
Cons: monthly subscription; more setup than a small firm may need

Structured Excel workbook

Pros: fee-earner table and matter fields ready; one-time purchase
Cons: no built-in case management; multi-matter statements need formula work

Product highlight: Firms that skip a matter-code system usually notice the cost only after the third or fourth open matter — by then, retrofitting codes onto months of untagged time entries is the slow part, not adding the column itself.

Extra billing notes worth keeping

Keep a short "billing conventions" note inside the workbook — even one sheet tab — so a new paralegal or a covering associate does not guess whether hours round up, round to the nearest tenth, or round down at the six-minute mark. The same note should say whether costs are billed at actual receipt amount or at a small handling markup, since firm policy and some state bar guidance on cost billing can differ from firm to firm.

If a client asks for a breakdown mid-matter, you should be able to filter the time-entry log by matter code and date range and hand over a partial statement in minutes, not re-build the invoice from memory. That single capability is often the real difference between a workbook that survives client audits and one that generates a dispute call weeks later.

Handling rate changes without breaking old invoices

Rates change — a paralegal is promoted, an associate's hourly rate goes up at the new fiscal year, or a firm adjusts pricing for a practice area. When that happens, never edit the rate table in a way that silently changes the amount on invoices you already sent. Instead, keep prior invoices as flattened copies (values, not live formulas) once they are finalized, and only let the live rate table affect new, unbilled time entries going forward.

A simple habit that prevents this problem: once an invoice is sent, save a static copy (PDF or a values-only worksheet snapshot) before touching the rate table again. That way a rate correction next quarter cannot retroactively change what a client was already billed and already paid.

A short note on trust and retainer accounting

Trust and retainer accounting (IOLTA and similar client-fund rules in many jurisdictions) carries real record-keeping obligations that a spreadsheet alone does not automatically satisfy. A well-built Excel workbook can display a retainer's opening balance, the amount applied on a given invoice, and the balance remaining — and that visibility is genuinely useful to both the firm and the client. It is not, by itself, a substitute for your bar's specific trust-accounting requirements or for dedicated trust-accounting software once a practice's volume or jurisdictional rules call for it. When in doubt, confirm with your bar association or an accountant familiar with legal trust rules in your state.

Disclosure

PlanoNest sells this template. Links to PlanoNest products and collections point to our own digital template shop.

Frequently Asked Questions

What is a matter code and why does a law firm need one?

A matter code is a short identifier tying every time entry and cost to a specific case or engagement. Firms with more than a handful of open matters need it to avoid mixing clients' time entries and to build accurate statements quickly.

How should a firm handle different billing rates for partners, associates, and paralegals?

Keep a fee-earner rate table with each role's rate, and have every time entry pull its rate from that table by name — never retype the rate on each row, or a rate change will not apply consistently.

Can one invoice cover multiple matters for the same client?

Yes, as long as the statement groups entries by matter code with a subtotal per matter before the grand total, so the client can still audit any single matter's detail.