Reporting & Reconciliation

Financial Reports

Subscription metrics, billing operations, and financial reporting
View as Markdown

Reporting Capabilities

Prolifi provides a comprehensive suite of financial reports. All reports are filterable by operating entity, date range, currency, and customer segment.

Subscription and revenue metrics

MRR Report (see Glossary: Reporting and Global Terms)

  • Total MRR by period
  • New MRR (new subscriptions)
  • Expansion MRR (upgrades, add-ons)
  • Contraction MRR (downgrades)
  • Churned MRR (cancellations)
  • Net MRR movement

ARR Report (see Glossary: Reporting and Global Terms)

  • Annualised recurring revenue snapshot by period
  • ARR by plan, by product, by customer segment

NRR Report (see Glossary: Reporting and Global Terms)

  • Net Revenue Retention by period
  • Cohort-based NRR (how much revenue retained from customers acquired in a specific period)

ARPU Report (see Glossary: Reporting and Global Terms)

  • Average Revenue Per User by period
  • ARPU by plan, by segment

Churn Report (see Glossary: Reporting and Global Terms)

  • Customer churn rate by period
  • Revenue churn rate by period
  • Voluntary vs. involuntary churn split
  • Churn reason analysis (where cancellation reason codes are captured)

Billing operations reports

Invoice Summary:

  • All invoices by status for a period
  • Total billed, total collected, total outstanding
  • Overdue invoice ageing analysis

Collections Report:

  • Payment collection totals by period
  • Collection by payment method, by operating entity
  • Failed collection analysis (by decline reason)

Dunning Performance Report:

  • Recovery rate by retry attempt
  • Revenue recovered through dunning
  • Dunning cancellation rate

For details on configuring dunning retry schedules and recovery strategies, see Dunning and Payment Recovery.

DSO Report (see Glossary: Reporting and Global Terms)

  • Average days from invoice issue to payment
  • DSO by customer segment, by operating entity

Financial reporting

Revenue Recognition Report:

  • Recognised revenue by period (by product, by customer)
  • Deferred revenue balance by period
  • Recognition schedule for all active deferred invoices

For a full explanation of how revenue recognition works in Prolifi, including recognition rules, schedules, and period-end runs, see Revenue Recognition.

Tax Liability Report:

  • Tax collected by jurisdiction, by rate
  • Tax-exempt transactions with reason codes
  • Net revenue vs. tax by operating entity

Reconciliation Report:

  • Matched, unmatched Prolifi records, unmatched gateway records
  • Discrepancy summary by category

Transaction Audit Trail Export:

  • Complete, immutable record of all transactions for a period
  • Available as CSV for external archival or audit submission

Regulation-grade reporting

Prolifi’s regulation-grade reports are designed to meet the requirements of accounting standards and financial audits:

  • ASC 606 Revenue Recognition Report: Supports US GAAP compliance for SaaS and subscription businesses
  • IFRS 15 Revenue Recognition Report: Supports international financial reporting standard compliance
  • Audit trail export: Complete, immutable transaction history suitable for external audit submission
  • Tax compliance reports: Formatted for VAT/GST return preparation in supported jurisdictions

Prolifi’s compliance certification programme is in progress. Regulation-grade reporting outputs should be reviewed by your auditor or compliance team before being used for statutory purposes.

Exporting Financial Data

All Prolifi financial reports are exportable:

CSV export: Available for all reports. Suitable for import into accounting systems (Xero, QuickBooks, NetSuite, Sage, SAP), BI tools (Power BI, Tableau, Looker), and spreadsheets.

API export: Report data is available via the Prolifi API, enabling automated extraction for integration with accounting and reporting pipelines. Pagination is supported for large datasets.

Scheduled exports: Configure recurring export schedules (daily, weekly, monthly) to automatically generate and deliver report files to a configured destination (email, SFTP, or connected integration).

Use scheduled exports to automate month-end reporting. Configure weekly or monthly exports for key reports like MRR, revenue recognition, and reconciliation to reduce manual effort and ensure timely delivery.