Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
Education
Bachelor's degree
Must-have skills
Advanced ExcelGST FilingSAPTDSTallyZoho Books
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: India
Job Title: Deputy Manager, Accounts Company: SmileWorks Department: Finance & Accounts Location: Mangolpuri Reports to: Finance Head Experience: [6-10] years in accounts and finance Role Summary We are looking for an experienced Accounts Deputy Manager to manage day-to-day accounting operations, ensure accurate and timely financial reporting, and support statutory compliance and audits. Key Responsibilities
Oversee day-to-day accounting: journal entries, ledger maintenance, bank and account reconciliations
Handle month-end and year-end closing, and prepare MIS and financial statements
Manage accounts payable and receivable, vendor and customer reconciliations
Ensure timely GST, TDS and other statutory compliance, including return filing
Coordinate with statutory, internal and tax auditors and close audit queries
Support budgeting, cash flow monitoring and variance analysis
Review the work of junior accounts staff and guide the team
Maintain internal controls and ensure accounting policies are followed
Support management with financial data and reports as needed Requirements Required Qualifications
B.Com / M.Com or equivalent
CA Inter / CA dropout or semi-qualified candidates are welcome (CA is not mandatory)
[6-10] years of relevant accounting experience, with some time in a supervisory role Skills
Strong knowledge of accounting principles, GST, TDS and the Companies Act
Hands-on experience with Tally / ERP (SAP, Zoho Books or similar) and advanced Excel
Experience handling audits
Good analytical, communication and team-management skills
Attention to detail and the ability to meet deadlines
This guide is for freshers and experienced professionals in India preparing for the Excel round of MIS executive, accounts, operations, back-office and data analyst interviews, where a practical Excel test is common. It has 60 questions with answers in three levels: the basics every fresher must know (references, VLOOKUP, IF, SUMIFS, text and date functions, pivot tables), real work problems for 1-4 years of experience (lookup errors, dynamic arrays, slicers, Goal Seek), and senior topics such as Power Query, the Data Model, large-file performance and building a monthly MIS report. Sample data and formulas are shown as small tables with their results. Rebuild each example in Excel (Microsoft 365) as you read, then take the mock test.
Questions you may be asked
What is the difference between relative, absolute and mixed cell references?
How does VLOOKUP work, and why do you usually set its last argument to FALSE?