TSYS Settlement Report GuideLast updated on 09/09/2022

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

1. 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

2. Enter a batch number to look for a particular batch, or leave blank to include all transactions for your date range.

3. Click Run Report. The TSYS Settlement report generates.

Your report results display in a table based on the filters you set. By default, the Credit Card Transaction report includes the following columns:

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

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.

1. Above the report results, click Edit Columns.

2. 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

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.

Note:

• 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.

• See Guide to ServiceTitan payments auto-batching

• See Schedule reports

• See Reports FAQ