4Reports and Inquiry
Option 4Budget Analysis Report
This report is provided to present budget performance. Budget amounts are compared to actual amounts for each budget type, account, and fiscal year, and are reported in cumulative or net monthly amounts. The following processing steps accomplish this job.
- Step 1You can use this function to specify whether you want net or cumulative amounts to be printed on the Budget Analysis report.
The screen below allows you to enter parameters needed for the Budget Analysis report.
Budget Analysis Report screen
Data items for the preceding screen are described below:
- Net or Cumulative Amounts
Upper case, up to 3 characters Letters only Valid: NET, CUM Required Carries forward in ADD mode
Define the code that identifies the terms in which the balances are to be printed.
- NET
- Month-to-date net activity
- CUM
- Year-to-date cumulative amounts
Press ENTER to save the information on this screen.
- Step 2In preparation for performing a sort/selection process on the Budget Amounts information, this step provides you with a default sequencing of data records by Budget Type, Account, and Fiscal Year, giving additional sort order choice by Account Component, with the option to change modifiable parameters at run time. Selection of data records is provided by Budget Type, Account, Account Component, and Fiscal Year, with the option to enter user-specified comparisons at run time.
- Step 3This disposition type is used for all standard General Ledger reports.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the budge Analysis Report, this step formats the Budget Amounts information. The following data items are shown: Fiscal Year, SOY, Budget Compared to Actual, Month Descriptor, Monthly Balances, Monthly Amounts, EOY, Monthly Amount, and Monthly Net Amount. As appropriate, group headings appear whenever a change occurs in Account.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 15:41 LGG Page: 1
Budget Analysis Report
NET MONTHLY TOTALS
Actual Budget % of Budget Actual Budget % of Budget
=================================================================================================================================
Budget Type FA Budget 90 FY90 Fixed Asset Budget
Account 1130001000 Land
Fiscal Year 90
SOY 650,000.00 0.00
Dec 0.00
Jun 0.00 0.00 0.00 Jan 0.00
Jul 0.00 0.00 0.00 Feb 0.00
Aug 0.00 0.00 0.00 Mar 0.00
Sep 0.00 Apr 0.00
Oct 0.00 May 0.00
Nov 0.00
EOY 0.00
Account 1130002000 Land, Canadian
Fiscal Year 90
SOY 514,767.12 0.00
Dec 0.00
Jun 0.00 0.00 0.00 Jan 0.00
Jul 0.00 0.00 0.00 Feb 0.00
Aug 0.00 0.00 0.00 Mar 0.00
Sep 0.00 Apr 0.00
Oct 0.00 May 0.00
Nov 0.00
EOY 0.00
Account 1140001000 Buildings
Fiscal Year 90
SOY 410,000.00 0.00
Dec 0.00
Jun 0.00 0.00 0.00 Jan 0.00
Jul 0.00 0.00 0.00 Feb 0.00
Aug 0.00 0.00 0.00 Mar 0.00
Sep 0.00 Apr 140,000.00
Oct 0.00 May 0.00
Nov 250,000.00
EOY 0.00