Why billing
goes wrong.

Nobody leaves over a fee error. They leave over what the fee error tells them.

Billing is the quietest way to lose a client

Nobody leaves over a fee error. They leave over what the fee error tells them — that the firm they trusted with several hundred thousand dollars could not correctly calculate a number it has calculated ninety times before. The money is trivial. The inference is not.

The five ways it actually goes wrong

1. The schedule that lives in one person's head

Grandfathered rates, a break negotiated in 2019, a household where the daughter's account is billed differently for a reason that made sense at the time. None of it is in the system. It is in the memory of whoever set it up, and it is applied by hand every quarter.

This is the most common failure and the one that survives migrations, because nobody knows to migrate what nobody has written down.

2. Householding that does not match reality

Accounts grouped for billing in a way that no longer reflects the relationship — a divorce, a death, a trust that was restructured. The rate is right. The grouping is wrong. The invoice is wrong.

3. Timing mismatches

Average daily balance versus period-end. Billing in advance versus arrears. A transfer that lands on the wrong side of a boundary. Each of these is defensible individually; the problem is when the method in the system does not match the method described in the client agreement.

4. Reconciliation that happens after the money moves

Fees deducted, then checked. This works until it does not, and the failure mode is the worst one: correcting a client's account after they have already seen the debit.

5. The manual step nobody owns

Almost every firm has one — an export, a spreadsheet, a paste. It works because one person is careful. It fails the first quarter that person is on holiday.

Which of these are yours and which are structural

One, two and five are process problems. They can be fixed by writing things down, and a firm with the discipline to do that will fix them without changing anything else.

Three and four are usually structural. If billing runs on data exported from a system that traded the accounts, there is a gap, and reconciliation happens across it rather than within it. That gap is where timing and matching errors are born, and no amount of care closes it entirely — care only makes the errors rarer, which makes them harder to catch.

What good looks like

• Fee schedules held as data, with exceptions recorded as exceptions and visible to more than one person.
• The billing calculation running against the same records that hold the positions, so there is nothing to reconcile between.
• Reconciliation before the deduction, not after.
• An audit trail showing what was charged, on what basis, and what changed since last quarter.
• No manual step that depends on a single person being available.

The test

Pick your three most complicated households. Ask whoever runs billing to explain, without looking at the spreadsheet, exactly how each is charged and why. If they can, you have a documentation problem you can fix in an afternoon. If they cannot, you have a structural one, and it is worth knowing that now rather than during an examination.