Reconciliation

Reconcile totals with clear explanations — match by keys, track variance, and produce a defensible summary you can send to stakeholders.

Source A

Example: POS / system-of-record

A:not loaded

Amount column Flip sign

TXT is supported when it is a delimited export (CSV/TSV-style) with a header row.

Source B

Example: bank / GL / downstream system

B:not loaded

Amount column Flip sign

Privacy: everything runs locally in your browser (GitHub Pages friendly).

Adjustments (optional)

Example: manual journals / exceptions

Adj:none

Adj amount

Use the same group keys so adjustments roll up to the right bucket.

1) Group keys (dimensions)

Reconcile totals by these columns (leave empty to compare grand totals only).

Tip: For finance-style reconciliations try Account, CostCenter, Date/Week. For retail try StoreId + Week.

2) Compare rules

Trim whitespace (" abc " → "abc")

Case-insensitive keys (store001 == STORE001)

Normalize numbers ($1,234.00 == 1234)

Parentheses as negative ((123) → -123)

Absolute tolerance

Percent tolerance

Set to 0 to disable percent tolerance.

Results

Matched groups, missing groups, and variances

Grand A— Grand B— Adj— Variance— Groups— Matched— Out tol— A only— B only— Keys:— Amounts:—

Status	Group key	A total	B total	Adj	Variance	Var %	Rows A	Rows B	Notes

Tip: Click any row to drill into the underlying Source A / Source B records for that group.