Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article describes where to access financial reporting and how to use the financial reporting capabilities. It also includes a description of the default financial reports that are provided.
Note
Financial reporting is now available through an add-in. Therefore, the default availability of Financial reporting through Microsoft Dynamics 365 Finance has changed. If you're an existing customer, Microsoft provides the new Financial reporting add-in in your Microsoft Dynamics Lifecycle Services environment. If you're currently using the Financial reporting module, there's no impact on your environments or your organization's ability to run financial reports.
Install the Financial reporting add-in
The Financial reporting add-in lets financial and business professionals create, maintain, deploy, and view financial statements. Financial reporting includes dimension support. Therefore, account segments or dimensions are immediately available. No additional tools or configuration steps are required after installation.
You can get the Financial reporting add-in as a Dynamics 365 app in Power Platform admin center for supported Dynamics 365 Finance and Operations environments. Availability depends on the environment's cloud, geographic region, and applicable Dynamics 365 Finance entitlement. You enable the add-in through the applicable Finance and Operations application bundle.
In public cloud, the Financial reporting add-in is available in the following geographies:
- Asia Pacific
- Australia/Oceania
- Brazil/South America
- Canada
- Europe
- France
- India
- Japan
- North America
- Norway
- South Africa
- Switzerland
- United Arab Emirates
- United Kingdom
Availability will expand to more geographic regions and sovereign clouds as required platform dependencies become available.
Power Platform admin center (Recommended)
- Go to Power Platform admin center.
- Select Environments, and then select your environment.
- Under Resources, select Dynamics 365 apps.
- Select Install app.
- Search for and select Microsoft Dynamics 365 Financial Reporting.
- Review and accept the legal terms and privacy statement.
- Select Install.
Lifecycle Services (Legacy)
Alternatively, for Lifecycle Services-managed environments:
- In Lifecycle Services, confirm that Power Platform integration is configured and available.
- Select Install a new add-in, and search for Financial reporting.
- Agree to the terms, and then select Install.
If Microsoft Dynamics 365 Financial Reporting isn't available, confirm that the environment is in a supported geography and that the tenant has the required Dynamics 365 Finance entitlement. If the app still isn't available or installation fails, contact Microsoft Support with your environment ID, region, and error message.
Uninstall the Financial reporting add-in
Important
If you uninstall the Financial reporting add-in, you remove resources that are used for Financial reporting. This action permanently deletes any previously created reports, report designs, and configurations. Recovery isn't supported.
- In Lifecycle Services, find the Financial reporting add-in in the Environment add-ins section under Power Platform Integration.
- Select Uninstall and then Agree.
Accessing Financial reporting
You can find the Financial reporting menu in the following locations:
- General Ledger > Inquiries and reports
- Budgeting > Inquiries and reports > Basic budgeting
- Budgeting > Inquiries and reports > Budget planning
- Budgeting > Inquiries and reports > Budget control
- Consolidations
To create and generate financial reports for a legal entity, set up the following information for that legal entity:
- Fiscal calendar
- Ledger
- Chart of accounts
- Currency
- Post a transaction to at least one account
- MainAccount is listed in the Selected column on the Financial reporting setup page (General ledger > Ledger setup > Financial reporting setup)
Granting security access to Financial reporting
The financial reporting functions are available to users who have the appropriate privileges and duties assigned to them through their security roles. The following sections list these privileges and duties, together with the associated roles.
Duties
| Duty label | Description | AOT name |
|---|---|---|
| Maintain financial reporting security | Maintain financial reporting security and perform administrative tasks. | FinancialReportsSecurityMaintain |
| Maintain financial reports | Design and maintain financial reports. | FinancialReportsMaintain |
| Generate financial reports | Generate and refresh financial reports. | FinancialReportsGenerate |
| Review financial performance | Review and analyze financial performance. | FinancialReportsPerfReview |
Privileges
| Privilege label | Description | AOT name |
|---|---|---|
| Maintain financial reporting security | Maintain financial reporting security and perform administrative tasks. | FinancialReportsSecuritySystemMaintain |
| Maintain financial reports | Design and maintain financial reports. | FinancialReportsMaintainReports |
| Generate financial reports | Generate and refresh financial reports. | FinancialReportsGenerateReports |
| View financial reports | View financial reports. | FinancialReportsView |
Roles
| Privilege label | Duty | Roles |
|---|---|---|
| Maintain financial reporting security | Maintain Financial reporting security | Security administrator |
| Maintain financial reports | Maintain financial reports | Accounting Manager, Accounting Supervisor, Financial Controller, Budget Manager |
| Generate financial reports | Generate financial reports | CEO, CFO, Accountant |
| View financial reports | Review financial performance | None assigned |
After you add a user or change a role, the user can access Financial reporting within a few minutes.
Note
The sysadmin role is added to all roles in financial reporting.
Report deletions and expirations
Users who generate a report can delete their own reports. Users with the Maintain financial reporting security duty can delete other users' reports.
The Financial report retention policies feature contains the following changes:
Newly generated reports are automatically marked as having an expiration date of 90 days from when they're generated.
Any existing reports from before the feature was installed are given a 90-day expiration period. The date might show as blank for a short period of time until the Financial reporting service is running, a report is generated, and the service performs the update to existing reports with a blank expiration date.
Users with Maintain financial reporting security have access to this functionality. Any user in the Maintain financial report duty granted the Maintain financial report expiration privilege also has the ability to modify the expiration period. Currently, two retention options are available:
- An expiration of 90 days.
- An option to set the report to never expire.
When you select an expiration, such as 90 days, you apply it 90 days from today. This behavior differs from the 90 days from the original generation date set when the report was generated.
Additional options will be considered in future functionality. The expiration of 90 days is the default, and users with appropriate permissions can override the default on the Financial reports list page.
Historical accuracy after transaction edits
Beginning with Financial reporting release 10.0.45, fact versioning was removed from the Financial reporting database (MRDB). When you rerun or drill into a previously generated report, the detail is recalculated using the current transaction data. If the underlying transaction was edited after the original report was produced, drill-down lines might differ from the original snapshot. Top-level balances in the saved report don't change.
Note
To create an immutable audit copy, export the report to Excel or PDF when you finalize it.
Historical accuracy after transaction edits
Starting with Financial reporting release 10.0.45, the Financial reporting database (MRDB) no longer supports fact versioning. When you rerun or drill into a previously generated report, the detail recalculates by using the current transaction data. If someone edits the underlying transaction after you generate the original report, the drill-down lines might differ from the snapshot you first saw. The top-level balances in the saved report don't change.
Tip
To create an immutable audit copy, export the report to Excel or PDF when you finalize it.
Default reports
Financial reporting provides 22 default financial reports. Every report uses the default main account categories. You can use these reports as is or as a starting point for your financial reporting needs. In addition to the traditional financial statements, such as Income statement and Balance sheet, these default reports include reports that show the different types of financial reports that you can create.
| Default report | Description |
|---|---|
| 12 Month Rolling Single Column Income Statement – Default | View an organization's profitability for the past 12 months in a single column. |
| 12 Month Trend Income Statement – Default | View an organization's profitability for each of the last 12 months. These 12 months can span more than one fiscal year. |
| Actual vs Budget – Default | View detailed balance information for all accounts for the original budget, and compare the revised budget to actuals that have a variance. |
| Audit Details – Default | View detailed balance information for all accounts. This report shows debit and credit balances in the reporting currency and the local currency, together with additional transaction information, such as the user ID, the user who last modified the data, the date of the last modification, and the journal ID. |
| Balance List – Default | View detailed balance information for all accounts. This report shows opening and closing balances, and debit and credit balances for the current period and year to date, together with additional transaction information, such as the voucher. |
| Balance Sheet – Default | View the organization's financial position for the year. |
| Balance Sheet and Income Statement Side by Side - Default | View the organization's financial position and profitability for the year side by side. |
| Cash Flow – Default | Gain insight into the cash that's coming in to and going out of the organization. |
| Detailed JE and TB Review – Default | View opening balance and activity information for all accounts. |
| Detailed Trial Balance - Default | View balance information for all accounts that have debit and credit balances, and the net of these balances, together with the transaction date, voucher, and journal description. |
| Expenses Three Year Quarterly Trend – Default | Gain insight into expenses for the past 12 quarters over the previous three years. |
| Financial Captions JE and TB Review – Default | See an overview of the balances and activity for the asset, liability, owner's equity, revenue, expense, gain, or loss financial captions. |
| Income Statement – Default | View the organization's profitability for the current period and the year to date. |
| Ledger Transaction List – Default | View detailed balance information for all accounts. This report shows debit and credit balances, together with additional transaction information, such as the transaction date, journal number, voucher, posting type, and trace number. |
| Ratios – Default | View the solvency, profitability, and efficiency ratios for the organization for the year. |
| Rolling 12 Month Expenses – Default | Gain insight into expenses for each of the last 12 months. These 12 months can span more than one fiscal year. |
| Rolling Quarter Income Statement – Default | View the organization's profitability on a quarterly basis for the past year and the year to date. |
| Side by Side Balance Sheet – Default | View the organization's financial position for the year. This report shows assets and liability, and shareholder equity side by side. |
| Summary Trial Balance – Default | View balance information for all accounts that have opening and closing balances, and debit and credit balances together with their net difference. |
| Summary Trial Balance Year Over Year – Default | View balance information for all accounts that have opening and closing balances, and debit and credit balances together with their net difference for the current year and the past year. |
| Weekly Sales and Discounts - Default | Gain insight into sales and discounts for each week in a month. This report includes a four-week total. |
| Budget Funds Available - Default | View a detailed comparison of revised budget, actual expenditures, budget reservations, and budget funds available for all accounts. |
Opening financial reports
When you select the Financial reporting menu, you see the list of default financial reports for the company. You can open or modify a report. To open one of the default reports, select the report name. The first time you open a report, the system automatically generates it for the previous month. For example, if you open a report for the first time in August 2019, the system generates the report for July 31, 2019. After you open a report, you can start exploring it by drilling down on specific pieces of data and changing report options.
Creating and modifying financial reports
From the financial reports list, you can create a new report or modify an existing report. If you have the appropriate permissions, you can create a new financial report by selecting New on the Action Pane. The system downloads a report designer program to your device. After the report designer starts, you can create the new report. After you save the new report, it appears in the financial reports list. The list shows only reports that were created for the company that you're using in Dynamics 365 Finance.
Reporting tree definitions
One of the components used to build financial reports is a reporting tree definition. A reporting tree definition helps define the structure and hierarchy of your organization. It's a cross-dimensional hierarchical structure that's based on the dimensional relationships in your financial data. It provides information at the reporting unit level and at a summary level for all units in the tree.
You can create an unlimited number of reporting trees to display your organization's data in various ways. Each reporting tree can contain any combination of departments and summary units, but a report definition can link to only one reporting tree at a time.
Update the Financial reporting version through slipstreaming
Finance and operations apps are updated every month. However, Financial reporting isn't necessarily updated on that cadence. Moreover, customers have more options about when they implement updates for finance and operations apps. Financial reporting updates are automatically installed. Financial reporting has a designated version that you consume in a customer environment when a service update is implemented, when downtime is initiated, or when a customer's environment is in Maintenance mode. This process is known as slipstreaming or true-up, because all customer implementations are set to the same version of Financial reporting.
You can find changes that are released in each version in What's new or changed in Dynamics 365 Finance. You can find platform updates and bug fixes in the "Additional Resources" section at the bottom of the page for each release.
The selected slipstreamed version is a reviewed and validated version of Financial reporting that's ready for production. It's compatible with any previous or future version of Dynamics 365 Finance. For example, Financial reporting can be on the latest 10.0.19 build while the customer is still on application version 10.0.16.
Note
The only circumstance where customers can move to a previous version (a downgrade scenario) occurs if Microsoft stops a true-up rollout because of an issue. As soon as a fix is available, it is applied automatically.
The slipstream process is fully automated and doesn't require any customer action. Three topologies consume slipstream, each in a slightly different way:
On-premises – On-premises deployments don't support slipstream and true-up.
Infrastructure as a service (IaaS) – The slipstream logic is applied during any operation that tries to update Financial reporting. It includes binary updates or broadcasts that contain binary updates.
Self-service – Any operation that requires Financial reporting downtime applies the slipstream logic:
- Binary updates or broadcasts that include binary updates
- S patching or other infrastructure downtime
- AOT package deployments