Home

ClientLine® User Manual

1. Code Type Code Description Count Amount Percent Count Amount Percent Ci USD MC L Requested Trangachor formation Nob Rec ere t y 733 73 100 O 0 00 Oe ua ML y Warme Buletin Pile 2 TAAl 100 L D Li LESS The Disputes Dashboard is divided into several sections e Retrievals 6 months Displays the number of Open Expired and Fulfilled items Click the Open column hyperlink and you can quickly drill down into the detail to research items that are still pending a response e Chargebacks 6 months Provides the number of Open Expired and Fulfilled chargeback items Click the Open column hyperlink and you can quickly drill down into the detail to research items that are still pending a response e Chargebacks Debited Gives you the number and dollar amount of chargebacks that were debited over the last 7 days Click on the Status Date hyperlink to view a detailed listing e Chargebacks Reversed Displays the number and dollar amount of chargebacks that were reversed over the last 7 days Click on the Status Date hyperlink to view a detailed listing EPICOR Payment Exchange Page 8 e Chargeback History 6 months Is a statistical report the gives you the total counts dollar amounts and percentages of chargebacks over the last 6 months Chargebacks are categorized as o Received from Issuer Incoming Chargebacks received from issuer o Reversed to Issuer Chargebacks that were resolved and
2. 6 AA t Bugness vun r 111 Mam Street H uiglan TX Hrs EE 0000000000 Fandi Far MM PC EEI 0 722575557555555 ESTE T OF MONTH 6 4 4 Statement Information screen Real Time Statement Delivery Data Unavailable 6 4 5 IRS Information screen IRS Filing Name Foreign Entity Indicator Validation Response Code lt lt Validation Response Date lt lt EPICOR Payment Exchange Page 41 6 4 6 Account Fees screen Account Fees __ ree nate and pesrription Amount Last Changed _ _ 001 MASTERCARD SALES TRANS FEE 05000 05 21 2010 DOS VISA SALES TRANS FEE 05000 05 21 2010 009 DINERS SALES TRANS 05000 05 21 2010 013 AMEX SALES TRANS FEE 05000 05 21 2010 015 DISCOVER SALES TRANS FEE 05000 05 21 2010 018 DEBIT ATM CARD TRANSACTION FEE 008200 05 21 2010 030 MASTERCARD LOCAL AUTH FEE 003200 05 21 2010 031 MASTERCARD WATS AUTH FEE 003200 05 21 2010 032 MASTERCARD LOCAL WATS AUTH FEE 03200 05 21 2010 033 MASTERCARD ECR AUTH FEE 003200 05 21 2010 034 MASTERCARD DIRECT SOLUTIONS 003200 05 21 2010 035 MASTERCARD VOICE AUTH FEE 230000 06 20 2002 036 MASTERCARD VRU AUTH FEE 250000 06 20 2002 6 4 7 Terminal List Details screen Terminal List Details EDC Terminal Serial Network Maintained Natntenante Ship Install Billing Billing
3. If you wish to compress the report to a smaller file size select Yes from the Zip Option field otherwise choose No Choose either Web Online or E mail from the Select Delivery Option field You will need to determine the maximum file size that your email provider will allow and then specify it in the Select Mailbox Size lt 1MB 1MB 5MB 5MB 10MB 10MB 15MB gt 15MB If you wish to receive an e mail when the report is generated then select Yes from the Notify When Finished field otherwise choose NO If you choose YES an email address must be specified in the E Mail To Address 1 field Select E Mail to Address 2 and E Mail to Address 3 to add other recipients Additional email recipients do not have to be enrolled ClientLine users Not all email fields need to be filled in Click Submit 7 1 4 Report Confirmation screen Report Schedule Confirmation EPICOR Payment Exchange Page 46 Note e f you do not have Microsoft Office loaded to your pc you can still receive a Scheduled Report e Once the report is complete double click on the report number to prompt the report to open in a word processing application available on your pc e Reports will take longer to generate if they span a large amount of time or are pulled at a high level of hierarchy These reports will include large amounts of data or multiple locations e Scheduled reports that are larger than 16MB in size cannot be emailed from our server to you Also your
4. Date Hbaler 3 aed Part tT inem Jeterdianpo Charges pee f Reversala E E Em T AW pz TE p T r n RAE arene Tulal Por urency Qiii A_i ers TE 8 473 338 aa i 3 is 95 518 7 d Bi a 35 73 ra 37495 9948 Field Definitions are listed below for both the Deposit Summary Totals and the Deposit Expanded Detail report Currency Code 3 digit code identifying the funded currency Date The date of the checking account deposit Net Sales Sales Refund Amount EPICOR Payment Exchange Page 17 3rd Party Adjustments Transactions that are passed directly to a third party service provider for processing and or funding Adjustments Amounts credited to or deducted from your account to resolve processing or billing discrepancies Interchange Charges Variable amounts established by the Card Associations for processing transactions Service Charges Amounts charged to authorize process and settle card transactions Fees A range of transaction based and or fixed amounts for specific card processing services Chargebacks Reversals Transactions that are challenged or disputed by a cardholder or card issuing bank A Chargeback is the amount that is disputed by the cardholder or card issuing bank A Reversal is the amount that was previously resolved against the merchant but now is resolved in favor of the merchant Deposit Amount deposited to your checking account The Deposit Expanded Detail report displays bank dep
5. Card Type field you may choose Both Credit or Debit Click Submit Transactions Search 6 1 2 Transaction Detail Report Transaction Detail Agent Date 08 01 2010 Sorted by Date Time Location ID External ig Mud lorc Batch Number Submit Data s grind Trans Trans Trans Date Merchant ID Number Amount Type 999999999999 000000017800 08 01 2010 m 9999999 9999 146 64 Sale 08 01 2010 Processed 02 031762 EPICOR Payment Exchange Page 33 The Transaction Search gives you a list of transactions associated with a specific account number for up to 6 months Remember that when searching you can use the full card number or the last 4 digits This report is commonly used to verify double charges check for a credit on a disputed transaction or determine how frequently a customer makes a purchase The following section defines many of the fields on the report Location ID Location where the transaction was processed External Merchant ID Additional merchant number associated with the location Currency Code 3 digit code identifying the currency the transaction was processed in Terminal ID ID number of the terminal on which the transactions was processed Batch Number Number of the batch in which the transaction was submitted Submit Date Date the batch was submitted to Merchant Services Card Type The brand associated with the card number Cardholder Number The number identifying the cardholder issuer and card brand Trans Amo
6. Payment Exchange Page 29 5 2 Retrievals When an issuing bank sends a retrieval request it is important to respond quickly Unanswered retrieval requests can result in chargebacks From the Disputes tab on the toolbar select Retrievals 5 2 1 Retrievals search window Retrievals Access All Hierarchies for Agent Retrieval type A v C Retrieval Status All Statuses Y Card Ref Case Cardholder Number Sub Category Filter All Card Types v Card search must be full card number or last four digits Example 1234567890123456 or 3456 Enter the desired date within the past 13 months into required Date Range From To fields You may also specify and filter by Amount Range The Retrieval Type field lets you select All Open Expired or Fulfilled In the Retrieval Status field you can choose All Open Expired or Fulfilled You can select from the drop down to filter by Cardholder Number Reference Number or Case Number and enter the appropriate value in the Card Ref Case field Filter by card type or by Reason Code in the Sub Category field Click Submit 5 2 2 Retrieval List Retrieval List Agent Status Date Range 08 01 2010 to 08 05 2010 Download Spreadsheet 2 Open Retrievals Location ID External Merchant ID currency Code Request Reason Card Type ene Nun Number Status Date Status 999999999999 999999999 VISA 99999 06 24 2010 214 36 08 22 2010 08 02 2010 Open Total for Status Open Total f
7. iA PEA E Fra ar qan ns et pend nob pras RAT M ia i Mba Ls AAA 2 A Heg Mi 13 T LP iudi UL a Cra Er ca ri k n 2 549 85 1 3554 j Hr da E P IE G DW EE wn Tr USD E im Bar mung EN i YT T ma N an an H e ous ii i A Ed ovn ust irc y X i 3 Tan ul dl E SL EUR 11H 74 ans fete ler srran Cede HEFE AT IAE Le LES FI8I B5 i if FER A La 1657 aud er is The Chargeback Analysis is broken down by card type reason code and provides a grand total and dollar amount This report is the same as that displayed in the Chargeback History section of the Chargeback Dashboard but on this report a date range within the last 13 months may be used instead of the last 7 days The following section defines some of the fields found on this report Currency Code the 3 digit code identifying the currency the chargebacks were initiated in Card Type The brand associated with the card number Reason Code Numeric chargeback reason code Description Description of the chargeback reason code Received from Issuer Incoming Chargebacks received from the issuer Reversed to Issuer by Merchant Services Chargeback cases that were auto represented automatically resolved back to the issuer Resubmitted Reversed to Issuer by Merchant Chargeback cases that were sent back to the issuer based on information received from the merchant Debited to Merchant Received from Issuer Reversed to Issuer by Merchant Services Resubmitted Reve
8. 08 384 67 105 00 70 00 503 59 276 19 6 844 73 Retum to Menu Page 44 7 Reports The Report selection contains 4 submenu or dropdown choices Scheduled Report View Reports Update Reports and Delete Reports Scheduled Reports allows you to generate reports showing summary and detail information Reports can be sent to individual or multiple users via email or downloaded in multiple formats PDF MSWord Excel or CSV You can also schedule reports to run daily weekly monthly yearly or quarterly 7 1 Scheduled Reports The scheduler template allows you to schedule report delivery on a recurring basis Select the report format delivery frequency level of hierarchy start and end date and delivery method Select the Reports tab from the toolbar then click Scheduled Report from the dropdown 7 1 1 Report Builder category selection screen Report Builder Access All Hierarchles for Lead Corporate ul fao n qe run ez a T 1 at a j a F L mr ALLA L Comore CUSTOM DEPLOYMENT Submit Enter ID and level Choose from the dropdown in the Select Report Category field Click Submit 7 1 2 Report selection screen Report Builder Cergpsrad ALIN List of Scheduled Repara ner HLDIDI Bul chiedi contaming hand keyed Trenaacti na HLADOLL Fybirda wank fe du ALAC Fred summary by kerl k r HLADO6 Ai yi her ator eia In the Select Report dropdown choose
9. 7 72 247 49 436 54 3 11 7 215 1 415 635 65 89 17 uso VISA 30 Services not provided or merchandise not received 329 71 722 15 1 58 10 1 862 85 2 60 35 9 267 74 12 92 284 60 591 56 84 48 USD VISA 41 Cancelled recurring transaction 301 40 869 09 0 90 3 460 88 1 13 3 649 66 1 59 295 39 758 55 97 28 USD VISA 3 Not as described or defective merchandise 157 29 945 24 0 66 c 908 06 3 03 12 3 328 60 11 12 141 25 708 58 85 85 uso VISA 60 Illegible fulfillment 4 1 194 81 0 03 4 1 194 81 100 00 0 0 00 0 00 0 0 00 0 00 USD VISA 711 Declined authonzation 20 2 481 69 0 05 0 0 00 0 00 0 0 00 0 00 20 2481 69 100 00 USD VISA 72 No authorization 124 21 999 39 048 4 32 44 0 15 0 0 00 0 00 120 21 966 95 99 85 uso VISA 23 Expired card 2 462 85 0 01 1 211 44 45 68 0 0 00 251 41 54 32 USD VISA 75 Cardholder does not recognize transaction 2 645 494 751 18 10 87 35 6 789 49 1 37 57 8 496 81 1 72 2 553 479 464 88 96 91 USD VISA 76 Incorrect transaction code u s 3 920 48 0 02 2 290 50 31 56 0 0 00 629 98 68 44 USD VISA 22 Non matching account number 17 1662 35 0 04 2 105 81 6 37 0 0 00 0 00 15 1556 54 93 63 USD VISA 80 Incorrect transaction amount or account number 164 41 483 78 0 91 11 75 6 13 1 216 50 0 52 152 38 723 53 93 35 USD VISA 81 Fraudulent transaction card present 305 102 982 93 2 26 39 10 759 33 10 45 3 1 846 32 1 79 263 90 377 28 87 76 USD VISA 82 Duplicate processing 633 99 204 62 2 18 27 4 562 17 4 60 49 8 3
10. HE Moving Letlers Rasen Nex riquaned held Note View an online demo of ClientLine at https www myClientLine9 net publicS clrp training demo as Once enrolled you can access ClientLine from the URL https www myClientLine net or https www businesstrack com Select Merchant Login ClientLince Now Introducing Business Track Have an Account Create an Account ANDA payment proces sig w h an easy 40 00 Sus of ordne 1003 giri o y exter ras ute qu Nr aed efe ter haege pra sieuburtc barsa rs GELTEN You future success PRAMS nat rou Nave De DUI A INSI dey 19 Mace tore Cilent ine Demo y Use your login and password that you received at enrollment Merchant Login User ID Forgot User ID Password Forgot Password EPICOR Payment Exchange Page gt Navigation The following information may be useful when using ClientLine Reporting e Click most column headings throughout the application to sort in Ascending or Descending order e Any text displayed with a blue underline is a hyperlink to another page or screen e Once a blue hyperlink has been accessed it will change to purple e Credit amounts will be colored in red on all online screens with the exception of the disputes Chargeback and Retrieval modules e Use the horizontal and vertical scroll bars to view the entire screen or pages e Use the Page Navigation buttons FORWARD PAGE BACK buttons an
11. Start Stop Number Number Name By Date Date Method Amount Date Date pc PC Personal 649498 CARDNET CUST 2 C stomer Computer Owned 6 5 Card Issuer Identification You can access issuing bank information for Visa and MasterCard numbers through this option This information is also available when you click on View Card Issuer Info from any Credit Transaction Detail or Debit Transaction Detail screen Select Research from the toolbar and then click Card Issuer Identification from the dropdown 6 5 1 Card Issuer Identification screen Card Issuer Identification Access All Hierarchies for Agent Enter only the first 6 digits of the cardholder number and click Submit 6 5 2 Card Issuer Information screen MasterCard Issuer Information EPICOR Payment Exchange Page 42 6 6 Fraud Reporting The Fraud Reporting option allows you to monitor refunds by location that have taken place within the last 6 months Select Research tab from the toolbar and click Fraud Reporting from the dropdown 6 6 1 Fraud Reporting selection screen Fraud Reporting Access All Hierarchies for Corporate The Date Range From To field is a required field and you must enter a date within the last 6 months Enter desired amounts in the Amount Range fields Click Submit 6 6 2 Fraud Refund Summary By Location screen Fraud Refund Summary By Location Location Date 08 26 2010 LocatonID Name _ turrency Code RefundCount Refund
12. T ds 4 i XT EN I p Tr B pd D DC I 817 19 B Kura wit He n Eji L d dal Eua Eu Ba Eur E oe b DE Ebi EDO GNE Lo H pl A THH hig tani pa Li AA mar J PEL Pak E pc D na zd pw anm 97 pE uit He il TIE quee Ru Miel piii da Gire i pm Cura E E b mr i BL hare LSD a u A o A an Se h LAA CA 30 ae a h FU BS j Ee 5 e jal i usn Mc za ALI yf narrib poin 1 rT ag 1 155 i Gur H bm li rM REID mi HC ru La 2 Wi pagan i5 Tid 1 2d lin i th Tb E bas Ps A i is TA a in usr Ld FT amd cuu parma mni nans 4 Pha r BES D X PETE 3 113 24 IT IT a EN 12 der usar bi y ade da Br lt ar dns A B a i a dr em Li px p Iz EREB1 li EO Kay With Teall Agr HG mel bd ET Ea ath di FEM LEFEL i 44 42 Cue n rma LEE EEL a7 Part Wat roe at cn BE pra CWP E Pal MEER d n j ob 1 Bit Bus Biri li dj MI 1 1 a LEM EN tx us E dl pala rre Br ar n m r ban 1 114 EA ii E Ed E Box D d Ed a me A uin thi p ion o6 De BIT d a ji Tii Gul a sa Ort E px Q me A Lal ys ue WED TEI n M AP ery ayan Ja 5 194 95 lh li M Tp E ca b Bn pite v dort uar His 1 Pr dede AA Pep e L l b aki ia 1 iH hira E E Qnm li ELM LE T Lud TRE Lo DEA J Baran ren nire an nb uerba 1 Er JU a Cuma L d AE SATA iat VLA E LITER pi Tal De jJ li Dirk ax UR zn R E Raza k l EX IDRATE usn PEI Ml Pr ak la m rar ard ser Ba E An 1d ya 0 ar SL E Dx DIR L A 2 L xar wae via Er Lopate proa li Tu Pom e Lr LE al y cab d aka il
13. To fields You may also specify and filter by Amount Range The Chargeback Status field lets you select All Open All Closed All Reversed or All Statuses In the Category field you can choose All Debited Pre Arbitration Pre Compliance Pre Note Request for Doc Reversed Sent to Collection or Auto Represent Filter by card type or by Reason Code in the Sub Category field On the last row of the search window you can select from the drop down to filter by Cardholder Number Reference Number or Case Number and enter the appropriate value in the Cards Ref Case field 5 1 2 Chargeback List Chargeback List Agent Status Date Range 08 01 2010 to 08 05 2010 Download Spreadsheet x 3 Ezternal Currency Chargeback Case Cardholder Trans Chargeback Status Not as described or asaanaaaaaaanananaacaaa ARANA 99999 99999999999999999999999 999999 9999 999999999999 USD defective merchandise 999999999 22999979999 07 22 2010 251 41 08 21 2010 08 01 2010 OPEN Mot as described or 00000 99999999999999999999999 gog99 5 999999999999 USD He eye Ba aaa ee 999999999 9999997779999 07 22 2010 251 41 08 21 2010 08 01 2010 OPEN Total for Category Debited 502 82 Total for Status All Open 502 82 Total for Currency USD 502 82 Record 1 to 2 of 2 Page 1 of 1 Go To Page Go to Location he From the Chargeback List you can click on the Cardholder Number hyperlink to drill down to the chargeback detail EPICOR
14. Word This guide will describe the most common features of ClientLine Log In amp password maintenance Before using ClientLine you must first go to https www businesstrack com and select Enroll You will need your 12 digit Merchant ID MID Please follow the instructions on page 10 of your Welcome Kit ClientLines Now Introducing Business Track he anhancad web Ica lor Packing analyzing and manitoring payment processing inibrmalon 3 nar Ta L E 1 5 E Have an Account Create an Account Analyze payment processing with an easy Ic uz B suite of online lc gainang greatir insight fo qunckTy and e amp ecteeely manage pour abecyoruc Tane aione Your fura Eucorgs requires Thal you have me business insight decisions tomorrow EPICOR Payment Exchange Page 4 As indicated in on page 10 of your Welcome Kit you will need to complete the ClientLine enrollment information as displayed on the illustration below Please completely fill eut the farm below Merchant amp Business Checking Accounl if Tax i Tx ID 16 not required for marchants outside of tha United States Bank Sort Code Transit Bank Sort Code Transit 4 nal required for mienchanbs in he United labes First Hame Last Marne Zip Postal Codo Phone Number Emiail Varity Email Select Language Please Select v Security Question Please Select Security Question Answer Type the RED Moving Letters
15. be filled in Click Submit 8 2 4 Group Report Schedule Confirmation screen Report Schedule Confirmation View Online Reports EPICOR Payment Exchange Page 55
16. card not present 75 Vi corporate card card not present 76 Vi business card card not present 551 Vi purchasing card level 3 44 Vi commercial card level 2 443 Vi corporate card level 2 20 Vi cps electronic commerce basic 735 Vi cps rewards 2 1736 Vi cps card not present 16 Mc consumer debit refund 1 6 Mc merit 1 electronic commerce debit 2416 Mc domestic merit i debit 2095 High value Merit I 4 Mc enhanced merit i 742 Mc world comml data rate iii business 4 Mc world elite merit 1 555 Mc corp intl business 2 Mc commercial data rate iii us corp 12 Mc commercial data rate i us corp 13 Mc corp data rate iii us bus corp 179 Mc corp data rate i us business 137 Mr ecnrn data rate iii fic nurchace 971 The Pie Chart graphically illustrates the card types that make up the interchange expense for your business EPICOR Payment Exchange Page 28 5 Disputes The Disputes tab contains 4 selections to help you manage the resolution of chargebacks and retrieval requests 5 1 Chargebacks You can query and view chargebacks within the last 13 months by selecting the Disputes tab and then choosing Chargebacks from the dropdown 5 1 1 Chargebacks search screen Chargebacks Access Al Y DEM O Card search must be full card number or last four digits Example 1234567890123456 or 3456 Enter the desired date within the past 13 months into required Date Range From
17. differently 2 2 2 Terminal Transaction List Terminal Transaction List Location Submit Dates 08 10 2010 Sorted by Date Time Laz anan To Ezternal Currency Terminal Batch Submit Card Cardholder Trans Trans Trans Entry Auth Merchant ID Code Number Date Type Number Amount Type Date Mode Code 999999999999 USD 00000 000320100001 08 10 2010 VISA 999999 e0999 316 94 Sale 08 09 2010 Processed 1 055014 999999999999 USD 00000 000320100001 08 10 2010 AMEX Ss9999 999 210 94 Sale 08 09 2010 Processed 00 166847 999999999999 USD 00000 000320100001 08 10 2010 VISA Sssss9 999 104 94 Sale 08 09 2010 Processed 01 007924 999999999999 USD 00000 000320100001 08 10 2010 VISA 199999179999 210 94 Sale 08 09 2010 Processed 01 120501 EPICOR Payment Exchange Page 13 Click on the Cardholder Number hyperlink to display additional detail on the transaction 2 3 Rejected Transactions Select Rejected Transactions from the submenu and a search menu displays allowing you to search on rejected transactions for a date range within the last 6 months You may use this report to identify training opportunities at point of sale Complete the required Date Range fields and other optional fields and click the Submit button Submit 2 3 1 Rejected Transaction Search screen Rejected Transactions Access All Hierarchies for Agent mu e SET Required as mm dd yyyy nenene ID Enter the ID and level for a specific location Sub
18. for up to 13 months Select the Funding tab from the toolbar and then click Monthly Fee and Service Charge History from the dropdown 3 4 1 Monthly Fee and Service Charge History search window Monthly Fee and Service Charge History Acersa Bll Hie rar hai fer Agent wt srse AAA Ena Enter the ID and the level you wish to search and click Submit 3 4 2 Withheld Funds report Monthly Fee and Service Charge History Laatia July 2004 pe August hl j Correr y Code Honk Am E WD Mir 2008 LE Augatt 2003 rmm ABpesmess TE bao Qetaber 200 34 Bn w Tb v MH UD December MH IL Muy CULI D lF ateruary 2010 ED March 2010 2Li Apri 2010 EL Ra iui usc Jure 2031 Li Aly zu 2D Bugust 2010 The Amount field displays the monthly fee and service charges that were billed for the month 3 5 Monthly Statement The Monthly Statement allows you to view a copy of your monthly processing statement You can save a copy to your hard drive or print it Note The size limit for Monthly statements is 2MB Statements larger than that will not be available through ClientLine 3 5 1 Monthly Statement search window Monthly Statement Access All Hierarchies for Corporate Required as mm dd yyyy Enter the ID and the level you wish to search You may enter dates within the past 13 months in the Statement Date Range From To fields If you wish to view your account activity at a corporate level choose Recap from the Statement Type field Ch
19. from the list of reports and click Submit EPICOR Payment Exchange Page 45 7 1 3 Report Scheduler screen HL4006 Authorization detail Corporate Report Frequency Run Now MP Adobe PDF File J mm dd yyyy 03 10 2011 NO n CRM Web Online mm dd yyyy mm dd yyyy lt lt lt EMalToAddress3 E Mail To Address2 00 E Mail To Address3 fd lt In the Report Schedule section select Report Frequency Run Now Daily Weekly Monthly Quarterly Yearly Selecting anything other than Run Now in Report Frequency will generate a recurring report of that frequency Select Receive Report On to choose date you wish to receive the report The Dates to Report section sets the beginning and end dates that are to be included on your report Enter a date in the End Date field only when a Run Now report is chosen The Report Delivery Options section contains several key fields You can choose how you wish to view your report from the Select Report Format field Choices in the dropdown include Word for Windows Document Excel 8 0 Comma separated values or Adobe PDF File Reports in CSV will not contain headers as this would cause a failure to load into a database If you intend to save this report to a separate application such as Microsoft Access it is suggested you choose the Delivery option of email and the Report Format option of Microsoft Excel 8 0 or CSV
20. sent back to the issuer o Resubmitted Reversal to Issuer by Merchant Cases that were sent back to the issuer based on information received from the merchant o Debited to Merchant Received from issuer Reversed to Issuer by Merchant Services Resubmitted Reversed to Issuer by Merchant 1 2 2 Chargebacks Debited amp Chargebacks Reversed Chargebacks Debited Chargebacks Reversed Currency Chargeback Chargeback Currency Chargeback Chargeback Code Amount Code Amount UsD 0 05 2010 155 28 481 50 USD 08 05 2010 5 536 00 USD 08062010 181 35 478 89 USO 08 06 2020 3 160 57 USO 0807 2010 125 3 965 20 usp 08 09 2010 16 2 494 59 USD 03 08 2010 79 16 156 30 USD 20 10 2010 3 830 60 USD 0809 2010 100 2 146 84 USD 08 11 2010 4 1 158 53 USO 08102010 41 6 669 399 USD 08 11 2010 101 25 364 09 1 2 3 Chargeback History Chargeback History 6 Months Card Reason Received from Issuer Reversed ars Merchant eo ni to Issuer Debited to Merchant Type Code Count Amount Percent Count Amount Percent Count Amount Percent Count Amount Percent US MC 0 00 10 Requested transaction information not received 334 77 087 66 1 69 0 00 2 956 19 3 83 324 74 131 47 96 17 d 2 01 0 a 07 Warning bulletin file 3 745 37 0 02 1 212 93 28 57 0 0 00 0 00 532 44 71 43 USD MC 08 Requested required authorization not obtained 18 11 937 89 0 26 9 1 657 24 14 00 0 0 00 0 00 9 10 180 65 86 0 USD MC 12 Account nu
21. the authorization response 6 3 Query Builder Create your own reports with the Query Builder option You can determine which fields are on the report as well as the date range card types the locations included in the report and how the data is grouped and sorted Choose either Account Summary or Bank Deposits both are described below Select the Research tab from the tool bar and click Query Builder from the dropdown EPICOR Payment Exchange Page 36 6 3 1 Authorization Data Report Query Builder Access All Hierarchies for Agent Date Ramgerrom j Jrequiredas mm dd yyyy Enter ID and select level Enter the desired dates into the required Date Range From To field You must choose either Account Summary or Bank Deposits from the dropdown in the Report On field Both of these selections are described in the sections below The checking account may be entered in the Checking Account Number field or search for it by clicking the search button to the right of the field Click Submit Account Summary Report This report is generated from your submitted sales information 6 3 2 Account Summary Report criteria screen Account Summary Report Agent Date 09 22 2010 Location ID Location ID v O Asc External Merchant ID None v his O Desc Currency Code None v Submit Date Card Type ALL Card Types Batch Number EN Sales Count DISCOVER A Sales Amou
22. 0002 000009300002 000009300001 000009300001 Sorted by Date Time Batch Number 11 03 2009 11 10 2009 11 12 2009 11 13 2009 11 13 2009 11 13 2009 11 16 2009 11 17 2009 11 18 2009 11 18 2009 11 19 2009 11 20 2009 11 20 2009 11 24 2009 11 24 2009 11 24 2009 11 24 2009 11 25 2009 11 25 2009 11 27 2009 11 30 2009 11 30 2009 11 30 2009 11 30 2009 EPICOR Payment Exchange VISA VISA VISA VISA VISA VISA VISA VISA VISA VISA VISA VISA VISA VISA VISA MC MC VISA VISA VISA VISA Dates 11 01 2009 to 11 30 2009 ta N 999999 9998 990999 9999 999999 e ggo9 999999 9999 999999 9999 999999 9999 9999999999 9999999999 9999999999 99999959999 999999 9999 999999 9999 999999 9999 999999 9999 999999 9999 999999 9999 999999 9999 999999 9999 999999 9999 99999979999 999999 9999 999999 9999 999999 9999 99999979999 999999 9999 999999 9999 cu Card rdholder COMETE 11 03 2009 11 10 2009 11 12 2009 11 13 2009 11 13 2009 11 13 2009 11 16 2009 11 17 2009 11 18 2009 11 18 2009 11 19 2009 11 20 2009 11 20 2009 11 24 2009 11 24 2009 11 24 2009 11 24 2009 11 25 2009 11 25 2009 11 27 2009 11 30 2009 11 30 2009 11 30 2009 11 30 2009 210 00 51 07 210 00 105 00 116 76 126 66 33 00 100 00 43 71 172 67 717 92 98 51 14 41 2 422 54 41 13 140 00 175 00 191 82 535
23. 11 Vi non us sig v004 Vi pre cps2000 foreign MN G N RANA EE CI SD SD BR N BB H o H H B ED Record 1 to 20 of 20 Page 1 of 1 Go To Page 1 Y 2 739 78 206 95 82 22 53 49 29 99 55 63 1 764 17 300 11 55 66 187 23 867 57 550 97 552 09 377 05 394 76 175 00 58 03 104 98 48 13 157 72 8 654 55 31 27 2 36 0 94 0 61 0 34 0 63 20 1495 3 4395 0 64 95 2 14 9 90 6 2995 6 3095 4 30 4 51 2 0095 0 66 1 20 0 55 1 8095 100 29 21 4 49 1 12 1 1295 1 12 1 12 15 73 2 25 1 12 1 12 10 1195 10 1195 5 62 1 12 4 49 2 2595 1 12 1 12 2 25 3 37 100 Click on Description hyperlink to view by location from there you can click on the Location ID hyperlink to view the Credit Transaction List On the Credit Transaction list you can click the Cardholder Number hyperlink to view Credit Transaction Detail Identify which locations are not qualifying for the lowest interchange rates Qualification Expense This selection provides you with interchange expense information by plan code by location which enables you to see which locations may be contributing to higher interchange costs After selecting Rate Analysis from the toolbar click Qualification Analysis from the dropdown 4 2 1 Qualification Expense report search window Qualification Expense Access Location 999999999999 Transaction Type All Required as mm dd yyyy a Pian Dep w Zi ia E
24. 2 255 99 0 0 00 0 0 00 255 99 999999999999 USD 08 02 2010 VISA 000151020021 2 193 75 0 0 00 0 0 00 193 75 Grand Totals 75 9 755 87 2 59 98 0 0 00 9 695 89 Page 1 of 1 Go To Page 1 Y Bank Deposits Report This report is based off your bank deposit information EPICOR Payment Exchange Page 38 6 3 4 Bank Deposit Report criteria screen Bank Deposit Report Agent Date 08 01 2010 to 08 02 2010 Pte i Fields To Show ooo Location ID O None v ml O asc External Merchant ID O None a None i O Desc Currency Code Li None B Checking Account Number O Funded Date O Batch Number O Funding Category O Minor Funding Category O Item Count O Credit Amount O Debit Amount E Total Amount O Step 4 Select State None Selected AK of Location 75 AL of Location 1550 AR of Location 123 v Submit Query Of the selections listed in the Fields to Show window 8 are required as indicated in the list below Location ID Required Field External Merchant ID Required Field Currency Code Required Field Checking Account Number Required Field Funded Date Required Field Batch Number Required Field Funding Category Required Field Minor Funding Category Required Field Item Count Credit Amount Debit Amount Total Amount Choose up to 3 fields to group the report results In the Group By fields choose from the following Location ID External Merchant ID Curr
25. 2010 027801 Deposits MASTERCARD 1 271 44 0 00 271 44 999999999999 USD 999999999 08 01 2010 017801 Deposits VISA 1 2 915 29 0 00 2 915 29 999999999999 USD 999999999 08 01 2010 017801 Deposits MASTERCARD 1 1 039 25 0 00 1 039 25 999999999999 USD 999999999 08 01 2010 017801 Deposits AMERICAN EXP 1 276 46 0 00 276 46 999999999999 USD 999999999 08 01 2010 017801 Deposits MU GEESE 1 0 00 276 46 276 46 999999999999 USD 999999999 08 02 2010 027801 Deposits VISA 1 229 01 0 00 229 01 999999999999 USD 099999999 08 02 2010 027801 Deposits MASTERCARD 1 35 00 0 00 35 00 999999999999 USD 999999999 08 02 2010 027801 Deposits AMERICAN EXP 1 167 63 0 00 167 63 999999999999 USD 999999999 08 02 2010 027801 Deposits E 1 0 00 167 63 167 63 999999999999 USD 999999999 08 01 2010 017801 Deposits VISA 1 289 47 0 00 289 47 USD 999999999 08 01 2010 017801 Deposits AMERICAN EXP 1 139 99 0 00 139 99 SEMEN ADJUSTMENT FOR 999999999999 USD 999999999 08 01 2010 017801 Deposits errs cA 1 0 00 139 99 139 99 999999999999 USD 999999999 08 01 2010 017801 Deposits VISA 1 422 96 0 00 422 96 999999999999 USD 999999999 08 01 2010 017801 Deposits MASTERCARD 1 199 99 0 00 199 99 Grand Totals 21 9 082 04 584 08 8 497 96 Page 1 of 1 Go To Page 1 Y 6 4 Location Profile Details The Location Profile Details displays account information such as Statement Setup IRS Information Account Fees and Terminal List Details Use this option to list your corporate locations and review th
26. 5 45 100 66 247 00 53 318 07 87 931 40 50 054 35 209 057 10 1 320 75 421 88 2 957 37 EPICOR Payment Exchange 65 130 84 8 675 50 5 877 34 206 099 73 Ticket 16 06 216 23 Page 16 3 Funding The Funding tab is used to reconcile your bank account and contains 5 submenu selections e Bank Deposits e All Activity Summary e Withheld Funds e Monthly Fee and Service Charge History e Monthly Statement 3 1 Bank Deposits There are 2 reports available to assist with reconciliation of your bank statement the Deposit Summary Totals and the Deposit Expanded Detail Make your selection from the drop down on the last field of the Bank Deposits search window You can limit your search by entering the Funding Date Range Checking Account Number and select either Date or Checking Account from the Grouping field to determine how the totals are displayed on your report 3 1 1 Bank Deposits search window Bank Deposits Access All Hiprarcbses Tew Agent a whi sunran Toss j e E Shown below is the Deposit Summary Totals report grouped by Date This report may be used in addition to the Bank Deposit information on the Reporting Dashboard if you need to view more than 7 days of deposit information You can click the Date hyperlink to view funding categories by checking account number 3 1 2 Bank Deposits search window rra Summary Totals Funding Date Il j 10 2010 L twenty Code
27. 81 31 3 1 505 45 40 6195 D 0 00 0 00 USD Total for VISA 14 4 413 51 84 3395 E 1 420 82 93 06 Ti 2 992 69 80 73 0 0 00 0 00 Total for USD 18 5 233 66 100 00 8 1 526 81 100 00 10 3 706 85 100 00 0 0 00 0 00 Record 1 to 5 of 5 Page 1 of 1 Go To Page 1 Y The Retrieval Analysis report is broken down by card type reason code and provides a grand total and dollar amount Items in the Retrievals column contain both Media and Chargeback retrievals Analyze the reason codes to determine which are adding to your workload The following section defines some of the fields found on this report Currency Code the 3 digit code identifying the currency the retrievals were initiated in Card Type The brand associated with the card number Reason Code Numeric retrieval reason code Description Description of the retrieval reason code Retrievals Incoming retrievals received from the issuer This is the total of the Fulfilled Unfulfilled and Expired columns Fulfilled Retrieval requests responded to by the merchant and sent to the issuer Unfulfilled Retrieval requests that were not fulfilled by the merchant Expired Retrieval requests that were not fulfilled within the requested timeframe EPICOR Payment Exchange Page 32 6 Research The Research tab provides seven submenu selections that will be valuable for researching cardholder activity 6 1 Card Search The Card Search utility has 4 reports Transactions Author
28. 83 04 8 45 557 86 259 41 86 95 USD VISA 83 Fraudulent transaction card not present 8 591 1 916 565 94 42 10 125 19 789 72 1 03 171 58 426 41 3 05 8 295 1 838 349 81 95 92 uso VISA 85 Credit not processed 485 102 185 76 2 24 11 2 091 05 2 05 46 7 957 36 7 79 428 92 137 35 90 17 USD VISA 86 Paid by other means 195 39 714 42 0 87 4 713 61 1 80 3 308 82 0 78 188 38 691 99 97 43 USD Total for VISA 13 975 2 964 821 98 65 12 282 52 104 29 1 76 380 98 881 26 3 34 13 313 2 813 836 43 94 91 Total for Currency Code USD 21 846 4 552 660 28 100 00 691 174 670 40 3 84 627 148 317 80 3 26 20 528 4 229 672 08 92 91 1 3 Today s Data Selecting Today s Data from the Dashboard tab dropdown provides you with a look at the settled transactions for the current day You cannot view transactions that have been posted but not settled You can view a Card Type Summary or a Bank Deposit Summary Both views give you the ability to drilldown to detail information EPICOR Payment Exchange Page 9 2 Sales Tab Transaction activity can be monitored for a number of different transaction types When you select Submitted Sales from the toolbar submenus will display based on your account setup Those submenus may include e Credit Transactions e Debit Transactions e Terminal Transactions e Rejected Transactions e Transaction Summary e Monthly Sales History Field definitions and descriptions are provided below for all submenu screens Address Verifi
29. A V010 Vi foreign standard 1 58 03 0 93 1 6 00 0 96 1 59 USD VISA VOLi Viinternational commercial commercial 1 104 98 1 89 1 8 00 1 74 1 59 USD VISA V111 Vi non us sig 2 48 13 0 87 1 8 00 0 80 3 17 USD VISA V133 PR ELEC RTL2 CR 9 867 57 11 28 1 3 00 14 41 14 2995 USD VISA V135 PR ELE RTL2 PLAT 1 187 23 Bd 1 8 00 e lt m la hais 1 59 USD VISA V136 PR ELEC RTL2 SIGN 5 552 09 10 49 1 9 00 9 17 7 94 USD VISA V141 PR STD CR al 377 05 6 22 1 65 00 6 26 1 59 USD VISA Vid4 PR STD SIGN 2 175 00 3 50 2 00 2 9195 3 1795 USD VISA V741 PR ELEC RTL2 DB 9 550 97 6 89 1 25 00 9 1595 14 2995 USD VISA V742 PR STD DB 4 394 76 6 51 1 65 00 6 56 5 3595 Total for Currency Code 63 5 914 77 97 61 100 100 Interchange Expense is an estimated calculation amounts may change when actual billing occurs Record 1 to 19 of 19 Page 1 of 1 First Previous Next aS Go To Page 1 A Click on the Description hyperlink to drill down by location and then on the Location ID hyperlink to view the Credit Transaction list From there you may click on the Cardholder Number hyperlink to drill down to the Credit Transaction Detail view Qualification Expense Location 999999999999 DBA Name Submit Date Range 10 01 2009 to 10 05 2009 Vi moto ecommerce return debit 6 7 Vi eirf non cps all other debit 10 Vi cps electronic commerce basic debit 23165 Vi cps card not present debit 772 Vi signature preferred
30. Amount Gross Sales PercentofSales 99999999999 DBA Name USD 88 2 828 14 64 571 77 4 38 Record 1 to 1 of 1 Page 1 of 1 Grand Total 2 828 14 Go To Page Return to Menu 6 7 Refunds with No Sale This option allows you to view a detailed list of refunds without matching sales for the date range within the last 6 months Select Research tab from the toolbar and click Refunds with No Sales from the dropdown 6 7 1 Refund With No Sales Activity selection screen Refund With No Sales Activity Access Location 999999999999 Card search must be full card number or last four digits Example 1234567890123456 or 3456 Enter ID and select level The required Date Range From To field must contain dates within the last 6 months You may enter the full card number or just the last 4 digits in the Card field Click Submit EPICOR Payment Exchange Page 43 6 7 2 Refund With No Sales Activity report screen Refund With No Sales Activity Location 999999999999 DBA Name 999999999999 USD USD USD USD USD USD USD Total for Currency USD Record 1 to 24 of 24 Page 1 of 1 First Previous Next Last Go To Page 1 Y 000009030001 000009100002 000009120003 000009130001 000009130001 000009130001 000009160001 000009170002 000009180002 000009180001 000009190002 000007200002 000007200002 000009240002 000009240002 000009240002 000009240001 000009250002 000009250001 000009270001 00000930
31. Bank Deposit Summary section or click the Description hyperlink in the Processing Expense Summary section to see detailed items for the funding categories 3 3 Withheld Funds If your account is set up for Withheld Funds this report can be used to track the funds withheld from the deposit to your account Select Funding from the toolbar then click Withheld Funds from the dropdown 3 3 1 Withheld Funds search window WithHeld Funds esa AB Hrs f r a Sen I read Corporate SYSP w te a Pr Me E m Enter the location ID and select the level you would like to search The Process Date Range From To fields must contain dates within the last 13 months Click Submit to run the report 3 3 2 Withheld Funds report WithHeld Funds Localia Bun Gate Kiz 12 220 80 Fresa OF 08 7 2010 to J 12 2030 Location fi Currency Cade bate ategerrg cr Balance Total usn Ce dl amp erord i te ia j Page i al 1 Ga Ta Page 1 Withheld Funds report field definitions Location ID Location where the transaction was processed Currency Code 3 digit code identifying the funded currency Date Date of the account balance Category Type of funds being held Account Balance The balance being withheld from the merchant s business checking account EPICOR Payment Exchange Page 19 3 4 Monthly Fee and Service Charge History The Monthly Fee and Service Charge History displays information by month and contains information
32. ClientLine User Manual EPICOR Payment Exchanges Table of Contents o en E OTT Log In password maintenance ccccocccccnncononncnnnnnonononarononanonnnnanononaronenaronenanos NENE O p o oeporpr pjhhhjhj nnaammm L o e o XX E Np DE z DN N NJaZ ZzR DM 1 1 Reporting Dashboard seminarios L2 DibutesDasnbOSE tucan NER Co HDH MR 4 1 f nn An mm mrrm j 2 1 Credit amp Debit Transactions l l kk kek kk k 2 2 Terminal Transactions ruinas 2 3 Rejected Transactions h kek keke 2 4 Transaction Summary M L kk kk k k k k k K K k 2 5 Monthly Sales History cccoocccncnocononaconocanonnonacononarononnncononaronenarononos MEE ei Rm Sl Bal k DEPOS NETT 3 2 AllActivity Summary oer rrr orar rra nora eene 3 8 Withheld Funds i cs orte etienne terno tp te rre j SEDE 3 4 Monthly Fee and Service Charge History A 3 5 Monthly Statement eese eran nenne eee E TET RRR A FRCS PY 1G idea 4 1 Qualification Analysis esee 42 Qualtication EXO CNS Cc cuivre aia SS PI succ MEER Ge CENTRES o MEME a E EEUU Duro Charceback Anal S S ETT SEMEN uu 7 SIS ta TUNER o ono A oL O Oo EPICOR Payment Exchange Page 2 Trans ACTIONS SM ra 33 Ale dra o A en 34 Cd CISA CIS Sears 34 IRetrievals A e ee O kxr zz Lia 35 62 Authorization OSO Ro OPERE TOS 36 gt EE Oa BUC mmm 36 Account ummy REDO Tn tii 37 Dank Depo
33. D Unique number assigned to the transaction by the merchant Location ID Location where the transaction was processed Merchant Name DBA Name EPICOR Payment Exchange Page 10 Net Processed Amount Net Submitted Amount Rejected Amount Net Processed Count Net Submitted Count Rejected Count Net Submitted Count Sales Count Refund Count Net Submitted Amount Sales Amount Refund Amount Partial Auth Indicator Indicates if a partial auth was received Ex a cardholder has a credit line of 500 00 and a balance of 450 00 a sale of 100 00 is attempted A partial auth may be obtained for 50 00 rather than declining the entire sale Payment Amount Amount of transaction that was processed Plan Code Identifies the interchange level at which the transaction cleared Processed Currency Code 3 digit code and description identifying the currency the transaction was processed in Reclass Code Code that identifies why a transaction was reclassified Reference Number 23 digit Outgoing Acquirer reference number Refund Amount The total dollar amount of the refunds credit for the submitted date Refund Count The total number of refunds credits for the submitted date Reject Description Description of reject reason Status Indicates whether transaction was Processed Cancelled or Rejected Sales Count Total number of sales for submitted date Sales Amount The total dollar amount of the transactions for the submitted da
34. ONIC COMMER CORPT amp ENUS PURCHASE CORPT amp ENUS BUS WORLD ELITE OTHER BUS ENH VAL TEE 7955 WASTERCARDWONDEBTTOTA 55 MASTERCARD DEBIT MERIT I ECOMM DH 1378400 on 15 En 154 0150 d MASTERCARDDESTTOTAL GE fT VISA NONDEBIT CPERETAL KEY ENTERED CPEREWARDS 2 CAS BUSINESS CARD T amp E CAS PURCHASING CARD TEE SIGNATURE PREFERRED CRP E VISA NONDEBIT TOTAL 21100 1 7100 1 100 1 7100 1 7100 1 100 21100 PRA i go ab da ka 134 DEBIT ar ETE M Ge DEDCIONCHR METIA ANS ENEE Pua aes DUNS QNID rabun crm for amch participating payan without raqard ku rey eure fer cracin cxx ar iria ri lam raura mrrvcuntz or any chan mn par rarpaci ns iunc idanification mura Total GROSS REPORTABLE SALES TINSA zi EPICOR Payment Exchange Page 25 4 Rate Analysis The Rate Analysis tab on the toolbar gives you access to reports needed to manage and analyze your interchange expenses There are 3 selections on the submenu e Qualification Analysis e Qualification Expense e Billbacks Not used with Epicor Payment Exchange Each of these selections will be described in the sections below 4 1 Qualification Analysis Depending on your pricing plan all transactions may not be processed at the same rate ClientLine Reporting provides you with 13 months of summary and 6 months of detail history for each clear plan Typically merchants use the information to quantify and evaluate the amount and the pe
35. Range Enter the transaction dollar amount you wish to include in the search Cardholder Invoice Reference Enter any of the 3 numbers and choose the corresponding option from the drop down box When searching by Cardholder Number you may enter either the last 4 digits or the complete card number Card Type Select ALL Visa MasterCard Discover American Express or Other Sort By Select from the dropdown Date Time Cardholder Number Amount After entering the search criteria click Submit and the Credit Transaction List or Debit Transaction List displays Click on any of the column headings to sort the report differently 2 1 2 Credit Transaction List Credit Transaction List Agent Submit Date 08 10 2010 Download Spreadsheet X a Sorted by Date Time External Currency Yerminal Batch Submit card Cardholder Trans e Entr Auth 999999999999 USD 00000 000320100001 08 10 2010 py 999999 9999 816 94 ET 08 09 2010 Processed 01 055014 999999999999 USD 00000 000320100001 08 10 2010 AMEX 99995979999 210 94 Sale 08 09 2010 Processed 00 166847 999999999999 USD 00000 000320100001 08 10 2010 VISA 999999 9999 104 94 Sale 08 09 2010 Processed 01 007924 999999990999 USD 00000 000320100001 08 10 2010 VISA m 210 94 Sale 08 09 2010 Processed 01 120501 999999999999 USD 00000 000320100001 08 10 2010 AMEX 9699597779559 316 94 Sale 08 09 2010 Processed 00 148955 Click on the Cardholder Number ant the Credit Tr
36. SIS HLO104 Qualification expense detail by location date 1 RATE ANALYSIS HLO126 Qualification expense summary by corporate al Click on the desired report hyperlink in the Report ID column 7 2 2 Download Report Detail screen Download Report Detail Corporate Date 08 27 2010 Report ID Report Status Report Title Report Error Delivery Option Report Format Date Last Run HL1501 2571928 Scheduled Chargeback detail by status date Web Online PDF 73KB 08 26 2010 Click on the appropriate report number hyperlink in the Report ID column EPICOR Payment Exchange Page 47 7 2 3 File Download window File Download E3 Do you want to open or save this file E Mame HL1501 25718928 826 pdF EL Type Adobe Acrobat Document From www mvclientlinenm net harm your computer IF pau do not trust the source do not open or Y While files from the Internet can be useful same files can potentially save this File Vv hats the risk Click Open to view the report click Save to save the report to your local file 7 3 Update Reports Follow these procedures to revise an existing scheduled report Select the Reports tab on the toolbar then click Update Reports from the dropdown 7 3 1 Update Reports selection window Update Reports Access All Hierarchies for Corporate Submit Enter ID and select level If you are logged in under a higher level of hierarchy than what the report you are looking for was scheduled you will
37. ansaction Detail window will display EPICOR Payment Exchange Page 12 2 1 3 Credit Transaction Detail Credit Transaction Detail Transaction Detail 999999999999 OBA Name d Ty VISA 00000 9999999999999999 000320100001 60104360 08 10 2010 08 09 2010 01 Manual key entered 316 94 M Manual gt d c USD U S Dollar V051 Vi cps rewards 2 I gt Processed 0 00 USD U S Dollar 0 0 999999999999999999999999 000219713289307 Authorizations View Card Issuer Info Addendums 2 2 Terminal Transactions Select Terminal Transactions from the submenu and a search menu displays allowing you to search on credit card transactions within the last 6 months for a specific terminal You can use this report to research potential internal fraud by reviewing a specific terminal for suspicious activity Complete the required Date Range fields and other optional fields and click the Submit button Submit 2 2 1 Terminal Transaction Selection Window Access All Hierarchies lor Agent Lou is ID Enter the ID and level for a specific location Submit Date Range Required Field Enter the dates within the last 6 months that you wish to include in the search Terminal ID Required Field Enter the terminal that you wish to include in the search After entering the search criteria click Submit and the Terminal Transaction List displays Click on any of the column headings to sort the report
38. ansactions click on the Cardholder Number hyperlink to display details about an individual transaction Sales Trend Daily sales for the last 7 days are illustrated on a bar graph and help identify peak sales days Submitted Card Type Summary Breaks down previous day sales by card type Click on the card type hyperlink to drill down to individual transactions that make up that card type total EPICOR Payment Exchange Page e Bank Deposits Provide the transfers to your bank account over the last 7 days Drill down on the date to view checking account information The Deposit column indicates the amount deposited to your checking account by funding category Credit Click on the date hyperlink to display details on each day s deposits Click the Bank Account hyperlink to display each deposit by Funding Category 1 2 Disputes Dashboard Chargebacks and Retrievals are displayed on the Disputes Dashboard 1 2 1 Disputes Dashboard DASHBOARD SUBMITTED SALES FUNDING RATE ANALYSIS DISPUTES RESEARCH SCHEDULED REPORTS GROUPS INTERNAL CPTIONS Chargebacks Debited Number of tems A y 636 TB Currency ialbus Chargeback Cha Percentage of Totals b ors Eb Code Date Coun A 1r 17 USD 0123 3007 5 USD DAS 2 Chargehacks Gmerths Kurk Fh s USD OL C P LIEBER ar cenas USD 010235007 5 Percentage of Totala Recewed from Issuer Reversed ip Issuer by Merchant Services Eezuh ic Card i
39. backs that have been reversed back to the issuing bank Retrievals Search 6 1 5 Retrieval List Retrieval List Agent Status Date Range 08 01 2010 to 08 05 2010 Download Spreadsheet M 8 Open Retrievals Location ID External Merchant ID Currency Code Request Reason Case Number Card Type Cardholder Number Status Date Status USD 28 9999 9999 06 24 2010 214 36 08 22 2010 08 02 2010 Open 999999999 VISA 999999 999999999999 Total for Status Open 214 36 Total for Currency USD 214 36 Record 1 to 1 of 1 Page 1 of 1 Go To Page 11 s Go to Location The Retrievals List displays retrieval information for a specific card number Enter the 3 required fields on the search screen Account Number Invoice Number Activity Type and Date Range You may also filter by amount and Date Type Transaction Date or Status Date Use this report to verify the number of retrievals on a specific cardholder number Field definitions are quite similar to those described in the Chargebacks Search section The 2 listed below are those that are unique to the Retrievals List Request Reason Code sent by issuing bank identifying reason for request Status e Open retrieval requests that have not been fulfilled and the due date has not expired e Expired retrieval requests that were not fulfilled within the requested timeframe e Fulfilled retrieval requests responded to by the merchant and sent to the issuer EPICOR Payment Exc
40. cation Service Code provided to merchant when the cardholder s billing address was validated as being correct before completion of a mail telephone transaction Authorization Amount Amount of the authorization request Authorization Code Code provided during the authorization process if an authorization approval was received Authorization Date Date the transaction was submitted for authorization approval Authorization Response The issuer s reply to an authorization request Batch Number Number of the batch in which the transaction was submitted Billback Reason Identifies the reason a reclassification Cardholder Number The number identifying the cardholder issuer and card brand Card Type The brand associated with the card number Currency Code 3 digit code identifying the currency the transaction was processed in Currency Conversion Rate Exchange rate used when a transaction is submitted and processed in two different currencies CVV2 CVC2 Result Indicator determining the card validation through the magnetic swipe was captured at the time of sale Entry Description Description identifying how the cardholder information was entered at the point of sale Entry Mode Code identifying how the cardholder account information was entered or captured at the point of sale Expiration Date Date the cardholder s card expires External Merchant ID Additional merchant number associated with the location Invoice Trace I
41. d Go to Page dropdown selection on the bottom of screens to page forward or backward on the online screens e Use the Return to Menu or Return to Dashboard buttons to return back to the Reporting Dashboard Return to Dashboard e Some online screens have Excel and CSV Comma Separated Value icons e Click on these icons to view the data on the online screen in either XLS or CSV format 28 Download Spreadsheet e If entering ClientLine at a hierarchy level higher than location you will see the below ID field on all screens La Lead Corporate w Lead Corporate o If you wish to view data at the MID and hierarchy level for which you are enrolled this field must remain blank If you wish to view data for a different MID hierarchy level enter the MID you wish to view in the ID field and choose the corresponding hierarchy level I upou know the DBA Name or the State but not the MID you can click on the box to do a Merchant ID Lookup e Click on the Logoff button on the toolbar to end your ClientLine amp X amp session The ClientLine9 tool bar is shown below Each of the tabs will be discussed in detail in the pages that follow Navigate to each section by clicking on the tabs Sales late Analysis Reporting Dashboard EPICOR Payment Exchange Page 6 1 Dashboard Tab ClientLine has two Dashboards Reporting Dashboard and Disputes Dashboard which allow you to quickly view the last 7
42. days of your bankcard processing information The Reporting Dashboard will be the default display when you log into ClientLine 1 1 Reporting Dashboard The reporting dashboard gives you a snapshot of your most recent bankcard activity There are 4 key areas of information included on the Reporting Dashboard shown below Hyperlinks allow you to drill down to greater detail in 3 of the 4 areas of the Reporting Dashboard 1 1 1 Reporting Dashboard E MAD SUBMITTED SALES FUNDINE RATE AMALYSIS DISPUTES a a A di E E A INTERNAL OPTIONS subrutied Sales Do lar Agent 1212121214212 All Locations wmm a DL 21 2007 27950 83704293 DLT 17 3301 528 759 06 01 23 2007 18 782 611 172 51 DL 24 2007 20 602 683 675 43 DEO 21373 703 706 49 01 26 2007 31 240 1 014 361 41 PETF ari 032 OS dre 035 Obie OI Bank Deposits TEE E24 Pw WT ne 17739 577 TH 2117 Iang n nk P0233 0419 n1 nnm n nn 3 5014 nT Submitted Sales Displays daily gross sales for credit and debit cards over the last 7 days Click on the date to drill down and view the Batch Number Submit date Terminal ID Transaction Count Transaction Amount and Average Ticket amount Use the number in the Trans Amount column to compare to your Eagle s RDS totals Click on the date hyperlink to drill down to batch details displayed by terminal You can drill down to individual transactions by clicking on the transaction amount hyperlink In the individual tr
43. e Card Type Summary provides you with a summary for all card types for the past 13 months You can drill down by clicking on the card type hyperlink to view a breakdown by location and then click on the cardholder number hyperlink to view transaction details for the past 6 months 2 4 2 Card Type Summary Card Type Summary Totals Location na 10 2010 te 08 10 2010 Het Processed ae Submit Card Sales Refund Retard Het Submitted Het Submitted he pect Het Processed Code Date Amount Count Amount Count Amount Count Count OB 10 2010 Subtotal for Date Subtotal for Currency Code Page Totals uso Grand Total WSO eS uso ust uso WSO Record 1 to 4 of 4 Page of HE VISA OSCAR AMEX JCB DINER Ge 19 1 11 35 To Paga 1 3 705 54 214 92 2476 34 7 135 66 71 135 66 7 138 66 791 81 3 705 59 214 97 2 426 34 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 com coco co 0 00 0 00 0 00 0 00 791 81 3 705 59 14 42 2426 34 7 138 66 7 138 55 7 138 66 791 81 3 705 59 214 97 2 4 25 34 0 00 0 00 LJ of oo voc 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Brnount 791 81 3 705 59 214 92 2436 34 7 135 66 7 138 55 7 138 66 791 81 2 705 59 214 92 2 426 34 0 00 0 00 The Batch Summary displays closed batches for a given day or date range and like the Card Type Summary it is available for 13 months with detail available for the pas
44. e Detail Status Report to ensure that the information on file is accurate Select the Research tab from the toolbar and then click Location Profile Details from the dropdown If you have a single location the Location Profile Details Status report will appear If you have multiple locations the following selection screen will display 6 4 1 Bank Deposit Report criteria screen Location Profile Details Access All Hierarchies for Agent IIA Locsin ame v mea 578060666555056 II EPICOR Payment Exchange Page 40 The dropdown on Select Lookup Field allows you to choose from Location Name Merchant Name Location Address Location City Location State Location Zip or Merchant ID The Select a Pattern field has a dropdown with choices that include Starts With Equals and Includes Enter the search string you wish to use in the Enter Value field Click Submit 6 4 2 Location Profile Details screen Location Profile Details Agent Location ID External Merchant ID Location Name Location Status Location Address Merchant Name 999999999999 DBAName OPEN 111 Main StreetHouston TX 99999 DBAName 999999999999 DBAName OPEN 111 Main StreetHouston TX 99999 DBAName Click on the Location ID hyperlink to display the Location Profile Details Status Statement Information IRS Information Account fees and Terminal List Details all Shown below 6 4 3 Location Profile Details Status screen Location Profile Detalle Status m _
45. edek ya seksi ye nia 999999999 99999999999999999999999 999999 9999 07 22 2010 251 41 08 21 2010 08 01 2010 OPEN Total for Category Debited 502 82 Total for Status All Open 502 82 Total for Currency USD 502 82 Record 1 to 2 of 2 Page 1 of 1 Go To Page 11 bh Go to Location b EPICOR Payment Exchange Page 34 This report allows you to view chargeback information for a specific account number Enter the account number date range amount and transaction date or status date You can use this report to determine the number of chargebacks on a specific cardholder number Click on the Cardholder Number hyperlink to view the Chargeback Detail Report The following sections define many of the fields on this report Chargeback Description Description of the chargeback reason code Case Number Number assigned by Merchant Services for the chargeback Reference Number 23 digit Outgoing Acquirer reference number Cardholder Number The number identifying the cardholder issuer and card brand Trans Date Date the transaction occurred Chargeback Amount Amount of the dispute Due Date The particular day on or before which merchant response must be received to comply with Association regulations Status Date Date of the last action taken by the dispute back office Status e Open Chargebacks that have not been responded to and the due date has not expired e Closed Chargebacks where the due date has expired e Reversed Charge
46. email system may limit incoming file sizes to you In both cases you will need to select Web Online as the delivery option and save to your desktop Reports that are over 10MB will be held for an overnight delivery Web Online reports will be deleted from the system after 2 days e Emailed reports that are larger than your mailbox size will attempt to be zipped and emailed to you If the report still is larger than your mail box size an email will be sent to you advising you to go online to view Size limit for scheduled reports is 250 MB If your report exceeds this size you will need to rerun the report at a lower level of hierarchy or for a smaller date range 7 2 View Reports In this section you will learn how to download and view generated reports You may need to do this for very large reports if they exceed the email system size limits As mentioned in the previous section scheduled reports larger than 16MD cannot be emailed from the server to you To view reports select Reports from the toolbar and then click View Reports from the dropdown 7 2 1 Report Download Summary screen Report Download Summary Corporate Date 08 27 2010 FUEL CG0302 Fuel product detail 1 SALES HL1100 Reconciliation report 2 CUSTOM HL1525 Chargeback Exception by Location report 1 FUNDING HLO410 Daily deposit totals 1 DISPUTES HL1501 Chargeback detail by status date 1 DISPUTES HL1506 Cb percent of sales based on corporate al RATE ANALY
47. ency Code Checking Account Number Funded Date Batch Number Funding Category EPICOR Payment Exchange Page 39 Minor Funding Category Select the Sort By field from the dropdown and click the radio button to choose whether to sort in Ascending or Descending order From the windows at the bottom of the criteria window select the state and locations that you wish to include in the report from the Select State and Select Locations windows The Report Locations Selected window will display the locations chosen To run the report click Submit Query If you wish to revise the selections click Clear Screen An example of the Bank Deposit Report is shown below 6 3 5 Bank Deposit Report criteria screen Bank Deposit Report Agent Date 08 01 2010 to 08 02 2010 Currency Checking Account Funded Batch Funding Minor Funding Credit Debit Total modam O Date Number Category Category Amount Amount Amount 999999999999 USD 999999999 08 01 2010 017801 Deposits DEBIT ATM CARD 2 634 70 0 00 634 70 999999999999 USD 999999999 08 01 2010 017801 Deposits DEBIT ATM CARD 1 47 48 0 00 47 48 999999999999 USD 999999999 08 01 2010 017801 Deposits VISA 1 1 166 62 0 00 1 166 62 999999999999 USD 999999999 08 01 2010 017801 Deposits MASTERCARD 1 594 91 0 00 594 91 999999999999 USD 999999999 08 01 2010 017801 Deposits VISA 1 551 84 0 00 551 84 999999999999 USD 999999999 08 02 2010 027801 Deposits VISA 1 100 00 0 00 100 00 999999999999 USD 999999999 08 02
48. es can easily identify each segment of your portfolio and can be continually applied to scheduled reports in the future Once created you can easily go back into the system and add or delete locations to from a specific group The Groups selection can only be used if your access is set at the corporate level or higher and multiple locations are rolling up to your corporate level access The two submenu selections from Groups are Group Builder and Group Reports Each are described in the sections below 8 1 Group Builder In this section you will learn how to add update and delete your unique groups Select Groups from the toolbar and then click Group Builder from the dropdown The Action field in the selection window contains 3 choices each are described below Add New Group 8 1 1 Group Builder selection screen Group Builder J Select Add New Group from the Action field dropdown and click Submit 8 1 2 Group Description State selection screen Add New Reporting Group Corporate Date 8 27 2010 Step 1 Group Descripti Group Description TEST Step None Selected A AK of Location 1 AL of Location 8 AR of Location 4 AZ of Location 28 Submit Build In Step 1 Group Description enter name into the Group Description field that you will remember for future updates and reference In Step 2 Select State choose the state of locations that you wish to include Click S
49. hange Page 35 6 2 Authorization Search You can use this option to search on authorization codes and amount ranges Authorization data is available for the past 6 months Select the Research tab on the toolbar and then click Authorization Search from the dropdown 6 2 1 Authorization Search Authorization Search Access All Hierarchies for Agent C ONE e B v Amount Range or Auth Code must be Entered Card search must be full card number or last four digits Example 1234567890123456 or 3456 Enter ID and select level The Date Range Amount Range and Authorization Code are required fields Card Number and Card Type Both Debit Credit are optional fields to help filter the view Click Submit 6 2 2 Authorization Data List Authorization Data List Apre Dates 0860142010 Tires ins 2010 Sorted br Cate Time Leratism ID ExternalMerchaatID Currency Code Cardholder hamber Twpiratism Dale Amewat Auth Date Aesth Code Respsase Code uit Drs gogo EE bu PIFI bad bd ed racra u rad UE Db LL LES En Go To Pags Y ira te Locabon Field Definitions can be found in the sections above Listed below are a few of the fields more specific to the Authorization Data List Amount Amount of authorization Auth Date Date the transaction was authorized Auth Code Code provided during the authorization process if an authorization approval was received Response Code 2 digit code identifying
50. izations Chargebacks and Retrievals Each of the reports begin with the same search screen shown below The Activity Type field determines the report that is produced Note Fields displayed on the search window may vary based upon the report selection Select the Research tab from the toolbar and then click Card Search from the drop down 6 1 1 Retrieval Analysis report Authorizations search screen shown Card Search Access All Hierarchies for Agent EmterCardNumber Invoite i card Number Required Activity Type Authorizations Y Cate Type Authorization Date Y CC A rr4HERGCR73 22nm aA 58I3935 a om Card search must be full card number or last four digits Example 1234567890123456 or 3456 Enter ID and select level The Enter Card Number Invoice Number field is a required field Select from the drop down and enter the appropriate value You may search a card number by using either the complete number or the last 4 digits of the card number In the Activity Type field you will need to select one of the 4 report types Transactions Authorizations Chargebacks and Retrievals Choose between Submit Date and Transaction Date in the Date Type field You may also specify a dollar range in the Amount Range field In the example shown above the Authorization Code field is displayed when Authorizations is selected as the Activity Type Enter the authorization code for which you wish to search in this field In the
51. lt A lt A lt 5A lt O Report Type Pie Chat v pie Chart is applicable only for location level Enter the required Date Range From To within the past 13months Select the Transaction Type All Sales Refunds Chargebacks Reversals and Sort By Plan Description Dollar Amount On the Report Type field you may select Report or Pie Chart available only at the location level Click Submit Depending on your choice in the Report Type field either the Report or the Pie Chart will display both are illustrated below EPICOR Payment Exchange Page 27 4 2 2 Qualification Expense report Qualification Expense Location Submit Date Range 08 01 2010 to 08 10 2010 Sales Erin Card Type Description Trans Count Percent USD Mc MO005 Mc foreign electronic plus 14 1 764 17 29 11 1 6595 00 29 30 22 22 USD MC MO06 Mc foreign standard plus 2 300 11 6 45 2 15 00 4 98 ls USD MC M009 Mc domestic merit iii 1 29 99 0 57 1 5895 10 0 50 1 59 USD MC MO84 Mc consumer credit refund 2 1 53 49 C12 2 0995 00 0 8995 1 5995 USD MC MO95 Mc world mc merit 1 1 55 66 1 24 2 05 10 0 92 1 5995 M314 MC PREM CON STD USD Mc ACOUSISSLAC i 82 22 1 97 24 00 1 37 1 59 M316 MC PREM CON ELEC i m USD MC ACOUSISSLAC QUSISSLAC 4 206 95 4 97 2 4 00 3 44 5 3595 USD MC M609 Mc domestic merit iii debit al 55 63 0 73 1 05 15 0 92 1 5995 USD VISA 004 Vi pre cps2000 foreign 3 157 72 1 73 1 1 00 2 62 4 76 USD VIS
52. mber not on file 38 5 594 20 0 12 30 6 307 12 112 74 0 0 00 0 00 8 712 92 12 74 USD MC 31 Transaction amount differs 13 5 215 53 0 11 0 0 00 0 00 0 0 00 0 00 13 5 215 53 100 00 USD MC 34 Duplicate processing 77 10 688 33 0 23 5 493 73 4 62 3 263 22 246 69 9 931 38 92 92 uso MC 35 Card not valid or expired 6 1 109 76 0 02 5 1 101 60 99 26 0 0 00 1 8 16 0 74 USD MC 37 Fraudulent transaction no cardholder authorization 5 324 1 150 693 67 25 28 331 108 099 79 9 39 167 35 924 81 3 12 4 826 1 006 669 07 87 48 uso MC 41 Canceled recurring transaction 210 25 038 83 0 5595 1 154 14 0 6295 1 415 91 1 66 208 24 468 78 97 72 USD MC 42 Late presentment 1 211 94 0 00 1 211 94 100 00 0 0 00 0 00 0 0 00 0 00 USD MC 3 Cardholder dispute defective not as described 87 16 683 64 0 37 3 175 84 1 05 5 324 39 1 94 79 16 183 41 97 00 uso mc ss Nonreceipt of merchandise 96 20 247 73 0 44 5 1 036 60 5 12 17 3 411 25 16 85 74 15 799 88 78 03 uso MC 57 Card activated telephone transaction 2 1 624 79 0 04 0 0 00 0 00 0 0 00 0 00 2 1 624 79 100 00 USD MC 59 Services not rendered 125 18 735 74 0 41 4 895 67 4 78 0 0 00 0 00 121 17 840 07 95 22 uso MC 60 Credit not processed 151 31 046 20 0 68 3 607 14 1 96 17 3 598 33 11 59 131 26 840 73 86 45 USD MC 63 Cardholder does not recognize potential fraud 1 386 211 277 02 4 64 11 1 612 37 0 76 27 2 542 44 1 20 1 348 207 122 21 98 03 USD Total for MC 7 871 1 587 038 30 34 88 409 122 566 11
53. mi DC a DE 41 742 00 DIO OT EDO zl i I Bas D kak i ue j Bi A4 44 111 844 54 EPICOR Payment Exchange Page 22 3 5 5 Monthly Statement YOUR CARD PROCESSING STATEMENT Lo mom mnm 070541 OT O6H1 Gro TH OFA 1 GrH arzHaH1 STIR E amp zH1H1 CaciciDIDCE 1 ED BOrHzH1 CODO ZE 07441 a 0541 0rm641 07m 7HA BOrH amp H1 a re 0941 A 3700 Orin pOocODCOZ 17800 Ora Ore Ora Ors Ore 1 rara OT EEH er oren EPICOR Payment Exchange Page 23 3 5 6 Monthly Statement YouR CARD PROCESSING STATEMENT Decoripibon Tensecions memis bo AMERICAN EXPRESS Mo Chayebaci Fara niz br the Sispemernt Period Mo Ari uz renta dor fils She FEES CHARGED Date Tyne 07 2041 E 072041 ac MASTERCARD SALES TRANEFEE GITRANSACTIONS AT 025000 07 2011 FEE AMEX EDC CAFTUF I 07 2041 oraw VIZA CREDITS TRANBFEE 2 TRANBACTIONS AT 025000 0701 VHCEB REWARDS 2 07041 VEEIRF NON CFE ALL OTHER 0701 VHBIGNATURE CARD ELECTRONIC 073041 veces BUSINESS TEE Brant VE PURCHASING CARD TEE Bran Total Fea Type Legand SC Sarvice Charges IC interchange Charges FEE Fas EPICOR Payment Exchange 3 5 7 Monthly Statement YouR CARD PROCE 5 5ING STATEMENT Page 7 of Merchant Humber 123258789012 Cusiamer Sanka Warie mycileriiine net Suliemen Period 07 0111 07 21 11 Phe 1 300 555 1234 PENDING INTERCHANGE CHARGES Jade Producti corictan MASTERCARD HONDEBIT WORIDCARD OTHER MERIT I ELECTR
54. mit Date Range Required Field Enter the dates within the last 6 months that you wish to include in the search Batch Number Enter a specific batch number if you wish to exclude transactions from other batches within a date range After entering the search criteria click Submit and the Rejected Transaction List displays Click on any of the column headings to sort the report differently 2 3 2 Rejected Transaction List Rejected Transaction List Agent Submit Dates 08 01 2010 to 08 10 2010 Sorted by Date Time External A Reject Location ID Merchant Basestniion 999999999999 USD 00000 001081080001 08 08 2010 AMEX _ 999999 7 9999 214 92 Refund 08 06 2010 Rejected DUPE EDIT Record 1 to 1 of 1 Page 1 of 1 Total Amount 214 92 Go To Page Y Go to Location x Card Cardholder Trans Trans Type Number Amount Type Currency Terminal Cod ID Batch Number Submit Date Trans Date 2 4 Transaction Summary Select Transaction Summary from the submenu and a search menu displays allowing you to view either of two reconciliation reports You may select Card Type Summary or Batch Summary by choosing from the drop down in the last field on the Transaction Summary Search window EPICOR Payment Exchange Page 14 2 4 1 Transaction Summary Search window Transaction Summary Accpss All Hierarchies for Agent cae Hs ET l H D las mm dd yvy Py Card Type Summary j Submit Th
55. need to enter the MID in the ID box and select the appropriate hierarchy to update that specific report Click Submit 7 3 2 Update Report Summary screen Update Report Summary Update Report Summary For Corporate FUEL CG0302 Fuel product detail 1 SALES HL1100 Reconciliation report 1 CUSTOM HL1525 Chargeback Exception by Location report 1 FUNDING HLO410 Daily deposit totals 1 DISPUTES HL1501 Chargeback detail by status date 1 DISPUTES HL1506 Cb percent of sales based on corporate 1 RATE ANALYSIS HL0104 Qualification expense detail by location date 1 Click on the report number hyperlink in the Report ID column EPICOR Payment Exchange Page 48 7 3 3 Update Report Detail screen Update Report Detail Update Report Detail For Corporate Report ID Report Title Request Name Report Frequency Date Created Date Last Run Report Link HL1501 2571928 Chargeback detail by status date Weekly 03 10 2010 08 26 2010 HL1501 Click on the hyperlink in the Report Link column 7 3 4 Report Delivery Criteria screen Report Delivery Criteria Enter desired changes and click Submit 7 3 5 Report Update Confirmation screen Report Update Confirmation 7 4 Delete Reports To delete reports select the Reports tab on the toolbar and click Delete Reports from the dropdown 7 4 1 Delete Report Summary screen Delete Report Summary Corporate FUEL CG0302 Fuel product de
56. nt Refund Count Refund amp mount Reject Count Reject Amount Total Amount Step 5 Select Locations Step 6 Report Locations Selected AK of Location 75 None Selected AL of Location 1550 AR of Location 123 wi Click the check boxes to select the fields that you wish to show on your report from the following list The first 6 fields are required All other fields are optional Location ID Required Field External Merchant ID Required Field Currency Code Required Field Submit Date Required Field Card Type Required Field Batch Number Required Field Sales Count Sales Amount EPICOR Payment Exchange Page 37 Refund Count Refund Amount Reject Count Reject Amount Total Amount Choose up to 3 fields to group the report results You may select Location ID External Merchant ID Currency Code Submit Date Card Type or Batch Number In the Select Card Type window choose All Card Types or select a specific card type MC Visa etc to be included in your report Select the Sort By field from the dropdown and click the radio button to choose whether to sort in Ascending or Descending order From the windows at the bottom of the criteria window select the state and locations that you wish to include in the report from the Select State and Select Locations windows The Report Locations Selected window will display the locations chosen To run
57. oose Location to view a specific location s processing activity Click Submit EPICOR Payment Exchange Page 20 3 5 2 Monthly Statement List Monthly Statement List Retrieval Type Download From the Monthly Statement List window select the month you wish to view and then click Get Statement The size limit for Monthly statements is 2mb ClientLine reporting will not display any statements larger than that 3 5 3 Monthly Statement Summary Page YOUR COMPANY ANY TOWN US 12325 YOUR CARD PROCESSING STATEMENT JOHN DOE 123 AHYSTREET DRIVE ANYTOWN US 12345 ee dal pa al Total Amount You Submitted 512 907 80 Third Party Transactions 801 00 Chargebacks Reversals 0 00 Adjustments 0 00 Fees Charged 5261 96 Total Amount Processed 11 844 84 Yaar over yaar Growth Jul 11 yg Jul 10 Ea jr Mo EG oo FUTON 514 000 11 000 5 000 a non ae ae E El S a E a LR x ne y AS Sur ASS ra i D um we oy IMPORTANT INFORMATION ABOUT YOUR ACCOUNT Fuster bo page 2 for detalla EPICOR Payment Exchange Page 21 3 5 4 Monthly Statement YOUR CARD PROCESSING STATEMENT Toi Groce Jalec You Suterftied Butyritisd Hunter 05 30 11 DONOOOZOTE0O 07 01 11 ODO000017800 07 03 11 07 051 ODO000057800 0706111 DOtOD DET3D onan ODODODOT TOC 07 08 11 CARD PROCESSING STATEMENT Bate lutem l imbi er a nn am T Benth E 8774 D Ca nn u ua irin a a diu 256 a5 ake b ATA T I HET C RET
58. or Currency USD 214 36 Record 1 to 1 of 1 Go To Page 1 Y Go to Location Mj Page 1 of 1 Click on the Cardholder Number hyperlink to view details 5 3 Chargeback Analysis Chargeback Analysis provides total counts dollar amounts and percentages of Chargeback disputes Received from the Issuer Reversed to the Issuer by Merchant Services Resubmitted Reversed to the Issuer by Merchant and Debited to Merchant Select the Disputes tab from the toolbar and then click Chargeback Analysis from the dropdown EPICOR Payment Exchange Page 30 5 3 1 Chargeback Analysis search window Chargeback Analysis Access All Hierarchies for Agent o mn ELIT I Lead Corporate M SYSP Y Enter ID and select level Enter the desired date within the past 13 months into required Date Range From To fields 5 3 2 Chargeback Analysis report Hur wah r nil Ha linier bop Egarhewungdiksascied qe States Date Range ORO 1 20 L0 ba Eros FONO ert n Mese Escorial Ea kp ud Pree Deer F kai erii Inner hp Hrer kiant for bil ral dus Hann hari peri dare sar Erran Laan draga Prrprek lman Amem Pero E mml di rael Fenorak utt Be a Bopper be onorrrabme correa au LAA 5 big pod E bg p ce B V ENT 25 go gu ust His b j mi 24 bute te E ita En g Loa E Xn D Dc 12 Hobo Leo HE th bape yy an ed ue poa pet n saray l 105a DALE l 3 EA E A A 3 Im ust HE 1i asa di Fror i j a Bu aoe B B as L AA UD uer M Tara eros pra
59. osit information broken down by checking account number You can click on the Checking Account Number hyperlink to view Batch Summary Totals Click on the Location ID hyperlink to view Credit Transaction List and click on the Cardholder Number to view the Credit Transaction Detail 3 1 3 Bank Deposits search window Deposit Expanded Detail Agent Funding Gabe TI 107 2010 Checking Alcea Currency Cade i Picus Metales Ted Party Adjustments Adjustments Iaterr ange Charges Service Charges Pers Chargeback j Ra yn m ala he poet it SSS SE mixedar krainakn xwada hmc ad bikie bce icin kirr PERF Fi r nd pa 01d i pg 03 0 m T hi udi F D a i Li ed DULD dig 7 14 Et 07 1 1 PERA Uuibmid LET ki i i ha i mI aL 1e sk 04 D 11 146 24 pa 24 bike qu 3t zl af LE taj 1 1 91 ae EHEH Da Lo 2010 444 060 06 pa Le 454 075 54 H LO 115 31 iL ki 1 190 83 ad FEFE UID panh H Li 151 4 113 455 24 aad EE 2114 Ll MUN x 11 30 3 r d Ll J 9 593 71 Perera iF r I ic ad 5a E n mad t 8 t r ud Lili da Dar LEV 20210 P eS a Fa Pr 2 080 555 87 g pu 0 6 Q D oe Me 414 04 37 NURSE WORT Puk H Pu RIS Y T i i LL AXE DO si Lr nr as 7 a 1 USE rires ELO O10 VIRI 51 111 0 0 4410651 0 0 0 0434 0 0 TUDI 244 45 Pi ERECTO Pla tesa ME 4 Tuli Fg j 7 WE SAEC Hr Besse ae he oe 1051 Mad LI Lt J Ma a L Tat Fee Corte d k r A TO BATE YIEE LL EW LD LB Oy 0 07 CA Pre 37 305 val S B Grid Taal For Cu
60. oup Reports from the dropdown EPICOR Payment Exchange Page 53 8 2 1 Group Report Build selection screen Group Report Build Enter ID and level Select Report Category Disputes Funding Giftcards Rate Analysis Research Sales Each of these categories contains reports with data similar to the data found within the corresponding menu header in the online modules Click Submit 8 2 2 Group Report Report selection screen Group Report Build Select Report ForLead Corporate FUNDING Reports Select Report CGD401 Bank deposit detail by location date HI 00 Sele Report Group 000000000 Y Select Report from the list of reports provided Select Report Group from the list of your groups provided Click Submit 8 2 3 Group Report Scheduler screen CG0401 Bank deposit detail by location date Corporate 4206 Test Dates to Report mm dd yyyy C A SO A EA Select v mm dd yyyy Plame QUN NOW reports ont Notify When Finished HO lt lt lt In the Report Schedule section select from the dropdown in the Report Frequency field The choices are Run Now Daily Weekly Monthly Quarterly or Yearly Choose date you wish to receive report in the Receive Report On field EPICOR Payment Exchange Page 54 The Dates to Report section allows you to enter the beginning date of your report in the Start Date field Choose date yo
61. rcentage of sales that were processed at the higher rates This can help you identify potential opportunities at the point of sale to reduce processing expenses After selecting Rate Analysis from the toolbar click Qualification Analysis from the dropdown 4 1 1 Qualification Analysis search window Qualification Analysis Enter the ID and choose the hierarchy level The Date Range From To are required fields You may select a date range within the past 13 months Sort By has a drop down allowing you to choose Plan Description or Dollar Amount Click Submit EPICOR Payment Exchange Page 26 4 1 2 Qualification Analysis report Qualification Analysis Location Submit Date Range 08 01 2010 to 08 10 2010 Currency Code Description Trane Count Trans Amount Sales Percent by Sales Percent by Amount Count USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD USD Subtotal for Currency Code r 001 Amex pass thru M316 MC PREM CON ELEC ACQUSISSLAC M314 MC PREM CON STD ACQUSISSLAC M084 Mc consumer credit refund 2 MOO9 Mc domestic merit iii M609 Mc domestic merit iii debit MOO5 Mc foreign electronic plus MOO6 Mc foreign standard plus MO95 Mc world me merit 1 V135 PR ELE RTL2 PLAT V133 PR ELEC RTL2 CR V741 PR ELEC RTL2 DB V136 PR ELEC RTL2 SIGN HG Vi41 PR STD CR V742 PR STD DB Vid4 PR STD SIGN V010 Vi foreign standard v011 Vi international commercial standard V1
62. rrency US li 427 037 FO n arr 358 nb 34 903 104 15 410 Ir 0 00 0 00 59 973 753 37 885 SURE li 3 2 All Activity Summary The All Activity Summary report displays your processing expense along with a summary of your bank deposits for a period of up to 13 months 3 2 1 All Activity search window All Activity Summary The Funded Date Range field is the only required field enter From To dates within the last 13 months If the Checking Account Number is not known you may use the search button to the right of that field to search for a specific account number EPICOR Payment Exchange Page 18 3 2 2 All Activity Summary All Activity Summary lupra Feed Dato 08 10 2010 Ta m aze Charges JSC L D h l de ATA Barz W S 2 252 10 1 15 17 Hah Tid dent Pounded Por bate Range He Pi Li Currency ade i Dabe Ea zma cretion Amount 7 Dibra IL Li DLE L y Z1 LEO DRASDA OLD LOA sra y Code j hrf Sales ded Faiy Adjustments Adjustments ries Charges Fer Chargehach Eesergala Depa Ai 5 7T i mh c J L 1 pe 27 005 990 5 Ferdi ap lr r 3 732 LUI Inizrzharae Harnas 05 510 37 CHALE MEVEN SI X 3 abd LSO OB 10 2D1D DA LD 2010 CHABGEBACKS 63 027 19 Tial Tas USD 159 275 22 Grand Total 159 475 27 Field Definitions for the All Activity Summary report are the same as those for Bank Deposits in section 5 1 Click the Date hyperlink in the
63. rsed to Issuer by Merchant EPICOR Payment Exchange Page 31 5 4 Retrieval Analysis The Retrieval Analysis displays total counts dollar amounts and percentages of all Retrievals Media and Chargeback received from Issuer Fulfilled Unfulfilled and Expired Select the Disputes tab from the toolbar and then click Retrieval Analysis from the dropdown 5 4 1 Retrieval Analysis search window Retrieval Analysis Access All Hierarchies for Agent Pd Lead Corporate v SYSP Enter ID and select level Enter the desired date within the past 13 months into required Date Range From To fields 5 4 2 Retrieval Analysis report Retrieval Analysis Agent 08 01 2010 to 08 05 2010 Currency Card Reason Retrievals Fulfilled Unfulfilled Expired Code Type Code Description Count Amount Percent Count Amount Percent Count Amount Percent Count Amount Percent USD MC 21 Cardholder doesnot recognize transaction 3 745 04 14 24 1 105 99 6 94 2 639 05 17 2495 0 0 00 0 00 USD MC 23 Needs for personal records 1 75 11 1 4495 0 0 00 0 00 1 75 11 2 03 0 00 0 00 USD Total for MC 4 820 15 15 67 al 105 99 5 9495 2 714 16 19 27 0 0 00 0 00 USD VISA 28 Cardholder request copy with signature 4 1 014 40 19 3895 2 179 39 11 7595 2 835 01 22 5395 0 0 00 0 00 USD VISA 30 Cardholder request due to dispute 2 552 23 12 4695 0 0 00 0 00 2 652 23 17 6095 0 0 00 0 00 USD VISA 33 Fraud analysis request 8 2 746 88 52 48 5 1 241 43
64. sits T OO enr E a 38 64 Location Profile Details c c 40 6 5 Card Issuer Identification T 42 55 FUL Repo usais 43 O7 REMUS with NO Sale M 43 A o e en O o e 45 EE e A E y 45 y MEN REO DEM NI OMA HAERESI FIM ADT MUI 47 7 9 Update N DO sy neyan yen K inn eke a v la in Ras 48 7 4 Delete Reports eese rrr errori parra serere A e keka raura saa SIN say 49 OU ee ee AE ae 51 S l Group Builder socio O ees 51 Add New GFOUD usesiiimieiuh a M h had papopy N rue cas 51 Doo MM PP JJJ lb MUN o io m 52 BIZ RC poil o NN EE Et 53 52 Cre Ue elo ET EIER 53 EPICOR Payment Exchange Page 3 Introduction ClientLine Reporting is a robust online tool that gives you 24 7 access to your bankcard processing information With ClientLine you can e Review daily bankcard activity e View 6 months of credit card transaction details and a year of summary information e Research customer inquiries card activity and transactions e Analyze processing expenses e View print email monthly statements e Reconcile bankcard funding with bank deposits e Monitor and resolve chargebacks and retrieval requests e Identify refunds with no matching sales e Create scheduled reports in a variety of formats print email PDF spreadsheet or MS
65. t and click on the button as needed EPICOR Payment Exchange Page 52 If no other changes are needed click Submit Update To add locations to your report use your mouse to highlight the state in Step 2 The locations for that state will appear in Step 3 Using your mouse highlight the location you would like to add to the group Click on the button If more than one location needs to be added continue to highlight and click on the button as needed Once you have finished adding all the locations needed Click Submit Update The Group Activity Confirmation should appear Group Activity Confirmation Report Group Update is Complete Report Group Update More Locations Update More States Complete Group Build Delete Group 8 1 7 Group Builder selection screen Group Builder Select Delete Group from the Action field dropdown From the Select Report Group dropdown choose the group to be deleted Click Submit 8 1 8 Update Reports selection screen Update Reports Please review the following location list used to create this reporting group Number Name X Address City State County Zip Delete Group A listing of all the current locations for the group will appear Click Delete Group to delete the group Delete Confirmation window displays Update Reports 8 2 Group Reports This section describes how to select the scheduled reports that you wish to run Select Groups from the toolbar then click Gr
66. t 6 months You can use this report to view your transaction counts and amounts by batch Click on the Location ID hyperlink to see detailed information 2 4 3 Batch Summary Batch Summary Totals Location Batch Sales Sales External pet Sot set Size WED Subtotal for ore ee Code Page Totals usp Grand Total ugo Record 1 to i of 1 Page l af 1 010 06 000120100041 Go To Page 1 Y iler Cunt Aena Y T 5 138 665 35 7 130 66 35 7 130 66 45 7 130 66 EPICOR Payment Exchange FE j A 10 to 08 10 2010 Het Pede Sabia ted Submited Lanes Processed Processed Count Amount Amount 0 00 FL J L K Di YA 7 138 66 5 0 00 7 130 66 i 0 00 35 7 130 66 i a 35 7 130 66 0 o0 35 7 130 60 0 0 35 7 130 66 0 50 35 7 130 66 Page 15 2 5 Monthly Sales History You can view bankcard activity by card type for 13 months from the Monthly Sales History selection on the Sales tab Just select the Card Type from the dropdown and click Submit 2 5 1 Monthly Sales Summary selection window Honthly Sales History Bong Localinm AAA spe Click on the Month hyperlink to view location totals You can use this report to analyze location performance 2 5 2 Monthly Sales Summary selection window Monthly Sales History Location July 2009 to August 2010 Average Grand Total Far Currency USD 68 759 72 5 097 38 5 BT2 34 63 58 fer 08 1 185 13 1 623 62 106 29 15
67. tail 1 SALES HL1100 Reconciliation report i CUSTOM HL1525 Chargeback Exception by Location report 1 FUNDING HL0410 Daily deposit totals al DISPUTES HL1501 Chargeback detail by status date 2 DISPUTES HL1506 Cb percent of sales based on corporate al RATE ANALYSIS HLO104 Qualification expense detail by location date 1 Click on the desired report number hyperlink in the Report ID column 7 4 2 Delete Report Detail screen Delete ReportDetail Corporate Report Number ReportTite Requester Name Run When CreateDate LastRun Click To Delete HL1501 2571928 Chargeback detail by status date Weekly 03 10 2010 08 26 2010 YES HL1501 2907174 Chargeback detail by status date CPLCMJU Daily 08 27 2010 08 27 2010 YES EPICOR Payment Exchange Page 43 In the Click To Delete column click on the YES hyperlink for the desired report 7 4 3 Delete Report Confirmation screen Delete Report Confirmation Click Confirm to complete the report deletion process 7 4 4 Delete Report Verification Message screen Delete Scheduled Reports Delete Scheduled Reports EPICOR Payment Exchange Page 50 8 Groups The Groups selection offers you the opportunity to create unique groups of your locations by selecting the locations of your choice and running scheduled reports based on those unique groups This provides you greater flexibility in managing the overall performance of your portfolio The unique group nam
68. te Submit Date Date the batch was submitted to Merchant Services Submitted Currency Amount Amount of Transaction in the currency which it was submitted Submitted Currency Code 3 digit code and description identifying the currency the transaction was submitted in Terminal ID ID number of the terminal on which the transaction was processed Transaction Amount The amount of the sale or refund Transaction Date Date the transaction occurred Transaction ID Unique 15 digit number assigned to all original purchase transactions Transaction Status Indicates whether transaction was Processed Cancelled or Rejected Transaction Time Time at which the transaction occurred Trans Type Numeric code that identifies the transaction as a sale credit or cash advance 2 1 Credit amp Debit Transactions Select Credit Transactions or Debit Transaction from the submenu and a search window displays Complete the required Date Range fields and other optional fields and click the Submit button Submit EPICOR Payment Exchange Page 11 2 1 1 Search window is the same for Credit Debit Transactions Access All Hierarchies for Lead Corporate DU Ecos vI svse v m Date e Number ID Enter the ID and level for a specific location Date Range Required Field Enter the dates within the last 6 months that you wish to include in the search Date Type Choose either Submit Date or Transaction Date Amount
69. the report click Submit Query If you wish to revise the selections click Clear Screen An example of the Account Summary Report is shown below 6 3 3 Account Summary Report screen Account Summary Report Agent Date 08 01 2010 to 08 02 2010 ype nt Count Count nt 999999999999 USD 08 02 2010 ATM 0000000275800 4 468 99 0 0 00 0 0 00 468 99 999999999999 USD 08 02 2010 ATM 000000027800 5 421 84 0 00 0 00 421 84 999999999999 USD 08 02 2010 VISA 000098020021 21 2 656 33 0 0 00 0 0 00 2 656 33 999999999999 USD 08 02 2010 AMEX 000098020021 5 1 145 05 0 0 00 0 0 00 1 145 05 999999999999 USD 08 02 2010 AMEX 000099020021 1 40 98 0 0 00 0 0 00 40 98 999999999999 USD 08 02 2010 MC 000099020021 3 246 57 D 0 00 0 00 246 57 999999999999 USD 08 01 2010 VISA 000128010023 1 100 00 0 0 00 0 0 00 100 00 999999999999 USD 08 01 2010 MC 000128010023 1 271 44 0 00 0 00 271 44 999999999999 USD 08 02 2010 VISA 000099020021 rj 1 348 81 0 00 0 0 00 1 348 81 999999999999 USD 08 01 2010 MC 000129010023 iL 35 00 0 0 00 0 0 00 35 00 999999999999 USD 08 01 2010 AMEX 000129010023 1 167 63 0 0 00 0 0 00 167 6 999999999999 USD 08 01 2010 VISA 000129010023 2 259 00 1 29 99 0 0 00 229 01 999999999999 USD 08 02 2010 MC 000100020021 2 203 99 0 0 00 0 0 00 203 99 999999999999 USD 08 02 2010 AMEX 000100020021 d 169 97 0 00 0 00 169 97 999999999999 USD 08 02 2010 VISA 000100020021 14 1 770 53 1 29 99 0 0 00 1 740 54 999999999999 USD 08 02 2010 MC 000151020021
70. ubmit Build EPICOR Payment Exchange Page 51 8 1 3 Group Locations selection screen Step Select Locations S 99999999999 CLOSED OPEN OPEN OPEN D I D D I Step n Selected Locations 9999999999 m Double click on locations in Step 3 Select Locations that you wish to include OR click once and then click the button to add the location to the Step 4 Selected Locations section To select all locations click on the button To deselect locations click on the location and then click on the button To deselect all location click on the button Click Submit Build 8 1 4 Add New Report Group Complete screen Add More Locations Add More States Complete Group Build At this screen you may Add More Locations or add locations from a different state click Add More States Click Complete Group Build to complete the process The confirmation window shown below should appear 8 1 5 Group Build Confirmation screen Group Build is Complete Update Group 8 1 6 Group Builder selection screen Group Builder Update Group v Select Update Group from the Action field dropdown Click Submit A listing of the current locations for your report will appear in Step 4 Selected Locations To delete locations from your report use your mouse to highlight the location that needs to be deleted Click on the button If more than one location needs deleted continue to highligh
71. unt The amount of the sale or refund Trans Type Numeric code that identifies the transactions as a sale credit or cash advance Trans Date Date the transaction occurred Status Indicates whether transaction is Active or Cancelled or Rejected Entry Mode Code identifying how the cardholder account information was entered or captured at the point of sale Auth Code Code provided during the authorization process if an authorization approval was received Authorizations Search 6 1 3 Authorization Data Report Authorization Data List Agent Dates 08 01 2010 Through 08 05 2010 Sorted by Date Time Location ID External Merchant ID Currency Code Cardholder Number Expiration Date EM Auth Eats mn nue Response Code 999999999999 USD 8999999 12 12 74 08 03 2010 00 Go To Page 1 lt Tm Last Go to su Y The Authorizations Search gives you a list of authorizations associated with a specific account number authorization code or amount range for up to 6 months Click on the Cardholder Number hyperlink to view the Authorized Transaction detail Chargebacks Search 6 1 4 Chargeback List Chargeback List Agent Status Date Range 08 01 2010 to 08 05 2010 Download Spreadsheet Ed 8 External Currency Chargeback Case Cardholder Trans Chargeback jm 999999999999 USD Not as described or 999999999 99999999999999599999999 999999 07 22 2010 251 41 08 21 2010 08 01 2010 OPEN defective merchandise 999999999999 USD H
72. ur report will end and enter it in the End Date field End Date should only be entered when a Run Now report frequency is selected The Report Delivery Options section contains several key fields You can choose how you wish to view your report from the Select Report Format field Choices in the dropdown include Word for Windows Document Excel 8 0 Comma separated values or Adobe PDF File Reports in CSV will not contain headers as this would cause a failure to load into a database If you intend to save this report to a separate application such as Microsoft Access it is suggested you choose the Delivery option of email and the Report Format option of Microsoft Excel 8 0 or CSV If you wish to compress the report to a smaller file size select Yes from the Zip Option field otherwise choose No Choose either Web Online or E mail from the Select Delivery Option field You will need to determine the maximum file size that your email provider will allow and then specify it in the Select Mailbox Size lt 1MB 1MB 5MB 5MB 10MB 10MB 15MB gt 15MB If you wish to receive an e mail when the report is generated then select Yes from the Notify When Finished field otherwise choose NO If you choose YES an email address must be specified in the E Mail To Address 1 field Select E Mail to Address 2 and E Mail to Address 3 to add other recipients Additional email recipients do not have to be enrolled ClientLine users Not all email fields need to

ClientLine® User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents

ClientLine&reg; User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents

ClientLine® User Manual