More information

Summary Budget Comparison

Access this report using Reports>Budget>Summary Budget Comparison.

Use this report, which can be generated for any account type or account code combination, to print data comparing current year or period budgeted revenues and expenses with current year or period actual revenues and expenses. Budget data was entered when the budget worksheet was set up using Activities>Budget Worksheet or Transactions>Enter Budget. This report contains:

Additional columns if number type user defined fields were created by the Administrator using Organization>Set Up User Defined Fields.
The Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up to override report dates or create custom formulas.

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 six new columns will be added to this report, such as Current Period Actual # - {UDF Display Name}, YTD Actual # - {UDF Display Name}, Total Actual # - {UDF Display Name}, Current Period Budget # - Original - {UDF Display Name}, YTD Budget # - Original - {UDF Display Name}, and Total Budget # - Original - {UDF Display Name}. (Otherwise, three columns are added, such as Current Period Budget - Original, YTD Budget - Original, and Total Budget - 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.

Specify the reporting period for this report by entering a Current Reporting Year Begins date and the Current Period Dates.

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. Columns that use a period of Opening Balances Date through Ending Balances Date, or Current Reporting Year Begins Date through Ending Balances Date, use the dates specified on the Setup tab of the report. However, if a column uses the Total Budget Dates, this range was assigned on the Options tab of the report.

Column	Description
Account Type	The General Ledger account type, such as EXP or REV.
Account Code	The actual account code assigned to the account, such as 201, 05, or 45001.
Account Title	The actual title assigned to the account code, such as Housing or Service Fees.
Account Short Title	Usually the first 15 characters of the Account Title. The report prints an account short title, such as Housing or Svc Fees.
Effective Date	The line item's effective date.
Prior Year Current Period Actual	This monetary amount is calculated by taking the net amount of actual decreases and increases for the prior year period Opening Balances Date through the prior year Ending Balances Date.
Prior Year Actual	This monetary amount is calculated by taking the net amount of actual decreases and increases for the prior year Current Reporting year Begins date through the prior year Ending Balances Date.
Current Period Actual	This monetary amount is calculated by taking the net amount of actual decreases and increases for the period Opening Balances Date through the Ending Balances Date.
YTD Actual	This monetary amount is calculated by taking the net amount of actual decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year.
Prior Year Budget - {Budget Version Display Name}	This monetary amount is calculated by taking the net amount of budget decreases and increases for the Current Reporting Year Begins date through the Ending Balances date of the prior year.
Current Period Budget - {Budget Version Display Name}	This monetary amount is calculated by taking the net amount of budget decreases and increases for the period Opening Balances Date through the Ending Balances Date for the specified Budget Version.
Current Period Budget Variance - {Budget Version Display Name}	This is the expense and revenue variance for the calculation between the Current Period Actual amounts and the Current Period Original Budget amounts.
YTD Budget - {Budget Version Display Name}	This monetary amount is calculated by taking the net amount of budget decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year for the specified Budget Version.
YTD Budget Variance - {Budget Version Display Name}	This is the expense and revenue variance for the calculation between the Current Year Actual amounts and the YTD Original Budget amounts.
Total Budget - {Budget Version Display Name}	This monetary amount is calculated by taking the net amount of decreases and increases for the period Total Budget From date through the Total Budget Through date (on the Options tab) for the specified Budget Version.
Total Budget Variance - {Budget Version Display Name}	This is the expense and revenue variance for the calculation between the Current Year Actual amount and the Total Original Budget amounts.
Percent Total Budget Remaining - {Budget Version Display Name}	This amount, which is represented using a percentage, is calculated by taking the Total Original Budget less the Current Year Actual, and then dividing the result by the Total Original Budget.
Percent Total Budget Used - {Budget Version Display Name}	This amount, which is represented using a percentage, is calculated by taking the YTD Actual divided by the Total Original Budget.
{Custom Columns}	A custom column that was created.
Prior Year Actual # - {UDF Display Name}	This number amount is calculated by taking the net amount of actual decreases and increases for the prior year Opening Balances Date through the prior year Ending Balances Date for the specified Budget Version and the specified UDF.
Current Period Actual # - {UDF Display Name}	This number amount is calculated by taking the net amount of actual unit decreases and increases for the period Opening Balances Date through the Ending Balances Date for the specified UDF.
YTD Actual # - {UDF Display Name}	This number amount is calculated by taking the net amount of actual unit decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year for the specified UDF.
Total Actual # - {UDF Display Name}	This number amount is calculated by taking the net amount of actual unit decreases and increases for the period Total Budget From date through the Total Budget Through date for the specified UDF.
Prior Year Budget # - {Budget Version Display Name} - {UDF Display Name}	This number amount is calculated by taking the net amount of budget decreases and increases (having an entry type of UO) for the Current Reporting Year Begins date through the Ending Balances date of the prior year for the specified Budget Version and the specified UDF.
Current Period Budget # - {Budget Version Display Name} - {UDF Display Name}	This number amount is calculated by taking the net amount of budget unit decreases and increases for the period Opening Balances Date through the Ending Balances Date for the specified Budget Version and the specified UDF.
YTD Budget # - {Budget Version Display Name} - {UDF Display Name}	This number amount is calculated by taking the net amount of budget unit decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year for the specified Budget Version and the specified UDF.
Total Budget # - {Budget Version Display Name} - {UDF Display Name}	This number amount is calculated by taking the net amount of unit decreases and increases for the period Total Budget From date through the Total Budget Through date for the specified Budget Version and the specified UDF.

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
Total Budget	Select the start and end date you want to use to calculate and print total budget amounts. This range can exceed a 12 month interval.
Year-End Adjustments	Select this option to include year-end adjustments on the report. This entry type was designated during transaction entry.
Only Revenue and Expense Type Codes	Deselect this option to show all account types on the report (except Cash, AP, and AR); otherwise, the report displays only revenue and expense accounts.
Unposted Actual Amounts	Select this option to show all non-budget unposted amounts on the report.
Suppress Lines with All Zeros	Select this option so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

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 is typically used by program directors/managers to stay abreast of the status of funds available. It can be run on a company-wide basis or for a sub-component (a single grant or contract, for example).
This report can contain two date ranges: Opening/Ending Balances (on the Setup tab) and Total Budget From/Through (on the Options tab). However, the system cannot look at two date ranges. It uses one or the other. Any time a column is selected pertaining to "Total Budget," the system looks at the "Total Budget From/Through" date range.
Select the Show Totals box to print totals for each account code combination. For summary reports, the Show Total box is rarely selected for the last item in the sort sequence. A redundant total would appear after each item, since there is nothing lower in the sequence to total.
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.
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).