How to Archive GL Data Before Year-End Closing Procedure

Q:   Our year-end closing procedure will purge all detail transactions, but I don't want to lose my previous-year GL  transactions because they contain important data that I would like to go back to for reporting and auditing in the future.  So I would prefer a method to archive my GL Transaction file before I trigger year-end closing. Can you provide the steps needed to perform that archive?

A:  The strategy is to use Elliott's Multi-Company feature and create an archive company for historical inquiry purposes.  In Elliott, typically there will be a mapped network drive and a root Elliott folder to store data and programs. Just as a way to explain by example, the Elliott root folder may be:
        M:\Elliott7

Throughout this document, we will refer to the M:\Elliott7 folder even though that is not necessarily your actual Elliott root folder. With regard to any instructions in this document that refer to M:\Elliott7, you can just change it to your actual Elliott root folder.  Your data will be stored in DATA or DATA_?? folders under the Elliott root folder.  For example, your Company 1 data will be stored in the M:\Elliott7\DATA folder and your Company 2 data will be stored in M:\Elliott7\DATA_02 folder. Using this principle, you can see how Elliott supports up to 99 companies.

Let's say your production company is Company 1, so your production data resides in the M:\Elliott7\DATA folder.  Let's say that you wish to create an archive Company 23 for the year 2013.  Its corresponding data folder will be M:\Elliott7\DATA_23.  Throughout this document, we will refer to M:\Elliott7\DATA as the production company data folder and M:\Elliott7\DATA_23 as the company created for year 2013 archiving  purposes.

1. Create new Company 23:
  • Login as Supervisor to Elliott, then click "New Company" at Company Selection window (V7) or right-click "Elliott Business Software" (V8). The system will display a small window showing "Company Number." Enter 23 for this example. The system will create a new folder labeled M::\Elliott\DATA_23
  • You will see Company 23 "No Company Name" showing on the company selection. Click OK to do the initial setup for the new company.
  • Go to Company Setup (Util-Setup --> Company Setup), Update Company Information (i.e., ABC Company - 2013) and pick System Manager and General Ledger 2 modules from the second screen -- Specify Packages.
  • Initial files -- The system may create necessary files automatically, but we still recommend that you create and initialize files from File Utilities.  

2. Copy GL files from DATA (Company 01) to DATA_23 (Company 23):
  • Copy M:\Elliott7\DATA\GL*.* to M:\Elliott7\DATA_23 -- You may copy from Windows Explorer. Highlight files starting with GL from the DATA folder, then copy and paste to DATA_23. 
3. Perform the following tasks to archive Company 23 and Company 01:
  • In the archived Company 23, if you did a temporary year end, your accounting period will show the current year.  You should change the accounting period back to last year to match the year of the archived company. 
  • In the archived Company 23, if you did a temporary year end, run Recalculate Accounts Balance so the account balance reflects last year's number.
  • Print Summary Trial Balance for archived Company 23 and compare with Company 01.
  • Print Detail Trial Balance for one of the expenses accounts (i.e., Telephone Expense) for archived Company 23 and Company 01, and compare with the Summary Report (make sure the amount matches).
  • (Options) Compare the Financial Statement in archived Company 23 with Company 01.
4. Your archiving is done if the categories listed above under #3 all match with Company 01. You are ready to close your books from the live Company (01). From now on, Company 23 is a historical archived company for viewing and reporting only. Do not make any further entries into it.




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