Management Information System Executive

Company Description
Skytron Electronics LLP, based in Ahmedabad, Gujarat, specializes in the distribution of Consumer Electronics, Consumer Durables, Mobile devices, and Mobile accessories. The company has collaborated with prominent brands such as Realme, HMD, Fire-Boltt, Shkod, Infinix, Dizo, Boult Audio, Iffalcon, Sansui, and Gizmore. With a reputation for excellence, Skytron consistently delivers high-quality products and services that cater to customer needs.

Job Title:

MIS Executive (Finance & Operations)

Role Objective  To maintain, analyze, and report on critical business data to ensure financial accuracy and operational efficiency. The ideal candidate will bridge the gap between day-to-day accounting and high-level data reporting, ensuring all ledgers are reconciled and outstanding balances are monitored.

Key Responsibilities & "Jobs to Do"   Ledger & Account Management:
Maintain and update the Account Ledger to ensure all financial transactions are recorded accurately.
Reconcile accounts to identify and resolve any discrepancies between internal records and external statements.
Receivables & Outstanding Tracking:
Monitor OUTSTANDING payments from clients or vendors.
Generate aging reports to highlight overdue accounts and support the collections team.
Transactional Processing:
Record and track Purchase entries to maintain up-to-date inventory and liability data.
Manage Cash and Cheque Receipts, ensuring all physical payments are correctly logged into the system.
Returns & Adjustments Management:
Handle DOA (Dead on Arrival) Replacements, tracking faulty inventory and ensuring timely replacement or credit.
Process Cancelled Order Sales Returns, adjusting inventory levels and sales figures accordingly.
Banking & Reconciliation:
Oversee Banking and Adjustment entries, ensuring bank statements align with the company’s internal cash flow records.

Candidate Qualifications

Education:

Bachelor’s degree in Commerce (B.Com), Finance, Business Administration, or a related field.
Technical

Skills:

* Strong proficiency in MS Excel (must be comfortable with VLOOKUP, Pivot Tables, and Data Validation).

Experience with accounting software (e.g., Tally, SAP, or Zoho Books).

Experience:

1–3 years of experience in an MIS, Data Operations, or Accounts Executive role.

Core Competencies:

High attention to detail (crucial for managing DOA and Sales Returns).
Strong analytical skills to interpret "Outstanding" reports.
Ability to meet strict daily and monthly reporting deadlines.

Expected Deliverables   Daily:
Cash/Cheque receipt logs and updated Purchase registers.
Weekly:
Outstanding Aging Reports and DOA tracking status.
Monthly:
Fully reconciled Account Ledger and Bank Reconciliation Statements (BRS).