uniWIKI - User contributions [en]

Accounting Finance:Accounting Finance:UMC Charity

2019-11-28T22:44:12Z

Harmanr: /* Preparing the Statements */

= Overview =
*The UMC Charity is considered a separate entity that allows shareholders to make donations, which uniPHARM matches (depending on which charity they would like to donate to).
*The charity receives funding from uniPHARM and runs the same fiscal year as the main company (Feb to Jan)

=Accessing the Charitable Foundation=
*To access the UMC Charity in ASW, change company by logging into ASW.
*Select Change Company in the top ribbon(green arrow)
*Enter CF for company code for Charitable Foundation. (Enter VA if switching back to uniPHARM database)

=Entering Transactions=
*Ensure you are in the CF database (see steps above)
*Navigate to Financials -> Financial Accounting -> GL Transaction Tasks -> Enter Financial Transactions

=== Entering Expenses ===
*Enter as a Voucher type 30
*Document Type: '''INE'''
*INV# = reference from Angela which is found on the Cheque Requisition Form
*Cost Center - 1510
*Supplier INV Date - Cheque Date
*Send to appropriate GL (730100 for Donations)
*Post Batch then print

===Entering Payment into Bank===
*Enter as '''VT 45'''
*Doc Type: '''MAN'''
*Doc#: Chq #
*Doc Date: Chq Date
*Text: MANXXX, Name of Charity
*Enter Amount and press enter to continue to next screen
*Select corresponding entry and select '''Update'''
*Post the batch and stamp the Cheque Requisition Form to mark completion
*Scan the invoices and the journal entry into the Donations Folder. Donation Receipts to the CRA Folder

=Preparing the Statements=
*Open the CF Financial Statements Template File
*Open the details tab and fill in the details for the month using the date, reference (assign each transaction a reference #), and amount for transactions in the month.
Enter the GL accounts each transaction will correspond with. Common GL accounts include:

*100200 - Bank
*750200 – Other contributions
*750220 – Contributions with Tax Receipts (This transaction requires amount to be entered in the Donations Rec’d column as well). Check to ensure an donation receipt has been created for the donation.
*210000 – Accounts Payable
*120000 – Accounts Receivable

*Refresh the pivot table in the top right of the details page
*Enter transaction details from the monthly bank statement into the Bank Tab. Ensure the total matches the bank statement and the amount in the GL
*UWD Donations – Ensure the amount in this tab match the GL in the Unipharm company (VA not the CF database)
*Fill in details in the remaining tabs and update the date and balances at the top of the page. Charity Registration numbers can be found at on the [https://apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch?request_locale=en CRA Charity Listing Page]
*Refresh all pivot tables and ensure the totals are correct
*Link the pivot table in the Trial Balance (details) tab to the corresponding cells in the Trial Balance Summary tab
*Manually fill in the previous years information using the year to date information from the printed statements which can be printed in ASW by navigating to BUs Reporting -> work with reports
*Print FIN01, FIN03 UMC and FIN05-UMC2 and match totals to the respective statements

[[Category:UMC Charity]]

Accounting Finance:BC Light Recycle-Monthly Report-Surcharges

2019-11-26T20:01:06Z

Harmanr: /* Submit Monthly Report to CESA */

==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''' [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==
#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''''
#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''''BC
#Copy data to '''BC Light Recycle Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|BC Light Recycle Worksheet}}
#Create '''sub-totals''' for each '''type'''
#Print '''sheet''' and save '''file'''

[[File:nancy6.png|500px]]
[[File:nancy5.png|500px]]

==Submit Monthly Report to CESA==
#We are now ready to submit our monthly fees to BC Recycling. Log into web browser – go to [https://ehfreporting.com/|BC Recycling] (link does not work until you remove extra letters from the URL
#Click '''Light Recycle'''
#Enter User Name: ''''UNIPHARM'''' and Password: ''''jt2051''''
#Click '''Log in'''
#Click '''British Columbia''' and select the Mark the applicable '''year''' and the applicable '''month'''
#Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
#Click '''Save and Continue'''
#Enter description of methodology '''sales to BC customers from uniPHARM's inventory'''
#Click '''box''' to confirm that brand listing is up to date and enter '''applicable date'''
#Click '''Save and Continue'''
#Click '''EFT (Electronic Fund Transfer'''
#Click '''Save and Continue'''
#Click '''box''' to agree
#Click '''Submit Report'''
#Click '''Ok'''
#Click '''Download Monthly Invoice as PDF'''
#Print '''Invoice''' and attach with '''printout of worksheet'''
#Forward to '''Payroll & Benefits Administrator for processing'''
#Click '''Log out''' to logout of BC Light Recycle

[[File:nancy7.png|500px]]

[[Category:BC Light]]

Accounting Finance:BC Light Recycle-Monthly Report-Surcharges

2019-11-26T20:00:29Z

Harmanr: /* Submit Monthly Report to CESA */

==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''' [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==
#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''''
#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''''BC
#Copy data to '''BC Light Recycle Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|BC Light Recycle Worksheet}}
#Create '''sub-totals''' for each '''type'''
#Print '''sheet''' and save '''file'''

[[File:nancy6.png|500px]]
[[File:nancy5.png|500px]]

==Submit Monthly Report to CESA==
#We are now ready to submit our monthly fees to BC Recycling. Log into web browser – go to [https://ehfreporting.com/|BC Recycling]
#Click '''Light Recycle'''
#Enter User Name: ''''UNIPHARM'''' and Password: ''''jt2051''''
#Click '''Log in'''
#Click '''British Columbia''' and select the Mark the applicable '''year''' and the applicable '''month'''
#Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
#Click '''Save and Continue'''
#Enter description of methodology '''sales to BC customers from uniPHARM's inventory'''
#Click '''box''' to confirm that brand listing is up to date and enter '''applicable date'''
#Click '''Save and Continue'''
#Click '''EFT (Electronic Fund Transfer'''
#Click '''Save and Continue'''
#Click '''box''' to agree
#Click '''Submit Report'''
#Click '''Ok'''
#Click '''Download Monthly Invoice as PDF'''
#Print '''Invoice''' and attach with '''printout of worksheet'''
#Forward to '''Payroll & Benefits Administrator for processing'''
#Click '''Log out''' to logout of BC Light Recycle

[[File:nancy7.png|500px]]

[[Category:BC Light]]

Accounting Finance:Accounting Finance:UMC Charity

2019-11-26T00:12:00Z

Harmanr: /* Preparing the Statements */

= Overview =
*The UMC Charity is considered a separate entity that allows shareholders to make donations, which uniPHARM matches (depending on which charity they would like to donate to).
*The charity receives funding from uniPHARM and runs the same fiscal year as the main company (Feb to Jan)

=Accessing the Charitable Foundation=
*To access the UMC Charity in ASW, change company by logging into ASW.
*Select Change Company in the top ribbon(green arrow)
*Enter CF for company code for Charitable Foundation. (Enter VA if switching back to uniPHARM database)

=Entering Transactions=
*Ensure you are in the CF database (see steps above)
*Navigate to Financials -> Financial Accounting -> GL Transaction Tasks -> Enter Financial Transactions

=== Entering Expenses ===
**Enter as a Voucher type 30
*Document Type: '''INE'''
*INV# = reference from Angela which is found on the Cheque Requisition Form
*Cost Center - 1510
*Supplier INV Date - Cheque Date
*Send to appropriate GL (730100 for Donations)
*Post Batch then print

===Entering Payment into Bank===
*Enter as '''VT 45'''
*Doc Type: '''MAN'''
*Doc#: Chq #
*Doc Date: Chq Date
*Text: MANXXX, Name of Charity
*Enter Amount and press enter to continue to next screen
*Select corresponding entry and select '''Update'''
*Post the batch and stamp the Cheque Requisition Form to mark completion
*Scan the invoices and the journal entry into the Donations Folder. Donation Receipts to the CRA Folder

=Preparing the Statements=
*Open the CF Financial Statements Template File
*Open the details tab and fill in the details for the month using the date, reference (assign each transaction a reference #), and amount for transactions in the month.
Enter the GL accounts each transaction will correspond with. Common GL accounts include:

*100200 - Bank
*750200 – Other contributions
*750220 – Contributions with Tax Receipts (This transaction requires amount to be entered in the Donations Rec’d column as well). Check to ensure an donation receipt has been created for the donation.
*210000 – Accounts Payable
*120000 – Accounts Receivable

*Refresh the pivot table in the top right of the details page
*Enter transaction details from the monthly bank statement into the Bank Tab. Ensure the total matches the bank statement and the amount in the GL
*UWD Donations – Ensure the amount in this tab match the GL in the Unipharm company (VA not the CF database)

[[Category:UMC Charity]]

Accounting Finance:Accounting Finance:UMC Charity

2019-11-26T00:11:25Z

Harmanr:

= Overview =
*The UMC Charity is considered a separate entity that allows shareholders to make donations, which uniPHARM matches (depending on which charity they would like to donate to).
*The charity receives funding from uniPHARM and runs the same fiscal year as the main company (Feb to Jan)

=Accessing the Charitable Foundation=
*To access the UMC Charity in ASW, change company by logging into ASW.
*Select Change Company in the top ribbon(green arrow)
*Enter CF for company code for Charitable Foundation. (Enter VA if switching back to uniPHARM database)

=Entering Transactions=
*Ensure you are in the CF database (see steps above)
*Navigate to Financials -> Financial Accounting -> GL Transaction Tasks -> Enter Financial Transactions

=== Entering Expenses ===
**Enter as a Voucher type 30
*Document Type: '''INE'''
*INV# = reference from Angela which is found on the Cheque Requisition Form
*Cost Center - 1510
*Supplier INV Date - Cheque Date
*Send to appropriate GL (730100 for Donations)
*Post Batch then print

===Entering Payment into Bank===
*Enter as '''VT 45'''
*Doc Type: '''MAN'''
*Doc#: Chq #
*Doc Date: Chq Date
*Text: MANXXX, Name of Charity
*Enter Amount and press enter to continue to next screen
*Select corresponding entry and select '''Update'''
*Post the batch and stamp the Cheque Requisition Form to mark completion
*Scan the invoices and the journal entry into the Donations Folder. Donation Receipts to the CRA Folder

=Preparing the Statements=
*Open the CF Financial Statements Template File
*Open the details tab and fill in the details for the month using the date, reference (assign each transaction a reference #), and amount for transactions in the month.
*Enter the GL accounts each transaction will correspond with. Common GL accounts include:
100200 - Bank
750200 – Other contributions
750220 – Contributions with Tax Receipts (This transaction requires amount to be entered in the Donations Rec’d column as well). Check to ensure an donation receipt has been created for the donation.
210000 – Accounts Payable
120000 – Accounts Receivable
*Refresh the pivot table in the top right of the details page
*Enter transaction details from the monthly bank statement into the Bank Tab. Ensure the total matches the bank statement and the amount in the GL
*UWD Donations – Ensure the amount in this tab match the GL in the Unipharm company (VA not the CF database)

[[Category:UMC Charity]]

Accounting Finance:Accounting Finance:UMC Charity

2019-11-26T00:08:21Z

Harmanr:

Accounting Finance:Accounting Finance:UMC Charity

2019-11-25T22:57:16Z

Harmanr: Created page with "= Overview = *The UMC Charity is considered a separate entity that allows shareholders to make donations, which uniPHARM matches (depending on which charity they would like to..."

Accounting Finance:Accounting Finance:CIBC-Daily Cashbook Clearing

2019-10-29T17:35:10Z

Harmanr:

The Cashbook is cleared daily to ensure that the amounts entering and leaving the bank account are recorded correctly in the GL.

== Print Transaction Detail Report ==
*Log into the CIBC CMO Website
*In order to retreive a copy of the prior day's transactions, select '''Information Reporting''' and click '''Edit''' for '''Prior Day Transaction Detail'''.
*Select prior day’s date, select the correct bank account ('''CAD uniPHARM Wholesale Drugs Ltd'''.), and add to accounts included in report before viewing report and '''printing'''

==Cashbook Clearing==
*Navigate to ASW --> '''GF460 - Work With Cash Book Reconciliation'''
*Enter '''001''' under bank for CIBC CAD
*Clear the amounts on the report from the cashbook. Enter the file type you are clearing (ex EFT) into the '''DT''' column to navigate quicker.
*Select the file you are clearing and click '''Reconcile'''
* Change the '''Reconciliation date''' to the date the item cleared the bank (date on the report)
*'''Do not change the Value Date'''
*Enter the '''month end date''' into the '''Statement Number''' in the following format - MM/DD/YY. Use the last day of the month, not the current date*
*If item not found in cashbook, track items on the CIBC Missing Amounts spreadsheet. Inquire with Donna or Christine to determine if remittance advice from the vendor/customer have been received. Clear once entered
*Enter the amounts for the Credit Card Reposition in the Visa & MC Transfers spreadsheet (Common -> AR -> Banking-> CIBC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:Accounting Finance:CIBC-Daily Cashbook Clearing

2019-10-29T17:33:32Z

Harmanr: Created page with "The Cashbook is cleared daily to ensure that the amounts entering and leaving the bank account are recorded correctly in the GL. *In order to retreive a copy of the prior day..."

The Cashbook is cleared daily to ensure that the amounts entering and leaving the bank account are recorded correctly in the GL.

*In order to retreive a copy of the prior day's transactions, select '''Information Reporting''' and click '''Edit''' for '''Prior Day Transaction Detail'''.
*Select prior day’s date, select the correct bank account ('''CAD uniPHARM Wholesale Drugs Ltd'''.), and add to accounts included in report before viewing report and '''printing'''

*Navigate to ASW --> '''GF460 - Work With Cash Book Reconciliation'''
*Enter '''001''' under bank for CIBC CAD
*Clear the amounts on the report from the cashbook. Enter the file type you are clearing (ex EFT) into the '''DT''' column to navigate quicker.
*Select the file you are clearing and click '''Reconcile'''
* Change the '''Reconciliation date''' to the date the item cleared the bank (date on the report)
*'''Do not change the Value Date'''
*Enter the '''month end date''' into the '''Statement Number''' in the following format - MM/DD/YY. Use the last day of the month, not the current date*
*If item not found in cashbook, track items on the CIBC Missing Amounts spreadsheet. Inquire with Donna or Christine to determine if remittance advice from the vendor/customer have been received. Clear once entered
*Enter the amounts for the Credit Card Reposition in the Visa & MC Transfers spreadsheet (Common -> AR -> Banking-> CIBC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:GST

2019-10-29T16:59:42Z

Harmanr: /* CRA Netfile */

==Overview==
GST remittances are made monthly before the end of the the following month. Check with Nancy, Finance Manager, before making GST remittance to ensure that the month has been closed and no more entries are able to be posted into the previous month.

== GST Worksheet ==
*Navigate to the GST folder and '''create a copy of the GST worksheet'''. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for.
*Enter values for '''GL 122500 and 122000''' in correct columns for current month. Add '''GST received''' in column E
*Enter GST deposits/payments made in the month in the correct column (column I/K)
*'''Update and drag formulas''' in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. '''Discrepancies''' may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the '''adjustment''' cell.
*'''Ensure totals for Current and Year to Date Sections match'''

== CRA Netfile ==
*Once worksheet is complete and totals match, navigate to '''[https://www.canada.ca/en/revenue-agency/services/e-services/e-services-businesses/gst-hst-netfile.html CRA Netfile Website]'''
*Enter the '''business number and Access code''' (can find in top left corner of GST worksheet). Enter dates reporting for (previous month). Click 'Next'
*Enter '''sales figure''' in Line 101 (same on used in PST calculation)
*Enter current from GL '''122500''' in '''Line 105'''
*Enter current for GL '''122000''' in '''Line 108'''
*'''Verify''' total matches the total in the worksheet
*Submit
*Save a copy of the return in the GST folder

[[Category:Workflows-Finance]]
[[Category:GST]]

Accounting Finance:CIBC-Downloading Cheque Clearing File

2019-10-29T16:53:43Z

Harmanr: /* Downloading File */

==Overview==
'''Corporate Clearing Services''' offers clients issuing a high volume of cheques reduced chequing cost due to the customer being responsible for cheque verification and returning any irregular items to the Bank. A unique pseudo transit '''30120''' has been created and a bulk debit is made to the associated branch account '''00900''' for the total amount of the cheques cleared. Multiple accounts can be associated with a pseudo transit number. A computer file is generated each morning of cheques drawn on our bank account under the previous day’s date. The information contained in the file will include all information contained within the MICR line of our cheques.

==Corporate Clearing Contacts==
*UWD Contact - Nancy Ng (local 202) [mailto:nancyn@unipharm.com Nancy Ng]
*UWD I.S. Contact - Norwin Uy (local 218) [mailto:norwinu@unipharm.com Norwin Uy]
*CIBC, Cash Management Manager - Edward Woo [mailto:edward.woo@cibc.ca Edward Woo] Tel: 604-665-1167, Fax: 604-665-1841
*CIBC Helpdesk: T: 1-800-500-6316 (ask Nancy to contact bank if required)
*CIBC F: 1-866-463-9004 or 1-905-415-0798

==Logging into CIBC==
#Open your supported web browser
#Logo into [https://cmo.cibc.com/wp/wps/portal/bbdsignon CIBC]
#Enter your 16 digit '''User ID''' (only an authorized user will be issued a User ID)
#Enter your '''token number''' (from your CIBC FOB)
#Enter your '''PIN'''
#Click the ''''Sign On'''' button

[[File:nancy11.png|500px]]

===Downloading File===
#Navigate to CMO -> Reporting -> Cash Management Reports
#Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
#There will be 2 types of files:
==== CCRAW – Corporate Clearing File ====

*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
*Change file name by clicking into the Archive folder and selecting the most recent file. Change date in file name to today’s date.
*For example, for October 29, select the most recent file (for Oct 28) and then change the file name to CL102919 for October 29th.
*Go back into the CIBC folder and save the file. If the file is saved in the Archive folder it will not be able to import into the system.
[[File:nancy13.png|500px]]
==== EFRPT – Input File Totals for CIBC EFTs ====
*Print and staple these to the previous days EFT batch. Ensure the amounts match.

==== Print Daily Transaction Report ====
*This will be used to clear the Cashbook
*Click Back to Dashboard (in the menu at the top of the screen) to return to the main menu in CIBC
*Select Information Reporting and click Edit for Prior Day Transaction Detail. Select prior day’s date, select the correct bank account (CAD uniPHARM Wholesale Drugs Ltd.), and add to accounts included in report before viewing report and printing

===Import File to ASW===
1.Go to green screen and click '''1''' (VA Company Production) - '''1''' (UWD Extensions) - '''70''' (Bank EDI)

2.Enter '''FW''' next to CIBC (file waiting to import) and press '''enter'''

[[File:nancy14.png|500px]]

3.Enter '''IM''' next to file to be imported and press '''enter''' (when file has been imported, the file name will disappear)

4.Press '''F12''' to move back to previous panel

5.If imported file does not have an error, the file will be posted automatically.

[[File:nancy15.png|500px]]

===Viewing File with Error===

1.Enter '''FI''' to view file with error and press '''enter'''

[[File:nancy16.png|500px]]

2.For errors, move to file and enter '''DT''' for details and press '''enter'''

[[File:nancy17.png|500px]]

3.Move to Errors only? and enter '''Y''' (this shows only transactions with errors) and press '''enter'''

[[File:nancy18.png|500px]]

4.Enter '''DT''' for detail on transaction with errors and press '''enter'''

[[File:nancy19.png|500px]]

===Correcting File with Error===

====Exceptions which are correctable====
*Encoding error
*Items cleared in the wrong currency (change amount to match ASW system amount)
*All other issues must be directed to Information Systems for review.

#For Encoding error, change the '''amount''' to match the ASW system amount. Note: encoding errors > $10 may be claimed back from bank
#Change '''header total''' to match the change and press '''enter'''
#Press '''F3'''

[[File:nancy21.png|500px]]

====Exceptions which are to be returned to bank====

*Stale-dated (cheques older than six months which have been cashed but VOID in ASW system (delete transaction)
*Encoding error (greater than $10)
*Fraudulent signature (delete transaction)
*Payment stopped (delete transaction)
*All other issues must be directed to Information Systems for review.

Enter '''DL''' to delete and press '''enter'''

[[File:nancy23.png|500px]]

===Posting batch after Error Correction===
#Enter '''PO''' to post file and press '''enter'''
#Press '''enter''' again to post file into ASW

[[File:nancy24.png|500px]]

*When file has been posted, the status will be '''Posted'''
*Do not re-import or re-post a file into ASW

===Importing Control File Worksheet===
#Goto {{unc|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing}}
#Enter '''imported date,actual date, file#, lines, amount and importer and any important notes'''
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
#Click '''save'''

===Returning Cheque in CIBC===
1.Go back to the '''CIBC CMO website'''

2.Click '''Cheque Services'''

3.Click '''Cheque Inquiry'''

4.Click on the correct account '''16512'''

5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''

[[File:nancy27.png|500px]]
[[File:nancy28.png|500px]]

6.Click the '''box''' to highlight all cheque images

7.Click '''Cheque image'''

8.Scan through all the '''cheque images''' to make sure there was no cheque tampering done. If there was, make sure to report it within '''24 hours to CIBC'''. You do not need to print the cheque image report.

[[File:nancy29.png|500px]]

===Corporate Clearing Online Decision===
[[File:nancy35.png|500px]]

[[File:nancy31.png|500px]]

[[File:nancy33.png|500px]]

[[File:nancy34.png|500px]]

*All returned items must be submitted by the '''cut-off time of 1pm''' or all items will be paid.
*'''Intria''' will handle later day instructions:
Fax later day returns no later than '''12 noon''' (local time) the following day to Intria '''(FAX #1-866-463-9004)'''
Include the following details on the fax page:
*Posting date
*Cheque Serial Number
*Cheque Amount
*Return Reason
*Call 1-888-947-7736 (Helpdesk) if you need to contact the bank (Client #1225510BC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC-Downloading Cheque Clearing File

2019-10-29T16:53:11Z

Harmanr: /* Downloading File */

==Overview==
'''Corporate Clearing Services''' offers clients issuing a high volume of cheques reduced chequing cost due to the customer being responsible for cheque verification and returning any irregular items to the Bank. A unique pseudo transit '''30120''' has been created and a bulk debit is made to the associated branch account '''00900''' for the total amount of the cheques cleared. Multiple accounts can be associated with a pseudo transit number. A computer file is generated each morning of cheques drawn on our bank account under the previous day’s date. The information contained in the file will include all information contained within the MICR line of our cheques.

==Corporate Clearing Contacts==
*UWD Contact - Nancy Ng (local 202) [mailto:nancyn@unipharm.com Nancy Ng]
*UWD I.S. Contact - Norwin Uy (local 218) [mailto:norwinu@unipharm.com Norwin Uy]
*CIBC, Cash Management Manager - Edward Woo [mailto:edward.woo@cibc.ca Edward Woo] Tel: 604-665-1167, Fax: 604-665-1841
*CIBC Helpdesk: T: 1-800-500-6316 (ask Nancy to contact bank if required)
*CIBC F: 1-866-463-9004 or 1-905-415-0798

==Logging into CIBC==
#Open your supported web browser
#Logo into [https://cmo.cibc.com/wp/wps/portal/bbdsignon CIBC]
#Enter your 16 digit '''User ID''' (only an authorized user will be issued a User ID)
#Enter your '''token number''' (from your CIBC FOB)
#Enter your '''PIN'''
#Click the ''''Sign On'''' button

[[File:nancy11.png|500px]]

===Downloading File===
#Navigate to CMO -> Reporting -> Cash Management Reports
#Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
#There will be 2 types of files:
==== CCRAW – Corporate Clearing File ====

*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
*Change file name by clicking into the Archive folder and selecting the most recent file. Change date in file name to today’s date.
*For example, for October 29, select the most recent file (for Oct 28) and then change the file name to CL102919 for October 29th.
*Go back into the CIBC folder and save the file. If the file is saved in the Archive folder it will not be able to import into the system.

==== EFRPT – Input File Totals for CIBC EFTs ====
*Print and staple these to the previous days EFT batch. Ensure the amounts match.

==== Print Daily Transaction Report ====
*This will be used to clear the Cashbook
*Click Back to Dashboard (in the menu at the top of the screen) to return to the main menu in CIBC
*Select Information Reporting and click Edit for Prior Day Transaction Detail. Select prior day’s date, select the correct bank account (CAD uniPHARM Wholesale Drugs Ltd.), and add to accounts included in report before viewing report and printing

[[File:nancy13.png|500px]]

===Import File to ASW===
1.Go to green screen and click '''1''' (VA Company Production) - '''1''' (UWD Extensions) - '''70''' (Bank EDI)

2.Enter '''FW''' next to CIBC (file waiting to import) and press '''enter'''

[[File:nancy14.png|500px]]

3.Enter '''IM''' next to file to be imported and press '''enter''' (when file has been imported, the file name will disappear)

4.Press '''F12''' to move back to previous panel

5.If imported file does not have an error, the file will be posted automatically.

[[File:nancy15.png|500px]]

===Viewing File with Error===

1.Enter '''FI''' to view file with error and press '''enter'''

[[File:nancy16.png|500px]]

2.For errors, move to file and enter '''DT''' for details and press '''enter'''

[[File:nancy17.png|500px]]

3.Move to Errors only? and enter '''Y''' (this shows only transactions with errors) and press '''enter'''

[[File:nancy18.png|500px]]

4.Enter '''DT''' for detail on transaction with errors and press '''enter'''

[[File:nancy19.png|500px]]

===Correcting File with Error===

====Exceptions which are correctable====
*Encoding error
*Items cleared in the wrong currency (change amount to match ASW system amount)
*All other issues must be directed to Information Systems for review.

#For Encoding error, change the '''amount''' to match the ASW system amount. Note: encoding errors > $10 may be claimed back from bank
#Change '''header total''' to match the change and press '''enter'''
#Press '''F3'''

[[File:nancy21.png|500px]]

====Exceptions which are to be returned to bank====

*Stale-dated (cheques older than six months which have been cashed but VOID in ASW system (delete transaction)
*Encoding error (greater than $10)
*Fraudulent signature (delete transaction)
*Payment stopped (delete transaction)
*All other issues must be directed to Information Systems for review.

Enter '''DL''' to delete and press '''enter'''

[[File:nancy23.png|500px]]

===Posting batch after Error Correction===
#Enter '''PO''' to post file and press '''enter'''
#Press '''enter''' again to post file into ASW

[[File:nancy24.png|500px]]

*When file has been posted, the status will be '''Posted'''
*Do not re-import or re-post a file into ASW

===Importing Control File Worksheet===
#Goto {{unc|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing}}
#Enter '''imported date,actual date, file#, lines, amount and importer and any important notes'''
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
#Click '''save'''

===Returning Cheque in CIBC===
1.Go back to the '''CIBC CMO website'''

2.Click '''Cheque Services'''

3.Click '''Cheque Inquiry'''

4.Click on the correct account '''16512'''

5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''

[[File:nancy27.png|500px]]
[[File:nancy28.png|500px]]

6.Click the '''box''' to highlight all cheque images

7.Click '''Cheque image'''

8.Scan through all the '''cheque images''' to make sure there was no cheque tampering done. If there was, make sure to report it within '''24 hours to CIBC'''. You do not need to print the cheque image report.

[[File:nancy29.png|500px]]

===Corporate Clearing Online Decision===
[[File:nancy35.png|500px]]

[[File:nancy31.png|500px]]

[[File:nancy33.png|500px]]

[[File:nancy34.png|500px]]

*All returned items must be submitted by the '''cut-off time of 1pm''' or all items will be paid.
*'''Intria''' will handle later day instructions:
Fax later day returns no later than '''12 noon''' (local time) the following day to Intria '''(FAX #1-866-463-9004)'''
Include the following details on the fax page:
*Posting date
*Cheque Serial Number
*Cheque Amount
*Return Reason
*Call 1-888-947-7736 (Helpdesk) if you need to contact the bank (Client #1225510BC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC-Downloading Cheque Clearing File

2019-10-29T16:52:59Z

Harmanr: /* Downloading File */

==Overview==
'''Corporate Clearing Services''' offers clients issuing a high volume of cheques reduced chequing cost due to the customer being responsible for cheque verification and returning any irregular items to the Bank. A unique pseudo transit '''30120''' has been created and a bulk debit is made to the associated branch account '''00900''' for the total amount of the cheques cleared. Multiple accounts can be associated with a pseudo transit number. A computer file is generated each morning of cheques drawn on our bank account under the previous day’s date. The information contained in the file will include all information contained within the MICR line of our cheques.

==Corporate Clearing Contacts==
*UWD Contact - Nancy Ng (local 202) [mailto:nancyn@unipharm.com Nancy Ng]
*UWD I.S. Contact - Norwin Uy (local 218) [mailto:norwinu@unipharm.com Norwin Uy]
*CIBC, Cash Management Manager - Edward Woo [mailto:edward.woo@cibc.ca Edward Woo] Tel: 604-665-1167, Fax: 604-665-1841
*CIBC Helpdesk: T: 1-800-500-6316 (ask Nancy to contact bank if required)
*CIBC F: 1-866-463-9004 or 1-905-415-0798

==Logging into CIBC==
#Open your supported web browser
#Logo into [https://cmo.cibc.com/wp/wps/portal/bbdsignon CIBC]
#Enter your 16 digit '''User ID''' (only an authorized user will be issued a User ID)
#Enter your '''token number''' (from your CIBC FOB)
#Enter your '''PIN'''
#Click the ''''Sign On'''' button

[[File:nancy11.png|500px]]

===Downloading File===
#Navigate to CMO -> Reporting -> Cash Management Reports
#Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
#There will be 2 types of files:

==== CCRAW – Corporate Clearing File ====

*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
*Change file name by clicking into the Archive folder and selecting the most recent file. Change date in file name to today’s date.
*For example, for October 29, select the most recent file (for Oct 28) and then change the file name to CL102919 for October 29th.
*Go back into the CIBC folder and save the file. If the file is saved in the Archive folder it will not be able to import into the system.

==== EFRPT – Input File Totals for CIBC EFTs ====
*Print and staple these to the previous days EFT batch. Ensure the amounts match.

==== Print Daily Transaction Report ====
*This will be used to clear the Cashbook
*Click Back to Dashboard (in the menu at the top of the screen) to return to the main menu in CIBC
*Select Information Reporting and click Edit for Prior Day Transaction Detail. Select prior day’s date, select the correct bank account (CAD uniPHARM Wholesale Drugs Ltd.), and add to accounts included in report before viewing report and printing

[[File:nancy13.png|500px]]

===Import File to ASW===
1.Go to green screen and click '''1''' (VA Company Production) - '''1''' (UWD Extensions) - '''70''' (Bank EDI)

2.Enter '''FW''' next to CIBC (file waiting to import) and press '''enter'''

[[File:nancy14.png|500px]]

3.Enter '''IM''' next to file to be imported and press '''enter''' (when file has been imported, the file name will disappear)

4.Press '''F12''' to move back to previous panel

5.If imported file does not have an error, the file will be posted automatically.

[[File:nancy15.png|500px]]

===Viewing File with Error===

1.Enter '''FI''' to view file with error and press '''enter'''

[[File:nancy16.png|500px]]

2.For errors, move to file and enter '''DT''' for details and press '''enter'''

[[File:nancy17.png|500px]]

3.Move to Errors only? and enter '''Y''' (this shows only transactions with errors) and press '''enter'''

[[File:nancy18.png|500px]]

4.Enter '''DT''' for detail on transaction with errors and press '''enter'''

[[File:nancy19.png|500px]]

===Correcting File with Error===

====Exceptions which are correctable====
*Encoding error
*Items cleared in the wrong currency (change amount to match ASW system amount)
*All other issues must be directed to Information Systems for review.

#For Encoding error, change the '''amount''' to match the ASW system amount. Note: encoding errors > $10 may be claimed back from bank
#Change '''header total''' to match the change and press '''enter'''
#Press '''F3'''

[[File:nancy21.png|500px]]

====Exceptions which are to be returned to bank====

*Stale-dated (cheques older than six months which have been cashed but VOID in ASW system (delete transaction)
*Encoding error (greater than $10)
*Fraudulent signature (delete transaction)
*Payment stopped (delete transaction)
*All other issues must be directed to Information Systems for review.

Enter '''DL''' to delete and press '''enter'''

[[File:nancy23.png|500px]]

===Posting batch after Error Correction===
#Enter '''PO''' to post file and press '''enter'''
#Press '''enter''' again to post file into ASW

[[File:nancy24.png|500px]]

*When file has been posted, the status will be '''Posted'''
*Do not re-import or re-post a file into ASW

===Importing Control File Worksheet===
#Goto {{unc|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing}}
#Enter '''imported date,actual date, file#, lines, amount and importer and any important notes'''
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
#Click '''save'''

===Returning Cheque in CIBC===
1.Go back to the '''CIBC CMO website'''

2.Click '''Cheque Services'''

3.Click '''Cheque Inquiry'''

4.Click on the correct account '''16512'''

5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''

[[File:nancy27.png|500px]]
[[File:nancy28.png|500px]]

6.Click the '''box''' to highlight all cheque images

7.Click '''Cheque image'''

8.Scan through all the '''cheque images''' to make sure there was no cheque tampering done. If there was, make sure to report it within '''24 hours to CIBC'''. You do not need to print the cheque image report.

[[File:nancy29.png|500px]]

===Corporate Clearing Online Decision===
[[File:nancy35.png|500px]]

[[File:nancy31.png|500px]]

[[File:nancy33.png|500px]]

[[File:nancy34.png|500px]]

*All returned items must be submitted by the '''cut-off time of 1pm''' or all items will be paid.
*'''Intria''' will handle later day instructions:
Fax later day returns no later than '''12 noon''' (local time) the following day to Intria '''(FAX #1-866-463-9004)'''
Include the following details on the fax page:
*Posting date
*Cheque Serial Number
*Cheque Amount
*Return Reason
*Call 1-888-947-7736 (Helpdesk) if you need to contact the bank (Client #1225510BC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC-Downloading Cheque Clearing File

2019-10-29T16:51:22Z

Harmanr: /* Downloading File */

==Overview==
'''Corporate Clearing Services''' offers clients issuing a high volume of cheques reduced chequing cost due to the customer being responsible for cheque verification and returning any irregular items to the Bank. A unique pseudo transit '''30120''' has been created and a bulk debit is made to the associated branch account '''00900''' for the total amount of the cheques cleared. Multiple accounts can be associated with a pseudo transit number. A computer file is generated each morning of cheques drawn on our bank account under the previous day’s date. The information contained in the file will include all information contained within the MICR line of our cheques.

==Corporate Clearing Contacts==
*UWD Contact - Nancy Ng (local 202) [mailto:nancyn@unipharm.com Nancy Ng]
*UWD I.S. Contact - Norwin Uy (local 218) [mailto:norwinu@unipharm.com Norwin Uy]
*CIBC, Cash Management Manager - Edward Woo [mailto:edward.woo@cibc.ca Edward Woo] Tel: 604-665-1167, Fax: 604-665-1841
*CIBC Helpdesk: T: 1-800-500-6316 (ask Nancy to contact bank if required)
*CIBC F: 1-866-463-9004 or 1-905-415-0798

==Logging into CIBC==
#Open your supported web browser
#Logo into [https://cmo.cibc.com/wp/wps/portal/bbdsignon CIBC]
#Enter your 16 digit '''User ID''' (only an authorized user will be issued a User ID)
#Enter your '''token number''' (from your CIBC FOB)
#Enter your '''PIN'''
#Click the ''''Sign On'''' button

[[File:nancy11.png|500px]]

===Downloading File===
#Navigate to CMO -> Reporting -> Cash Management Reports
#Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
#There will be 2 types of files:

#CCRAW – Corporate Clearing File
*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
*Change file name by clicking into the Archive folder and selecting the most recent file. Change date in file name to today’s date.
*For example, for October 29, select the most recent file (for Oct 28) and then change the file name to CL102919 for October 29th.
*Go back into the CIBC folder and save the file. If the file is saved in the Archive folder it will not be able to import into the system.

#EFRPT – Input File Totals for CIBC EFTs
*Print and staple these to the previous days EFT batch. Ensure the amounts match.

#Print Daily Transaction Report
*This will be used to clear the Cashbook
*Click Back to Dashboard (in the menu at the top of the screen) to return to the main menu in CIBC
*Select Information Reporting and click Edit for Prior Day Transaction Detail. Select prior day’s date, select the correct bank account (CAD uniPHARM Wholesale Drugs Ltd.), and add to accounts included in report before viewing report and printing

[[File:nancy13.png|500px]]

===Import File to ASW===
1.Go to green screen and click '''1''' (VA Company Production) - '''1''' (UWD Extensions) - '''70''' (Bank EDI)

2.Enter '''FW''' next to CIBC (file waiting to import) and press '''enter'''

[[File:nancy14.png|500px]]

3.Enter '''IM''' next to file to be imported and press '''enter''' (when file has been imported, the file name will disappear)

4.Press '''F12''' to move back to previous panel

5.If imported file does not have an error, the file will be posted automatically.

[[File:nancy15.png|500px]]

===Viewing File with Error===

1.Enter '''FI''' to view file with error and press '''enter'''

[[File:nancy16.png|500px]]

2.For errors, move to file and enter '''DT''' for details and press '''enter'''

[[File:nancy17.png|500px]]

3.Move to Errors only? and enter '''Y''' (this shows only transactions with errors) and press '''enter'''

[[File:nancy18.png|500px]]

4.Enter '''DT''' for detail on transaction with errors and press '''enter'''

[[File:nancy19.png|500px]]

===Correcting File with Error===

====Exceptions which are correctable====
*Encoding error
*Items cleared in the wrong currency (change amount to match ASW system amount)
*All other issues must be directed to Information Systems for review.

#For Encoding error, change the '''amount''' to match the ASW system amount. Note: encoding errors > $10 may be claimed back from bank
#Change '''header total''' to match the change and press '''enter'''
#Press '''F3'''

[[File:nancy21.png|500px]]

====Exceptions which are to be returned to bank====

*Stale-dated (cheques older than six months which have been cashed but VOID in ASW system (delete transaction)
*Encoding error (greater than $10)
*Fraudulent signature (delete transaction)
*Payment stopped (delete transaction)
*All other issues must be directed to Information Systems for review.

Enter '''DL''' to delete and press '''enter'''

[[File:nancy23.png|500px]]

===Posting batch after Error Correction===
#Enter '''PO''' to post file and press '''enter'''
#Press '''enter''' again to post file into ASW

[[File:nancy24.png|500px]]

*When file has been posted, the status will be '''Posted'''
*Do not re-import or re-post a file into ASW

===Importing Control File Worksheet===
#Goto {{unc|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing}}
#Enter '''imported date,actual date, file#, lines, amount and importer and any important notes'''
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
#Click '''save'''

===Returning Cheque in CIBC===
1.Go back to the '''CIBC CMO website'''

2.Click '''Cheque Services'''

3.Click '''Cheque Inquiry'''

4.Click on the correct account '''16512'''

5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''

[[File:nancy27.png|500px]]
[[File:nancy28.png|500px]]

6.Click the '''box''' to highlight all cheque images

7.Click '''Cheque image'''

8.Scan through all the '''cheque images''' to make sure there was no cheque tampering done. If there was, make sure to report it within '''24 hours to CIBC'''. You do not need to print the cheque image report.

[[File:nancy29.png|500px]]

===Corporate Clearing Online Decision===
[[File:nancy35.png|500px]]

[[File:nancy31.png|500px]]

[[File:nancy33.png|500px]]

[[File:nancy34.png|500px]]

*All returned items must be submitted by the '''cut-off time of 1pm''' or all items will be paid.
*'''Intria''' will handle later day instructions:
Fax later day returns no later than '''12 noon''' (local time) the following day to Intria '''(FAX #1-866-463-9004)'''
Include the following details on the fax page:
*Posting date
*Cheque Serial Number
*Cheque Amount
*Return Reason
*Call 1-888-947-7736 (Helpdesk) if you need to contact the bank (Client #1225510BC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC-Downloading Cheque Clearing File

2019-10-29T16:50:40Z

Harmanr: /* Downloading File */

==Overview==
'''Corporate Clearing Services''' offers clients issuing a high volume of cheques reduced chequing cost due to the customer being responsible for cheque verification and returning any irregular items to the Bank. A unique pseudo transit '''30120''' has been created and a bulk debit is made to the associated branch account '''00900''' for the total amount of the cheques cleared. Multiple accounts can be associated with a pseudo transit number. A computer file is generated each morning of cheques drawn on our bank account under the previous day’s date. The information contained in the file will include all information contained within the MICR line of our cheques.

==Corporate Clearing Contacts==
*UWD Contact - Nancy Ng (local 202) [mailto:nancyn@unipharm.com Nancy Ng]
*UWD I.S. Contact - Norwin Uy (local 218) [mailto:norwinu@unipharm.com Norwin Uy]
*CIBC, Cash Management Manager - Edward Woo [mailto:edward.woo@cibc.ca Edward Woo] Tel: 604-665-1167, Fax: 604-665-1841
*CIBC Helpdesk: T: 1-800-500-6316 (ask Nancy to contact bank if required)
*CIBC F: 1-866-463-9004 or 1-905-415-0798

==Logging into CIBC==
#Open your supported web browser
#Logo into [https://cmo.cibc.com/wp/wps/portal/bbdsignon CIBC]
#Enter your 16 digit '''User ID''' (only an authorized user will be issued a User ID)
#Enter your '''token number''' (from your CIBC FOB)
#Enter your '''PIN'''
#Click the ''''Sign On'''' button

[[File:nancy11.png|500px]]

===Downloading File===
*Navigate to CMO -> Reporting -> Cash Management Reports
*Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
*There will be 2 types of files:

*CCRAW – Corporate Clearing File
*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
*Change file name by clicking into the Archive folder and selecting the most recent file. Change date in file name to today’s date.
*For example, for October 29, select the most recent file (for Oct 28) and then change the file name to CL102919 for October 29th.
*Go back into the CIBC folder and save the file. If the file is saved in the Archive folder it will not be able to import into the system.

*EFRPT – Input File Totals for CIBC EFTs
*Print and staple these to the previous days EFT batch. Ensure the amounts match.

*Print Daily Transaction Report
*This will be used to clear the Cashbook
*Click Back to Dashboard (in the menu at the top of the screen) to return to the main menu in CIBC
*Select Information Reporting and click Edit for Prior Day Transaction Detail. Select prior day’s date, select the correct bank account (CAD uniPHARM Wholesale Drugs Ltd.), and add to accounts included in report before viewing report and printing

[[File:nancy13.png|500px]]

===Import File to ASW===
1.Go to green screen and click '''1''' (VA Company Production) - '''1''' (UWD Extensions) - '''70''' (Bank EDI)

2.Enter '''FW''' next to CIBC (file waiting to import) and press '''enter'''

[[File:nancy14.png|500px]]

3.Enter '''IM''' next to file to be imported and press '''enter''' (when file has been imported, the file name will disappear)

4.Press '''F12''' to move back to previous panel

5.If imported file does not have an error, the file will be posted automatically.

[[File:nancy15.png|500px]]

===Viewing File with Error===

1.Enter '''FI''' to view file with error and press '''enter'''

[[File:nancy16.png|500px]]

2.For errors, move to file and enter '''DT''' for details and press '''enter'''

[[File:nancy17.png|500px]]

3.Move to Errors only? and enter '''Y''' (this shows only transactions with errors) and press '''enter'''

[[File:nancy18.png|500px]]

4.Enter '''DT''' for detail on transaction with errors and press '''enter'''

[[File:nancy19.png|500px]]

===Correcting File with Error===

====Exceptions which are correctable====
*Encoding error
*Items cleared in the wrong currency (change amount to match ASW system amount)
*All other issues must be directed to Information Systems for review.

#For Encoding error, change the '''amount''' to match the ASW system amount. Note: encoding errors > $10 may be claimed back from bank
#Change '''header total''' to match the change and press '''enter'''
#Press '''F3'''

[[File:nancy21.png|500px]]

====Exceptions which are to be returned to bank====

*Stale-dated (cheques older than six months which have been cashed but VOID in ASW system (delete transaction)
*Encoding error (greater than $10)
*Fraudulent signature (delete transaction)
*Payment stopped (delete transaction)
*All other issues must be directed to Information Systems for review.

Enter '''DL''' to delete and press '''enter'''

[[File:nancy23.png|500px]]

===Posting batch after Error Correction===
#Enter '''PO''' to post file and press '''enter'''
#Press '''enter''' again to post file into ASW

[[File:nancy24.png|500px]]

*When file has been posted, the status will be '''Posted'''
*Do not re-import or re-post a file into ASW

===Importing Control File Worksheet===
#Goto {{unc|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing}}
#Enter '''imported date,actual date, file#, lines, amount and importer and any important notes'''
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
#Click '''save'''

===Returning Cheque in CIBC===
1.Go back to the '''CIBC CMO website'''

2.Click '''Cheque Services'''

3.Click '''Cheque Inquiry'''

4.Click on the correct account '''16512'''

5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''

[[File:nancy27.png|500px]]
[[File:nancy28.png|500px]]

6.Click the '''box''' to highlight all cheque images

7.Click '''Cheque image'''

8.Scan through all the '''cheque images''' to make sure there was no cheque tampering done. If there was, make sure to report it within '''24 hours to CIBC'''. You do not need to print the cheque image report.

[[File:nancy29.png|500px]]

===Corporate Clearing Online Decision===
[[File:nancy35.png|500px]]

[[File:nancy31.png|500px]]

[[File:nancy33.png|500px]]

[[File:nancy34.png|500px]]

*All returned items must be submitted by the '''cut-off time of 1pm''' or all items will be paid.
*'''Intria''' will handle later day instructions:
Fax later day returns no later than '''12 noon''' (local time) the following day to Intria '''(FAX #1-866-463-9004)'''
Include the following details on the fax page:
*Posting date
*Cheque Serial Number
*Cheque Amount
*Return Reason
*Call 1-888-947-7736 (Helpdesk) if you need to contact the bank (Client #1225510BC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC-Downloading Cheque Clearing File

2019-10-29T16:49:04Z

Harmanr: /* Downloading File */

==Overview==
'''Corporate Clearing Services''' offers clients issuing a high volume of cheques reduced chequing cost due to the customer being responsible for cheque verification and returning any irregular items to the Bank. A unique pseudo transit '''30120''' has been created and a bulk debit is made to the associated branch account '''00900''' for the total amount of the cheques cleared. Multiple accounts can be associated with a pseudo transit number. A computer file is generated each morning of cheques drawn on our bank account under the previous day’s date. The information contained in the file will include all information contained within the MICR line of our cheques.

==Corporate Clearing Contacts==
*UWD Contact - Nancy Ng (local 202) [mailto:nancyn@unipharm.com Nancy Ng]
*UWD I.S. Contact - Norwin Uy (local 218) [mailto:norwinu@unipharm.com Norwin Uy]
*CIBC, Cash Management Manager - Edward Woo [mailto:edward.woo@cibc.ca Edward Woo] Tel: 604-665-1167, Fax: 604-665-1841
*CIBC Helpdesk: T: 1-800-500-6316 (ask Nancy to contact bank if required)
*CIBC F: 1-866-463-9004 or 1-905-415-0798

==Logging into CIBC==
#Open your supported web browser
#Logo into [https://cmo.cibc.com/wp/wps/portal/bbdsignon CIBC]
#Enter your 16 digit '''User ID''' (only an authorized user will be issued a User ID)
#Enter your '''token number''' (from your CIBC FOB)
#Enter your '''PIN'''
#Click the ''''Sign On'''' button

[[File:nancy11.png|500px]]

===Downloading File===
*Navigate to CMO -> Reporting -> Cash Management Reports
*Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
*There will be 2 types of files:

#CCRAW – Corporate Clearing File
*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
*Change file name by clicking into the Archive folder and selecting the most recent file. Change date in file name to today’s date.
*For example, for October 29, select the most recent file (for Oct 28) and then change the file name to CL102919 for October 29th.
*Go back into the CIBC folder and save the file. If the file is saved in the Archive folder it will not be able to import into the system.

#EFRPT – Input File Totals for CIBC EFTs
*Print and staple these to the previous days EFT batch. Ensure the amounts match.

# Print Daily Transaction Report
*This will be used to clear the Cashbook
*Click Back to Dashboard (in the menu at the top of the screen) to return to the main menu in CIBC
*Select Information Reporting and click Edit for Prior Day Transaction Detail. Select prior day’s date, select the correct bank account (CAD uniPHARM Wholesale Drugs Ltd.), and add to accounts included in report before viewing report and printing

[[File:nancy13.png|500px]]

===Import File to ASW===
1.Go to green screen and click '''1''' (VA Company Production) - '''1''' (UWD Extensions) - '''70''' (Bank EDI)

2.Enter '''FW''' next to CIBC (file waiting to import) and press '''enter'''

[[File:nancy14.png|500px]]

3.Enter '''IM''' next to file to be imported and press '''enter''' (when file has been imported, the file name will disappear)

4.Press '''F12''' to move back to previous panel

5.If imported file does not have an error, the file will be posted automatically.

[[File:nancy15.png|500px]]

===Viewing File with Error===

1.Enter '''FI''' to view file with error and press '''enter'''

[[File:nancy16.png|500px]]

2.For errors, move to file and enter '''DT''' for details and press '''enter'''

[[File:nancy17.png|500px]]

3.Move to Errors only? and enter '''Y''' (this shows only transactions with errors) and press '''enter'''

[[File:nancy18.png|500px]]

4.Enter '''DT''' for detail on transaction with errors and press '''enter'''

[[File:nancy19.png|500px]]

===Correcting File with Error===

====Exceptions which are correctable====
*Encoding error
*Items cleared in the wrong currency (change amount to match ASW system amount)
*All other issues must be directed to Information Systems for review.

#For Encoding error, change the '''amount''' to match the ASW system amount. Note: encoding errors > $10 may be claimed back from bank
#Change '''header total''' to match the change and press '''enter'''
#Press '''F3'''

[[File:nancy21.png|500px]]

====Exceptions which are to be returned to bank====

*Stale-dated (cheques older than six months which have been cashed but VOID in ASW system (delete transaction)
*Encoding error (greater than $10)
*Fraudulent signature (delete transaction)
*Payment stopped (delete transaction)
*All other issues must be directed to Information Systems for review.

Enter '''DL''' to delete and press '''enter'''

[[File:nancy23.png|500px]]

===Posting batch after Error Correction===
#Enter '''PO''' to post file and press '''enter'''
#Press '''enter''' again to post file into ASW

[[File:nancy24.png|500px]]

*When file has been posted, the status will be '''Posted'''
*Do not re-import or re-post a file into ASW

===Importing Control File Worksheet===
#Goto {{unc|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing|\\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing}}
#Enter '''imported date,actual date, file#, lines, amount and importer and any important notes'''
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
#Click '''save'''

===Returning Cheque in CIBC===
1.Go back to the '''CIBC CMO website'''

2.Click '''Cheque Services'''

3.Click '''Cheque Inquiry'''

4.Click on the correct account '''16512'''

5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''

[[File:nancy27.png|500px]]
[[File:nancy28.png|500px]]

6.Click the '''box''' to highlight all cheque images

7.Click '''Cheque image'''

8.Scan through all the '''cheque images''' to make sure there was no cheque tampering done. If there was, make sure to report it within '''24 hours to CIBC'''. You do not need to print the cheque image report.

[[File:nancy29.png|500px]]

===Corporate Clearing Online Decision===
[[File:nancy35.png|500px]]

[[File:nancy31.png|500px]]

[[File:nancy33.png|500px]]

[[File:nancy34.png|500px]]

*All returned items must be submitted by the '''cut-off time of 1pm''' or all items will be paid.
*'''Intria''' will handle later day instructions:
Fax later day returns no later than '''12 noon''' (local time) the following day to Intria '''(FAX #1-866-463-9004)'''
Include the following details on the fax page:
*Posting date
*Cheque Serial Number
*Cheque Amount
*Return Reason
*Call 1-888-947-7736 (Helpdesk) if you need to contact the bank (Client #1225510BC)

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:GST

2019-10-25T16:17:10Z

Harmanr:

Category:GST

2019-10-25T16:09:13Z

Harmanr: Created blank page

Accounting Finance:GST

2019-10-24T19:52:11Z

Harmanr:

Accounting Finance:GST

2019-10-24T19:51:28Z

Harmanr:

Accounting Finance:GST

2019-10-24T19:50:31Z

Harmanr: /* GST Worksheet */

GST remittances are made monthly before the end of the the following month. Check with Nancy, Finance Manager, before making GST remittance to ensure that the month has been closed and no more entries are able to be posted into the previous month.

== GST Worksheet ==
*Navigate to the GST folder and '''create a copy of the GST worksheet'''. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for.
*Enter values for '''GL 122500 and 122000''' in correct columns for current month. Add '''GST received''' in column E
*Enter GST deposits/payments made in the month in the correct column (column I/K)
*'''Update and drag formulas''' in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. '''Discrepancies''' may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the '''adjustment''' cell.
*'''Ensure totals for Current and Year to Date Sections match'''

== CRA Netfile ==
*Once worksheet is complete and totals match, navigate to '''[https://www.canada.ca/en/revenue-agency/services/e-services/e-services-businesses/gst-hst-netfile.html CRA Netfile Website]'''
*Enter the '''business number and Access code''' (can find in top left corner of GST worksheet). Enter dates reporting for (previous month). Click 'Next'
*Enter '''sales figure''' in Line 101 (same on used in PST calculation)
*Enter current from GL '''122500''' in '''Line 105'''
*Enter current for GL '''122000''' in '''Line 108'''
*'''Verify''' total matches the total in the worksheet
*Submit
*Save a copy of the return in the GST folder

Accounting Finance:GST

2019-10-24T19:49:08Z

Harmanr: /* CRA Netfile */

GST remittances are made monthly before the end of the the following month. Check with Nancy, Finance Manager, before making GST remittance to ensure that the month has been closed and no more entries are able to be posted into the previous month.

== GST Worksheet ==
*Navigate to the GST folder and create a copy of the GST worksheet. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for.
*Enter values for GL 122500 and 122000 in correct columns for current month. Add GST received in column E
*Enter GST deposits/payments made in the month in the correct column (column I/K)
*Update and drag formulas in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. Discrepancies may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the adjustment cell.
*Ensure totals for Current and Year to Date Sections match

== CRA Netfile ==
*Once worksheet is complete and totals match, navigate to '''[https://www.canada.ca/en/revenue-agency/services/e-services/e-services-businesses/gst-hst-netfile.html CRA Netfile Website]'''
*Enter the '''business number and Access code''' (can find in top left corner of GST worksheet). Enter dates reporting for (previous month). Click 'Next'
*Enter '''sales figure''' in Line 101 (same on used in PST calculation)
*Enter current from GL '''122500''' in '''Line 105'''
*Enter current for GL '''122000''' in '''Line 108'''
*'''Verify''' total matches the total in the worksheet
*Submit
*Save a copy of the return in the GST folder

Accounting Finance:GST

2019-10-24T19:47:45Z

Harmanr:

GST remittances are made monthly before the end of the the following month. Check with Nancy, Finance Manager, before making GST remittance to ensure that the month has been closed and no more entries are able to be posted into the previous month.

== GST Worksheet ==
*Navigate to the GST folder and create a copy of the GST worksheet. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for.
*Enter values for GL 122500 and 122000 in correct columns for current month. Add GST received in column E
*Enter GST deposits/payments made in the month in the correct column (column I/K)
*Update and drag formulas in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. Discrepancies may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the adjustment cell.
*Ensure totals for Current and Year to Date Sections match

== CRA Netfile ==
*Once worksheet is complete and totals match, navigate to [https://www.canada.ca/en/revenue-agency/services/e-services/e-services-businesses/gst-hst-netfile.html CRA Netfile Website]
*Enter the business number and Access code (can find in top left corner of GST worksheet). Enter dates reporting for (previous month). Click 'Next'
*Enter sales figure in Line 101 (same on used in PST calculation)
*Enter current from GL 122500 in 'Line 105'
*Enter current for GL 122000 in 'Line 108'
*Verify total matches the total in the worksheet
*Submit
*Save a copy of the return in the GST folder

Accounting Finance:GST

2019-10-24T19:44:52Z

Harmanr: Created page with "== GST Worksheet == *Navigate to the GST folder and create a copy of the GST worksheet. Paste in the corresponding year's folder. Rename original worksheet to month GST is bei..."

== GST Worksheet ==
*Navigate to the GST folder and create a copy of the GST worksheet. Paste in the corresponding year's folder. Rename original worksheet to month GST is being prepared for.
*Enter values for GL 122500 and 122000 in correct columns for current month. Add GST received in column E
*Enter GST deposits/payments made in the month in the correct column (column I/K)
*Update and drag formulas in the bottom section of the worksheet to the current month's cells. Enter the year to date values for GL 122000 and 122500. Discrepancies may be due to late receipts/entries of GST received/paid. Check the next period to ensure. If so, enter timing differences into the adjustment cell.
*Ensure totals for Current and Year to Date Sections match

== CRA Netfile ==
*Once worksheet is complete and totals match, navigate to [https://www.canada.ca/en/revenue-agency/services/e-services/e-services-businesses/gst-hst-netfile.html CRA Netfile Website]
*Enter the business number and Access code (can find in top left corner of GST worksheet). Enter dates reporting for (previous month). Click 'Next'
*Enter sales figure in Line 101 (same on used in PST calculation)
*Enter current from GL 122500 in 'Line 105'
*Enter current for GL 122000 in 'Line 108'
*Verify total matches the total in the worksheet
*Submit
*Save a copy of the return in the GST folder

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T18:11:10Z

Harmanr: /* Submit Monthly Report to PST */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T18:10:02Z

Harmanr: /* Submit Monthly Report to PST */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==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/_/]
#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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T18:09:19Z

Harmanr: /* Submit Monthly Report to PST */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T18:08:33Z

Harmanr: /* Submit Monthly Report to PST */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#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/_/
#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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T17:58:36Z

Harmanr: /* Generate PST Worksheet */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#We are now ready to submit our monthly fees to PST. Log into web browser – go to [http://www2.gov.bc.ca/gov/topic.page?id=78521DE3BD5D46C9A3B17631207A0AD7 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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T17:58:02Z

Harmanr: /* Generate PST Worksheet */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#We are now ready to submit our monthly fees to PST. Log into web browser – go to [http://www2.gov.bc.ca/gov/topic.page?id=78521DE3BD5D46C9A3B17631207A0AD7 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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T17:56:35Z

Harmanr: /* Generate PST Worksheet */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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 - found in text. if no invoice number 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'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#We are now ready to submit our monthly fees to PST. Log into web browser – go to [http://www2.gov.bc.ca/gov/topic.page?id=78521DE3BD5D46C9A3B17631207A0AD7 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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T17:55:48Z

Harmanr: /* Generate PST Worksheet */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#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''' 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 - found in text. if no invoice number 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'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#We are now ready to submit our monthly fees to PST. Log into web browser – go to [http://www2.gov.bc.ca/gov/topic.page?id=78521DE3BD5D46C9A3B17631207A0AD7 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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2019-10-24T17:49:32Z

Harmanr: /* Generate PST Worksheet */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Copy the previous month’s PST spreadsheet into the corresponding year’s folder before starting. Rename spreadsheet to current month.
#Log into PST Worksheet {{unc|\\superserver.unipharm.local\Accounting\harmanr\Taxes\PST| PST Worksheet}}
#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)
#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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#We are now ready to submit our monthly fees to PST. Log into web browser – go to [http://www2.gov.bc.ca/gov/topic.page?id=78521DE3BD5D46C9A3B17631207A0AD7 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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:BC Light Recycle-Monthly Report-Surcharges

2019-10-23T21:08:27Z

Harmanr: /* Submit Monthly Report to CESA */

==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''' [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==
#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''''
#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''''BC
#Copy data to '''BC Light Recycle Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|BC Light Recycle Worksheet}}
#Create '''sub-totals''' for each '''type'''
#Print '''sheet''' and save '''file'''

[[File:nancy6.png|500px]]
[[File:nancy5.png|500px]]

==Submit Monthly Report to CESA==
#We are now ready to submit our monthly fees to BC Recycling. Log into web browser – go to [https://ehfreporting.com|BC Recycling]
#Click '''Light Recycle'''
#Enter User Name: ''''UNIPHARM'''' and Password: ''''jt2051''''
#Click '''Log in'''
#Click '''British Columbia''' and select the Mark the applicable '''year''' and the applicable '''month'''
#Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
#Click '''Save and Continue'''
#Enter description of methodology '''sales to BC customers from uniPHARM's inventory'''
#Click '''box''' to confirm that brand listing is up to date and enter '''applicable date'''
#Click '''Save and Continue'''
#Click '''EFT (Electronic Fund Transfer'''
#Click '''Save and Continue'''
#Click '''box''' to agree
#Click '''Submit Report'''
#Click '''Ok'''
#Click '''Download Monthly Invoice as PDF'''
#Print '''Invoice''' and attach with '''printout of worksheet'''
#Forward to '''Payroll & Benefits Administrator for processing'''
#Click '''Log out''' to logout of BC Light Recycle

[[File:nancy7.png|500px]]

[[Category:BC Light]]

Accounting Finance:BC Light Recycle-Monthly Report-Surcharges

2019-10-23T21:07:42Z

Harmanr: /* Submit Monthly Report to CESA */

==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''' [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==
#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''''
#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''''BC
#Copy data to '''BC Light Recycle Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|BC Light Recycle Worksheet}}
#Create '''sub-totals''' for each '''type'''
#Print '''sheet''' and save '''file'''

[[File:nancy6.png|500px]]
[[File:nancy5.png|500px]]

==Submit Monthly Report to CESA==
#We are now ready to submit our monthly fees to BC Recycling. Log into web browser – go to [https://ehfreporting.com/|BC Recycling]
#Click '''Light Recycle'''
#Enter User Name: ''''UNIPHARM'''' and Password: ''''jt2051''''
#Click '''Log in'''
#Click '''British Columbia''' and select the Mark the applicable '''year''' and the applicable '''month'''
#Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
#Click '''Save and Continue'''
#Enter description of methodology '''sales to BC customers from uniPHARM's inventory'''
#Click '''box''' to confirm that brand listing is up to date and enter '''applicable date'''
#Click '''Save and Continue'''
#Click '''EFT (Electronic Fund Transfer'''
#Click '''Save and Continue'''
#Click '''box''' to agree
#Click '''Submit Report'''
#Click '''Ok'''
#Click '''Download Monthly Invoice as PDF'''
#Print '''Invoice''' and attach with '''printout of worksheet'''
#Forward to '''Payroll & Benefits Administrator for processing'''
#Click '''Log out''' to logout of BC Light Recycle

[[File:nancy7.png|500px]]

[[Category:BC Light]]

Accounting Finance:CESA-Monthly Report-Surcharges

2018-12-28T17:30:27Z

Harmanr: /* Submit Monthly Report to CESA */

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

==Contacts==
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==
#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''''
#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}}
#Create '''sub-totals''' for each '''type'''
#Print '''sheet''' and save '''file
'''
[[File:cesa.png|500px]]

[[File:cesa2.png|500px]]

==Submit Monthly 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]
#Click '''Stewards'''
#click '''Report & Remit'''
#Enter User Name: ''''uniPHARM'''' and Password: ''''UWD2051''''
#Click '''Log in'''
#Mark '''File/View Reports''' and select the applicable '''month'''
#Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
#Click '''Save and Continue'''
#Enter description of methodology '''sales to BC customers from uniPHARM's inventory'''
#Click '''box''' to confirm that brand listing is up to date and enter '''applicable date'''
#Click '''Save and Continue'''
#Click '''EFT (Electronic Fund Transfer'''
#Click '''Save and Continue'''
#Click '''box''' to agree
#Click '''Submit Report'''
#Click '''Ok'''
#Click '''Download Monthly Invoice as PDF'''
#Print '''Invoice''' and attach with '''printout of worksheet'''
#Forward to '''Payroll & Benefits Administrator for processing'''
#Click '''Log out''' to logout of CESA

[[File:cesa3.png|500px]]

[[Category:CESA]]

Accounting Finance:EPRA - Yukon Recycling

2018-11-22T20:35:27Z

Harmanr:

== Summary ==
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 October 2018.

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

== 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 ==

* Generate the Surcharge report in ASW.
*In ASW – '''system management''' – '''query manager''' – '''run a query request'''.
*Select – ''''surcharge'''' – enter date range for '''previous''' month, enter '''surcharge type 12''' and press 'enter'
*Once report is finished running, go to '''superserver/staging/harmanr'''. Open up '''surch.csv'''
*Copy data to Yukon Recycling Fee Worksheet
*Create subtotals for each file type
*Print and save the worksheet

== Submit Monthly Report ==
* Log onto [https://reporting.recyclemyelectronics.ca/index.php?process=login_frontoffice EPRA Yukon Recycling Website ]
*User: '''jtargett'''
*Password '''2051uniPHARM2051$'''
*Click '''Monthly Declarations''' – you should see open declarations and the month that you are submitting for. Click to open.
*Enter '''quantities''' from the amounts generated in the surcharge report
*Once finished click '''Submit Monthly Declaration'''
*Click '''Here''' to view and print the invoice
*Submit the invoice along with the printed worksheet to '''Payroll & Benefits Administration'''

[[Category:EPRA]]

Accounting Finance:EPRA - Yukon Recycling

2018-11-22T20:24:42Z

Harmanr: /* Submit Monthly Report */

Accounting Finance:EPRA - Yukon Recycling

2018-11-22T20:19:53Z

Harmanr: /* Generate Surcharge Report */

== Summary ==
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 October 2018.

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

== 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 ==

* Generate the Surcharge report in ASW.
*In ASW – '''system management''' – '''query manager''' – '''run a query request'''.
*Select – ''''surcharge'''' – enter date range for '''previous''' month, enter '''surcharge type 12''' and press 'enter'
*Once report is finished running, go to '''superserver/staging/harmanr'''. Open up '''surch.csv'''
*Copy data to Yukon Recycling Fee Worksheet
*Create subtotals for each file type
*Print and save the worksheet

== Submit Monthly Report ==
* Log onto EPRA [https://reporting.recyclemyelectronics.ca/index.php?process=login_frontoffice EPRA Yukon Recycling ]

Accounting Finance:EPRA - Yukon Recycling

2018-11-22T20:13:27Z

Harmanr: /* Generate Surcharge Report */

Accounting Finance:EPRA - Yukon Recycling

2018-11-22T20:12:32Z

Harmanr: /* Summary */

Accounting Finance:EPRA - Yukon Recycling

2018-11-22T20:05:19Z

Harmanr:

Accounting Finance:EPRA - Yukon Recycling

2018-11-22T20:04:50Z

Harmanr: Created page with "The Electronic Products Recycling Association (EPRA) has identified specific product categories that we are required to submit recycling fees on behalf of our retail pharmacie..."

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 October 2018.

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

Accounting Finance:CIBC-Entering eDEPOSITS

2018-10-19T17:30:41Z

Harmanr: /* Logging into CIBC */

==Overview==
CIBC eDeposit business solutions help you save time and improve cash flow by allowing you to securely deposit your cheques into your account from the convenience of your office.

==eDeposit Restrictions==
*Cheque images are stores electronically at CIBC for up to 120 days
*Hold original cheques and destroy after 30 days
*CIBC eDeposit limit - $250,000 per deposit
*Process only Canadian cheques/drafts
*Upload cheques before 4pm (PST) for same day deposit

==eDeposit Contacts==
*UWD I.S. Contact – contact Norwin Uy (local 218) [mailto:norwinu@unipharm.com Norwin Uy]
* CIBC Helpdesk: T: 1-800-500-6316 (ask Nancy to contact bank if required) [mailto:nancyn@unipharm.com Nancy Ng]

==Logging into CIBC==
#Enter cheques into ASW prior to scanning & uploading to CIBC – goto FIN-AR-022 (Work with manual cheques)
#Open your supported web browser
#Logo into [http://cibc.com/edeposit/signon http://cibc.com/edeposit/signon]
#Type in the 16 digit User ID ''''4506449491313128''''
#Type in the Password ''''UWD2037'''' (case sensitive)
#Click the ''''Sign On'''' button

[[File:cibc11.png|500px]]

===Connecting Your Scanner===
*Scanner is on the scanning station.
*Place the scanner on a flat surface at least '''6 inches''' from your computer
*Connect the '''power cord''' from the power supply to the power connection on the scanner
*Connect the '''power supply''' to the AC outlet
*Make sure the scanner is turned '''off'''. Verify that the '''red power''' indicator on the control panel is lit
*Connect the '''USB cable''' supplied with the scanner to the scanners USB connector
*Connect the '''other end''' of the USB cable to an available USB port on your computer

===Scanning Cheque into CIBC===
*Click ''''Create New Deposit'''' button on the right side of the Welcome Page (you will be taken to the New Deposit page where you will need to enter the details of your deposit

[[File:cibc10.png|500px]]

===Enter New Deposit===
*Choose the account you wish to credit (UWD or UMC Charity)
*Enter '''User Code''' under Optional field 1 (firstname and first initial of last name)
*Enter '''number of cheques''' (add an extra item for batch total)
*Enter '''batch total'''

[[File:cibc3.png|500px]]

===Capture Data===
*Once you have completed the fields, you are ready to begin scanning your cheques.
*Place '''ONE cheque''' in the scanner facing outward
*Next, click ''''Capture''''
*After a moment your cheque will begin to feed through the scanner.
*After the first cheque has been scanned, place the '''next cheque''' in the scanner facing outward until completed.

===Deposit Item List Page===
*After the cheques have completed scanning, the Deposit Item List page will display a list of your scanned cheques as well as your Virtual Deposit Slip.
*Text recognition software will read key details from your cheques including the value, and source account number. These details will be presented on screen.
*If the complete button is '''green''' there are no errors, goto [[#Upload Cheques to CIBC]].
*If the complete button is '''red''', you have an error that needs to be fixed or your deposit is not balanced and you’ll need to make adjustments.
*'''Edit:''' allows you to edit an item’s details
*'''Delete:''' allows you to delete a selected item
*'''Add Items:''' If you forgot a cheque or deleted an item, you can add them to the deposit by using the Add Items button.
*'''Back to Deposit List:''' Takes you back to your deposit list. All items scanned will be saved in the system and you can return to them later.
*'''Delete Deposit:''' Deletes the entire deposit, including the scanned cheques.
*'''Failed Image Quality:''' rescan cheque - if failed image quality persists, deposit cheque manually to the bank via courier

====Balancing Differences====

[[File:cibc4.png|500px]]

[[File:cibc5.png|500px]]

====Fixing Errors During Deposit====

[[File:cibc6.png|500px]]

[[File:cibc7.png|500px]]

====Cheque Error====

[[File:cib12.png|500px]]

[[File:cibc13.png|500px]]

===Deposit Flow Chart===

[[File:cibc8.png|500px]]

===Upload Cheques to CIBC===
#Click ''''Complete'''' The complete button will be '''green''' when you are able to complete your deposit. If the complete button is '''red''', you likely have an error that needs to be fixed or your deposit is not balanced and you’ll need to make adjustments.
#Click ''''OK'''' when you are sure you want to complete the deposit.

[[File:cibc9.png|500px]]

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:Statements-Printing List of Customers with Debit Payment Types

2018-09-28T16:51:59Z

Harmanr: /* Settling Debits against Credits */

==Overview==
Print report listing customers with debit payment types

==Before Running Statements==
*The auto cash application does not correctly deal with ’source’ type documents (payments) that have a debit amount – it ignores them.
*Any accounts with this type of transaction will have to be manually settled.
*Run the report before running statements.
*For each customer listed on report, look into ASW A/R balance inquiry to see if there are any credits to settle these transactions against. If so, do so.

==Printing List of Customers with Debit Payment Types==

:1. Select '''System management'''

[[File:SettlingDebits1.png|400px]]

:2. Select '''Query manager'''

[[File:SettlingDebits2.png|400px]]

:3. Select '''Run a query request'''

[[File:SettlingDebits3.png|400px]]

:4. Double-click '''FINAR001 - List customers with debit payment types'''

[[File:SettlingDebits4.png|400px]]

:5. Change '''Printer''' to '''LP05'''

:6. Press '''Enter'''

:7. For each customer listed, look into ASW A/R balance inquiry to see if there are any credits to settle these transactions against.

[[File:SettlingDebits5.png|400px]]

==Settling Debits against Credits==

In ASW:
:1. Click '''ASW fastpath'''

:2. Click '''Cash management'''

:3. Click '''A/R cash management tasks'''

:4. Click '''A/R invoicing tasks'''

:5. Click '''Enter financial transactions'''

[[File:SettlingDebits6.png|400px]]

:6. Enter '''Voucher type''' (25 - A/R Manual Housekeeping)

:7. Press '''Enter'''

[[File:SettlingDebits7.png|400px]]

:8. Select '''Add''' to add new entry

[[File:SettlingDebits8.png|400px]]

:9. Enter '''Document type'''

:10. Enter '''Document number'''

:11. Press '''Enter'''

[[File:SettlingDebits9.png|400px]]

:12. Double-click selected transaction

*Try to use the same transaction type ie. MC to MC, CVI to VI or CMC to MC (Can apply to future periods if no past)

*Don't do VT type or CHK

*Settle VOD's otherwise they will remain unsettled. (Can apply to any type)

*For EFT, only pull for the period previous

* Don't apply to Invoices

:13. If nothing to put it against, press '''Cancel settlement''' twice
::'''OR''' select '''Update''' when completed

[[File:SettlingDebits10.png|400px]]

:14. Select '''F12''' to move back to previous panel

[[File:SettlingDebits11.png|400px]]

:15. Select '''F3''' when completed

[[File:SettlingDebits12.png|400px]]

:16. Press '''Enter'''

[[File:SettlingDebits13.png|400px]]

:17. Mark '''Close batch'''
:18. Change '''Printer queue''' to '''PRT01''' (no need to print)
:19. Press '''Enter'''

[[File:SettlingDebits14.png|400px]]

:20. Press '''Enter'''

[[File:SettlingDebits15.png|400px]]

[[Category:Workflows-Finance]]
[[Category:Accounts Receivable]]

Accounting Finance:BC Light Recycle-Monthly Report-Surcharges

2018-07-24T17:27:48Z

Harmanr: /* Overview */

==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''' [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==
#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''''
#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''''BC
#Copy data to '''BC Light Recycle Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|BC Light Recycle Worksheet}}
#Create '''sub-totals''' for each '''type'''
#Print '''sheet''' and save '''file'''

[[File:nancy6.png|500px]]
[[File:nancy5.png|500px]]

==Submit Monthly Report to CESA==
#We are now ready to submit our monthly fees to BC Recycling. Log into web browser – go to [https://ehfreporting.com|BC Recycling]
#Click '''Light Recycle'''
#Enter User Name: ''''UNIPHARM'''' and Password: ''''jt2051''''
#Click '''Log in'''
#Click '''British Columbia''' and select the Mark the applicable '''year''' and the applicable '''month'''
#Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
#Click '''Save and Continue'''
#Enter description of methodology '''sales to BC customers from uniPHARM's inventory'''
#Click '''box''' to confirm that brand listing is up to date and enter '''applicable date'''
#Click '''Save and Continue'''
#Click '''EFT (Electronic Fund Transfer'''
#Click '''Save and Continue'''
#Click '''box''' to agree
#Click '''Submit Report'''
#Click '''Ok'''
#Click '''Download Monthly Invoice as PDF'''
#Print '''Invoice''' and attach with '''printout of worksheet'''
#Forward to '''Payroll & Benefits Administrator for processing'''
#Click '''Log out''' to logout of BC Light Recycle

[[File:nancy7.png|500px]]

[[Category:BC Light]]

Accounting Finance:PST-Monthly Report-Remittance

2018-05-29T17:28:52Z

Harmanr: /* Generate PST Worksheet */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Log into PST Worksheet {{unc|\\superserver.unipharm.local\Accounting\harmanr\Taxes\PST| PST Worksheet}}
#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)
#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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''Summary''' page in columns G and I
#Save '''worksheet'''
#Print the '''Summary''' and the '''AR-AP in-out''' sheets
#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
*The '''AR/AP''' row should balance to the sum of the '''In-Out''' transactions

==Submit Monthly Report to PST==
#We are now ready to submit our monthly fees to PST. Log into web browser – go to [http://www2.gov.bc.ca/gov/topic.page?id=78521DE3BD5D46C9A3B17631207A0AD7 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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:PST-Monthly Report-Remittance

2018-05-29T17:01:17Z

Harmanr: /* Generate PST Worksheet */

==Overview==
Reporting and paying tax means filing a tax return and paying the government the tax you charged on your sales and PST you owe on the purchases you made to run your business.

You must report and pay to us all PST and municipal and regional district tax (MRDT) you have charged, whether or not you have actually collected it from your customer. This includes tax you may have charged incorrectly, such as:
at an incorrect rate (for example, you charged 10% PST on general goods instead of 7%)
on a non-taxable good or service

We are responsible for submitting '''monthly remittances''' Our PST number is '''PST-1000-9145'''. A copy of our PST registration is saved in DocView/Licenses.

[[File:nancyn3.png|500px]]

==Contacts==
*The main contact is the '''Manager, Finance''' [mailto:nancyn@unipharm.com Nancy Ng]. Please direct all questions to the Manager, Finance.

*PST Helpdesk (8:30 AM to 4:30 PM)
Tel: 1-877-388-4440
Email: CTBTaxQuestions@gov.bc.ca

==Generate PST Worksheet==
#Log into PST Worksheet {{unc|\\superserver.unipharm.local\Accounting\harmanr\Taxes\PST| PST Worksheet}}
#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-80, 10, 30, 50)
#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)
#The '''total''' should match total in the '''Current year sheet'''
#Enter the '''total''' for the in/out transaction in the '''current year sheet''' in column F and H
#Save '''worksheet'''
#Print the '''current year sheet''' and the '''AR-AP in-out sheet'''

==Submit Monthly Report to PST==
#We are now ready to submit our monthly fees to PST. Log into web browser – go to [http://www2.gov.bc.ca/gov/topic.page?id=78521DE3BD5D46C9A3B17631207A0AD7 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)
#After obtaining the access code, enter the '''access code''' and click '''login'''
#Click '''Provincial Sales Tax'''
#Click '''File Return''' on the applicable month
#Enter Step 1 - Total Sales & Leases (obtain from financial statement)
#Enter Step 2 B - PST Collectable on Sales and Leases (Use Sales SO/AR) total)
#Enter Step 3 E - Purchase and Lease Price of Taxable Goods, Software and Services (use total on AP/GL row)
#Enter Step 3 F - PST Due on Purchases and Lease (use total AP/GL)
#Check Step 5 - the '''Total Amount Due''' and match it to worksheet
#Click '''Submit'''
#Click '''Print Return''' and print
#Click '''Make a Payment'''
#Enter '''Confirmed Amount''' and click '''I hereby authorize....'''
#Click '''Submit'''
#Click '''Print''' and print two copies
#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.

[[File:nancy4.png|500px]]

[[Category:PST]]

Accounting Finance:BC Light Recycle-Monthly Report-Surcharges

2018-05-28T20:38:46Z

Harmanr:

==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 6'''. 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''' [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==
#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''''
#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''''BC
#Copy data to '''BC Light Recycle Fee worksheet''' (use most current fiscal year) {{unc|\\SUPERSERVER\Accounting\nancyn\Excel\Monthly Tax and Accruals|BC Light Recycle Worksheet}}
#Create '''sub-totals''' for each '''type'''
#Print '''sheet''' and save '''file'''

[[File:nancy6.png|500px]]
[[File:nancy5.png|500px]]

==Submit Monthly Report to CESA==
#We are now ready to submit our monthly fees to BC Recycling. Log into web browser – go to [https://ehfreporting.com|BC Recycling]
#Click '''Light Recycle'''
#Enter User Name: ''''UNIPHARM'''' and Password: ''''jt2051''''
#Click '''Log in'''
#Click '''British Columbia''' and select the Mark the applicable '''year''' and the applicable '''month'''
#Enter the '''quantity''' for each applicable item. (the total fees should match your worksheet)
#Click '''Save and Continue'''
#Enter description of methodology '''sales to BC customers from uniPHARM's inventory'''
#Click '''box''' to confirm that brand listing is up to date and enter '''applicable date'''
#Click '''Save and Continue'''
#Click '''EFT (Electronic Fund Transfer'''
#Click '''Save and Continue'''
#Click '''box''' to agree
#Click '''Submit Report'''
#Click '''Ok'''
#Click '''Download Monthly Invoice as PDF'''
#Print '''Invoice''' and attach with '''printout of worksheet'''
#Forward to '''Payroll & Benefits Administrator for processing'''
#Click '''Log out''' to logout of BC Light Recycle

[[File:nancy7.png|500px]]

[[Category:BC Light]]

Accounting Finance:Auto Cash-Running Auto Cash

2018-05-10T18:57:42Z

Harmanr: /* Running Auto Cash */

==Overview==
*Auto Cash is run to settle payments to transactions
*Auto cash is run on the 15th and last day of the month

==Statement Format==
*There are two types of statements that can be created.
#Balance Forward statements have an opening balance and show only current transactions for the period. All new customers and shareholders are Balance Forward types.
*Open Item Statements provide a detailed list of all customer transactions associated with an Open Item for the statement period.

==Running Auto Cash==

:1. Select '''2 Start uniPharm Extensions'''

[[File:AutoCash1.PNG|400px]]

:2. Select '''1 VA Company (PRODUCTION)'''

[[File:AutoCash2.PNG|400px]]

:3. Select '''1 UWD Extensions'''

[[File:AutoCash3.PNG|400px]]

:4. Select '''44 Auto Cash'''

[[File:AutoCash4.PNG|400px]]

:5. Select '''1 Run Auto Cash'''

[[File:AutoCash5.PNG|400px]]

:6. Select all customers (Y/N) ? '''Y'''

:7. Interactive or batch (I/B) ? '''B'''

:8. Click '''F10''' to run/submit process

[[File:AutoCash6.PNG|400px]]

:9. Press '''Enter''' to confirm

[[File:AutoCash7.PNG|400px]]

:10. Click '''F12''' to go back to previous panel

[[File:AutoCash6.PNG|400px]]

:11. Select '''3 Show list of runs'''

[[File:AutoCash8.PNG|400px]]

:12. There should be '''2''' batches for each auto cash run. '''Both''' will be posted separately.

:13. They should be both Status '''PO''' when completed; however, it could be '''IN''' if there are no transactions in the batch.

[[File:AutoCash9.PNG|400px]]

===Closing Batch in A/R===
:1. Click '''ASW fastpath'''
:2. Click '''Cash management'''
:3. Click '''A/R cash management tasks'''
:4. Click '''A/R invoicing tasks'''
:5. Click '''Enter financial transactions'''

[[File:AutoCash10.png|400px]]

:6. Click '''Select batch number'''

[[File:AutoCash11.png|400px]]

:7. Mark first '''Auto Cash''' transaction

:8. Press '''Enter'''

[[File:AutoCash12.png|400px]]

:9. Press '''F3'''

[[File:AutoCash13.png|400px]]

:10. Click '''Close batch'''

:11. Change '''Printer queue''' to '''PRT01''' (no need to print)

:12. Press '''Enter'''

:13. '''Repeat for 2nd batch'''

[[File:AutoCash14.png|400px]]

[[Category:Workflows-Finance]]
[[Category:Accounts Receivable]]