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