Actual Budget Analysis Report

GL: Actual/Budget Analysis Report

Make the following menu selections to display this tab:

eFinancials—Reports—GL Reports—Actual/Budget Analysis

Use this tab to print a report displaying actual and budgeted amounts for income and expense accounts.

Note

To successfully run this report for a consolidated entitycompany, the reported periods must be closed for the consolidated entitycompany and the entitiescompanies that make up the consolidated entitycompany.

Report Description

This report is available as a Standard Report or an Alternate Report. It displays the actual and budget amounts for income and expense accounts. The report includes information for all entitiescompanies currently selected, which can include consolidated entitiescompanies, and applies the default budget version set up for each entitycompany.

Report Field	Description
EntityCompany	The entitycompany appears at the top of the report.
Fiscal Year	The fiscal year appears at the top of the report.
Account	The report includes a row for each account associated with the entitycompany.
Actual	Actual amounts. By default, the report shows actual amounts for current and prior periods, and budget amounts for all future periods. If you want the report to show actual amounts for closed periods and budget amounts for open periods, select the Actuals for closed periods, budgets for open periods button when you run the report. To include unapproved transactions in the calculation of actual amounts, select the Include Unapproved Transactions in Actual Periods check box when you run the report.
Budget	Budget amounts. By default, the report shows actual amounts for current and prior periods, and budget amounts for all future periods. If you want the report to show actual amounts for closed periods and budget amounts for open periods, select the Actuals for closed periods, budgets for open periods button when you run the report.
Revised Totals	For each account, this amount is calculated as the total of all actual amounts plus the remaining budget amounts for the fiscal year.
Original Budget	For each account, this amount is the total of all original budget amounts for each period in the fiscal year.
Totals row	The last row shows the total amounts for each column.

To Print the Report

Note

Before generating this report, you must have set up report formats.

From the eFinancials menu, select Reports—GL Reports—Actual Budget Analysis.
Click Select EntitiesCompanies. Select the entitiescompanies for which you want to print the report and click Save.
From the Report Format drop-down list, accept the default (P & L) or select a format.
If you want the report to include unapproved transactions in actual amounts, select the Include Unapproved Transactions in Actual Periods check box.
Specify the type of amounts you want to be printed:

Actuals through current period, budgets for future periods: Keep this default option selected if you want to print actual amounts for current and prior periods, and budget amounts for all future periods.

Actuals for closed periods, budgets for open periods: Select this button to print actual amounts for closed periods and budget amounts for open periods.

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.
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.