Payment reporting
What is a settlement report?
A settlement report is a payment-provider record that helps a business connect a payout or transfer with the payment activity grouped into it. It commonly summarizes transactions and adjustments for a reporting period or settlement batch, giving accounting and operations teams a structured starting point for reconciliation.
Direct answer
It explains how payment activity relates to a settlement
Payment systems may call this a settlement report, payout reconciliation report, transfer detail, deposit report, or another provider-specific name. The purpose is similar: show the records behind an amount moved from the payment platform to a business account or balance.
The report is not always a simple list of sales. Depending on the provider and reporting view, it may include payments, refunds, disputes, adjustments, withheld amounts, provider charges, failed transfers, or activity that remains unsettled at the report cutoff. A business should use the definitions supplied by its provider because labels, signs, grouping rules, and availability are not universal.
Common fields
Read the identifiers before comparing totals
Start with the fields that establish which records belong together, then work through the amounts.
Settlement or payout identifier
A unique reference can connect the report to a transfer shown by the provider and to the matching bank activity. Preserve the original identifier when exporting data or recording an accounting entry.
Reporting dates and cutoff
The transaction date, processing date, settlement date, and transfer date may differ. Confirm which date controls inclusion so a calendar-day sales report is not compared blindly with a settlement batch.
Activity categories
Look for the provider's categories for payments and other activity. A summarized report may group records, while an itemized export can provide individual transaction references for investigation.
Net movement
The total transferred may reflect additions and deductions associated with the batch. Follow the report's own calculation and terminology instead of assuming that gross sales should equal the bank amount.
Reconciliation workflow
Match the report through a repeatable sequence
Confirm the scope
Select the correct business account, location, currency, date range, and settlement identifier. Record the time zone and reporting cutoff when they affect which transactions appear.
Compare the provider totals
Review the opening or starting balance when supplied, activity grouped by category, adjustments, unsettled activity, and the final payout or transfer amount. Use the provider's report definitions to interpret each line.
Match the external record
Find the corresponding bank or accounting entry using the settlement identifier, transfer reference, date, and amount available to your team. Timing differences can place related records on different business dates, so document the reason for a difference rather than forcing unrelated entries to match.
Investigate exceptions
Use an itemized export or transaction view to trace missing, duplicated, reversed, refunded, disputed, or still-pending activity. Escalate unexplained differences through the provider's authenticated support channel without placing cardholder data or credentials in general messages.
Operational controls
Make reports useful without exposing sensitive data
Use consistent exports
Apply the same filters and report type each period. Keep the original file name, generation date, account scope, and settlement reference so reviewers can reproduce the comparison.
Separate summary and detail
Use summary data for routine entries and itemized data for exceptions. This reduces clutter while preserving a trace from an aggregate total back to its underlying records.
Limit access
Give report access only to staff who need it, use individual logins where available, and store exports in an approved business system. Do not copy full card numbers, bank credentials, passwords, or secret API keys into worksheets or support requests.
Keep an exception log
Record the report, affected identifier, observed difference, owner, status, and resolution. Avoid including unnecessary customer or payment details when a provider reference is sufficient.
Practical questions
Settlement report questions
Is a settlement report the same as a sales report?
Usually not. A sales report focuses on sales activity, while a settlement-oriented report explains the provider activity grouped with a payout, transfer, or settled balance. The date range and included records can therefore differ.
Why might the bank amount differ from gross payments?
A provider may group refunds, disputes, adjustments, charges, prior-period activity, or other entries with the settlement. Review the provider's calculation and itemized records before assigning a cause.
Should every settlement report be exported?
Retention needs depend on the business's accounting process and professional guidance. If reports are exported, use consistent filters, protect access, and retain enough context to reproduce the reconciliation.
Related guidance
Build a clearer reporting workflow
Next step
Map one settlement from report to bank record
Choose a completed settlement, preserve its identifier, export the appropriate summary and itemized views, and document how the provider total connects to the corresponding business record.
To learn more about how TSYS can help improve the way your organization accepts payments, markets to new customers, or manages its HR responsibilities, get in touch by calling 585-981-8463 to get started.
CONTACT US