I will automate excel reconciliation and data validation reports


About this gig
Still comparing spreadsheets row by row?
I will build a reusable automation that compares your Excel or CSV exports, checks agreed business rules, and produces a clear exception report.
Your workflow can flag:
- Missing records and duplicate IDs
- Changed amounts, statuses, or other agreed fields
- Blank required values and invalid numbers
- Differences outside your chosen tolerance
You receive a repeatable script, an Excel-compatible exceptions CSV, a readable HTML report, source code, and setup instructions. Each finding points to its source file and row so you can investigate it.
I work from sample input files and your expected results. We agree the matching key, field rules, and output before development. Standard and Premium include setup in one agreed environment and a walkthrough.
Please message me before ordering so I can confirm your file structure, scope, and package. Google Sheets exports are supported. Live integrations, scanned PDFs, and changed source layouts require a separate quote.
Get to know Santhosh S
Senior Executive
- FromIndia
- Member sinceOct 2026
- Avg. response time1 hour
Languages
Tamil, English
My Portfolio
FAQ
What do you need to start?
Two representative sample exports, the matching key, fields to check, tolerance and blank-value rules, plus an example expected result.
Can I run it again next month?
Yes, on files with the agreed structure. Replace the inputs and rerun. Premium includes scheduling in one agreed environment.
Will it change my original files?
It reads inputs and writes separate reports. Corrections or write-back require separate scope.
Does it support Google Sheets?
CSV or XLSX exports are supported. A live connection needs separate scoping for access, hosting and refresh requirements.
What about formulas and PDFs?
Send evaluated values for formula-based workbooks. PDF extraction, OCR and new calculation rules need a separate assessment.
Do I receive the source code?
Yes, with instructions for the agreed workflow.
How do we confirm it works?
We agree examples of matches, differences and edge cases before development. Delivery includes a demonstration and source-row evidence.
What does a revision include?
Adjustments to agreed rules, configuration or layout. New sources, integrations, calculations or substantially different workflows are separate work.
What do the package limits include?
Row limits combine both input files per run. One workflow uses two source layouts, one key and one report format. Each XLSX source uses one worksheet. Premium includes 14 days of bug fixes against agreed requirements; the buyer supplies the machine and paid licenses.
