Collapse AllExpand All

5.1.3.  Cash Flow Report

Because Cash Flow statements can vary so widely, there is no system-defined Cash Flow template. To create your own Cash Flow statement, select the "Cash Flow" report type. The following screen will appear:

Note

If the xTuple Project Accounting package is installed, you will have the option to make the Cash Flow report available to Projects.

Cash Flow Financial Report

To create the row layouts for a Cash Flow report, you would follow the same basic steps as described in Section 5.1.4, “ Ad Hoc Report”. The only difference is you won"t need to specify which balances to calculate (e.g., beginning, ending, etc.). Because the Cash Flow report is one of three standard statement formats, the system determines which calculations will be done.

Tip

To build row layouts for the three standard report types—Income Statement, Balance Sheet, and Cash Flow—use the same techniques as when building Ad Hoc report row layouts. The only difference is you won"t need to specify which balances to calculate (e.g., beginning, ending, etc.). The system determines which calculations will be done for the standard statement formats.

In addition to row layouts, you may also define column layouts for your Cash Flow report. Column layouts are used to specify the time buckets financial information will be sorted into. You specify a column layout to use when viewing or printing Financial Reports. You may define any number of column layouts. Each layout will be linked to either a pre-defined report definition or a custom report definition you create yourself.

To create column layouts for a Cash Flow report, select the "Column Layouts" tab. The following screen will appear:

Cash Flow Report Column Layouts

When creating column layouts for a Cash Flow report, you are presented with the following options:

Column Layouts

Display lists column layouts defined for the Cash Flow report.

The following buttons are unique to this screen:

ADD

Select to add a column layout.

To create a new column layout, select the ADD button. The following screen will appear:

Add New Column Layout

When adding a new column layout, you are presented with the following options:

Name

Enter a name to identify the column layout.

Description

Enter a brief description of the column layout.

Report Template

Specify the report definition you want to associate with the column layout.

Tip

When creating a column layout, you can choose from the following standard report templates:

FinancialReport (used by all Ad Hoc reports)

FinancialReportMonth

FinancialReportMonthBudget

FinancialReportMonthDbCr

FinancialReportMonthPriorMonth

FinancialReportMonthPriorQuarter

FinancialReportMonthPriorYear

FinancialReportMonthQuarter

FinancialReportMonthYear

FinancialReportQuarter

FinancialReportQuarterBudget

FinancialReportQuarterPriorQuarter

FinancialReportYear

FinancialReportYearBudget

FinancialReportYearPriorYear

FinancialTrend (used by non-Ad-Hoc trend reports)

If for some reason these templates don"t meet your needs, you can always use OpenRPT to a) modify them or b) create your own custom report templates.

Selected Period

Select the time period(s) you want to have included in the column layout:

Month

Select to have the current month included as one of the columns in the layout. The month used as the basis for the reporting is specified when the report is run. If selected, you will also have the option to include the prior month in the layout.

Quarter

Select to have the current Quarter included as one of the columns in the layout. The month used as the basis for the reporting is specified when the report is run. If selected, you will also have the option to include the prior Quarter in the layout.

Year

Select to have the current Fiscal Year-to-Date included as one of the columns in the layout. The month used as the basis for the reporting is specified when the report is run. If selected, you will also have the option to include the prior Fiscal Year in the layout.

Show Debits and Credits

Select to have Debits and Credits included as columns for each of the time periods (month, Quarter, Year) specified for the layout.

% of Group Total

Select to have the percentage of group total included as a column for each of the time periods (month, Quarter, Year) specified for the layout. This information will only be shown for groups and Accounts whose row definition specifies "Show % of Group Total."

Note

There is no relationship between the selected time periods in a column layout and the Trend Report options available when viewing a Financial Report. Trend Reporting ignores column layouts.

Prior

Select to include prior time period information in the column layout by selecting from the following options:

  • Period: Will include information for the Accounting Period immediately prior to the Period specified when the Financial Report is run. You must also select at least one of the time-period check boxes below ("Full Month" or "Full Quarter") for prior information to be included.

  • Year: Will include information for the Fiscal Year immediately prior to the current Year specified when the Financial Report is run. You must also select at least one of the time-period check boxes below ("Full Month," "Full Quarter," etc.) for prior information to be included.

  • Full Month: If selected, a full month's worth of information will be included when the report is run—depending on the prior time period specified above. If the "Period" option is specified, then the month immediately prior to the selected Accounting Period will be included. If the "Year" option is specified, then the selected month in the prior Fiscal Year will be included.

  • Full Quarter: If selected, a full Quarter's worth of information will be included when the report is run—depending on the prior time period specified above. If the "Period" option is specified, then the Quarter immediately prior to the selected Accounting Period's Quarter will be included. If the "Year" option is specified, then the selected Quarter in the prior Fiscal Year will be included.

  • Full Year: If selected, the full prior Fiscal Year's worth of information will be included when the report is run.

    Tip

    The "Full Year" and "Year To Date" check boxes are not affected by the "Period" or "Year" selections.

  • Year To Date: If selected, the current Fiscal Year to Date's worth of information will be included when the report is run.

  • % of Group Total: If selected, the percentage of the group total for the prior time period will be included when the report is run. This information will only be shown for groups and Accounts whose row definition specifies "Show % of Group Total."

  • Difference: If selected, the amount of difference between the selected Accounting Period and the prior time period will be included when the report is run.

  • % of Difference: If selected, the percentage difference between the selected Accounting Period and the prior time period will be included when the report is run.

Budget

Select to include Budget information in the column layout. If selected, the following additional options will be available:

% of Group Total

If selected, the Budget percentage of the group total will be included when the report is run. This information will only be shown for groups and Accounts whose row definition specifies "Show % of Group Total."

Difference

If selected, the amount of difference between the selected Accounting Period and the Budget for the Period will be included when the report is run.

% of Difference

If selected, the percentage difference between the selected Accounting Period and the Budget for the Period will be included when the report is run.

To specify additional configuration options for the layout of your Cash Flow report, select the "Options" tab. The following screen will appear:

Cash Flow Report Options

When specifying additional configuration options for the layout of your Cash Flow report, you are presented with the following options:

Show Grand Total

Select if you want to include a grand total in the Financial Report.

Alternate Labels

You have the option to substitute alternate text for the following column headers or row labels when viewing or printing your Financial Report:

Alternate Debits

Specify an alternate label to use as the header text for the Debits column. If not specified, the default text will be used.

Alternate Credits

Specify an alternate label to use as the header text for the Credits column. If not specified, the default text will be used.

Alternate Budget

Specify an alternate label to use as the header text for the Budget column. If not specified, the default text will be used.

Alternate Grand Total

Specify an alternate label to use as the text for the Grand Total row. If not specified, the default text will be used.

Note

Any Notes you add to a Financial Report definition will appear at the bottom of the Financial Report when the Financial Report is printed.