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
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.
Filter by Category or Audience. Report Details on the right describes the selected report and its
layouts.
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.
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.