Comparative Financial Statements

The Comparative Financial Statements allows you to compare expenditures and revenues against the budget for more than one year. It will display actuals balances for the selected cycle — as well as the previous fiscal year — and the budget values for both fiscal years.

You must select revenue and expenditure elements for the report to generate the correct values, and for the percentage of budget to display properly.

You can also designate begin and end dates so the report will show the comparative values for the selected fiscal years.

The report is reached by selecting Reports > General Ledger > Comparative Financial Statements and can be created as a PDF or Excel file.

The report contains the following information:

The Summary worksheet includes: fund ID & description, account type, prior year budget & actuals, prior year percentage of budget, selected year budget & actuals, and selected year percentage of budget.

The Detail worksheet includes: fund ID & description, account type & description, prior year account code, prior year budget & actuals, prior year percentage of budget, selected year account code, selected year budget & actuals, and selected year percentage of budget.

Report filters are:

Sample report - summary

Sample report - detail

 

Return to General Ledger Reports Overview