Useful Tools and Reports
FIS Report 51: This report will give you the current balance summary of your Rate Account and any Subsidy accounts. This is a quick look at how things stand in your total for the Rate activity. Also this report allows you to drill down to detail.
- Sort by Account and Subaccount
- Month Range: Current through Current
- Balance Summary type: year to date
- Chart L
- ORG: DREC
- Sub Account (for this year) R1-12
FIS Report 2: Transaction Listing, This is a great report for showing you every transaction that has taken place in your rate and subsidy accounts. Transactions are listed by Object Consolidation so it is easy to see all the Income, Recharge and expenses. Great for Rates with Program years outside of the normal fiscal year.
- Month Range: Your Program year. (plus a couple of months at the end of the Program year to capture all expenses and income that you anticipate)
- Chart L
- ORG (yours)
- Sub Account (for this year ) R1-12
FIS256 Object Expenditures by Fiscal year : Great report for looking up historical data on expenditures in order to create your Rate budget.
FIS156 Object/Transaction Code Summary: Good for a quick look at your RATE account only.
Payroll Expense Report FIS339: Used to complete the budget to Actual Sheet. Gives you the actual salary and benefit expense per staff.
PPS Staffing Summary PPS34: verify the current salaries of staff in the rate activity
PPS Employee Relations Code PPS75: Used to determine which if the employee is covered by a Union and which one. (you can look up the contracts to determine if there are anticipated increase in the upcoming year)
Riverside: Actual Benefit Cost
Berkeley: Actual Benefit Cost
Davis: Composite Benefit Rate
ANR: Composite Benefit Rate