Responsibilities:

• This would involve checking our bank account daily for cash payments and determining if a corresponding Manufacturer Excel file has been received (in most cases, the Excel file is sent when the Manufacturer executes the payment to us).  If a file has not yet been sent by the Manufacturer, this resource would reach out via e-mail to the Manufacturer to obtain the file.

• If there is a payment per our bank account, resource would need to identify and provide descriptions for the payment based on the Manufacturer file so that Accounting can book the payment in the GL with the appropriate descriptions

• Upon receiving manufacturer file, the resource would review the file for any payments to those accounts on our LPP Advance program

  If there are manufacturer payments associated with an account for which the GPO has provided advanced payments to the account, the resource would be responsible for logging that payment from the Manufacturer on our Excel spreadsheet which is used to track recovery of advanced payments.

• In order to meet and improve upon our current KPI for rebate payment to members, this resource would also be responsible for preparing the Excel documentation that we use to reconcile the manufacturer payment to our estimates.  This involves:

  Summarizing the manufacturer data in a pivot table format in Excel, Extracting the GPO’s Value Report either from Power BI or the Excel spreadsheet provided to us, setting up a comparison of the Manufacturer payment by parent account to the GPO’s estimated payment by parent account per our Value Report, and highlighting any variances

• If time permits, the associate could research discrepancies to determine source of error.  Or the associate could hand off the file to a Senior Analyst to do more extensive research. 

• Upon completion of file preparation, upload a payment file into SAP in order to meet our stated KPI’s.  Initially, we would require that payments are made within 30 days after receipt of funds from Manufacturer, but we would want to quickly move to a 15 day turnaround for payment once the resource is fully trained.

• ​The payment process requires SAP processing knowledge in order to create transaction registers and calculation runs.  The calculation runs created would then require SAP approval by a manager or director on my team in order for payment to be extracted by AP.

• Upon completion of payment by AP, this resource would send out the rebate notification letters via email to all practices receiving rebates for the products just processed.  We have a template that can be used to fill in the relevant information, and the process is performed via a mail merge in Word.  This notification process is being reviewed for automation in 2026; therefore, the mail merge work would be performed until such time this is automated.

• This resource would be responsible for logging dates of cash receipts from Manufacturers as well as GPO payment dates on an Excel spreadsheet so that we can track calculation of our KPI’s.

• Associate would be responsible for completing tasks such as entering void and reissue requests into the AP TMR system on MS PowerApps.

• Associate may also be asked to assist with baseline reconciliations, which involves validating manufacturer calculations of member baselines for performance rebates

 

Experience:

• Minimum of 5 years preferred.

Education: 

• Would prefer a 4-year degree in the fields of Accounting or Finance.

.

Skills and Knowledge:

• Intermediate Excel skills (Pivot tables, VLookups, and various formulas)

• SAP Vistex skills (training to be provided) using the various t-codes for:

• Settling Rebates

• Running reports

• Looking up practice payment codes and banking information

• Organizational skills and sense of urgency

• Ability to run Sales reports using Business Objects webi as well as the GPO’s Power BI application

What Cencora offers

​Benefit offerings outside the US may vary by country and will be aligned to local market practice. The eligibility and effective date may differ for some benefits and for team members covered under collective bargaining agreements.

Full time

Affiliated Companies

Affiliated Companies: Cencora Costa Rica Limitada

Equal Employment Opportunity

Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.

The company’s continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory.

Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email [email protected]. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned