The following table provides a summary of data available via Accounting Projection Reports.
Additional overview information on Reports is available here.
Report Formats and Descriptions
Format |
Description |
Account Expenditure |
|
Account Expenditure Report |
Provides all expenditures on the account—salary and non-salary overview by month by transaction date. Includes total encumbrances, total expenditures, budget, available balance, total direct, total indirect, grand total |
Account Expenditure Reports by Campus Date |
Provides all expenditures on the account—salary and non-salary overview by month by campus date. Includes total encumbrances, total expenditures, budget, available balance, total direct, total indirect, grand total |
Actuals Plus Projections |
|
Actuals Plus Projections by Account, Person |
Provides the salary per month for a specific period of time plus projections for a specific period of time. Data is listed by account and then lists each person on the account. Includes the account number, name, months, and total salary |
Actuals Plus Projections by Person, Account |
Provides the salary per month for a specific period of time plus projections for a specific period of time. Data is listed by person and then lists each account the person is paid from. Includes the account number, name, months, and total salary |
Actuals Plus Projections by Person, Account 2 |
Provides the salary and fringe per month for a specific period of time plus projections for a specific period of time. Data is listed by person and then lists each account (salary and fringe) the person is paid from. Includes the account number, name, months, and total salary |
|
|
FBC Find Grid |
Provides all data listed on the find grid (info populated in the Salary Data) |
Fringe Benefit Table |
Provides a breakdown of all fringe benefits by object code for each employee paid on the account. Includes ID/name, rate/cost center, FTE, start and end dates, fringe benefit object codes, and total fringe for each person |
Monthly Burn Rate |
|
Monthly Burn Rate Plus Projections Report |
Provides detailed salary and fringe on a monthly basis by line item for actual dates and projected dates within one year. Includes actual average, monthly budget, amount over/under, and remaining balance |
Monthly Burn Rate Plus Projections Report Summary with Directs |
Provides summary of salary and fringe and other direct on a monthly basis for actual dates and projected dates within one year. Includes total, actual average, remaining balance for directs, and total remaining balance |
Monthly Burn Rate Plus Projections Report with Directs |
Provides detailed salary and fringe and other direct on a monthly basis by line item for actual dates and projected dates within one year. Includes actual average, monthly budget, amount over/under, and remaining balance |
Monthly Expense Percentage |
|
Monthly Expense Percentage by Account, Person |
Provides total monthly expense percentage for each account, also provides percentage breakdown for each employee paid on the account. Includes names, month(s), total FTE |
Monthly Expense Percentage by Person, Account |
Provides total monthly expense percentage for each employee, also provides percentage breakdown for each account that the employee is paid on. Includes ID, name, account(s), month, total FTE |
Format |
Description |
Monthly Expense Percentage by Person, Account w/Cost Share |
Provides total monthly expense percentage for each employee, also provides percentage breakdown for each account that the employee is paid on including cost share acct. Includes ID, name, account(s), month, total FTE |
Monthly Expenses |
|
Monthly Expenses by Account, Person |
Provides total monthly expense for each account, also provides expenses for each employee paid on the account. Includes name, month, total fringe, total salary, grand total for each person paid on the account, and total costs per month |
Monthly Expenses by Person, Account |
Provides total monthly expense for each employee, also provides expenses for each account that the employee is paid on. Includes ID, name, account(s), month, total fringe, total salary, and grant total for each account, and total costs |
Monthly Expenses by Person, Account 2 |
Provides the salary and fringe per month for a specific period of time. Data is listed by person and then lists each account (salary and fringe) the person is paid from. Includes the account number(s), name, months, total fringe, total salary, grand total, and total costs |
Monthly Expenses plus Projections and Budget |
Provides the expenses (salaries, non-salary, indirect) per month for a specific period of time – includes actuals plus projections. Includes the name(s), months, total encumbered, total actual expense, total projected, budget, variance, and total. |
Monthly Expenses plus Projections and Budget (60 months) |
Provides the expenses (salaries, non-salary, indirect) per month for a period of 60 months—includes actuals plus projections. Includes the name(s), months, total encumbered, total actual expense, total projected, budget, variance, and total. |
Payroll Projection |
|
Payroll Projection Report |
Provides payroll projected for a given period of time, broken out by personnel type and then employee. Includes name, avg. monthly pay, FTE, project period, begin and end dates, projected salary and benefits, total, avg acct., and monthly pay |
Payroll Projection Report with Cost Center |
Provides payroll projected for a given period of time including cost center(s), broken out by personnel type and then employee. Includes name, begin and end dates, account rate, FTE, project period, total salary, projected period, salary, and benefits, and projected salary and benefits. |
Payroll Projection Report with Pay Periods |
Provides payroll projected for a given period of time with pay periods, broken out by personnel type and then employee. Includes name, begin and end dates, average monthly pay, FTE, average account monthly pay, projected period, salary, and benefits, and projected salary and benefits |
Position Control |
|
Position Control by Object Code |
Provides position number and object code for each person paid from the account. Includes position number, name, cost share, from and to dates, annual rate, budget amount, salary amount, balance, and total for the position number |
Position Control by Position # |
Provides position number for each person paid from the account. Includes position number, name, cost share, from and to dates, annual rate, budget amount, salary amount, balance, and total for the position number |
Format |
Description |
Projection to Actual |
|
Projection to Actual Comparison by Employee |
Provides projected amount of salary and fringe line items for the employee in comparisons to the amount that was actually paid for the employee. Includes salary and fringe projected, actual, and difference |
Projection to Actual Comparison Summary by Employee |
Provides a summary of the projected amount of salary and fringe for the employee in comparisons to the amount that was actually paid for the employee. Includes salary and fringe projected, actual, and difference |
Projection to actual Comparison Summary by Employee and Account |
Provides a summary of the projected amount of salary and fringe for the employee in comparisons to the amount that was actually paid for the employee. Also provides the account(s) the employee was paid on. Includes salary and fringe projected, actual, and difference |
Salary and Benefits Table |
|
Salary & Fringe Benefits Table |
Provides a breakdown of all salary and fringe benefits by object code for each employee paid on the account. Includes ID/name, rate/cost center, FTE, start and end dates, salary and fringe benefit object codes, and total salary and fringe for each person. |
Salary Table |
Provides total salary for a specified period of time for each employee paid on the account. Includes ID/name, acct#/cost share, rate/cost center, FTE, start and end dates, salary w/object code listed, and total |
Total Salary and Benefits Table |
Provides TOTAL salary and fringe benefits for a specified period. Includes, name, acct, FTE, start and end dates, salary, fringe, total salary & fringe |
Total Salary and Benefits with BW/MTH Salaries |
Provides total salary and benefits with biweekly and monthly salaries. Includes name, account, rate, FTE, start and end dates, annual salary, annual fringe, and total salary and fringe |
Total Salary and Benefits with BW/MTH Salaries and Account subtotals |
Provides total salary and benefits with biweekly and monthly salaries and subtotals each account the employee is paid from. Includes name, account, rate, FTE, start and end dates, annual salary, annual fringe, and total salary and fringe |
User Defined Columns |
Provides reports that are specifically created and defined for the user |
Sample Reports