Transaction line item reports

Generate detailed reports about revenue received, past due invoices, draft and issued invoices, and canceled transactions, broken down by line item.

Transactions capture and calculate revenue for both checkouts and invoices. They hold information about a customer purchase. Transaction line items are the individual items that make up a transaction.

You can generate reports through the dashboard or via the API.

Report filters

When generating transaction line item 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. Completed: Transaction is completed. Payment collected successfully and fully processed. Paid: Transaction is fully paid, but hasn't yet been processed internally. Draft: Transaction is missing required fields. Typically the first stage of a checkout before customer details are captured. Ready: Transaction has all the required fields to be marked as `billed` or `completed`. Billed: Transaction has been updated to `billed`. Billed transactions get an invoice number and are considered a legal record. They can't be changed. Typically used as part of an invoice workflow. Past due: Transaction is past due. Occurs for automatically-collected transactions when the related subscription is in dunning, and for manually-collected transactions when payment terms have elapsed. Canceled: Transaction has been updated to `canceled`. If an invoice, it's no longer due.
Origin	Where or why the transaction was created. Created via the API: Transaction created via the Paddle API. Created via the checkout (web): Transaction created automatically by Paddle.js for a checkout. Scheduled subscription renewal: Transaction created automatically by Paddle as a result of a subscription renewal. One-time subscription charge: Transaction created automatically by Paddle as a result of a one-time charge for a subscription. Subscription update: Transaction created automatically by Paddle as a result of an update to a subscription. Payment method update: Transaction created automatically as part of updating a payment method. May be a zero value transaction.
Currency	The currency of the transaction.
Collection mode	How the customer has been asked to pay. All: Show both modes. Manual: Payment is collected manually. Customers are sent an invoice with payment terms and can make a payment offline or using a checkout. Auto: Payment is collected automatically using a checkout initially, then using a payment method on file.

Report columns

Column headings on transaction line item reports mirror fields in the Paddle API. Data is provided in the following columns:

transaction_idstring

Paddle ID of the related transaction, prefixed with txn_.

transaction_statusstring

Status of the related transaction.

invoice_numberstring or null

Invoice number for this transaction. Automatically generated by Paddle when you mark a transaction as billed where collection_mode is manual.

customer_idstring or null

Paddle ID of the customer that this transaction is for, prefixed with ctm_.

customer_emailstring<email>

Email address for the customer that this transaction is for.

address_idstring or null

Paddle ID of the address that this transaction is for, prefixed with add_.

customer_country_codestring

Supported two-letter ISO 3166-1 alpha-2 country code of the address that this transaction is for.

business_idstring or null

Paddle ID of the business that this transaction is for, prefixed with biz_.

business_namestring or null

Name of the business that this transaction is for.

subscription_idstring or null

Paddle ID of the subscription that this transaction is for, prefixed with sub_.

idstring

Unique Paddle ID for this transaction item, prefixed with txnitm_. Used when working with adjustments.

product_idstring

Paddle ID of the product that this transaction item is for, prefixed with pro_.

product_namestring

Name of the product related to this transaction item.

price_idstring

Paddle ID of the price that this transaction item is for, prefixed with pri_.

price_descriptionstring

Internal description for this price, not shown to customers. Typically notes for your team.

billing_cycle_frequencyinteger or null

Amount of time for the billing cycle of the related price, if recurring.

billing_cycle_intervalstring or null

Unit of time for the billing cycle of the related price, if recurring.

trial_period_frequencyinteger or null

Amount of time for the trial period of the related price, if set.

trial_period_intervalstring or null

Unit of time for the trial period of the related price, if set.

transaction_currency_codestring

Supported three-letter ISO 4217 currency code for this transaction.

unit_pricestring

Unit price for this transaction item.

quantitystring

Quantity of this transaction item on the related transaction.

subtotalstring

Subtotal before discount, tax, and deductions in the transaction currency. If an item, unit price multiplied by quantity.

discountstring

Total discount as a result of any discounts applied in the transaction currency.

taxstring

Total tax on the subtotal in the transaction currency.

totalstring

Total after discount and tax in the transaction currency.

proration_ratestring

How proration was calculated for this item. Rate used to calculate proration.

billing_period_starts_atstring<date-time> or null

RFC 3339 datetime string of when the billing period for this transaction starts.

billing_period_ends_atstring<date-time> or null

RFC 3339 datetime string of when the billing period for this transaction ends.

tax_ratestring

Rate used to calculate tax for this transaction line item.

balance_currency_codestring

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.

transaction_to_balance_currency_exchange_ratestring

Exchange rate used to convert between the transaction currency to your balance currency. 1.0 if currencies match.

transaction_created_atstring<date-time>

RFC 3339 datetime string of when the related transaction was marked as created. null for transactions that are not billed or completed.

updated_atstring<date-time>

RFC 3339 datetime string of when this entity was updated. Set automatically by Paddle.

billed_atstring<date-time> or null

RFC 3339 datetime string of when the related transaction was marked as billed. null for transactions that are not billed or completed.

payment_captured_atstring<date-time> or null

RFC 3339 datetime string of when payment was last captured for the related transaction.

balance_updated_atstring<date-time> or null

RFC 3339 datetime string of when the balance for the related transaction was last updated.

completed_atstring<date-time> or null

RFC 3339 datetime string of when the related transaction was marked as completed. null for transactions that are not completed.

payment_methodstring

Type of payment method used for the last payment attempt for this transaction.

originstring

How this transaction was created.

collection_modestring

How payment is collected for this transaction. automatic for checkout, manual for invoices.

custom_dataobject

Your own structured key-value data.

payment_terms_frequencyinteger or null

Amount of time for the payment terms set for this transaction. Only present for manually-collected transactions.

payment_terms_intervalstring or null

Unit of time for the payment terms set for this transaction. Only present for manually-collected transactions.

additional_informationstring or null

Notes or other information included on the invoice document generated for this transaction. Only present for manually-collected transactions.

purchase_order_numberstring or null

Customer purchase order number. Only present for manually-collected transactions.

checkout_enabledboolean or null

Whether the related transaction may be paid using a Paddle Checkout. Only present for manually-collected transactions.

Generate reports

Reports API reference

Create a report

Transaction line item reports

Report filters

Report columns

Related pages