TSYS/Elavon Settlement report

Overview

The TSYS/Elavon Settlement Report provides a list of all of the deposits from TSYS or Elavon 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/Elavon Settlement Report to reconcile deposits from TSYS or Elavon with corresponding credit card payments.

Note: The name of this settlement report depends on your credit card processor. For example, if you use TSYS to process your credit card transactions, the name of the report template will be TSYS Settlement.

Who uses this feature

Administrators and office employees

Things to know

You may receive two separate batches for TSYS card transactions, separated by the processor’s internal classification: the e-commerce classification (not limited to online payments) and the retail classification.

Create a TSYS/Elavon Settlement report

Follow the steps to create a custom report based on the TSYS/Elavon Settlement template.

The TSYS/Elavon Settlement report template has the following columns selected by default:

Batch Date: Date the batch was created
Batch Number: Batch number assigned by TSYS or Elavon
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 or Elavon 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/Elavon Settlement report

Click the From - To field to set date filters. You can:
- Use the calendar to select a specific date range and then 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.
  - This Week: From Monday through Sunday of the current week.
  - Week to Date: From Monday through the current date of the current week.
  - Last 7 Days: Previous seven days, including today.
  - Last 14 Days: Previous 14 days, including today.
  - Last 30 Days: Previous 30 days, including today.
  - 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 today.
  - 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 today.
  - Last Year: From January 1 of the previous year to December 31.
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/Elavon 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/Elavon settlements for more specialized reporting. For further customization, you can also arrange and filter your report 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/Elavon Settlement report to show the following fields:
1. Merchant ID: Merchant ID associated with this settlement

FAQ

Does the TSYS/Elavon 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/Elavon Settlement report?

The TSYS/Elavon 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/Elavon 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/Elavon Settlement report?

In the TSYS/Elavon 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/Elavon Settlement report?

No you can’t add checks or ACH payments in the TSYS/Elavon 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?