4Reports and Inquiry
Option 4Budget vs. Actual Inquiry
This function displays the monthly budget and balance amounts and calculates the budget variance.
In order to display the Budget vs. Actual inquiry, this step formats the Budget Amounts information. The following data items are shown: Budget Type, Fiscal Year, Account, Description, Month Descriptor, Monthly Net Amount, Monthly Amount, and Difference.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 17:00 LGG Page: 1
Budget Variances - MTD/YTD Report
For August 89
MTD MTD MTD YTD YTD YTD
Account Budget Actual Variance Budget Actual Variance
=================================================================================================================================
Budget Type FA Budget 90 FY90 Fixed Asset Budget
Fiscal Year 90
1130001000 Land .00 .00 .00 .00 .00 .00
1130002000 Land, Canadian .00 .00 .00 .00 .00 .00
1140001000 Buildings .00 .00 .00 .00 .00 .00
1140002000 Buildings, Canadian 120000.00 .00 120000.00 120000.00 .00 120000.00
1150001000MA Equipment .00 .00 .00 .00 .00 .00
1150002000MA Equipment, Canadian .00 .00 .00 .00 .00 .00
1160001000 Furniture and Fixtures .00 .00 .00 .00 .00 .00
1160002000 Furniture/Fixtures, Canadian 22150.00 .00 22150.00 22150.00 .00 22150.00
_____________ _____________ _____________ _____________ __________ ___________
— Fiscal Year Subtotals —> 142150.00 .00 142150.00 142150.00 .00 142150.00
============= ============= ============= ============= ========== ===========
_____________ _____________ _____________ _____________ __________ ___________
— Budget Type Subtotals —> 142150.00 .00 142150.00 142150.00 .00 142150.00
============= ============= ============= ============= ========== ===========