Summary Budget Comparison Report

To access this report, go to Reports > Budget > Summary Budget Comparison

Use this report, which can be generated for any account type or account code combination, to print data comparing current year or period budgeted revenues and expenses with current year or period actual revenues and expenses. Budget data was entered when the budget worksheet was set up using Transactions > Budget Transactions.

Budget Version and User Defined Field Columns: When a new Budget Version is added by the Administrator, and you have a UDF with a BD transaction source, at least six new columns will be added to this report, such as Current Period Actual # - {UDF Display Name}, YTD Actual # - {UDF Display Name}, Total Actual # - {UDF Display Name}, Current Period Budget # - Original - {UDF Display Name}, YTD Budget # - Original - {UDF Display Name}, and Total Budget # - Original - {UDF Display Name}. (Otherwise, three columns are added, such as Current Period Budget - Original, YTD Budget - Original, and Total Budget - Original). Therefore, the number of columns in this report can grow exponentially.

Tip: If you're not familiar with the MIP Cloud Report Builder interface, see Report Builder for an introduction.

You can choose to use the report as-is by selecting Export or View, or make edits to the report by selecting Edit.

If you choose to make edits to the report, the Report Builder page will display. From this page, use the Setup tab to choose the columns you'd like to appear on the report. You can rename the columns under the Column Heading.

 

The following columns are available to include in the report:

Column

Description

Account Type

The General Ledger account type, such as EXP or REV.

Account Code

The actual account code assigned to the account, such as 201, 05, or 45001.

Account Title

The actual title assigned to the account code, such as Housing or Service Fees.

Account Short Title

Usually the first 15 characters of the Account Title. The report prints an account short title, such as Housing or Svc Fees.

Effective Date

The line item's effective date.

Prior Year Current Period Actual

This monetary amount is calculated by taking the net amount of actual decreases and increases for the prior year period Opening Balances Date through the prior year Ending Balances Date.

Prior Year Actual

This monetary amount is calculated by taking the net amount of actual decreases and increases for the prior year Current Reporting year Begins date through the prior year Ending Balances Date.

Current Period Actual

This monetary amount is calculated by taking the net amount of actual decreases and increases for the period Opening Balances Date through the Ending Balances Date.

YTD Actual

This monetary amount is calculated by taking the net amount of actual decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year.

Prior Year Budget - {Budget Version Display Name}

This monetary amount is calculated by taking the net amount of budget decreases and increases for the Current Reporting Year Begins date through the Ending Balances date of the prior year.

Current Period Budget - {Budget Version Display Name}

This monetary amount is calculated by taking the net amount of budget decreases and increases for the period Opening Balances Date through the Ending Balances Date for the specified Budget Version.

Current Period Budget Variance - {Budget Version Display Name}

This is the expense and revenue variance for the calculation between the Current Period Actual amounts and the Current Period Original Budget amounts.

YTD Budget - {Budget Version Display Name}

This monetary amount is calculated by taking the net amount of budget decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year for the specified Budget Version.

YTD Budget Variance - {Budget Version Display Name}

This is the expense and revenue variance for the calculation between the Current Year Actual amounts and the YTD Original Budget amounts.

Total Budget - {Budget Version Display Name}

This monetary amount is calculated by taking the net amount of decreases and increases for the period Total Budget From date through the Total Budget (on the Options tab) for the specified Budget Version.

Total Budget Variance - {Budget Version Display Name}

This is the expense and revenue variance for the calculation between the Current Year Actual amount and the Total Original Budget amounts.

Percent Total Budget Remaining - {Budget Version Display Name}

This amount, which is represented using a percentage, is calculated by taking the Total Original Budget less the Current Year Actual, and then dividing the result by the Total Original Budget.

Percent Total Budget Used - {Budget Version Display Name}

This amount, which is represented using a percentage, is calculated by taking the YTD Actual divided by the Total Original Budget.

{Custom Columns}

A custom column that was created.

Prior Year Actual # - {UDF Display Name}

This number amount is calculated by taking the net amount of actual decreases and increases for the prior year Opening Balances Date through the prior year Ending Balances Date for the specified Budget Version and the specified UDF.

Current Period Actual # - {UDF Display Name}

This number amount is calculated by taking the net amount of actual unit decreases and increases for the period Opening Balances Date through the Ending Balances Date for the specified UDF.

YTD Actual # - {UDF Display Name}

This number amount is calculated by taking the net amount of actual unit decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year for the specified UDF.

Total Actual # - {UDF Display Name}

This number amount is calculated by taking the net amount of actual unit decreases and increases for the period Total Budget From date through the Total Budget Through date for the specified UDF.

Prior Year Budget # - {Budget Version Display Name} - {UDF Display Name}

This number amount is calculated by taking the net amount of budget decreases and increases (having an entry type of UO) for the Current Reporting Year Begins date through the Ending Balances date of the prior year for the specified Budget Version and the specified UDF.

Current Period Budget # - {Budget Version Display Name} - {UDF Display Name}

This number amount is calculated by taking the net amount of budget unit decreases and increases for the period Opening Balances Date through the Ending Balances Date for the specified Budget Version and the specified UDF.

YTD Budget # - {Budget Version Display Name} - {UDF Display Name}

This number amount is calculated by taking the net amount of budget unit decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year for the specified Budget Version and the specified UDF.

Total Budget # - {Budget Version Display Name} - {UDF Display Name}

This number amount is calculated by taking the net amount of unit decreases and increases for the period Total Budget From date through the Total Budget Through date for the specified Budget Version and the specified UDF.

Use the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, to implement security features, and more.

  • "Total Budget" - Select the start and end date you want to use to calculate and print total budget amounts. This range can exceed a 12 month interval.

  • Select "Summarize Amounts" to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

  • Select "Do Not Allow Changes to this Report" to secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.

  • Select "Year End Adjustments" to include year end adjustments on the report. This entry type was designated during transaction entry.

  • Select "Only Revenue and Expense Type Codes" to show only these account types on the report.

  • Select "Rounding" to round the amounts to the nearest whole number when printing the report. Select "None" to not round the amounts.

  • Select "Open Entries in Detail" to include opening balances (system or user opening entries) in detail.

  • Select "Replace total debits and credits with Balance" to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.

  • Select "Suppress Lines with All Zeros" so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

Use the Layout tab to change the font and page setup for a report.