GLTRIALB General Ledger Trial Balance Report

Trial Balance Report

Application Overview

 

The Trial Balance Report application prints a Trial Balance report in account number or profit center order. These two options provide a detail or summary for a range of accounts that fall within a specified set of dates, within all profit centers or one profit center, or for one financial entity.

 A General Ledger Trial Balance may be obtained at any time.

 A trial balance may be obtained for any date within the fiscal year, for a selected profit center or All profit centers, for a selected financial entity, for active accounts or All accounts, and in detail or summary by General Ledger Account.

 The report displays a running balance, beginning and ending balance, total debits, total credits, period totals, and net change for each account.  Subtotals are printed if they are requested, as specified in the G/L Account File.

 On a detail report, all transactions are shown in detail unless, a compression was previously run and the detail is no longer avail­able.

 If you are uncertain of the dates on all transactions on the file, a starting date of 01/01/00 and an ending date of 12/31/99 will print all transactions.

 You may select either a single profit center or a single financial entity, but not both.  These choices are mutually exclusive.

 

Run Instructions

 

Select Trial Balance from the pull down G/L Reports window.  The following screen will then be displayed:

 


Trial Balance Report Entry Screen

 

 The following options are available:

    • Select the desired mode from the Trial Balance menu bar
    • Enter the data requested on the screen

     To return to the menu bar, press the ESC or F10 key. To leave this application, press ESC and then X for EXIT when positioned at the menu bar.

    Entry Field Descriptions

     

    Name

    Type and Description

    1.  Starting Date

    A date in the standard date format.  Enter the starting date of the range you want to include in your report, or press the RETURN key to default to the   starting date of the current period as defined in the Accounting Period File application.

    2.  Ending Date

    A date in the standard date format.  Enter the ending date of the range to include in your report, or press the RETURN key to default to the end­ing date of the current period as defined in the Accounting Period File application.

    If either the starting or ending date is not a period date, the system will display:

    Warning - Starting Date Is Not            A Period Starting Date-            Is This Ok?.....or

    Warning - Ending Date Is Not             A Period Ending Date-             Is This Ok?

    If you answer Y to these messages the resulting report will include transactions that fall between the starting or ending date range that was entered.

    If you answer N, you will need to enter the correct date. 

    3.  Starting Account

    An account in the standard account number format.  Enter the starting account in the range you want to include in your report, or press RETURN to default to All accounts.

    4.  Ending Account

    An account in the standard account number format.  Enter the ending account in the range you want to include in your report, or press RETURN to default to the same account as you previously entered in the starting account field.

    If RETURN was entered in the starting account, this field will be skipped.

    5.  Show Detail?

    Y or NRETURN defaults to Y.

    If Y is entered then in addition to the summary figures for each account, all transactions for the selected period will also print.  If N, then only the summary figures for each account print.

    6.  Financial Entity

    5 alphanumeric characters.  Enter a valid financial entity number present in your Financial Entity File

    The entity description will then automatically display.

    If you want to skip this field press RETURN.

    7.  Profit Center

    A standard profit center number in the standard profit center number format.

    If your company does not use profit centers, this field will be skipped.     Press RETURN to default to All profit centers.

    If a non‑blank financial entity was entered above, the entry of this field will be skipped.

    8.  Show Only Active

         Accounts?            

    Y or NRETURN defaults to Y.

    If you enter Y, then only accounts within the specified range that have activity within the entered range of dates will print.  If N is entered, all accounts within the specified range will print even if there is no activity for the account in the entered date range.  

    NOTE: If an inactive account is a sub‑total level and this field is Y, then the account sub‑total will not print.  In order to get correct sub‑totaling for an inactive account you must answer N to this field. 

    9. Sub Totals

    Y or N.  This enables the Trial Balance Report to display subtotals.

    If you answered Y to field #5 Detail Report? select one of the following options:

    D   =  Daily/Monthly Tot

                  Prints Daily And Monthly

                  Sub Total.

    M   =  Monthly Tot

                  Prints Monthly Sub Total.

    N   =  No Sub Tot

                  Prints No Sub Total

    If you answered N to # 5

    Detail Report?, this field automatically defaults to N.

    ScreensScreens

     

     

     

    Trial Balance Report (In Account Order)

     

     


     

    Trial Balance Report (In Profit Center Order)

     

     REPORTS

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    General Ledger

    1. GLMENU General Ledger Package Overview
    2. My General Ledger Interface with Other Package Is Out of Balance
    3. Can Journal Ledger Be Imported to General Ledger?
    4. Is There a Way to Pull All Manual GL Entries Out of Elliott?
    5. How to Print a Wider Financial Statement
    6. General Journal Transaction Out Of Balance After Interface with AR
    7. How to Archive GL Data Before Year-End Closing Procedure
    8. GL Year-End Closing Checklist
    9. Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
    10. General Journal Transaction In Balance But Not Able to Post
    11. Net Income from Profit & Loss Statement Does Not Match Balance Sheet
    12. Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
    13. Error During GL Interface from Other Package and Journal Transaction Is Lost
    14. COMPRESS General Ledger Processing Compress General Ledger TRX File
    15. GLBUDMNT General Ledger Budget File Maintenance
    16. GLCMPMNT General Ledger Comparative File Maintenance
    17. GLCONSOL General Ledger Company Consolidation
    18. GLCTLMNT General Ledger G/L Setup
    19. GLDSTMNT General Ledger Distribution Code File Maintenance
    20. GLENTMNT General Ledger Financial Entity File Maintenance
    21. GLJNLLST General Ledger Journal History Report
    22. GLPRDMNT General Ledger Accounting Period File Maintenance
    23. GLPRDSCN General Ledger Period Account Balance Report
    24. GLRATSCN General Ledger Financial Ratio Report
    25. GLRECALC General Ledger Recalculate Account Balances
    26. GLRECENT General Ledger Recurring Journal Trx Processing
    27. GLSRCMNT General Ledger Source File Maintenance
    28. GLTRIALB General Ledger Trial Balance Report
    29. GLWRKSHT General Ledger Print General Ledger Worksheet
    30. INTERFAC General Ledger Interface From Other Packages
    31. TEXTMNT General Ledger Statement Text File Maintenance
    32. SRCEXREF General Ledger Source Cross Reference Report
    33. YEAREND General Ledger Year-End Procedure
    34. GLACTMNU General Ledger G/L Account File
    35. GNJINLENT General Ledger General Journal Trx Processing
    36. My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
    37. Budget File Maintenance Questions & Answers
    38. LAYMNU General Ledger Statement Layout File Maintenance 1
    39. LAYMNU General Ledger Statement Layout File Maintenance 2
    40. LAYMNU General Ledger Statement Layout File Maintenance 3
    41. LAYMNU General Ledger Statement Layout File Maintenance 4
    42. LAYMNU General Ledger Statement Layout File Maintenance 5
    43. LAYMNU General Ledger Statement Layout File Maintenance 6
    44. LAYMNU General Ledger Statement Layout File Maintenance 7
    45. LAYMNU General Ledger Statement Layout File Maintenance: Index
    46. STMNTMNU Select and Print Financial Statements 1
    47. STMNTMNU Select and Print Financial Statements 2
    48. STMNTMNU Select and Print Financial Statements 3
    49. STMNTMNU Select and Print Financial Statements 4
    50. STMNTMNU Select and Print Financial Statements: Index
    51. Job Code Adjustment through GL Journal Entries

    Feedback and Knowledge Base