The CivicPay Online Settlement List page is used to track and report on settlements and to print payment receipts. The Settlement List page can be accessed via the main menu at the left of the new CPO interface.

Filter the Settlements data

• Use the filter at the top of the page to filter the settlements that display in the data grid below.

• The Start Date and End Date fields are used to filter the settlements displayed on the page by a range of settlement transaction dates.
  • The maximum date range that can be displayed is 31 days.
• Click the Apply button to display the settlements results filtered by the specified date.
• Click the Filters button to open a more extensive set of settlement filters.

• The Payment Type field is used to filter the settlements by individual credit card or ACH payment type.
• The Merchant Activity field is used to filter the settlements by merchant processor.
  • Select Any to include all merchant activity.
  • Select Utility to include only transactions processed through Springbrook Utility Billing.
  • Select PayPad to include only transactions processed through your PayPad terminal.
  • Select Municipal to include only transactions processed as part of the Springbrook Municipal Payments Collection process.
• The Amount fields are used to specify a minimum and maximum payment value in order to filter the displayed settlements by amount.
• The Activity toggles are used to specify the type of payment activity on the settlement.
• The Clear button is used to reset all filters.
• Click the Apply button to filter the settlements according the criteria entered above.
• Once the filtered settlements are displayed, click the Export button to export the filtered settlements in an Excel spreadsheet or a .CSV file.

Investigate the Payment Settlement data

• Once the settlements have been filtered, the date, number of payment settlements, and total amount of those payment settlements will display across the top of the page.
• Use the column headings to sort the displayed payment settlements.
• Click a payment settlement to open the payment detail window.

• The payment detail window will include all the payments details displayed on the Payments List page as well as:
  • Refund Date and Refund Settlement - Refund date and settlement in the event of a refunded payment.
  • SB Lookup - A CivicPay ID generated and assigned by CivicPay and passed as a payment ID number into Springbrook. This number can be found in the cr_reciept.payment_id field in CR QBE or the UB Account History Payment Description field.
  • Bill Amount - Amount applied to citizen's account in Springbrook.
  • Fee Amount - Amount of convenience or service fee charged by the agency.
    • The sum of the UB Amount and Fee Amount is the amount passed to the gateway for processing against the citizen's credit card or checking account.
    • The UB Amount and Fee Amount fields will not display when the payment in question was generated through a PayPad transaction, as indicated in the Merchant Account field.
  • Gateway details:
    • Authorizing Network Response - Coded response from the authorizing network.
    • Payment Settlement Date - Date the payment was funded.
    • AVS Response (credit card payment only) - Single-letter code returned by the card issuer indicating the degree to which the address information provided in the next two fields matches the address information they have on file for the credit card.
    • AVS Address and AVS ZIP (credit card payment only) - Street address and ZIP code the card issuer has on file for the credit card.
    • ACH Return Code (ACH payment only) - Code and explanation indicating the reason an ACH payment was returned.
    • ACH Return Date (ACH payment only) - Date an ACH payment was returned.
    • Submission Source - How the payment was initiated, e.g. keyed, recurring, saved profile.
• The Reverse Payment button will open the Reverse Payment window.
• The Print Receipt button will open a print-friendly version of the receipt that can be printed or saved as a PDF.
• The Email Receipt button allows you to enter an email address where the receipt will be emailed.