Difference between revisions of "Accounting Finance:AMEX POS Reconciliation"
Jump to navigation
Jump to search
Christined (talk | contribs) m |
Christined (talk | contribs) m |
||
| Line 23: | Line 23: | ||
# Copy the previous worksheet and rename the tab with the month you are working on (example AMEX-SEP2017) |
# Copy the previous worksheet and rename the tab with the month you are working on (example AMEX-SEP2017) |
||
# While on the AMEX website, download the monthly statement by clicking the icon on the upper left side (see screenshot below for details) |
# While on the AMEX website, download the monthly statement by clicking the icon on the upper left side (see screenshot below for details) |
||
| − | # Report will open in Excel. Copy and paste it to your Amex reconciliation details worksheet |
+ | # Report will open in Excel. Copy and paste it to your Amex reconciliation details worksheet in column AA. |
# Using the POS report generated from ASW, fill in the yellow cells on the worksheet |
# Using the POS report generated from ASW, fill in the yellow cells on the worksheet |
||
# Change the date and manipulate all formula's to make your worksheet work. |
# Change the date and manipulate all formula's to make your worksheet work. |
||
Revision as of 15:48, 24 October 2017
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
- Open your supported web browser
- Log on to https://www.americanexpress.com/canada/en/merchant/home/merchant_c.shtml
- User ID is unipharm and password is test123
- Click See All Payments
- Make sure you put the correct date range
AMEX Reconciliation Details Worksheet
- Click on the link to go to the details worksheet AMEX Bank Rec Jun17-Jan18 Details
- Copy the previous worksheet and rename the tab with the month you are working on (example AMEX-SEP2017)
- While on the AMEX website, download the monthly statement by clicking the icon on the upper left side (see screenshot below for details)
- Report will open in Excel. Copy and paste it to your Amex reconciliation details worksheet in column AA.
- Using the POS report generated from ASW, fill in the yellow cells on the worksheet
- Change the date and manipulate all formula's to make your worksheet work.
- Any discrepancies should be included in your monthly reconciliation sheet AMEX Bank Rec Jun17-Jan18
Running ASW POS Report
- At the ASW main screen click System Management
- Click on Query Manager and then Run a query request
- Click FINAR006 Print POS summary report
- Put the correct date range (example 080117 to 083117)
- Customer range will always be 00000 - 99999
- Change printer type to LP05 and once report it printed, keep the summary and take only the stores that show AMEX sales