> For the complete documentation index, see [llms.txt](https://developer.paddle.com/llms.txt). # 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](https://developer.paddle.com/api-reference/transactions/overview.md) 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. ## When to use - **Analyze revenue by product or price** Break transactions down to the individual items so you can see which products and prices drive revenue. - **Audit subscription billing** See line-level detail for renewals, one-time charges, and proration. - **Feed product-level analytics** Export itemized transaction data into BI tools for cohort, mix, and product performance analysis. ## Report filters When generating transaction line item reports, you can filter by: {% table %} - 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. {% /table %} ## Report columns Column headings on transaction line item reports mirror fields in [the Paddle API](https://developer.paddle.com/api-reference/overview.md). Data is provided in the following columns: ```yaml title: Transaction line item report type: object properties: transaction_id: type: string pattern: ^txn_[a-z\d]{26}$ description: Paddle ID of the related transaction, prefixed with `txn_`. title: Transaction ID examples: - txn_01h04vsbhqc62t8hmd4z3b578c transaction_status: type: string enum: - draft - ready - billed - paid - completed - canceled - past_due description: Status of the related transaction. x-enum-descriptions: draft: description: Transaction is missing required fields. Typically the first stage of a checkout before customer details are captured. readOnly: true ready: description: Transaction has all of the required fields to be marked as `billed` or `completed`. readOnly: true billed: description: Transaction has been updated to `billed`. Billed transactions get an invoice number and are considered a legal record. They cannot be changed. Typically used as part of an invoice workflow. paid: description: Transaction is fully paid, but has not yet been processed internally. readOnly: true completed: description: Transaction is fully paid and processed. readOnly: true canceled: description: Transaction has been updated to `canceled`. If an invoice, it's no longer due. past_due: description: 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. readOnly: true invoice_number: type: - string - "null" description: Invoice number for this transaction. Automatically generated by Paddle when you mark a transaction as `billed` where `collection_mode` is `manual`. customer_id: type: - string - "null" pattern: ^ctm_[a-z\d]{26}$ description: Paddle ID of the customer that this transaction is for, prefixed with `ctm_`. title: Customer ID examples: - ctm_01grnn4zta5a1mf02jjze7y2ys customer_email: type: string minLength: 1 maxLength: 320 format: email description: Email address for the customer that this transaction is for. title: Email address examples: - test@paddle.com address_id: type: - string - "null" pattern: ^add_[a-z\d]{26}$ description: Paddle ID of the address that this transaction is for, prefixed with `add_`. title: Address ID examples: - add_01gm302t81w94gyjpjpqypkzkf customer_country_code: oneOf: - type: string enum: - AD - AE - AG - AI - AL - AM - AO - AR - AS - AT - AU - AW - AX - AZ - BA - BB - BD - BE - BF - BG - BH - BI - BJ - BL - BM - BN - BO - BQ - BR - BS - BT - BV - BW - BZ - CA - CC - CG - CH - CI - CK - CL - CM - CN - CO - CR - CV - CW - CX - CY - CZ - DE - DJ - DK - DM - DO - DZ - EC - EE - EG - EH - ER - ES - ET - FI - FJ - FK - FM - FO - FR - GA - GB - GD - GE - GF - GG - GH - GI - GL - GM - GN - GP - GQ - GR - GS - GT - GU - GW - GY - HK - HM - HN - HR - HU - ID - IE - IL - IM - IN - IO - IQ - IS - IT - JE - JM - JO - JP - KE - KG - KH - KI - KM - KN - KR - KW - KY - KZ - LA - LB - LC - LI - LK - LR - LS - LT - LU - LV - MA - MC - MD - ME - MF - MG - MH - MK - MN - MO - MP - MQ - MR - MS - MT - MU - MV - MW - MX - MY - MZ - NA - NC - NE - NF - NG - NL - "NO" - NP - NR - NU - NZ - OM - PA - PE - PF - PG - PH - PK - PL - PM - PN - PR - PS - PT - PW - PY - QA - RE - RO - RS - RW - SA - SB - SC - SE - SG - SH - SI - SJ - SK - SL - SM - SN - SR - ST - SV - SX - SZ - TC - TD - TF - TG - TH - TJ - TK - TL - TM - TN - TO - TR - TT - TV - TW - TZ - UA - UG - UM - US - UY - UZ - VA - VC - VG - VI - VN - VU - WF - WS - XK - YT - ZA - ZM description: Two-letter ISO 3166-1 alpha-2 representation of a supported country. x-enum-descriptions: AD: description: Andorra AE: description: United Arab Emirates AG: description: Antigua and Barbuda AI: description: Anguilla AL: description: Albania AM: description: Armenia AO: description: Angola AR: description: Argentina AS: description: American Samoa AT: description: Austria AU: description: Australia AW: description: Aruba AX: description: Åland Islands AZ: description: Azerbaijan BA: description: Bosnia and Herzegovina BB: description: Barbados BD: description: Bangladesh BE: description: Belgium BF: description: Burkina Faso BG: description: Bulgaria BH: description: Bahrain BI: description: Burundi BJ: description: Benin BL: description: Saint Barthélemy BM: description: Bermuda BN: description: Brunei BO: description: Bolivia BQ: description: Caribbean Netherlands (Bonaire, Sint Eustatius, and Saba) BR: description: Brazil BS: description: Bahamas BT: description: Bhutan BV: description: Bouvet Island BW: description: Botswana BZ: description: Belize CA: description: Canada CC: description: Cocos Islands CG: description: Republic of Congo CH: description: Switzerland CI: description: Côte d'Ivoire (Ivory Coast) CK: description: Cook Islands CL: description: Chile CM: description: Cameroon CN: description: China CO: description: Colombia CR: description: Costa Rica CV: description: Cape Verde CW: description: Curaçao CX: description: Christmas Island CY: description: Cyprus CZ: description: Czechia (Czech Republic) DE: description: Germany DJ: description: Djibouti DK: description: Denmark DM: description: Dominica DO: description: Dominican Republic DZ: description: Algeria EC: description: Ecuador EE: description: Estonia EG: description: Egypt EH: description: Western Sahara ER: description: Eritrea ES: description: Spain ET: description: Ethiopia FI: description: Finland FJ: description: Fiji FK: description: Falkland Islands FM: description: Micronesia FO: description: Faroe Islands FR: description: France GA: description: Gabon GB: description: United Kingdom GD: description: Grenada GE: description: Georgia GF: description: French Guiana GG: description: Guernsey GH: description: Ghana GI: description: Gibraltar GL: description: Greenland GM: description: Gambia GN: description: Guinea GP: description: Guadeloupe GQ: description: Equatorial Guinea GR: description: Greece GS: description: South Georgia and the South Sandwich Islands GT: description: Guatemala GU: description: Guam GW: description: Guinea-Bissau GY: description: Guyana HK: description: Hong Kong HM: description: Heard Island and McDonald Islands HN: description: Honduras HR: description: Croatia HU: description: Hungary ID: description: Indonesia IE: description: Ireland IL: description: Israel IM: description: Isle of Man IN: description: India IO: description: British Indian Ocean Territory IQ: description: Iraq IS: description: Iceland IT: description: Italy JE: description: Jersey JM: description: Jamaica JO: description: Jordan JP: description: Japan KE: description: Kenya KG: description: Kyrgyzstan KH: description: Cambodia KI: description: Kiribati KM: description: Comoros KN: description: Saint Kitts and Nevis KR: description: South Korea KW: description: Kuwait KY: description: Cayman Islands KZ: description: Kazakhstan LA: description: Lao People's Democratic Republic (Laos) LB: description: Lebanon LC: description: Saint Lucia LI: description: Liechtenstein LK: description: Sri Lanka LR: description: Liberia LS: description: Lesotho LT: description: Lithuania LU: description: Luxembourg LV: description: Latvia MA: description: Morocco MC: description: Monaco MD: description: Moldova ME: description: Montenegro MF: description: Saint Martin MG: description: Madagascar MH: description: Marshall Islands MK: description: Macedonia MN: description: Mongolia MO: description: Macao MP: description: Northern Mariana Islands MQ: description: Martinique MR: description: Mauritania MS: description: Montserrat MT: description: Malta MU: description: Mauritius MV: description: Maldives MW: description: Malawi MX: description: Mexico MY: description: Malaysia MZ: description: Mozambique NA: description: Namibia NC: description: New Caledonia NE: description: Niger NF: description: Norfolk Island NG: description: Nigeria NL: description: Netherlands "NO": description: Norway NP: description: Nepal NR: description: Nauru NU: description: Niue NZ: description: New Zealand OM: description: Oman PA: description: Panama PE: description: Peru PF: description: French Polynesia PG: description: Papua New Guinea PH: description: Philippines PK: description: Pakistan PL: description: Poland PM: description: Saint Pierre and Miquelon PN: description: Pitcairn PR: description: Puerto Rico PS: description: Palestinian territories PT: description: Portugal PW: description: Palau PY: description: Paraguay QA: description: Qatar RE: description: Reunion RO: description: Romania RS: description: Republic of Serbia RW: description: Rwanda SA: description: Saudi Arabia SB: description: Solomon Islands SC: description: Seychelles SE: description: Sweden SG: description: Singapore SH: description: Saint Helena SI: description: Slovenia SJ: description: Svalbard and Jan Mayen SK: description: Slovakia SL: description: Sierra Leone SM: description: San Marino SN: description: Senegal SR: description: Suriname ST: description: São Tomé and Príncipe SV: description: El Salvador SX: description: Sint Maarten SZ: description: Swaziland TC: description: Turks and Caicos Islands TD: description: Chad TF: description: French Southern and Antarctic Lands TG: description: Togo TH: description: Thailand TJ: description: Tajikistan TK: description: Tokelau TL: description: Timor-Leste TM: description: Turkmenistan TN: description: Tunisia TO: description: Tonga TR: description: Turkey TT: description: Trinidad and Tobago TV: description: Tuvalu TW: description: Taiwan TZ: description: Tanzania UA: description: Ukraine UG: description: Uganda UM: description: United States Minor Outlying Islands US: description: United States UY: description: Uruguay UZ: description: Uzbekistan VA: description: Holy See (Vatican City) VC: description: Saint Vincent and the Grenadines VG: description: British Virgin Islands VI: description: U.S. Virgin Islands VN: description: Vietnam VU: description: Vanuatu WF: description: Wallis and Futuna WS: description: Samoa XK: description: Kosovo YT: description: Mayotte ZA: description: South Africa ZM: description: Zambia description: Supported two-letter ISO 3166-1 alpha-2 country code of the address that this transaction is for. business_id: type: - string - "null" pattern: ^biz_[a-z\d]{26}$ description: Paddle ID of the business that this transaction is for, prefixed with `biz_`. title: Business ID examples: - biz_01grrebrzaee2qj2fqqhmcyzaj business_name: type: - string - "null" maxLength: 1024 description: Name of the business that this transaction is for. title: Name subscription_id: type: - string - "null" pattern: ^sub_[a-z\d]{26}$ description: Paddle ID of the subscription that this transaction is for, prefixed with `sub_`. title: Subscription ID examples: - sub_01h04vsc0qhwtsbsxh3422wjs4 id: type: string pattern: ^txnitm_[a-z\d]{26}$ description: Unique Paddle ID for this transaction item, prefixed with `txnitm_`. Used when working with [adjustments](https://developer.paddle.com/build/transactions/create-transaction-adjustments). title: Transaction item ID examples: - txnitm_01gm302t81w94gyjpjpqypkzkf product_id: type: string pattern: ^pro_[a-z\d]{26}$ description: Paddle ID of the product that this transaction item is for, prefixed with `pro_`. title: Product ID examples: - pro_01gsz97mq9pa4fkyy0wqenepkz product_name: type: string description: Name of the product related to this transaction item. minLength: 1 maxLength: 200 price_id: type: string pattern: ^pri_[a-z\d]{26}$ description: Paddle ID of the price that this transaction item is for, prefixed with `pri_`. title: Price ID examples: - pri_01gsz8z1q1n00f12qt82y31smh price_description: type: string minLength: 2 maxLength: 200 description: Internal description for this price, not shown to customers. Typically notes for your team. billing_cycle_frequency: description: Amount of time for the billing cycle of the related price, if recurring. type: - integer - "null" minimum: 1 billing_cycle_interval: description: Unit of time for the billing cycle of the related price, if recurring. type: - string - "null" enum: - day - week - month - year trial_period_frequency: description: Amount of time for the trial period of the related price, if set. type: - integer - "null" minimum: 1 trial_period_interval: description: Unit of time for the trial period of the related price, if set. type: - string - "null" enum: - day - week - month - year transaction_currency_code: type: string enum: - USD - EUR - GBP - JPY - AUD - CAD - CHF - HKD - SGD - SEK - ARS - BRL - CLP - CNY - COP - CZK - DKK - HUF - ILS - INR - KRW - MXN - NOK - NZD - PEN - PLN - RUB - THB - TRY - TWD - UAH - VND - ZAR description: Supported three-letter ISO 4217 currency code for this transaction. title: Currency code x-enum-descriptions: USD: description: United States Dollar EUR: description: Euro GBP: description: Pound Sterling JPY: description: Japanese Yen AUD: description: Australian Dollar CAD: description: Canadian Dollar CHF: description: Swiss Franc HKD: description: Hong Kong Dollar SGD: description: Singapore Dollar SEK: description: Swedish Krona ARS: description: Argentine Peso BRL: description: Brazilian Real CLP: description: Chilean Peso CNY: description: Chinese Yuan COP: description: Colombian Peso CZK: description: Czech Koruna DKK: description: Danish Krone HUF: description: Hungarian Forint ILS: description: Israeli Shekel INR: description: Indian Rupee KRW: description: South Korean Won MXN: description: Mexican Peso NOK: description: Norwegian Krone NZD: description: New Zealand Dollar PEN: description: Peruvian Sol PLN: description: Polish Zloty RUB: description: Russian Ruble THB: description: Thai Baht TRY: description: Turkish Lira TWD: description: New Taiwan Dollar UAH: description: Ukrainian Hryvnia VND: description: Vietnamese Dong ZAR: description: South African Rand unit_price: type: string description: Unit price for this transaction item. quantity: type: string description: Quantity of this transaction item on the related transaction. subtotal: type: string description: Subtotal before discount, tax, and deductions in the transaction currency. If an item, unit price multiplied by quantity. discount: type: string description: Total discount as a result of any discounts applied in the transaction currency. tax: type: string description: Total tax on the subtotal in the transaction currency. total: type: string description: Total after discount and tax in the transaction currency. proration_rate: type: string description: How proration was calculated for this item. Rate used to calculate proration. billing_period_starts_at: type: - string - "null" format: date-time description: RFC 3339 datetime string of when the billing period for this transaction starts. title: Timestamp examples: - "2024-10-12T07:20:50.52Z" billing_period_ends_at: type: - string - "null" format: date-time description: RFC 3339 datetime string of when the billing period for this transaction ends. title: Timestamp examples: - "2024-10-12T07:20:50.52Z" tax_rate: type: string description: Rate used to calculate tax for this transaction line item. examples: - "0.2" balance_currency_code: type: string enum: - AUD - CAD - CHF - CNY - CZK - DKK - EUR - GBP - HUF - PLN - SEK - USD - ZAR description: 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. title: Currency code (payouts) x-enum-descriptions: AUD: description: Australian Dollar CAD: description: Canadian Dollar CHF: description: Swiss Franc CNY: description: Chinese Yuan CZK: description: Czech Koruna DKK: description: Danish Krone EUR: description: Euro GBP: description: Pound Sterling HUF: description: Hungarian Forint PLN: description: Polish Zloty SEK: description: Swedish Krona USD: description: United States Dollar ZAR: description: South African Rand transaction_to_balance_currency_exchange_rate: type: string examples: - "1.0513135" description: Exchange rate used to convert between the transaction currency to your balance currency. `1.0` if currencies match. transaction_created_at: type: string format: date-time description: RFC 3339 datetime string of when the related transaction was marked as `created`. `null` for transactions that are not `billed` or `completed`. title: Created at examples: - "2024-10-12T07:20:50.52Z" readOnly: true updated_at: type: string format: date-time description: RFC 3339 datetime string of when this entity was updated. Set automatically by Paddle. title: Updated at examples: - "2024-10-13T07:20:50.52Z" readOnly: true billed_at: type: - string - "null" format: date-time description: RFC 3339 datetime string of when the related transaction was marked as `billed`. `null` for transactions that are not `billed` or `completed`. title: Timestamp examples: - "2024-10-12T07:20:50.52Z" payment_captured_at: type: - string - "null" format: date-time description: RFC 3339 datetime string of when payment was last captured for the related transaction. title: Timestamp examples: - "2024-10-12T07:20:50.52Z" balance_updated_at: type: - string - "null" format: date-time description: RFC 3339 datetime string of when the balance for the related transaction was last updated. title: Updated at examples: - "2024-10-13T07:20:50.52Z" readOnly: true completed_at: type: - string - "null" format: date-time description: RFC 3339 datetime string of when the related transaction was marked as `completed`. `null` for transactions that are not `completed`. title: Timestamp examples: - "2024-10-12T07:20:50.52Z" payment_method: description: Type of payment method used for the last payment attempt for this transaction. type: string enum: - alipay - apple_pay - bancontact - blik - card - google_pay - ideal - kakao_pay - korea_local - south_korea_local_card - mb_way - naver_pay - offline - payco - paypal - pix - samsung_pay - unknown - upi - wechat_pay - wire_transfer x-enum-descriptions: alipay: description: Alipay, popular in China. apple_pay: description: Apple Pay on a supported Apple device. bancontact: description: Bancontact, popular in Belgium. blik: description: BLIK, a popular payment method in Poland. x-released: true card: description: Credit or debit card. google_pay: description: Google Pay on a supported Android device, Chromebook, or Google Chrome browser. ideal: description: iDEAL, popular in the Netherlands. kakao_pay: description: Kakao Pay, a popular payment method in South Korea. x-released: true korea_local: description: Multi-step Korean payment method workflow, which includes multiple payment options for the Korean market. Deprecated - use `south_korea_local_card`, `kakao_pay`, `naver_pay`, `payco`, or `samsung_pay` instead. deprecated: true x-released: true south_korea_local_card: description: Korean local credit or debit card. x-released: true mb_way: description: MB WAY, a popular payment method in Portugal. x-released: true naver_pay: description: Naver Pay, a popular payment method in South Korea. x-released: true offline: description: Payment recorded offline. payco: description: Payco, a popular payment method in South Korea. x-released: true paypal: description: PayPal. pix: description: Pix, popular in Brazil. Available in early access. x-released: true samsung_pay: description: Samsung Pay, a popular payment method in South Korea. x-released: true unknown: description: Payment method not known. upi: description: Unified Payments Interface (UPI), popular in India. Available in early access. x-released: true wechat_pay: description: WeChat Pay, a popular payment method in China. x-released: false wire_transfer: description: Wire transfer, sometimes called bank transfer. origin: oneOf: - type: string enum: - api - subscription_charge - subscription_payment_method_change - subscription_recurring - subscription_update - web x-enum-descriptions: api: description: Transaction created via the Paddle API. subscription_charge: description: Transaction created automatically by Paddle as a result of a one-time charge for a subscription. subscription_payment_method_change: description: Transaction created automatically as part of updating a payment method. May be a zero value transaction. subscription_recurring: description: Transaction created automatically by Paddle as a result of a subscription renewal. subscription_update: description: Transaction created automatically by Paddle as a result of an update to a subscription. web: description: Transaction created automatically by Paddle.js for a checkout. description: How this transaction was created. collection_mode: type: string enum: - automatic - manual description: How payment is collected for this transaction. `automatic` for checkout, `manual` for invoices. title: Collection mode x-enum-descriptions: automatic: description: Payment is collected automatically using a checkout initially, then using a payment method on file. manual: description: Payment is collected manually. Customers are sent an invoice with payment terms and can make a payment offline or using a checkout. Requires `billing_details`. custom_data: type: object unevaluatedProperties: {} description: Your own structured key-value data. title: Custom Data example: customer_reference_id: abcd1234 payment_terms_frequency: description: Amount of time for the payment terms set for this transaction. Only present for manually-collected transactions. type: - integer - "null" payment_terms_interval: description: Unit of time for the payment terms set for this transaction. Only present for manually-collected transactions. type: - string - "null" enum: - day - week - month - year additional_information: description: Notes or other information included on the invoice document generated for this transaction. Only present for manually-collected transactions. type: - string - "null" purchase_order_number: description: Customer purchase order number. Only present for manually-collected transactions. type: - string - "null" checkout_enabled: description: Whether the related transaction may be paid using a Paddle Checkout. Only present for manually-collected transactions. type: - boolean - "null" ```