Replacing Outsourced Reconciliation With an In-House, Audit-Ready Engine

Background

Blackberrys Menswear (Mohan Clothing Co. Pvt. Ltd.) is a high-volume, multi-channel retail operation spanning its own stores and a network of large-format retail partners including Shoppers Stop. SAP is the system of record, and settlement arrives from more than a dozen payment sources — each with its own format, timeline, and fee structure.

The Challenge

The friction sat across three layers inside the four walls of the store, and one layer outside them:

• POS-to-SAP synchronization failures

  Sales receipts that never made it to the central ledger required manual comparison of thousands of rows to find what was missing.

• Incorrect tender type logging

  Cashiers occasionally logged card payments as cash, corrupting the SAP ledger at the GL-account level and requiring tedious manual correction.

• Bank reconciliation complexity

  Verifying that POS sales actually reached the bank meant reconciling against HDFC MPRs, Paytm, CMS cash receipts, Amex, and Zomato settlements — each with its own timeline and fee structure — with no automated way to catch variances.

• Channel-partner network complexity

  Roughly 100 large-format retail and e-commerce partners each maintained their own payable ledger, while Blackberrys maintained a party ledger per partner. Reconciling the two meant untangling clubbed payments, TDS short-deductions, returns-to-vendor, scheme and settlement disputes, and opening-balance differences — outsourced to a third-party agency at real cost, with limited transparency and slow turnaround.

The Solution

BotIntelli built four connected reconciliation workflows for Blackberrys, each targeting a specific point of friction:

• POS vs. SAP Sales Reconciliation

  Matches on unique receipt ID and auto-generates differential journal entries to balance the ledger.

• POS vs. SAP Tender Reconciliation

  Flags mismatched payment modes with corrective tags to eliminate misclassified tender errors.

• POS vs. Collections Reconciliation

  Triangulates expected revenue against actual bank and wallet deposits, with automated cash-deposit SLA tracking and penalty calculation for delayed store deposits.

• Channel-Partner Reconciliation

  Validated on live ledgers, producing a two-part Detail + Summary output per partner that ties every rupee of difference to a named category: invoices, payments, RTV, TDS, schemes, GST, and notes.

Implementation & Impact

• Sales reconciliation

  The POS-SAP sales engine recovered approximately 66 hours of manual effort per month, while identifying a missing-posting rate of 0.048% — sales that occurred at the register but never reached the central ledger, now caught automatically instead of surfacing at quarterly audit.

• Tender reconciliation

  Running on the same cadence, the tender reconciliation workflow identified a misclassified tender and refund rate of 0.017%, recovering a comparable amount of manual effort while eliminating the "missing cash" chases that were actually misclassified card or digital payments.

• Collections reconciliation

  The most labor-intensive of the three store-level workflows, collections reconciliation recovered 264 hours of manual effort per month and surfaced a missing settlement/gateway-fee error rate of 0.083% — while automated SLA and penalty logic now enforces cash-deposit compliance consistently across every store, including built-in weekend and holiday grace periods.

• Channel-partner reconciliation

  The channel-partner engine was validated live against real ledger data, correctly matching cross-ledger transactions — including complex 90-day payment clubbing across 2-to-8 settlement lines — and tying every partner's balance out to a fully explained, auditable difference. This replaced a third-party outsourced reconciliation agency with an in-house, glass-box process, designed to scale from an initial partner cohort to the full ~100-partner network using one reusable engine.

Looking Ahead

With all four reconciliation workflows validated, Blackberrys is positioned to bring its full channel-partner network onto the platform in phases, extending the same audit-ready reconciliation that now runs on its own stores to every partner ledger in its network.