Stackrows
Law Firm Invoice Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Invoice
Invoice Log
Client & Matter List
Fee Schedule
Trust Account Ledger

Law Firm Invoice Template

Bill clients accurately for hourly, flat fee, and retainer matters — with timekeeper billing rates, matter numbers, trust account tracking, and a full invoice log.

$29Save 4+ hours vs. building a legal billing spreadsheet from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx230 KB5 sheetsUpdated 2026-03-22

What's Inside This Law Firm Invoice Template

This template includes 5 worksheets, each designed for a specific part of your law firm financial workflow:

1

Invoice

The printable invoice sheet used for each client billing. It's structured with your firm's header (name, address, bar number placeholder), a Client & Matter section capturing the client name, matter name, matter number, and billing period — all required fields on legal invoices. The time entries table lists each entry with the timekeeper's initials, service date, activity description, hours billed, and rate per hour; the extended amount calculates automatically. A separate flat fee section handles fixed-fee matters or unbundled services. The totals block accounts for prior balance, new charges, payments received from trust, and the resulting amount due. Payment instructions and trust account details are editable at the bottom.

2

Invoice Log

A running register of every invoice issued across all clients and matters. Each row records the invoice number, client name, matter name, matter number, invoice date, due date, amount billed, amount paid, and current status (Paid, Outstanding, Overdue, Disputed). The sheet calculates total billed YTD, total collected, total written off, and total outstanding automatically. Conditional formatting flags overdue invoices in red and disputed amounts in yellow. For firms managing multiple active matters across multiple clients, this sheet gives you a real-time view of your AR balance and highlights follow-up priorities without combing through individual invoices.

3

Client & Matter List

A directory of clients and their associated matters that feeds the Invoice sheet via dropdown selection. For each client you store the billing contact name, billing address, email, billing rate type (hourly vs. flat fee), default payment terms, and any special billing instructions (such as required purchase order numbers, e-billing platform requirements, or client-imposed billing guidelines). Each matter is listed separately with its own matter number, practice area, responsible attorney, originating attorney, and billing status (active or closed). Selecting a client from the Invoice dropdown auto-populates the Bill To fields, reducing data entry errors and ensuring every invoice carries the correct matter reference.

4

Fee Schedule

A lookup table of billing rates organized by timekeeper level and name. List each attorney (partner, associate, of counsel), paralegal, and legal assistant with their standard hourly rate and any client-specific rate overrides. The Invoice sheet references this table via dropdown, so selecting a timekeeper auto-fills their billing rate — preventing the billing errors that happen when rates are typed manually across dozens of invoices. The fee schedule also documents historical rates by effective date, which is important for matters that span a rate increase cycle and for responding to client audits of billing records.

5

Trust Account Ledger

A dedicated ledger for tracking IOLTA (interest on lawyer trust account) activity by client. Each row records the transaction date, client name, matter number, transaction type (deposit, disbursement, or transfer to operating account), description, and running balance per client. The ledger maintains individual client balances and a combined trust account total — both required for state bar trust accounting compliance. At invoice time, this sheet tells you exactly how much trust balance a client has available, so you can apply it correctly to the invoice. Keeping trust accounting inside the same workbook as your invoice log eliminates the reconciliation step most small firms currently do manually.

Law Firm Invoice Template Features

  • Time entry billing with timekeeper, date, activity description, hours, and rate per line
  • Matter number and billing period fields required on every legal invoice
  • Fee schedule lookup by timekeeper level with client-specific rate override support
  • Trust account (IOLTA) ledger with per-client running balances
  • Invoice log tracking Paid, Outstanding, Overdue, and Disputed status across all matters
  • Client & matter directory with billing contact, terms, and e-billing platform notes

How to Use This Law Firm Billing Spreadsheet

Setup takes about 30 minutes. Download the .xlsx file and open it in Excel or Google Sheets. Start with the Client & Matter List sheet — add each active client and their open matters. Enter billing contact details, payment terms, and any billing instructions specific to that client (some corporate clients require e-billing through a third-party platform; note that here so it's visible at invoice time). Then move to the Fee Schedule sheet and enter each timekeeper with their current billing rate. Once those two sheets are populated, creating each invoice takes under 10 minutes.

To create an invoice, go to the Invoice sheet and select the client and matter from the dropdowns. Set the billing period and invoice number (use a consistent format such as INV-2026-0042). In the time entries table, enter each time entry: select the timekeeper from the dropdown (which auto-fills their rate), enter the date, hours, and a clear activity description. Add any flat fee charges in the flat fee section if applicable. Review the trust balance in the Trust Account Ledger and, if the client has funds available to apply, enter the trust payment amount in the totals block. Print or export to PDF.

After sending each invoice, log it in the Invoice Log — enter the invoice date, due date, amount, and set the status to Outstanding. Update to Paid when funds clear, or to Overdue after the due date passes. For trust account activity, record every deposit and disbursement in the Trust Account Ledger immediately — state bar rules in most jurisdictions require trust accounts to be reconciled monthly, and doing it as you go is far simpler than reconstructing transactions at month-end. Firms that treat the Invoice Log as a weekly review item — checking outstanding balances and flagging anything past 30 days — consistently see shorter collection cycles than those who invoice and wait.

Send your next invoice in under 10 minutes

Set up your matter list and fee schedule once, then create any invoice in minutes — with timekeeper billing, trust account tracking, and a full log of outstanding balances.

Why Law Firms Need a Structured Invoice Template

Law firms bill differently from almost every other professional services business, and generic invoice templates fail them for a predictable reason: they don't account for matter-based billing. Every legal invoice needs to be tied to a specific matter with its own number — not just a client — because a single client may have five active matters with different billing arrangements, different responsible attorneys, and different billing rates. Invoicing without matter numbers creates confusion for clients, makes AR tracking nearly impossible, and can create compliance issues with state bar billing requirements.

The financial structure of a law firm invoice reflects how legal fees actually get earned. Time entries need a timekeeper identifier (so clients can see whether they're paying partner rates or associate rates for each task), a date, a narrative description, hours, and a billing rate — not just a dollar amount. Flat fee matters need their own section because they aren't billed by the hour but still need a matter reference and clear description. Trust account applications need to be reflected on the invoice face with the correct balance available — because clients receiving a bill that shows trust funds on deposit expect to see those applied before the net amount due is calculated.

Collection is the part of law firm finance that most attorneys underweight until it becomes a problem. The average law firm realization rate — the percentage of invoiced fees that actually gets collected — runs between 85% and 92% for well-managed firms, and significantly lower for firms without structured follow-up processes. The Invoice Log in this template is designed to support that follow-up: it shows outstanding balance by matter and by client, flags invoices that have crossed the due date, and tracks disputed amounts separately. Firms that review their AR weekly and follow up within five days of a missed due date consistently collect more and at faster cycles than those waiting until month-end to notice what's overdue.

Law Firm Industry at a Glance

Financial templates built for law firms and legal practices — from solo practitioners to mid-size firms. Pre-loaded with billing rate structures, matter tracking, and trust account categories.

Revenue Drivers

  • Billable hours (hourly engagements)
  • Flat fee matters
  • Retainer agreements
  • Contingency fee recoveries

Key Cost Categories

  • Attorney compensation & draws
  • Paralegal & staff salaries
  • Malpractice insurance
  • Legal research subscriptions (Westlaw, LexisNexis)
  • Office rent & overhead
  • Bar dues, CLE & licensing

Typical Margins

Gross: 40-60% · Net: 15-35%

Seasonality

Q4 typically busiest for transactional and corporate practices (year-end deals); litigation practices are more event-driven. January is slower across most practice areas.

Key Performance Indicators

Billable hours per attorneyRealization rateCollection rateMatter profitabilityUtilization rate

Law Firm Invoice Template FAQ

Law Firm Invoice Template

$29