Amit Ranjan
Financial Analyst
Indore
Summary
Academic Objective: - To gain in-depth knowledge in the field of Accounts, Taxation, Audit, and Financial statement analysis & reports & eventually serve at the highest level.
Social Objective: - To be a man of trust, honesty & confidence at all levels.
Overview
11
11
years of professional experience
Work History
Financial Analyst
LINAMAR INDIA PVT LTD
5 2015 - Current
- Ensure compliance with company rules, policies, and regulations
- Maintaining and reconciling accounts as well as preparing reports; creating, documenting, and posting complex journal entries; recording various intercompany transactions and cost allocations
- Performed monthly reconciliation of critical and non-Critical accounts like Inventory, Fixed Assets, Bank, A.R., A.P, Provisions etc
- Responsible for daily, weekly, and monthly account activities including timely and accurate accounts payable, accounts receivable, bank reconciliation of all corporate accounts, cash receipts, disbursements, invoicing, and preparation of daily bank deposits
- Manage vendor & customer issues and reconcile Debtors & Creditors statements on regular basis and Issue of Debit & Credit note to customers & vendors for rate difference & short supply of goods
- Processing Local and import vendors payment through check and NEFT & RTGS
- Preparing daily debtors outstanding statement and following up with clients for timely recovery of outstanding payment, Ensuring timely payment
- Bi-Weekly flash is prepared and submitted to Corporate with details like Estimated Cash receipts, estimated payroll disbursement, estimated capex payment, and estimated non capex suppliers' payment for Current 2 weeks (Actuals) and next 4 weeks (Projected)
- Summarizing current financial status by collecting information; preparing the daily profit and loss statement, and sales reports
- Monthly Statutory Payments before due date such as TDS, PF, GST, ESIC etc
- Ensuring GST compliance and preparing GST working and Filling of eReturns periodically
- Preparing monthly and quarterly TDS working and payment
- Assist and support tax consultants and professionals in handling taxation matters
- Answer to customer questions about tax issues and respond to customer inquiries about their tax problems
- Planning and executing monthly / quarterly / annual closure schedules; providing monthly financial statements; administering the monthly closing process
- Variance analysis done for major changes with actual budget approved
- Variance analysis between Monthly budget vs Actual amount
- Monthly budget preparation and monitoring
- Supported annual budgeting process by providing detailed analysis of projected revenues and expenses
- Prepared cash flow projections, cost analysis and monthly, quarterly and annual reports
- Improved cash flow management by implementing effective accounts receivable and payable strategies
- Prepared various schedules required for Statutory audits like AP, AR, related party transactions, Purchase register, MSMED, and Inventory etc
- Supporting Statutory audits by providing information & answers to auditors
- Managed relationships with external auditors to facilitate smooth audit processes while addressing concerns promptly
- Collaborated with cross-functional teams to develop strategies that improved overall company performance metrics in finance-related areas
- Ensured accurate record-keeping by maintaining up-to-date knowledge of accounting principles, industry-specific regulations, and software tools available for use in daily tasks
Accounts Executive
SMR Automotive Systems India Ltd.(Motherson Group)
05.2013 - 04.2015
- Day to day accounting entries passed in ERP like purchase, sales, Journal Voucher, cash, payment, maintaining cash voucher and more
- Handling the Accounts Payable as per Purchase order, terms, and conditions
- Checking of invoices as per GRN & Purchase orders
- Perform intercompany invoicing & intercompany reconciliation
- Calculation and Processing of Salary with Coordination with HR
- Handling petty cash & making entry the same
- Preparation of Bank reconciliation on Excel &MFG PRO
- Monthly Statutory Payments before due date such as Profession Tax, PF, Services Tax, TDS, etc
- Monthly payment and Filling of e-Returns of Professional Tax
- Handling and Calculating TDS of Employees and others
- Handling Bank payment transactions through RTGS & NEFT or Cheque
- Contact for Statutory and Internal Auditors for providing requisite information
- Monthly Reporting to Management - at branch level
- Managing vendor aging and vendor payments on time
- Processing Local and Import supplier payment
- Reconciles vendor accounts on periodical basis and getting confirmation
- Verification of the transactions to comply with financial policies and procedures
- To do provisions for monthly, quarterly & yearly basis.
Education
PGDBM -
DY. Patil Management & Research, Pune
MMM - undefined
IBMR Pune
B. Com - undefined
Allahabad University
H S C - undefined
U.P Board
S S C - undefined
B.S.E Board
MBS -
IBMR Pune
Skills
Data inputting & Analysis
Microsoft Excel
General Ledger Management
Accounts Receivable
Accounts Payable
Bank Reconciliation
Cash Flow Management
P&L Management
Variance Analysis
Financial statement analysis & reports
Forecasting
Budget Planning
Tax Compliance
Audit preparation and response
Socialobjective
To be a man of trust, honesty & confidence at all levels.
Keyimpactarea
Monthly Account Reconciliations, Statutory Compliance / Internal Control, Accounts Payable & Receivables, Cash Flow Management, Monthly budget preparation and monitoring, Supporting Statutory audits.
Skills
MFG PRO, IFS ERP, V- lookup, X-lookup, BPC, Tally ERP, MS excel, MS Word, Knowledge of Microsoft outlook 365, English, Hindi
Permanentaddress
Kuraich, Mahavir Asthan, Sasaram Bihar-821115
Personal Information
- Date of Birth: 12/14/1986
- Gender: Male
- Marital Status: Married
Timeline
Accounts Executive
SMR Automotive Systems India Ltd.(Motherson Group)
05.2013 - 04.2015
Financial Analyst
LINAMAR INDIA PVT LTD
5 2015 - Current
PGDBM -
DY. Patil Management & Research, Pune
MMM - undefined
IBMR Pune
B. Com - undefined
Allahabad University
H S C - undefined
U.P Board
S S C - undefined
B.S.E Board
MBS -
IBMR Pune