Skip to main content

How do I use the Payment Transactions report?

Become an expert on the Payment Transactions - Local Time report!

Helen Kang avatar
Written by Helen Kang
Updated over 2 weeks ago

The Payment Transactions report surfaces information on all successful purchase/refund transactions.

This report is available in:

  • Local Time

  • Coordinated Universal Time (UTC)

This report is useful for:

  • Investigating specific payment transactions (for situations like fraud cases).

  • Filtering transactions by payment type, cash, or specific credit cards when exported.

  • Viewing a cash report by exporting the data and filtering for “Cash” under the Source Type and/or Payment Label.

  • Viewing an account balance report by exporting the data and filtering for “Account Balance” under the Source Type and/or Payment Label.

  • Locating specific walk-in transactions by exporting the data and filtering for blanks in customer information columns.

Payment Transactions Reports vs. Orders Report:

  • Refer to the Orders Report if you'd like specific details on the items purchased in an order.

  • Refer to the Payment Transactions Report for specific details on how the order was paid for.

Pulling up the Report

  1. Navigate to Reports from the left panel > Finance > Payment Transactions - Local Time or UTC > View.

  2. Specify the time frame from the date picker.

The report shows transaction events within the selected date range. Each action, like a purchase or refund, appears if it occurred during that range.

Apply any additional filters.

Understanding the Report

The Payment Transactions report includes:

If an order is refunded, you'll see the order number twice (one row specifically for when the initial payment was made and another row for the refunded order).

For partial refunds, you'll see a new row each time an item in the order is refunded.

  1. Transaction Date:

    1. Date based on the studio's configured time zone

    2. Date recorded in UTC

  2. Transaction Time:

    1. Time based on the studio's configured time zone

    2. Date recorded in UTC

  3. Transaction Type

    1. Capture: When a credit card transaction is successfully processed.

    2. Refund: When a transaction is refunded.

  4. Amount: The Amount processed for the specific transaction.

  5. Stripe Fee: Stripe fees are processed on Captures.

    1. *Note: Fees are not applied on refunds and $0 charges.

  6. Net Amount = Amount (column 4) - Stripe Fee (column 5).

  7. Payment Type: How the transaction was paid for.

    1. Type of credit card (Visa, Discover, Mastercard, American Express)

    2. Cash

    3. No charge: Transaction processed for $0

    4. Account Balance - Cash: Account balance with deferred revenue assigned

    5. Account Balance - Complimentary: Account balance given complimentary by the studio

    6. Account Balance - Migration: Account balance migrated to a customer's account upon platform migration

  8. Payment Label: Last 4 digits of the credit card used for the transaction.

  9. Order Number: Generated by the system.

  10. Order Currency

  11. Order Tax

  12. Order Total without Tax

  13. Order Total

  14. Order Status:

    1. Completed

    2. Refunded

    3. Partially refunded

  15. Order Date: Date when the order was placed.

  16. Order Time: Time when the order was placed.

    1. *Note: Order Date and Order Time (columns 13 & 14) may be different than Transaction Date and Transaction Time (columns 1 & 2).

      1. Scenario 1: Deferred orders

        1. For memberships that are set to bill at a later time (whether on a specific date or upon activation), the order information will display when the membership was processed through the POS (for the initial $0 charge) and the transaction information will display when the payment was processed by the system on the specified start date or upon activation

      2. Scenario 2: Refunds processed after the initial transaction

  17. Device Type

    • Tablet

    • Mobile

    • Desktop

    • Blank: IOS or Android App

  18. Order Processed by System?

    1. True: All automatic charges (recurring memberships, no-show penalty fee, late cancel penalty fee) or a "bill on start" membership

    2. False: All other sales made by employees in the POS or by customers from the website/app

    3. First-time membership payment will render FALSE, and all subsequent payments will be TRUE

  19. Customer ID

    1. If blank, the transaction was processed as a walk-in

  20. Customer Email

    1. If blank, the transaction was processed as a walk-in

  21. Customer Name

    1. If blank, the transaction was processed as a walk-in

  22. Stripe ID: ID used to compare a specific transaction from the Mariana Tek Transaction report and the Stripe Payment Transactions report.

  23. Stripe Payout ID: The ID generated upon a Stripe payout (deposit).

  24. Stripe Payout Status

  25. Stripe Payout Created: When the payout was initiated.

    1. Click here to determine your payout schedule.

  26. Broker ID: ID of the person who processed the transaction.

    1. If this information is different than the Customer ID, the broker is an employee

      1. All employees have two IDs: one for their employee account and one for their customer account. The ID displayed will always be pulled from their Customer ID

    2. If the order was processed by the system (column 16), the Broker ID will always display the customer's information

  27. Broker Email: Email of the person who processed the transaction.

  28. Broker Name: Name of the person who processed the transaction.

  29. Fulfillment Location

  30. Fulfillment Region: Dependent on Fulfillment Location.

  31. Purchase Location

    1. In-Store: Processed through the POS

    2. E-Commerce: Processed through the web app or mobile app

  32. Payment Gateway: Associated with Fulfillment Location

Reconcile your Bank Accounts

Did this answer your question?