Job Purpose:

To handle commission-related calculations, MIS preparation, data verification, and commission-related

customer/branch/employee queries. The candidate should have good knowledge of MS Excel, basic calculations,

data handling, and report preparation.

Key Responsibilities

 Calculate and process monthly commission data accurately as per company guidelines.

 Verify and cross-check commission data before final processing.

 Prepare and maintain commission-related MIS reports on a monthly basis.

 Work extensively on MS Excel, including formulas, calculations, sorting, filtering, and data reconciliation.

 Check and identify discrepancies or errors in commission data and coordinate with the concerned team for

correction.

 Maintain proper records and databases of commission-related transactions and reports.

 Handle and respond to commission-related emails and queries received from branches and advisors.

 Handle commission-related calls and provide proper information for the same.

 Prepare various MIS reports as required by management.

 Reconcile data between different reports/system records and highlight mismatches.

 Coordinate with the IT, Accounts, Sales, Branches, and other concerned departments for commission-





related issues.

 Maintain proper documentation and records of all commission calculations, corrections, and queries.

 Ensure commission-related reports and responses are completed within the required timelines.

 Assist in identifying and resolving recurring issues in commission calculations and data.

 Perform other commission/MIS-related activities assigned by the reporting manager.

Required Skills

 Good knowledge of MS Excel is mandatory.

 Knowledge of Excel formulas such as VLOOKUP/XLOOKUP, IF, SUMIF/SUMIFS, COUNTIF/COUNTIFS,

Pivot Tables, Filters and Sorting.

 Good numerical and calculation skills.

 Ability to work with large volumes of data.

 Good understanding of MIS preparation and data reconciliation.

 Good analytical and problem-solving skills.

 Good written and verbal communication skills.

 Ability to handle email queries professionally.

 Ability to communicate confidently over calls.

 Valuable attention to detail and accuracy.
Exeperience - 5 years to 6 years

Pay: ₹25,000.00 - ₹30,000.00 per month

Benefits:

- Provident Fund

Work Location: In person

📌 Commission & MIS Executive (India)
🏢 Tirumalla Tirupati Credit Multistate Credit Society
📍 India