COMPRESS General Ledger Processing Compress General Ledger TRX File

Compress General Ledger Trx File

Application Overview

 

The Compress General Ledger Transaction File application will consolidate General Ledger transactions according to the account's compression code in the G/L Account file for all transactions dated within the current fiscal year through a cut‑off date.  It may be run after the financial statements for a given period have been obtained and no more detail is desired for each transaction.

 

Each transaction posted to G/L is retained on file.  This may result in significant use of disk space but should not cause degradation in performance when running financial statements and other reports as long as they are processed within valid period ranges.

 

Five options are available:

 

a. If file space or slow performance is not a problem, all trans­actions may be left on file.

 

b. Transactions may be compressed by date.  When date compression is used, all G/L entries are compressed to one transaction for each day for each account.

 

    Example:

 

         Account # - 05030 - XXXXX - XXXXX Wages

 

         Date                       DR                          CR

 

           9/3                         10.00

           9/5                                                       10.00

           9/6                       345.80

           9/6                                                       22.44

           9/6                       182.40

           9/6                         92.90

           9/29                     252.08

           9/29                     165.00                          .  

                                   1,057.22                      32.44

After the transactions are compressed the file will contain:

 

         Account # ‑ 05030‑XXXXX-XXXXX     Wages

 

         Date                       DR                          CR

 

         9/3                          10.00

         9/5                                                        10.00

         9/6                        598.66

         9/29                      417.12

 

c.    Transactions may be compressed by period.  When period compression is used, all entries in each G/L account are compressed to one transaction for each accounting period.

 

d. Transactions may be compressed by source within date.  When this is used, all G/L entries with the same source and the same date are compressed into one transaction.  The sources of the original transactions are retained.

 

e.    Transactions may be compressed by source within period.  When this is used, all entries in each G/L account with the same source and within one period are compressed to one transaction.  The sources of the original transactions are retained.

 

The source field is changed to Comp for options b and c above.  The reference is changed to Summary Net Change This Date for date com­pressed transactions and Summary Net Change This Period for period compressed transactions.

 

Most likely the total debits and total credits will now be different on the General Ledger Transaction file.  The net change and ending balance should be the same for the periods compressed within the cut‑off date.  Transactions that were compressed and whose totals counter‑balanced will have been deleted.


Run Instructions

 

Select Compress General Ledger Trx File from the pull down G/L Processing window.  The following screen will then be displayed:

 

 

Compress General Ledger Trx File Entry Screen

 

 

  

 The following options are available:

    • Enter the period cut‑off date when requested.  This date must be a valid period ending date.
    • Enter the data requested on the screen.
    • All processing is automatic from this point. To terminate the program without processing press the ESC or F10 key while positioned for entry of the cut‑off date.

     

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

     

    Entry Field Descriptions

     

    Name

    Type and Description

    Please Enter Period Cut‑Off Date

    Enter a date in the standard date format.  Pressing RETURN defaults to the current period ending date as defined in the Accounting Period file.

     

    The date you enter must be the ending date of some period defined in the Accounting Period file.

     

     

     

     


     

    Compress General Ledger Trx File

    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
    52. How to Distribute Sales to General Ledger by Warehouse Location

    Feedback and Knowledge Base