You are in charge of booking and analyzing 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.
Qualifications- Advanced Excel
- SAP
- Fluency in French
- Be logical, rigorous
- Love to work and manipulate numbers
- Be comfortable with discount calculations
- Ability to synthesize for reporting
- Good internal and external interpersonal skills
- 0 to 1 year of experience in a dispute analyst position
- Level BEP to BTS in accounting Degreed +2/3
- Able to investigate issues on his/her own (autonomous)
- Very agile in calculation and analysis
- Strong synthesis skills: be able to share numbers in an efficient manner to Sales Team
- Ability to build a partnership with Sales, with a Control point of view.
- Time flexibility (more workload on last day of the month, need to stay connected later than other days)
