Responsibilities

- Daily, weekly & monthly MIS reports on buyer-supplier transactions and commission
- Maintain party-wise (buyer/supplier) payment received and pending status reports
- Calculate and reconcile commission earned by the agency
- Data analysis and business performance reporting for management
- Prepare Excel/Google Sheets dashboards for daily/weekly review
- Maintain and improve internal reporting formats and systems
- Automate repetitive reports where possible
- Follow up internally (with accounts/team/records) wherever required for accurate and timely data

Mandatory Skills
- Advanced MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas)

- Google Sheets
- Solid analytical and reporting mindset
- Attention to detail in payment/commission calculations
- Basic understanding of ledger/accounts reconciliation





Added Advantage
- Google Apps Script / automation experience
- Experience in textile trading, agency, or broking business

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

Application Question(s)

- Difference between VLOOKUP and INDEX-MATCH? When would you use each?
- Write an IF formula: Below ₹10,000 = Low, ₹10,000-50,000 = Medium, above = High.
- How would you consolidate 5 separate Excel files into one Google Sheets system?
- How would you automate a weekly report that pulls data and emails it automatically?
- How would you use COUNTIF to find duplicate values in a column?

Work Location: In person

📌 MIS Executive (Surat)
🏢 Jain agency
📍 Surat