Real-time SaaS metrics, multi-format export.
MRR, ARR, churn, ARPU, collection rate, cohorts. Executive dashboard with period filters. Export CSV, Excel, PDF, OFX, JSON.
Feature
Real-time
metrics
6
export formats
∞
customizable periods
Snapshots
daily and monthly
SaaS indicators natively calculated
MRR (Monthly Recurring Revenue)
Sum of mrrAmountCents from all active billing accounts. Calculated in real time and by monthly snapshot.
- Breakdown by plan
- Monthly history
- Comparison with previous month
ARR (Annual Recurring Revenue)
MRR × 12 or sum of annual subscriptions.
- For investors and board
- Export CSV / PDF
Churn Rate
Subscriptions canceled in period / subscriptions at start of period. Logo + revenue churn.
- Voluntary vs involuntary cancellations
- Aggregated cancellation reason
- Cohort analysis
ARPU
Total revenue / active customers. Upgrade and cross-sell metric.
- Average Revenue Per User
- Upgrade and cross-sell tracking
Collection Rate
Invoices paid on time / invoices issued. Indicator of dunning efficiency.
- Dunning efficiency
- Historical comparison
LTV (in development)
ARPU / churn — average customer value.
- Customer Lifetime Value
- In development
What is available
Executive Dashboard
Cards with KPIs (MRR, active subscriptions, collection rate, churn) + charts (monthly revenue, distribution by plan).
- Period filter (last 12 months default)
- Comparison with previous period
- Auto-refresh
Cohort Analysis
Analysis by signup cohort. Revenue retained per month after onboarding.
- Retention heatmap
- Drill-down by plan
- Export for external analysis
Tax Reports
TaxPeriod consolidates monthly/quarterly calculation per Company. Service book, period calculation.
- ISS calculated per municipality
- Quarterly IRPJ + CSLL
- Estimated DAS (Simples Nacional)
- Format compatible with accounting
Usage Snapshots
UsageDailySnapshot + UsageMonthlySnapshot store aggregated consumption. Reduces query cost in dashboard.
- Calculated by worker
- Support for quantity + cost
- Base for metered billing
Multi-Format Export
ExportService creates Export records and triggers export worker. Result in S3 with signed link.
- CSV (generic)
- Excel XLSX (with formatting)
- PDF (formatted reports)
- OFX, JSON, ZIP
Scheduled Reports
Recurring reports sent by email. Configurable by frequency (daily, weekly, monthly).
- Automatic email
- Configurable by frequency
- Daily, weekly, monthly
Advanced Filters
Combination by status, plan, amount, period, tags. Save custom views.
- AND/OR operators
- Flexible time range
- Export of applied filter
Queryable AuditLog
Every mutation recorded. Filter by user, action, resource, IP. Useful for compliance and troubleshooting.
- Previous + new values JSON
- Configurable retention (default 2 years)
- API for SIEM integration
Schedule export via API
bash
curl -X POST https://api.billing.kobana.com.br/v1/exports \
-H "Authorization: Bearer sk_live_..." \
-H "Content-Type: application/json" \
-d '{
"resource": "invoices",
"format": "xlsx",
"filters": {
"period_start": "2026-01-01",
"period_end": "2026-06-30",
"status": ["paid"]
}
}'response
{
"id": "exp_xyz",
"status": "processing",
"download_url": null,
"estimated_time_seconds": 30
}