Paddle Billing
Search

Generate reports

Export information from your Paddle account as a spreadsheet to better understand your data and reconcile account activity.

Reports in Paddle let you export information from your account that you can open in a spreadsheet app. You can use them as part of your financial processes, like calculating revenue and analyzing trends. They're often used for working with data in other applications, like accounting or ERP solutions.

Illustration showing the report picker card from the Paddle web app. There's a heading that says 'Choose a report,', then under that there are four items: transactions, transaction items, adjustments, and adjustment items'. For each item, there is a button that says build report.

How it works

There are four kinds of reports available in Paddle:

  • Transactions

    Transactions capture and calculate revenue for both checkouts and invoices. They hold information about an amount that you're billing for. Generate transactions reports to get information about revenue received, past due invoices, draft and issued invoices, and canceled transactions.

  • Transaction line items

    Generate transaction line items reports to get the same data as on transactions reports, but broken down by transaction line item.

  • Adjustments

    Adjustments are records of changes to a transaction. They're created automatically by Paddle when making prorated changes to a subscription, or when making changes to an issued invoice. Generate adjustments reports to get information about refunds, credits, and chargebacks.

  • Adjustment line items

    Generate adjustment line items reports to get the same data as on adjustments reports, but broken down by adjustment line item.

When you build a report, you can filter to choose the data that you include on it. Reports are always sorted by when they were last updated, and date range filters work using the date an entity was last updated. This is so you always see the most relevant data. For example, invoices created a few months before being issued and paid are included on reports when they're issued and paid.

Data on reports may be delayed for up to 24 hours. This means you might not see transactions or adjustments from the last 24 hours on your reports.

It might take a little while to generate a report, depending on the amount of data you include on it. The Reports screen in the Paddle web app updates when your report is ready, and you'll get an email to let you know, too. Reports are available to download for 14 days once generated.

Reports are CSV files

Paddle produces reports as CSV (comma-separated values) files. CSV files are text files that use commas to separate cells of data. You can open CSV files with any spreadsheet app, like Microsoft Excel, Google Sheets, and Apple Numbers.

Your computer or device may open CSV files in your default text editor. If this happens, open your spreadsheet app and use File > Open to open it, or look for an import option.

Paddle exports CSV files using UTF-8/Unicode character encoding, with a comma as the delimiter.

Generate a report

Open report builder

  • Go to Paddle > Reports.

  • Click Build report for the report that you'd like to generate under the "Generate a report" heading.

Screenshot showing the Reports screen in Paddle, with Reports on the nav called out. The build report button is called out, too.

Filter report data

  • Use the options to filter the data you'd like to include on your report.

  • When you're done, click Generate report.

Screenshot showing the new report drawer, with the filters section called out. The fields are empty.

Download report

  • Paddle starts working on generating your report in the background. You'll get an email when it's done.

  • Look out for an email from Paddle, then click Download report in the email.

  • You can also download your report from the Reports screen in the Paddle web app.

Screenshot of an email from Paddle saying that a report is ready to download.

Data included on reports

Column headings on reports largely mirror fields in the Paddle API. For example, transactions reports include fields that you'll find against the transaction entity when working with the API.

idstring

Unique Paddle ID for this adjustment entity, prefixed with adj_.

transaction_idstring

Paddle ID for the transaction related to this adjustment, prefixed with txn_.

customer_idstring

Paddle ID for the customer related to this adjustment, prefixed with ctm_.

customer_emailstring<email>

Email address for the customer that this adjustment is for.

address_idstring

Paddle ID for the address related to this adjustment, prefixed with add_.

customer_country_codestring

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

business_idstring or null

Paddle ID for the business related to this adjustment, prefixed with biz_.

business_namestring or null

Name of the business that this adjustment is for.

actionstring

How this adjustment impacts the related transaction. refund adjustments must be approved by Paddle, and are created with the status pending_approval.

reasonstring

Why this adjustment was created. Retained for record-keeping purposes.

statusstring

Status of this adjustment. Set automatically by Paddle.

refund adjustments must be approved by Paddle, and are created with the status pending_approval until they move to approved or rejected on review. Other kinds of adjustment do not need approval, so are created with the status approved.

created_atstring<date-time>

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

updated_atstring<date-time>

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

approved_atstring<date-time> or null

RFC 3339 datetime string of when this adjustment was marked as approved. null for transactions that are not approved.

currency_codestring

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

subtotalstring

Total before tax in the adjustment currency.

taxstring

Total tax on the subtotal in the adjustment currency.

totalstring

Total after tax in the adjustment currency.

paddle_feestring

Total fee taken by Paddle for this adjustment in the adjustment currency.

earningsstring

Total earnings in the adjustment currency. This is the subtotal minus the Paddle fee.

chargeback_feestring or null

Chargeback fee incurred for this transaction. Only present where the adjustment action is chargeback or chargeback_warning.

balance_currency_codestring

Three-letter ISO 4217 currency code of your balance currency.

balance_currency_subtotalstring or null

Total before tax and fees in your balance currency.

balance_currency_taxstring or null

Total tax on the subtotal in your balance currency.

balance_currency_totalstring or null

Total after discount and tax in your balance currency.

balance_currency_paddle_feestring or null

Total fee taken by Paddle for this adjustment in your balance currency.

balance_currency_earningsstring or null

Total earnings for this adjustment in your balance currency. This is the total minus the Paddle fee.

balance_currency_chargeback_feestring or null

Chargeback fee incurred for this transaction in your balance currency. Only present where the adjustment action is chargeback or chargeback_warning.

Related pages