View and manage all of your Thinkific Payment transactions from the 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
- Column customization
- Failed payments, refunds and chargebacks
- Country and zip code/postal code details—Using location data, you can determine if you have a tax obligation and the calculate the exact tax amount to submit.
How It Works
The Transaction Report is available under the Market & Sell menu of your Thinkific Admin Dashboard. 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, email your student, view their 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.
- 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.
How to View the Transaction Report
- Go to Market & Sell
- 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.
How to Export the Transaction Report
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 will show in the export that you run.
- Go to Market & Sell
- 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
The following details are available for every transaction. You can use the Columns option to choose which fields are visible.
|Date||Date transaction took place|
|Status||Succeeded, Refunded, Partially refunded, Failed|
|Fee||Thinkific Payments transaction fee|
|Net amount||Amount minus Fee|
|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.|
|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 credit card|
|Card expiry date||Credit card expiry MM/YY|
|Zip/postal code||Zip code or postal code of buyer|
|Country||Country of buyer|
|Affiliate||Affiliate name if applicable|
|Coupon name||Coupon name if applicable|
||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 are 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 be attached to one Invoice ID.|
Refunds for Thinkific Payment transactions can be processed directly from your Transactions page. See how to manage refunds here: Thinkific Payments: Refunds
Frequently Asked Questions
Can I use this report for tax reporting?
The Transaction Report currently includes zip code/postal code and Country details, which you can use to aid with tax management and reporting. We will also have State and Province details coming soon. Thinkific team members are by no means tax experts, so please check with a local tax expert before making any decisions about whether or not tax is applicable and how to go about calculating tax based on you and your customer's location.
We are constantly working on improvements and adding additional features to our TCommerce suite, so stay tuned for future updates regarding automatic tax charges in checkout.
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.
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?
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.