GMS Agency Program Analysis Spreadsheet

#320 Agency program analysis spreadsheet

This supplement will create spreadsheet presentations of project or element financial activity by line item or cost category. You select which type of information you want to include in each column - budgets, prior year, current month, current year, or project to date data. You have the choice to prepare the analysis using regular month end data or cost allocation detail, if you use Supplement #399 Consolidated Cost Allocation Detail. With the flexibility of retaining groups of projects and elements, its use is unlimited. Some examples are developing departmental reports based on contract year, an analysis of all program administration elements, determining fiscal year grantor costs for the audit report which grant and contract years vary from the agency's fiscal year, and budget analysis preparation.