Our finance team once spent three late nights reconciling usage spreadsheets against invoices. Every correction required digging through logs, spreadsheets, and half a dozen Slack threads. We needed revenue recognition that ran itself and produced an audit trail accountants could trust.
Capture Revenue at the Event Level
Instead of summarizing usage at the end of the month, we rate each event as it lands. The billable item we create includes:
- Who triggered the usage
- Which product and meter applied
- Quantity, unit price, and currency
- Timestamps for the event and billing period
Finance can trace any invoice line back to a single usage record without asking engineering for help.
Let the System Build Invoices
UsageBox groups billable items according to each customer’s cadence. Proration, discounts, and taxes are handled by the configuration we maintain in the catalog. Once an invoice closes, we publish summarized entries to our accounting system so the general ledger stays clean.
Keep Exports Boring
We maintain two exports:
- A nightly CSV that finance can import into their ERP if something changes unexpectedly.
- An API endpoint that downstream systems call for automation tasks like revenue scheduling.
Both contain the metadata auditors ask for, unique IDs, timestamps, and the pricing version applied.
Controls That Passed Audit
- Pricing changes are versioned, so we can prove which rules were active on any date.
- Usage events and billable items are immutable; corrections happen through adjustment entries, not edits.
- We reconcile totals weekly by comparing UsageBox exports with accounting reports.
Rolling It Out
- Align with finance on when revenue should be recognized for each product.
- Instrument ingestion so every event carries the data finance needs.
- Test with historical usage to confirm the new pipeline mirrors prior invoices.
- Switch a single plan to the automated flow before migrating the rest.
The first full billing cycle after this rollout closed without a single reconciliation fire drill. We still monitor the exports, but most weeks finance doesn’t need us, they already have the answers.