E-Commerce · Operations · Global

Replacing a broken manual close with an automated reconciliation engine

A global eCommerce platform was reconciling multiple payment processors against its internal transaction layer manually, every month. We designed and delivered a production-grade automated 3-way reconciliation engine and eliminated the manual close cycle.

Tools & methods

Challenge

The finance lead was re-importing ERP data up to five times in a three-hour window at month-end. A single person handled all bank postings for every entity. The close took weeks. The root cause was process design, not capacity.

Approach

Scoped, architected, and delivered an Electron desktop application with a Python/Pandas backend performing a 3-way match across payment processors, internal platform records, and bank deposits. Built direct ERP connections into close workbooks and connected Power BI for live GL visibility.

Results

• 3–4 hour manual reconciliation replaced with an automated engine
• 4 payment processors covered: PayPal, Stripe, Braintree, NMI
• Manual GL export loop eliminated via direct Dynamics NAV connection
• Exception dashboard replacing month-end scramble with real-time visibility
• Phase 2 scoped: 6 additional payment processors across second business unit