Accounting Finance:CIBC-Downloading Cheque Clearing File - Revision history

Williamw: /* Print Daily Transaction Report */

2021-01-13T18:00:25Z

Print Daily Transaction Report

2021-01-13T17:59:11Z

Print Daily Transaction Report

2021-01-13T17:55:46Z

EFRPT (CONFIRMATION) – Input File Totals for CIBC EFTs

2021-01-13T17:55:38Z

CCRAW – Corporate Clearing File

2021-01-13T17:54:30Z

Downloading File

2021-01-13T17:45:04Z

Returning Cheque in CIBC

2021-01-13T17:43:53Z

Returning Cheque in CIBC

2021-01-13T17:41:10Z

Returning Cheque in CIBC

2021-01-13T17:40:15Z

Returning Cheque in CIBC

2021-01-13T17:39:57Z

Returning Cheque in CIBC

← Older revision		Revision as of 18:00, 13 January 2021
Line 67:		Line 67:

	[[File:inforeport.PNG\|800px]]		[[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 64: / Line 64: @@
 *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
+*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
 ===Import File to ASW===

@@ Line 43: / Line 43: @@
 [[File:nancy13.png|500px]]
-==== EFRPT (CONFIRMATION) – Input File Totals for CIBC EFTs ====
+==== (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

@@ Line 34: / Line 34: @@
 #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.

@@ Line 21: / Line 21: @@
 ===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 ====
@@ 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.
 *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 (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
 *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.'''

@@ Line 134: / Line 134: @@
 [[File:chq4.PNG|400px]]
 .Click on the correct account '''16512'''
-[[File:chq2.PNG|400px]]
+[[File:chq1.PNG|400px]]
 .Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''
 .Click the '''box''' to highlight all cheque images

← Older revision		Revision as of 17:41, 13 January 2021
Line 144:		Line 144:

	7.Click '''Cheque image'''		7.Click '''Cheque image'''
−
−	[[File:chq3.PNG\|400px]]

	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.

← Older revision		Revision as of 17:40, 13 January 2021
Line 148:		Line 148:

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

@@ Line 132: / Line 132: @@
 .Click '''Cheque Inquiry'''
 .Click on the correct account '''16512'''
 .Pick the date that corresponds to your '''clearing cheque report''' and click '''View Result'''
 .Click the '''box''' to highlight all cheque images
 .Click '''Cheque image'''
 .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.