SkyTab Lighthouse Business Manager Settlement Detail Report

Description: Learn how to access a Settlement Details Report and the details of settled transactions. 

---

By using this report, you can:

• Verify individual transaction amounts.
• Understand the associated fees for each transaction.
• Track refunds and chargebacks.
• Perform detailed, transaction-level reconciliation to ensure your batches are correct.

Parameter Options: 

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

How to Access the Report: 

1. Log in to Lighthouse Business Manager.
2. Select Reporting from the left side menu.
3. From the dropdown options, select Processing.
4. Search for “Settlement Detail”.

Accessibility:

• Once generated, you can download the report in various formats (e.g., CSV, Excel, PDF) or subscribe to receive it directly to your email at your preferred frequency. 

Report Fields: 

Field	Description
Merchant ID	A unique ID associated with the merchant’s processing account.
Merchant Name	Name of the Merchant
Parent Name	Name of the Parent on the MID
Card Number	Masked version of the customer's card number
Merchant Reference	A unique custom reference number
Transaction ID	A unique transaction ID number
Card Brand	Name of the card network (e.g Visa, Mastercard, American Express)
Batch Number	A unique identifier of a batch that was settled.
Date	Transaction date
Payout Date	Date when the transaction payout was paid by the payment processor. Please note that funds may take 1-3 additional business days to appear in your 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. Chargeback: transactions reversed due to a customer dispute Adjustment: an amount (debited or credited) to a merchant's balance to modify it. Payout: transferred funds Service Fee (EU transactions): fees charged for different services provided by Shift4 (e.g., wire transfer fee). Reversal (EU transactions): Transactions that were previously approved but are subsequently reversed.
Order Type	The type of the order including Sale and Refund.
Country	The two-letter code representing the country where the transaction originated.
Currency	The currency used for the payment.
Gross	Total of all sales transactions reported in a period without any deductions split by debit and credit.
Fees	Itemized fees deducted from each transaction, including the card brand, interchange, and processor fee.
Total	The final amount of the transaction after all applicable deductions have been applied.