Vendor Reconciliation & Excel Expert

The assignment centres on cleaning up a vendor ledger that currently contains unmatched invoices, payments, credit notes and GST/TDS adjustments. I will provide the raw SAP download along with bank payment files; your job is to turn that data into a reconciled, audit-ready workbook. Using advanced Excel functions—XLOOKUP, VLOOKUP, SUMIFS and PivotTables—you will: • trace every invoice line to its corresponding payment or credit • flag and categorise all variances (TDS deductions, credit notes, short-payments, GST holds, ageing items, etc.) • produce a concise reconciliation statement for each vendor, followed by a summary dashboard that highlights outstanding balances and root-cause explanations. The finished file must be logically structured, formula-driven (no hard-coded figures), and easy for an accountant to review. Familiarity with SAP’s P2P cycle will help you interpret reference fields and document numbers, but any robust vendor-accounting background is welcome. When you respond, please cite a similar reconciliation you have completed, outline the size of the data set you handled, and give me a realistic timeline for initial draft and final delivery. Accuracy and clarity outweigh speed, yet I would like the first cut within a week if feasible.