Accounting Ops Assistant Analyst - LD&T - Beverages

Job Description

Auto req ID: 208342BR

Job Description

PepsiCo’s strength is its people. Winning together is all about respect for one another’s rare traits, backgrounds, perspectives and experiences. Our teams reflect the diversity of our customers and our communities, breaking down barriers and winning awards.
Around the world, we're working hard to give people the tastes they crave and the nutrition they need. We dream globally and act locally, constantly innovating to sustain our planet, our people, our communities and our business practices. As a global food and beverage company with brands that stand for quality and are respected household names such as Quaker Oats, Tropicana, Gatorade, Lay’s and Pepsi-Cola, we are committed to Performance with Purpose; pushing to be best and fully committed to the people we share the planet with.

Financial Reporting:
Adherence to closing agenda timeline
Prepare the monthly inventory physical count procedures across all locations
Follow-up with plant controllers to resolve all issues that may rise during the count process
Ensure that the count is performed according to Pepsico’s policies and procedures
Communicate/analyze physical count results and provide justification to management regarding the count differences
Get the approval of management as per the SOA on the count differences and reflect such differences on SAP
Prepare the inventory reserve analysis, secure needed approvals and ensure proper recording. This reserve analysis consists of; Finished goods, Raw Materials & Spare Parts.
Monitor the inventory in transit between all locations and warehouses. Investigate for any abnormal activities in the transit areas
Check the unit price per category in B/S vs. COGs
Update the FG auxiliary report with the PBI variance capitalization manual entry (Beverages)
Check the ending balances on Inventory GL accounts are reconciled with the Auxiliary reports for each inventory category
Ensures no negative inventory stocks at month-end
Update the supplier allocation sheet: R&P ending stock from auxiliary report, receipts from MB51, PO price/unit t-code ME2N
Monthly tracking for breakage, damaged products and expired products by; (Beverages) :DC ,Price point, SKU
Write-off process
Responsible for the write off process across all locations
Prepares the write off analysis and secure the needed approvals
Performance Management reviews:
Conduct Monthly and Quarterly detailed Balance Sheet review for all Inventory accounts together with the necessary aging and COC
Highlight of any balance sheet risks to management
Prepares monthly inventory deck comparing actual vs. previous month and last year
Issue monthly Operations Deck
Audit & Compliance:
Support both external and internal audit on costing related requests
Ensure business compliance with Statutory, Legal and Taxation requirements, PepsiCo corporate and local business policies & procedures, and ethical business practices
Partner with BPO (Business process Owner) and CO (Control Owner) in GCS and Fraud risk assessment, monitoring self testing and remediation of failures
Update GCS MIM process
Ensure timely closure of; Internal audit remediation and track progress & BAIC issues
Ensure adherence of SoA as per approved local policies and enforce execution
Ensure timely GCS testing (Quarterly)
Perform sudden visits to all warehouses to perform sudden counts
Business Partnership:
Review all SC contracts and evaluate costs
Attend S&OP meetings and engage to enhance MRP process
Planning and Forecasting:
Partner with Supply chain and planning finance to develop and track financial metrics and validate assumption for productivity projects to ensure tangible savings are delivered to P&L
Partner with Planning Finance to ensure working capital forecast accuracy and improvements through Inventory (DII) and Cash Flows Analysis
Special Projects:
Identify scope for process improvements and interventions from time to time to achieve process simplification / better controls / process standardization / accounting / outsourcing
Lead & partner with BIS to implement system enhancements of COGS and inventory management areas


Bachelor’s degree in Finance or any relevant discipline.
From 1-2 years of experience in a similar role
English Language Proficiency is a must
Excellent Analytical skills
Excellent Communication skills

Relocation Eligible: Not Applicable
Job Type: Pipeline