Attorney Invoice Template Excel: Fees, Costs, and Matter Detail Clients Expect

Search attorney invoice template excel and most results are generic invoice generators with "attorney" swapped into a placeholder field. A real attorney invoice has to do more work: it has to separate professional fees from reimbursed costs, show the hours behind the fee total, and — when the client has a retainer on file — show exactly how much of that retainer this bill draws down. Hub: Legal Invoice Template Excel: Bill Matters, Time Entries, and Client Fees.

Key takeaway: An attorney invoice earns client trust when fees (time × rate) and costs (out-of-pocket expenses) sit in clearly separate sections, every fee line traces back to a dated time entry, and any retainer balance is shown before and after the bill.

Hub: legal invoice template excel

The three blocks a client expects to see

[TABLE: Attorney invoice structure]

Block	Contents	Why clients look here first
Header	Matter number, matter name, client, invoice #, statement period	Confirms which case this bill covers
Fees	Dated time entries: timekeeper, task, hours, rate, amount	Proves the hours match the description
Costs / disbursements	Filing fees, courier, expert witness, transcripts, travel	Shows what was reimbursed, not billed as time

A retainer line — funds held, amount applied this period, balance remaining — belongs either at the bottom of the fees block or in its own small summary box near the total. Do not bury it inside a general "notes" cell; clients specifically scan for that number.

Fees vs costs: keep the line clean

The pillar covers why this split matters at a cluster level. In practice, the rule is simple: if a human's billable time produced the line, it is a fee. If money left the firm's pocket for something external — a court filing fee, a process server, a deposition transcript, printing and binding for a filing — it is a cost or disbursement.

Many jurisdictions have guidance on whether costs can carry a markup or must be passed through at the amount actually paid; check your bar's rules rather than assuming either convention. Whatever your policy, state it once (in engagement letters or a workbook note) and apply it consistently so every invoice looks the same to a returning client.

[TABLE: Fee vs cost examples]

Item	Fee or cost	Notes
2.4 hours drafting a motion	Fee	Timekeeper hours × rate
Court filing fee	Cost	Pass through at actual amount unless firm policy states otherwise
Deposition transcript	Cost	Often billed at invoice amount from the court reporter
Paralegal research time	Fee	Different rate than attorney time
Courier / process server	Cost	Reimbursed expense, not time
Travel time to a hearing	Fee (often at a reduced rate)	Firm policy should state the rate used

Building the sheet without breaking the math

Set up an attorney invoice in Excel

Header block: matter number, matter name, client name and address, invoice number, statement date range.
Timekeeper table: name, role, hourly rate — even for a solo practice, this documents the rate for the record.
Time-entry rows: date, timekeeper, task description, hours (decimal, not free text), rate (pulled from the timekeeper table), amount = hours × rate.
Fees subtotal formula summing the amount column.
Costs section: date, description, amount — summed separately from fees.
Retainer box (if applicable): opening balance, amount applied this invoice, closing balance.
Grand total = fees subtotal + costs subtotal − retainer applied (if the retainer is paying this bill directly rather than being tracked separately).

Warning: Never let a single "Amount" column blend hourly fees and reimbursed costs. The moment those are mixed, a client's bookkeeper cannot verify either number, and disputes take far longer to resolve than they should.

Where free tools fall short

Wave Apps and InvoiceSimple both generate a clean-looking PDF fast — useful for a flat-fee engagement with no hourly component and no trust accounting involved. Neither has a native concept of timekeeper rates, matter numbers, or a fees-versus-costs split; you would be building all of that inside their line-item fields, which quickly turns into a workaround rather than a proper structure. Purpose-built practice tools like MyCase or LawPay handle this natively but come with a subscription and more setup than a solo attorney billing a handful of matters usually needs.

A structured workbook such as the Billing Invoice for Legal Services template keeps the matter fields, timekeeper table, and costs section pre-built — one-time purchase, instant download, current pricing on the product page. It opens in Excel, Google Sheets, or WPS.

[PRO_CON]

Generic invoice tool (Wave Apps, InvoiceSimple)

Pros: fast, free tier, polished PDF output
Cons: no matter field, no timekeeper rate table, no fees/costs split

Structured legal invoice workbook

Pros: matter number, timekeeper table, and costs section already built
Cons: paid workbook (price on product page); still requires manual time entry

Product highlight: Most billing disputes on attorney invoices trace back to one of two causes: a lump-sum fee line with no supporting time entries, or a cost that was quietly billed at a marked-up amount without disclosure.

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 the difference between fees and costs on an attorney invoice?

Fees are professional time billed at a timekeeper's rate. Costs (or disbursements) are out-of-pocket expenses like filing fees, transcripts, or courier charges. Keep them on separate lines so a client can verify each independently.

Should an attorney invoice show the retainer balance?

Yes, whenever a retainer or trust account funds the matter. Show the balance before this invoice, the amount applied, and the balance remaining — clients specifically look for that number.

Can I use a general invoice template for attorney billing?

Only for simple flat-fee work with no hourly component and no trust activity. Once time entries, multiple timekeepers, or costs enter the picture, a generic invoice template will not hold the detail a client — or a fee dispute — will ask for.