About This Tool
What It Does
This is a lightweight web tool for matching transactions between two Excel or CSV files. It's designed for operational reconciliation workflows where you need to quickly identify which transactions match across different data sources.
Common Use Cases
- Bank statement reconciliation
- General ledger matching
- Payment record verification
- Transaction reconciliation across systems
- Finding missing or unmatched records
How It Works
Upload two files (your records and external records), map the amount, date, and optional description columns, then configure matching rules. The tool applies three matching rules in sequence:
- Exact Match: Identical amount and date
- Close Match: Amount within ±2%, date within ±2 days (adjustable)
- Flexible Match: Amount within ±5%, date within ±7 days (adjustable)
Results are provided as an Excel file showing matched pairs, unmatched records, and which rule was used for each match.
File Handling & Privacy
Temporary Processing: Uploaded files are stored temporarily in the server's temp directory during processing and are automatically cleaned up when you upload new files or when the server restarts.
No Long-Term Storage: Files are not intentionally stored, archived, or backed up. The tool processes your data and generates results, but does not persist your original files.
Recommended Usage: While files are handled temporarily, avoid uploading highly sensitive or confidential data. This tool is best suited for operational reconciliation tasks with non-critical data.
Active Development
This tool is actively being improved based on user feedback. Key improvements include enhanced matching rules, better result visualization, and improved error handling.
If you encounter issues or have feature suggestions, please visit the Contact & Feedback page.