How do I report MRR and revenue with iDBQuery?
Ask iDBQuery 'What's our current MRR, and how did it break into new, expansion, contraction and churn this quarter?' and it queries your billing data live, returns the movement waterfall and totals, and cites every figure back to the invoices or subscriptions behind it.
Monthly recurring revenue reporting means tracking not just the total but the movements that change it. With iDBQuery you ask for the whole picture in plain language: - Connect your billing or subscription source (a database, an export, or a spreadsheet). - Ask 'What's our MRR today, and break the change since last month into new, expansion, contraction and churn.' - iDBQuery writes the SQL, computes each component, and returns the movement waterfall plus the running total.
A worked example: a founder asks 'Show MRR by month for the last year and highlight the biggest expansion month.' iDBQuery renders the trend, identifies the peak expansion period, and lets you drill into the specific upgrades that drove it, each traceable to an invoice.
The differentiator is that every figure is cited back to the underlying subscriptions or invoices, so finance can defend the number in a board deck rather than trusting a dashboard tile. Because iDBQuery builds one live model, you can blend billing data with your CRM to segment MRR by plan, region, or sales rep in the same question, with no data warehouse and no pipeline. Save the question as a live report and it refreshes against your data every time you open it, so revenue reporting becomes a link you share rather than a spreadsheet you rebuild.
Updated 2026-06-22