Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

Detailed Accounting Trial Balance - Screen Overview

Detailed Accounting Trial Balance

Screen Code: gltdatbpm

The following three reports provide information about trial balance and their format:

  1. Detailed Accounting Trial Balance
  2. YTD Detailed Account Trial Balance
  3. One Account YTD Trial Balance

The Detailed Accounting Trial Balance report shows all journal entry transactions for the selected month. You can further drill down into the data shown by specifying a fund, department, and program, and even an account object range.

Navigation Tip: General Ledger >> Financial Reports >> Detailed Accounting Trial Balance.

mceclip0.png

It has the following parameters:


Field


Description


Fund group


Name of the Fund Group. Leaving blank lists all the fund group names. When you enter a fund group, the other optional fields like Fund Number, Department number, and Program number will be cleared.


Fund number


Name of the Fund Number. Leaving blank or zero lists all the fund numbers. When you enter a fund number, fund group selection will be disabled.


Department number


Department number denotes the key field of Department name.


Program number


Program numbers associated with one Fund or Department might differ from the description for the same Program number within a different Fund or Department.


From Object


Object Code Start Range


To Object


Object Code End Range


Period Ending


Accounting Period ending in mmyyyy format


Generate Spreadsheet


If Yes - The report will be created in a spreadsheet format and sent to a shared directory.


Include JE detailed comments


If Yes, then the comments in the JE detail lines will be printed


JE detail description first


Sort order on JE detail description.

Click Submit. Submit Parameter page appears. Enter the Job Description, date, time to run the job, and a number of copies and click Submit again.

Print_Detailed_Account_Parameters.gif

It displays the following message at the bottom of General Ledger - Additional Reports Menu:

mceclip1.png

Version 1

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.