Accounting Ops Assistant Analyst - LD&T - Beverages
Pepsico -
Nasr City, CairoPosted 4 years ago83People have clicked1 open position
Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Accountabilities:
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 arise during the counting 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 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
- esponsible 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 ageing and COC
- The 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 the 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
Job Requirements
Qualifications/Requirements:
- Bachelor’s degree in Finance or any relevant discipline.
- Minimum 2 years of experience in a similar role
- English Language Proficiency is a must
- Excellent Analytical skills
- Excellent communication skills