Browse categories
Explore
Fiverr Pro
English
$
USD
I will build an automated excel reconciliation and data comparison tool
About this Gig
Do you manually cross-check two lists in Excel orders vs. deliveries, planned vs. actual, budget vs. spend and waste hours copy-pasting and eyeballing mismatches?
I build automated Excel tools that compare two datasets and instantly flag every discrepancy missing items, quantity mismatches, unexpected entries color-coded and ready to review. No manual VLOOKUP-ing row by row.
What you get:
- A working Excel file with your real data structure
- Automatic matching between two sheets (any two lists you need compared)
- Clear status flags (e.g. Matched / Missing / Under / Over / Unexpected)
- Color-coded results so issues jump out visually
- Compatible with Excel, LibreOffice, and WPS Office no special add-ins needed
- A simple instructions tab so your team can use it without me
I have hands-on experience in retail inventory control and internal audit, so I understand messy real-world data partial deliveries, duplicate entries, missing references not just clean textbook examples.
Platform:
Excel
Development technology:
Python
•
Excel
•
VLOOKUP
Expertise:
Pivot tables
•
Formulas
•
Dashboard
•
Cleaning
FAQ
Do you need my real data?
A sample (even 10-20 rows, anonymized if needed) helps me match your exact column structure — but I can also work from a description of your columns.
Will this work in Google Sheets?
This gig is Excel-based (works in Excel, LibreOffice, WPS). Let me know before ordering if you specifically need Google Sheets — logic is similar but some formulas differ.
What if my data structure changes later?
I include revisions, and I'm happy to quote ongoing updates separately if needed.
