The main source of financial reporting is the main accounts. The components of financial reporting include a balance sheet, income statement, trial balance, cash flow, and more. The normal scenario is that the main account's balances do not mean much when it comes to analysis. This is because it is a total of the posted transactions' amounts, and it is required to be able to dig into this total breakdown. In other words, it provides us with information on how this amount is allocated, for example, among business units and departments. This allocation gives the lowest level of analysis to break down the same balance for a main account by more than one dimensional perspective.
The following diagram shows the financial dimension allocation for the main account:
Financial dimensions provide us with a deeper analysis of the transactions posted on the general ledger accounts, where it gives the controller an analytical view of the transactions that occurred on the expenses account. For example, you can analyze the account balance according to the financial dimensions assigned to the main account.
The Microsoft Dynamics 365 for Finance and Operations financial dimension allows an organization to reach the lowest level of breakdown and analysis. There are three main standpoints to consider while discussing the financial dimension:
- The first standpoint is the required breakdown analysis for each main account in the chart of accounts, in order for it to be utilized at the reporting level.
- The second standpoint is the controls and validations while doing the data entry, in order to certify that the keyed-in transactions are allocated to the required dimensions before the transaction is posted. This directly affects the accuracy of reporting.
- The third standpoint is the reconciliation between the sub-ledger and the general ledger, and the ability to break down the balance using the sub-ledger (customers, vendors, items, banks, and more).
These standpoints are shown in the following diagram:
The role of the Microsoft Dynamics 365 for Finance and Operations consultant is to clarify the best usage of financial dimensions to the concerned parties. The key process owners who ascertain the financial dimensions' requirements are the Chief Financial Officer (CFO) and the financial controller. The three main standpoints of financial dimension can be summarized as follows:
- Reporting and analysis: This is used to identify reporting needs and data entry results
- Data entry controls and validations: This is used for data entry filtration
- Sub-ledger and general ledger reconciliation: This is used for reconciliation of transactions between the sub-ledger and the general ledger
The implementation team ascertains the financial dimensions' requirements during the analysis phase to understand what the business needs are at the reporting and analysis stages, and then identifies the required number of financial dimensions and how to utilize these dimensions.
Microsoft Dynamics 365 for Finance and Operations supports an unlimited number of financial dimensions.
According to the business domain, every business needs to build the structure of their chart of accounts and financial dimensions. They also need to identify which sub-ledger should be tracked at the general ledger level. To build the structure of the chart of accounts and financial dimensions, follow these steps:
- Classify the required dimensions for each main account, verifying whether it is mandatory or optional
- Categorize the financial dimensions that are interrelated and are dependent on each other to filter dimensions based on the previously selected value
- Categorize the intra-related dimensions; these are not dependent on the previously selected dimension
Microsoft Dynamics 365 for Finance and Operations supports the use of the existing sub-ledger master data to define financial dimensions. The following diagram illustrates the usage of financial dimensions:
The heart of a financial dimension is the chart of accounts, as shown in the previous diagram. It should be carefully structured and set to the required dimension validation of each main account. It is important to consider this structure of the chart of accounts and dimensions' validation in the opening balance upload, as it will affect reporting and analysis, in addition to an automatic transaction, such as the exchange rate adjustment, and inventory recalculations.