General Ledger Report Consolidation for Multi-Company Financial Statements

General Ledger Report Consolidation for Multi-Company Financial Statements

This module allows for multi-Company operations to consolidate their Balance Sheets and Income Statements. The only limitations to this option are that each Company has to be on the same fiscal year and same period as all the rest, and if one Company has closed the previous year, they must all close the previous year before consolidated financial statements can be printed. Your RollMaster Trainer will typically perform all the necessary set up for this report. 


Once the setup has been completed, the General Ledger Report Consolidation module will allow you to first set-up which Company financial statements will be merged and then merge the values. When you enter this module, you will have a choice of whether to Perform Consolidation or Set Up Consolidations. The first time through, you must enter the Set Up Consolidations option. Thereafter, the only time you need to enter that option is to remove a Company from the consolidation or add a Company to the consolidation. In the Set Up Consolidations screen, the cursor will be positioned at the Master Company prompt. You can type the number of the Master Company your trainer created or you can look it up by typing a “?” in that field and hitting enter. Once you have entered through the Master Company field, the system will prompt a Subsidiary Company field. Again, you can type in one of your Company numbers or type a “?” to get a look up of existing companies in the system. Once you have selected a Company, the system will bring up an Option prompt. At this prompt, you can type an “A” to Add the company to the consolidation or type a “C” to Cancel the process. The system will then place the cursor back at the Subsidiary Company prompt. Select the next Company and continue the process until all companies have been added. When you have finished, you can hit the Esc key twice to exit this screen. To remove a Subsidiary Company, enter back into this screen, select the Company you wish to remove from the consolidation and type a “D” to Delete it from the process. 


You will need to enter into the Perform Consolidation screen after you exit the Set Up Consolidations screen to merge all G/L Account Numbers in all companies into one Chart of Accounts within the Master Company. Thereafter, you will use this screen to merge the value of all account numbers in all companies prior to printing consolidated financial statements. If you use the same set of account numbers for each Company, they will simply combine together into one in the Master Company. In the Perform Consolidations screen, the cursor will be positioned at the Master Company prompt. You can type the number of your Master Company or hit enter to bring it up through a look-up process. The system will then prompt the following: Perform consolidation? (Y)es, (N)o. Type a “Y” to perform the consolidation. By performing this step, you have instantly set all Account Numbers up in the Master Company and they can be viewed through the Account Status/Inquiry module. Before you can print out consolidated financial statements, you must first format them in the Master Company through the Report Format Maintenance module. They can then be printed through the Income/Expense Statement and Balance Sheet report modules in the G/L Reports Menu.


    • Related Articles

    • Company Control

      COMPANY CONTROL When you click on or hit enter on the Company Control option from the Select Option menu, the system will prompt another Select Option menu as follows: COMPANY CONTROL 1 SCREEN The following controls are specific to each company you ...
    • General Ledger Budget Programs

      G/L Budget Comparison Report: The following “Budget” programs were developed to set budgets for income and expense accounts. This allows a User to track whether the company is over or under budget on these accounts on a monthly basis. To set budgets ...
    • Print Journals Update General Ledger

      This is an extremely important report module. At the end of the day, after all daily processing and reports are completed, run this report module to send all activity to the system General Ledger. This includes any entries made in the Journal Posting ...
    • Report Format Maintenance

      This module is used to design custom Financial Statements. The RollMaster System automatically prints a Trial Balance report, but cannot print a Balance Sheet, Income & Expense Statement or any other customized financial report until they have been ...
    • Print Statements

      This report module prints Statements for Customers with outstanding balances, provided the Statement field in the Customer Maintenance module for those Customers is not set to “N” for no statement. Any Service Charges assessed will also appear on ...