Skip to main content

Balance Sheet Account Balance

Controller's Office

Purpose

Determine the PeopleSoft Financials balance of an account as of a specific date

Query

CU_GL_ACCOUNT_BALANCE


Steps
Navigate to the Budget Management homepage
image2021-4-20_13-55-9.png

Select Query Viewer
image2021-4-20_13-52-33.png

Search for CU_GL_ACCOUNT_BALANCE
image2021-4-20_13-57-33.png

Save it to your Favorites so you won't need to search for it next time
image2021-4-20_13-58-59.png

Select Run to HTML
image2021-4-20_14-0-57.png

Enter the Account and as of Date you are inquiring about; Hit View Results
image2021-4-20_14-5-47.png

The results will appear on the screen
image2021-4-20_14-7-6.png

Launching the query opened a new tab which you can close when you are done without exiting PeopleSoft
image2021-4-20_14-9-30.png


How to get the detailed transactions for an account for a specific timeframe