Contact Us

  • Contact Us
  • Home
  • Administrators
  • How to view Admin Reports

Settlement Report

Written by Jeanne Murphy

Updated at December 2nd, 2024

Contact Us

  • Administrators
    Admin Setup How to manage Admin and CSR users How to Upload Account and Bill Files How to view Admin Reports
  • Customer Service Representatives
    CSR Setup How to review payer information How to manage payer accounts How to send a one-time payment link to an unenrolled payer How to make a payment to a customer account How to cancel and refund payments How to set up and cancel recurring payments How to edit invoices How to add, edit or delete a payment category How to add or edit an account balance
+ More

This report summarizes the total number of successful and failed transactions during a timeframe.

The report is different from the Payment History Report or the Support screen in that it tracks only transactions that are ready to be sent to a Gateway in the next batch cycle or transactions that have been sent to a Gateway.

This report does not show:

  • Transactions that were cancelled by the Payer or the CSR.
  • Any future-dated transactions.

The main benefit of the Settlement Report is that it provides a concise view of all transactions and can be used to determine exactly which transactions have been sent to the Gateways.

The Settlement Report Summary shows a summary of all ACH Transactions and a summary of all Credit Card Transactions.

Type Description
Debits Total debit transactions and total amounts. Each payment is counted as a debit.
Credits Total credit transactions and total amounts. Each reversal is counted as a Credit.
Cleared Number of transactions that have been cleared.
Errors Number of transactions that have resulted in a Return.

 

Go to the Reports page and choose Settlement Report. Enter your Start Date and End Date and click Run Report.

Click Report Details to produce a detailed view of each transaction. 

To see more detail for a specific transaction, click anywhere on the transaction’s row.

For each payment the report lists:

Data Description
Transaction ID Unique ID assigned to the payment by DirectBiller
Status

A status of Failed indicates that the Gateway has sent a Return record. The Failed status is only used for ACH transactions.

For Credit Card transactions, failure is detected at the time the payer enters the transaction, and failed Credit Card transactions are never settled with the Gateway.

Note: The Status Codes used here are different from the Status Codes that are displayed to the Payer and the CSR. The Status Codes used here track the payment status from the perspective of the Gateways.

Entry Date Date the payer entered the payment.
Effective Date Date the payment was effective as assigned by the Gateway.
Type

Debit for payments sent for processing by the Gateway.

Credit for reversals sent to the Gateway.

Amount Amount of the payment.
Settle Date

Date the payment is set to Processed by DirectBiller.

For Credit Card payments this is the same date the payment was entered by the user, or the next day if the payment was entered after the daily cutoff.

For ACH payments this is 2 business days after the payment was sent for processing because DirectBiller continues to check the ACH system for possible returns.

Gateway Name of the Gateway that processes the payment

Note: The Settlement Report does not display any Pass-Through fields or invoice- related information, since this information is not sent to the Gateways.

summary resolution

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Aging Report
  • Card Expiration Report
  • Payment History Report
Expand