|
|
| Line 1: |
Line 1: |
| |
==Overview== |
|
==Overview== |
| |
uniPHARM uses Chase Paymentech's as our credit card processor. Merchant Statements are released the first week of the following month and all data is accessible from Resource Online. |
|
uniPHARM uses Chase Paymentech's as our credit card processor. Merchant Statements are released the first week of the following month and all data is accessible from Resource Online. |
| |
+ |
|
| |
+ |
==DIMP - Version Control Table== |
| |
+ |
{| class="wikitable" |
| |
+ |
|- |
| |
+ |
! Document !! Version # !! Date of Issue !! Description (Addition/Revision) !! DMS Owner (date/doc ref. etc) |
| |
+ |
|- |
| |
+ |
| '''DIMP''' || '''1.0''' || July 3, 2003 || Initial draft || |
| |
|
|
|
| |
==Contacts== |
|
==Contacts== |
Revision as of 12:06, 26 January 2018
Overview
uniPHARM uses Chase Paymentech's as our credit card processor. Merchant Statements are released the first week of the following month and all data is accessible from Resource Online.
DIMP - Version Control Table
| Document |
Version # |
Date of Issue |
Description (Addition/Revision) |
DMS Owner (date/doc ref. etc)
|
| DIMP |
1.0 |
July 3, 2003 |
Initial draft |
Contacts
Unipharm Wholesale 1613455 - Virtual Terminals
Download Card Type Summary by Merchant Report
- Click Recon Solution/Daily Report Review/Card Type Summary by Merchant
- Click UNIPHARM WHOLESALE DRUGS LTD 10946585
- Click Drill Down
- Click Unipharm Wholesale 1613455 - (company) and click Select
- Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
- Click Generate Report
- Copy to Sales Sheet and update pivot table Chase Merchant Statement
Download Settlement Fees Detail Canada
- Click Recon Solution/Settlement Review/Settlement Fees Details Canada
- Click UNIPHARM WHOLESALE DRUGS LTD 10946585
- Click Drill Down
- Click Unipharm Wholesale 1613455 - (company) and click Select
- Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
- Click Generate Report
- Copy to Fees Sheet and move merchant # and merchant to correct columns
- Copy Group data to Type data and change assessment, interchange and transaction fees to either MC or VI
- Change amount to positive number and update pivot table
Download All Transactions
- Click Recon Solution/Daily Report Review/All Transactions
- Click UNIPHARM WHOLESALE DRUGS LTD 10946585
- Click Drill Down
- Click Unipharm Wholesale 1613455 - (company) and click Select
- Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
- Click Generate Report
- Copy only merchant 6077431 to UWD Sheet
- Pull down columns A & B to remove any previous manual entries
- Pull down columns V to AH to remove any previous manual entries
- Look for any N/A entries and enter missing profile in Profiles (you may need to look at the actual POS download) [1]
- Any highlighted fields in column B require you to manually change when the same card number is used for multiple accounts (you may need to look at the actual POS download). Change the account number and highlight in yellow.
- Make sure the Reconciliation Summary is balanced.
Invoice UWD Sheet Charges
- Goto UWD Sheet and invoice all applicable charges in column AD (column AF will indicate which accounts to invoice)
- Enter the invoice number in column AE.
- Invoice as manual (AR) invoice using item number 02003812 (separate each entry)
Manual CVM Adjustments
No need to create an invoice for store charges because Merchant Statements will provide all the necessary information and the document number will be the merchant statement ending date (i.e. 43017 for April 30, 2017)
- Goto Data sheet and make sure the reconciliation summary is balanced
- Change Dates column E1 to month end date, i.e. September 30, 2017 and column E2 to the month end date i.e. 93017.
- Click Portfolio sheet and clock Print All Statements
- Goto Data sheet and enter manual entry for all applicable charges (see column BU) (Note - the manual entry charge should match printed Merchant Statement)
- Use CVM template and make sure due date is closest 10th or 25th
Unipharm Wholesale 1626312 - Stand Alone and Integrated Terminals
Download Card Type Summary by Merchant Report
- Click Recon Solution/Daily Report Review/Card Type Summary by Merchant
- Click UNIPHARM WHOLESALE DRUGS LTD 10946585
- Click Drill Down
- Click Unipharm Wholesale 1626312 - (company) and click Select
- Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
- Click Generate Report
- Copy to Sales Sheet Chase Merchant Statement
- Change column B to numeric by copying and pasting values only
- Update pivot table
Download Settlement Fees Detail Canada
- Click Recon Solution/Settlement Review/Settlement Fees Details Canada
- Click UNIPHARM WHOLESALE DRUGS LTD 10946585
- Click Drill Down
- Click Unipharm Wholesale 1626312 - (company) and click Select
- Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
- Click Generate Report
- Sort data by Card Type and Fee Desc
- Insert AX,MC,VI,DS OR DI in front of Fee Description and change miscellaneous fees to FEE-SETUP
- Copy data to Fees sheet
Merchant Table
- Make sure Data Total reconciles to the Data total on the Data Sheet. If not, you might be missing some merchants.
- The only acceptable discrepancy is merchants with more than one account (i.e. charge will not be covered by UWD).
Manual CVM Adjustments
No need to create an invoice for store charges because Merchant Statements will provide all the necessary information and the document number will be the merchant statement ending date (i.e. 43017 for April 30, 2017)
- Goto Data sheet and make sure the reconciliation summary is balanced and the same as the pdf 1626312-Statement.
- Change Dates (columns E1 & E2) to month end date.
- Click Portfolio sheet and clock Print All Statements
- Goto Data sheet and enter manual entry for all applicable charges (see column BU) (Note - the manual entry charge should match printed Merchant Statement)
- Use CVM template and make sure due date is closest 10th or 25th
|
