Ranjan Gupta profile photo 1 on Tal

Ranjan Gupta

Sr. Finance Executive @ HT Media Group | Debtors MIS BRS,Collection,Ex Mynd FP&A Aspirant

Delhi

5+ years of work experience

HT Media Group
Sep 20223 yrs 10 mosPresent

Daily All India Collection Summary • Mis-All India Debtors & DSO MIS • AI Plan vs ActualHT,Mint • AOP Mint delhi • AI Policy Compliance • Blocking of Agencies • Followup HT(Mumbai,Moha) & Mint location • All India SSC Code open-Verifier Level-2 • Sales Promotion IO to HT and Mint locations • Working of scheme write back and excess Revenue • IND AS 115 Financing Component Working • Current and Non Current Working & Revenue recognize for disclosure purpose • Ensure All India Return Billing • Unsold billing of delhi agencies(Re Billing) • Revenue Entries • Interest of SD of mint locations • HDFC and Seal Bank Reconciliation • Review of Banking entry flow of Mohali, Mumbai • Paytm and Razorpay Refund in Bank Reco • All India subsidy checking • All India scheme review • Preparation of Mumbai scheme reconciliation • Revenue from advance recognized in last FY • Booking data • SFDC day to day issue resolution for payment
Mynd Integrated Solutions Pvt. Ltd.
Apr 20211 yrMar 2022

Revenue Recognition as per Ind as 115 of the sale of Hardware (Goods). • In SAP by performing Revrec Run of V-Satellite Company • Preparation of File relating to Sale of Services and matched with the Revenue GL’S in SAP • Preparation of Advance Billing File and match with the Advance Billing GL’S. • Preparation of Schedules of Revenue and Cogs. • Controlling of Vendor Master (Creation, Extension, TDS Codes etc.
SIS Group Enterprises
Apr 20196 mosSep 2019

Preparation of Collection Review Report on daily basis. Analyzing Unit Margin and make recommendations to the controlling officer. Preparation of ULM Sheet (Analyzing salary of 3000 employees with respect to ERP i.e. UPT). Maintain cash of branch and book-keeping. Assist branch manager in resolving financial grievances of employees. Timely and correct billing of the units under branch and ensuring it deliver to clients on or before 5th of every month. Proper stock management of livery and stores including physical verification. Preparation of Checklist and Calculation of Manual Wage due to computation error.
Mayasheel Retail India Limited
Aug 20186 mosJan 2019

Routine Office Account Management and Internal Audit Book – Keeping: Maintaining Computerized Books of Accounts of Management, Assisting in preparation of financial statements. • Responsible for Rectifying Entries and making procedure of passing entries at Front end (at store level). • MIS Reports: Responsible in the preparation of MIS reports to provide feedback to top management on Expenses. • Reconciliation: Bank, Debtors & Creditors Reconciliation and other Reconciliations with Accounts. • Auditing / Statutory Compliance: Finalizing of various accounts & liaising with internal & statutory auditors for conducting audits in compliance to the tax laws and ensuring timely payment. • Fixed Assets: Monthly capitalization & depreciation run of Fixed Assets and related issues like Input Tax Credit of GST. • Settlement Report: Responsible for Settlement process of stores. Handling the Accounting of Succession of LLP into Company. (Making new heads in System as per the requirement of Companies Act 2013 with opening Balances)

Education

CA Final, Accounts

The Institute of Chartered Accountants of India

20127 yrs2019

High School, Commerce

Rajkiya Pratibha Vikas Vidyalaya Sector-10 Dwarka

20042 yrs2006

Join Ranjan and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Ranjan Gupta on Tal

Headline

Sr. Finance Executive @ HT Media Group | Debtors MIS BRS,Collection,Ex Mynd FP&A Aspirant

Location

Delhi

Work experience

Sr.Finance Executive at HT Media Group, Sep 2022 - Present · 3 yrs 10 mos, Daily All India Collection Summary • Mis-All India Debtors & DSO MIS • AI Plan vs ActualHT,Mint • AOP Mint delhi • AI Policy Compliance • Blocking of Agencies • Followup HT(Mumbai,Moha) & Mint location • All India SSC Code open-Verifier Level-2 • Sales Promotion IO to HT and Mint locations • Working of scheme write back and excess Revenue • IND AS 115 Financing Component Working • Current and Non Current Working & Revenue recognize for disclosure purpose • Ensure All India Return Billing • Unsold billing of delhi agencies(Re Billing) • Revenue Entries • Interest of SD of mint locations • HDFC and Seal Bank Reconciliation • Review of Banking entry flow of Mohali, Mumbai • Paytm and Razorpay Refund in Bank Reco • All India subsidy checking • All India scheme review • Preparation of Mumbai scheme reconciliation • Revenue from advance recognized in last FY • Booking data • SFDC day to day issue resolution for payment

Senior Accountant at Mynd Integrated Solutions Pvt. Ltd., Apr 2021 - Mar 2022 · 1 yr, Revenue Recognition as per Ind as 115 of the sale of Hardware (Goods). • In SAP by performing Revrec Run of V-Satellite Company • Preparation of File relating to Sale of Services and matched with the Revenue GL’S in SAP • Preparation of Advance Billing File and match with the Advance Billing GL’S. • Preparation of Schedules of Revenue and Cogs. • Controlling of Vendor Master (Creation, Extension, TDS Codes etc.

Accountant at SIS Group Enterprises, Apr 2019 - Sep 2019 · 6 mos, Preparation of Collection Review Report on daily basis. Analyzing Unit Margin and make recommendations to the controlling officer. Preparation of ULM Sheet (Analyzing salary of 3000 employees with respect to ERP i.e. UPT). Maintain cash of branch and book-keeping. Assist branch manager in resolving financial grievances of employees. Timely and correct billing of the units under branch and ensuring it deliver to clients on or before 5th of every month. Proper stock management of livery and stores including physical verification. Preparation of Checklist and Calculation of Manual Wage due to computation error.

Senior Accountant at Mayasheel Retail India Limited, Aug 2018 - Jan 2019 · 6 mos, Routine Office Account Management and Internal Audit Book – Keeping: Maintaining Computerized Books of Accounts of Management, Assisting in preparation of financial statements. • Responsible for Rectifying Entries and making procedure of passing entries at Front end (at store level). • MIS Reports: Responsible in the preparation of MIS reports to provide feedback to top management on Expenses. • Reconciliation: Bank, Debtors & Creditors Reconciliation and other Reconciliations with Accounts. • Auditing / Statutory Compliance: Finalizing of various accounts & liaising with internal & statutory auditors for conducting audits in compliance to the tax laws and ensuring timely payment. • Fixed Assets: Monthly capitalization & depreciation run of Fixed Assets and related issues like Input Tax Credit of GST. • Settlement Report: Responsible for Settlement process of stores. Handling the Accounting of Succession of LLP into Company. (Making new heads in System as per the requirement of Companies Act 2013 with opening Balances)

Education

CA Final, Accounts, The Institute of Chartered Accountants of India

High School, Commerce, Rajkiya Pratibha Vikas Vidyalaya Sector-10 Dwarka