Accounting Finance:CESA-Monthly Report-Surcharges - Revision history

Williamw: /* Overview */

2022-07-27T19:51:13Z

Overview

Williamw at 19:50, 27 July 2022

2022-07-27T19:50:56Z

Williamw: /* Generate Surcharge Report */

2022-07-27T19:49:47Z

Generate Surcharge Report

Williamw at 19:49, 27 July 2022

2022-07-27T19:49:08Z

Williamw at 19:48, 27 July 2022

2022-07-27T19:48:06Z

Williamw at 19:47, 27 July 2022

2022-07-27T19:47:08Z

Norwinu at 06:33, 19 December 2020

2020-12-19T06:33:06Z

Harmanr: /* Submit Monthly Report to CESA */

2018-12-28T17:30:27Z

Submit Monthly Report to CESA

Nancyn at 18:42, 21 November 2017

2017-11-21T18:42:51Z

Nancyn at 18:42, 21 November 2017

2017-11-21T18:42:25Z

@@ Line 2: / Line 2: @@
 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'''.
+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==

@@ Line 2: / Line 2: @@
 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.  Data is coming from our invoice records based on the item master surcharge table.  Our Steward number is '''1267'''.
+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==

@@ Line 8: / Line 8: @@
 ==Generate Surcharge Report==
-#Annual remittance reporting will include period of January through December and the payment expiry date will be January 31<sup>st</sup> following remittance period.
+#Annual remittance reporting will include period of January through December and the payment expiry date will be January 31<sup>st</sup> after the remittance period.
 #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''''
 #Once report has finished running (typically only a few seconds) go to '''superserver/staging/nancyn/''' - file name should be ''''surch.csv''''

@@ Line 8: / Line 8: @@
 ==Generate Surcharge Report==
-#Annual remittance reporting will include period of January through December and the payment expiry date will be January 31st following remittance period.
+#Annual remittance reporting will include period of January through December and the payment expiry date will be January 31<sup>st</sup> following remittance period.
 #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''''
 #Once report has finished running (typically only a few seconds) go to '''superserver/staging/nancyn/''' - file name should be ''''surch.csv''''

@@ Line 2: / Line 2: @@
 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'''.  Data is coming from our invoice records based on the item master surcharge table.  Our Steward number is '''1267'''.
+We are responsible for submitting '''annual reports''' based on surcharge '''type 6''' as of 2022.  Data is coming from our invoice records based on the item master surcharge table.  Our Steward number is '''1267'''.
 ==Contacts==

@@ Line 2: / Line 2: @@
 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 6'''.  Data is coming from our invoice records based on the item master surcharge table.  Our Steward number is '''1267'''.
+We are responsible for submitting '''annual reports''' based on surcharge '''type 6'''.  Data is coming from our invoice records based on the item master surcharge table.  Our Steward number is '''1267'''.
 ==Contacts==
@@ Line 8: / Line 8: @@
 ==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 '''6''' and press ''''enter''''
+#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''''
 #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''''
@@ Line 19: / Line 20: @@
 [[File:cesa2.png|500px]]
-==Submit Monthly Report to CESA==
+==Submit Annual Report to CESA==
-#We are now ready to submit our monthly fees to EPRA.  Log into web browser – go to [https://www.cesareporting.ca https://www.cesareporting.ca]
+#We are now ready to submit our annual fees to EPRA.  Log into web browser – go to [https://www.cesareporting.ca https://www.cesareporting.ca]
 #Click '''Stewards'''
 #click '''Report & Remit'''
 #Enter User Name: ''''uniPHARM'''' and Password: ''''not available''''
 #Click '''Log in'''
-#Mark '''File/View Reports''' and select the applicable '''month'''
+#Mark '''File/View Reports''' and select the applicable '''period'''
 #Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
 #Click '''Save and Continue'''
@@ Line 36: / Line 37: @@
 #Click '''Submit Report'''
 #Click '''Ok'''
-#Click '''Download Monthly Invoice as PDF'''
+#Click '''Download Annual Invoice as PDF'''
 #Print '''Invoice''' and attach with '''printout of worksheet'''
 #Forward to '''Payroll & Benefits Administrator for processing'''

@@ Line 8: / Line 8: @@
 ==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 '''6''' and 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 '''6''' 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'''
-# Print '''sheet''' and save '''file
+#Print '''sheet''' and save '''file
 '''
 [[File:cesa.png|500px]]