Difference between revisions of "Accounting Finance:Accounting Finance:CIBC-Daily Cashbook Clearing"
Jump to navigation
Jump to search
(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...") |
|||
| (14 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The Cashbook is cleared daily to ensure that the amounts entering and leaving the bank account are recorded correctly in the GL. |
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'''. |
*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''' |
*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''' |
*Navigate to ASW --> '''GF460 - Work With Cash Book Reconciliation''' |
||
| + | |||
| + | [[File:GF460-1.PNG|600px]] |
||
| + | |||
*Enter '''001''' under bank for CIBC CAD |
*Enter '''001''' under bank for CIBC CAD |
||
| + | |||
| + | [[File:GF460.PNG|600px]] |
||
| + | |||
*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. |
*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''' |
*Select the file you are clearing and click '''Reconcile''' |
||
| Line 11: | Line 20: | ||
*'''Do not change the Value Date''' |
*'''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* |
*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* |
||
| + | *Once confirmed the transaction has been cleared, press '''F10''' to complete the clearing process. |
||
| ⚫ | |||
| + | |||
| ⚫ | |||
| + | [[File:GF460-2.PNG|600px]] |
||
| + | |||
| ⚫ | |||
| + | |||
| + | [[File:CIBC_Missing.PNG|800px]] |
||
| + | |||
| + | Clear once entered. |
||
| + | |||
| + | *List of Total Debit are related to cheque deposit transitions. Once imported, the transaction will be automatically cleared. Check to ensure the CCRAW file has been imported. |
||
| ⚫ | |||
| + | [[File:CC_Repo.PNG|500px]] |
||
[[Category:Workflows-Finance]] |
[[Category:Workflows-Finance]] |
||
Latest revision as of 11:20, 13 January 2021
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*
- Once confirmed the transaction has been cleared, press F10 to complete the clearing process.
- 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. (File Location: \common\AR\Banking\CIBC\HR CIBC Missing Amounts.xlsx)
Clear once entered.
- List of Total Debit are related to cheque deposit transitions. Once imported, the transaction will be automatically cleared. Check to ensure the CCRAW file has been imported.
- Enter the amounts for the Credit Card Reposition in the Visa & MC Transfers spreadsheet (Common -> AR -> Banking-> CIBC -> Visa & MC Transfers). These transactions relating to repositions will be made at the end of the month as on lump sum transfer.
