Vendor Reconciliation & Excel Expert
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
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.
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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.