11+ Excel Modeling Jobs in Delhi, NCR and Gurgaon | Excel Modeling Job openings in Delhi, NCR and Gurgaon
Apply to 11+ Excel Modeling Jobs in Delhi, NCR and Gurgaon on CutShort.io. Explore the latest Excel Modeling Job opportunities across top companies like Google, Amazon & Adobe.
PythonWhat you will do:
- Creating and updating proprietary models/spreadsheets for the prospective investments
- Analysing financial information and conducting analytic and strategic research.
- Inputting data into proprietary financial models and ensuring the accuracy of data and output based on the data.
- Creating Automations using VBA and other tools wherever needed.
- Compiling historical data in respect of stocks and companies from publicly available sources.
- Updating and maintaining databases to track relevant financial, economic or other indicators which may be relevant to the sector and/or region under coverage
- Assisting with other company and industry related analysis as may be required by the Fund Manager
- Monitoring relevant market news and information
- Assisting with the preparation and development of research reports, industry primers and marketing presentations.
- Financial Modelling Experience is a must and a person should be excellent at this. This is the main part of the job along with research on the Financial Numbers
- Excellent understanding of Financial Statements and Accounting Standards.
- Qualified CA
- Financial Statements Audit experience preferred
- The ability to work independently and proactively
- Person should be passionate for Equities
- Strong proficiency in Advanced Excel, VBA.
- Proficiency in data science tools and languages (SQL and Python) will be considered as a great positive but not a necessary requirement
About Company
Our client is an integrated workforce management software platform offering intelligent automation for daily work orders management, housekeeping activities, facility maintenance, scheduling & labor management, and time & attendance purpose-built for the hospitality market and another dynamic scheduling environment.
Responsibilities
• Monthly book reviews and analysis of accounting books for India and Overseas entities - UK, US, Singapore & China.
• In charge of inter-company transactions and reconciliation.
• Perform monthly, quarterly and year-end closing, and preparation of financial statements – standalone and consolidated.
• Assist in developing/maintaining monthly reports of revenues and expenditures.
• Coordinate with foreign entities’ accountants, consultants and auditors for timely financial reporting and filing.
• Convening of Statutory audits for all the regions – India, UK, US, Singapore and China.
• Review and interpret financial reporting requirements, rules and regulations.
• Statutory compliance management like direct taxes, indirect taxes as well as payroll taxes for various geographies.
• Helps with different accounting fields, including accounts receivable, accounts payable, fixed assets, journal entry review, etc.
Requirements
• Chartered Accountant with 4 to 7 years of relevant years of experience.
• Proficiency in Microsoft Office Suite (MS Excel & MS Word).
• Effective oral and written communication skills. Strong command over written and spoken English.
• Strong hands-on experience in General ledger transactions, preparation of financial statements and MIS reporting.
• Experience in convening statutory audits.
• Experience in Transfer Pricing will be a value add
About Company
Our client is an integrated workforce management software platform offering intelligent automation for daily work orders management, Housekeeping activities, facility maintenance, scheduling & labour management, and time & attendance purpose built for the hospitality market and other dynamic scheduling environment.
About the job
As an Assistant Manager – Finance & Accounts, you would be responsible for managing Accounts payable, Banking & Payments, Monthly Closing and Reconciliations, Statutory Filings - Audit & Secretarial and other related activities.
Roles & Responsibilities:
• Daily & Weekly review - Vendor bills, employee expense reimbursement & other transactions according to stipulated guidelines.
• Preparation of weekly payment tracker file and weekly payment uploads in different banking portals
• Corporate Card transactions review & reconciliations.
• Maintain Fixed Assets Register.
• Coordinating with Account Executives, Vendors & Internal teams on routine stuff
• Weekly & Monthly bank reconciliations in Intacct for all the 5 entities.
• Petty Cash Management & Payouts.
• Imprest Accounts reconciliations.
• Monthly TDS - transaction verification and payments.
• Accruals and Prepaid Exp Tracker - Booking of accounting transactions & completion of reconciliation statement on monthly basis.
• AP Ageing reconciliation with Trial Balance.
• Inter Company reconciliations – monthly.
• Statutory Monthly & Quarterly Tax Returns - Overseas & India (VAT & GST).
• TDS, GST & VAT Returns - Data validation and coordination with consultants for filing
• Foreign Lability & Assets Report (FLA), MSME Returns, MCA filings, APR filings, ROC and other related filings
• Board Minutes - Data sharing and coordination with consultants.
• Tax Returns filings verification.
• Assistance to Internal teams in Annual Audits.
• Project assigned by Finance Head & Finance Manager.
Requirements:
• Master’s Degree in of Commerce (M. Com)
• 7-9 years of relevant experience
• Robust oral and written communication and presentation skills
• High degree of computer literacy, working knowledge of Microsoft Office suite, especially MS Excel
• Experience in any ERP like Quickbooks, Intacct, Tally, Expensify etc.
• Strong attention to deadlines and detail – ability to handle multiple tasks simultaneously.
Candidate should have overall exposure of accounts and finance (Including GST, TDS, Financial reporting, Monthly & Annually closing, MIS, payroll & Accounts payable)
Must be familiar with e-commerce business and have a good understanding of Marketplace & inventory-based business models, COD & Courier Freight Reconciliations.
Eager to explore new areas and excited to work with business teams for problem-solving.
Must be able to own his work and manage the timelines
Should have a long term mindset not looking for short term salary hike.
Good team player, hard-working, should have the ability to manage the cross-functional stakeholders
Should have a good understanding of Excel, ERP & Tally and able to work with large data sets in excel knowledge of SQL will be an added advantage.
Extramarks is leading the Education Technology sector in India by providing 360⁰ education support to learners through new age digital education solutions. These solutions are used by schools in class room for imparting education and by students at home to make learning easy and effective. Keeping pace with globalization and technology in education, Extramarks empowers young learners to step in with the latest technology and have anytime-anywhere access to quality learning. In a very short period, Extramarks has become extremely popular among schools and students. More than 8000 schools use digital learning and technology solutions of Extramarks across India, Singapore, Kuwait, UAE and South Africa.
Extramarks Learning App allows students to learn at home at their own pace and space and provides complete educational support eliminating the need of a tutor. The three pronged pedagogical approach of Learn, Practice and Test ensures better learning outcomes for students. All concepts are first explained in an easy to learn manner with the help of rich media then the students are allowed to practice the concept. Virtual Practicing modules and Q&A allow the retention of knowledge that is tested on a robust teaching platform to identify the learning gaps.
Extramarks is currently in the process of scaling up rapidly and is looking to hire for the position of Sr. Executive- Accounts , to be an experienced professional with unique skill who stretches from strategy to execution. Extramarks is driving student learning through data driven techniques by providing personalized learning recommendations to the students.
Job Role: Sr.Executive – Accounts
Job Overview
Technically sound across various areas of finance including :
Stock Audit and its valuation,
Knowledge of Cost Centers,
Working Knowledge of TDS Compliances, GST Return
Finalization of Balance sheet & Statement of Profit and Loss A/c,
General Accounting, Tally, Billing, vouching & verification,
Bank reconciliation, Payable/Receivable Reconciliation,
Handling of Account Receivables & Payable management (Ageing Report, Reconciliation, and Forecasting),
Preparation of documents for financial related services
Preparation of Cash Budget, MIS Report.
Will be a responsible member of the Finance team. Following criteria are essential:
- Ability to work with teams and across departments with a positive attitude
- Willingness to work hard and for long hours when required
- Ability and willingness to make changes and innovate
- Ability to analyse and prepare various MIS and monthly/daily reports
- Positive attitude and excellent communication skills
Qualification
Should have 85% plus marks in 10th and 12th exams.
B.Com.
What you will do:
- Maintaining day to day books of Accounts and General Ledger Accounting
- Maintaining Bank Reconciliation Statements and Reconciliation of all Debtors & Creditors.
- Managing Payment of TDS & Filing of E-TDS Returns Quarterly, Payment & Filing of any other Statutory Payments (PF, Profession Tax etc.)
- Maintaining cash transactions & petty cash book, day to day cash & bank transactions, online payments (Staff Salary & other expenses)
- Managing vendor accounts, preparation of cheques, online payments
- Handling Debtors collection & follow-up
- Ensuring Finalization of Balance-sheet & P&L Account
What you need to have:
- Must have 2 plus years of experience in Accounts.
- Tool/ Software - Zoho books
- BCom/ MCom/ CA inter can apply
- Should have good written and spoken English.
- Motivated, self-starter individual with high level of integrity, intensity and activity with a can-do attitude.
- Ability to understand work priority and execute them accordingly
- Disciplined process oriented work style with good knowledge of GST, Invoicing and other Indian Accounting standards
experience- 1-5 years of experience in CA firm
knowledge - filing GST and TDS returns, bookkeeping, exposure in audits.
Are you a Finance enthusiast and can handle daily finance processes with ease? Here is a role where you will work with a trendy brand and grow with the brand.
Our client is the most sought after traditional Indian outfit manufacturing and exporting company. Their contemporary and stylishly designed clothes are full of unique patterns, matchless embroidery, gorgeous mirror-work and beautiful block prints.
Almost a decade old, it is a venture committed to bring together a varied range of traditional crafts and techniques of dyeing, weaving, printing and hand embroidery. The founders have dedicated their life to promote Indian Block Prints and provide employment and Hand-Embroidery training to women so that numerous underprivileged women can be empowered.As the Accounts Executive, you will manage all the accounting duties including completing multiple ledger reconciliations, journal entry preparation, and participating in financial month-end closures.
- Having knowledge of time office and payroll processing.
- Managing payroll accounting & its controlling.
- Handling reconciliation of primary and secondary sales stock and preparation of data for GST return (GSTR-1 & 3B)
- Handling GST audit, TDS filling return and payment/refund processing.
- Coordinating with all the internal departments.
- Making PCS rate payment.
- Maintaining accounting and book keeping.
- Managing expenditures within allotted budget.
What you need to have:
- Having a B.Com degree is a must.
- Good understanding and experience in FMCG sector, especially e-commerce in handling finance.
- Must have good working knowledge of excel.
- Familiarity with finance and accounting regulations/processes.
- Good communication and interpersonal skills.
Experience: 6 to 7 years
Annual CTC: Rupees 3,00,000 to 4,00,000
Perform daily reconciliation of accounts between Geneva and Custodian/Prime Broker.
Monthly investigation on Reconciliation discrepancies and verify all the transactions (Independently
complete cash, portfolio and capital reconciliations and investigate and resolve any discrepancy).
Prepare monthly financial reporting package for Hedge Funds, including the determination of "Net
Asset Value" and
prepare the Statement of Asset and Liabilities and Profit and Loss Statement
Ensure Fund income and expenses, including management and performance fees, are accrued for and
are in accordance with relevant accounting standards (Calculation of Incentive Fee and Management
Fee).
Accurate and timely processing of all capital activities including subscriptions, redemptions,
transfers, rollups, capital commitments and calls.
Derive pricing for portfolio investments. Updating status reports.
Cash Management-managing the daily cash flow of trades and monitoring fund cash-flows.
Process incoming and outgoing cash movements related to capital activity.
Creation and maintenance of investor information including payment models and contacts.
Preparation of Investor and Client reports including Audit confirmations, Trade confirmations etc.
Communicate the transactions associated with the fund(s) and work closely with internal and external
clients to provide accurate and thorough accounting packages.
Correspond with external investment managers regarding day-to-day fund inquiries including entering
security trades, fee, payments, cash position breaks, and reconciliations. Client engagement and a
dedication to quality service is a must for success.
Requirements for this role include:
University degree or equivalent that required 3+ years of formal studies of Finance/Accounting
principles
2+ year(s) of accounting experience for financial instruments (equities, fixed income, and derivatives),
operation of capital
markets, and life cycle of trades. Well versed with all financial instruments
Complete procedural knowledge of fund accounting is a must. Trade Booking, Cash reporting,
Exception analysing, reconciliation of assets and cash, Post pricing issues etc.
2+ year(s) of data entry experience that required a focus on quality including attention to detail,
accuracy, and
accountability for your work product.
2+ year(s) of experience using MS-Excel that required you to use Formulas, Tables & Formatting,
Conditional Formatting,
Charting, Pivot tables & Pivot Reporting.
2+ year(s) of experience in a service-oriented role where you had to correspond in writing or over the
phone with external
customers.
Ability to work regularly scheduled shifts from Monday-Friday.
Desired qualities:
A drive to broaden one’s knowledge of the financial services industry by learning new concepts and
systems and taking the
initiative to apply it to daily work assignments.
Attention-to-detail to ensure that all deliverables consistently meet the highest standard of quality
and accuracy.
Positivity and collegial approach in assisting both colleagues and clients and the ability to work in
team environment.
Curiosity, critical thinking and attention to detail: Whether it’s to identify a solution to a problem or
possibly help
implement a more efficient process or procedure, your skills have a place in our business.
- Developing and managing annual and multi-year budgets that are adequate for the organization’s needs including preparation of periodic budget forecasts
- Preparing and maintaining cash flow analysis as needed
- Ensuring timely preparation of Standalone & Consolidated Financial Statement
- Taking responsibility for GST, TDS, FEMA and other Statutory & Regulatory Compliances
- Taking responsibility for external Stat Audit and Other regulatory tax filing
- Ensuring operational compliance with policies, procedures and regulations for any necessary entities
- Processing vendor payments
- Handling Employee reimbursements including managing employee credit card charges and reconcile credit card accounts
- Ensuring Timely preparation of MIS reports
- Responding to inquiries from internal stakeholders regarding budgets, deposits, disbursement and granting reporting requests.
- Processing payroll, reporting payroll taxes and ensuring compliances thereof
- Performing basic office management duties as requested
What you need to have:
- Should be MBA Finance / CA with 5 to 8 years work exp
- Excellent in MS Excel & MS Power point
- Knowledge of Tally
- Experience in ecommerce will be an added advantage
- Knowledge on ERP implementation
- Excellent communication & presentation skills -Ability to interface with Management
Follow Cutshort