Control & Reporting Asst Analyst

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.
  
  

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