Deposit

A deposit query provides summary information related to a merchant’s deposit, and includes the ability to drill down to access transaction detail.

To run a deposit query:

1. Click the Research Query navigation button.

   

   The Research Query page opens.

   

2. Select the Deposit option.

   The page refreshes to list the appropriate fields.

3. Enter your query criteria.

   Note: Fields marked with a red asterisk (*) are mandatory.

   • Post Start Date: Click the Calendar icon and select the appropriate date.
   • Post End Date: Click the Calendar icon and select the appropriate date. This field is not required; however, if you do not enter a date, the system will populate the same date as entered in the start date field.
   • Bank Number: If you have more than one bank number, select the appropriate bank number from the drop down list.
   • Merchant Number: Type the 15-digit merchant ID number or click Search to perform a merchant lookup.

     Note: The merchant names and numbers displayed in the Merchant Lookup scroll box are dependent upon your user role and profile.

   • Amount: From and To: Type the amount range for the deposits.
4. Click Generate Report.

   The Deposit Query page opens

   The Deposit Query page list information in these sections:

   • Deposit Search Criteria: post start date, post end date, amount from, and amount to.
   • Merchant Detail Section: merchant number, merchant DBA name, merchant DBA city, and merchant DBA state.
   • Deposit Listing: deposit date, deposit amount, and reference number.
5. Click the Reference Number to open the Deposit Details page.

   The Deposit Details page lists information in these sections:

   • Deposit Summary: merchant number, merchant DBA name, merchant DBA city, merchant DBA state, reference number, deposit amount, and deposit date.
   • Deposit Listing: transaction date, transaction amount, transaction id, submitted as, downgrade reason code, downgrade to, cardholder number, and card expiration date.
6. Click the Transaction ID link to open the Deposit transaction detail page.

   The Deposit transaction detail page list information in these sections:

   • Transaction: transaction date, transaction amount, transaction id, submitted as, downgrade reason code, downgrade to, cardholder number, and card expiration date.
   • Transaction Listing: RPS, AU1, auth date, term entry, total auth, TID/BNR, id method, ref number, merchant DBA name, AC1, AU2, merchant DBA state, Qual, validation code, merchant DBA zip, auth amount, merchant DBA city, MCC, auth response, merchant DBA country, MOTO, incoming trans code.
   • Vital Downgrades: No, P&V code, RPS bump code, and reason.
   • Associate Downgrades: downgrade code and reason.
7. Click Report Summary to open the Deposit transaction report summary page.

   The Deposit transaction report summary page displays the following read-only information in four sections:

   • Merchant Information: merchant number, merchant DBA name, address 1 and address 2, merchant DBA city, merchant DBA state, merchant DBA zip, merchant DBA country, and downgrade reason code.
   • View Authorization, Capture, Clearing and Settlement: element and value.
   • View Qualification Guide Interchange: fields, P&V value, and guide value.
   • View P & V Details: additional clearing and settlement data for a transaction.

     Note: The proof and verification details only appear when you click the View P&V Report button.

8. Click View P and V Report to open the P and V report page.
9. On any query report page, change the criteria as required.
   1. On any query report page, click Search or Re-search.

      

      The query search page opens with fields populated with the last criteria entered.

   2. Enter your new criteria, and then click Generate Report.

      The query report page opens listing information based on the new criteria you entered.

10. On any query report page, export the data to Excel or PDF as required.

    On any report page, click Printer Friendly.

    Adobe Reader opens with a PDF version of the report in view.

    

    Use the Adobe Reader functionality to navigate, print, and save the PDF version of the report.

    You can export query report data into a spreadsheet format using Microsoft® Excel.

    To do this, on any query report page, click Excel.