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