Payment reporting and reconciliation
Clean financial reporting is the backbone of running a business. Intellivizz CRM gives you payment data; reconciling it with your bookkeeping is your monthly accounting routine.
Built-in payment reports
Total revenue by period (day, week, month, quarter, year)
Revenue by product/service
Revenue by customer
Active vs. cancelled subscriptions (MRR/ARR)
Average revenue per customer (ARPU)
Failed payment recovery rate
Refunds issued and reasons
Where to find reports
Reporting → Payments — dashboard view
Payments → Transactions — line-by-line transaction list
Payments → Subscriptions — subscription-specific metrics
Export to CSV from any report screen
Monthly reconciliation routine
Export all transactions for the month from Payments → Transactions
Compare to your Stripe dashboard payouts (Stripe shows when money actually moved to your bank)
Compare to your bank statement deposits
Note any discrepancies (chargebacks, refunds, processor fees) and account for them in your books
Tag any disputed/refunded transactions in your accounting software
Send the export to your bookkeeper
Critical metrics to track monthly
| Metric | What it tells you |
|---|---|
| Total revenue | Top-line growth |
| MRR / ARR | Subscription revenue stability |
| Net revenue (after refunds) | True earnings |
| Average transaction value | Pricing health |
| Customer lifetime value (LTV) | How much each customer is worth over time |
| Failed payment rate | Card health |
| Dunning recovery rate | How well dunning is working |
| Refund rate | Customer satisfaction signal (high = problem) |
| Dispute rate | Compliance signal (>1% = serious risk) |
TIP — Connect to your accounting software
QuickBooks, Xero, FreshBooks, and others integrate with Stripe directly — transactions flow into your books automatically with proper categorization. This removes 80% of monthly bookkeeping work for service businesses. Set this up once during onboarding.
