Collapse AllExpand All

5.1.  New Financial Report

The Financial Reporting Engine (FRE) enables you to design custom Financial Reports, which can then be previewed, printed, or exported in tab-delimited format. You are free to decide how much detail to include in these custom reports. For example, you can create highly-detailed Financial Reports or executive summaries.

To create a new Financial Report, select the "Create Financial Report" option. The following screen will appear:

Create New Financial Report

When creating a new Financial Report, you are presented with the following options:

Name

Enter a name to identify the Financial Report.

Description

Enter a brief description of the Financial Report.

Active

Select to indicate whether the Financial Report is active or not. Inactive Financial Reports will be hidden on the master list of Financial Reports by default.

Report Type

Select one of the following standard statement formats to be the basis for your new Financial Report:

Income Statement

Select to create an Income Statement. You might also consider building an Income Statement by making a copy of the system-defined Income Statement, using the system-defined report as a template. To make a copy of the system-defined Income Statement, simply use the COPY button on the master list of Financial Reports. Once copied, you can freely modify the report to suit your needs.

Balance Sheet

Select to create a Balance Sheet. You might also consider building an Income Statement by making a copy of the system-defined Balance Sheet, using the system-defined report as a template. To make a copy of the system-defined Balance Sheet, simply use the COPY button on the master list of Financial Reports. Once copied, you can freely modify the report to suit your needs.

Cash Flow

Select to create a Cash Flow statement. Because Cash Flow statements can vary so widely, there is no system-defined Cash Flow template.

Ad Hoc

Select to create an Ad Hoc report. An Ad Hoc report is completely free-form and user-defined. This format gives you the flexibility to create reports which do not fit neatly within the three standard report types. Any Financial Report created in the system prior to version 2.1.0 will be classified as an Ad Hoc report.

Use in Projects

If the xTuple Project Accounting package is installed, select this option to make the Financial Report available to Projects.