pic 1

An increasing number of companies are adding subscriptions as one of the revenue models to their business. Two different examples of this service include:

  • Netflix, which is a 100% subscription-based company focused on B-to-C, or business to consumers.
  • Microsoft, which originated in an era where software sold as one-time licenses, has today become an increasingly subscription-based software provider, with most of their software delivered in a software-as-a-service (SaaS) model using their Azure cloud.

As companies begin to adopt subscription-based revenue models for their customers, accounting departments and finance teams find themselves in a new struggle. Tasks that once were relatively easy in a world of “one and done” sales deals, like invoicing, reporting and analysis, and budgeting for various types of subscription contracts can now be quite complex and time consuming. On top of that, companies now have to deal with monthly, annual and multi-year subscriptions. Other challenges center around existing customers and adding to or removing from their contracts, as well as, customer churn (cancelled subscriptions), and other complexities.

However, today’s customers using Microsoft’s two cloud accounting systems, Dynamics 365 Finance and Dynamics 365 Business Central are in luck. A Canadian software vendor by the name of Binary Stream has developed an add-in module called “Subscription Billing Management” (SBM), which in short allows accountants to elegantly manage their subscription contracts right within their Dynamics ERP system.

So, What About the Reporting, Budgeting and Forecasting for Subscription Data?

In collaboration with Binary Stream, the U.S.-based company, Solver, has expanded its Microsoft Dynamics 365 Finance and Dynamics 365 Business Central integrations to include key information from Binary Stream’s Subscription Billing Management app.

Solver is a modern Microsoft Azure-based, multi-tenant cloud solution that automates and streamlines reporting and planning processes. It is often referred to as a Corporate Performance Management (CPM) solution.

With Solver integrated to the Dynamics ERPs, as well as the Binary Stream app, customers benefit from financial and operational reporting that includes their subscription data, all in one single cloud portal. Furthermore, they can use Binary Stream SBM’s subscription data as a basis for single and multi-year revenue forecasts.

What are Examples of Subscription Reports and Budgets?  

The following are examples of specific reports and budget input forms created in Solver and based on actual subscription data flowing in from the integration available through Binary Stream’s SMB for Microsoft Dynamics app.

This first example shows a multi-year forecast going up to 10 years into the future. Based on the drivers seen in the yellow cells in the top left corner, the user can quickly generate monthly and annual subscription revenue forecasts.

Multi-year subscription revenue and churn budgeting and forecasting with monthly detail

Multi-year subscription revenue and churn budgeting and forecasting with monthly detail

When it comes to reporting, a flexible report writer like the one in Solver, can provide a multitude of report types to slice and dice subscription related data by metric, customer, and product.

The report below shows monthly recurring revenue (MRR) with metrics for new sales, upgrades/downgrades and churn. It also shows the monthly trend for the ending MRR.

Dashboard analysis of subscription metrics like MRR and Churn

Dashboard analysis of subscription metrics like MRR and Churn

The report below shows a chart and data on an eight-quarter rolling basis. This makes it easy for users to analyze subscription revenue over multiple years. Any individual quarterly column can be expanded to display detail for the three underlying months.

Eight quarter rolling subscription revenue report with monthly detail

Eight quarter rolling subscription revenue report with monthly detail

The Scheduled Billing report example seen below can be run for any given period. It helps accountants see the specific payment status per invoice per customer, including total, balance, deferred and recognized amounts.

Scheduled billing report showing recognized and deferred revenue per customer

Scheduled billing report showing recognized and deferred revenue per customer

Sometimes the finance team needs to analyze deferred revenue by customer. The example below shows deferrals by month for the remainder of the current year and then displays the summary for the next three years into the future.

Multi-year deferred revenue by customer report for the next three years

Multi-year deferred revenue by customer report for the next three years

In conclusion, as a company with a subscription-driven business model, you have a solid cloud-based accounting system with Microsoft Dynamics Finance or Dynamics Business Central. When adding Binary Stream’s app for Subscription Billing Management, you get a specialty add-in that is completely focused on helping you manage your subscriptions. By connecting Solver’s cloud-based reporting and planning solution, you now have a best-in-class suite to not only help with day-to-day accounting and analysis, but can also keep a keen eye on the future with world-class budgeting and forecasting functionality.

LOS ANGELES, CA. – August 5, 2020 – Solver, ranked among the highest rated companies in cloud-based Corporate Performance Management (CPM) for customer satisfaction by G2, announced its partnership with Binary Stream, a Gold Enterprise Resource Planning Partner Independent Software Vendor (ISV) delivering scalable software solutions simplifying company processes, such as subscription billing automation for Enterprise Resource Planning (ERP) customers.

Solver and Binary Stream have partnered to integrate Solver’s cloud-based CPM application with Binary Stream’s enterprise-grade software solution to offer customers a pre-configured integration and pre-built report templates.  With this partnership, Microsoft Dynamics 365 Business Central customers using Binary Stream’s Multi-Entity Management and Subscription Billing Management apps can now use Solver to create professional grade reports across all of their data.

The integration enables quick loading of dimensions and data from Binary Stream’s tables in Microsoft Dynamics 365 Business Central. The report templates include more than 10 different layouts.  Subscription Billing Management reports include: Churn Analysis; MRR; Monthly revenue per product/customer; Eight quarter rolling subscription revenue trend; Scheduled billing; invoiced vs. recognized amount; Deferred revenue current year and next three years; and Subscription revenue forecasting. A report example is shown below:

Press Release Binary Stream Image 1

For Multi Entity Management, reports include: Consolidating P&L; and Multi-company benchmarking. An example of this report is shown below:

Press Release Binary Stream Image 2

By partnering together for this integration, Solver and Binary Stream are focusing on delivering rapid time-to-value for Microsoft Dynamics 365 Business Central customers looking for advanced cloud-based financial and operational reporting. Budgeting and Forecasting is also provided as an option.

“Our relationship with Binary Stream goes back many years. In fact, Solver is one of their customers. In this project, engineers from both companies collaborated together to configure the integrations and to discuss reporting ideas,” says Nils Rasmussen, CEO at Solver. He continues, “Our mutual goal is to enable faster and better decisions for our joint customers by making it faster and easier to deploy our cloud products together with Microsoft Dynamics 365 Business Central.”

Lak Chahal, President and CEO at Binary Stream added, “We are excited to collaborate and innovate in digital transformation with Solver, and to jointly offer Microsoft Dynamics 365 Finance and Dynamics 365 Business Central users with a streamlined way to access clearer insights and make better business decisions regardless of the complexity of their underlying processes and data.”


About Solver

With a quickly growing community of thousands of global customers and hundreds of partners worldwide, Solver provides a leading cloud Corporate Performance Management suite for Microsoft Dynamics 365 Finance and Business Central, Acumatica, SAP Business One, SAP ByDesign, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, NetSuite and other ERPs. Solver is ranked in the leader quadrant in the Corporate Performance Management (CPM) Software Grid on G2, Solver is also the overall Leader in Customer Experience Model in 2020 Dresner Wisdom of Crowds® Enterprise Performance Management Market Study and as a Microsoft Gold ISV Partner, Solver has won countless awards, including the Microsoft BI Partner of Year Award, recognition on the Gartner Group CPM Magic Quadrant, and Best Places to Work for a workplace culture that celebrates customer service, integrity, and innovation. Solver was named best in class for consulting continuity in Dresner’s Wisdom of Crowds EPM market report.  Solver is sold through its 12 global offices and a worldwide network of partners. For any questions, visit or contact Solver at


About Binary Stream

Binary Stream is a Gold-Certified Microsoft ISV developing innovative solutions for digital transformation within both cloud and on-premise Microsoft Dynamics ERPs. Binary Stream’s award-winning solutions help streamline various business processes involving consolidation accounting, subscription management, property lease management, and healthcare supply chains. Being directly-embedded within the core platform, Binary Stream solutions extend the functionality of Dynamics 365 Finance, Dynamics 365 Business Central, and Dynamics GP.

With over 20 years of experience, Binary Stream continues to help organizations scale their businesses with robust functionality tailored to the finance, healthcare, real estate, manufacturing & distribution, and software industries. Over 2,000 organizations around the world trust Binary Stream to manage their financial processes with confidence and ease, while gaining the flexibility they need to cater to their customers. Backed by superb sales, development, implementation, and support teams, Binary Stream enables Microsoft Partners to provide their clients with future-proof solutions by building reliable, trust-worthy relationships. For any questions, please visit or contact Binary Stream at