Adjustment line item reports
Generate detailed reports about refunds, credits, and chargebacks, broken down by line item.
Adjustments are records of changes to a transaction, like refunds or credits. They're created automatically by Paddle when making prorated changes to a subscription, or when making changes to an issued invoice. Adjustment line items are the individual items that make up an adjustment.
You can generate reports through the dashboard or via the API.
Report filters
When generating adjustment line item reports, you can filter by:
| Field | Description |
|---|---|
| Updated date | The date an adjustment was last modified. Matches entities modified on or after the start date and before the end date. |
| Status | The current status of the adjustment.
|
| Type | Kind of adjustment.
|
Report columns
Column headings on adjustment line item reports mirror fields in the Paddle API. Data is provided in the following columns:
Unique Paddle ID for this adjustment item, prefixed with adjitm_.
Paddle ID for the adjustment for this adjustment item, prefixed with adj_.
Paddle ID for the transaction related to this adjustment item, prefixed with txn_.
Paddle ID for the customer related to this adjustment, prefixed with ctm_.
Email address for the customer that this adjustment is for.
Paddle ID for the address related to this adjustment, prefixed with add_.
Supported two-letter ISO 3166-1 alpha-2 country code of the address that this adjustment is for.
Paddle ID for the business related to this adjustment, prefixed with biz_.
Name of the business that this adjustment is for.
How this adjustment impacts the related transaction.
Why this adjustment was created. Retained for record-keeping purposes.
Status of this adjustment. Set automatically by Paddle.
Most refunds for live accounts are created with the status of pending_approval until reviewed by Paddle, but some are automatically approved. For sandbox accounts, Paddle automatically approves refunds every ten minutes.
Credit adjustments don't require approval from Paddle, so they're created as approved.
Paddle ID of the product that this transaction item is for, prefixed with pro_.
Name of the product related to this transaction item.
Paddle ID of the price that this transaction item is for, prefixed with pri_.
Internal description for this price, not shown to customers. Typically notes for your team.
Amount of time for the billing cycle of the related price, if recurring.
Unit of time for the billing cycle of the related price, if recurring.
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 adjustment was marked as approved. null for transactions that are not approved.
Supported three-letter ISO 4217 currency code for this adjustment.
Total before tax in the adjustment currency.
Total tax on the subtotal in the adjustment currency.
Total after tax in the adjustment currency.
How proration was calculated for this item. Rate used to calculate proration.
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.
Rate used to calculate tax for this transaction line item.
Exchange rate used to convert between the adjustment currency to your balance currency. 1.0 if currencies match.
Total before tax and fees in your balance currency.
Total tax on the subtotal in your balance currency.
Total after discount and tax in your balance currency.