Budget Analysis - Budget vs. Current Year End Comparison

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

The Budget Analysis - Budget vs. Current Year End Comparison (IRR1045s.rpt) provides a comparison of a future budget with the current balance to determine how much the future budget changed accounts from the current balance.  This report reverses the calculations for variance as the comparison is to the current, not the budget.

This report is not typically used as a budget variance report in the budget year, but was intended as an aid in developing a budget. With it, you can get a measure of how your developing budget varies from your current year end performance.

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.

The Budget Variance - Budget vs Current Year End Comparison report can be configured through the parameter selection to provide different views. 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, above the column headers.

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

In this report:

$Var – Budget balance - Current balance

%Var - $Var divided by Current balance

This report was not set up as a default so you would not confuse it with the existing reports, but can easily be set to display on your listings in the Advanced Income Shock module.

Balance Sheet Accounts:

Income Statement Accounts: