Finance Executive

We are currently looking for Finance Executive (Accounts Receivable). Below is the job description:

1. Customer & Master Data

• Customer account creation and maintenance
• Customer master verification
• Credit limit and payment-term maintenance
• GST/tax and billing information verification

2. CREDIT NOTE / DEBIT NOTE

• Invoice verification
• Debit notes and credit notes
• GST/tax calculation verification
• Customer statement generation

3. Scheme Calculation & Settlement

• 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

• AR Aging Report
• Outstanding Report
• Collection Report
• Customer Ledger
• Scheme Calculation Report
• Scheme Outstanding/Settlement Report
• Credit Note Report
• Customer-wise Sales & Scheme Report
• DSO Report
• Collection forecast

10. Systems & Excel

• SAP / Oracle / Dynamics / Tally / other ERP
• Advanced Excel
• Pivot Tables
• XLOOKUP/VLOOKUP
• SUMIFS/COUNTIFS
• Data reconciliation and MIS preparation
• GOOLGE SHEET WORK