Rebates Supervisor at Masscash Holdings (Pty) Ltd

Purpose of this role: 

• To check and process rebates on the system; reporting and other ad-hoc rebates related duties. Supervise the Rebates Administrators.

Job specifications/responsibilities will include the following: 

Oasis Notification

• Oasis notifications are received daily from the rebates administrator
• Check to ensure that the information on the Masterfile and system (Great Plain) agrees to the oasis contract. Rectify any errors to ensure data is 100% accurate.
• Additional Deduct/Change to Rebate Rate (payback) and settlement discount rate must be changed accordingly
• Oasis notification needs to be compared to GP. Ensure that the rate is unchanged.
• Create an additional master file /payback/settlement discount schedule which indicates the old and new percentages ie if there is any movement in the rate.
• Indicate the period applicable for the change. The impact of this needs to be processed into GP.
• Compare contract start date to end date and ensure that only additional income raised is applicable to data range.
• Important to ensure that only rate differential is processed into the system

PFI not in PSDISC

• Extract report 79 for all suppliers with unlink bar codes for the relevant month
• Items that are not linked need rebates to be claimed
• Based on the bar code and product description claim the relevant rebate applicable for the supplier
• Depending on the Supplier differentiate between a collect versus a deduct supplier and process into the system accordingly.

PFI (Weekly-Monday)

• Upon completion of creditors import and notification via email from creditors department Extract the list of all unlink products
• Place a copy of the unlink extract on the rebates folder with a relevant date ( date of extraction)
• Extract report 64 to identify the MREB suppliers and the unlink vendors need to be classified as either SREB or MREB suppliers
• Intercompany suppliers, Brown sundries, SREB suppliers no further action required
• Only MREB supplier further action required on GP i.e. link to the relevant category based on description of item

Receipting

• Analyst must compare that what the Supplier has made – agrees with what is in the system. If not this must be investigated and the discrepancies / differences must be resolved and corrected before inputting into the system.. This is to be done per store / per analysis.
• Some Suppliers pay directly into the bank account for rebates due to Cambridge
• Split must be obtained from the relevant supplier for the payment per store
• Any payment for KZN must be paid over to KZN
• Remaining stores income must be receipted against the 251-01-002 account
• Responsible for the completion of Supplier accounts
• Expected date of payment for Unilever is between the 16 to18 of each month. Nestle is the 22-25 of each month
• Follow up needs to be done monthly with supplier and the banking team to confirm whether money has been received for the month

Monthly Billings

• Capture the ad-hoc(AH), Contractual Income (CI) and AA BILLINGS for the Group, National office and DC using the macro method
• Ensure the billings are signed by both buyer and supplier
• Ensure that the billings captured on GP agrees from a value perspective to the actual billing and allocated to the correct supplier
• Ensure that no duplicate billings are processed.
• Check that detail on the billing matches the GL allocated; if not amend and correct.

Ad-hoc

• Administration duties related to rebates function
• Reconciliation of 251-01-003
• Running Macro
• Processing journals
• Analytical review to ensure the effective rate is correct per region
• Growth control
• Queries from suppliers
• MR Analytics to be performed in line with business requirements.
• Provide explanation for all rate changes (particularly when down)

Requirements:  

• Matric essential plus tertiary qualification or progress towards qualification; or experience in a related finance position.3-4 years related experience in a retail finance environment with focus on administration. Rebates experience preferred.
• Supervisory experience preferred.
• Advanced excel skills; strong competency on VLook up and Pivot tables.