Smart Reconciliation Sheet

This sheet is to help finance and accounting teams reconcile two datasets.It’s built for cases where data doesn’t perfectly match, like bank statements vs ERP exports, invoices vs payments, or any cross-check where you're manually comparing hundreds of rows.It compares both datasets and finds matches based on amount and closest date, handles small discrepancies and shows you only what needs attention. What's included:

• Set tolerance levels for amounts, dates, descriptions
• Color-coded status (matched, review, no match)
• Pre-filtered sheets showing just the exceptions
• Handles duplicate amounts correctly (matches to closest date, not first occurrence)