top of page

Financial Reporting with Account Schedules in Dynamics 365 Business Central

Updated: Jul 18, 2022


Account Schedules is a module in Dynamics 365 Business Central that you can use to further analyze the financial data in the chart of accounts. It can help you to analyze the figures in the general ledger accounts or to compare general ledger entries with general ledger budget entries by Dimensions.


Business Value: The presentation of financial reports is an important part of how people consume them. Reports must provide business insights in a way that enables people to easily recognize the report and quickly identify the important data. In Business Central, account schedules are the main tool for creating user-defined financial reports. This release provides new capabilities for account schedules that make it easier for people to produce reports in the layout they desire.

Source: Microsoft


Feature Details

  • You can control how the number zero is printed (as "0", "-", or (blank)). When skipping zero-lines you can now keep Headers, Begin-totals, and End-Total in order to keep the schedules structure legible.

  • When you define account schedules, you can use G/L account categories as Totaling filter for columns.

  • The Account Schedules Overview supports 15 columns so that you can view budgets for 12 months and a total.

  • You can export and import account schedules to or from files, which makes it easier to reuse them between companies.

  • Headings (Begin-totals) are kept when printing to keep the structure of the account schedule. You can also choose to print lines marked as not to be shown, which makes validating the account schedules easier to do when you're designing them.

How to use it

  1. Type "Account Schedules" into the search bar and select the corresponding result.

Financial Reporting with Account Schedules in Dynamics 365 Business Central

2. Once on the Account Schedules page, select the “New” action to begin the process of creating a new schedule. Alternatively, you can select the “Copy Account Schedule” action.


Financial Reporting with Account Schedules in Dynamics 365 Business Central

3. Fill out all fields necessary. Once you get to the Default Column Layout field, you can select an existing layout. This can be edited later as needed.


Financial Reporting with Account Schedules in Dynamics 365 Business Central

4. In Process Menu, Select the “Edit Account Schedule” action.


Financial Reporting with Account Schedules in Dynamics 365 Business Central

5. Begin creating rows for the specific financial elements you want to have in the report.


Financial Reporting with Account Schedules in Dynamics 365 Business Central

6. In Related Menu, Select the “Overview” action to see a preview of the financial report based off of these specifications.


Financial Reporting with Account Schedules in Dynamics 365 Business Central

Financial Reporting with Account Schedules in Dynamics 365 Business Central

See Business Central's latest features in action.


We hope you find this new feature useful and interesting. Would you like to see other cool features available in Dynamics 365 Business Central's latest release? Comment below or book your personalized demo here.



Comentarios


bottom of page