TSYS Settlement Report GuideLast updated on 09/09/2022
The TSYS Settlement Report provides a list of all of the deposits from TSYS for credit card transactions, and includes details of each transaction within a deposit. This report can show batches up until the previous day.
Use the TSYS Settlement Report to reconcile deposits from TSYS with corresponding credit card payments.
Create a TSYS Settlement report
Follow the steps to create a custom report based on the TSYS Settlement template.
The TSYS Settlement report template has the following columns selected by default:
Batch Date—Date the batch was created
Batch Number—Batch number assigned by TSYS
Net Deposit—Total deposit amount of all transactions in this batch Note: This amount does not take into account any holds. The actual deposit amount may be different if TSYS places a hold on the batch deposit.
Number of Debits—Number of debit transactions in this batch
Amount of Debits—Total of all debit transactions in this batch
Number of Credits—Number of credit transactions in this batch
Amount of Credits—Total of all credit transactions in this batch
Deposit Amount—Total amount that was deposited
Deposit Date—Date of the deposit
Hold Amount—Amount that the processor is holding and has not yet paid out
Run the TSYS Settlement report
Click the From - To field to set date filters. You can:
Use the calendar to select a specific date range and click Apply.
Use the left menu to select a preset date range:
Today: From 12:00 AM to the current time
Yesterday: Previous day, from 12:00 AM to 11:59 PM
Last 7 Days: Previous seven days, including the current date
Last 14 Days: Previous 14 days, including the current date
Last 30 Days: Previous 30 days, including the current date
Month to Date: From the first of the current month to the current day
Last Month: Entire month before the current month. For example, if the date is February 5, the entire month of January.
Last 90 Days: Previous 90 days, including the current date
This Quarter: Current quarter, including future dates. For example, if the date is April 25, from April 1 - June 30.
Last Quarter: Entire quarter before the current quarter. For example, if the date is April 25, from January 1 - March 31.
Quarter to Date: From the first day of the current quarter to the current day
Year to Date: From January 1 of the current year to the current day
Last 365 Days: Previous 365 days, including the current date
Enter a batch number to look for a particular batch, or leave blank to include all transactions for your date range.
Click Run Report. The TSYS Settlement report generates.
Read report results
Your report results display in a table based on the filters you set. By default, the Credit Card Transaction report includes the following columns:
Date the batch was created
Batch number assigned by TSYS
Total number of all transactions in this batch This amount does not take into account any holds. The actual deposit amount may be different if TSYS places a hold on the batch deposit.
Number of Debits
Number of debit transactions (such as refunds) in this batch
Amount of Debits
Total of all debit transactions in this batch
Number of Credits
Number of credit transactions (charges) in this batch
Amount of Credits
Total amount of all credit transactions in this batch
Total amount of the deposit
Date of the deposit
Amount that the processor is holding on to and has not yet paid out
View all transactions in a batch
To see each of the transactions in a batch, click a cell in the Batch Number column, and then click the arrow.
Batch transaction columns include
Date of the transaction
Code of the transaction
Amount of the transaction
Authorization code of the transaction
Transaction reference number
The authorization amount of the payment
Whether or not the payment was voided
Invoice number associated with the payment
Payment Batch Number
Batch number of the payment
Name of the customer. This field is linked with the customer's profile in ServiceTitan.
Name of the technician who processed the credit card transaction.
Note: Technician names only appear for credit card transactions made after May 18, 2020.
Customize your report
You can add and remove columns related to TSYS settlements for more specialized reporting. For further customization, you can also arrange and filter your results to narrow the focus of your report.
Above the report results, click Edit Columns.
In Edit Columns, select or deselect the items you want added to or removed from your report. Hover over a field to view a description of that column.
You can edit the TSYS Settlement report to show the following fields:
Merchant ID—Merchant ID associated with this settlement
TSYS Settlement Report FAQ
Does the TSYS Settlement report include the customer’s name for negative payments?
No. Since ServiceTitan does not create the refund payment item, there is no way to match it to a customer's name.
What is the date filter logic of the TSYS Settlement report?
The TSYS Settlement report is based on the batch date, so any batch which falls in the report date range is included in the report.
When do batch or settlement files appear in my report?
TSYS uploads batch files into ServiceTitan reports on Tuesday, Wednesday, Thursday, Friday, and Saturday. You will not receive settlement reports on Sunday or on Monday.
Transactions made on Fridays before the cut-off time will be included in the batch on Saturday.
Transactions made on Fridays after the cut-off time will go in the batch on Tuesday.
Batch files are uploaded in the early morning, however on Tuesdays and on holidays when batch files are bigger there may be a delay and you may want to run your reports later in the day..
Why are transactions missing from a batch?
If the transaction is processed after the batch cut-off time for that day, it is excluded from that day’s batch and will be batched the following day.. You can check the batch for the next day and you will see it.
Note: For more information, see the previous question about the settlement days.
What defines a debit in the TSYS Settlement report?
In the TSYS Settlement report debit is a number of positive payments. If money is refunded to your account, it will be in the Credits column. The net deposit is the difference between the two.
Can we add checks or ACH payments in the TSYS Settlement report?
No you can’t add checks or ACH payments in the TSYS Settlement report. It is recommended to use the ProfitStars Settlement report template.
Does this report show each transaction or only the batch information?
If you go to the values in the report, you can find detailed information about the transactions.
For more information, see Drill down in reports.
Note: To see a detailed view of transactions, you can use a report built with the Credit Card Transaction report template.
Want to learn more?
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.
Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.