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), robust 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

Solid 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.
Solid 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 Kirti Nagar (India)
🏢 Panav Biotech
📍 India