Trial Balance by Object Lesson


In this lesson you will learn how to run the Trial Balance by Object Report.

 

Navigation:

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

 

or

 

Budget  > Agency Budget Management > Inquiries & Reports > Accounting Reports > Balance Reports > Trial Balance Reports > Trial Balance by Object


Steps:

  1. Click the State of Nebraska link.

    Step 1
  2. Click the Accounting link.

    Step 2
  3. Click the Inquiries & Reports link.

    Step 3
  4. Click the Accounting Reports link.

    Step 4
  5. Click the Trial Balance Reports link.

    Step 5
  6. Click the Trial Balance by Object link.

    Step 6
  7. Click the Data Selection option.

    Step 7
  8. Click the Submit button.

    Step 8
  9. Click the drop down list of the Right Operand column for the Object Account row.

     

     

    Step 9
  10. Click the Literal list item.

    Step 10
  11. Enter the Object Account into the Literal Value field. Enter "454100".

    Step 11
  12. Click the OK button.

    Step 12
  13. Click the drop down list of the Right Operand for the Fund row.

    Step 13
  14. Click the Literal list item.

    Step 14
  15. Enter the fund into the Literal Value field. Enter "10000".

    Step 15
  16. Click the OK button.

    Step 16
  17. 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
  18. Click the OK button.

    Step 18
  19. 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

     

    Subledger Type  

     

    In this lesson we are not going to change any to of the data in these fields.

    Step 19
  20. Click the Print tab.

    Step 20
  21. Revew the fields on the Print tab.

    Step 21
  22. Click the Currency tab.

    Step 22
  23. Review the field on the Currency tab.

    Step 23
  24. Click the Summarize tab.

    Step 24
  25. 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
  26. Click the OK button.

    Step 26
  27. 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