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.