Data Export

Download ready-made reports on revenue, tax, customers, orders and operations for bookkeeping and analysis.

Admin → Data Export offers ready-made datasets you can download for your accountant, a spreadsheet or a BI tool. Exports are available as CSV (opens in Excel and Google Sheets) or JSON. Most datasets can be filtered by date range, and every export is streamed, so large exports work too.

You need the admin.data-export permission, plus the permission for the area the dataset comes from. The invoices dataset, for example, also needs admin.payments.

Available datasets

Revenue & billing

DatasetUse it for
Invoices & paymentsEvery invoice with subtotal, discount, tax, total, net earnings, gateway and transaction ID. The starting point for bookkeeping.
Revenue by month / by package / by gatewayRevenue breakdowns for reporting.
RefundsEvery refund issued.
Sales tax / VAT reportTax collected per jurisdiction, for tax returns.
Unpaid invoices (aged)Outstanding invoices grouped by age.
Account credit ledgerEvery balance change across all customers.

Orders & subscriptions

DatasetUse it for
Orders & servicesAll orders with status, cycle and due date.
Renewal forecastUpcoming renewals and expected revenue.
Churn & cancellationsTerminated and cancelled services.
Gateway subscriptionsEvery subscription and its status.
Checkout line itemsExactly what was purchased in each checkout.
Order add-ons & config optionsWhich configurable options customers choose.

Customers

DatasetUse it for
Customer listAll customers and their contact details.
Customer lifetime valueTotal spend per customer.
Billing addresses & tax IDsAddress and tax data for compliance.
Signups & conversion by monthGrowth and conversion from signup to customer.
Bans & suspensionsModeration history.

Catalog & operations

DatasetUse it for
Packages / Price listYour catalog and its prices.
Provisioned accountsAccounts created on remote platforms.
Payment gateway setupConfigured gateways (secrets are never exported).
Configured tax ratesYour tax countries and states.
Sent email logEmail delivery history.
Audit trailActivity log of changes made in the system.
Support ticketsTicket history (when the Tickets module is enabled).

Exports contain personal data. Store and share them in line with your privacy obligations, such as GDPR.

On this page