GL Budget Reports window
The Budget Reports display income and expense activity versus budgeted amounts and can be run for a specified period and account number range, and with several levels of detail.
Fund Number (Fund product only)
Enter a fund number to show only accounts in that fund on the report.
Print All Funds (Fund product only)
This drop-down is only active if the Fund Number field is blank. If you want to print one report that displays all the included funds, select Combined from the drop-down. If you want to print a separate report for each fund, select Separated.
Starting Period / Ending Period
Enter the starting and ending period number(s) that you want to include in the report. You can choose any period(s) in your
fiscal calendar, from 1 to 60. If you want to include only one period in the report, enter the same number in both the
Starting Period and
Ending Period boxes. The defaults for these boxes are the Present Period as shown in your fiscal calendar.
When you enter the period number, the first date of the starting period and the last date of the ending period will appear to the right of the corresponding boxes so you can verify that these are the periods you want to include in the report.
(Fund product only) If the Allow multiple fiscal calendars check box is selected in Module Preferences and the fund calendar is different than the organization calendar, the fund’s organization calendar will be used for these dates.
YTD Starting Period / Ending Period
Enter the YTD starting and ending period number(s) that you want included in the report. You can choose any period(s) in your
fiscal calendar, from 1 to 60. If you want to include only one period in the report, enter the same number in both the
YTD Starting Period and
Ending Period boxes. The defaults for these boxes are the Present Period as shown in your fiscal calendar.
When you enter the period number, the first date of the starting period and the last date of the ending period will appear to the right of the corresponding boxes so that you can verify that these are the periods you want to include in the report.
Budget
From the drop-down, choose the budget you want to print. If you choose All Finalized Accounts, the report will include accounts from every finalized budget. If you choose a specific Budget Code, it will include both finalized and non-finalized accounts in the budget you select.
Skip No Activity
Select either or both of these check boxes based on which accounts you want to exclude from the report.
Zero Balance
Select this check box to exclude accounts that have a zero balance for the specified time period on the report. If the accounts have a balance, but not in the time period shown on the report, they will not appear on the report.
Zero Budget
Selecting this check box will exclude accounts with no budget information entered for the period range included in the report.
Print Account Number
Select this check box if you want to print the account numbers on the report. If this check box is selected, the account numbers will appear on the left side of the page before the account descriptions.
Sort by Fund (Fund product only)
This check box is only active if you select Combined from the Print All Funds drop-down and you select a Report Type other than Advanced Detailed. Select this check box if you want to sort the included accounts by fund number.
Use Advanced Report Groups
Select this check box if you want to generate a report with an
advanced layout. When you select this check box, different options are available from the
Report Type drop-down and the
Report Group Lookup is enabled.
Report Type
Select the Report Type from the drop-down list. The following report types are available:
• Standard: Prints a statement of actual and budgeted income, expense activity for both the specified period and the year-to-date, and includes the variance between the actual and budgeted year-to-date figures.
• Variance: Prints a statement of actual and budgeted income, expense activity, and the percentage of the remaining budget, for both the specified period and the year-to-date. It also includes the variance between the actual and budgeted amounts for both the specified period and year-to-date.
• Profit and Loss or Revenue and Expense: Prints a statement of actual and budgeted revenue and expense activity for the year-to-date as of the specified period. It also includes the percentage that the actual amounts are over, or under, the budgeted amounts.
If you selected the Use Advanced Report Groups check box, the following options are available:
• (Accounting product only) Advanced Profit and Loss: This report uses the layout you select in the Report Group field to show the actual and budgeted profit and loss activity for the year-to-date as of the specified period.
• (Accounting product only) Advanced Detailed: Prints the Income Statement sorted by the accounts you added to the Advanced Report Group layout, even if the accounts do not have a Group 1 Report Group assignment in the GL Accounts window.
• (Fund product only) Advanced Revenue and Expense: This report uses the layout you select in the Report Group field to show the actual and budgeted revenue and expense activity for the year-to-date as of the specified period.
• (Fund product only) Advanced Detailed: Prints the Revenue and Expense Report sorted by the accounts you added to the Advanced Report Group layout, even if the accounts do not have a Group 1 Report Group assignment in the GL Accounts window.
Use Account Filter
Select this check box and enter a filter to use to print a customized report which includes only those accounts that meet the filter criteria. This option is not available if you selected the Use Advanced Report Groups check box.
Use Advanced Filter
Select this radio button to use an
Advanced Filter Code as a filter for the report.
Account Filter
If you selected the Use Account Filter radio button, enter a filter to specify which accounts to include. Only accounts that match the specified filter criteria will appear on the report. Use wildcards (* and ?) to establish the filter parameters. Substitute a (?) for any single character in the account number, or an (*) for any number of characters. For example, to include all four-digit accounts beginning with a 1, enter 1??? in the Account Filter box. To include all accounts that end in 02, enter *02.
If you selected the
Use Advanced Filter radio button, type the Code or use the Lookup to enter the
Filter Code to use to select the accounts.
Report Group
This field is only available if you selected the Use Advanced Report Groups check box. Type the Report Group Code you want to use for this report layout or open the Lookup to select one.
Related Topics
Published date: 03/12/2021