R2 drill-down: period_end=2026-05-31, target_account=2000

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-05-31, target account 2000. 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: (1,162,127.02)USDLeft side of the comparison
Right side: (1,160,942.40)USDRight side of the comparison
Difference: (1,184.62)USDLeft side minus right side
Unexplained: (1,184.62)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 2000
Record Relay staged	Date	Account	Amount	Line in the uploaded file
tb:2000:2025-12-31	2025-12-31	2000	(735,473.01)USD	row 28, line 29

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)

Lines where entry date and posting period disagree

Each line below carries an entry date in one period and a posting period in another, so the control report and Relay's detail count the same money in different periods. That is the usual reason an account ties overall but not period by period.

Likely timing contributors
Record Relay staged	Date	Account	Amount	Line in the uploaded file
jl:JE-AP-20455:2	2062-03-14	2000	(1,184.62)USD	row 7639, line 7640