Main Menu | Reporting | My Reports | Select Report (Budget group) and Edit
The Budget Variance report (IRR1046s.rpt) provides a comparison between MTD and YTD and budget. This comparison provides the user with an analysis of how well one had previously anticipated performance. The variance is typically looking at a change from the budget.
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 Processed: date.
The columns show the volume and yield for Current and Budget, a Dollar Variance to the current month and Percentage Variance to the Current Month.
Each account displays data for the current period comparing actual to budget for both MTD and YTD.
The Budget Variance reports can be configured through their parameter selection to provide different views. The following screen displays the system parameters 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.
Calculations
The data for the current period compares actual to budget for both MTD and YTD.
Current $ Var = Current balance minus Budget balance
Current % Var = $ Var divided by Budget balance (times 100 for a %)
Balance Sheet Accounts:
| • | Balance columns contain respective month's Average Monthly Balances for the account (AVG) or Ending Monthly Balances (END) |
| • | Data is displayed in dollars. |
Income Statement Accounts:
| • | Balance columns contain respective month's Ending Monthly Balances for the account |
| • | Data is displayed in dollars. |