BeyondERP.Newsletter
Menu

Inquiry page · Subscription billing

Unbilled revenue reconciliation

A report page that calculates the unbilled revenue of the billing schedules as of the date you enter, with schedule, currency, customer and end user.

Business process
Bill subscriptions
Menu item
SubBillUnbilledRevenueRecon
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report page that calculates the unbilled revenue of the billing schedules as of the date you enter, with schedule, currency, customer and end user.
What you do hereUse this page to reconcile the unbilled revenue balance per billing schedule with the unbilled revenue account in the general ledger at period end.
ExampleFor example, at 30 June a BEAT accountant runs it as of 30 June and finds 750.00 still unbilled on a 250.00-a-month schedule whose first nine months were stubbed.
Unbilled revenue reconciliation page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage accounts receivable › Bill subscriptions
Menu pathSubscription billing › Recurring contract billing › Inquiries and reports › Unbilled revenue reconciliation
Set up firstUnbilled revenue mass processing Microsoft Learn
Used next byGenerate invoice Microsoft Learn
Related pagesUnbilled revenue setup Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Read Unbilled revenue reconciliation for the right dates

Use this page to reconcile the unbilled revenue balance per billing schedule with the unbilled revenue account in the general ledger at period end.

Steps from Microsoft

  1. Go to Subscription billing > Recurring contract billing > Inquiries and reports > Unbilled revenue reconciliation.
  2. In the Calculate unbilled revenue reconciliation dialog, enter the As of date, such as the last day of the period you reconcile.
  3. Select OK to calculate the unbilled revenue balances and show them on the page.
  4. Compare the total with the unbilled revenue account: the initial journal entry debits unbilled revenue, and each invoice moves the amount to accounts receivable.
  5. For a difference on one line, open Unbilled revenue journal entry audit on the Renewals tab of the line details.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
As of dateThe date the unbilled revenue balances are calculated for.Checked in Dynamics 365
Billing schedule number / DescriptionThe billing schedule.Checked in Dynamics 365
CurrencyThe currency of the schedule.Checked in Dynamics 365
Customer account / Customer nameThe customer of the schedule.Checked in Dynamics 365
End user account / End user nameThe end user of the contract.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
The report page shows no lines after OKThe page only lists billing schedules in the dates you entered. Widen From date and To date, and check that the schedules aren't archived; archived lines no longer appear on inquiry pages. Microsoft Learn
Unbilled revenue doesn't reconcile with the invoices after top billingTop billing and unbilled revenue don't work together. Set Number of top lines to 0 on every item group that has unbilled revenue items. Microsoft Learn
The invoice for an unbilled revenue line has nothing to reverse from unbilled revenueCreate the unbilled revenue journal entry before invoicing, with Create journal entry on the line or on Unbilled revenue mass processing. Microsoft Learn

Test checklist

  1. Run the page as of 30 June.
  2. Check: The schedule shows 750.00 unbilled.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Read Unbilled revenue reconciliation for the right datesThe last day of the fiscal period, run after the period's invoices are posted.Invoices move amounts out of unbilled revenue, so the balance agrees with the ledger only when all of the period's invoices are posted.When is unbilled revenue reconciled?Reconciling before all invoices of the period are posted, or with top billing on, which breaks the reconciliation.Test: Unbilled balance after stubbing

Feature management and licence

Feature to turn onSubscription billing (Must be on)Recurring contract billing (Must be on)
Licence or add-inTurn off the Revenue recognition feature first: Subscription billing can't be used while it is on. Then, in Feature management, turn on Subscription billing and after it Recurring contract billing. Revenue recognition was deprecated in January 2024 and replaced by Subscription billing. Subscription billing users and managers can open this page.

Microsoft Learn

Solution architect

5Design impact

Can it be undoneReversible: The page only reads billing schedules; running it again with other dates changes nothing. Microsoft Learn
If you change it laterThe page calculates from the unbilled revenue entries each time; it changes no data. Microsoft Learn
Technical architect

6Technical

Menu itemSubBillUnbilledRevenueRecon Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itSubscription billing manager SubBillBillingMaintainSubscription billing allocation, deferral, and billing manager SubBillMaintainSubscription billing user SubBillBillingViewSubscription billing module user with capabilities including billing, allocation, and deferral features SubBillViewGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SubBillUnbilledRevenueRecon
Data migrationLoad order: Unbilled revenue reconciliation has no data entity in Data management, so there is nothing to load from a file or a configuration template. It is calculated from the billing schedules when you run it, so load the billing schedules and run the page in the new environment.Microsoft Learn
Everyone

8Sources