Assistant Accounts Receivable Manager

Job Title : Assistant Manager Accounts Receivable

Team : Accounts & Finance

Location: Head Office (Lower Parel, Mumbai)

Role Purpose:

Responsible for end-to-end Accounts Receivable, Revenue Accounting and Revenue Reconciliation across the company's predominantly B2C business, with a strong focus on offline retail stores and online D2C channels.

The role will ensure that revenue is completely and accurately captured,

reconciled with operational systems and payment collections, appropriately accounted for, and reported within defined timelines.

Key Responsibilities :

1. Revenue Accounting & Reconciliation

• Own the end-to-end revenue reconciliation process across:

1. Offline stores

2. Own website / D2CMall stores

3. Franchisees

4. Corporate sales

5. Other business channels, wherever applicable.

• Perform daily/weekly/monthly revenue reconciliation between POS, Shopify/e-commerce systems, Tally/ERP and the General Ledger.
• Ensure completeness and accuracy of sales recorded in books.
• Investigate and resolve differences between operational reports and accounting records.
• Perform store-level and channel-level revenue reconciliation.
• Ensure timely month-end revenue finalization and closure.
• Prepare revenue-related schedules and supporting documents for monthly closing and audit.
• Identify revenue leakages, duplicate entries, missing transactions and incorrect accounting.

2. Offline Store Revenue & Cash Reconciliation

• Perform daily store-wise sales reconciliation between POS sales and

accounting records.

• Reconcile cash, card, UPI, EDC and other modes of payment against store sales.
• Monitor cash collections and ensure timely deposit into bank.
• Reconcile cash collections with bank deposits.
• Investigate cash shortages, excesses and delayed deposits.
• Perform EDC/payment settlement reconciliation and identify unsettled or incorrectly settled transactions.
• Track store-wise payment discrepancies and ensure timely resolution with Retail Operations.
• Coordinate with stores for missing invoices, payment confirmations and reconciliation differences.

3. Online / D2C Revenue & Payment Gateway Reconciliation

• Perform daily reconciliation of own website sales with Shopify/e-commerce reports.
• Reconcile:

Orders Invoices Payment Gateway Bank ERP/GL.

• Perform payment gateway reconciliation for all online transactions.
• Track successful, failed, pending, reversed and chargeback transactions.
• Reconcile payment gateway settlements with bank credits.
• Identify settlement deductions, MDR, refunds and other payment gateway adjustments.
• Ensure timely accounting of online sales and related payment transactions.
• Coordinate with the e-commerce/technology team for system or data discrepancies.

4. Refund Management

• Perform daily refund reconciliation.
• Reconcile refunds initiated through the website/payment gateway with accounting records and bank/payment gateway settlements.
• Prepare monthly refund MIS.
• Identify refunds processed without corresponding sales or duplicate refunds.
• Monitor refund ageing and unresolved refund cases.
• Ensure appropriate accounting of sales returns/refunds and related GST impact.

5. GST & E-Invoicing

• Ensure accurate and timely GSTR-1 data finalization.
• Coordinate with the Tax team for revenue-related GST reporting.
• Ensure accuracy of:

1. GSTIN

2. HSN codes

3. Tax rates

4. Place of supply

5. Invoice values

6. Credit notes/debit notes.

• Ensure e-invoicing data is complete and accurate wherever applicable.
• Coordinate with stores/business teams for GST invoice requirements.
• Ensure HSN codes and other tax masters are appropriately maintained in
• Shopify/ERP.
• Reconcile GST sales data with books and operational revenue reports.
• Support GST audits and queries relating to revenue.

6. Mall Revenue / Franchise Revenue

• Prepare and share mall revenue statements/reports within agreed
• timelines.
• Coordinate with mall management for revenue-related submissions and
• queries.
• Validate mall revenue reports against POS/ERP records.
• Prepare and share franchise revenue data with relevant stakeholders.
• Reconcile franchise sales/revenue with invoices and accounting records.
• Follow up on revenue confirmations and outstanding differences.

7. Corporate Sales & Invoicing

• Manage accounting and invoicing for corporate customers, including
• preparation of Proforma Invoices (PI) and final invoices.
• Ensure invoices are raised accurately and within agreed timelines.
• Track corporate receivables and follow up for payment confirmations.
• Reconcile corporate customer balances with books.
• Coordinate with Sales/Business teams for invoice disputes and deductions.

8. Accounting in Tally

• Ensure timely posting of sales-related entries in Tally/ERP.
• Review accounting entries for revenue, collections, refunds, credit notes and payment settlements.
• Ensure proper mapping of revenue to appropriate channels, stores,
• locations and GL accounts.
• Perform periodic reconciliation between sub-ledgers/operational systems and General Ledger.
• Ensure all revenue-related accounts are reconciled before month-end closure.

9. Revenue MIS & Management Reporting

• Prepare weekly revenue MIS at order level and circulate weekly.
• Track and report:

1. Revenue

2. Collections

3. Refunds

4. Payment gateway settlements

5. Cash collections

6. EDC reconciliation

7. Revenue variances.

• Highlight significant reconciliation differences and ageing to management.
• Provide actionable insights on revenue and collection exceptions.

A. Key Controls & Risk Management

The role should also have ownership of revenue-related financial controls, including:

• Ensuring 100% revenue completeness between POS/Shopify and
• accounting records.
• Ensuring all payment modes are reconciled.
• Monitoring unreconciled revenue and collection balances.
• Identifying unusual revenue adjustments, refunds and credit notes.
• Monitoring ageing of unreconciled transactions.
• Ensuring proper approval and documentation for manual revenue entries.
• Ensuring segregation of duties between sales, refund processing, collections and accounting.
• Maintaining proper audit trails for revenue reconciliation.
• Supporting Internal Financial Controls / statutory and internal audits.

B. Month-End Closing Responsibilities

• Complete month-end revenue reconciliation within defined closing timelines.

• Reconcile:

1. POS vs ERP

2. Shopify vs ERP

3. Payment Gateway vs Bank

4. EDC vs Bank

5. Cash sales vs Cash deposits

6. Revenue MIS vs GL

7. Refunds vs payment gateway/bank.

• Identify and pass required accounting entries.
• Prepare revenue schedules for statutory/internal audit.
• Ensure no material unreconciled revenue/collection balances remain at month-end.
• Provide revenue sign-off to the Finance Controller/CFO.

C. Key Deliverables / KPIs

I would recommend making the KPIs measurable, rather than simply listing activities.

• Revenue Reconciliation: 100% reconciliation of revenue across all channels.
• Daily Store Reconciliation: Completed within T+1.
• Online / Payment Gateway Reconciliation: Completed within T+1.
• Cash Reconciliation: 100% store-wise reconciliation.
• EDC Reconciliation: 100% settlement reconciliation.
• Refund Reconciliation: Completed on a daily basis.
• Revenue Finalization: Completed within the month-end closing timeline.
• GSTR-1 Data: Accurate and timely submission to the Tax Team.
• E-Invoicing: 100% of applicable invoices processed correctly.
• Revenue MIS: Weekly MIS circulated every Monday.
• Unreconciled Items: Minimum ageing with timely closure.
• Month-End Revenue Reconciliation: Completed before Finance close.
• Audit Queries: Timely resolution with complete supporting documentation.

Qualifications & Experience

Qualification:

• B.Com / M.Com or equivalent.
• Strong accounting and reconciliation knowledge.

Experience:

• 5 to 7 years of experience in Accounts Receivable, Revenue Accounting, Retail Finance, E-commerce Finance or Financial Controllership.
• Experience in retail / D2C / e-commerce / multi-store businesses
• preferred.
• Experience handling large volumes of B2C transactions and payment
• reconciliations preferred.
• Strong experience in POS, payment gateway and ERP reconciliations.

Systems & Technical Skills

1. Strong working knowledge of:
2. Tally / ERP
3. Advanced Excel
4. Shopify / e-commerce platforms
5. POS systems
6. Payment gateways
7. EDC/card settlement reports
8. GST / e-invoicing systems
9. MIS and reconciliation tools

Advanced Excel skills should be mandatory, including Pivot Tables,

XLOOKUP/VLOOKUP, SUMIFS, data validation, reconciliation techniques and preferably Power Query.