View and manage all of your Thinkific Payment transactions from the Transaction Report. You can quickly find what you’re looking for and take action in one dedicated place.
The Transaction Report is only available for payments processed through Thinkific Payments. All Stripe and PayPal transactions are available on the Orders Report.
In this article:
About This Feature
The TCommerce Transaction Report makes tracking successful payments, failed payments, refunds and chargebacks a breeze. It provides an easy way to view and manage Thinkific Payments transactions separate from the Orders Report and offers enriched data of students' purchases to help track your tax liability. You can quickly find what you’re looking for and manage admin tasks like refunds from a single place.
The Transaction Report includes:
- Date filtering
- Prouct filtering
- Column customization
- Failed payments, refunds and chargebacks
- Detailed fee breakdown
How It Works
The Transaction Report is available under the Sales menu of your Thinkific Admin Dashboard if you are using Thinkific Payments. The report provides a detailed breakdown of all Thinkific Payments transactions from Order Number to product type (one-time, payment plan, or subscription). It includes a search option and date picker for quick access to specific transactions based on these key transaction details.
You can also refund a transaction, view the receipt, view the student profile, view the order, and view the affiliate associated if applicable right from the Transactions table.
The Transaction Report provides accurate historical transaction data for all purchases made through Thinkific Payments. You'll see individual line items for all transactions including payment plans and subscriptions.
Important Considerations
- The Transactions Report is for Thinkific Payments transactions only. Refer to your Orders Report if you have Stripe or PayPal transaction history.
- Unlike the Orders Report, the Transaction Report does not display $0 purchases.
- Looking to export your Transaction Report data to QuickBooks? Check out our Auto-Sync with QuickBooks functionality!
How to View the Transaction Report
- From your Admin Dashboard, select Sales
- Select Transactions
Here you will see all of your Thinkific Payments transactions displayed in reverse chronological order by default. Select the arrow icon beside a heading name to adjust the sorting order of your transactions.
The following details are available for every transaction in the Transaction table. You can use the Columns option to choose which fields are visible.
| Field | Description |
| Date | Date the transaction took place |
| Status | Succeeded, Refunded, Partially refunded, Failed |
| Subtotal | Product price before tax |
| Tax | Tax collected |
| Total | Total transaction amount Note: for transactions where VAT was calculated, Subtotal and Total will be the same, as VAT is price-inclusive. Learn more here: TCommerce: Sales Tax and VAT Solution. |
| Fees | Thinkific Payments transaction fees |
| Net amount | Amount minus Fee |
| Currency | Buyer currency |
| Name | Customer name. This will update in the report if updated in the user profile. |
| Customer email. This will update in the report if updated in the user profile. | |
| Order | Thinkific Order Number. Payment plans and subscriptions will have multiple transactions listed under the same Order Number. |
| Product | Product name |
| Order bump | Product name included in your Order bump |
| Transaction type | Payment, Refund |
| Pricing type | One-time, Subscription, or Payment Plan |
| Payment method | Card, Apple Pay, Google Pay |
| Card brand | Visa, Mastercard, American Express, etc. |
| Card last four digits | Last 4 digits of the credit card |
| Card expiry date | Credit card expiry MM/YY |
| Zip/postal code | Zip code or postal code of the buyer |
| Country | Country of buyer |
| Affiliate | Affiliate name if applicable |
| Coupon name | Coupon name if applicable |
| Coupon code |
Coupon code if applicable |
| Coupon discount | $ value of coupon discount |
| Price label | Additional pricing label if applicable |
| Refund reason | Duplicate, Fraudulent, Requested by customer, Other |
| Failed reason | Reason for a failed transaction. Ex. The card has insufficient funds to complete the purchase. |
| Transaction ID | Auto-generated unique identifier for your transaction |
| User ID | Unique identifier for your customer. If a customer's name or email is edited, the User ID can still be used as the key identifier to look up all their transactions. |
| Provider charge ID | ID for tracking retry attempts. With subscription or payment plan renewals, there can be multiple automated retry attempts to collect the payment. Provider charge ID allows you to see each retry attempt for failed payments. |
| Invoice ID | Subscription or payment plan renewals are to be attached to one Invoice ID. |
| Address Line 1 | Address information captured if a full address collection is enabled. Note: these fields appear in the Transaction Export only - it will not be visible in the Transaction table. |
| Address Line 2 | |
| City |
Transaction Summaries
Easily gain instant insights into your sales performance in real-time with transaction summary cards at the top of the Transactions table. These summary cards will dynamically display:
- Gross Sales: Total amount and count of successful sales.
- Refunds: Total amount and count of refunded transactions.
- Net Sales: Total earnings (sales minus refunded transactions, tax, and fees).
- Failed Payments: Total amount and count of failed transactions.
How to Export the Transaction Report
Looking to export your Transaction Report data to QuickBooks? Check out our Auto-Sync with QuickBooks functionality!
If you would like to export your data for your records or accounting purposes, you can do so by selecting the Export button. You will then receive an email containing a CSV file of your report. CSV (comma-separated values) is a universal file type that can be opened by any spreadsheet program, such as Excel, or Google Sheets.
If you have applied a date range or modified the visible columns on your orders table, these changes will apply to the export you run.
- From your Admin Dashboard, select Sales
- Select Transactions
- Optional: Use the Date Picker to adjust the date range that will be exported
- Optional: Use the Column menu to select or deselect visible columns that will be exported
- Select Export
Transaction Details
Click on the transaction to open up a transaction details view where you can see information about the transaction, including student details, payment details, and the fee and tax breakdown.
Processing Refunds
Refunds for Thinkific Payment transactions can be processed directly from your Transactions page. See how to manage refunds here: Thinkific Payments: Refunds
Viewing Transaction Receipt
You can view the transaction receipt by following these steps:
- From Admin Dashboard, select Sales
- Select Transactions
- Click on the three dots next to the transaction
- Select the View Receipt option
Frequently Asked Questions
If my student's name or email is changed, how can I locate their previous transactions?
You can search your Transactions Report using the Thinkific User ID. When a new user is created in your account, they are automatically assigned a Thinkific User ID that can be used to search for all transactions even if there has been a name or email change.
Learn more here: View all Thinkific Payments Transactions from a Customer with User ID
Why do some Transactions have the same Order Number?
Payment plans and subscriptions will have multiple transactions listed under the same Order Number. The Transaction ID will always be unique.
What is the difference between the Transactions Report and Orders Report?
The Transaction Report includes payments processed through Thinkific Payments specifically. If you have connected to Stripe or PayPal, these transactions are available on the Orders Report.
Can I retry failed payments from the Transaction Report?
You can process refunds from the Transaction Report. If you would like to retry failed payments, pause, resume, or cancel subscriptions and payment plans, see Thinkific Payments: Managing Student Payments.
Will gift transactions be visible in the Transaction Report?
Transactions made using TCommerce: Gifting option (i.e. orders that were made as gifts for someone else) will be visible in the Transaction Report. As gift redemptions (i.e. orders that are made when a gift recipient redeems their gift) are $0 purchases, they will not be visible in the Transaction report.
Will Group Order transactions be visible in the Transaction Report?
Transactions made using TCommerce: Group Orders option (i.e. orders where a purchase of several seats is made) will be visible in the Transaction Report. As individual seat redemptions (i.e. orders that are made when someone redeems their seat) are $0 purchases, they will not be visible in the Transaction report.
More About TCommerce
TCommerce: Powered by Thinkific Payments