Law Firm Balance Sheet Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Balance Sheet sheet and review the pre-loaded line items. Most of the asset and liability categories will match your firm's chart of accounts with minimal changes. The main adjustments are usually in the equity section: update the partner capital account names to match your actual partner structure, and if your firm tracks draws separately from capital, the template handles both formats.

Enter your current figures starting from cash and working down through the asset section. The trust account balance should match your IOLTA reconciliation — use the Trust Account Reconciliation sheet to confirm the figure before entering it. Work-in-progress should reflect unbilled time valued at your standard billing rates. On the liabilities side, the trust account liability line must equal your trust asset balance; the template links these cells automatically so they stay in sync. Once you've entered all figures, the balance check cell at the bottom confirms your statement is in balance.

Use the Period Comparison sheet whenever you're preparing financials for a bank, outside counsel review, or partner meeting. Enter the prior-period figures and the sheet calculates variances automatically. Most managing partners run this quarterly — it takes about 30 minutes once your current balance sheet is updated — and it's the fastest way to track whether receivables are growing faster than collections, which is the most common early warning sign for law firm cash flow problems.

Law firm balance sheets have structural features that generic templates handle badly. The most significant is the trust account: client funds held in escrow or retainer must appear on the balance sheet as both a current asset (the cash your firm is holding) and an equal current liability (the obligation to disburse those funds). Most accounting templates treat the trust account as just a bank account, which understates both assets and liabilities and creates reconciliation headaches. For firms with active transactional or family law practices, the trust balance can represent a substantial portion of total assets — and it must be reconcilable to the client ledger at all times.

Work-in-progress is another line item that distinguishes legal practices from most businesses. WIP represents time your attorneys have worked but not yet billed. For firms on a cash basis, WIP doesn't appear on the balance sheet at all — but for accrual-basis firms (which most mid-size practices use), WIP is a current asset valued at billing rates. Tracking it separately from accounts receivable is important because it has different collection risk. Billed and unpaid invoices are receivables; unbilled time is WIP. The ratio of WIP to total outstanding billings tells you whether your billing cadence is keeping pace with work being done. Firms that let WIP accumulate for more than 30–60 days typically collect less of it.

The equity section of a law firm balance sheet reflects whatever entity structure the firm uses — partner capital accounts in partnerships and LLPs, owner's equity in sole practices, retained earnings and paid-in capital in professional corporations. For partnerships, the balance sheet is often used to track partner capital account balances and draws, which feed directly into K-1 calculations at year end. Using a consistent balance sheet format every quarter makes that process significantly less painful than reconstructing equity movements from bank statements at tax time.