Law Firm Finance: Cube vs Mosaic for Realization and Credit

Realization, collected fees divided by standard billing rate value of hours worked, drops for reasons that never show up in a timekeeping report: a partner writes down a bill to preserve a client relationship, a matter gets billed at a discounted flat fee that undershoots the actual hours, or a client disputes and negotiates an invoice down after the fact. None of that is visible until someone calculates realization by matter and compares it to standard rate value.

Cube lets you build that comparison directly in a spreadsheet tied to your time and billing system, matter by matter, so a partner's write-down pattern becomes visible rather than buried in a firm-wide average. Mosaic can hold the resulting numbers, but the write-down and discount logic itself has to be configured as a custom calculation, since it isn't a concept the platform's SaaS-oriented metrics were built around.

Review these sources of revenue leakage each month:

• Look for write-downs a partner made after the fact to preserve a client relationship, since these rarely appear in a timekeeping report.
• Compare flat-fee matters against the actual hours worked to see where the fee undershoots the effort delivered.
• Flag invoices a client disputed and negotiated down after they went out, and record the reason for each reduction.
• Track realization by matter, not only firm-wide, so one heavily discounted matter does not hide inside a healthy average.

A single matter often has one partner who brought in the client (origination credit) and a different attorney who actually did the billable work (working-attorney credit), and most compensation models split a percentage of the fee between the two. Modeling this correctly means every matter needs both credits tagged, not just a single responsible attorney field, or the compensation forecast will misattribute revenue.

Build this as a two-column tag on every matter in whichever tool you use: one for origination, one for working attorney, each with its own percentage split. Cube makes it straightforward to build compensation forecasts that pull directly from this split. Mosaic would need the split imported as structured data, since credit-splitting isn't a built-in concept in its metric library.

Billings and collections diverge in a law firm more than in most businesses, since a client can dispute a bill, request a payment plan, or simply pay late without much recourse beyond a strained relationship. A forecast built on billings alone will consistently overstate near-term cash.

Track a rolling collections rate by client type or practice group, and apply that rate to billings to get a realistic cash forecast rather than assuming billed equals collected. Either tool can hold this calculation, but you have to build the collections-rate assumption yourself in both cases, since it depends heavily on your specific client base.

Once a firm outgrows a partner or office manager tracking realization and collections informally, the next step is usually a controller or finance director who owns billing, collections, and compensation calculations full time. Nationally, accountants and auditors, a reasonable proxy for this kind of hire, earn a median wage near $84,000, with experienced candidates in major markets commanding well above $110,000¹.

That hire, more than the software choice, is usually what determines whether realization and origination-split reporting actually gets built and kept current rather than living in a partner's head.

A lateral partner arriving with an existing client book changes the compensation model immediately, since that partner typically brings origination credit on matters the firm didn't previously have any visibility into, along with a compensation guarantee that usually runs a fixed number of months regardless of actual billings during that period.

Build the guarantee as its own forecast line, separate from the standard origination and working-attorney compensation formula, since treating it as ordinary compensation will understate cost during the guarantee period and then show a confusing swing once the guarantee expires and normal formula-based compensation takes over. Track the lateral's actual originated billings from day one even during the guarantee period, so the firm has real data ready for the transition conversation before the guarantee runs out rather than negotiating from scratch.