---
title: Payments Report
description: The Payments report is a Sales report that displays all payment data for all tender types. This report is useful for finding a transaction for a guest if all you have is the last 4 of their credit card, or the last name of the card holder. You can also use this report to see the payment history of a specific check if you already have the check ID
---

[Skip to content](https://helpdesk.tray.sa/en/payments-report#main-content)

- [English](https://helpdesk.tray.sa/en/payments-report)
- [العربية](https://helpdesk.tray.sa/ar/تقرير-المدفوعات)

English

Show submenu for translations

![TRAY logo - powered etc.. 4](https://helpdesk.tray.sa/hs-fs/hubfs/TRAY%20logo%20-%20powered%20etc..%204.png?width=92&height=48&name=TRAY%20logo%20-%20powered%20etc..%204.png)

Open main navigation

Close main navigation

- - [English](https://helpdesk.tray.sa/en/payments-report)
    - [العربية](https://helpdesk.tray.sa/ar/تقرير-المدفوعات)

  English
  
  Show submenu for translations
- Contact us

 Contact us

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Desk](https://helpdesk.tray.sa/en?hsLang=en)
2. [Reports](https://helpdesk.tray.sa/en/reports?hsLang=en)
3. [Sales Reports](https://helpdesk.tray.sa/en/reports?hsLang=en#sales-reports)

April 24, 2025

# Payments Report

The **Payments** report is a **Sales** report that displays all payment data for all tender types. This report is useful for finding a transaction for a guest if all you have is the last 4 of their credit card, or the last name of the card holder. You can also use this report to see the payment history of a specific check if you already have the check ID

 

This report can be exported to CSV, Excel and PDF

 

**HQ Reports**

On TRAY HQ, select the **REPORTS** tab across the top menu. From there select the **Reporting Category Selector** and from the **Sales** reports select the **Payments** report

![Screen\_Shot\_2022-04-13\_at\_4.50.33\_PM.png](https://trayhelpdesk.zendesk.com/hc/article_attachments/5558686972820/Screen_Shot_2022-04-13_at_4.50.33_PM.png)

**Payments report filter options**

| **FIELD** | **DESCRIPTION** |
| --- | --- |
| **PERIOD** | Specify the time period you want to report on |
| **SITES** | Filter the report by site or group |
| **SERVICE** | Filter the report by service for the selected sites \- If multiple sites are selected, each value will be prefaced by the site name |
| **STAFF** | Filter the report by a specific staff member \- If multiple sites are selected, each value will be prefaced by the site name |
| **TENDER TYPE** | Filter the report by a specific tender type \- If multiple sites are selected, each custom tender will be prefaced by the site name |
| **CARD TYPE** | Filter the report by a specific Credit Card network |
| **DRAWER** | Filter the report by the cash drawer. This only shows values if cash drawers are configured for the site. If not, you should filter by terminal or staff \- If multiple sites are selected, each value will be prefaced by the site name |
| **SEARCH** | Filter the report by the last 4 of a specific credit card or the last name of the credit card holder (not the guest) This will show all transactions by that credit card or a guest with that last name in the period specified |
| **STATUS** | Filter the report by the following payments status. The ones that are underlined are the default statuses - **Authorized - **Any active Credit Card authorizations that have not yet been captured - **Captured - **Any CC payment that has successfully been captured - **Captured Deposit -** Payment taken day of an event - **Cash Collected - **All Cash payments - **Client Processed Declined - **All declines from 3rd party Client payment platforms such as Freedom Pay, Merchant Link, Etc. - **Declined - **All declines from server integrated payment platforms such as Magensa, Auth. Net - **Gift Card Deposit - **Any payments taken for gift card issuances. Gift card are not recorded as a sale until the redemption of the gift card occurs. - **HQ Credit Card Refund **- Payments refunded from TRAY HQ (No longer possible) - **Refunded - **Accounts for any refunded payments from any tender type - **Reservation Deposit - **Initial payment taken for an event - **Tip Adjustment - ** Accounts for any tips that have been adjusted after the payment was originally captured - **Voided - **Accounts for any payments that have been voided |
| **CHECK ID** | Filter for a specific check ID  |

![Screen\_Shot\_2022-04-13\_at\_6.17.15\_PM.png](https://trayhelpdesk.zendesk.com/hc/article_attachments/5560504120980/Screen_Shot_2022-04-13_at_6.17.15_PM.png)

**Payments report fields**

| **FIELD** | **DESCRIPTIONS** |
| --- | --- |
| **DATE/TIME** | The date/time the payment was taken |
| **SITE** | The site associated with the payment |
| **TAB ID/TERMINAL** | The check ID that the payment is associated with |
| **STAFF NAME** | The staff member who took the payment |
| **NAME** | The name of the credit card holder  |
| **TYPE** | The tender type of the payment |
| **CARD TYPE** | The credit card brand |
| **ENDING IN** | The last 4 digits of the credit card |
| **COMMENT** | This field only displays if the tender type is set to "allow comment" |
| **BASE** | The subtotal of the payment |
| **TAX** | The tax collected on the payment |
| **TIP** | The tip amount collected on the payment |
| **TOTAL** | Base + Tax + Tip |
| **STATUS** | Shows the applicable status of the payment that the report is filtered by |
| **ACTIONS** | Legacy field |

 

**Credit Card Details**

**![Screen\_Shot\_2022-04-15\_at\_11.41.51\_AM.png](https://trayhelpdesk.zendesk.com/hc/article_attachments/5603661244052/Screen_Shot_2022-04-15_at_11.41.51_AM.png)**

The last 4 of the credit card on a credit card payment is a hyperlink that will take you to the details of that credit card payment. By clicking on that link you will access the Credit Card Details screen. From here you can see specific information about the authorization and capture of that payment, including transaction ID's from the payment processor, as well as any error messages from the processor. ![Screen\_Shot\_2022-04-15\_at\_11.39.01\_AM.png](https://trayhelpdesk.zendesk.com/hc/article_attachments/5603657679252/Screen_Shot_2022-04-15_at_11.39.01_AM.png)

- [HQ - Sites](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#main-content)

    - [Menus](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#menus)
    - [Revenue Centers](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#revenue-centers)
    - [People](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#people)
    - [Payments](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#payments)
    - [Cash Management](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#cash-management)
    - [Discounts](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#discounts)
    - [Hardware](https://helpdesk.tray.sa/en/hq-sites?hsLang=en#hardware)
- [Offline Mode Functionality](https://helpdesk.tray.sa/en/offline-mode-functionality?hsLang=en#main-content)

    - [Offline Mode](https://helpdesk.tray.sa/en/offline-mode-functionality?hsLang=en#offline-mode)
- [Getting started](https://helpdesk.tray.sa/en/getting-started?hsLang=en#main-content)

    - [Start Guides](https://helpdesk.tray.sa/en/getting-started?hsLang=en#start-guides)
- [POS](https://helpdesk.tray.sa/en/pos?hsLang=en#main-content)

    - [TRAY POS](https://helpdesk.tray.sa/en/pos?hsLang=en#tray-pos)
- [Reports](https://helpdesk.tray.sa/en/reports?hsLang=en#main-content)

    - [Sales Reports](https://helpdesk.tray.sa/en/reports?hsLang=en#sales-reports)
    - [Orders Reports](https://helpdesk.tray.sa/en/reports?hsLang=en#orders-reports)
    - [Labor Reports](https://helpdesk.tray.sa/en/reports?hsLang=en#labor-reports)
    - [Cash Reports](https://helpdesk.tray.sa/en/reports?hsLang=en#cash-reports)
- [API Documentation](https://helpdesk.tray.sa/en/api-documentation?hsLang=en#main-content)

    - [5.10 API Documentation](https://helpdesk.tray.sa/en/api-documentation?hsLang=en#5-10-api-documentation)
- [Release Notes](https://helpdesk.tray.sa/en/release-notes?hsLang=en#main-content)

    - [Release Notes](https://helpdesk.tray.sa/en/release-notes?hsLang=en#release-notes)

[![TRAY logo - powered etc.. 4-2](https://helpdesk.tray.sa/hs-fs/hubfs/TRAY%20logo%20-%20powered%20etc..%204-2.png?width=92&height=48&name=TRAY%20logo%20-%20powered%20etc..%204-2.png "TRAY logo - powered etc.. 4-2")](https://tray.sa)

Riyadh - Al-Sulaimania District, Eng. Musa'ed Al-Angari Street, Building No. 7965

TRAY © 2024. All Rights Reserved.