Budget Variance - Fiscal Year

Main Menu | Reporting | My Reports | Select Report (Budget group) and Edit

The Fiscal Year Budget Variance report (IRR1041s.rpt) provides a view of your balance sheet and income statement's budget.  Comparing budget with historical and projected figures for the entire current fiscal year.

The report uses the current default budget set.  The budget set will be displayed on the report in the upper left hand corner under the As of: date.

Each account will display the budget, historical, and projected figures as well as the dollar variance and percentage variance in each fiscal month.  

The report will show all historical months in blue and for non-color printers with an asterisk-*.

The following screen displays the system parameter that can be customized by the bank.

There is one system parameter for this report which can be changed by the user:

Parameter 1: Bal_Type - Select Average(Avg.) or Ending(End.).  This parameter pertains to the balance sheet side of the General Ledger.  The Income side will always use ending balances.  The report will print which balance type you have selected in the upper right hand area, below the date columns.

Parameter 2: Bdgt_Scenario - Select the budget simulation from the drop down box. The data source field on the report will display the budget simulation name located in the upper left hand corner under the budget set name.

Calculations

This report shows the trend of variance throughout the fiscal year.  Here again is a comparison of actual performance or current projected balance to a predetermined budget balance

$Var = Hist/Proj balance - Budget balance

%Var = $Var divided by the Budget balance (times 100 for a percent)

Balance Sheet Accounts:

Income Statement Accounts: