This page displays the posted expenses for a project on a monthly basis for the budget period. Information is organized by expense category and account. Expenditure reports can be generated based on time periods such as budget, project or fiscal year. The total column reflects what the cumulative monthly totals are for the specified time period.
Caption |
Type |
Description |
Category |
Dropdown |
Lists different expense categories such as Salaries & Wages, Travel, Equipment, etc. |
Account # |
Text |
Expense accounts under categories such as salaries, equipment, supplies, etc
|
Month From |
Text or Calendar Control |
Monthly search from date; can select using the calendar control. Date range not limited to 12 months. |
Month To |
Text or Calendar Control |
Monthly search to date; can select using the calendar control. Date range not limited to 12 months. |
Project Header
Caption |
Type |
Description |
Fund # |
Text |
Displays the PeopleSoft fund number for the Contract. |
Status |
Text |
Displays the fund status – Active, Inactive, etc. |
PI Name |
Text |
The name of Principal Investigator of the Agreement |
Project Title |
Text |
The name of the Agreement (Project) |
Sponsor Name |
Text |
The name of the Sponsor |
Sponsor # |
Text |
The Sponsor number for the project |
Budget Start/End |
Text |
The Budget start and end dates |
Project Start/End |
Text |
The Project start and end dates |
Main Page Elements
Field |
|
Description |
Last GL Post |
Label |
The last date when the General Ledger data was received |
Category |
Text |
Expense category such as Salaries & Wages and Equipment, among others. |
Account # |
Text |
Expense accounts viewed under categories by clicking the ‘+’ sign. |
Months |
Text |
Monthly total expenditure by category and account |
Total |
Text |
Sum of monthly total in period |
Direct Costs |
Text |
Sum of expenses by month. |
Indirect Costs |
Text |
Indirect cost allowance per month |
Total Costs |
Text |
Total Direct Expense + Total Indirect |
Revenue |
Text |
Sum of total revenue deposited by month |
Cash Balance |
Link |
Sum of total revenue deposited against the fund minus the total expenses to date. Links to Budget Details. |
Reports can be downloaded by clicking on the available download links.
Download to Excel
Download to PDF
The navigation trail keeps track of the path that the user came in from to allow for easy ‘back’ access to where they came from. Example:
Agreement Summary >> Expense Details
The Expense Details page can be accessed from the following pages:
Sub-modules
From clicking on the Expense Details tab from the following pages:
Project Details
Contract Details
Salary Details
Transaction Details
Budget Details
Projections
Links
Financial Summary by clicking on ‘Last Month Expenses’ link
From Expense Details the user can navigate to:
Sub-modules
Project Details
Contract Details
Salary Details
Transaction Details
Budget Details
Projections
Financial Summary
Agreement Summary
Links
Category amount:
Transaction Details for all categories except Salaries and Fringe Benefits
Labor Distribution for Salaries and Fringe Benefits categories
Revenue Breakdown by clicking on ‘Revenue’ link
Budget Details for selected month ending in the grant general statement, by clicking on ‘Cash Balance’ link.