How to Match TSYS Payment Batches to QuickBooks Online Deposits

Problem

You are having issues reconciling TSYS batches to QuickBooks Online and bank deposits.

Solution

1. Go to the navigation bar and click Reports.

2. Enter "TSYS" in the search bar at the top and press Enter.

3. Select the TSYS Settlement report.

4. Select the date range or TSYS batch you want to review and click Run Report.

5. The report that appears include the following columns:        

   1. Batch Date: Date of the TSYS batch

   2. Batch Number: Batch number assigned by TSYS. This is NOT your export batch number.

   3. Net Deposit: Amount to match to your bank deposit

   4. Number of Debits: Number of payments you received in this batch

   5. Amount of Debits: Sum of the payments you received in this batch

   6. Number of Credits: Number of refunds you issued in this batch

   7. Amount of Credits: Sum of the refunds you issued in this batch

   8. Deposit Date: Date the money is deposited in your bank account.

   9. Hold Amount: Amount the processor is holding on to and has not paid you yet.

6. Double-click on a batch number to show a list of all transactions that makes up the Net Deposit amount.

7. From here you can find:        

   1. The amount of each payment or refund in the deposit total

   2. A link to each invoice on which the payments were taken

   3. A link to which ServiceTitan batch (Payment Batch Number) the payments are located

8. Use this list of transactions to create deposits in QBO that match up to the deposits showing in the QBO bank feed.

9. You can also use the list of transactions to reconcile invoices from ServiceTitan to QBO.