Reports
Reports are files with the row-level records behind your billing: invoices, invoice lines and taxes, the events billed on an invoice, unmatched and duplicate events, prices and overrides, subscriptions, payments and the revenue recognition schedule. Use them for month-end close, reconciliation, tax returns and audits, or to load billing data into a spreadsheet or BI tool. Where Insights shows aggregated figures, a report gives you every row behind them.
Available reports
Every report type has a report_code, which you use to request it through the API.
Invoice data
Revenue
Usage and events
Customers, catalogue and contracts
Generate a report
Solvimon generates reports asynchronously: you request a report, Solvimon queues and builds it, and you download the file when it is ready. Files are available as CSV, JSON Lines, Parquet or Avro.
Via API
Request the report with its report_code and the parameters it takes:
Poll the request with GET /v1/report-generate-requests/{id} until it has finished, then fetch the report it produced and a download link for the file:
The parameters a report accepts depend on its type:
The customers, products, pricing plan subscriptions, pricing and clauses reports take no parameters: they always contain your current full list.
Via Desk
Request reports on the Reporting page in Desk: choose the report, set the period and filters, and download the file once it is ready. Desk lists the reports enabled for your platform; every type can be requested through the API.
Schedules and automatic reports
A report subscription generates a report automatically: on a day of the week, on a day of the month, or each time an invoice becomes final. Subscriptions can also push each file to your own BigQuery, Amazon S3, Google Cloud Storage or Snowflake. Set them up on the Reporting page in Desk, or with POST /v1/report-subscriptions:
The report configuration decides which report the subscription generates. List your platform’s configurations with GET /v1/report-configurations.
Solvimon generates the invoice usage report automatically each time a standard invoice becomes final, so it is always available for final invoices.
A report configuration sets which optional columns a report contains for your platform. Changing the columns of a report that a subscription pushes to your warehouse changes the table it writes, so update anything that reads that table at the same time.
Things to know
- Different reports use different dates. Invoice headers, lines and taxes filter on the billing period date of the invoice, falling back to the invoice date. The Invoices report and the revenue recognition report filter on the invoice date. Two reports for “September” can therefore contain different invoices.
- Different status defaults. Without a
statusesparameter, invoice headers, lines and taxes contain final invoices only. The Invoices report contains every status, including draft and void. - Scheduled invoice reports contain your full history. A scheduled run has no date range, so each file contains every invoice to date.
- Revenue recognition filters on invoice date, not reporting month. To get everything recognised in a quarter, request a wide invoice-date range and filter on the reporting period in the file.
- Data extraction time. Solvimon builds the customers, products, pricing plan subscriptions, Invoices and revenue recognition reports from its analytics warehouse rather than from live data. Each report records when its data was extracted in
data_extracted_at.
To get billing data into your own data warehouse continuously, without requesting files, use data exports. To ask questions about your billing data from an AI assistant instead, use the MCP server.