Description: Learn general high-level information about the Settlement report.

The Settlement Report provides a comprehensive overview of batch details and a tool for reconciling daily payouts.

It provides a comprehensive, detailed overview of the batches that make up each payout, giving you a clear view of your transactions as they move from a sale to a deposit in your bank account.

  1. Select Reporting from the left side navigation menu.
  2. Select Reports.
  3. Select Settlement in the Financial Reports section.
    S4D_SettlementReport_1.jpg
  4. Select the filters along the top for the desired time Period.
    S4D_SettlementReport_Period_2.jpg
    Note: The message "There is no data for the selected location and time period combination" will appear if there are no entries for the selected Period.
  5. Review the report with an option to download if preferred.
    S4D_SettlementReport_DownloadOption_3.jpg
    S4D_Settlement_SampleReport_4.jpg

For an in-depth guide on Online Payments Reporting, view the Online Payments Reporting Guide. 

Parameter Options: 

  • Period Selection: To view data for a specific time, either select a single date or define a date range for the report.

Export and Delivery

After the report is generated, you can:

  • Download: Export your report as a CSV or Excel format.
  • Subscribe: Set up a recurring email delivery to receive the report automatically to your email.
  • For Enterprise merchants only: Subscribe to receive the file in an SFTP location. Additional configuration is required for this option. Please contact your Enterprise Account Manager to help you set it up.
    Note: For details about the CSV extract format and field specifications, visit the Settlement Report CSV Extract Specification.

Key Features

  • Financial Overview: Gain visibility into your batches with a summary of gross and net totals. See every batch status from batched to settled, refunded, charged back, and payout.
  • Batched Transactions: Transactions that were sent to settlement and are pending settlement, indicated by a gray row labeled "batched."
  • Card Brand Breakdown: Use the Card Brand toggle to view transaction types broken down by card brand, such as Visa, Mastercard, and Amex. 
    For EU: if the card brand field is empty, the payment was processed through a digital wallet (Alipay+).

Data Overview

The report is organized into several columns, each representing key data elements:

Merchant ID A unique ID associated with the merchant processing
account
Merchant Name Name of the Merchant
Parent Name Name of the Parent on the MID
Country The country where the transaction occurred. Countries are represented by either a two-letter or three-letter code, such as US or CAN.
Batch Number Unique identifier of a batch.
Batch Closed Date Date indicating when the transactions were processed for settlement. For the "Batched" transaction type, the date shown is the date transactions were captured.
Payout Date Date indicating when the transactions were paid out by the processor. There might be 1-3 days delay from this date to the date funds are showing in the bank account due to weekends and holidays.
Transaction Type
  • Settled: transactions successfully processed and completed.
  • Refund: transactions where funds are returned to a customer.
  • Reject: transactions not approved or processed.
  • Adjustment: an amount (debited or credited) to a merchant's balance to modify it.
  • Chargeback: transactions reversed due to a customer dispute.
  • Payout: transferred funds
  • Batched: total transactions and amounts identified in the initial batch that was sent for settlement and may differ from the payout once settlement is finalized.
  • Reversal (EU transactions): Transactions that were previously approved but are subsequently reversed.
  • Service Fee (EU transactions): fees charged for different services provided by Shift4 (e.g., wire transfer fee). This transaction type is applied at the acquiring contract level, not per Merchant ID. Please add it to all relevant MIDs payout amounts to finalize your deposit total.
  • Reserves (EU transactions): The amounts deducted and released from the merchant’s collateral. This transaction type is applied at the acquiring contract level, not per Merchant ID. Please add it to all relevant MIDs payout amounts to finalize your deposit total.
Deposit Currency The currency in which the payout was deposited.
Gross Amount Total of all sales transactions reported in a period without any deductions.
Bank Fees Total amount deducted from the merchant for services provided. E.g., terminal fees, card fees, etc.
Net Amount Total of all sales transactions reported in a period after any deductions have been removed.
Transaction Count Number of transactions.

How to Reconcile Your Report

For a detailed, step-by-step guide on how to reconcile settlement, please see our Settlement Report Reconciliation Guide article.