Accounting Finance:Call 2 Recycle-Monthly Report-Surcharges

Overview

GreenTrax has identified specific product categories that we are required to submit recycling fees on behalf of our retail pharmacies. We have started adding surcharges to specific items in February 2017 and submitted our first payment commencing April 01, 2017.

We are responsible for submitting monthly reports based on surcharge type 10. Data is coming from our invoice records based on the item master surcharge table. Our Call2Recycle Site ID number is 170569.

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.

• GreenTrax Contact: Wendy Riveti Wendy Riveti Tel: 1-888-665-0908

• Billing Contact: Cameron McPhedran Cameron McPhedran Tel: 1-416-307-2858 or 1-888-224-9764

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 10 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'
4. Copy data to Call 2 Recycle Fee worksheet (use the most current fiscal year) Call2recycle
5. Create sub-totals for each type
6. Check G/L 210758 to ensure that it matches with the worksheet total.
7. Print sheet and save file

Submit Monthly Report to GreenTrax

1. We are now ready to submit our monthly fees to GreenTrax. Log into web browser – go to http://greentrax.call2recycle.org/sign-in/
2. Enter Email Address: 'nancyn@unipharm.com' and Password: jt2051.
3. Click 'Go to Transaction History.'
4. Confirm brands and banners.
5. Click on the link for the month you are submitting payment. (EX 2018-M03 = March)
6. Enter Sales for each type
7. Click Submit & Generate invoice
8. Double-click on the invoice (pdf file)
9. Click 'sign out'
10. Print the invoice and forward to Payroll & Benefits Administration with worksheet attached.