Difference between revisions of "Accounting Finance:EPRA-Monthly Report-Surcharges"

From uniWIKI
Jump to navigation Jump to search
(Created page with "==Overview== The '''Electronic Products Recycling Association''' (EPRA) has identified specific product categories that we are required to submit recycling fees on behalf of o...")
 
m
 
(13 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
==Overview==
  
==Overview==
−
The '''Electronic Products Recycling Association''' (EPRA) 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 mid Feb. 2016 and have previously submitted past due fees starting from Jul. 1, 2012 when this program was expanded to include items that we carry.
 +
The Electronic Products Recycling Association ('''EPRA''') 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 mid Feb. 2016 and have previously submitted past due fees starting from Jul. 1, 2012 when this program was expanded to include items that we carry.
   
 
We are responsible for submitting '''monthly reports''' based on surcharge '''type 9'''. Data is coming from our invoice records based on the item master surcharge table. Our Steward number is '''RBC502999'''.
  
We are responsible for submitting '''monthly reports''' based on surcharge '''type 9'''. Data is coming from our invoice records based on the item master surcharge table. Our Steward number is '''RBC502999'''.
   
 
==Contacts==
  
==Contacts==
−
The main contact is the '''Director, Purchasing & Distribution''' [mailto:johnt@unipharm.com] and the alternative contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com]. Please direct all questions to the Director, Purchasing & Distribution.
 +
The main contact is the '''Director, Purchasing & Distribution''' [mailto:johnt@unipharm.com John Targett] and the alternative contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Director, Purchasing & Distribution.
   
 
==Generate Surcharge Report==
  
==Generate Surcharge Report==
−
#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 = '''9''', press ''''enter''''
 +
#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 '''9''' and press ''''enter''''
−
#Once report has finished running (typically only a few seconds) go to superserver/staging/nancyn/ - file name should be ''''surch.csv''''
 +
#Once report has finished running (typically only a few seconds) go to '''superserver/staging/nancyn/''' - file name should be ''''surch.csv''''
−
#Open file – sort by column ''''D''''
 +
#Open '''file''' – sort by column ''''D''''
 
#Copy data to '''EPRA Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|EPRA Worksheet}}
  
#Copy data to '''EPRA Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|EPRA Worksheet}}
 
#Create '''sub-totals''' for each '''type'''
  
#Create '''sub-totals''' for each '''type'''
Line 19: Line 19:
   
 
==Submit Monthly Report to EPRA==
  
==Submit Monthly Report to EPRA==
−
#We are now ready to submit our monthly fees to EPRA. Log into web browser – go to [https://reporting.recyclemyelectronics.ca]
 +
#We are now ready to submit our monthly fees to EPRA. Log into web browser – go to [https://reporting.recyclemyelectronics.ca https://reporting.recyclemyelectronics.ca]
−
#Enter User ID: ''''johnt'''' and Password: ''''UWD2051jt''''
 +
#Enter User ID: ''''johnt'''' and Password:
 
#Click ''''Monthly Declarations'''' – you should see '''open declarations''' and the month that you are submitting for. Click to '''open'''.
  
#Click ''''Monthly Declarations'''' – you should see '''open declarations''' and the month that you are submitting for. Click to '''open'''.
−
#Enter quantity sold for EPR1 ($2.25) into “Desktop/Countertop Electronic Products….Medical Equipment. Enter quantity sold for EPR3 ($0.40) into “Portable Electronic …Medical Equipment.
 +
#Enter quantity sold for EPR1 ($2.25) into ''''Desktop/Countertop Electronic Products….Medical Equipment''''. Enter quantity sold for EPR3 ($0.40) into ''''Portable Electronic …Medical Equipment''''.
−
#Once finished, click ''''submit monthly declaration'''' at the bottom.
 +
#Once finished, click ''''Submit Monthly Declaration'''' at the bottom.
−
#Click 'here' to view the invoice immediately.
 +
#Click ''''Here'''' to view the invoice immediately.
−
#Click 'logout'
 +
#Click ''''logout''''
−
#Print the invoice and forward to Payroll & Benefits Administration with worksheet attached.
 +
#Print the '''invoice''' and forward to '''Payroll & Benefits Administration''' with '''worksheet attached'''.
   
−
[[File:epra1.png|500px]]
  
 
[[File:epra4.png|500px]]
  
[[File:epra4.png|500px]]
   

Latest revision as of 23:38, 18 December 2020

Overview

The Electronic Products Recycling Association (EPRA) 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 mid Feb. 2016 and have previously submitted past due fees starting from Jul. 1, 2012 when this program was expanded to include items that we carry.

We are responsible for submitting monthly reports based on surcharge type 9. Data is coming from our invoice records based on the item master surcharge table. Our Steward number is RBC502999.

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 9 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 EPRA Fee worksheet (use most current fiscal year) EPRA Worksheet
  5. Create sub-totals for each type
  6. Print sheet and save file

epra2.png epra3.png

Submit Monthly Report to EPRA

  1. We are now ready to submit our monthly fees to EPRA. Log into web browser – go to https://reporting.recyclemyelectronics.ca
  2. Enter User ID: 'johnt' and Password:
  3. Click 'Monthly Declarations' – you should see open declarations and the month that you are submitting for. Click to open.
  4. Enter quantity sold for EPR1 ($2.25) into 'Desktop/Countertop Electronic Products….Medical Equipment'. Enter quantity sold for EPR3 ($0.40) into 'Portable Electronic …Medical Equipment'.
  5. Once finished, click 'Submit Monthly Declaration' at the bottom.
  6. Click 'Here' to view the invoice immediately.
  7. Click 'logout'
  8. Print the invoice and forward to Payroll & Benefits Administration with worksheet attached.

epra4.png

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:EPRA-Monthly_Report-Surcharges&oldid=13295"