Daily client-asset reconciliation record (fictional sample data)
Fernhollow Digital Assets Ltd: Friday, 13 November 2026
1. Summary
The reconciliation found 1 difference outside tolerance. Each has a case, shown in section 4. Every non-zero position in the firm's records was covered by a comparison.
2. Sources and the two calculations
Client entitlement is calculated for each client from the firm's own records only. Holdings come only from external sources: the custodian's confirmation for assets held with a custodian, and chain data read from nodes separate from the firm's transaction systems for assets the firm holds itself. The configuration validator refuses a comparison whose two sides are the same source or system, are derived from each other, or are both chain data.
| Calculation | Source | As at | Detail | Positions |
|---|---|---|---|---|
| Holdings | Bitcoin chain (reconciliation node) System: recon-bitcoin-node | 13 Nov 2026, 16:58 | bitcoin block 922,163 | 13 |
| Holdings | Ethereum chain (reconciliation node) System: recon-ethereum-node | 13 Nov 2026, 16:59 | ethereum block 23,848,812 | 23 |
| Holdings | Kestrel Custody confirmation (daily statement) System: kestrel-custody | 13 Nov 2026, 17:00 | Statement KST-20261113 | 3 |
| Entitlement | Client ledger (firm records, daily export) System: fernhollow-ledger | 13 Nov 2026, 17:00 | Export 2026-11-13.csv, 83 rows | 83 |
3. Reconciliation: entitlement against holdings, per trust and asset class
Difference is entitlement minus holdings. A positive difference is a shortfall; a negative difference is an excess. Each token on each network is a separate asset class.
| Trust | Asset class | Holdings source | Entitlement | Holdings | Difference | Tolerance | Result |
|---|---|---|---|---|---|---|---|
| TA | BTC | Kestrel Custody confirmation | 77.10192377 | 77.10192377 | 0.00 | Exact | Matched |
| TA | ETH | Kestrel Custody confirmation | 1,014.779658221422 | 1,014.77965822 | 0.000000001422 | 0.00000001 | Within tolerance |
| TA | USDC | Kestrel Custody confirmation | 1,398,414.93 | 1,398,414.93 | 0.00 | Exact | Matched |
| TB | BTC | Bitcoin chain | 32.04113961 | 32.04113961 | 0.00 | Exact | Matched |
| TB | ETH | Ethereum chain | 193.51400732 | 193.51400732 | 0.00 | Exact | Matched |
| TB | USDC | Ethereum chain | 1,072,318.58 | 1,071,068.58 | 1,250.00 | Exact | Break |
Tolerances are set in the firm's configuration and apply only where stated: Trust A: entitlement v Kestrel Custody confirmation: 0.00000001 ETH. Basis: Reconciliation policy RP-3 s4.2 (fictional): the custodian reports ETH to 8 decimal places. All other lines must match exactly.
4. Breaks and cases
Open cases, and cases closed in the five business days to Fri 13 Nov. A shortfall must be made good within 24 hours; an excess must be removed before the next reconciliation. The system tracks these clocks and alerts; the firm decides and acts. A case cannot close without a recorded reason, a second approval by a different user, and a re-run.
Open
CASE-0002: shortfall of 1,250.00 USDC, Client Trust B (held by the firm on chain)
- 12 Nov 2026, 18:30SystemOpened by run RUN-2026-11-12-1: shortfall of 1,250.00 USDC (entitlement 1,072,318.58, holdings 1,071,068.58). Assigned to Joseph Mensah.
- 13 Nov 2026, 09:30Joseph MensahDifference traced to a Trust B address registered to client CL-1031: an outbound transfer of 1,250 USDC in the 12 Nov block range. No withdrawal in the ledger matches it. Asked operations for the instruction record.
- 13 Nov 2026, 14:05Joseph MensahOperations cannot yet match the transfer to an instruction. Raised with compliance. Treasury asked to confirm whether the firm will make good the shortfall from its own USDC.
- 13 Nov 2026, 18:30SystemEscalated to Maja Lindqvist: shortfall not made good: notification decision required. The shortfall was not resolved within the make-good window. The firm must decide on notifying affected clients and the FCA without delay. (CASS 17.5.13R and 17.5.15R)
- 13 Nov 2026, 18:30SystemScheduled run RUN-2026-11-13-1 for Fri 13 Nov: difference still 1,250.00 USDC.
Closed
CASE-0001: shortfall of 0.25 BTC, Client Trust A (held with Kestrel Custody)
- 10 Nov 2026, 18:30SystemOpened by run RUN-2026-11-10-1: shortfall of 0.25 BTC (entitlement 77.78515277, holdings 77.53515277). Assigned to Asha Patel.
- 11 Nov 2026, 09:40Asha PatelDifference traced to client CL-1007: a 0.25 BTC deposit booked in the ledger on 10 Nov. Kestrel confirms it settled at 17:42 (their ref KT-55120, fictional), after the 17:00 statement cut-off, and will reissue the 10 Nov confirmation.
- 11 Nov 2026, 11:10Asha PatelRevised statement KST-20261110-R1 received from Kestrel.
- 11 Nov 2026, 11:15Asha PatelProposed resolution (Timing difference): Timing difference at the custodian: the client deposit settled after the statement cut-off and appears on the revised 10 Nov confirmation. No ledger change and no shortfall to make good.
- 11 Nov 2026, 11:40Ruth OkaforSecond approval given: Checked the revised statement and the deposit record.
- 11 Nov 2026, 11:45SystemRe-run RUN-2026-11-10-2 for Tue 10 Nov: matched.
- 11 Nov 2026, 11:50Asha PatelClosed by Asha Patel, second approval by Ruth Okafor. Reason: Re-run on the revised custodian statement matches. Closed as a custodian timing difference.
5. Client entitlement calculation
Each client's entitlement by asset class at 13 Nov 2026, 17:00, from the firm's own records only (Client ledger (firm records, daily export)). 40 clients.
| Client | BTC | ETH | USDC |
|---|---|---|---|
| Client Trust A (held with Kestrel Custody) | |||
| CL-1001 | 2.85473773 | 12.482980237954 | - |
| CL-1002 | - | 82.456286153085 | - |
| CL-1003 | 10.24760232 | 0.731197 | 35,715.95 |
| CL-1004 | 6.90711896 | 104.73125710955 | - |
| CL-1005 | 5.94026077 | 63.93307737479 | - |
| CL-1006 | - | - | 214,721.77 |
| CL-1007 | 3.6682 | 121.33715914 | - |
| CL-1008 | 0.62357 | 81.446387644928 | 104,068.24 |
| CL-1009 | - | - | 73,180.67 |
| CL-1010 | 2.92722765 | - | 100,092.04 |
| CL-1011 | 2.60340942 | - | - |
| CL-1012 | - | 0.839093 | 174,600.37 |
| CL-1013 | 7.07294057 | - | - |
| CL-1014 | - | 2.954561 | 21,503.98 |
| CL-1015 | - | 4.82951479155 | 71,777.97 |
| CL-1016 | - | 123.680989015681 | - |
| CL-1017 | 0.76024873 | 84.547419231216 | 201,953.45 |
| CL-1018 | 10.8904305 | - | - |
| CL-1019 | 3.32911765 | 67.78505299 | 149,204.47 |
| CL-1020 | 0.298351 | 66.50013437 | 1,196.57 |
| CL-1021 | - | 0.92548675 | 1,552.63 |
| CL-1022 | 7.29379208 | 120.341620352668 | 112,663.37 |
| CL-1023 | - | 52.10798857 | - |
| CL-1024 | 11.68491639 | 23.14945349 | 136,183.45 |
| Total entitlement | 77.10192377 | 1,014.779658221422 | 1,398,414.93 |
| Client Trust B (held by the firm on chain) | |||
| CL-1025 | 2.15350529 | - | - |
| CL-1026 | - | 2.101421 | 28,497.99 |
| CL-1027 | 2.01760948 | 39.07830007 | 125,813.62 |
| CL-1028 | 2.93074182 | - | 32,502.54 |
| CL-1029 | 3.49279503 | - | 42,077.33 |
| CL-1030 | 3.84857936 | - | 185,750.48 |
| CL-1031 | 0.94128603 | 36.74135565 | 18,400.00 |
| CL-1032 | 4.00702593 | 2.720914 | 129,200.11 |
| CL-1033 | - | - | 14,347.65 |
| CL-1034 | 2.115218 | 25.9439233 | 1,344.13 |
| CL-1035 | 0.90146 | - | 41,287.02 |
| CL-1036 | 3.15623782 | 2.442027 | 211,554.53 |
| CL-1037 | - | 26.00319223 | - |
| CL-1038 | 3.57841913 | 21.77144236 | 68,422.51 |
| CL-1039 | 0.10294421 | 36.71143171 | 72,555.70 |
| CL-1040 | 2.79531751 | - | 100,564.97 |
| Total entitlement | 32.04113961 | 193.51400732 | 1,072,318.58 |
6. Runs in the last five business days
| Business date | Run | Trigger | Finished | Status | Lines | Breaks | Evidence record |
|---|---|---|---|---|---|---|---|
| Mon 9 Nov | RUN-2026-11-09-1 | Scheduled | 9 Nov 2026, 18:30 | Completed | 6 | 0 | 1 |
| Tue 10 Nov | RUN-2026-11-10-1 | Scheduled | 10 Nov 2026, 18:30 | Completed | 6 | 1 | 2 |
| Tue 10 Nov | RUN-2026-11-10-2 | Re-run | 11 Nov 2026, 11:45 | Completed | 6 | 0 | 8 |
| Wed 11 Nov | RUN-2026-11-11-1 | Scheduled | 11 Nov 2026, 18:30 | Completed | 6 | 0 | 11 |
| Thu 12 Nov | RUN-2026-11-12-1 | Scheduled | 12 Nov 2026, 18:30 | Completed | 6 | 1 | 12 |
| Fri 13 Nov | RUN-2026-11-13-1 | Scheduled | 13 Nov 2026, 18:30 | Completed | 6 | 1 | 17 |
7. Alerts
| Time | Alert | To | Channel |
|---|---|---|---|
| 10 Nov 2026, 18:30 | Shortfall: BTC in TA, CASE-0001 | Asha Patel | Demo: not sent |
| 12 Nov 2026, 18:30 | Shortfall: USDC in TB, CASE-0002 | Joseph Mensah | Demo: not sent |
| 13 Nov 2026, 18:30 | Shortfall not made good: notification decision required: CASE-0002 (TB, USDC) | Maja Lindqvist, Joseph Mensah | Demo: not sent |
8. Evidence log reference
Every run and every case event is written to an append-only evidence log. Each record holds a cryptographic hash of the previous record, so editing or deleting any past record is detectable by running recon verify.
- This run's record
- 17, recorded 13 Nov 2026, 18:30
- Record hash
- 5870c9d2350cb488e62dd4e56043ec75902f31f739506aa932392e235d500be9
- Previous record hash
- 8c7f65cff18c501a6b0ce45558d9b153bdbda8f3d8b6ea5a4ef668d4429fe7c7
- Content hash
- fe61f12822a7891ffdabc7da587233c30744b912717a16f038d1f139976a6239
- Log head when printed
- Record 18, 29d703087e0172bc6725b23b3d07ed9ed64f0791700d9ff6b4566226b53af084
- Verification
- Chain of 18 records checked from the first record; no edits or gaps found.