Report: Budget

The Budget report allows you to review budget data entry and provides hard copy reports for budget comparison and analysis.

Report Selections

What is this?

Reporting Period

This selection determines the date range for the general ledger posting data and the month(s) for the budget data to be considered for output to the report:

Group/Field	What is this?
From List	Use this option to select a pre-defined date range from the list.
Select Dates	Use this option to type in a specific date range not covered by the choices in the From List option.

Business Unit

Click the link to open the Business Unit Selections form and make your selections if you want to narrow the report to specific business units only (e.g., division, branch, department, group).

Business Unit Consolidation Option

These options are different depending on the combination of Business Unit options (division, branch, department, group) turned on in the Accounting Options section of Agency Setup.

Division/Department	What does this mean?
All Divs and Depts Consld	Report all divisions and departments consolidated.
Div by Div/Dept Consld within Div	Report divisions separately, consolidating all departments within each division.
Div by Div/Dept by Dept within Div	Report all divisions and departments separately.

Division/Branch/Department	What does this mean?
All Divs, Brnches, and Depts Consld	Report all divisions, branches, and departments consolidated.
Div by Div/Brnch Consld/Dept Consld	Report each division separately, while consolidating all departments into their respective branches, and all branches into their respective divisions.
Div by Div/Brnch by Branch/Dept Consld	Report each division, and branch separately, while consolidating all departments into their respective branches.
Div by Div/Brnch by Brnch/Dept by Dept	Report each division, branch, and department separately.

Division/Branch/ Department/Group	What does this mean?
All Divs, Brnches, Depts, and Grps Consld	Report all divisions, branches, departments, and groups consolidated.
Div by Div/Brnch by Brnch/Dept by Dept/Grp by Grp	Report each division, branch, department, and group separately.
Div by Div/Brnch by Brnch/Dept by Dept/Grp Consld	Report each division, branch, and department separately, while consolidating all groups into their respective departments.
Div by Div/Brnch by Brnch/Dept Consld/Grp Consld	Report each division, and branch separately, while consolidating all groups into their respective departments, and all departments into their respective branches.
Div by Div/Brnch Consld/Dept Consld/Grp Consld	Report each division separately, while consolidating all groups into their respective departments, all departments into their respective branches, and all branches into their respective divisions.

Division/Department/Group	What does this mean?
All Divisions, Departments, and Groups Consolidated	Report all divisions, departments, and groups consolidated.
Div by Div/Dept Consld/Grp Consld	Report each division separately, while consolidating all groups into their respective departments, and all departments into their respective divisions.
Div by Div/Dept by Dept/Grp Consld	Report each division, and department separately, while consolidating all groups into their respective departments.
Div by Div/Dept by Dept/Grp by Grp	Report each division, department, and group separately.

Budget

This list contains all budgets that exist in the system.

If you select a budget that only contains data for a business unit combination for which you do not have security authorization, the report returns no amounts.

Reporting Level

Indicates the level of detail included by general ledger reporting group. The default is 3-Average. The full range of reporting levels are:

1-Most summarized
2-Summarized
3-Average
4-Detailed
5-Most Detailed

Report Format

This selection offers several different formats for displaying budget data. The default selection is Budget Comparison with % of Income Including Prior Year and YTD.

See the tables in the Report Format Options section of this topic for more information.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as checked.

Report Format Options

Budget Comparison with % of Income Including Prior Year and YTD is the default report format. The default format and the other available formatting choices are described below:

Field Selection

Report Format

Budget

Data Column #	Report Column Heading	What is this?
1	Budget [BegDate] [EndDate]	Budget data for the selected period.
2	Budget % Total Incm	Value from column 1 divided by Budget Total Income expressed as a percentage.

Budget Comparison with % of Income

Data Column #	Report Column Heading	What is this?
1	Report [BegDate] [EndDate]	Data from general ledger postings for the selected period.
2	Report % Total Incm	Value from column 1 divided by Total Report Income expressed as a percentage.
3	Budget [BegDate] [EndDate]	Data from selected budget for the selected period.
4	Budget % Total Incm	Value from column 3 divided by Budget Total Income expressed as a percentage.

Budget Comparison with Variance

Data Column #	Report Column Heading	What is this?
1	Report [BegDate] [EndDate]	Data from general ledger postings for the selected period.
2	Budget [BegDate] [EndDate]	Data from selected budget for the selected period.
3	Variance Report vs Budget	Value in column 1 minus value in column 2.
3	Variance Report vs Budget	Column 3 result expressed as a percentage.

Budget Comparison with % of Income Including Prior Year and YTD

Data Column #	Report Column Heading	What is this?
1	Prior [BegDate] [EndDate]	Actual data for the selected date range in the prior year.
2	Report [BegDate] [EndDate]	Reported data for the selected date range.
3	Budget [BegDate] [EndDate]	Budget data for the selected date range.
4	Report % Tot Incm	Column 1 minus column 2 divided by Budget Total Income expressed as a percentage.
5	YTD Prior [BegDate] [EndDate]	Reported data for the Prior Year to Date.
6	YTD [BegDate] [EndDate]	Reported data for the Year to Date.
7	YTD Budget [BegDate] [EndDate]	Budget data for the Year to Date.
8	YTD Rpt % Tot Inc	Column 4 minus column 5 divided by Budget Total Income, expressed as a percentage.

Budget Comparison with % of Income Including YTD

Data Column #	Report Column Heading	What is this?
1	Report [BegDate] [EndDate]	Reported data for the selected date range.
2	Budget [BegDate] [EndDate]	Budget data for the selected date range.
3	Budget vs Report % Total Incm	Column 1 minus column 2 divided by Budget Total Income expressed as a percentage.
4	YTD [BegDate] [EndDate]	Reported data for the Year to Date.
5	YTD Budget [BegDate] [EndDate]	Budget data for the Year to Date.
6	YTD Rpt vs Budg % Tot Inc	Column 4 minus column 5 divided by Budget Total Income, expressed as a percentage.

Budget Comparison with Variance Including Prior and YTD

Data Column #	Report Column Heading	What is this?
1	Prior [BegDate] [EndDate]	Actual data for the selected date range in the prior year.
2	Report [BegDate] [EndDate]	Reported data for the selected date range.
3	Budget [BegDate] [EndDate]	Budget data for the selected date range.
4	Variance Budget vs Report	Column 1 minus column 2.
5	YTD Prior [BegDate] [EndDate]	Prior Year data for the Year to Date.
6	YTD [BegDate] [EndDate]	Report data for the Year to Date.
7	YTD Budget [BegDate] [EndDate]	Budget data for the Year to Date.
8	YTD Variance Budg vs Rpt	Column 6 minus column 7.

Budget Comparison with Variance Including YTD

Data Column #	Report Column Heading	What is this?
1	Report [BegDate] [EndDate]	Reported data for the selected date range.
2	Budget [BegDate] [EndDate]	Budget data for the selected date range.
3	Variance Budget Report	Column 1 minus column 2.
4	YTD Report [BegDate] [EndDate]	Reported data for the Year to Date.
5	YTD Budget [BegDate] [EndDate]	Budget data for the Year to Date.
6	YTD Variance Budg vs Rpt	Column 4 minus column 5.

Budget

CSV Columns	Description
BudgetDescription	Report description.
Division	Displays All Divisions when Consolidation = "All Divisions consolidated". Otherwise displays the division name.
Branch	Displays All Branches when Consolidation = "All Branches consolidated." Otherwise displays the branch name.
Department	Displays All Departments when Consolidation = "Departments consolidated". Otherwise displays the Department Name.
Group	Displays All Groups when Consolidation = "All Groups consolidated". Otherwise displays the Group Name.
Level 1	Level 1 for GL detail number.
Level 2	Level 2 for GL detail number. Matches Description for Detail 2 account.
Level 3	Level 3 for GL detail number. Matches Description for Detail 3 account. Blank for Detail 2.
Level 4	Level 4 for GL detail number. Matches Description for Detail 4 account. Blank for Detail3, Detail 2.
Level 5	Level 5 for GL detail number. Matches Description for Detail 5 account. Blank for Detail 4, Detail 3, Detail 2.
Account	GL number.
AcctDescription	Name of GL account number.
PriorPeriodAmt	Actual GL number net posting for selected reporting period minus one year.
ReportPeriodAmt	Actual GL number net posting for selected reporting period.
BudgetPeriodAmt	Budgeted total for selected reporting period.
YTDPrior	Actual GL YTD total for prior year.
YTDReport	Actual GL YTD for Report year.
YTDBudget	Budgeted total for Report year.
Month1Amt	Budget amount for GL period 1.
Month2Amt	Budget amount for GL period 2.
Month3Amt	Budget amount for GL period 3.
Month4Amt	Budget amount for GL period 4.
Month5Amt	Budget amount for GL period 5.
Month6Amt	Budget amount for GL period 6.
Month7Amt	Budget amount for GL period 7.
Month8Amt	Budget amount for GL period 8.
Month9Amt	Budget amount for GL period 9.
Month10Amt	Budget amount for GL period 10.
Month11Amt	Budget amount for GL period 11.
Month12Amt	Budget amount for GL period 12.

All Formats Except Budget

CSV Columns	Description
BudgetDescription	Report description.
Division	Displays All Divisions when Consolidation = 'All Divisions'. Otherwise displays the division name.
Branch	Displays All Branches when Consolidation = "All Branches consolidated." Otherwise displays the branch name.
Department	Displays All Departments when Consolidation = 'Departments Consolidated'. Otherwise displays the Department Name.
Group	Displays All Groups when Consolidation = "All Groups consolidated". Otherwise displays the Group Name.
Level 1	Level 1 for GL detail number.
Level 2	Level 2 for GL detail number. Matches Description for Detail 2 account.
Level 3	Level 3 for GL detail number. Matches Description for Detail 3 account. Blank for Detail 2.
Level 4	Level 4 for GL detail number. Matches Description for Detail 4 account. Blank for Detail3, Detail 2.
Level 5	Level 5 for GL detail number. Matches Description for Detail 5 account. Blank for Detail 4, Detail 3, Detail 2.
Account	GL number.
AcctDescription	Name of GL account number.
PriorPeriodAmt	Actual GL number net posting for selected reporting period minus one year.
ReportPeriodAmt	Actual GL number net posting for selected reporting period.
BudgetPeriodAmt	Budgeted total for selected reporting period.
YTDPrior	Actual GL YTD total for prior year.
YTDReport	Actual GL YTD for Report year.
YTDBudget	Budgeted total for Report year.