In this lesson you will learn how to run the Trial Balance by Object Report.
We have listed two ways to navigate to the Trial Balance by Object Report process. This lesson will be using the Accounting navigational steps.
Accounting > Inquiries & Reports > Accounting Reports > Balance Reports > Trial Balance Reports > Trial Balance by Object
Budget > Agency Budget Management > Inquiries & Reports > Accounting Reports > Balance Reports > Trial Balance Reports > Trial Balance by Object
Click the State of Nebraska link.Step 1
Click the Accounting link.Step 2
Click the Inquiries & Reports link.Step 3
Click the Accounting Reports link.Step 4
Click the Trial Balance Reports link.Step 5
Click the Trial Balance by Object link.Step 6
Click the Data Selection option.Step 7
Click the Submit button.Step 8
Click the drop down list of the Right Operand column for the Object Account row.
Click the Literal list item.Step 10
Enter the Object Account into the Literal Value field. Enter "454100".Step 11
Click the OK button.Step 12
Click the drop down list of the Right Operand for the Fund row.Step 13
Click the Literal list item.Step 14
Enter the fund into the Literal Value field. Enter "10000".Step 15
Click the OK button.Step 16
Note: If running for fund 10000 or 40000, also narrow report by a business unit or range of business units to see information for your agency only and to avoid excess processing time.
To narrow the report by business unit, complete the following information:
Left Operand – Business Unit(F0901)(MCU)[BC]
Comparison – is equal to
Right Operand – enter the business unit
In this lesson we are not going to narrow by business unit.Step 17
Click the OK button.Step 18
On the Select tab review and complete the following fields as needed:
Fiscal Year – enter the fiscal year for which to run report (Ex. Enter 6 for Fiscal Year beginning July 1, 2006.)
Period – enter the period for which to run report (Ex. Enter 1 for July 1)
Ledger Type – enter the ledger for which to run report
Note: Run on BF ledger to see what budget amounts were entered. (If running on BF ledger, do not enter an object range on the Summarize tab so you can see BU.object codes)
Subledger – enter * to see correct balances
In this lesson we are not going to change any to of the data in these fields.Step 19
Click the Print tab.Step 20
Revew the fields on the Print tab.Step 21
Click the Currency tab.Step 22
Review the field on the Currency tab.Step 23
Click the Summarize tab.Step 24
To see what has been spent on an object for an entire fund, click the Summarize tab and complete the following fields:
Beginning Range Object Account Summarization
Ending Range Object Account Summarization
Note: If a range is not entered, you will see balances by BU.object codes.
In this lesson we are not going to use these fields.Step 25
Click the OK button.Step 26
Click the OK button.Step 27
To view the report you will need to go to View Job Status. For more information go to the Reports Lesson under the System Basics Training Guides.
You have successfully completed this lesson.
Table of Contents Start Topic