## Job Summary
We are looking for a *Collection Accounts Executive* to manage customer outstanding payments, maintain accurate receivable records, and prepare MIS reports. The ideal candidate should have hands-on experience in *Accounts Receivable (Collections), strong knowledge of **Tally ERP, and advanced proficiency in **Microsoft Excel*.
## Key Responsibilities
### Accounts Receivable & Collections
* Follow up with customers for outstanding payments via calls and emails.
* Ensure timely collection of payments as per the agreed credit terms.
* Maintain customer outstanding records and collection status in Tally ERP.
* Coordinate with customers to resolve payment-related queries and invoice discrepancies.
* Reconcile customer ledgers and monitor ageing reports.
* Process and maintain records of credit notes, where applicable.
### MIS Reporting
* Prepare daily, weekly, and monthly collection MIS reports.
* Analyze sales and collection data using Advanced Excel.
* Create Pivot Tables, VLOOKUP/XLOOKUP, dashboards, and analytical reports for management.
* Generate ageing analysis and receivable reports.
### Stock Analysis
* Prepare monthly closing stock analysis and comparison reports in Excel.
* Assist in inventory reconciliation and reporting.
## Required Skills
* Strong knowledge of *Tally ERP* (Mandatory).
* Advanced Microsoft Excel skills (Pivot Tables, VLOOKUP/XLOOKUP, IF, SUMIF/SUMIFS, INDEX-MATCH, Charts, and Conditional Formatting).
* Good understanding of *Accounts Receivable, Collections, Credit Notes, and Customer Ledger Reconciliation*.
* Excellent communication skills in English.
* Strong analytical and follow-up skills.
## Qualification
* B.Com or Bachelor's Degree in Commerce, Finance, or Accounting.
* 2–5 years of experience in *Accounts Receivable / Collection Accounts / MIS*.
Pay: ₹18,000.00 - ₹20,000.00 per month
Benefits:
Work Location: In person
