Accounting Operations Assistant Analyst - LD&T - Beverages At Pepsico | Finance Vacancies | 1-2 years of experience
New Cairo, Egypt
Finance
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.
Accountabilties:
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.
Qualifications/Requirements
• Bachelor’s Degree in Finance or any relevant discipline.• Minimum 1-2 years of experience in a similar role
• English Language Proficiency is a must
• Excellent Analytical skills
• Excellent Communication skills