Accounting Finance:PST-Monthly Report-Remittance - Revision history

Williamw: /* Generate PST Worksheet */

2021-11-22T23:22:59Z

Generate PST Worksheet

Williamw: /* Generate PST Worksheet */

2021-04-27T20:32:02Z

Generate PST Worksheet

Norwinu at 06:22, 19 December 2020

2020-12-19T06:22:37Z

Williamw at 19:18, 31 January 2020

2020-01-31T19:18:12Z

Williamw at 19:15, 31 January 2020

2020-01-31T19:15:40Z

Williamw: /* Generate PST Worksheet */

2020-01-27T18:58:21Z

Generate PST Worksheet

Harmanr: /* Submit Monthly Report to PST */

2019-10-24T18:11:10Z

Submit Monthly Report to PST

Harmanr: /* Submit Monthly Report to PST */

2019-10-24T18:10:02Z

Submit Monthly Report to PST

Harmanr: /* Submit Monthly Report to PST */

2019-10-24T18:09:19Z

Submit Monthly Report to PST

Harmanr: /* Submit Monthly Report to PST */

2019-10-24T18:08:33Z

Submit Monthly Report to PST

@@ Line 32: / Line 32: @@
 #Check that:
 *'''Debit/Credit'''(columns D/E)= '''Subtotal column''' which = '''Sum of VT's''' = '''(G/L amount for period + payment)'''
-*AP 30 in the '''Summary''' tab should balance to '''G/L for VT type 30''' - '''Previous Payment'''. This amount should also balance to the total at the bottom of '''AR-AP in-out''' sheet
+*AP 30 in the '''Summary''' tab should balance to '''G/L for VT type 30 total''' - '''Previous Payment'''. This amount should also balance to the total at the bottom of '''AR-AP in-out''' sheet
 *The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

@@ Line 23: / Line 23: @@
 #Navigate to the Sales Calculation Tab. Insert a new column and find the amounts for the GL accounts listed. Drag formulas to calculate sales figure. Enter/paste this amount into the sales column in the Summary tab.
 #Enter '''total PST''' for the month in '''columns D & E'''. This amount should balance to the amount in the '''Subtotal''' column, which is the sum of the totals for each voucher type. This amount can also be checked by adding the '''G/L 210700''' amount for the period with the previous month's payment (which is included in the transaction enquiry for the current period).
-#Enter '''total''' for each '''voucher type''' specified (80-83, 10, 30, 50). '''Subtract''' the previous months payment when entering the '''AP30''' amount (This is usually the largest '''VT30''')
+#Enter '''total''' for each '''voucher type''' specified (80-83, 10, 30, 50). '''Subtract''' the '''previous month's payment''' when entering the '''AP30''' amount (This is usually the largest '''VT30''')
 #Click on '''AR-AP-in-out sheet''' and enter data for '''voucher type 30''' (note the positive numbers are usually drop shipments which are in/out (paid and charged back to the store). Enter values for '''VT30''' in '''Gl 210700''' into the cells for the month that is being prepared (except the PST payment). Enter positive amounts above and negative amounts below.
 #Enter the following information: Vendor Name, Reference (document Number), AR Invoice (if no AR invoice then enter CHG Stores if noted in text. AR Invoice numbers only for positive amounts)

@@ Line 23: / Line 23: @@
 #Navigate to the Sales Calculation Tab. Insert a new column and find the amounts for the GL accounts listed. Drag formulas to calculate sales figure. Enter/paste this amount into the sales column in the Summary tab.
 #Enter '''total PST''' for the month in '''columns D & E'''. This amount should balance to the amount in the '''Subtotal''' column, which is the sum of the totals for each voucher type. This amount can also be checked by adding the '''G/L 210700''' amount for the period with the previous month's payment (which is included in the transaction enquiry for the current period).
-#Enter '''total''' for each '''voucher type''' specified (80-83, 10, 30, 50). Subtract the previous months payment when entering the '''AP30''' amount (This is usually the largest '''VT30''')
+#Enter '''total''' for each '''voucher type''' specified (80-83, 10, 30, 50). '''Subtract''' the previous months payment when entering the '''AP30''' amount (This is usually the largest '''VT30''')
 #Click on '''AR-AP-in-out sheet''' and enter data for '''voucher type 30''' (note the positive numbers are usually drop shipments which are in/out (paid and charged back to the store). Enter values for '''VT30''' in '''Gl 210700''' into the cells for the month that is being prepared (except the PST payment). Enter positive amounts above and negative amounts below.
 #Enter the following information: Vendor Name, Reference (document Number), AR Invoice (if no AR invoice then enter CHG Stores if noted in text. AR Invoice numbers only for positive amounts)

@@ Line 52: / Line 52: @@
 #Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
 #Click '''Submit'''
-#Click '''Print''' and print two copies
+#Click '''Print'''and print two copies (save a copy of PDF to folder)
 #Click '''Ok'''
 #Attached the '''Return''' and '''Confirmation''' to the worksheet printouts, with the Social Service Tax worksheet on top and forward to '''Angela Chan''' for processing.

@@ Line 55: / Line 55: @@
 #Click '''Ok'''
 #Attached the '''Return''' and '''Confirmation''' to the worksheet printouts, with the Social Service Tax worksheet on top and forward to '''Angela Chan''' for processing.
-#Forward second copy of '''Confirmation''' with the account '''21981''' write on to '''Christine Del Rosario''' for processing.
+#Forward second copy of '''Confirmation''' with the account '''21981''' write on to '''Donna Kill''' for processing.
 [[File:nancy4.png|500px]]

@@ Line 22: / Line 22: @@
 #Log into PST Worksheet {{unc|\\superserver.unipharm.local\Accounting\harmanr\Taxes\PST| PST Worksheet}}
 #Navigate to the Sales Calculation Tab. Insert a new column and find the amounts for the GL accounts listed. Drag formulas to calculate sales figure. Enter/paste this amount into the sales column in the Summary tab.
-#Enter '''total PST''' for the month in '''columns D & E'''. This amount should balance to the amount in the '''Subtotal''' column, which is the sum of the totals for each voucher type. This amount can also be checked by adding the G/L 210700 amount for the period with the previous month's payment (which is included in the transaction enquiry for the current period).
+#Enter '''total PST''' for the month in '''columns D & E'''. This amount should balance to the amount in the '''Subtotal''' column, which is the sum of the totals for each voucher type. This amount can also be checked by adding the '''G/L 210700''' amount for the period with the previous month's payment (which is included in the transaction enquiry for the current period).
-#Enter '''total''' for each '''voucher type''' specified (80-83, 10, 30, 50). Subtract the previous months payment when entering the AP30 amount (This is usually the largest VT30)
+#Enter '''total''' for each '''voucher type''' specified (80-83, 10, 30, 50). Subtract the previous months payment when entering the '''AP30''' amount (This is usually the largest '''VT30''')
-#Click on '''AR-AP-in-out sheet''' and enter data for '''voucher type 30''' (note the positive numbers are usually drop shipments which are in/out (paid and charged back to the store). Enter values for VT30 in Gl 210700 into the cells for the month that is being prepared (except the PST payment). Enter positive amounts above and negative amounts below.
+#Click on '''AR-AP-in-out sheet''' and enter data for '''voucher type 30''' (note the positive numbers are usually drop shipments which are in/out (paid and charged back to the store). Enter values for '''VT30''' in '''Gl 210700''' into the cells for the month that is being prepared (except the PST payment). Enter positive amounts above and negative amounts below.
 #Enter the following information: Vendor Name, Reference (document Number), AR Invoice (if no AR invoice then enter CHG Stores if noted in text. AR Invoice numbers only for positive amounts)
 #The '''total''' should match total in the '''Current year sheet'''

@@ Line 36: / Line 36: @@
 ==Submit Monthly Report to PST==
-#We are now ready to submit our monthly fees to PST.  Log into web browser – go to [PST|https://www.etax.gov.bc.ca/btp/eservices/_/]
+#We are now ready to submit our monthly fees to PST.  Log into web browser – go to [https://www.etax.gov.bc.ca/btp/eservices/_/ PST]
 #Enter User ID: ''''uniPHARM'''' and Password and click '''Login'''
 #Click '''Send Access Code Email''' (an email with the access code will be emailed to nancyn@unipharm.com)