Reconciliation Gap Checker

Compare two independent financial files (e.g. your ERP transaction journal against a bank statement or supplier invoice log). Computes exact row matches, identifies surplus records, and flags cent-level line variances in memory.

File A: Primary LedgerUpload CSV

System_Ledger.csv

Key Column:

Amount Column:

File B: Target / Bank FeedUpload CSV

Bank_Statement.csv

Key Column:

Amount Column:

Reconciliation Rules & Tolerance

Variance Tolerance (Absolute Value):$0.01Values differing by less than $0.01 are classified as matched (e.g. minor FX or rounding noise).

Join & Variance Logic:

• Key Hash: Outer join on normalized string keys (trimmed of whitespace and quotes).

• Net Discrepancy: Σ Amount_A - Σ Amount_B across all matching and orphan keys.

• Output Label: Deterministic operational estimate.