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
Query paid invoices for a period via API
bash
curl "https://api.billing.kobana.com.br/v1/invoices?status=paid&due_date_from=2026-01-01&due_date_to=2026-06-30&per_page=100" \
-H "Authorization: Bearer $KOBANA_TOKEN"response
{
"data": [
{
"id": "2d3e4f5a-6b7c-4d8e-9f0a-1b2c3d4e5f6a",
"number": "INV-001234",
"status": "paid",
"total": 299.9,
"amount_paid": 299.9,
"due_date": "2026-06-10",
"paid_at": "2026-06-08T14:12:00.000Z"
}
],
"meta": { "total": 184, "page": 1, "per_page": 100, "total_pages": 2 }
}