R2 drill-down: period_end=2026-06-30, target_account=5100

discrepancy

Why the two sides of this control disagree — record by record, down to the line of the file each one came from. Back to reconciliation results

The two sides of this control should agree for period end 2026-06-30, target account 5100. Anything left over is money one side reports and the other does not.

The same balances carried through the account mapping. It answers a different question from R1: not 'is the ledger complete' but 'does it still tie after being mapped onto the new chart of accounts'.

Left side: 391,060.50USDLeft side of the comparison
Right side: 391,510.50USDRight side of the comparison
Difference: (450.00)USDLeft side minus right side
Unexplained: (450.00)USDPart of the difference no record accounts for

What this comparison can and cannot show

The control trial balance is an aggregate report, so record-level matching is not possible. Lines whose entry date and posting period place them in different periods, and rows that could not be parsed, are listed as the likely contributors.

Control balances

The legacy system's own balances for these accounts. A control report is an aggregate, so Relay cannot match it row by row — it compares the totals and then shows what could move them.

Normalized record

Every record below links to what Relay staged, and every file reference links to the exact line of the uploaded export.

Accounts 5100, 5300, 6400, 6410
Record Relay staged	Date	Account	Amount	Line in the uploaded file
tb:5100:2025-12-31	2025-12-31	5100	0.00USD	row 60, line 61

Rows that could not be read

Lines of the export Relay could not parse, so nothing from them reached the staged detail. They are kept exactly as received, and they may account for part of the difference above.

Original source

lines 9505–9506 (Field count mismatch)

Control balances

Rows that could not be read

Lines where entry date and posting period disagree