Project Expenditure Details Report

This guide will cover:

  • How to navigate and run the Project Expenditure Details report
  • This report provides a detailed list of all expenditures charged to a project

Step One

Upon accessing WyoCloud from WyoWeb, navigate to Reports and Analytics.

  • Click on the Navigator (three horizontal lines) in the upper left corner of the homepage.

  • First click on Tools to expand (you may need to scroll within the navigator), then click Reports and Analytics.

  • The Reports and Analytics page is displayed.

 

Step Two

Navigate to the Transactional Reporting Table of Contents, where the Outstanding P-Card Transactions Report is located.

  • Select the small double arrow above the search.

  • From the drop down, select Shared Folders.

  • All Shared Folders you currently have security access for will display.  To locate the Transactional Table of Contents, begin by clicking on the Custom folder (you may need to scroll to locate it).

  • Click Dashboards.

  • Click Table of Contents.

  • To open the Table of Contents, click on the title

Note: You can set the Table of Contents as a favorite for easier navigation in the future.  For directions see this Quick Reference Guide.

 

Step Three

Running the Project Expenditure Details report

  • Under the Project Portfolio Management heading on the Table of Contents, click on Project Expenditure Details.

  • The report will begin to automatically run a list of data for all Project Expenditure Details and projects. **Wait until the report has produced a list of data before using any of the prompts

Example – report completed with full list of data

 

Step Four

Narrowing down the Project Expenditure Details report

  • You may use the following prompts to narrow the report to only display projects relevant to your needs.  It is recommended to prompt by project number. Note, in most cases you can leave a prompt blank or leave the default in any or all prompts. 
    • Project Number – Project number
    • Accounting Date From – Beginning accounting date for the expenditures
    • Accounting Date To – Ending accounting date for the expenditures
    • Expenditure Date From – Beginning expenditure date for expenditures
    • Expenditure Date To – Ending expenditure date for the expenditures
    • Invoice Number – Invoice number for the associated expenditure

 

The Accounting Date is when the expenditure is recognized and posted to the general ledger (GL). The Expenditure Date is when the expenditure was incurred.  For example, you may receive an order for supplies on March 25th, the invoice for the supplies was received on April 1st, and payment was issued on April 10th, thus posted to the GL on April 10th.

 

  • After selecting desired prompts, click Apply

  • The following columns are included:

Column Name

Column Definition

Project Number

Project number assigned

Project Name

Name of project

Accounting Date

Date when the expenditure is recognized and posted to the general ledger (GL)

Expenditure Date

Date when the expenditure was incurred

Transaction Number

System-generated number that uniquely identifies the expenditure item. This number can be used to search within Grants Management or Projects depending on your security roles to view the original document within the application.

Expenditure Organization

Organization where the expenditure was charged to

Expenditure Category

High level classification of expenditures (ex. Salaries, Wages, and Fringe Benefits)

Expenditure Type

Detailed classification of expenditures (ex. Fringe Rate)

Funds Status

Status of funds for the project allocated to the expenditure: Failed, Reserved, Reserved with warning, In process, etc.

User Batch Name

Name of the journal entry batch number associated with the expenditure. This column also includes the IDT number.

Document Name

Type of document associated with the expenditure (ex. IDT, Expense Report, Miscellaneous Expenditure Burdened, etc.)

Invoice Number

The invoice number associated with the expenditure (this number can either be the supplier invoice or expense report number)

Employee Name

Name of the employee for either a personal reimbursement or any p-card transaction processed on an expense report. Note: The employee name will not populate for payroll expenditures.

Supplier Name

Name of the supplier the expenditure is for

Comment

Line description associated with the expenditure

Raw Cost Amount

Base cost of the item without any burden added to acquire the product/service

Expenditure Amount

Total expenditure amount

Last Updated Date

The last date the expenditure item was updated

Last Updated By

The employee username of the person who last updated the expenditure item

 

Step Five

Exporting the data to Excel

  • The options to export and/or print are located on the top right side of the report.
    • Click on the gear icon
    • Hover over the Export option
    • Click on Excel (*.xlsx)

 

 

You have now navigated to and ran the Project Expenditure Details report.

 

Was this helpful?
0 reviews

Details

Article ID: 83993
Created
Tue 7/30/19 8:12 AM