Edit

Customer Deferrals (Power BI Report)

The Customer Deferrals report provides a comprehensive overview of revenue that was invoiced but not yet recognized. It allows users to track deferral balances and recognition schedules, helping you understand the timing of future revenue and ensure accurate financial reporting of your subscription-based liabilities.

Screenshot of the Customer Deferrals report.

Use the report

The report is meant for financial managers and accountants.

Financial managers can use this report to gain visibility into the company’s future revenue recognition. By analyzing the bar chart, which visualizes the balance between deferred and released (recognized) revenue over time, you can accurately forecast how and when billed amounts affect your profit and loss statement. This forecast helps align cash flow expectations with actual financial performance.

Accountants can use the report to ensure the accuracy and integrity of the deferral accounts. The detailed table provides a breakdown of released and deferred amounts by year and month, making it easy to perform period-end reconciliations.

Specifically, you can use this report to verify that all deferred revenue is being released correctly. By looking at previous months, you can quickly identify whether you have "open" deferred revenue that you should recognize. This information ensures that your financial statements are complete and that no revenue is mistakenly held on the balance sheet beyond its service period.

Key performance indicators

Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Data used in the report

The report uses data form the following tables in Business Central:

  • Customer Subscription Contract Deferrals

Track your business KPIs with Power BI metrics
Setting up the Subscription Billing Power BI app
Subscription Billing controlling
Subscription Billing overview