Jobs in Egypt - Accounting Ops Assistant Analyst at PepsiCo

Accounting Ops Assistant Analyst at PepsiCo

Location: Nasr City

Job Description:

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

Job Requirements:

• 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

To Apply:
https://www.pepsicojobs.com/main/jobs/208342BR?lang=en-eg&previousLocale=en-US

Tips for updating your Resume:
https://www.facebook.com/CareerAdvancers/photos/a.398704733586115/2697100093746556/?type=3&theater