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
| Custodian | Billed | Debited | Debited minus billed | Matched | Value breaks | Billed, not debited | Debited, not billed | Duplicate keys |
|---|---|---|---|---|---|---|---|---|
| Harbor Custody (synthetic) | 114,615.00 | 111,280.00 | -3,335.00 | 22 | 2 | 1 | 1 | 1 |
| Summit Trust Custody (synthetic) | 89,915.62 | 84,468.75 | -5,446.87 | 18 | 1 | 1 | 1 | 0 |
| Total | 204,530.62 | 195,748.75 | -8,781.87 | 40 | 3 | 2 | 2 | 1 |
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
| Account | Custodian | Class | Billed | Debited | Debited minus billed | Detail |
|---|---|---|---|---|---|---|
HC-20531 | Harbor Custody | duplicate key | 1,425.00 | 2,850.00 | +1,425.00 | 1 billed row and 2 debit rows share this account; no single pairing is correct |
HC20999 | Harbor Custody | debited, not billed | 0.00 | 412.50 | +412.50 | debited at the custodian, and no bill appears in the billing export |
ST20888 | Summit Trust Custody | debited, not billed | 0.00 | 1,175.00 | +1,175.00 | debited at the custodian, and no bill appears in the billing export |
HC-20556 | Harbor Custody | billed, not debited | 5,355.00 | 0.00 | -5,355.00 | billed, and no debit appears at the custodian |
ST-20417 | Summit Trust Custody | billed, not debited | 6,746.88 | 0.00 | -6,746.88 | billed, and no debit appears at the custodian |
HC-20422 | Harbor Custody | value break | 6,916.88 | 7,116.88 | +200.00 | debited 7,116.88 against billed 6,916.88 |
HC-20477 | Harbor Custody | value break | 5,270.00 | 5,252.50 | -17.50 | debited 5,252.50 against billed 5,270.00 |
ST-20439 | Summit Trust Custody | value break | 6,906.25 | 7,031.25 | +125.00 | debited 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-20417andHC20417) 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.