fbpx Skip to content

Reporting in Dynamics 365 Business Central: What You Need to Know

insightsoftware -
May 9, 2018

insightsoftware is a global provider of reporting, analytics, and performance management solutions, empowering organizations to unlock business data and transform the way finance and data teams operate.

Blog Business Central Need To Know

Although relatively new to the market, Microsoft Dynamics 365 Business Central is making waves amongst small to midsized growing businesses around the world. Microsoft’s newest cloud ERP product is touted as the “all-in-one” business management solution and has been equipped with the latest technology to manage financials, automate the supply chain, and optimize operations. But like nearly all the Microsoft Dynamics ERPs before it, Business Central claims to have all the native reporting functionality required to meet the financial management needs of small businesses, which we are going to evaluate in this post.

Learn more about the basics of Business Central
and what it means to the Dynamics community here

As any controller, bookkeeper, financial manager, accountant or business owner would know, solid financial reporting is essential to proper business function and can serve as the foundation for growth. Business Central comes with out-of-the-box reporting features, including Account Schedules, Microsoft Excel report templates, RDL (using Visual Studio or Microsoft SQL Server Reporting Services SSRS), custom XML in Word, and Power BI with Business Central content packs for basic Finance, Sales and CRM. These tools will give you access to the data you need to chart financial performance, analyze data and forecast trends – but you need experienced, technical resources to get you there.

The purpose of financial reporting is to provide easy to understand information about your company’s financial performance, which can then be turned into actionable decisions. Even with all these tools available, Business Central has some significant limitations within its reporting and analytics capabilities that will directly impact your ability to easily create the financial reports you need and make informed decisions. Here are 4 reporting challenges in Business Central you need to be aware of:

  1. Report Formatting
    No matter what size business you run, the ability to format reports to your company standards, personal preference, or the requirements of external agencies (such as banks) is extremely important for visibility, compliance, and efficiency. Business Central comes with only 6 pre-defined Excel reports to analyze your financial statements, with little-to-no room for customizations. To address that, Business Central also has Account Schedules, but these are rigid row/column structured reports created using propriety codes and formulas within the Business Central application itself. So, with no ability to change report formats without an experienced developer, most users are forced to export their reports and manually format them to meet their needs – which introduces redundancy and inaccuracies, and kind of defeats the purpose of an agile, all-in-one system.
  2. Data Accuracy
    Did you know that 9 out of 10 financial spreadsheet reports contain significant errors from human mistakes? The inability to dive deep into your numbers and being forced to rely on manual data entry equates to billions of dollars lost around the world. With that being said, Business Central connects data across accounting, sales, purchasing, inventory, and customer interactions to help automate this process and see financial performance in real-time. However, it doesn’t actually give you the ability to see the underlying details behind every number because you end up having to export and manipulate the Excel spreadsheet manually, which not only causes duplicate work and more errors, it disconnects you from the details behind the numbers.
  3. Consolidated Reporting Across Multiple Companies
    This might be news to some, but the native Business Central user reporting can only manage one company at a time and has a limited number of dimensions you can report on. For businesses with single entities and basic needs, this shouldn’t pose a problem. But for others, this complicates financial data consolidation and results in the same time-consuming manual processes you were struggling with before.
  4. Technical Expertise Required
    Change is always hard when introducing a new system to your clients and staff – but it doesn’t mean you should have to pay for developers and technical experts to create or modify financial reports. Although Business Central has strong Microsoft reporting tool compatibility that can address some of the needs that aren’t accessible through the user-based, in-app reporting, they aren’t user friendly without extensive training and experience. For instance, RDL reports allow you more options with formatting and accessing multiple companies but require advanced Visual Studio or SSRS Report Builder skills in order to set up. To be efficient and make data work for your business, reporting needs to be something that every member of your finance and management team should be able to create, modify, and share on their own.

Whether you are looking to move accounting software or bring your Dynamics ERP system to the cloud, there’s a fast and easy way to fill the reporting gaps in Business Central. Jet Reports Financials is a financial reporting tool available for download through Microsoft AppSource that allows you to build and run custom financial reports, directly in a tool that everyone already knows how to use – Excel.

With Jet Reports Financials, you can:

  • Create unlimited financial reports, in any format desired
  • Access more useful, adaptable templates you can use immediately (Ex. Executive Overview and Account Comparison)
  • Dynamically use any Excel functionality in your reports like charts, formulas, and images
  • Drilldown on any value in an Excel report back to the transactions in Business Central
  • Refresh reports dynamically, directly inside of Excel
  • Consolidate financial reporting from multiple companies, with unlimited Dimensions
  • Get users up and running immediately with an intuitive wizard

Get more visibility into your financial business performance by extending the reporting capability of Dynamics 365 Business Central with Jet Reports Financials. With multiple companies and dimensions for consolidations, external data input and calculations, and adaptable report formatting directly inside Excel, your users will be able to easily create the reports they need in record time.