Accounting Finance:CIBC Operating Line Reconciliation

Overview

All transactions flowing through General Ledge 200100 are to be reconciled against the deposits to our CIBC account on a monthly basis. All variances should be accounted for and reported immediately to ensure that we are not missing any sales for each shareholder. To do the reconciliation you will need the following:

1. CIBC Monthly Statement which Nancy will download in both .PDF and Excel versions in an agreed upon folder.
2. Operating Line worksheet which will also be found in an agreed upon folder.
3. Mastercard & Visa Transfers printout which will be included in a physical folder Nancy will provide.
4. CB-1: General Ledger List which you will download an excel file and print.
5. CB-2, CB-3, CB-4: Cash Book Transaction List which you will print

G/L & Cashbook Printing

To print G/L 200100

1. At the ASW main screen click Financials and then Financial Accounting
2. Click Analysis Tasks and then G/L Analysis Tasks
3. Click Print General Ledger, hit enter
4. Enter the accounting year and period of interest, enter 200100 beside Main and change the printer queue to LP05

To download Excel file of G/L 200100

1. Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
2. Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) from and to
3. Choose Main from Summarize. Choose 200100 - CIBC operation (new)for Main - from and to
4. Click Search. After results are generated, click Detail to excel. This will provide you with the printout for G/L 200100 in excel format, allowing you to search and compare entries and transactions as you see fit. Pivot tables are recommended.

To print CashBook Transaction list - 2

1. Access menu item GF457 - Print Cash Book transactions
2. Under the Sequence page, enter 1 by Document number
3. Enter 1, 001 for Bank. Enter the date of the month end in both Statement number boxes following the format MM/DD/YY (the format is important). Enter 2, 601 and accounting period of interest in the Accounting period boxes. By Reason Code, enter 2 and AP06.
4. Press Enter, and make sure printer output is LP05. Hit Enter again to print.

CIBC Operating Line Reconciliation Worksheet

To print CashBook Transaction list - 3

1. Access menu item GF457 - Print Cash Book transactions
2. Under the Sequence page, enter 1 by Document number
3. Enter 1, 001 for Bank. Enter 2, 601 and accounting period of interest in the Accounting period boxes. By Open, enter Y. By Reason Code, enter 2 and AP06.
4. Press Enter, and make sure printer output is LP05. Hit Enter again to print.

To print CashBook Transaction list - 4

1. Access menu item GF457 - Print Cash Book transactions
2. Under the Sequence page, enter 1 by Document number
3. Enter 1, 001 for Bank. Enter the date of the NEXT month end in both Statement number boxes following the format MM/DD/YY (the format is important). Enter 2, 601 and accounting period of interest in the Accounting period boxes. By Reason Code, enter 2 and AP06.
4. Press Enter, and make sure printer output is LP05. Hit Enter again to print.