FIND_THE_RIGHTJOB.

Cntrl & Rpt Asst Analyst

Egypt

Overview:

You are in charge of booking and analysing invoices for advertising participations and monitoring commercial cooperation budgets.

Responsibilities:

Booking invoices
Communicate to the DMO the commercial cooperation and budgets to be entered in SAP according to Pepsico France's internal procedures.
Book invoices for CDAs and Promo invoices on the appropriate budget and module (PS or SD) after checking the imputations transmitted by the key accounts managers
Check the applicable VAT rate according to the nature of the service
Pay invoices after validation according to Pepsico France's internal procedures.
Ensure payment of invoices within the applicable payment deadline.
Budget monitoring
Monitor budget by management year.
Analyze and monitor trade cooperation and NIP budgets highlighting discrepancies and transmit information to Key Accounts Managers
Set up monitoring and analysis of accounts to understand discrepancies, and year-end landings.
Ensure the correct receipt of all invoices and ensure the follow-up of accounts with customers and Key Accounts Managers
Closing process
Ensure Net sales is consistent along the month
Prepare all extractions from PS and SD and load the proper bookings in SAP with respect to the timelines
Book any additional bookings requested by FR Team
Reconcile Net Revenue in collaboration with Local FR Team
Ageing Balance analysis
Be a driving force in dispute resolution in collaboration with AR Clerks, Key Account Managers and customers
Review the Ageing balance 2 times a month (the 15th and 30th), anticipate and set up an action plan if necessary.
Ensure comprehensive tracking of business cooperation and Promo deductions and claim all deducted invoices from customers to clear accounts as soon as possible
Maintenance vendor data base
Make requests, to the "data stewards", to open/change the vendor accounts necessary for the booking of invoices.
Call customers to validate RIBs according to PepsiCo procedures
To be the guarantor and actor of the respect of PepsiCo's internal procedures.
Ensure the day-to-day handling of the mail, and proceed to its distribution among the various persons in charge.