master-to-transactions
Record-count controlPASS
Value-total controlEXCEPTION
Grouped subtotal controlEXCEPTION
Overall control statusEXCEPTION
Record-count equation: 2 matched row pairs + 1 unmatched valid left + 1 unmatched valid right + 1 invalid-key left + 0 invalid-key right = 5 expected joined rows; actual joined output: 5.
matched row pairs + unmatched valid left rows + unmatched valid right rows + invalid-key left rows + invalid-key right rows. Invalid/missing reconciliation-key rows are reported separately and are not counted as valid unmatched keys.
Value-total controls
| Left field | Left total | Right field | Right total | Difference | Status |
|---|---|---|---|---|---|
| Balance | $2,015.00 | Amount | $2,075.50 | ($60.50) | EXCEPTION |
Grouped subtotal controls
| Group | Left total | Right total | Difference | Status |
|---|---|---|---|---|
| East | $0.00 | $125.50 | ($125.50) | EXCEPTION |
| North | $1,215.00 | $1,200.00 | $15.00 | EXCEPTION |
| South | $800.00 | $750.00 | $50.00 | EXCEPTION |
| West | $0.00 | $0.00 | $0.00 | PASS |