I will automate your invoice and payment reconciliation in excel or python

Pakistan

I speak Urdu, Punjabi, English

Financial Data Analyst

I'm a Financial Data Analyst from Lahore, Pakistan. For 1.5+ years I've reconciled invoices, payments, credit memos and deductions across 20+ US retail accounts, so I know where money and data go miss...
About this Gig

Every month, are you or your team manually checking invoices against payments in spreadsheets? I automate that. I build reconciliation tools that match invoices to payments, flag unpaid, short-paid, overpaid and duplicate amounts, and separate real deductions from data errors in Excel (formulas, Power Query) or Python and SQL, whichever fits how you already work. What makes this different: every deliverable validates its input, flags rows it can't match with a clear reason instead of silently dropping them, and keeps money calculations exact to the cent no float-rounding drift. This comes from real experience I do this professionally every day, reconciling 20+ US retail accounts. My public GitHub shows tested, working examples, including one with 77 automated tests. Send me a sample of your invoice and payment files (a few rows is enough) and I'll tell you honestly whether I can help and how, before you order.

Technology:

Excel

•

Google Sheets

•

Python

•

PowerShell

Expertise:

Data extraction

•

Data flow

•

Data manipulation