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.

Key Skills & Competencies

• Strong understanding of e-commerce sales-to-receipt cycles, payment gateway settlement mechanics, and BNPL/EMI settlement structures.
• Working knowledge of wallet liability and loyalty points accounting concepts in a D2C/retail environment.
• Proficiency in analytical/data tools - BI/SQL-based tools or querying and reporting large datasets.
• Good working knowledge of Finance and ERP systems — Tally and Logic ERP.
• Advanced Excel skills — VLOOKUP/XLOOKUP, pivot tables, conditional formatting, and large-dataset handling.
• Strong analytical and problem-solving skills with high attention to detail and accuracy.
• Good communication and coordination skills to liaise with payment partners, internal tech/ops and finance teams.
• Ability to work under deadlines during month-end/quarter-end closing.

Qualification & Experience

• 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.

Key Deliverables / Success Metrics

• 100% reconciliation of Shopify sales with receipts across all prepaid partners within agreed TAT, with minimal unresolved/ageing exceptions.
• Accurate and up-to-date Wallet Liability and Loyalty Points ledger tying back to system balances at all times.
• Timely, accurate MIS and dashboards enabling Finance leadership to monitor receivables health and settlement risk.
• Clean statutory/internal audit trail for sales-receipts-wallet-loyalty reconciliation with no material observations.