Accounting Finance:Accounting Finance: CIBC USD and Payroll Reconciliation
Overview
All transactions that clear the bank on a monthly basis for the USD (02-52913) and Payroll (80-18316) accounts need to be reconciled every month. Any variances need to be recorded and presented on the monthly bank reconciliation.
Required Documents
• Download the bank statements from the CIBC CMO website for the USD (02-52913) and Payroll (80-18316) accounts for the previous month o In the CMO Website go to ‘’’Information Reporting’’’ and under ‘’’Reports’’’, ‘’’Filter’’’ to ‘’’Prior Day’’’. o Select ‘’’Transaction and Balance Statement’’’, and filter to the previous month’s dates. o Select the appropriate account • Open the Bank Reconciliation worksheets (LINK) • In ASW open up the cash book o For USD the bank account will be 002 o For Payroll the bank account will be 005
Reconciliation
- Bulleted list item
Open up ASW ‘Work With Cashbook Reconciliation’’’ Balance is on the upper right corner Reconcile the amounts that have cleared to find the balance DATE: Month end Reconciliation date: Date the entry cleared the bank Include any items left over that have not cleared under the balance as per bank statement section