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

* Robust 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:

- Provident Fund

Work Location: In person

📌 Accounts Receivable Executive (India)
🏢 Panav Biotech
📍 India