How to Log Attorney Billable Hours in a Spreadsheet

Unbilled time is the silent leak in small firms — work happens, clients get results, invoices go out late or never. A free billable hours log spreadsheet tracks matters, time entries, rates, and invoiced amounts with billed vs. unbilled roll-ups.

Time entry discipline

Log when you switch tasks, not at 6 p.m. from memory:

1. Matter and client
2. Date
3. Description — enough detail for fee review and ethics audits
4. Hours
5. Rate — from matter table or default
6. Billed? flag when included on an invoice

Filter unbilled by matter before month-end billing meeting.

Realization starts with capture

You cannot improve realization without knowing unbilled WIP. Firms also tracking client engagements at scale pair this log with WIP and billing tracker roll-ups per client.

This is not trust accounting

The sheet supports hour capture and invoice preparation — not IOLTA trust ledgers, client fund segregation, or compliance reporting. Use certified trust accounting tools where required by your jurisdiction.

When practice management software wins

E-billing, trust accounting, calendaring, and document management integrate at firm scale. Solo practitioners and micro-firms often bill from a sheet until unbilled WIP exceeds a comfortable threshold.

These templates are operational time logs, not legal advice. Billing practices must comply with state bar rules and client agreements.