Accounting Finance:CESA-Monthly Report-Surcharges

Overview

BC Small Appliance and Power Tool Recycling Program CESA has identified specific product categories that we are required to submit recycling fees on behalf of our retail pharmacies.

We are responsible for submitting annual reports based on surcharge type 6 as of 2022 (previously on a monthly basis). Data is coming from our invoice records based on the item master surcharge table. Our Steward number is 1267.

Contacts

The main contact is the Director, Purchasing & Distribution John Targett and the alternative contact is the Manager, Finance Nancy Ng. Please direct all questions to the Director, Purchasing & Distribution.

Generate Surcharge Report

1. Annual remittance reporting will include period of January through December and the payment expiry date will be January 31^st after the remittance period.
2. In the first week of each year, generate the following report (csv) for the previous year. In ASW – system management – query manager – run a query request. Select – 'surcharge' – enter date range for previous year, enter surcharge type 6 and press 'enter'
3. Once report has finished running (typically only a few seconds) go to superserver/staging/nancyn/ - file name should be 'surch.csv'
4. Open file – sort by column 'D'
5. Copy data to EPRA Fee worksheet (use most current fiscal year) EPRA Worksheet
6. Create sub-totals for each type
7. Print sheet and save file

Submit Annual Report to CESA

1. We are now ready to submit our annual fees to EPRA. Log into web browser – go to https://www.cesareporting.ca
2. Click Stewards
3. click Report & Remit
4. Enter User Name: 'uniPHARM' and Password: 'not available'
5. Click Log in
6. Mark File/View Reports and select the applicable period
7. Enter the quantity for each applicable item. (the total fees should match your worksheet)
8. Click Save and Continue
9. Enter description of methodology sales to BC customers from uniPHARM's inventory
10. Click box to confirm that brand listing is up to date and enter applicable date
11. Click Save and Continue
12. Click EFT (Electronic Fund Transfer
13. Click Save and Continue
14. Click box to agree
15. Click Submit Report
16. Click Ok
17. Click Download Annual Invoice as PDF
18. Print Invoice and attach with printout of worksheet
19. Forward to Payroll & Benefits Administrator for processing
20. Click Log out to logout of CESA