Key Responsibilities
Build and maintain MIS dashboards and reports in Google Sheets:
Consolidate data from multiple sources such as:
Accounting software exports (e.g., Tally)
Bank statements
Sales and inventory records
Prepare summary reports for:
Sales performance
Inventory status
Supplier payments & customer receivables
Profit & Loss tracking
Update reports on a daily / weekly / monthly basis
Identify data gaps and suggest improvements in reporting structure
Ensure accuracy of data and highlight mismatches or discrepancies
Document report formats and processes for consistency
Required Skills & Qualifications (Must Have)
Robust working knowledge of Google Sheets, including:
VLOOKUP, HLOOKUP, INDEX-MATCH
Pivot Tables
SUMIF, COUNTIF,
AVERAGEIF
Data validation & conditional formatting
IMPORTRANGE
Basic charts & dashboards
Ability to handle raw, unstructured, and inconsistent data:
Robust attention to detail
Basic understanding of business and accounting concepts:
Sales, expenses, receivables, payables, inventory
Ability to work independently with mínimal supervision
Good communication skills in English & Hindi
Pay: ₹15,000.00 - ₹20,000.00 per month
Perks:
Leave encashment
Provident Fund
Work Location: In person
📌 Mis Executive Thane
🏢 SHREE DIAMOND
📍 Thane
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.