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 stored temporarily on our server while you work and are deleted automatically after 24 hours of inactivity.
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
Uploaded files and results are stored temporarily and deleted automatically after 24 hours of inactivity.