What is A Settlement Report?

The Settlement Report provides a detailed .csv of funding activity occurring within a selected time period. This includes transactions that are settled, refunded, chargedback, cancelled, and expired. Settlement reports are typically used by merchant accounting teams for reconciliation purposes.

How is a Daily Balance Calculated?

A daily balance is calculated by: [daily balance = settlements - refunds - chargebacks - fees - negative daily balance from previous day]. A positive daily balance will result in an ACH payment made to your bank account in 0-2 business days. The Settlement Report includes all funding events included in the daily balance calculation.

👍
Good to Know
NOTE: Typically, all settled transactions are funded by Bread Pay on a daily basis. After transactions are settled, funds are expected to appear in your account within 0-2 business days via ACH.

How to Download a Settlement Report?

The settlement report can be accessed under the "Reporting" dropdown in the Bread Pay Merchant Portal. You can download a list of transactions within a 100 day date range with the "Download CSV Report" option.

User Guide

Log into the Merchant Portal
In the left navigation bar, select ‘Settlement Report’

Select a specific date range or one of the preset options on the left side panel.

Select the ‘Download CSV Report’ button and the file will automatically be generated for use.

Settlement Report Column Definitions

Below you will see a list of definitions for the column names you will see in the csv Settlement Report you download.

Column Name	Description
ach_effective_date	The date that funds are deposited in a merchant account
bank_request_date	The date and time when Bread requests funds, based on a merchant’s previous day funding events
funding_event_date	The date of the funding event action taken by a merchant (settlement or refund)
customer_name	The name of the customer associated with the transaction
bread_product	The Bread payment product (e.g. "INSTALLMENTS")
bread_transaction_ID	A unique ID generated for each Bread transaction
merchant_order_ID	An external order ID, sent to Bread in the UPDATE request to Bread's Transaction API
transaction_creation_date	The date the transaction was created
transaction_amount	The total checkout amount of the transaction
funding_event_type	The type of funding event for the transaction (e.g. SETTLE or REFUND)
funding_event_amount	The amount that is settled or refunded. A positive amount indicates that the transaction was settled while a negative amount indicates it was refunded
funding_event_fees	The positive or negative amount of fees associated with the funding event
transaction_fee	Transaction fees associated with the transaction. This value may be 0
total_settled_amount	The total positive or negative settled amount deposited or netted on the ach_effective_date
currency	Currency of the transaction (USD)
bread_merchant_ID	Bread unique ID for a merchant
merchant_name	The merchant name
location_reference_ID	The location ID associated with a merchant. Not all merchants will need a location ID

📘
Note on Refunds
Refunded amounts are netted from daily ACH payments. Funding event fees on refunds are reflected as positive amounts, as Bread will return fees originally netted from settled transactions.

View and download a sample settlement report HERE