uniWIKI - User contributions [en]

Accounting Finance:Statements-Printing Customer Statement Report

2018-01-22T20:11:41Z

Rickyz: /* EFT Open Item (OI) > zero */

==Printing Customer Statement Report==

:1. Select '''2 Start uniPharm Extensions'''

[[File:CustStmtReport1.PNG|400px]]

:2. Select '''1 VA Company (PRODUCTION)'''

[[File:CustStmtReport2.PNG|400px]]

:3. Select '''1 UWD Extensions'''

[[File:CustStmtReport3.PNG|400px]]

:4. Select '''7 STM -- Statements'''

[[File:CustStmtReport4.PNG|400px]]

:5. Select '''15 Customer Statement Summary Rpt'''

[[File:CustStmtReport5.PNG|400px]]

Only use the first run of the period.

Print 4 summary reports:
===EFT Balance Forward (BA) > zero===

:1. BA EFT with closing balance '''GT''' zero
:2. Enter run number '''SRUNI#''' (change last 4 zeros to run number)
:3. Press '''Enter'''

[[File:CustStmtReport6.png|400px]]

===EFT Open Item (OI) > zero===

:1. OI EFT with closing balance '''GT''' zero
:2. Enter run number '''SRUNI#''' (''USE THE OPEN ITEM NUMBER''. Change last 4 zeros to run number)
:3. Change '''STFMT''' from '''B''' to '''O'''
:4. Press '''Enter'''

[[File:CustStmtReport7.png|400px]]

===EFT Balance Forward (BA) < zero===

:1. BA EFT with closing balance '''LT''' zero
:2. Enter run number '''SRUNI#''' (change last 4 zeros to run number)
:3. Change '''T01.STCLBD''' to '''LT'''
:4. Press '''Enter'''

[[File:CustStmtReport8.png|400px]]

===CC Closing Balance > zero===

:1. BA '''CC''' - credit card only
:2. Enter run number '''SRUNI#''' (change last 4 zeros to run number)
:3. Change '''DRPACD''' line '''CC'''
:4. Press '''Enter'''
:5. Go to work with printer output to retrieve and print the lists

[[File:CustStmtReport9.png|400px]]

[[Category:Workflows-Finance]]
[[Category:Accounts Receivable]]

Accounting Finance:Amenity Healthcare-Weekly Report

2017-12-12T17:43:14Z

Rickyz: /* Email Files to Amenity */

==Overview==
Each '''Monday''' or the '''next business day''' after a statutory holiday, prepare the '''weekly reports''' and email to '''payables@amenityhealthcare.com''' the '''same day'''.

==Contacts==
*Robert Swiscoski T:204-594-5881 [mailto:rswiscoski@amenityhealthcare.com rswiscoski@amenityhealthcare.com]
*Payables [mailto:payables@amenityhealthcare.com payables@amenityhealthcare.com]

==Store Accounts==
*4001-Qualicum (12425)
*4002-Nanoose (12426)
*4003-Memorial (12424)
*Rita's Apothecary & Home Healthcare (11885)

==Receiving File from Information Systems==
#Each '''Monday''' you will download '''three''' files from '''IS''' for the week from '''Sunday to Saturday''' (i.e. September 3-September 9, 2017)
#Log in Infonet. From '''Finance''' --> '''Custom A/R Detail Report'''. This can only be done through the home/front page (not through uniVIEW).
#Enter the Account Number for each of the stores (you would run this procedure 3 times, once per store)
#Enter the correct dates and '''run'''
#Save the '''files''' to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files|\\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files}}
#Save a '''second copy''' with the same name and adding '''Amenity''' at the end, as this becomes the working file for making the file '''adjustments''' (i.e. 4001-Qualicum (Sep 03-Sep 09, 2017)-Amenity.xlxs)

==File Adjustments Prior to sending File==
#Change customer number to numeric '''(highlight the column (A)→then Data→Test to Column→Delimited→Finish)'''
#Delete any documents with the document type '''EFT'''
#Check for duplicate invoice numbers on account types '''CVM''' and '''ELC''' (ELC should be the '''last day''' of the month and CVM should be the '''first day''' of the following month)
#Look for '''blanks''' or missing invoices and enter '''text details''' for all blanks.

==Email Files to Amenity==
#Email reports (including Rita's Apothecary) to [mailto:payables@amenityhealthcare.com payables@amenityhealthcare.com]

[[Category:Amenity]]

Accounting Finance:BC Online

2017-12-05T23:28:14Z

Rickyz: /* PPSA Worksheet */

==Contact Number==
*Online Support '''1-800-663-6102 or bcolhelp@accessbc.com'''

==BC Online - Sign On==
*Log onto '''www.bconline.gov.bc.ca'''
*Enter user ID '''PA75930'''
*Enter password '''UWD2006'''
*Click '''I Agree'''
*Click '''Sign On'''
[[File:BCO1.png|200px]]

==Personal Property Registry==
*Click '''Personal Property Reg'''
*Click '''Submit'''
*Click '''Registration'''
*Click '''Submit'''
*Click '''Draft a Financing Statement'''

==Drafting a Financing Statement==
*Enter Reference # (UWD account #)
*Enter SP (securing party) '''1'''
*Enter DE (debtor-enter both legal and operating names) '''2'''
*Enter VE (vehicle) '''0'''
*Enter GC (general collateral - # of lines) '''1'''
*Enter Reg Length '''5'''
*Enter Secured Party '''40270009''' (UWD code)
*Check entries and when all entries are correct, click '''Submit'''
[[File:BCO2.png|400px]]

*Enter 1st debtor
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code

*Enter 2nd debtor (if applicable)
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code
*Check entries and when all entries are correct click '''Submit'''
[[File:BCO3.png|400px]]

*Enter General Collateral
ALL OF THE DEBTOR’S PRESENT AND AFTER ACQUIRED PERSONAL PROPERTY.
*Check entry and when correct click '''Submit'''
[[File:BCO4.png|400px]]

*Click '''Verify/Register''' when no other changes are required
*Click Bypass Verification '''Yes'''
*Click '''Submit'''
[[File:BCO5.png|400px]]
*Click '''BC Online Mailbox''' to retrieve document information

==Print Selection List & PPSA Security Agreement==
*Click applicable document
*Go to '''General Collateral''' step '''OR'''
*Click '''Active Session'''
[[File:BCO6.png|400px]]
*Click '''Return'''

==Verify/Register a Financing Agreement==
*Click '''Draft a Financing Statement'''
#Enter Reference # (UWD account #)
#Enter SP (securing party) <1>
#Enter DE (enter individual) <1>
#Enter VE (vehicle) <0>
#Enter GC (general collateral - # of lines) <6>
#Enter Reg Length <5>
#Enter Secured Party <40270009> (UWD code)
#Check entries and when all entries are correct, click <Submit>

*Enter 1st debtor
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code

*Enter 2nd debtor (if applicable)
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code
*Check entries and when all entries are correct click '''Submit'''

*Enter General Collateral
*ALL INDEBTEDNESS, PRESENT AND FUTURE AND INDIRECT, ABSOLUTE
AND CONTINGENT OF '''OKANAGAN PHARMACY LTD. DBA OKANAGAN PHARMACY'''
REMEDY'S RX TO THE DEBTOR AND ALL PROCEEDS INCLUDING, WITHOUT
LIMITATION, ALL GOODS, SECURITIES, INSTRUMENTS, DOCUMENTS OF TITLE,
CHATTEL PAPER, INTANGIBLES AND MONEY (ALL AS DEFINED IN THE
*Check entry and click '''Submit''' when correct

*Continue to enter final line of General Collateral
*Check entry and click '''Submit''' when correct
[[File:BCO7.png|400px]]

*Click '''Verify/Register''' when no other changes are required
*Click Bypass Verification '''Yes'''
*Click '''Submit'''
*Click '''BC Online Mailbox''' to retrieve confirmation document
*Click applicable document
[[File:BCO8.png|400px]]
*Click '''Printer Icon'''
*Click '''Sign off'''
[[File:BCO9.png|400px]]

==PPSA Worksheet==
*Go to /accounting superserver/common/AR/PPSA
*Enter date, expiry date, registration #, name, type, terms
*SCAN documents into Gauss under Customer Application.
[[File:BCO10.png|400px]]

[[Category:Workflows-Finance]]
[[Category:Bank]]

Accounting Finance:BC Online

2017-12-05T23:28:02Z

Rickyz: /* PPSA Worksheet */

==Contact Number==
*Online Support '''1-800-663-6102 or bcolhelp@accessbc.com'''

==BC Online - Sign On==
*Log onto '''www.bconline.gov.bc.ca'''
*Enter user ID '''PA75930'''
*Enter password '''UWD2006'''
*Click '''I Agree'''
*Click '''Sign On'''
[[File:BCO1.png|200px]]

==Personal Property Registry==
*Click '''Personal Property Reg'''
*Click '''Submit'''
*Click '''Registration'''
*Click '''Submit'''
*Click '''Draft a Financing Statement'''

==Drafting a Financing Statement==
*Enter Reference # (UWD account #)
*Enter SP (securing party) '''1'''
*Enter DE (debtor-enter both legal and operating names) '''2'''
*Enter VE (vehicle) '''0'''
*Enter GC (general collateral - # of lines) '''1'''
*Enter Reg Length '''5'''
*Enter Secured Party '''40270009''' (UWD code)
*Check entries and when all entries are correct, click '''Submit'''
[[File:BCO2.png|400px]]

*Enter 1st debtor
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code

*Enter 2nd debtor (if applicable)
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code
*Check entries and when all entries are correct click '''Submit'''
[[File:BCO3.png|400px]]

*Enter General Collateral
ALL OF THE DEBTOR’S PRESENT AND AFTER ACQUIRED PERSONAL PROPERTY.
*Check entry and when correct click '''Submit'''
[[File:BCO4.png|400px]]

*Click '''Verify/Register''' when no other changes are required
*Click Bypass Verification '''Yes'''
*Click '''Submit'''
[[File:BCO5.png|400px]]
*Click '''BC Online Mailbox''' to retrieve document information

==Print Selection List & PPSA Security Agreement==
*Click applicable document
*Go to '''General Collateral''' step '''OR'''
*Click '''Active Session'''
[[File:BCO6.png|400px]]
*Click '''Return'''

==Verify/Register a Financing Agreement==
*Click '''Draft a Financing Statement'''
#Enter Reference # (UWD account #)
#Enter SP (securing party) <1>
#Enter DE (enter individual) <1>
#Enter VE (vehicle) <0>
#Enter GC (general collateral - # of lines) <6>
#Enter Reg Length <5>
#Enter Secured Party <40270009> (UWD code)
#Check entries and when all entries are correct, click <Submit>

*Enter 1st debtor
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code

*Enter 2nd debtor (if applicable)
#Enter Business Name
#Enter Address
#Enter City
#Enter Province
#Enter Postal Code
*Check entries and when all entries are correct click '''Submit'''

*Enter General Collateral
*ALL INDEBTEDNESS, PRESENT AND FUTURE AND INDIRECT, ABSOLUTE
AND CONTINGENT OF '''OKANAGAN PHARMACY LTD. DBA OKANAGAN PHARMACY'''
REMEDY'S RX TO THE DEBTOR AND ALL PROCEEDS INCLUDING, WITHOUT
LIMITATION, ALL GOODS, SECURITIES, INSTRUMENTS, DOCUMENTS OF TITLE,
CHATTEL PAPER, INTANGIBLES AND MONEY (ALL AS DEFINED IN THE
*Check entry and click '''Submit''' when correct

*Continue to enter final line of General Collateral
*Check entry and click '''Submit''' when correct
[[File:BCO7.png|400px]]

*Click '''Verify/Register''' when no other changes are required
*Click Bypass Verification '''Yes'''
*Click '''Submit'''
*Click '''BC Online Mailbox''' to retrieve confirmation document
*Click applicable document
[[File:BCO8.png|400px]]
*Click '''Printer Icon'''
*Click '''Sign off'''
[[File:BCO9.png|400px]]

==PPSA Worksheet==
*Go to /accounting superserver’/common/AR/PPSA
*Enter date, expiry date, registration #, name, type, terms
*SCAN documents into Gauss under Customer Application.
[[File:BCO10.png|400px]]

[[Category:Workflows-Finance]]
[[Category:Bank]]

Accounting Finance:Electronic Fund Transfer-Manual Customer EFT

2017-12-05T17:37:51Z

Rickyz: /* Post Manual EFT */

==Overview==
All EFT customers are balance forward statements which mean they will have statements which only show current transactions and past transactions are in the opening balance. The system will automatically settle the EFT during the Auto Cash process to the oldest invoice/credit note and will post any applicable discounts. Upon request, you might have to run a manual EFT which is not part of the usual 10th and 25th EFT batches. This is required as an 'one off' request in which a customer has requested an EFT to be run earlier/later than the usual 10th and 25th or if the original EFT did not go thru and therefore a manual EFT is required.

==Updating EFT Worksheet==
In order to upload an EFT file to the bank, the file number must be in sequence and there should be no duplicate numbers. Therefore, you should first update the worksheet to obtain the next '''Run ID''' number.

#Go to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\CIBC\EFT|CIBC-0100033237-0100023576- Upload Batch Control Log File}}
#Click either '''EFT-Credits''' or '''EFT-Debits''' sheet
#For credits there will only be '''one''' Run ID but for debits, there will be '''two''' Run IDs (first Run ID is blank)
#Enter the next '''Run ID'''
#Enter '''Date'''
#Enter '''Detail''' (i.e. Store and account number)
#Enter the '''EFT amount''' under Stmt Balance
#Enter any '''discounts''' under discount
#Enter '''Handler'''

[[File:Nancy41.PNG|400px]]

==Set-up Manual EFT==
#Goto UWD Extensions→1 UWD Extenstions→7 STM -- Statements→11 View Statement Control Periods
#Enter Type '''EF'''
#Enter Statement Period (next number from your worksheet)
#Press '''Enter'''
#Press '''F6'''
#Enter Statement Type '''EF'''
#Enter Period ID (next number from your worksheet)
#Enter Start and End Dates
#Enter Run Type '''M'''
#Enter Timing '''NA'''
#Enter Status '''FI'''
#Press '''Enter'''
#Press '''F12''' twice

[[File:Nancy42.PNG|400px]]

==Create Manual EFT==
#Enter '''11''' (View Statement Control Periods)
#Press '''Enter'''
#Enter Statement Type '''EF'''
#Enter '''Period ID'''
#Press '''Enter'''
#Enter '''EE''' next to batch
#Press '''Enter'''
#Press '''F6'''
#Enter '''Customer'''
#Enter A/R Payment Mode '''EFT'''
#Enter System EFT Amount
#Press '''Enter'''
#Press '''F12''' twice
#Enter '''EP''' next to batch
#Go to Work with Printer Output, highlight printout, click '''Change''', page-down, enter '''lp05''', tab, delete library. and press '''Enter''' twice.

[[File:Nancy43.PNG|400px]]

==Post Manual EFT==
===EFT Credit===
#Enter '''EC''' next to batch (to export EFT Credit - if not an EFT credit, nothing will process)
#Press '''Enter'''
#Enter document date (today's date if the credit has to go through immediately <- generally the case. Does not have to be the same as the start date)
#Press '''Enter'''
#Enter Voucher type '''27'''
#Enter Document type '''EFT'''
#Enter Identity '''PY'''
#Change printer queue '''lp05'''
#Press '''Enter''' (if not an EFT credit, the message '''Identity PY does not exist in payment file''')
#Press '''F12'''
#Enter '''E1''' next to batch
#Enter '''date'''
#Press '''Enter'''

===EFT Debit===
*You do not have to continue if you are only processing an EFT credit.
#For EFT debit, enter '''ED''' next to batch
#Press '''Enter'''
#Enter document date
#Press '''Enter'''
#Enter Voucher type '''27'''
#Enter Document type '''EFT'''
#Enter Identity '''PY'''
#Change printer queue '''lp05'''
#Press '''Enter''' (if not an EFT credit, the message '''Identity PY does not exist in payment file''')
#Press '''F12'''
#Enter '''E2''' next to batch
#Enter '''date'''
#Press '''Enter'''

[[File:Nancy44.PNG|400px]]

==Forward Document to be uploaded to Bank==
#Place an '''EFT Authorization sticker''' on top of all the documents.
#Date and sign the submitted portion of the sticker.
#Forward to Manager, Finance
#The Manager, Finance will uploaded the EFT batch to CIBC and obtain a second authorization signature.
#The Manager, Finance will print confirmation EFT sheet and staple to batch and file in storage box.

[[Category:Workflows-Finance]]
[[Category:Accounts Receivable]]

Accounting Finance:Electronic Fund Transfer-Manual Customer EFT

2017-12-05T17:37:13Z

Rickyz: /* EFT Credit */

==Overview==
All EFT customers are balance forward statements which mean they will have statements which only show current transactions and past transactions are in the opening balance. The system will automatically settle the EFT during the Auto Cash process to the oldest invoice/credit note and will post any applicable discounts. Upon request, you might have to run a manual EFT which is not part of the usual 10th and 25th EFT batches. This is required as an 'one off' request in which a customer has requested an EFT to be run earlier/later than the usual 10th and 25th or if the original EFT did not go thru and therefore a manual EFT is required.

==Updating EFT Worksheet==
In order to upload an EFT file to the bank, the file number must be in sequence and there should be no duplicate numbers. Therefore, you should first update the worksheet to obtain the next '''Run ID''' number.

#Go to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\CIBC\EFT|CIBC-0100033237-0100023576- Upload Batch Control Log File}}
#Click either '''EFT-Credits''' or '''EFT-Debits''' sheet
#For credits there will only be '''one''' Run ID but for debits, there will be '''two''' Run IDs (first Run ID is blank)
#Enter the next '''Run ID'''
#Enter '''Date'''
#Enter '''Detail''' (i.e. Store and account number)
#Enter the '''EFT amount''' under Stmt Balance
#Enter any '''discounts''' under discount
#Enter '''Handler'''

[[File:Nancy41.PNG|400px]]

==Set-up Manual EFT==
#Goto UWD Extensions→1 UWD Extenstions→7 STM -- Statements→11 View Statement Control Periods
#Enter Type '''EF'''
#Enter Statement Period (next number from your worksheet)
#Press '''Enter'''
#Press '''F6'''
#Enter Statement Type '''EF'''
#Enter Period ID (next number from your worksheet)
#Enter Start and End Dates
#Enter Run Type '''M'''
#Enter Timing '''NA'''
#Enter Status '''FI'''
#Press '''Enter'''
#Press '''F12''' twice

[[File:Nancy42.PNG|400px]]

==Create Manual EFT==
#Enter '''11''' (View Statement Control Periods)
#Press '''Enter'''
#Enter Statement Type '''EF'''
#Enter '''Period ID'''
#Press '''Enter'''
#Enter '''EE''' next to batch
#Press '''Enter'''
#Press '''F6'''
#Enter '''Customer'''
#Enter A/R Payment Mode '''EFT'''
#Enter System EFT Amount
#Press '''Enter'''
#Press '''F12''' twice
#Enter '''EP''' next to batch
#Go to Work with Printer Output, highlight printout, click '''Change''', page-down, enter '''lp05''', tab, delete library. and press '''Enter''' twice.

[[File:Nancy43.PNG|400px]]

==Post Manual EFT==
===EFT Credit===
#Enter '''EC''' next to batch (to export EFT Credit - if not an EFT credit, nothing will process)
#Press '''Enter'''
#Enter document date (today's date if the credit has to go through immediately <- generally the case)
#Press '''Enter'''
#Enter Voucher type '''27'''
#Enter Document type '''EFT'''
#Enter Identity '''PY'''
#Change printer queue '''lp05'''
#Press '''Enter''' (if not an EFT credit, the message '''Identity PY does not exist in payment file''')
#Press '''F12'''
#Enter '''E1''' next to batch
#Enter '''date'''
#Press '''Enter'''

===EFT Debit===
*You do not have to continue if you are only processing an EFT credit.
#For EFT debit, enter '''ED''' next to batch
#Press '''Enter'''
#Enter document date
#Press '''Enter'''
#Enter Voucher type '''27'''
#Enter Document type '''EFT'''
#Enter Identity '''PY'''
#Change printer queue '''lp05'''
#Press '''Enter''' (if not an EFT credit, the message '''Identity PY does not exist in payment file''')
#Press '''F12'''
#Enter '''E2''' next to batch
#Enter '''date'''
#Press '''Enter'''

[[File:Nancy44.PNG|400px]]
==Forward Document to be uploaded to Bank==
#Place an '''EFT Authorization sticker''' on top of all the documents.
#Date and sign the submitted portion of the sticker.
#Forward to Manager, Finance
#The Manager, Finance will uploaded the EFT batch to CIBC and obtain a second authorization signature.
#The Manager, Finance will print confirmation EFT sheet and staple to batch and file in storage box.

[[Category:Workflows-Finance]]
[[Category:Accounts Receivable]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T23:44:06Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

__FORCETOC__

==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 timely adjustments. To do the reconciliation you will need the following:

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

==G/L Printing & Download==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

==Cashbook Printing==

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, '''VOIDS''' tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month. Review G/L in the next month and look up the transactions on ASW.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T23:41:50Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

__FORCETOC__

==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 timely adjustments. To do the reconciliation you will need the following:

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

==G/L Printing & Download==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

==Cashbook Printing==

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, '''VOIDS''' tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T23:40:02Z

Rickyz: /* Overview */

__FORCETOC__

==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 timely adjustments. To do the reconciliation you will need the following:

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

==G/L Printing & Download==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

==Cashbook Printing==

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T23:39:54Z

Rickyz: /* Overview */

__FORCETOC__

==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 timely adjustments. To do the reconciliation you will need the following:

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

==G/L Printing & Download==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

==Cashbook Printing==

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T23:39:30Z

Rickyz:

__FORCETOC__

==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 timely adjustments. To do the reconciliation you will need the following:

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

==G/L Printing & Download==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

==Cashbook Printing==

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:36:17Z

Rickyz:

__FORCETOC__

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

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

==G/L Printing & Download==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

==Cashbook Printing==

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:35:38Z

Rickyz:

__FORCETOC__

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:31:27Z

Rickyz:

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:30:59Z

Rickyz:

{| class="wikitable"
|-
! [[==Overview==]]
|-
| [[==G/L & Cashbook Printing==]]
|-
| [[==CIBC Operating Line Reconciliation Worksheet==]]
|-
| Example
|}
==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:

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:30:33Z

Rickyz:

{| class="wikitable"
|-
! [[Overview]]
|-
| [[G/L & Cashbook Printing]]
|-
| [[CIBC Operating Line Reconciliation Worksheet]]
|-
| Example
|}
==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:

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:30:20Z

Rickyz:

{| class="wikitable"
|
! [[Overview]]
|
| [[G/L & Cashbook Printing]]
|
| [[CIBC Operating Line Reconciliation Worksheet]]
|
| Example
|}
==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:

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:28:47Z

Rickyz:

{| class="wikitable"
|-
! Header text
|-
| Example
|-
| Example
|-
| Example
|}
==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:

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:26:23Z

Rickyz:

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:26:08Z

Rickyz:

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:21:27Z

Rickyz:

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:20:54Z

Rickyz:

# Numbered list item

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:19:35Z

Rickyz:

[[#Overview]]

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.
*Vendor Transfer entries and Cheque E-Deposits could show up as a lump sum on one document and as separate items on another. This is especially true for TD Canada Trust, MSP, Equitable Life, BC Hydro, and Great West Life.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:18:52Z

Rickyz:

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:18:21Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:14:48Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.
#Make sure to hand over to Nancy with all printouts for review after completion.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:13:46Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.

'''Tips:'''
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:13:35Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.

Tips:
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.
*Often times, discrepancies could be due to '''timing differences'''. Keep an eye out for entries at month end and at the beginning of the month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:12:16Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa. The differences should resolve to 0 (rounding might be needed) between the Bank Statement and the G/L as well as their Debit and Credit balances.

Tips:
*In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
*Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.
*Provide as much information as possible in the adjustments/discrepancies for Nancy. Look at prior reconciliations for guidance.
*The AMEX, MasterCard & Visa worksheet is a good source of possible discrepancies. Make sure to compare the amounts.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:09:38Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa.
In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode

Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:09:25Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa.
In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode

Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:09:15Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa.
In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:08:55Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa.
**In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
**Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:08:20Z

Rickyz: /* CIBC Operating Line Reconciliation Worksheet */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas). Change all dates to reflect the month being reconciled.
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa.
##In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
##Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:07:55Z

Rickyz:

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print

[[File:cashbook4.jpg|500px]]

==CIBC Operating Line Reconciliation Worksheet==
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas).
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa.
##In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
##Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:07:13Z

Rickyz: /* G/L & Cashbook Printing */

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

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

==G/L & Cashbook Printing==

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

[[File:GL printing.jpg|500px]]

'''To download Excel file of G/L 200100'''
# Log on Infonet --> uniVIEW --> Finance --> Summarize/Extract G/L Transactions
# Enter 2018XX for Accounting Period (use the relevant period i.e 201809 for October's reconciliation) ''from'' and ''to''
# Choose '''Main''' from ''Summarize''. Choose 200100 - CIBC operation (new)for ''Main - from'' and ''to''
# 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 to organize the entries by voucher type are recommended.

[[File:GL download.jpg|500px]]

'''To print CashBook Transaction list - 2 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook2.jpg|500px]]

'''To print CashBook Transaction list - 3 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

[[File:cashbook3.jpg|500px]]

'''To print CashBook Transaction list - 4 '''
# Access menu item '''GF457 - Print Cash Book transactions'''
# Under the Sequence page, enter '''1''' by '''Document number'''
# 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'''.
# Press Enter, and make sure printer output is '''LP05'''. Hit Enter again to print.

===CIBC Operating Line Reconciliation Worksheet===
#Use a copy of the prior month as a template. Remove all entries and adjustments on the copy (do not delete formulas).
#Following the instructions on the right, enter relevant information for CB-1, CB-2, CB-3, CB-4
#Note down discrepancies between the CIBC Bank Statement and G/L 200100 in the relevant sections. Note that Credit entries on the Statement are Debit entries on the G/L and vice versa.
##In general, VOIDS tend to generate many discrepancies as they would not show up on the Bank statement. We would note down the discrepancies in the Credit or Debit sections but generally would not require actual adjustments to be mode
##Look at adjustments from prior months and note whether they appear on this month's G/L. If they don't appear, the adjustments would flow through to the current month.

[[File:cashbook4.jpg|500px]]

[[Category:Workflows-Finance]]
[[Category:Bank]]
[[Category:CIBC]]

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T20:00:28Z

Rickyz: /* G/L & Cashbook Printing */

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:59:46Z

Rickyz: /* G/L & Cashbook Printing */

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:59:19Z

Rickyz: /* G/L & Cashbook Printing */

File:GL download.jpg

2017-11-27T19:58:59Z

Rickyz:

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:58:42Z

Rickyz:

File:cashbook4.jpg

2017-11-27T19:29:01Z

Rickyz:

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:28:47Z

Rickyz: /* G/L & Cashbook Printing */

File:cashbook3.jpg

2017-11-27T19:25:51Z

Rickyz:

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:25:40Z

Rickyz: /* G/L & Cashbook Printing */

File:cashbook2.jpg

2017-11-27T19:13:39Z

Rickyz:

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:13:26Z

Rickyz: /* G/L & Cashbook Printing */

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:11:01Z

Rickyz: /* G/L & Cashbook Printing */

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:10:32Z

Rickyz: /* G/L & Cashbook Printing */

Accounting Finance:CIBC Operating Line Reconciliation

2017-11-27T19:05:38Z

Rickyz: /* G/L & Cashbook Printing */