|
xTuple ERP Reference Guide |
|
|
xTuple ERP Reference Guide |
| 6.1.2. Balance Sheet Report | ||
|---|---|---|
 | 6.1. New Financial Report |  |
The system ships with a basic Balance Sheet designed to generate Financial Reports using your Chart of Accounts data. In this section, we will examine this basic Balance Sheet.
Because the basic Balance Sheet is a system-defined Financial Report, it may not be modified (except to make it active or inactive). However, you may copy the report and modify the copy. You can think of the basic Balance Sheet as a template for building other, similar Financial Reports.
If the xTuple Project Accounting package is installed, the basic Balance Sheet will be available to Projects.
To view the basic Balance Sheet, select it for editing from the master list of Financial Reports. A message will alert you that this is a system-defined report which may only be viewed, not edited. Select the OK button to reach the following screen:
The "Row Layout" tab displays information on all the Account Groups and Account Numbers which make up the basic Balance Sheet. If this were a custom report you were creating, you would be able to add/remove Account Groups and Account Numbers to meet your specific needs.
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.
When viewing row layouts for the basic Balance Sheet, you are presented with the following columns:
Group/Account Name: Lists the Account Groups and Account Types used in the report. The two main groups are ASSETS and LIABILITIES AND OWNERS EQUITY. All Accounts having Type=Asset are included in the ASSETS group. And within the LIABILITIES AND OWNERS EQUITY group all Accounts having Type=Liability, Type=Equity, and also Net Income are included.
Sub./Summ.: Indicates whether group information will be presented as a subtotal or summary line when the report is run. In the basic Balance Sheet, all Account Groups are subtotaled—except for the Net Income group, which is summarized.
Oper.: Specifies whether a group will be added to ("+") or subtracted from ("-") the group total. In the basic Income Statement, LIABILITIES AND OWNERS EQUITY are subtracted from the ASSETS group.
Select the VIEW button to see the system-defined settings for each Account Group and Account Type used in the basic Income Statement. When creating your own reports, you may choose to either imitate or alter these default settings.
In addition to row layouts, you may also define column layouts for your Financial Reports. 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.
On the basic Balance Sheet, select the "Column Layouts" tab to view all the time buckets available for the report. If this were a custom report you were creating, you would be able to add/remove column layouts to meet your specific needs.
See Section 6.1.3, “ Cash Flow Report” for specific examples describing the various column layout options.
When viewing column layouts for the basic Balance Sheet, you are presented with the following column definitions—each of which defines a different time bucket available for viewing Balance Sheet information:
Current: Displays data for the current month (i.e., Accounting Period). The month used as the basis for the reporting is specified when the report is run. Uses the "FinancialReportMonth" report definition.
Current, Budget: Displays data for the current month, compared to Budget information for the current month. The month used as the basis for the reporting is specified when the report is run. Uses the "FinancialReportMonthBudget" report definition.
Current, Prior Month: Displays data for the current month, compared to the prior month end. The month used as the basis for the reporting is specified when the report is run. Uses the "FinancialReportMonthPriorMonth" report definition.
Current, Prior Quarter: Displays data for the current month, compared to the prior Quarter end. The month used as the basis for the reporting is specified when the report is run. Uses the "FinancialReportMonthPriorQuarter" report definition.
Current, Prior Year: Displays data for the current month, compared to the Prior Fiscal Year end. The month used as the basis for the reporting is specified when the report is run. Uses the "FinancialReportMonthPriorYear" report definition.
Current, Year Ago: Displays data for the current month, compared to the same month in the prior Fiscal Year. The month used as the basis for the reporting is specified when the report is run. Uses the "FinancialReportMonthPriorMonth" report definition.
Select the VIEW button to see the system-defined settings for each Account Group and Account Type used in the basic Income Statement. When creating your own reports, you may choose to either imitate or alter these default settings.
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.
To view additional configuration options for the layout of the basic Balance Sheet, select the "Options" tab. The following screen will appear:
The layout for the basic Balance Sheet does not use any extra configuration options. However, if you were creating your own Balance Sheet layout, you could choose to a) include a Grand Total row and b) use alternate labels for Budget and Grand Total rows when viewing and/or printing the Financial Report.
Any Notes you add to a Financial Report definition will appear at the bottom of the Financial Report when the Financial Report is printed.
| |  | |
| 6.1.1. Income Statement Report |  | 6.1.3. Cash Flow Report |