Sales & Receivables Reconciliation (Prepaid Payment Partners)

**Job Purpose:**The role is responsible for end-to-end reconciliation of Shopify sales against actual receipts collected through Snitch's prepaid payment ecosystem, including payment gateway partners (Razorpay, Juspay and similar aggregators) and Buy-Now-Pay-Later / EMI partners (Snapmint and similar). The role also owns the tracking, reconciliation and reporting of Wallet Liability and Loyalty Points, since a portion of prepayments on Shopify is settled through these instruments rather than direct bank receipts. The objective is to ensure that every rupee of sale recorded on Shopify is traceable to a corresponding receipt, refund, wallet movement or loyalty redemption, with all mismatches identified, investigated and closed within defined timelines.

Key Responsibilities: Sales vs. Receipts Reconciliation

• Perform daily/periodic reconciliation of Shopify sales data against receipts/settlements received from prepaid payment partners such as Razorpay, Snapmint, Juspay and other payment gateways/BNPL-EMI partners.
• Match order-level transactions across the Shopify order management system, payment gateway settlement reports and bank statements to identify gaps, short settlements, duplicate charges and unrecognized receipts.
• Track and reconcile Cash-on-Delivery (COD) vs. prepaid order mix, refunds, cancellations, chargebacks and partial payments arising from these channels.
• Investigate and resolve discrepancies between sales booked and receipts realized, coordinating with payment partners and the internal tech/ops teams to close open items within TAT.
• Prepare and maintain daily/weekly/monthly reconciliation trackers and MIS showing settlement ageing, pending receivables and partner-wise reconciliation status.

Wallet Liability & Loyalty Points Tracking

• Track and reconcile Wallet Liability balances arising from prepayments, refunds credited to wallet, and wallet redemptions against Shopify sales.
• Monitor Loyalty Points issuance, redemption and expiry, ensuring accurate accounting of loyalty-funded prepayments and their corresponding liability on the books.
• Ensure that wallet and loyalty point balances as per the Shopify/loyalty platform tie back accurately with the general ledger and finance reports.
• Flag and follow up on unusual movements, breakages, or anomalies in wallet/loyalty balances with relevant business and tech teams.

Receivables Management

• Maintain partner-wise receivable ageing (Razorpay, Snapmint, Juspay, and others) and follow up on overdue/unsettled amounts.
• Support monthly closing by providing accurate receivable and liability positions (wallet/loyalty) for financial reporting.
• Assist in resolving partner-raised queries/disputes and support audits (statutory/internal) related to sales-receipts reconciliation.

Reporting & Systems

• Extract, query and analyze large transaction datasets using analytical tools such as Snowflake and Metabase to build reconciliation reports and dashboards.
• Maintain and update reconciliation records in ERP systems (Tally, Logic ERP) and ensure accounting entries for sales, receipts, wallet and loyalty liability are correctly posted.
• Build and maintain robust Excel-based working files (lookups, pivot tables, macros as needed) to manage high-volume transaction-level reconciliation.
• Present periodic reconciliation status, ageing and exception reports to Finance leadership.

• Graduate/Postgraduate in Commerce, Accounting or Finance (B.Com/M.Com/MBA-Finance);
• professional certification (CA-Inter/CMA-Inter) preferred but not mandatory.
• 1–5 years of relevant experience in e-commerce/D2C sales reconciliation, payment gateway reconciliation, or receivables accounting, preferably in a Shopify-based or similar online retail environment.
• Prior exposure to Razorpay, Juspay, Snapmint or similar payment/BNPL partner reconciliation is highly desirable.