Skip to content
Bitta Apps

Bitta Subscriptions reference

Reports

Every Bitta Subscriptions report in one list: customer documents, worklists, registers, recurring revenue, forecasts, finance, pricing and resellers.

updated: applies-to: 1.3.5.0

Bitta Subscriptions has 64 reports, batch jobs included: customer documents for every lifecycle event, worklists, registers, recurring revenue, forecasts, finance, pricing and reseller reports. The Subscription Reports page (the Report Center) lists them in one place, together with four of Microsoft's Subscription Billing reports. Each report's Help in Business Central opens this page.

The Report Center

  1. Choose the search icon, enter Subscription Reports, and then choose the related link. It is also the first item in the Reports menu of the Subscription Lifecycle Manager role center, and in Microsoft's Subscription Billing role center.
  2. Filter by Category or Audience. Report Details on the right describes the selected report and its layouts.
  3. Choose Run to open the request page, or Schedule to run it later or every month from the job queue. Choose Report Inbox to find scheduled output.

The request page remembers your options from the last run, except the dates that mean "today": As Of Date, Reference Date, Notice Date, Posting Date, the start of a look-ahead (Starting Month of the forecast and the revenue waterfall, the first date of the price change and promotion notices), Period End of Create Reseller Statements, and the Analysis Month of the reports that read the latest contract analysis snapshot. They start from the work date, or the latest snapshot, on every run, and so do the dates worked out from them, such as Horizon End. Periods that you choose to review, such as the Starting Date and Ending Date of a register, keep their saved values.

Subscription Reports page listing the reports by category with the selected report's details
The Report Center lists every report in one place. Latest contract analysis snapshot at the top shows the month of Microsoft's latest contract analysis. The recurring revenue reports read those monthly snapshots. Choose Update Contract Analysis to take the current month's snapshot, and schedule Microsoft's Create Subscription Contract Analysis for the first day of each month so that no month is missing (past months cannot be snapshotted afterwards).

Most reports print as PDF and also have an Excel layout. Customer documents use Word layouts and can be sent by email through Business Central's document sending. Amounts are before tax unless the customer's prices include tax; the invoice adds the tax (Sales tax and VAT).

Customer documents

Print or send them from the record they belong to (for example Print/Send on a termination) or from the Report Center.

Report What it shows
Renewal Notice The notice before a renewal deadline: the lines, the current amount, the new price and what happens. Sent by the daily task (Renewals)
Amendment Confirmation What changed, from when, and what the next invoice will show
Hold Confirmation The hold dates, the subscriptions on hold, the credit period and the estimated credit
Termination Confirmation The last day of service, the credit period, and the fee with its invoice
Price Change Notice The written notice of a price increase, with old and new prices and the effective date
Promotion Notice A welcome (what was granted and until when) or an ending notice (the regular price afterwards)
Schedule of Services The customer's current subscriptions on one document: quantity, price, billing rhythm and term
Upcoming Invoice A preview of the contract's next billing run, including prorated charges and credits
Device Schedule Per contract, the devices with serial number, identifiers, dates and status, and the active devices against each service line's quantity (Devices)
Prepaid Balance Statement Every movement of a prepaid balance in a period with its running balance, to send to the customer (Prepaid balances)

Worklists

Report What it shows
Renewals Due The renewal pipeline: lines reaching a deadline in the horizon, by deadline, with ARR at stake
Cancellation Deadlines Evergreen lines whose last day to cancel falls in the next days
Holds to Review Active holds resuming soon, holds overdue to resume, and open-ended holds
Amendments Due Scheduled amendments by effective date, and overdue ones
Price Increases Due Proposed or planned price increases not yet applied, with old and new price
Promotions Ending Promotion lines ending soon, with the monthly revenue that returns
Unbilled Adjustment Lines Charges and credits from lifecycle actions that are not billed yet, with their age and source
Installment Schedule Installment plans with every installment: due date, amount, billing state, and what is billed and still to bill (Installment plans and milestones)
Milestone Status Contract milestones with their planned and completed dates, amounts and billing state
Overview of Contract Components (Microsoft) Microsoft's list of contract lines with dates, quantity, price, discount and amount

Registers

Report What it shows
Contract Lifecycle History One timeline per contract of every lifecycle event: amendments, holds, resumes, terminations, reopens, price increases, promotions, notices, one-time charges, moves and device events. The contract's Lifecycle Timeline FactBox shows the same events, newest first
Amendment Register Amendments applied in a period, with each change and its estimated amount
Hold Register Holds placed, resumed or canceled in a period: days on hold, credits
Termination Register Terminations in a period: settlement, reason, credit, remaining value, fee and fee invoice
Price Escalation Register Escalation entries: old and new price, uplift, index values, limit applied, status
Promotion Redemption Register Redemptions by promotion and customer, with the sales document
Renewal Notice Register Notices sent and failed in a period, with recipient and error
Terminations by Reason Terminations per reason and month: count, MRR ended, credits, fees
Holds by Reason Holds per reason and month: count, average days, MRR paused, outcome

Recurring revenue

These reports read Microsoft's monthly contract analysis snapshots. Charges and credits from lifecycle actions are left out, so the figures show the recurring price, not one-off adjustments. The amounts reconcile to Microsoft's contract analysis.

Report What it shows
Recurring Revenue Summary MRR and ARR for a month by customer, contract, item, plan family, reseller or salesperson, with a chart and an optional comparison month
Recurring Revenue Lines Every snapshot line of a month, for analysis in Excel
Recurring Revenue Movement The MRR bridge from opening to closing: new, reactivation, expansion, contraction, churn, with causes
Recurring Revenue Trend 12 or 24 months of MRR, ARR, customers, average revenue per account and growth; Split By a grouping (the seven largest and Other) or All for one line per period
Churn and Retention Customers and MRR at start, new, churned; logo churn, gross and net revenue retention, for all customers (Split By All) or per reseller, plan family, contract type or salesperson
Customer Cohorts Retention by start-month cohort: the share of each cohort's customers still paying, or of its first-month MRR retained, for 12 or 24 months since start, shaded as a heat map. A customer's cohort is the month its first subscription line started
Subscription Bookings New, reactivated, expanded, contracted and churned business per month, quarter or year, with MRR, ARR and term value booked, by salesperson, reseller, plan family or customer. Price increases, promotions, holds and reseller changes are not bookings
Plan and Add-on Mix Per plan family and plan: subscriptions, seats, MRR, MRR per seat, add-on attach rate
Create Subscription Contract Analysis (Microsoft) Takes the monthly snapshot that the reports above read

Forecasts

Report What it shows
Billing and Revenue Forecast What will be billed (by billing date) or earned (by service month) in the next months
Renewal Forecast Renewals by deadline month: current ARR, ARR at renewal with planned price changes, and ARR at risk

Finance

Report What it shows
Billed Ahead and Unbilled Month-end position per contract line: service billed in advance, and service delivered but not billed
Deferred Revenue Release Schedule Microsoft's unreleased contract deferrals by release month
Deferred Revenue, Current and Non-Current The deferred revenue balance on a date, split into what is released within the current period (default 12 months) and later, by contract, customer or contract type
Contract Value and Backlog Contract value of the current term, billed to date, and remaining value (backlog)
Subscription Margin Monthly revenue against monthly cost (vendor lines or item cost), margin and margin %, optionally after reseller commission
Subscription Customer Aging Receivables of subscription customers by contract, with MRR at risk
Revenue Allocation Schedule How each contract's price is allocated to its obligations by standalone selling price, with contractual, allocated and recognized revenue (Revenue recognition)
Revenue Waterfall The allocated revenue by month for the next 12 months and later, per contract or customer
Contract Asset and Liability The net position of every contract at a date: deferred revenue, allocation adjustments and unbilled revenue, split into contract asset and contract liability
Deferred Revenue Rollforward How deferred revenue and the allocation position moved in a period: opening, invoiced, released, adjusted, closing, per contract
Prepaid Balance Rollforward Prepaid balances in a period: opening, top-ups, usage, expiry, reversals, closing and the overage, for unearned revenue
Post Revenue Schedule, Create Revenue Allocations Batch jobs: post the revenue adjustments of the active allocations, and create the allocations of many contracts (Revenue recognition)
Customer and vendor contract deferrals analysis (Microsoft) Microsoft's deferral balances per contract

Pricing and promotions

Report What it shows
Price Increase Impact Revenue gained from price increases in a period, grouped by rule, index, customer or plan family (Group By)
Promotion Cost and Conversion Per promotion: redemptions, revenue given away, and customers still subscribed after it ended
Escalation Rule Listing Every rule with its method, limits, schedule, steps and the lines that use it
Price Index History Index values by month, with month-over-month and 12-month change

Resellers

Report What it shows
Reseller Statement The commission statement sent to a reseller, by end customer and contract
Create Reseller Statements Batch job: creates the statements up to a period end (Resellers)
Reseller Book of Business Report Each reseller's end customers with MRR and ARR for a month
Renewals by Reseller Upcoming renewal deadlines per reseller
Reseller Performance Per reseller: opening and closing MRR, new, expansion, contraction, churn, commission
Reseller Statement Register Statements by period with status, commission and payout document

Setup and migration

Report What it shows
Setup and Data Health Check Everything that will make billing, lifecycle or reports wrong, each with how to fix it (Troubleshooting)
Catalog Listing Plan families, plans and add-ons with their rules
Migration MRR Reconciliation Per migration batch, the source system's MRR against the MRR of the created lines, with the differences and the lines not created (Migration kit)

Limits

  • Recurring revenue history starts with Microsoft's first contract analysis snapshot. Months without a snapshot show as gaps.
  • Microsoft's own contract analysis pages and Power BI count open charge and credit lines as recurring revenue while they are open; Bitta Subscriptions' reports leave them out.
  • On very large books (20,000 contracts), whole-book reports with default filters take 5 to 9 minutes. Filter them or schedule them.
  • The Billing and Revenue Forecast leaves out one-off charges and credits from lifecycle actions.
  • Customer Cohorts shows n/a for months before Microsoft's first contract analysis snapshot (and, by revenue, for every month of a cohort whose first month has no snapshot).
  • Subscription Bookings counts the change between two monthly snapshots, so a change made and undone within one month is not booked. Term value runs to the line's Term Until; a line without one has no term value.

Next step

Ready to try Bitta Subscriptions?