Excel Stock Data Reconciliation

Budget: ₹750 - ₹1250/hr

I have several Excel workbooks that track our stock supply quantities. Unfortunately, the running balances have drifted and I keep running into inconsistent data. I need a data-savvy professional to dig into the spreadsheets, locate every mismatch, and return a clean, fully reconciled file.

Here is what I’m after: • Work directly in the existing.xlsx files—no data extraction needed. • Clean and standardise the key columns (item code, in-qty, out-qty, balance, unit cost, payment status). • Identify and flag each row, SKU, or date range where the quantity on hand does not reconcile with the recorded movements. • Produce a short findings report that highlights the size and cause of each discrepancy, backed by pivot tables or charts so the results are easy to scan.

Accuracy is the priority; elegant visuals are a bonus. If using Power Query, Power BI, or VBA speeds up the validation, feel free. I will share the raw files as soon as we agree to proceed and would like an initial pass within three days, with final delivery once we walk through any open questions together.

Please mention similar reconciliation or inventory analysis work you have handled and the techniques you plan to use for error detection and correction.