Legal Invoice Template — Excel

Every law firm that doesn't pay for billing software runs on an Excel invoice. The spreadsheet handles the math that the rules demand — hours × rate with tenths-of-hour precision, fee subtotals versus cost subtotals, and retainer balances that decrement as work gets done. Enter time entries, let the formulas resolve the rest.

Create Your Excel Invoice — Free

Why Excel for Lawyers & Law Firms

Tenths-of-hour arithmetic without rounding errors

A cell formatted as =C2*D2 with two decimal places produces exact line totals for 0.3 hours at $450, 1.7 hours at $325, and everything in between. Hand-calculating across fifty time entries is where billing mistakes cost real money — formulas eliminate the drift.

Separate fee and cost subtotals via SUMIF

Use =SUMIF(B:B,"Fee",E:E) and =SUMIF(B:B,"Cost",E:E) to split attorney time from pass-through expenses. This mirrors how legal invoices are expected to read — fees, hard costs, soft costs, grand total — without manually re-tallying each section.

Matter-level pivoting for multi-matter clients

If one client has five active matters, a single sheet with a Matter column becomes a pivot table that rolls fees per matter. You produce a consolidated statement with per-matter subtotals in seconds rather than maintaining five separate workbooks.

CSV export feeds LEDES converters and e-billing portals

Excel data exports cleanly to CSV, which is the input format most LEDES 1998B converters expect. Keep your timekeeper IDs, UTBMS task codes, and matter numbers in dedicated columns and the export pipeline to Tymetrix or Passport becomes a one-step operation.

Invoicing Challenges for Lawyers & Law Firms

Billable Hours Tracking

Law firms bill in six-minute increments (tenths of an hour). A single missed entry or rounding error across hundreds of time entries per month can mean thousands in lost revenue or ethics complaints.

Trust Account Separation

Bar rules require strict separation of earned and unearned fees. Invoices must clearly show when funds are drawn from a client’s trust (IOLTA) account versus billed against earned fees, and errors can lead to disciplinary action.

LEDES Format Requirements

Many corporate clients and insurance companies require invoices in LEDES (Legal Electronic Data Exchange Standard) format. Submitting invoices in the wrong format means delayed payment and frustrated clients.

Legal Excel Invoicing Tips

★

Lock your rate-table cells with sheet protection before sharing

Select your timekeeper rate column, Format Cells > Protection > Locked, then Review > Protect Sheet with a password. A paralegal entering time can't accidentally type $350 when your rate is $385. Unprotect when you need to raise rates at year-end — a two-second safeguard against a recurring billing error.

Record Time Entries in Detail

Each time entry should include the date, timekeeper initials, time in tenths, and a specific description of the work performed. Block billing (lumping multiple tasks into one entry) is disfavored by courts and clients.

Show Trust Account Draws Clearly

When drawing from a client’s trust account, show the trust balance, the amount applied to the current invoice, and the remaining balance. This satisfies bar requirements and keeps the client informed.

Bill Retainers with Transparency

For evergreen retainers, show the retainer amount, fees applied against it this period, and the remaining balance. Replenishment triggers should be clear so the client knows when to top up.

Separate Fees from Costs

Legal invoices should clearly distinguish attorney fees from hard costs (filing fees, court reporters, expert witnesses) and soft costs (copies, postage). This level of detail is expected in legal billing.

What to Include on a Legal Excel Invoice

Matter name and file/case number
Timekeeper name, title, and billing rate
Detailed time entries (date, hours, description)
Attorney fees subtotal
Hard costs (filing fees, court reporters, experts)
Soft costs (copies, postage, research databases)
Trust account balance and amount applied
Payment terms and retainer replenishment threshold

Generate Your Legal Excel Invoice Now

Create Invoice — Free, No Sign-Up

Frequently Asked Questions

How do I format hours for six-minute billing in Excel?

Use a Number format with one decimal place (0.1 = six minutes, 0.2 = twelve minutes, etc.) rather than hh:mm time format. Time format makes math messy because Excel treats 1:30 as a fraction of a day. Decimal hours multiply cleanly against hourly rates and match how the legal industry reports time universally.

Can Excel produce a LEDES-compliant legal invoice directly?

Not natively — LEDES 1998B and 2.0 are pipe-delimited formats with specific field ordering. But your Excel data is the raw material. Export to CSV and feed it into a LEDES converter (Tymetrix, Bill4Time, or a custom script), or pay for legal billing software if you submit to ten-plus corporate clients monthly.

How should I track trust account balances alongside the invoice in Excel?

Add a separate tab named Trust with columns for Date, Deposit, Withdrawal, and Running Balance. On your invoice sheet, use =Trust!D99 (or similar) to pull the current balance into the invoice footer. The two tabs stay in sync and your client sees their remaining retainer without you re-entering the number.