AR Collections Analyst - Billingual

at  PepsiCo

Overview:
The Collections Analyst is responsible for timely collection of an assigned portfolio consisting of National, Distributor, Small Format accounts. Maintaining balances at targeted DCSO levels, performing vigilant risk assessments, and completing account maintenance reviews accurately and promptly are required to mitigate risk of bad debt and the impact to cash flow

Responsibilities:

• Manage assigned portfolio of accounts, including reconciliations, collections and support on deductions management
• Execute appropriate collection strategies to improve period-end/monthly DCSO, Cash Flow and other Key Performance Indicators
• Liaise closely with KAMs (Key Account Managers) and BDMs (Business Development Managers) to solve customers’ unique requirements or reconciliation issues
• Educate customers on PBC terms and various payment/billing options to drive cash flow improvements
• Schedule periodic update status calls/reviews with appropriate KAMs to gain support and build strong partnerships
• Prepare and forward monthly packages to customers for past due invoices including appropriate proof of delivery and excel spreadsheets when required
• Comply to customer specific invoicing requirements and timelines for follow-up with a sense of urgency.
• Follow up with customers promptly on invalid claims to secure repayment
• Partner with internal stakeholders and shared services to action pricing, quantity, and rebate items
• Ensure updates to customer’s information is carried out in a timely basis to ensure accurate EDI transmissions
• Scrutinize SAP AR, DATB and review EDI reconciliations in order to identify missed electronic transmissions
• Prepare and participate in month-end risk reports and 1W1 Coaching sessions
• Develop and update monthly customer scorecards and communicate results to key stakeholders
• Consistently strive for productivity gains to minimize controllable costs

Qualifications:

• 3+ years in credit and collections in a computerized environment (preferably SAP AR application) managing relationships and collections of a variety of customers ranging from local distributors to high volume major retail accounts
• Strong reconciliation and analytical skills. Ability to engage key stakeholders in the resolution process for invalid deductions
• Strong verbal and written communication skills to work effectively with cross-functional teams and maintain customer goodwill and loyalty
• Intermediate to advanced MS Word, Excel (Pivot/Vlookup a must) and Outlook skills required
• Systems savvy (experience preferred in SAP environment)
• Post-Secondary school diploma/degree in business related field of finance/economics or relative work experience
• Enrolment in Canadian Credit Institute CCP educational program an asset but not required
• Strong time and desk management skills to identify priorities and meet deadlines/ objectives
• Ability to stay calm under pressure
• Ability to be tactful yet assertive with strong negotiation skills
• Good listening skills required to understand issues and provide solutions
• Both strong verbal and written French is required

• Manage assigned portfolio of accounts, including reconciliations, collections and support on deductions management
• Execute appropriate collection strategies to improve period-end/monthly DCSO, Cash Flow and other Key Performance Indicators
• Liaise closely with KAMs (Key Account Managers) and BDMs (Business Development Managers) to solve customers’ unique requirements or reconciliation issues
• Educate customers on PBC terms and various payment/billing options to drive cash flow improvements
• Schedule periodic update status calls/reviews with appropriate KAMs to gain support and build strong partnerships
• Prepare and forward monthly packages to customers for past due invoices including appropriate proof of delivery and excel spreadsheets when required
• Comply to customer specific invoicing requirements and timelines for follow-up with a sense of urgency.
• Follow up with customers promptly on invalid claims to secure repayment
• Partner with internal stakeholders and shared services to action pricing, quantity, and rebate items
• Ensure updates to customer’s information is carried out in a timely basis to ensure accurate EDI transmissions
• Scrutinize SAP AR, DATB and review EDI reconciliations in order to identify missed electronic transmissions
• Prepare and participate in month-end risk reports and 1W1 Coaching sessions
• Develop and update monthly customer scorecards and communicate results to key stakeholders
• Consistently strive for productivity gains to minimize controllable cost