Fictional sample data. Not a real firm, client or record.

Daily client-asset reconciliation record (fictional sample data)

Fernhollow Digital Assets Ltd: Friday, 13 November 2026

Run
RUN-2026-11-13-1
Status
Completed, scheduled
Started and finished
13 Nov 2026, 18:30 to 18:30 (Europe/London)
Evidence record
Record 17 in the evidence log, hash 5870c9d2350cb488…
Retention
Every calculation, confirmation, reconciliation and discrepancy record is kept for at least 5 years

1. Summary

6Trust and asset-class lines reconciled
4Matched exactly
1Within configured tolerance
1Breaks
1Open cases, 1 escalated

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.

CalculationSourceAs atDetailPositions
HoldingsBitcoin chain (reconciliation node)
System: recon-bitcoin-node
13 Nov 2026, 16:58bitcoin block 922,16313
HoldingsEthereum chain (reconciliation node)
System: recon-ethereum-node
13 Nov 2026, 16:59ethereum block 23,848,81223
HoldingsKestrel Custody confirmation (daily statement)
System: kestrel-custody
13 Nov 2026, 17:00Statement KST-202611133
EntitlementClient ledger (firm records, daily export)
System: fernhollow-ledger
13 Nov 2026, 17:00Export 2026-11-13.csv, 83 rows83

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.

TrustAsset classHoldings sourceEntitlementHoldingsDifferenceToleranceResult
TABTCKestrel Custody confirmation 77.1019237777.101923770.00Exact Matched
TAETHKestrel Custody confirmation 1,014.7796582214221,014.779658220.0000000014220.00000001 Within tolerance
TAUSDCKestrel Custody confirmation 1,398,414.931,398,414.930.00Exact Matched
TBBTCBitcoin chain 32.0411396132.041139610.00Exact Matched
TBETHEthereum chain 193.51400732193.514007320.00Exact Matched
TBUSDCEthereum chain 1,072,318.581,071,068.581,250.00Exact 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)

Status
Open; escalated: shortfall not made good: notification decision required
Comparison
Trust B: entitlement v Ethereum chain holdings
Owner
Joseph Mensah
Opened
12 Nov 2026, 18:30 by run RUN-2026-11-12-1
Investigate by
13 Nov 2026, 10:30
Make good by
13 Nov 2026, 18:30 (24 hours)
Escalated
13 Nov 2026, 18:30 to Maja Lindqvist

Closed

CASE-0001: shortfall of 0.25 BTC, Client Trust A (held with Kestrel Custody)

Status
Closed
Comparison
Trust A: entitlement v Kestrel Custody confirmation
Owner
Asha Patel
Opened
10 Nov 2026, 18:30 by run RUN-2026-11-10-1
Investigate by
11 Nov 2026, 10:30
Make good by
11 Nov 2026, 18:30 (24 hours)
Closed
11 Nov 2026, 11:50

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.

ClientBTCETHUSDC
Client Trust A (held with Kestrel Custody)
CL-10012.8547377312.482980237954-
CL-1002-82.456286153085-
CL-100310.247602320.73119735,715.95
CL-10046.90711896104.73125710955-
CL-10055.9402607763.93307737479-
CL-1006--214,721.77
CL-10073.6682121.33715914-
CL-10080.6235781.446387644928104,068.24
CL-1009--73,180.67
CL-10102.92722765-100,092.04
CL-10112.60340942--
CL-1012-0.839093174,600.37
CL-10137.07294057--
CL-1014-2.95456121,503.98
CL-1015-4.8295147915571,777.97
CL-1016-123.680989015681-
CL-10170.7602487384.547419231216201,953.45
CL-101810.8904305--
CL-10193.3291176567.78505299149,204.47
CL-10200.29835166.500134371,196.57
CL-1021-0.925486751,552.63
CL-10227.29379208120.341620352668112,663.37
CL-1023-52.10798857-
CL-102411.6849163923.14945349136,183.45
Total entitlement77.101923771,014.7796582214221,398,414.93
Client Trust B (held by the firm on chain)
CL-10252.15350529--
CL-1026-2.10142128,497.99
CL-10272.0176094839.07830007125,813.62
CL-10282.93074182-32,502.54
CL-10293.49279503-42,077.33
CL-10303.84857936-185,750.48
CL-10310.9412860336.7413556518,400.00
CL-10324.007025932.720914129,200.11
CL-1033--14,347.65
CL-10342.11521825.94392331,344.13
CL-10350.90146-41,287.02
CL-10363.156237822.442027211,554.53
CL-1037-26.00319223-
CL-10383.5784191321.7714423668,422.51
CL-10390.1029442136.7114317172,555.70
CL-10402.79531751-100,564.97
Total entitlement32.04113961193.514007321,072,318.58

6. Runs in the last five business days

Business dateRunTriggerFinishedStatusLinesBreaksEvidence record
Mon 9 NovRUN-2026-11-09-1Scheduled9 Nov 2026, 18:30Completed601
Tue 10 NovRUN-2026-11-10-1Scheduled10 Nov 2026, 18:30Completed612
Tue 10 NovRUN-2026-11-10-2Re-run11 Nov 2026, 11:45Completed608
Wed 11 NovRUN-2026-11-11-1Scheduled11 Nov 2026, 18:30Completed6011
Thu 12 NovRUN-2026-11-12-1Scheduled12 Nov 2026, 18:30Completed6112
Fri 13 NovRUN-2026-11-13-1Scheduled13 Nov 2026, 18:30Completed6117

7. Alerts

TimeAlertToChannel
10 Nov 2026, 18:30Shortfall: BTC in TA, CASE-0001Asha PatelDemo: not sent
12 Nov 2026, 18:30Shortfall: USDC in TB, CASE-0002Joseph MensahDemo: not sent
13 Nov 2026, 18:30Shortfall not made good: notification decision required: CASE-0002 (TB, USDC)Maja Lindqvist, Joseph MensahDemo: 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.