Accounting Finance:AMEX POS Reconciliation

Overview

All AMEX store sales figures 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.

Contacts

• Chase Relationship Manager - Oliver Manram T:416.940.6170, F: 416.940.6026 Oliver Manram
• Chase Helpdesk: T: 1-800.265.5158
• Toronto Customer Service: Tor-CanadaCustomerService@chasepaymentech.ca
• American Express Customer Service: 1-800-268-9877

CAP/Bank account numbers

• AMEX Cap Number 9324777847
• Bank account required when calling AMEX Customer Service #00900-38-52814

Logging into AMEX Website

1. Open your supported web browser
2. Log on to https://www.americanexpress.com/canada/en/merchant/home/merchant_c.shtml
3. User ID is unipharm and password is test123
4. Click See All Payments
5. Make sure you put the correct date range

AMEX Reconciliation Details Worksheet

1. While on the AMEX website, download report by clicking the icon on the upper left side (see screenshot below)
2. Report will open in Excel. Copy and paste it to your Amex reconciliation details worksheet which will be moved to your folder.
4. Change the date and manipulate all formula's to make your worksheet work.

Running ASW POS Report

1. At the ASW main screen click System Management
2. Click on Query Manager and then Run a query request
3. Click FINAR006 Print POS summary report
4. Put the correct date range (example 080117 to 083117)
5. Customer range will always be 00000 - 99999
6. Change printer type to LP05 and once report it printed, keep the summary and take only the stores that show AMEX sales