Understanding General Ledger Report Setup

Before you run the general ledger reports, such as the Profit and Loss statement, you must set up the formats required for the reports. The system produces reports to the specifications that you set up. You use the reports generated to complete the general ledger reports that you send to the government.

When you use the G/L Reports Setup program (P74R9020) to set up general ledger reports, you:

• Define the rows and columns that the system prints on the reports.

• Define the account or group of accounts that the system prints.

• Define formulas that the system uses to calculate sums based on amounts in certain rows or columns.

• Define the title of the reports.

You must set up a one or more report formats for these reports:

• Profit and Loss

• Balance Sheet

• Changes in Equity

• Cash Flow

When you complete the setup for general ledger reports, the system populates the tables that are accessed as the system generates the reports. The tables populated are:

Table ID	Description
Setup G/L Reports (F74R9020)	Includes data about the report format, such as the report name, type, and the source of the accounts. The system reads this table to determine the format of the report.
Report Detail Row Definition (F74R9021)	Includes data about the sequence of the rows, the row definitions that print on the report, and whether the rows are visible. The system reads this table to determine the sequence of rows and the row descriptions.
Accounts Group Definition (F74R9022)	Includes data about the accounts or range of accounts for which the system prints balances or calculates amounts. The system reads this table to determine the source of the amounts to print.
Report Column Description (F74R9023)	Includes data about columns for the Changes in Equity report. The system reads this table when you run the Changes in Equity program (R74R9030) to determine the report name, and row and column definitions.

To set up general ledger reports, complete these steps:

Step	Description
Add report formats.	You add report formats to identify the type of report and the source of the records that the system reads. For example, some reports might read records in the Account Balances (F0902) table, and some reports read records in the Correspondence Balance (F74R9002) table.
Add row details.	Select an existing format on the Setup G/L Reports form, then click Add to access the Report Row Detail Definition form. Click Add to access the Add/Update Detail row form, which is where you specify the type of rows for each section of the report, the sequence of the rows and the description for the row that prints on the report.
Associate accounts, or a range of accounts, to the rows.	After you define rows, you specify the account or range of accounts from which the system reads amounts.
Define columns for Changes in Equity reports.	After you define rows for Changes in Equity reports, you define the columns for the reports.