Variance analysis reports help quantify and identify the difference in actual expenditures or revenues between fiscal years and quarters. In some cases, variance is calculated by comparing budget to actuals and in others the comparison is based solely on actuals.

The Quarterly Variance Analysis Reports were designed by Analysis, Planning and Budget for the purpose of tracking budgets within a given year and between years. By request of Analysis, Planning and Budget this template has been moved to the Integrated Budget and Finance Page within the Budget Reports for 1A & 1B section of this site.

The Year-End Variance Analysis Reports are specifically designed for the year-end exercise. These reports are intended to facilitate the variance analysis exercise conducted by the Office of the Controller and required by 捆绑SM社区鈥檚 External Auditors.

• Variance Analysis How To
• Variance Analysis Grid
• Note that for 2. Salary related analysis; one might find Multi Period Payroll Details听useful. Payroll related reports may be found on the Payroll Reports page.

Instructions for logging in to reports and exporting data is available on the Running Web & Crystal Reports page..
Crystal Reports software is not required to run the web report templates.

Year-End Variance Analysis Report Templates

Variance Analysis CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2014-03-24

Description:
Displays specific revenue and expense related line items as per the audited financial statements for all unrestricted funds by Organization Code, regardless of the organization level. Displays Operating and Self Financing totals by current and prior fiscal years. Provides comparison in dollars and percentage current versus previous line item totals. Drilldown allows for information at the detail level by org, fund, and account codes.

Report Help:听

Variance Analysis Report Help

Prompting Query Fields:
- Current Fiscal Year
- Prior Fiscal Year
- Org Code
- Org Level

View Information [for Crystal Report]:
View: FG_Yearly_Operating_Statement
View: FG_Fund_Profile

Year-End ME Documents Report

听