P & L Variance Tab

eFinancials—Reports—GL Reports—P & L Variance or
ePO—Reports—P & L Variance

This report is available as a Standard Report or an Alternate Report.

The profit and loss statement compares the selected period actual amount with the period budget amount and displays a month-to-date variance amount. The same comparison is applied to year-to-date amounts, and displays a year-to-date variance amount. Variances are calculated based on the account type to determine if the variance is favorable or unfavorable. Unfavorable variances are bracketed. An optional selection parameter allows you to include unapproved transactions.

Variance Based on Budgets

If the Variance based on budgets check box is selected, the P & L Variance report calculates the Variance value based on Budget value instead of the Divisor Account value. The Variance value is a percentage.

When Variance based on budgets is checked, the Variance value is calculated for Month-to-Date (MTD) and Year-to-Date (YTD) as:

Variable MTD % = (Actual - Budget) / Budget * 100

Variable YTD % = (Actual - Budget YTD) / Budget YTD * 100

Example (MTD %)

Actual: 642.17

Budget: 1312.00

Actual - Budget = 669.83

669.83/1312 (Budget) * 100 = 51.05%

Note

Setting up a customized general ledger report format is of particular importance if you want to show the calculation of the Divisor account for a MTD and YTD % calculation between actual and budgeted numbers. As a prerequisite to being able to show the calculation, you must set up report formats that include divisor accounts. For the calculation to occur, the divisor account must be included in a report sequence.

From the eFinancials menu, select Reports—GL Reports—P & L Variance. Or, from the ePO menu, select Reports—P & L Variance.
Click Select EntitiesCompanies. Select the EntitiesCompanies for which you want to print the report and click Save.
From the Fiscal Year field, type the year for the report (for example, 2008).
From the Period field, type the period for the report (for example, 2).
From the Report Format drop-down list, select a format.
If you have separate budgets set up for eFinancials and ePO, at Budget Source select a budget source for this report. If you do not use separate budgets, this field does not appear.
To include unapproved transactions on the report, select the Include Unapproved Transactions check box.
To print the P & L variance based on budgets, select the Variance based on budgets check box. Refer to the Report Description, above, for more information.
Select the type of report you want to print: Standard Report or Alternate Report (refer to report description).
Select one of the following report printing options:

PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.
Create Spreadsheet: Prints the report in an Excel spreadsheet.

Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

GL: P & L Variance