fbpx Skip to content

How Do Dynamics 365 Business Central Account Schedules Compare to Jet Reports Financials?

insightsoftware -
May 29, 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 Post D365 Account Scheduled

For businesses looking for an upgrade in financial management, the highly anticipated release of Microsoft Dynamics 365 Business Central is no doubt a cutting-edge advancement for cloud-based ERP solutions available to—and built for—small- to medium-sized businesses. The Business Central finance module offers diverse and robust functionality, including general ledger, allocations, reconciliations, payment handling, fixed assets, and bank account management, to name just a few.

Also, in the utility line up are Account Schedules, a tool used directly inside the Business Central application for standard and custom financial reporting. As controllers, accountants, bookkeepers, and CFOs address their needs for “getting data out,” many are left with questions on whether or not Account Schedules will be enough, and how they compare to Jet Reports Financials, the first—and currently only—third party financial reporting solution built for Business Central and available in AppSource.

In this post, we are going to provide a general overview and cover the differences between Account Schedules and Jet Reports Financials by looking at the main components and distinctions between these two solutions through: configuration, formatting/report layout, consolidations, templates, and a high-level comparison chart.

What Are Account Schedules?

Account Schedules are used to get visibility into the financial chart of accounts data that resides inside Business Central in order to obtain reports like income statements, balance sheets, or cash flows. Account Schedules aren’t as new as Business Central itself. Since Business Central is built from Microsoft Dynamics NAV, those who are familiar with or have had experience with NAV may know how to use Account Schedules already. Account Schedules are accessed and used directly inside the Business Central application, so it relies on propriety code, layout, and formulas for creating reports.

Business Central delivers some sample account schedules, so you can use those templates or set up your own rows and columns. For example, you can create account schedules to calculate profit margins on dimensions like departments or customer groups. While you can create as many account schedule financial statements as you want, Account Schedules are confined to being inside Business Central unless (or until) manually exported to Excel using an export option.

What is Jet Reports Financials?

Jet Reports Financials is insightsoftware’s third party reporting solution built for Microsoft Dynamics 365 Business Central that provides a simple and easy way to create and run financial reports directly inside of Excel. This delivers an interface much more familiar to finance professionals, where they are often exporting or copying and pasting. Don’t misinterpret the “third party” label, though. Jet Reports Financials is available in Microsoft AppSource, where Dynamics 365 in-app integrations go through rigorous testing and vetting by Microsoft before being authorized for availability. Which means you can be confident that this reporting solution has top level performance and it addresses a need from Business Central users. Jet Reports Financials is also built by and from the same insightsoftware Jet Reports solutions relied on by more than 154,300 Microsoft Dynamics users globally.

From directly in Excel, Jet Reports Financials brings the ability to drag and drop any combination of chart of accounts, dimensions, and companies to instantly see account balances and create financial statements in the format users want. This brings with it the benefit of maximizing resources, decreasing risk, and lifting Business Central’s native reporting limitations by giving users the ability to build reports on their own without technical expertise, eliminating manual reporting tasks and extending visibility on financial data.

Comparing Accounts Schedules and Jet Reports Financials

Configuration:

When using Account Schedules in Business Central, a user must understand how to define both the row and the column layouts. The row layouts are specific to each account schedule and the column layouts can be created and reused with different account schedules. Not only is there a learning curve with this, mistakes can be hard to troubleshoot and result in unexpected numbers being displayed in the report. Here is an example of what is required to configure rows in an account schedule:

Configure Rows in D365 Business Central

In addition, to show anything other than just the net change, a user will need to create a number of column definitions. This involves using proprietary formulas. For example:

  • <Blank> = Current period
  • -1P = Previous Period
  • -1FY[1..LP] = Entire previous fiscal year
  • -1FY[CP..LP] = From current period in previous fiscal year to last period of previous fiscal year, inclusive

There are more of course, but you get the idea. This isn’t the most intuitive approach to report writing.

Alternatively, with Jet Reports Financials, users can simply put the accounts in the rows that they want and use the familiar Excel date formatting, functions, and formulas they already know to build out column headings and perform calculations that will dynamically update every time a report is refreshed to the real-time data from Business Central.

Check out this video to see how reports are easily set-up in Jet Reports Financials.

Image2
The Fast Financials report building wizard in Excel with Jet Reports Financials.

Report Layout:

Within Business Central’s Account Schedules, there is quite a bit of limitation in terms of how your report can look. There is no way to do things like add a logo, for example. Many users will end up running their account schedule, exporting it to Excel, and then spending needless time each month to format it and make it look appropriate for distribution to business stakeholders. Here is an example of the standard income statement that ships with Business Central:

Business Central Income Statement

With Jet Reports Financials, all of the formatting is handled inside of Excel so any logos, corporate color schemes, charts, PivotTables, and account layouts are just as easy to include or apply as any spreadsheet. This even allows users to get scorecard or dashboard type report formats and summaries of the financial data. Plus, the formatting only needs to be created and applied once. The report can then be easily re-run or refreshed on demand and all the formatting will remain or dynamically update, as the case would be with charts or graphs.

Jet Reports Financials income statement

Drill down:

Although drill down is available on an account schedule when it’s inside Business Central, Account Schedules do not support drill down from Excel. As is evident by the current use of Account Schedules in Dynamics NAV, most companies are going to need to export their account schedule to Excel in order to format it appropriately. Once it’s there, users won’t have the ability to get back to the numbers and details that compose the report.

With Jet Reports Financials, the functions used to build the report in Excel fully support drill down and drill-back to the Business Central web client. So, users can click a number on a monthly income statement, for example, and immediately get directly to the transaction details that make up this number.

Drilldown in Excel
Drilldown in Excel on Jet Reports Financials reports to transaction details inside Business Central

Consolidations:

Account Schedules in Business Central are composed per company and limited to these individual entities. There is no way to do one account schedule across multiple companies without a dedicated consolidated company set up in Business Central. Doing this requires a ton of extra development work and maintenance for the sheer purpose of consolidated financial reports. Not only does this introduce unnecessary added costs, it introduces risk in that consolidated company being accurate, and decreases the flexibility of the consolidation output. For example, you would always have to run the report for all the companies at once, you could not parse them out.

Jet Reports Financials, on the other hand, seamlessly allows consolidations across any combination of company entities, without the need to set up a consolidation company in Business Central. This is imperative for any organization running multiple companies in Business Central because it enables the flexibility to produce the financial consolidations required.

Jet Reports Financials Consolidated Income Statement
Consolidated Income Statement in Jet Reports Financials

Templates:

Account Schedules deliver a few sample standard reports and column layouts in Business Central. You can change some filters applied to them, such as dates/periods, department, standard dimensions, or budget, and change the column layout and calculations used. Remember, account schedules are driven by defined row/column layouts. You can modify these templates by adding new rows, but it’s important to note that you cannot copy the account schedule templates—or any account schedule for that matter—and make different variations:

Standard account schedules:

  • Balance Sheet
  • Cash Flow Statement
  • Income Statement
  • Retained Earnings


Standard column layouts (that will affect the report results):

  • Periods
  • Balance
  • Net Change
Example of standard account schedule: Income Statement
Example of standard account schedule: Income Statement

Jet Reports Financials delivers eight standard, modifiable reports out-of-the-box. This includes some reports that cannot be created with native Business Central reporting. All the template reports within Jet Reports Financials are completely customizable, and like any other report created with Jet Reports Financials, they can be copied an indefinite number of times to create unlimited variations. This capability has an extreme time saving advantage from Account Schedules, where you must completely start from scratch each time you want at new variation of a report, costing users hours of time and productivity.

Standard Jet Reports Financials Reports:

  • Executive Overview and Scorecard
  • Trial Balance
  • Expenses by Dimensions
  • Income Statement by Company
  • Income Statement Last Year and Budget
  • Income Statement by Month
  • Balance Sheet
  • Cash Flow Statement
Jet Reports Financials standard templates
Jet Reports Financials standard templates: Executive Overview and Income Statement by Month

See how to modify Jet Reports Financials sample reports here.

Comparison Chart:

Here is a high level comparison chart of Account Schedules vs. Jet Reports Financials for Microsoft Dynamics 365 Business Central:

Account
Schedules

Jet Reports
Financials

Environment/Interface
Business Central
in-app
Excel
Available
Native
Microsoft AppSource
Report Configuration and Calculations
Proprietary row/column functions, limited codes and formulas
Checkbox-based wizard and unlimited Excel formulas
Layout and Formatting
Controlled in-app, simple format, no branding
Flexible, Excel formatted,
open branding
Consolidations
Not
available
Unlimited company consolidations and entity filter combinations
Drilldown
In-app only
From Excel
Excel
Export
each time
Integrated – reports refreshed dynamically inside Excel
Report Variations
Must rebuild reports/account
schedule for any variations
Any report can be modified and copied to create different variations
Included Templates/Layouts
4 account schedule reports, 3 column layouts
8 customizable reports, including Executive Overview
Learning Curve
Medium-High
Low

Even though Microsoft Dynamics 365 Business Central is certainly a step ahead in cloud-based business management, it isn’t immune to the long legacy of ERP solutions across nearly every platform in a lack of delivering flexible and easy-to-use financial reporting out-of-the-box. Microsoft doesn’t disappoint on providing a user friendly and robust system for putting the business data in and enforcing operational and financial processes, but continues its tradition in relying on third-party options for the ability to deliver best of breed technology in areas like reporting.

Jet Reports Financials by insightsoftware offers accurate answers in a more flexible format to increase reporting efficiency. When implementing or moving to a new ERP like Business Central, it’s important to prioritize, giving finance users the reporting and data intelligence tools they need to effectively reduce risks, boost visibility, and get the answers at a moments’ notice. Best of all, there is absolutely zero risk in trying it out. You can download Jet Reports Financials as a free trial 30-day trial directly from AppSource now!

Try Jet Reports Financials for Free Now