Tracking sales is crucial to your business’ success, strategy, and health. With that in mind, Hotmart provides a full sales report, allowing you to track your business and tinker with strategies to go further.
The sales report is your sales history containing detailed information about transactions, fees, taxes, commissions, products, and buyers. It presents the information already gathered from the platform in a single exported document with in-depth details.
This report can be found by logging into your Hotmart account and accessing Sales then selecting Overview in the left side menu.
Currently, the sales report can be exported in two different templates:
- Standard Template: This template provides basic, general information gathered up to the moment of exporting.
- Detailed template: This template provides, beyond the basic information, more details about payment methods and currency conversion.
These templates can be exported in two formats:
- CSV: For automated spreadsheets
- XLS: For manual searches
What’s the difference between the standard and the detailed template?
Both report templates provide general information about your transactions, such as purchase and product info, payment methods, currencies and fees. The standard template is the platform’s default template, with its usual structure and each transaction’s general information. The detailed template is organized differently, with the same data as the standard template, but with additional columns and more in-depth information.
The columns in the detailed model are as follows:
- Price Name: The name of the product offer registered on the platform
- Local taxes: The amount paid in local taxes, if any, collected by Hotmart
- Commission currency: The currency of the commission paid to the parties involved in the sale
- Commission (Gross amount - no taxes): The gross amount of the commission already converted into the payment’s currency, without splitting it between the parties involved and taxes
- My commission: The amount of commission received by the user who exported the report
- Affiliate commission: The amount of the affiliate's commission already converted into the payment’s currency, with the fees and commissions of the parties involved already deducted
- Co-producer commission: The amount of the co-producer's commission already converted into the payment’s currency, with the fees and commissions of the parties involved already deducted
- Fee currency: The currency of the fees that will be deducted
- Processing fee: The amount of Hotmart's fee already in the commission’s currency, which will be deducted from the processed gross amount.
- Streaming rate: The fee for the Hotmart Player streaming service, when used.
- Other fees: The aggregate amount of all other fees, which may be levied on the processed gross amount. For example: Hotmart UmPorCento.
Understanding the data
The detailed template, in addition to the columns mentioned above, provides the same information as the standard template, but is organized differently. Here, we’ll detail the meaning of each column in each template.
Detailed template |
Standard template |
Meaning |
Transaction Code |
Transaction |
Transaction code generated for the purchase. |
Transaction Status |
Status |
Transaction status. |
Transaction date |
Date of sale |
Date the purchase was made. |
Payment confirmation |
Confirmation date |
Date on which the payment was confirmed. |
Producer |
Producer's name |
Name of the person producing the product sold. |
Product code |
Product code |
ID of the product sold. |
Product |
Product name |
Name of the product sold as registered on the platform. |
Price code |
Offer code |
Offer code of the product sold. |
Price name |
- |
The name of the product offer registered on the platform. |
Conversion rate (currency of order) |
Exchange rate |
Rate used to convert the original price of the offer into the amount to be paid by the Buyer, in their local currency. |
Currency of Order |
Currency |
Currency of the purchase used by the Buyer. |
Order Amount with Tax |
Total price |
Purchase price (already converted into the buyer's local currency, where applicable) with local taxes applied (if any). |
Local taxes |
- |
The amount paid in local taxes, if any, collected by Hotmart. |
Order Amount without Tax |
Price of Offer |
Amount of the purchase (already converted into the buyer's local currency, when applicable) without local taxes (if any) being levied. |
Conversion rate (commission’s currency) |
Exchange rate |
Rate used to convert the purchase price, before taxes, into the commission’s gross amount (without splitting it between the parties involved) in its respective currency. |
Commission’s currency |
- |
The commission currency of the parties involved in the sale. |
Commission (Gross amount - no taxes) |
- |
Gross commission amount already converted into the payment’s currency, without splitting it between the parties involved and taxes. |
My commission |
- |
Amount of the commission received by the user who exported the report, regardless of their role in the sale. |
Sale made as |
Source of the commission |
Description of the account user's participation in the sale in question: Producer, Affiliate or Co-producer. |
Producer Commission |
Amount of the Producer's commission, already converted into the payment’s currency, deducting the fees and commissions of the parties involved. |
|
Affiliate Commission |
- |
Amount of the Affiliate's commission, already converted into the payment’s currency, with the fees and commissions of the parties involved already deducted (when applicable). |
Co-producer Commission |
- |
Amount of the Co-producer's commission, already converted into the payment’s currency, with the fees and commissions of the parties involved already deducted (when applicable). |
Currency of Fee |
- |
Currency of the fees that will be charged on the gross amount processed. |
Processing fee |
- |
Amount referring to Hotmart’s fee, according to the percentage of the Producer, in the commission’s currency. This amount will be deducted from the gross amount processed. |
Streaming rate |
- |
Amount of the fee charged for Hotmart Player streaming service (when active and/or applicable). |
Other fees |
- |
Total amount of all other fees that may be charged on the gross amount processed. For example: Hotmart UmPorCento. |
Affiliate name |
Affiliate name |
Name of the Affiliate. |
Channel used for sale |
Source of the sale |
Channel through which the sale was made. |
SRC Code |
- |
SRC code used in the payment page’s URL to determine its source. |
SCK Code |
Payment page source |
SCK code used in the payment page’s URL to determine its source. |
Payment method |
Payment method |
Payment method used by buyers for their purchases. |
Billing |
Offer Payment Type |
The manner in which the sales price was, or will be, collected. |
Total number of installments |
Number of Installments |
Total amount of installments of a payment installment plan for cases where the sale has an 'Installment' or 'Smart Installment' collection type. |
Number of recurring payments |
Recurrences |
Number of recurring payments already made. Applicable for subscription plans in which this column returns the number of recurrences that have already been processed. |
Due date (vouchers) |
Due date |
Expiration date of the printed voucher for purchases made with a voucher payment method. For example: Boleto, OXXO, Baloto, PagoEfectivo, Sencillito, Multibanco, etc. |
Coupon Code |
Coupon |
Code of the coupon used by the Buyer making the purchase (if any). |
Free trial |
Free trial period |
If the sale has a free trial period, for cases of 'Subscription' sales. |
Quantity of items |
Number of items |
The number of items acquired in the purchase. Applicable for cases of sale of 'Tickets for Events' type of products. |
Buyer |
Name |
Name of the Purchaser. |
Buyer's email |
|
The buyer’s email. |
Country |
Country |
The buyer's country. |
Phone number |
Telephone Number |
The buyer’s phone number. |
Document |
Document |
The buyer’s ID number. |
Postal code |
ZIP Code |
The buyer’s postal code. |
City |
City |
The buyer’s city. |
State/Province/Region |
State |
The buyer’s state, province, or region. |
Address |
Address |
The buyer’s address. |
District |
Neighborhood |
The buyer’s neighborhood. |
Number |
Number |
The buyer’s address number. |
Address Line 2 |
Additional address info |
The buyer’s additional address information. |
|
|
The buyer’s Instagram. |
- |
Invoice |
Determines who is responsible for issuing the invoice, which can be Hotmart (HOTMART) or the Creator (SELLER). |