Difference between revisions of "Accounting Finance:CIBC-Downloading Cheque Clearing File"

From uniWIKI
Jump to navigation Jump to search
 
(11 intermediate revisions by the same user not shown)
Line 21: Line 21:
 
===Downloading File===
  
===Downloading File===
 
#Navigate to CMO -> Reporting -> Cash Management Reports
  
#Navigate to CMO -> Reporting -> Cash Management Reports
  +
  ⚫
[[File:CMO1.PNG|1000px]]
  +
  ⚫
[[File:CMO2.PNG|1000px]]
  +
 
#Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
  
#Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.
  +
  +
[[File:CMO3.PNG|1000px]]
  +
  +
[[File:CMO4.PNG|1000px]]
  +
 
#There will be 2 types of files:
  
#There will be 2 types of files:
  +
−
==== CCRAW – Corporate Clearing File ====
 +
==== (1) CCRAW – Corporate Clearing File ====
   
 
*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
 
*This will be downloaded to clear cheques out of the cashbook. Download this file to BANKEDI2 (N Drive) -> CIBC.
Line 29: Line 40:
 
*For example, for October 29, select the most recent file (for Oct 28) and then change the file name to CL102919 for October 29th.
 
*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.
  
*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]]
  
[[File:nancy13.png|500px]]
⚫
==== EFRPT (CONFIRMATION) – Input File Totals for CIBC EFTs ====
  
   
  ⚫
==== (2) EFRPT (CONFIRMATION) – Input File Totals for CIBC EFTs ====
⚫
*Print and staple these to the previous days EFT batch. Ensure the amounts match. '''Note: We have now transitioned from printing to saving the EFRPT file to respective directory. Rename EFPRT file and attach with the rest of original EFT files.'''
  
  +
  ⚫
*Please ensure confirmations have been saved as backup documents for both '''A/P''' and '''A/R''' EFT transactions
  +
  +
[[File:CMO5.PNG|800px]]
  +
  ⚫
*Print and staple these to the previous days EFT batch. Ensure the amounts match. '''Note: We have now transitioned from printing to saving the EFRPT file. The EFPRT file is renamed and attached with the original EFT files.'''
   
 
[[File:CMO.PNG|500px]]
  
[[File:CMO.PNG|500px]]
   
 
*For A/P, rename EFRPT pdf document to EFT011221 PROP 22409 - 1 confirmation and put the file in the same directory as the original signed document (eg. EFT011221 PROP 22409 - 1 signed.pdf)
  
*For A/P, rename EFRPT pdf document to EFT011221 PROP 22409 - 1 confirmation and put the file in the same directory as the original signed document (eg. EFT011221 PROP 22409 - 1 signed.pdf)
−  
⚫
*Please ensure confirmations have been saved as backup documents for both '''A/P''' and '''A/R''' EFT transactions
  
   
 
*A/P location: Network \ SUPERSERVER \ Accounting \ common \ AP \ Banking \ EFT-Wire Log
  
*A/P location: Network \ SUPERSERVER \ Accounting \ common \ AP \ Banking \ EFT-Wire Log
Line 49: Line 64:
 
*This will be used to clear the Cashbook
  
*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
  
*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
 +
*Select '''Information Reporting''' and click Edit for '''Daily Statement by Value Date'''. 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:inforeport.PNG|800px]]
  +
  +
See http://owl.unipharm.local/mediawiki/index.php/Accounting_Finance:Accounting_Finance:CIBC-Daily_Cashbook_Clearing
   
 
===Import File to ASW===
  
===Import File to ASW===
Line 123: Line 142:
 
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
  
#Identify any exceptions in '''exceptions''' and '''stop payment''' sheets
 
#Click '''save'''
  
#Click '''save'''
  +
  +
[[File:ImportLog.PNG|400px]]
   
 
===Returning Cheque in CIBC===
  
===Returning Cheque in CIBC===
Line 130: Line 151:
   
 
3.Click '''Cheque Inquiry'''
  
3.Click '''Cheque Inquiry'''
  +
  +
[[File:chq4.PNG|400px]]
   
 
4.Click on the correct account '''16512'''
  
4.Click on the correct account '''16512'''
  +
  +
[[File:chq1.PNG|400px]]
   
 
5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''
  
5.Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''
   
−
[[File:nancy27.png|500px]]
 +
[[File:chq2.PNG|400px]]
⚫
[[File:nancy28.png|500px]]
  
   
 
6.Click the '''box''' to highlight all cheque images
  
6.Click the '''box''' to highlight all cheque images
Line 143: Line 167:
   
 
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.
  
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===
  
===Corporate Clearing Online Decision===

Latest revision as of 11:00, 13 January 2021

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) Nancy Ng
  • UWD I.S. Contact - Norwin Uy (local 218) Norwin Uy
  • CIBC, Cash Management Manager - Edward Woo 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

  1. Open your supported web browser
  2. Logo into CIBC
  3. Enter your 16 digit User ID (only an authorized user will be issued a User ID)
  4. Enter your token number (from your CIBC FOB)
  5. Enter your PIN
  6. Click the 'Sign On' button

nancy11.png

Downloading File

  1. Navigate to CMO -> Reporting -> Cash Management Reports

CMO1.PNG

CMO2.PNG

  1. Reports may not display if they were generated prior day (ie on the weekend). Edit search criteria to show reports for past week.

CMO3.PNG

CMO4.PNG

  1. There will be 2 types of files:

(1) 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.

nancy13.png

(2) EFRPT (CONFIRMATION) – Input File Totals for CIBC EFTs

  • Please ensure confirmations have been saved as backup documents for both A/P and A/R EFT transactions

CMO5.PNG

  • Print and staple these to the previous days EFT batch. Ensure the amounts match. Note: We have now transitioned from printing to saving the EFRPT file. The EFPRT file is renamed and attached with the original EFT files.

CMO.PNG

  • For A/P, rename EFRPT pdf document to EFT011221 PROP 22409 - 1 confirmation and put the file in the same directory as the original signed document (eg. EFT011221 PROP 22409 - 1 signed.pdf)
  • A/P location: Network \ SUPERSERVER \ Accounting \ common \ AP \ Banking \ EFT-Wire Log

EFRPT.JPG

  • A/R location: Network \ SUPERSERVER \ Accounting \ common \ AR \ Banking \ CIBC \ EFT \ Fiscal 20XX-EFT Batch Approved \

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 Daily Statement by Value Date. 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

inforeport.PNG

See http://owl.unipharm.local/mediawiki/index.php/Accounting_Finance:Accounting_Finance:CIBC-Daily_Cashbook_Clearing

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

nancy14.png

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.

nancy15.png

Viewing File with Error

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

nancy16.png

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

nancy17.png

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

nancy18.png

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

nancy19.png

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.
  1. For Encoding error, change the amount to match the ASW system amount. Note: encoding errors > $10 may be claimed back from bank
  2. Change header total to match the change and press enter
  3. Press F3

nancy21.png

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

nancy23.png

Posting batch after Error Correction

  1. Enter PO to post file and press enter
  2. Press enter again to post file into ASW

nancy24.png

  • 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

  1. Goto \\superserver.unipharm.local\Accounting\common\AP\Banking\Cheque Clearing
  2. Enter imported date,actual date, file#, lines, amount and importer and any important notes
  3. Identify any exceptions in exceptions and stop payment sheets
  4. Click save

ImportLog.PNG

Returning Cheque in CIBC

1.Go back to the CIBC CMO website

2.Click Cheque Services

3.Click Cheque Inquiry

chq4.PNG

4.Click on the correct account 16512

chq1.PNG

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

chq2.PNG

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.

Corporate Clearing Online Decision

nancy35.png

nancy31.png

nancy33.png

nancy34.png

  • 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)
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:CIBC-Downloading_Cheque_Clearing_File&oldid=13373"