R2 drill-down: period_end=2026-03-31, target_account=6200

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-03-31, target account 6200. 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: 7,009.54USDLeft side of the comparison
Right side: 5,824.92USDRight side of the comparison
Difference: 1,184.62USDLeft side minus right side
Unexplained: 1,184.62USDPart 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 6200, 6210, 6230, 6240
Record Relay staged	Date	Account	Amount	Line in the uploaded file
tb:6200:2025-12-31	2025-12-31	6200	0.00USD	row 85, line 86

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)

tb:6210:2025-12-31	2025-12-31	6210	0.00USD	row 86, line 87

tb:6210:2026-03-31	2026-03-31	6210	1,447.95USD	row 482, line 483

tb:6230:2025-12-31	2025-12-31	6230	0.00USD	row 88, line 89

tb:6230:2026-03-31	2026-03-31	6230	0.00USD	row 484, line 485

tb:6240:2025-12-31	2025-12-31	6240	0.00USD	row 89, line 90

tb:6240:2026-03-31	2026-03-31	6240	1,877.39USD	row 485, line 486

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:1	2062-03-14	6200	1,184.62USD	row 9291, line 9292