More information

Budget Worksheet Report

Access this report using Reports>Budget>Budget Worksheet.

Use this report to view or print the budget worksheet as it's being created or after its creation. You can view the budget worksheet with periods in columnar format across the page. The reporting periods can be viewed as monthly, quarterly, or yearly as defined on the Options tab. Budget data was entered when the budget worksheet was set up by the Administrator using Organization>Set Up Modules>Budget>Budget Versions and Activities>Budget Worksheet. This report:

Consists of account, group account, and period column information; as well as a total of all the Period columns.
Reflects all of the information on the Budget Worksheet, Budget Revisions Worksheet, or units based Budget Worksheet, including the comparative columns and the total columns.
Contains additional columns if number type user defined fields were created by the Administrator using Organization>Set Up User Defined Fields.

Budget Version and User Defined Field Columns: When a new Budget Version is added by the Administrator, and you have a UDF with a BD transaction source, at least five new columns will be added to this report, such as Actual {Trans Line UDF}, Original, Original - {Trans Line UDF}, Posted Original, and Posted Original - {Trans Line UDF}. (Otherwise, two columns are added, such as Original and Posted Original). Therefore, the number of columns in this report can grow exponentially.

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Current Transaction Dates are also required to specify the date range for the data included in the report.

Use this tab to determine what data to include in the report and to define the report layout.

By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Account Code	The actual code or group code assigned to the account, such as, 201, 05, or 45001.
Account Title	The actual title assigned to the account code or group code, such as, Housing or Service Fees.
Period Amount Actual (actual) Original (budget version) Revised (budget version) Posted Original (posted budget version) Posted Revised (posted budget version) # Actual {Trans Line UDF} (actual) # Original - {Trans Line UDF} (budget version) # Revised - {Trans Line UDF} (budget version) # Posted Original - {Trans Line UDF} (posted budget version) # Posted Revised - {Trans Line UDF} (posted budget version)	This is a "by-period" column which includes currency and unit amounts for each actual, budget version, and posted budget version. This amount is based on the dates entered for the Current Transaction on the Setup tab. It is also calculated by the reporting period selected on the Options tab—Monthly, Quarterly, or Yearly. For example, if Actual and "Original" were selected as the Period Amount, 1/1/15 through 12/31/15 was selected as the dates for the Current Transaction, and Monthly as the reporting period, the system prints 12 separate columns for those months, and two columns displaying the reporting period amounts for each month. Note that this column includes currency and unit (#) amounts for each actual, budget version, and posted budget version.
Total Amount Actual (actual) Original (budget version) Revised (budget version) Posted Original (posted budget version) Posted Revised (posted budget version) # Actual {Trans Line UDF} (actual) # Original - {Trans Line UDF} (budget version) # Revised - {Trans Line UDF} (budget version) # Posted Original - {Trans Line UDF} (posted budget version) # Posted Revised - {Trans Line UDF} (posted budget version)	The sum of each Period Amount column. Note that this column includes currency and unit (#) amounts for each actual, budget version, and posted budget version.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to designate the Group Sets for the report. Groups provide an alternate way of reporting summarized accounting data. Selecting a group code on the report is the same as filtering by group code on the entire report. Any accounts not included in a Group Set will not be included in the report. In order for groups to be applied to the report, the group selected on the Groups tab must also be selected in at least one of the following: Content tab or Filter tab.

Use this tab to set up any Available Options for the report.

Options	Description
Reporting Period	Select how to display the reporting period amounts—Monthly, Quarterly, or Yearly. This period is based on the dates selected for the Opening and Ending Balances on the Setup tab. The reporting period amounts display in the Reporting Period Amount column on the Content tab.
Summarize Amounts	Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Use this tab to forecast actual amounts based on budget amounts or prior actual amounts. To use this tab, Actual needs to be selected as a column on the Content tab.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.

This report prints all the Account Codes in one column and all the Account Titles in another column. Additionally, the Title column is required.
In the Report Body group box, similar columns are grouped together and identified with a heading preceded by a collapsed or expanded symbol . A collapsed symbol indicates the columns that belong to the heading are hidden. Click the collapsed symbol to "expand" the heading to see the columns contained within it. Likewise, an expanded symbol indicates the columns below it belong to that heading. For example, when you see Account Code with a symbol next to it, this means that Account Code is a heading and that every code name under it (such as GL Code, Fund Code) stays with the heading when it is moved to the Selected box.
Use the Mover buttons to move one item under a heading. However, if an item is moved from under one heading and then a different item is moved from another heading, the system keeps the items parallel. For example, move Fund Code from the Title heading. Then, move GL Code from the Account Code heading. The system automatically moves Fund Code from the Title heading and GL Code from the Account Code heading.
Since this report contains this feature, the line header is built in. Therefore, an item is printed one time per unique value. Each column, directly related to the item selected, prints in the line header on the same line.
Currency fields follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).
Available Segments display only {Segment} Groups for which Group Sets have been created by the user. If no Group Sets for the {Segment} Group exist, the {Segment} Group will not display under Available Segment. Prior to selecting a {Segment} Group ensure that Group Sets are created for the {Segment} Group using the Reports>Assign Report Groups form.