Service Titan Knowledge Base

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

  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.


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:

Report column
Description

Batch Date

Date the batch was created

Batch Number

Batch number assigned by TSYS

Net Deposit

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

Deposit Amount

Total amount of the deposit

Deposit Date

Date of the deposit

Hold Amount

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

Report column
Description

Transaction Date

Date of the transaction

Transaction Code

Code of the transaction

Amount

Amount of the transaction

Authorization Code

Authorization code of the transaction

Transaction Reference

Transaction reference number

Auth Amount

The authorization amount of the payment

Voided

Whether or not the payment was voided

Invoice

Invoice number associated with the payment

Payment Batch Number

Batch number of the payment

Customer

Name of the customer. This field is linked with the customer's profile in ServiceTitan.

Technician Name

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.

  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


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.

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.




Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.