Pivot Table YTD (Year to Date) Guide

The YTD Pivot Tables present expenditure data on a cash basis where expenditures are recognized in the fiscal year that they are paid, not incurred. Requisition amounts that remain unpaid at the end of the year are not included in these expenditure amounts. However, unpaid requisition amounts from prior years paid during the current year are included in these schedules. The downloaded expenses represent all expenses paid for the fiscal year and reconciles to the SFS General Ledger.

The pivot tables will aid the user in expense and revenue trending analysis and will permit the user to further customize the tables per their analytical preference. Expense data are from fiscal years 2010, 2011, 2012 and YTD 2013. The user can select one year, or all years for analysis. In addition, there is a blank pivot table for further customization and analysis of selected downloaded data.

Four Year to Date Pivot Tables were created to analyze divisional expense data:

1.  YTD by Div, Dept, Fund, Year – The pivot table will show expenses by fiscal year for User specified expense criteria by Division, Department and Fund.

2.  YTD by Div, OwnDD, Acct, Obj Class – The pivot table will show expenses by fiscal year for user specified expense criteria by Owning department, Account (fund-ProjDept) and Object Class. Object Classifications are:

·  Capital

·  Fringe Benefits

·  Loan Fund Expense

·  Mandatory Transfers

·  Non Mandatory Transfers

·  Other Operating Expenses

·  Plant Additions

·  Prior Service Cost

·  Salaries

·  Scholarships and Fellowships

·  Supplies and Services

·  Tuition Fee Allocation

3.  YTD by Div, Program, Fund Grp – The pivot table will show expenses by fiscal year for user specified expense criteria by Division, Program and Fund Group. Fund Groups are:

·  1 General Program Ops

·  2 Other State Funds

·  3 Revolving-Auxiliaries and Hospitals

·  4 Revolving – General

·  5 Federal

·  6 Gifts and Endowments

·  7 State Bldg Trust Fund

4.  YTD by Div, Fund, Account – The pivot table will show expenses by fiscal year by Division, Fund and Account (SFS Account Codes-Descriptions)

Page 1