Find Missing Transactions in Excel
Upload two files and automatically match transactions. No formulas needed.
Quickly find matching and missing transactions between two Excel files. Works with bank statements, GL exports, and payment records.
- ✓ No formulas needed
- ✓ Works with any Excel or CSV file
- ✓ Try sample first (no upload required)
🔒 Files are processed temporarily and deleted immediately. No data is stored.
Takes less than 30 seconds
How matching works (simple rules)
Exact Match
Amount: 100 = 100
Date: 01 Jan = 01 Jan
→ Perfect match
Date: 01 Jan = 01 Jan
→ Perfect match
Close Match
Amount: 100 ≈ 102 (within ±2%)
Date: 01 Jan ≈ 02 Jan (within ±2 days)
→ Close match found
Date: 01 Jan ≈ 02 Jan (within ±2 days)
→ Close match found
Flexible Match
Amount: 100 ≈ 105 (within ±5%)
Date: 01 Jan ≈ 05 Jan (within ±7 days)
→ Flexible match found
Date: 01 Jan ≈ 05 Jan (within ±7 days)
→ Flexible match found
Results show which matching rule was used for each transaction.
Common transaction matching workflows
Files are processed temporarily and not retained after matching.