Transaction reports
Generate detailed reports about revenue received, past due invoices, draft and issued invoices, and canceled transactions.
Transactions capture and calculate revenue for both checkouts and invoices. They hold information about a customer purchase.
You can generate reports through the dashboard or via the API.
Report filters
When generating transaction reports, you can filter by:
| Field | Description |
|---|---|
| Updated date | The date a transaction was last modified. Matches entities modified on or after the start date and before the end date. |
| Status | The current status of the transaction.
|
| Origin | Where or why the transaction was created.
|
| Currency | The currency of the transaction. |
| Collection mode | How the customer has been asked to pay.
|
Report columns
Column headings on transaction reports mirror fields in the Paddle API. Data is provided in the following columns:
Unique Paddle ID for this transaction entity, prefixed with txn_.
Status of this transaction.
Invoice number for this transaction. Automatically generated by Paddle when you mark a transaction as billed where collection_mode is manual.
Paddle ID of the customer that this transaction is for, prefixed with ctm_.
Email address for the customer that this transaction is for.
Paddle ID of the address that this transaction is for, prefixed with add_.
Supported two-letter ISO 3166-1 alpha-2 country code of the address that this transaction is for.
Paddle ID of the business that this transaction is for, prefixed with biz_.
Name of the business that this transaction is for.
Comma-separated list of price IDs on this transaction.
Comma-separated list of discount IDs on this transaction.
Paddle ID of the subscription that this transaction is for, prefixed with sub_.
RFC 3339 datetime string of when this entity was created. Set automatically by Paddle.
RFC 3339 datetime string of when this entity was updated. Set automatically by Paddle.
RFC 3339 datetime string of when this transaction was marked as billed. null for transactions that are not billed or completed.
RFC 3339 datetime string of when payment was last captured for this transaction.
RFC 3339 datetime string of when the balance for this transaction was last updated.
RFC 3339 datetime string of when this transaction was marked as completed. null for transactions that are not completed.
Type of payment method used for the last payment attempt for this transaction.
How this transaction was created.
How payment is collected for this transaction. automatic for checkout, manual for invoices.
Your own structured key-value data.
Amount of time for the payment terms set for this transaction. Only present for manually-collected transactions.
Unit of time for the payment terms set for this transaction. Only present for manually-collected transactions.
RFC 3339 datetime string of when the billing period for this transaction starts.
RFC 3339 datetime string of when the billing period for this transaction ends.
Notes or other information included on the invoice document generated for this transaction. Only present for manually-collected transactions.
Customer purchase order number. Only present for manually-collected transactions.
Whether the related transaction may be paid using a Paddle Checkout. Only present for manually-collected transactions.
Supported three-letter ISO 4217 currency code for this transaction.
Subtotal before discount, tax, and deductions in the transaction currency. If an item, unit price multiplied by quantity.
Total discount as a result of any discounts applied in the transaction currency.
Total tax on the subtotal in the transaction currency.
Total after discount and tax in the transaction currency.
Total credit applied to this transaction. This includes credits applied using a customer's credit balance and adjustments to a billed transaction.
Total due on a transaction after credits but before any payments in the transaction currency.
Total fee taken by Paddle for this transaction in the transaction currency. null until the transaction is completed and the fee is processed.
Total earnings for this transaction in the transaction currency . This is the total minus the Paddle fee. null until the transaction is completed and the fee is processed.
Three-letter ISO 4217 currency code of your balance currency. If your primary currency has changed, this reflects the primary currency at the time the transaction was billed.
Exchange rate used to convert between the transaction currency to your balance currency. 1.0 if currencies match.
Total before tax and fees in your balance currency.
Total discount as a result of any discounts applied in your balance currency.
Total tax on the subtotal in your balance currency.
Total after discount and tax in your balance currency.
Total fee taken by Paddle for this transaction in your balance currency. null until the transaction is completed and the fee is processed.
Total earnings for this transaction in your balance currency. This is the total minus the Paddle fee. null until the transaction is completed and the fee is processed.
Additional credit generated from negative details.line_items. This credit is added to the customer balance.