Customer-wise and product-wise scheme calculation Target-based and slab-based scheme calculation Percentage and fixed-value scheme calculation Quantity-based promotional scheme calculation Verification of scheme eligibility as per company policy Calculation of customer incentives, rebates and discounts Adjustment for sales returns, credit notes and debit notes 4. Receipt & Cash Application
Customer payment posting Payment allocation against invoices Advance and unidentified receipt handling Customer ledger reconciliation Bank receipt reconciliation 5. Collection & Follow-up
Daily overdue monitoring Customer payment follow-up Collection planning Payment commitment tracking Escalation of long-outstanding balances 6. AR Aging & Reconciliation
Customer-wise aging analysis 30/60/90+ days overdue analysis AR sub-ledger reconciliation with GL Open-item clearing Identification and correction of discrepancies 7. Dispute Management
Invoice and pricing dispute resolution Scheme-related dispute resolution Coordination with Sales, Commercial, Logistics and customers Tracking disputes until closure 8. Month-End & Year-End Closing
AR reconciliation Scheme provision/accrual calculation Outstanding and aging review Credit-note/adjustment posting Month-end reporting Audit support 9. MIS & Reporting
SAP / Oracle / Dynamics / Tally / other ERP Advanced Excel Pivot Tables XLOOKUP/VLOOKUP SUMIFS/COUNTIFS Data reconciliation and MIS preparation GOOLGE SHEET WORK