I will automate your invoice and payment reconciliation in excel or python
Financial Data Analyst
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

