Law Firm Billing Tracker Excel for your practice — matter rates, time entries and invoices, trust and retainer tracking, and a monthly P and L dashboard. Know what every matter actually billed, what every hour actually…
About this template
Law Firm Billing Tracker Excel for your practice — matter rates, time entries and invoices, trust and retainer tracking, and a monthly P and L dashboard. Know what every matter actually billed, what every hour actually made, and which retainer is already used up. Built for attorneys, solo practitioners, and small law firms who need to know, matter by matter and timekeeper by timekeeper, whether the hourly rate covers the filing fees, the expert, and the associate — without accounting software. If a matter has billed past its retainer, this workbook shows it before the next time entry.
$49
Excel & Google Sheets template — instant download on Etsy
Matters and Billing Rates — matter, client, practice area, hourly rate, hours, fees billed, direct costs, profit, margin percent, and cost per hour for every matter. Change a rate and every time entry reprices by formula.
Time Entries and Invoices — date, client, timekeeper, matter, hours, hourly rate, fees billed, cost per hour pulled from the matter sheet, profit per entry, and margin. Log partner, associate, and paralegal time in one place.
Trust and Retainers — client, matter, retainer received, fees billed, retainer applied, trust balance, and outstanding invoices. Fees billed are formulas from the Time Entries sheet; enter each client's retainer received and the rest fills in.
Monthly P and L — revenue, direct costs, associate pay, rent, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and direct costs are formulas from the Time Entries sheet.
Dashboard — total revenue, time entries, hours billed, average fee per entry, gross and net profit and margin, best matter by margin dollars and by margin percent, most-billed matter, best entry and best timekeeper, costs by category, total retainers, trust balance, outstanding invoices, and realization rate.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Law Firm Billing & Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Law Firm Billing & Profit Tracker track?
The Law Firm Billing & Profit Tracker tracks Matters and Billing Rates; Time Entries and Invoices; Trust and Retainers; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total fees billed 42,650 from 20 time entries and 126 hours billed; average fee per entry 2,132.50.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.