In order to analyze per pupil spending you must examine multiple years of expenditures. The data can be extracted from alio by following these steps:

1 FAS>>FAS Reports>>Variable Column Report>>Build Variable Report Styles>>Select Style Description – Historical Expenditures Update Headings to reflect new years being reported. the example below would be used to gather information for use in the 20-21 budget

2 FAS>>FAS Reports>>Variable Column Report>>Report No is Expenditure History>>Select Use This Report Spec>>Select Style 43 Historical Expenditures>>Select Run Report Your alio Default Year should be the current year in order to extract correct prior year information. Select Open in Spreadsheet to work with the data in Sheets

Update the Sheets workbook to reflect new year’s data, Expenditure History through June 30, 2022

Revision: 3
Last modified: 17 November 2022