Difference between revisions of "Accounting Finance:Chase Paymentech-Merchant Statements"

From uniWIKI
Jump to navigation Jump to search
(Created page with "==Overview== uniPHARM uses Chase Paymentech's as our credit card processor. Daily credit card deposits processed by the stores using one of uniPHARM POS terminals must be impo...")
 
 
(18 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
==Overview==
 +
==Overview==
−
uniPHARM uses Chase Paymentech's as our credit card processor. Daily credit card deposits processed by the stores using one of uniPHARM POS terminals must be imported to uniPHARM in order for the stores to receive credit on their accounts.
 +
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==
  
==Contacts==
  +
*Relationship Manager - Oliver Manram T:416.940.6170, F: 416.940.6026 [mailto:oliver.manram@chasePaymentech.ca Oliver Manram]
−
*Relationship Manager - TBA
  
 
*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]
  
*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]
 
*Chase Helpdesk: T: 1-800.265.5158
  
*Chase Helpdesk: T: 1-800.265.5158
 
*Toronto Customer Service: [mailto:Tor-CanadaCustomerService@chasepaymentech.ca Tor-CanadaCustomerService@chasepaymentech.ca ]
  
*Toronto Customer Service: [mailto:Tor-CanadaCustomerService@chasepaymentech.ca Tor-CanadaCustomerService@chasepaymentech.ca ]
   
  +
==Unipharm Wholesale 1613455 - Virtual Terminals==
−
==Logging into Chase Orbital==
  
−
#Open your supported web browser
  
−
#Logo into '''[http://rol.paymentech.com/| http://rol.paymentech.com/]'''
  
−
#Enter '''User Name'''
  
−
#Enter '''Password''' and click ''''Secure Login''''
  
   
  +
===Download Card Type Summary by Merchant Report===
−
==Import Daily Transaction Details File==
  
  +
#Click '''Recon Solution/Daily Report Review/Card Type Summary by Merchant'''
−
#Move to '''File Download'''
  
−
#Click on '''File Download'''
+
#Click '''UNIPHARM WHOLESALE DRUGS LTD 10946585'''
  +
#Click '''Drill Down'''
−
#Click '''Transaction Details''' (be careful to select the correct date)
  
  +
#Click '''Unipharm Wholesale 1613455 - (company) and click '''Select'''
−
#Click '''Open'''
 
  +
#Click '''Process Dates from and to''' (i.e. 5/1/2017 to 5/31/2017)
−
#Move the file to the '''bankedi2\Chase directory'''
  
  +
#Click '''Generate Report'''
−
#Click ''''Logout'''' to logout of Chase Paymentech
  
  +
#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===
−
==Import Data to ASW==
  
  +
#Click '''Recon Solution/Settlement Review/Settlement Fees Details Canada'''
−
#Enter ''''1'''' on the uniPHARM Extension screen (Master Menu) and press ''''enter''''
  
  +
#Click '''UNIPHARM WHOLESALE DRUGS LTD 10946585'''
−
#Enter ''''1'''' (UWD Extension) and press ''''enter''''
  
  +
#Click '''Drill Down'''
−
#Enter ''''70'''' (Bank EDI) and press ''''enter''''
  
−
#Enter ''''FW'''' next to Chase Paymentech and press ''''enter''''
 +
#Click '''Unipharm Wholesale 1613455 - (company) and click '''Select'''
  +
#Click '''Process Dates from and to''' (i.e. 5/1/2017 to 5/31/2017)
−
#Enter ''''IM'''' to import file and press ''''enter'''' '''(when file has been imported, the file name will disappear)'''
  
  +
#Click '''Generate Report'''
−
#Press ''''F12'''' to move back to previous panel
  
  +
#Copy to '''Fees Sheet''' and move '''merchant #''' and '''merchant''' to correct columns
−
#Enter ''''FI'''' next to Chase Paymentech to view file imported if there is an error and press ''''enter'''' (''if imported file does not have an error, the file will be posted automatically)''
  
  +
#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 )
  +
#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.
   
  +
===Download All Transactions===
−
==Posting after Error==
  
  +
#Click '''Recon Solution/Daily Report Review/All Transactions'''
−
1.Enter ''''DT'''' next to the file with the error and press ''''enter''''
  
  +
#Click '''UNIPHARM WHOLESALE DRUGS LTD 10946585'''
  +
#Click '''Drill Down'''
  +
#Click '''Unipharm Wholesale 1613455 - (company) and click '''Select'''
  +
#Click '''Drill Down'''
  +
#Click '''Unipharm Wholesale Drugs 6077431 - (merchant) 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, 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'''.
  +
#Check the '''Sales total''' for each credit card matches to the sales on the merchant statement
  +
#Check the '''Fees total''' for each credit card matches to the sales on the merchant statement
  +
#Make sure the '''Reconciliation Summary''' is balanced.
   
  +
===Invoice UWD Sheet Charges===
−
2.Move to ''''Errors only?''' and enter ''''Y'''' (Yes) (''this shows only transaction with errors'') and press ''''enter''''
  
  +
#Goto '''UWD Sheet''' and invoice all applicable charges in '''column AD''' (column AF will indicate which accounts to invoice)
−
Correct only missing merchant number errors. All other errors must be directed to Information Systems.
  
  +
#Enter the '''invoice number''' in column AE.
  +
#Invoice as manual (AR) invoice using item number 02003812 (separate each entry)
   
  +
[[File:Nancy36.png|500px]]
−
3.To correct missing merchant number - press ''''F12'''' twice until you move back to Bank EDI Status panel.
  
   
−
4.Press ''''F7'''' ''(Merchant)''
  
   
  +
===Manual CVM Adjustments===
−
5.Enter '''customer #''' to check if there are any merchant numbers listed for the customer ''(merchant numbers maybe inaccurate)'' and press ''''enter''''
  
  +
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
−
6.If not, press ''''F6'''' to add new merchant #
  
  +
#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
   
  +
[[File:Nancy37.png|500px]]
−
7.In the maintain a merchant screen, enter:
  
−
*enter '''customer #'''
  
−
*enter '''card type''' ''(AX-AMEX,V-Visa,P-Debit Card,DS-Discover Card)''
  
−
*enter '''merchant #''' ''(V,M and P merchant numbers are identical)''
  
−
*For store credit cared only '''(enter only if the store is using a credit card to pay for statement)'''
 
−
*Press ''''enter''''
  
   
  +
==Unipharm Wholesale 1626312 - Stand Alone and Integrated Terminals==
−
8.Repeat 6 & 7. for next card type
 
   
  +
===Download Card Type Summary by Merchant Report===
−
9.Press ''''F12'''' to move back to previous panel.
  
  +
#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''' {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\Chase Paymentech\Merchant Statements|Chase Merchant Statement}}
  +
#Change '''column B''' to numeric by copying and pasting values only
  +
#Update '''pivot table'''
   
  +
===Download Settlement Fees Detail Canada===
−
10.Enter ''''FI'''' (file imported to view errors again) and press ''''enter''''
  
  +
#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 Descriptionand change miscellaneous fees to '''FEE-SETUP''' (Note: DS = Discover, and DI = Debit Interac)
  +
#Change '''"IWL250 3G - TELUS"''' and '''"IWL250 3G - ROGERS"''' to '''"IWL250 3G - TELUS/ROGERS"'''
  +
#Copy data from downloaded file to '''Fees sheet'''
  +
#Refresh pivot table
   
  +
===Merchant Table===
−
11.Move to file - enter ''''DT'''' for details and press ''''enter''''
  
  +
#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.
  +
#Check '''Merchant Table sheet''' to ensure totals are reconciled (# of terminals matches to # terminals being rented by merchants)
  +
#The only acceptable discrepancy is merchants with more than one account (i.e. charge will not be covered by UWD).
  +
#Check for any related financial adjustments (if applicable)
  +
#Before printing statement, check over the numbers to the data table and print the statement double sided (long edge)
   
  +
===Manual CVM Adjustments===
−
12.Move to '''Errors only?''' - enter ''''Y'''' (Yes) and there should be no missing merchant # errors. If there is an error, you might have to enter the transaction ''''DT'''' and press ''''enter'''' to accept the new merchant #
  
  +
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.
−
13.Press ''''enter''''
  
  +
#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
   
  +
[[File:Nancy37.png|500px]]
−
14.Press ''''F12'''' to move back to previous panel ''(the status of the file should now read '''Ready''')''
  
−  
−
15.Enter ''''PO'''' to post file
  
−  
−
16.Press ''''enter''''
  
−  
−
17.Press ''''enter'''' to post this file into ASW. When file has been posted, the status will be '''Posted'''. (''Do not re-import a file into ASW)''
  
−  
−
18.Press ''''F12'''' to move back to previous panel.
  
−  
−
==Update Import Batch Control Log==
  
−
#Goto {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\Chase Paymentech\POS Import| Chase Import Batch File}}
  
−
#Enter '''Imported Date'''
  
−
#Enter '''Actual Date'''
  
−
#Enter '''Batch #'''
  
−
#Enter '''ASW Beginning Journal #'''
  
−
#Enter '''ASW Ending Journal #'''
  
−
#Enter '''Importer'''
  
−
#Enter any addition '''notes''' if require.
  
−
#Save '''file'''
  
   
 
[[Category:Workflows-Finance]]
  
[[Category:Workflows-Finance]]

Latest revision as of 15:56, 1 February 2021

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

Unipharm Wholesale 1613455 - Virtual Terminals

Download Card Type Summary by Merchant Report

  1. Click Recon Solution/Daily Report Review/Card Type Summary by Merchant
  2. Click UNIPHARM WHOLESALE DRUGS LTD 10946585
  3. Click Drill Down
  4. Click Unipharm Wholesale 1613455 - (company) and click Select
  5. Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
  6. Click Generate Report
  7. 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. Chase Merchant Statement

Download Settlement Fees Detail Canada

  1. Click Recon Solution/Settlement Review/Settlement Fees Details Canada
  2. Click UNIPHARM WHOLESALE DRUGS LTD 10946585
  3. Click Drill Down
  4. Click Unipharm Wholesale 1613455 - (company) and click Select
  5. Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
  6. Click Generate Report
  7. Copy to Fees Sheet and move merchant # and merchant to correct columns
  8. 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
  9. 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 )
  10. Change amount to positive number (Remember to #Copy and paste as values to remove any formulas)
  11. 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.

Download All Transactions

  1. Click Recon Solution/Daily Report Review/All Transactions
  2. Click UNIPHARM WHOLESALE DRUGS LTD 10946585
  3. Click Drill Down
  4. Click Unipharm Wholesale 1613455 - (company) and click Select
  5. Click Drill Down
  6. Click Unipharm Wholesale Drugs 6077431 - (merchant) and click Select
  7. Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
  8. Click Generate Report
  9. Copy only merchant 6077431 to UWD Sheet
  10. Pull down columns A & B to remove any previous manual entries
  11. Pull down columns V to AH to remove any previous manual entries
  12. 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) [1]
  13. 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.
  14. Check the Sales total for each credit card matches to the sales on the merchant statement
  15. Check the Fees total for each credit card matches to the sales on the merchant statement
  16. Make sure the Reconciliation Summary is balanced.

Invoice UWD Sheet Charges

  1. Goto UWD Sheet and invoice all applicable charges in column AD (column AF will indicate which accounts to invoice)
  2. Enter the invoice number in column AE.
  3. Invoice as manual (AR) invoice using item number 02003812 (separate each entry)

Nancy36.png


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)

  1. Goto Data sheet and make sure the reconciliation summary is balanced
  2. Change Dates column E1 to month end date, i.e. September 30, 2017 and column E2 to the month end date i.e. 93017.
  3. Click Portfolio sheet and clock Print All Statements
  4. Goto Data sheet and enter manual entry for all applicable charges (see column BU) (Note - the manual entry charge should match printed Merchant Statement)
  5. Use CVM template and make sure due date is closest 10th or 25th

Nancy37.png

Unipharm Wholesale 1626312 - Stand Alone and Integrated Terminals

Download Card Type Summary by Merchant Report

  1. Click Recon Solution/Daily Report Review/Card Type Summary by Merchant
  2. Click UNIPHARM WHOLESALE DRUGS LTD 10946585
  3. Click Drill Down
  4. Click Unipharm Wholesale 1626312 - (company) and click Select
  5. Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
  6. Click Generate Report
  7. Copy to Sales Sheet Chase Merchant Statement
  8. Change column B to numeric by copying and pasting values only
  9. Update pivot table

Download Settlement Fees Detail Canada

  1. Click Recon Solution/Settlement Review/Settlement Fees Details Canada
  2. Click UNIPHARM WHOLESALE DRUGS LTD 10946585
  3. Click Drill Down
  4. Click Unipharm Wholesale 1626312 - (company) and click Select
  5. Click Process Dates from and to (i.e. 5/1/2017 to 5/31/2017)
  6. Click Generate Report
  7. Sort data by Card Type and Fee Desc
  8. 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)
  9. Change "IWL250 3G - TELUS" and "IWL250 3G - ROGERS" to "IWL250 3G - TELUS/ROGERS"
  10. Copy data from downloaded file to Fees sheet
  11. Refresh pivot table

Merchant Table

  1. Make sure Data Total reconciles to the Data total on the Data Sheet. If not, you might be missing some merchants.
  2. 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.
  3. Check Merchant Table sheet to ensure totals are reconciled (# of terminals matches to # terminals being rented by merchants)
  4. The only acceptable discrepancy is merchants with more than one account (i.e. charge will not be covered by UWD).
  5. Check for any related financial adjustments (if applicable)
  6. Before printing statement, check over the numbers to the data table and print the statement double sided (long edge)

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)

  1. Goto Data sheet and make sure the reconciliation summary is balanced and the same as the pdf 1626312-Statement.
  2. Change Dates (columns E1 & E2) to month end date.
  3. Click Portfolio sheet and clock Print All Statements
  4. Goto Data sheet and enter manual entry for all applicable charges (see column BU) (Note - the manual entry charge should match printed Merchant Statement)
  5. Use CVM template and make sure due date is closest 10th or 25th

Nancy37.png

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:Chase_Paymentech-Merchant_Statements&oldid=13411"