Accounting Ops Assistant Analyst - LD&T - Snacks
New Cairo, Egypt
Finance
281049BR
Auto req ID: 281049BR
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 (Snacks)
• 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; (Snacks) :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 matrics 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
#LI_AMENA
Qualifications/Requirements
• Bachelor’s degree in Finance or any relevant discipline.
• From 0 - 1 year of experience in similar role
• English Language Proficiency is a must
• Excellent Analytical skills
• Excellent Communication skills
Relocation Eligible: Not Eligible for Relocation
Job Type: Regular
.png)