Accounting Finance:Chase Paymentech-Merchant Statements - Revision history

Williamw: /* Download All Transactions */

2021-02-01T22:56:23Z

Download All Transactions

Williamw: /* Download Settlement Fees Detail Canada */

2021-02-01T22:47:11Z

Download Settlement Fees Detail Canada

Norwinu at 06:32, 19 December 2020

2020-12-19T06:32:10Z

Harmanr: /* Merchant Table */

2018-04-25T20:01:38Z

Merchant Table

Nancyn at 19:07, 26 January 2018

2018-01-26T19:07:02Z

Nancyn at 19:06, 26 January 2018

2018-01-26T19:06:25Z

Nancyn at 19:05, 26 January 2018

2018-01-26T19:05:31Z

Nancyn at 19:05, 26 January 2018

2018-01-26T19:05:14Z

Nancyn at 19:04, 26 January 2018

2018-01-26T19:04:46Z

Nancyn at 18:10, 13 October 2017

2017-10-13T18:10:07Z

@@ Line 37: / Line 37: @@
 #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'''

@@ Line 28: / Line 28: @@
 #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 from '''Mastercard''' to '''MC''', '''Visa''' to '''VI''', '''American Express''' to '''AX''', and '''Not Card Specific''' to blank
-#Create a column called '''Type" in Downloaded File to re-arrange and then join the column '''Card Type''' and '''Group''' Column Together (hint: use concatenate function, and make sure to delete the extra '''MC''' when '''MC MC''' appear )
+#Create a column called '''Type''' in Downloaded File to re-arrange and then join the column '''Card Type''' and '''Group''' Column Together (hint: use concatenate function, and make sure to delete the extra '''MC''' when '''MC MC''' appear )
 #Change '''amount''' to positive number (Remember to #Copy and paste as values to remove any formulas)
 #Once columns and data are arranged in the downloaded file, delete the data in the template. Copy and paste values from downloaded file to template. Update '''pivot table''' by right-clicking above pivot table using '''refresh''' function.

@@ Line 17: / Line 17: @@
 #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''' {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\Chase Paymentech\Merchant Statements|Chase Merchant Statement}}
+#Copy data from downloaded file to '''Sales Sheet''' (make sure to not delete any accounts, template on '''data sheet''' will pick up the data from '''Sales Sheet''') and update '''pivot table''' by hovering mouse above pivot table. Right click on mouse and then refresh. {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\Chase Paymentech\Merchant Statements|Chase Merchant Statement}}
 ===Download Settlement Fees Detail Canada===
@@ Line 27: / Line 27: @@
 #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'''
+#Copy '''Group data''' to '''Type data''' and change assessment, interchange and transaction fees from '''Mastercard''' to '''MC''', '''Visa''' to '''VI''', '''American Express''' to '''AX''', and '''Not Card Specific''' to blank
-#Change '''amount''' to positive number and update '''pivot table'''
+#Change '''amount''' to positive number (Remember to #Copy and paste as values to remove any formulas)
 ===Download All Transactions===
@@ Line 40: / Line 42: @@
 #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) {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\Chase Paymentech\Batch Processing}Batch Processing}}
+#Look for any '''N/A entries''' and enter '''missing profile''' in Profiles (you may need to look at the actual POS download, update new cc if applicable) {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\Chase Paymentech\Batch Processing}Batch Processing}}
 #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.
@@ Line 84: / Line 88: @@
 #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'''
+#Insert '''AX, MC, VI, DS OR DI''' in front of Fee Descriptionand change miscellaneous fees to '''FEE-SETUP''' (Note: DS = Discover, and DI = Debit Interac)
-#Copy data to '''Fees sheet'''
+#Copy data from downloaded file 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.
 #Check totals of data and ensure they match the totals on the pivot tables. If not then check to see all items are included in the table, or that the table is for the correct range of data.
 #The only acceptable discrepancy is merchants with more than one account (i.e. charge will not be covered by UWD).
 ===Manual CVM Adjustments===

@@ Line 89: / Line 89: @@
 ===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).

@@ Line 1: / Line 1: @@
 ==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.
 ==Contacts==

@@ Line 3: / Line 3: @@
 ==Contacts==
 *Relationship Manager - Oliver Manram T:416.940.6170, F: 416.940.6026 [mailto:oliver.manram@chasePaymentech.ca Oliver Manram]
 *Sales Contact – Harry Cho, VP National Sales T:604.872.0303, TF: 877.872.0303, F: 844.364.9210 [mailto:harry.cho@chasepaymentech.com Harry Cho]

@@ Line 7: / Line 7: @@
 !Document!!Version#!!
 | '''DIMP'''|| '''1.1'''||
 *Relationship Manager - Oliver Manram T:416.940.6170, F: 416.940.6026 [mailto:oliver.manram@chasePaymentech.ca Oliver Manram]
 *Sales Contact – Harry Cho, VP National Sales T:604.872.0303, TF: 877.872.0303, F: 844.364.9210 [mailto:harry.cho@chasepaymentech.com Harry Cho]

@@ Line 56: / Line 56: @@
 #Goto '''Data sheet''' and make sure the reconciliation summary is balanced
-#Change '''Dates''' column E1 to month end date, i.e. '''93017''' and column E2 to first day after month end i.e. '''100117'''.
+#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)