Accounting Finance:BC Light Recycle-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 monthly reports based on surcharge type 8. Data is coming from our invoice records based on the item master surcharge table. Our Steward number is 1373.

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. In the first week of each month, generate the following report (csv) for the previous month. In ASW – system management – query manager – run a query request. Select – 'surcharge' – enter date range for previous month, enter surcharge type 8 and press 'enter'
2. Once report has finished running (typically only a few seconds) go to superserver/staging/nancyn/ - file name should be 'surch.csv'
3. Open file – sort by column 'D'BC
4. Copy data to BC Light Recycle Fee worksheet (use most current fiscal year) BC Light Recycle Worksheet
5. Create sub-totals for each type
6. Print sheet and save file

Submit Monthly Report to CESA

1. We are now ready to submit our monthly fees to BC Recycling. Log into web browser – go to Recycling (link does not work until you remove extra letters from the URL
2. Click Light Recycle
3. Enter User Name: 'UNIPHARM' and Password: 'not available'
4. Click Log in, then head over to Reporting and click on Reporting
5. Click British Columbia and select the Mark the applicable year and the applicable month
6. Enter the quantity for each applicable item. (the total fees should match your worksheet)
7. Click Save and Continue
8. Enter description of methodology sales to BC customers from uniPHARM's inventory
9. Click box to confirm that brand listing is up to date and enter applicable date
10. Click Save and Continue
11. Click EFT (Electronic Fund Transfer
12. Click Save and Continue
13. Click box to agree
14. Click Submit Report
15. Click Ok
16. Click Download Monthly Invoice as PDF
17. Print Invoice and attach with printout of worksheet
18. Forward to Payroll & Benefits Administrator for processing
19. Click Log out to logout of BC Light Recycle

500px