Accounting Finance:Chase Paymentech Bank Reconciliation

Overview

All credit card store sales figures with the exception of AMEX which is done separately are to be reconciled against the deposits to our CIBC account on a monthly basis. All variances should be accounted for and reported immediately to ensure that we are not missing any sales for each shareholder. To do the reconciliation you will need the following:

1. CIBC Monthly Statement which Nancy will download in both .pdf and excel versions in CIBC Statements Excel and .pdf
2. Access to Chase Resource Online
3. GL 100400 and GL100100 Summary Report
4. Monthly Discount Charges worksheet for Chase \\SUPERSERVER\Accounting\common\AR\Banking\Chase Paymentech\Merchant Statements\2017-2018 and TD \\SUPERSERVER\Accounting\common\AR\Banking\TD Merchant Services\Merchant Statements\2017-2018

Contacts

• Chase Relationship Manager - Anmol Sandhu T:647.501.5241, F: 416.940.6026 Anmol Sandhu
• Chase Helpdesk: T: 1-800.265.5158
• CIBC Helpdesk T: 1-888-947-7736

Account and Client numbers

• CIBC Client number: 1225510BC
• CIBC Account: 00900-80-18618

GL Summary Report Printing

1. At the ASW main screen click Financials and then Financial Accounting
2. Click Analysis Tasks and then G/L Analysis Tasks
3. Click Print General Ledger, hit enter
4. Put the correct period and GL number you wish to print and change the printer queue to LP05

Reconciliation Tips

• Check that the sales transfers are matching the repositions on the bank statement \\SUPERSERVER\Accounting\common\AR\Banking\CIBC\Visa Mastercard Transfers
• Put the correct Bank and GL balances and then account for the discount charges in your reconciliation worksheet
• Include all chargebacks as well as the discount charges difference of Discover cards for Sunnyside account #11044
• All unsettled figures from the previous statement should stay in the worksheet until it is accounted for