CA Experienced 2-3 yrs required at pepsico as Finance Coordinator
Tenure Commitment- 2yrs
This role would be primarily involved in the following activities:
">Acting as the first person responsible
for consolidating results and all reporting related requirements to AMEA">Acting as the first person responsible
Sector for India Foods BU in HFM reporting module
">Reporting all monthly, quarterly and
Annual Schedules to AMEA Sector within agreed timelines
">First person responsible for closing
statutory accounts and coordinating with KPMG for statutory and tax audit
for specifies legal entities
">Preparing and submitting of annual US Tax
Package to Corporate
Accountabilities:
Responsible for consolidating
results of India Foods BU
Facilitate and track closure of
all closing related issues before consolidating
>Facilitate preparation of all HFM
schedules (including FAS 109 schedules)
>Finalize results for review with
Region Reporting Manager & Region Reporting Director
>Report results and include
Hyperion reporting, QOE and other reports
>Responsible for handling all
queries that would be coming from the Sector
( Monthly, 3 days,
complexity-H)(i/p: Financials closed in SAP o/p: HFM submission)
* Prepare other monthly sector deliverables (Monthly, 5 days, complexity-H)(i/p: across finance func, o/p: Sector)
* Support the reporting manager in collation & consolidation of pre-close deck for sector review(Quarterly, 5 days, complexity- H)(i/p: CF & OF, o/p: Pre-close deck)
* Support the rep manager in preparation & consolidation of over all foods balance sheet review by Region Controller (Quarterly, 3 days, complexity- M-H) (i/p: BSR done by OF & CF, o/p: over all BSR to Region control)
* Prepare the Indian entities 5471 files to Support Centre (SC) and provide any additional information as required for back up)(Annually, 10 days, complexity-M-H)(i/p: financial stmt, o/p: 5471)
Statutory Audit
* Review the Indian accounts financials in the statutory format for FLI and LFPL(For foods) prepared by SSC
* Review all balance sheet schedules
* Prepare all details as required by the auditors before the start and during their audit
* Ensure as many issues are closed as possible
* Prepare 3CD and related annexures
* Finalise and close statutory audits
* Ensure details are provided to transfer price auditors as per their requirements(i/p: Financials from SSC/locations, o/p: Financials signed by Director)
* Prepare and submit quarterly Cash Flow Analysis (Foods) to Sector coupled with deep-dive into reasons for variance
* Perform variance analysis of Working Capital Metrics (DII, DSO, DPO etc) together with business reasons for the same
* Prepare and submit quarterly deliverables like Q schedule, GNG Reporting, P&L Analysis, Balance Sheet analysis for India Foods to AMEA Sector within agreed timelines
* Liaison with respective departments (Marketing, HR etc) for collation of data and reporting
* Prepare & submit annual deliverables for India Foods (Annually, 15 days, complexity- H)(i/p: across functions, o/p: sector)
* Responsible for handling all queries that would be coming from the Sector
Review/Approval
* Prepare & review Foods G&A on a monthly basis (3-4 days, complexity- M)(i/p: various depts., SSC reports, o/p: G&A report)
* Review of bank recon statements every month & resolution of old items lying therein for Foods(monthly, complexity-M-H, 4-5 days)(i/p: SSC bank recon, o/p: part of BSR overall)
* Support Foods HQ Reporting Manager in preparation/review of Balance Sheet Schedules for HQ related balances on monthly basis
CA
2- 3yrs of experience
for specifies legal entities
">Preparing and submitting of annual US Tax
Package to Corporate
Accountabilities:
Responsible for consolidating
results of India Foods BU
Facilitate and track closure of
all closing related issues before consolidating
>Facilitate preparation of all HFM
schedules (including FAS 109 schedules)
>Finalize results for review with
Region Reporting Manager & Region Reporting Director
>Report results and include
Hyperion reporting, QOE and other reports
>Responsible for handling all
queries that would be coming from the Sector
( Monthly, 3 days,
complexity-H)(i/p: Financials closed in SAP o/p: HFM submission)
* Prepare other monthly sector deliverables (Monthly, 5 days, complexity-H)(i/p: across finance func, o/p: Sector)
* Support the reporting manager in collation & consolidation of pre-close deck for sector review(Quarterly, 5 days, complexity- H)(i/p: CF & OF, o/p: Pre-close deck)
* Support the rep manager in preparation & consolidation of over all foods balance sheet review by Region Controller (Quarterly, 3 days, complexity- M-H) (i/p: BSR done by OF & CF, o/p: over all BSR to Region control)
* Prepare the Indian entities 5471 files to Support Centre (SC) and provide any additional information as required for back up)(Annually, 10 days, complexity-M-H)(i/p: financial stmt, o/p: 5471)
Statutory Audit
* Review the Indian accounts financials in the statutory format for FLI and LFPL(For foods) prepared by SSC
* Review all balance sheet schedules
* Prepare all details as required by the auditors before the start and during their audit
* Ensure as many issues are closed as possible
* Prepare 3CD and related annexures
* Finalise and close statutory audits
* Ensure details are provided to transfer price auditors as per their requirements(i/p: Financials from SSC/locations, o/p: Financials signed by Director)
* Prepare and submit quarterly Cash Flow Analysis (Foods) to Sector coupled with deep-dive into reasons for variance
* Perform variance analysis of Working Capital Metrics (DII, DSO, DPO etc) together with business reasons for the same
* Prepare and submit quarterly deliverables like Q schedule, GNG Reporting, P&L Analysis, Balance Sheet analysis for India Foods to AMEA Sector within agreed timelines
* Liaison with respective departments (Marketing, HR etc) for collation of data and reporting
* Prepare & submit annual deliverables for India Foods (Annually, 15 days, complexity- H)(i/p: across functions, o/p: sector)
* Responsible for handling all queries that would be coming from the Sector
Review/Approval
* Prepare & review Foods G&A on a monthly basis (3-4 days, complexity- M)(i/p: various depts., SSC reports, o/p: G&A report)
* Review of bank recon statements every month & resolution of old items lying therein for Foods(monthly, complexity-M-H, 4-5 days)(i/p: SSC bank recon, o/p: part of BSR overall)
* Support Foods HQ Reporting Manager in preparation/review of Balance Sheet Schedules for HQ related balances on monthly basis
CA
2- 3yrs of experience
