Profit and Loss

The Profit and Loss report uses Summary Links that return actual and budget values for the current period and year to date.

This report uses cell C8 to define the current period for the report. Each Summary Link uses the Current Period Override feature on the Period Selection screen.

Actual values are derived from Ledger A with budget values from Ledger B.

This table shows the filters used on the report:

Filter Value Field reference
Table Ledger (LA) -
Ledger (Actual) A G$58
Ledger (Budget) B H$58
Account Code Row dependent $Y29 - $Z29
Accounting Period 2005/009 C$8
Product Type Analysis Code All $C$9
Note: The Filters section of the worksheet is used to control the selection of the Business Unit, Period and Product Group.