Financial firms

A sample fee-billing read

This is the kind of written read an investment adviser gets back, run here on synthetic files: one billing export against the debit files from two fictional custodians for 2026 Q3. Every number below comes from the reconciliation engine, unedited.

Fee-billing read, 2026 Q3, synthetic data

Status: complete (both custodians reconciled)
Conservation: balanced

Billed is what the billing export says should be debited. Debited is what the custodian files show was taken. The difference is debited minus billed. A difference is a lead to investigate, not a confirmed error.

Summary by custodian

CustodianBilledDebitedDebited minus billedMatchedValue breaksBilled, not debitedDebited, not billedDuplicate keys
Harbor Custody (synthetic)114,615.00111,280.00-3,335.00222111
Summit Trust Custody (synthetic)89,915.6284,468.75-5,446.87181110
Total204,530.62195,748.75-8,781.87403221

Counts are accounts. Billed, not debited: in the billing export, absent from the custodian debits. Debited, not billed: the reverse. Duplicate keys: an account that appears more than once on either side.

Exceptions

AccountCustodianClassBilledDebitedDebited minus billedDetail
HC-20531Harbor Custodyduplicate key1,425.002,850.00+1,425.001 billed row and 2 debit rows share this account; no single pairing is correct
HC20999Harbor Custodydebited, not billed0.00412.50+412.50debited at the custodian, and no bill appears in the billing export
ST20888Summit Trust Custodydebited, not billed0.001,175.00+1,175.00debited at the custodian, and no bill appears in the billing export
HC-20556Harbor Custodybilled, not debited5,355.000.00-5,355.00billed, and no debit appears at the custodian
ST-20417Summit Trust Custodybilled, not debited6,746.880.00-6,746.88billed, and no debit appears at the custodian
HC-20422Harbor Custodyvalue break6,916.887,116.88+200.00debited 7,116.88 against billed 6,916.88
HC-20477Harbor Custodyvalue break5,270.005,252.50-17.50debited 5,252.50 against billed 5,270.00
ST-20439Summit Trust Custodyvalue break6,906.257,031.25+125.00debited 7,031.25 against billed 6,906.25

Conservation

46 left = 40 matched + 3 value_break + 2 missing_right + 1 duplicate_left
47 right = 40 matched + 3 value_break + 2 missing_left + 2 duplicate_right
Every row on both sides is in exactly one class. Result: balanced.

What this read covers

  • That the fee the billing system says it charged is the fee the custodian actually debited, account by account.
  • Accounts debited but never billed, billed but never debited, and debited twice.
  • Account numbers written differently by the two systems (for example HC-20417 and HC20417) are paired exactly after ignoring case, spaces, hyphens, underscores, dots and slashes. Nothing is matched by similarity.

What this read does not cover

  • Whether the billed fee was right. It does not recalculate fees from advisory agreements, fee schedules, breakpoints, householding or account valuations.
  • Refunds of prepaid fees on closed accounts, and pro-rating for new accounts. These need account open and close dates, which this read does not take.
  • Whether an unmatched account is an error. A person decides what each difference means and what to do about it.

Method and limits

Account keys are the custodian plus the account number. A difference of 0.01 or less counts as matched. Amounts are USD and compared as exact decimals. One billing period, one billing export and one set of custodian debit files. The firm, custodians, accounts and amounts are fictional.

Generated by the reconciliation engine at commit 90328d4 from synthetic fixtures. The firm, custodians, accounts and amounts are fictional.

Get this read on your own files.

Send one quarter's billing export and the custodian debit files for the same period. A written read comes back, under a mutual NDA, at a fixed price of $2,500 to $4,000.

Book a call