Introduction to setting up financial reports
You can use financial reports to create customized reports in a flexible way and without needing to develop them.
You can use financial reports to arrange accounts that are listed in the chart of accounts, the chart of cost types, and the chart of cash flow accounts in ways that provide information about those accounts. Users can set up various layouts to define the information that they want to extract from any of these charts.
One main purpose of financial reports is to provide a place for calculations that can't be made directly in the chart of accounts. For example, users can create financial reports to calculate profit margins on dimensions such as departments or customer groups. Additionally, users can filter any entries and budget entries, such as by net change or debit amount.
By using cost types and cash flow entry accounts in the financial reports, you can build cost accounting reports and cash flow reports.
With financial reports, you can perform the following tasks:
Create customized financial reports without using the Report Designer.
Create as many financial reports as needed, each with a unique name.
Set up various report layouts and print the reports with the current figures.
Export financial data to Microsoft Excel.
A financial report consists of the following components:
A row definition
A column definition
To create a financial report, follow these steps:
Select the Search for Page icon in the top-right corner of the page, enter financial reports, and then select the related link.
Select New.
The Financial Reports page contains the following fields:
Name - Specifies the name of the financial report.
Description - Specifies a description of the financial report.
Row Definition - Specifies the row definition to be used for this financial report. A row definition contains the rows that you want to display in a financial report.
Column Definition - Specifies the column definition to be used for this financial report. A column definition contains the columns that you want to display in a financial report.
You can also create a new financial report by selecting Copy Financial Report, filling in the two fields, and then selecting the OK button.
Watch this video to see a demonstration of setting up a financial report and a row definition.