A feature called Business Intelligence is used by
- Comparing actual v/s budgeted amounts
- Set up analysis views using dimensions
- Create analysis reports for sales, purchases, and inventory
- Establishing KPIs and analyzing financial performance
Budget V/S Actual Amount Analysis
This comparison of analyzing budget, actual amounts make use of G/L Budgets. These budgets can be seen by entering G/L Budgets in the search function. After opening the desired budget, there are filter fields at the top that allow for the definition of which data is shown. These actual and budgeted amounts can be viewed for all accounts by navigating to the Chart of Accounts page and selecting the G/L Balance/Budget action.
Analyzing by Dimension
It can be done through the ‘Analysis Views’ page of
Creating Analysis Reports
Analysis reports assist in the creation of customized reports on the records of transactions. It can be personalized to focus on key accounts to examine things like profits, sales, and turnover to then compare with previous months or years and calculate differences. This is all done within the same view and gives the ability to easily jump to areas that are posing problems. There are a few analysis reports templates that come with Business Central, but they can be further customized to fit each business’s individual needs.
Financial Reporting with Account Schedules
Account schedules are mainly used to help generate information of financial data stored into the pieces within the chart of accounts. They analyze data within G/L accounts and compare entries on the general ledger with G/L budgets. There are a few default accounts schedules that come with Dynamics 365 Business Central, but new columns and rows can be created to provide more customization and serve different functions like calculating profit margins by the department.