You can run the Cost Share Expenditures query (UGA_GM_OP_COSTSHARE_EXP_DTL) to view a detailed list of cost share expenditures with related transaction IDs. The query can be accessed in the Grants WorkCenter or via Query Viewer on the UGA Financials homepage.
In this article, you will learn to run the Cost Share Expenditures to view a detailed list of cost share expenditures with related transaction ID.
First, log into the Financial Management System.
On the UGA Financials homepage,click the Grants tile.
In the Grants Center menu on the left side of the page, click the Grants WorkCenter link.
Click the Reports/Queries tab.
In the Reports/Processes section, click the Query Viewer link.
Note: You can also access this query using the Query Viewer tile from the Financials page.
Click the << button to close the Grants WorkCenter menu.
The Query Viewer page is displayed.
Enter the query name " UGA_GM_OP_COSTSHARE_EXP_DTL " into the begins with field.
Click the Search button.
The searched query is displayed.
Click the HTML link.
In the Project field, you can enter a Project ID. If you do not know the Project ID, enter the % sign to display all awards.
Enter appropriate information into the Project field.
Example shown here: " % ".
Click the View Results button.
The results are displayed. Click the Excel SpreadSheet link to open the document in an Excel file.
Click the Open button.
The Excel file opens in a protected view. Click the Enable Editing button to work with the document.
The Excel file is displayed, showing Chartstring and Accounting Date information. You can filter through the columns to view the information you need.
Scroll to the right to view additional columns.
The Amounts and Journal IDs of the transactions are displayed.