Collection Accounts Executive*

# *Job Title: Collection Accounts Executive*

*Company:* Panav Biotech Pvt. Ltd.

*Location:* Kirti Nagar, New Delhi

*Experience:* 2–5 Years

*Gender:* Female Preferred

*Employment Type:* Full-Time

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