MAS 90 200 500 SalesLogix Abra JobOps Texas Colorado Arizona Sage


Sage MAS 500 Advanced Consolidations is used with General Ledger and Multi-Currency to efficiently roll up company information, run eliminations, and generate consolidated financial statements for a group of companies. Advanced Consolidations provides a comprehensive solution for consolidating financial information across a group of companies, and can include actual and budget information from unrelated accounting software products, account structures, chart of accounts, and currencies.
Quick Links
Screen Shots	Activities	Integration	Reports Example
Setup	Utilities		Other Reports
Operational Flexibility
Navigation Ease	From each subsidiary company, use the Lookup and Navigator to map the subsidiary’s account structure to the consolidated company’s account structure. This step allows the system to structure a usable consolidation export file.	Maintain Consolidations	A consolidation is a group of financial statement attributes specified and saved for use in preparing consolidated financial statements. These attributes include a description, rollup, reporting currency, and data types. Use the Maintain Consolidations option to create and edit consolidations for processing consolidations in Process Advanced Consolidations.
General Ledger Export Of Subsidiary Data	Use the Export Consolidation Data task in General Ledger to export summarized data from each subsidiary company to a consolidation export file.	Advanced Consolidations Import Of Subsidiary Data	Use the Import Subsidiary Consolidation Data task in Advanced Consolidations to import each subsidiary company's export files.
Removing And Purging Consolidation Data	If necessary, you can remove or replace a previously imported consolidation file by consolidation period or subsidiary company. You can also purge consolidated data.	Adjusting Consolidated Statements	Enter adjustments to the consolidated financial statements in Enter Journal Transactions in General Ledger. Once adjustments are posted, Advanced Consolidations incorporates them into the consolidated financial statements.
Currency Translation	Translate transactions into the reporting currency using exchange schedules set up in the Multi-Currency Management module. Apply rates using period-end or historical values. Define the currency to use when generating consolidated reports.
Set Up
Consolidation Company	The consolidation company is created to produce consolidated financial reports and allow adjustments of the consolidated data.	Elimination Groups	Create elimination groups for automated eliminations of intercompany entries. Elimination Groups help to ensure that balances held against intercompany elimination accounts are in agreement with the appropriate offset account. For example, ensure that payables are compared with receivables, and sales are compared with purchases. You may specify whether to eliminate by natural account or validated segments.
Unlimited Rollups	Set up an unlimited number of rollups (Management, Legal, etc). Use Multi-Currency Support to group subsidiary companies to generate consolidated financial statements at various levels. Rollups identify controlling companies and the subsidiary company IDs that belong to the controlling company. You may roll up several subsidiary natural accounts into one consolidation natural account.	Maintain Account Segments	From the Consolidation Company, you will maintain the account segment values for the company segment and the eliminations segment. These segment values are typically used to represent all the subsidiary companies involved in the consolidation process.
Financial Exchange Schedule	The use of separate exchange schedules for financial data and budget data allows translation of the financial and budget data at different rates.	Budget Exchange Schedule	Within the Consolidation Company, you will select the budget currency exchange schedule for the currency conversion of budget amounts involving the natural account.
Default Export Data Types	Select financial or budget data types or both as the export default from General Ledger to Advanced Consolidations.	Mapping Makes Consolidation Simple	Map your subsidiary accounts to the Consolidation chart of accounts, presenting your group of companies as a single legal entity. Map subsidiary charts of accounts to the Consolidation chart of accounts by segment and segment values.
Activities
Process Advanced Consolidations	Use Process Advanced Consolidations to generate consolidated financial statements for the current company. Enter the consolidation to process, select the fiscal period, and specify the report format. An Audit Report can be printed for each consolidation.	Process Adjustments	Process subsidiary beginning balances (a one-time function) and adjustments made to the consolidation company for inclusion in the consolidated reports.
Process Eliminations	Eliminate the effect of intercompany transactions and capital transfers. Create balancing entries for mismatches. Post offsets to the elimination variance account.	Export Consolidation Data	You can transfer General Ledger data to an export file, which Advanced Consolidations uses for preparing consolidated financial statements.
Import Subsidiary Company Data	Quickly and easily establish a default exchange schedule and translation method for Balance Sheet and Income Statement accounts. Import subsidiary company data from a local or remote Sage MAS 500 database, or a third-party general ledger.	Process Consolidations	Process consolidations, eliminations, and adjustments for a specific fiscal period. You can also translate currencies and generate consolidations to produce financial statements.
Print Reports	Generate Advanced Consolidations reports as part of processing consolidations. These reports include the Reconciliation Report, Eliminations Report, and consolidated financial statements.	Post Data	Post currency translations and generated consolidations to Advanced Consolidations in Process Advanced Consolidations. Before posting transactions to the Advanced Consolidations database, you print the Audit Report, which you use to verify transactions so that you can make adjustments or corrections before posting.
Post Financial Data From All Your Business Entities	Enter and post directly to the general ledger subsidiary beginning balances and any necessary adjustments in the Consolidations company.
Screen Shots
	Maintain Consolidations		Advanced Consolidations Setup
	General Ledger Setup Options		Process Advanced Consolidations
Useful Utilities
Delete Consolidation Data By Company Or Period		Use these tasks to delete consolidated financial data by company or by period. A log allows you to verify that the successful deletion of the consolidation data for all the selected companies has been completed.
Integration With Other Sage MAS 500 Modules
Advanced Consolidations tightly integrates with General Ledger, and if one or more of your companies utilizes different currencies, integration is provided with Multi-Currency, Accounts Payable, and Accounts Receivable. The Sage MAS 500 modules that may be integrated with Advanced Consolidation are: Multi-Currency Management Accounts Payable Accounts Receivable General Ledger
Reports
Unlimited Reporting Options	Advanced Consolidations allows you to create any type of financial or statistical report that your company requires and allows managers to create their own ad-hoc reports. The consolidation reporting capabilities include everything from defining and building basic tables to reconciliation and presentation of consolidation figures.	Report Templates	Use several template reports in the familiar Excel format to generate consolidation reports. Examples include: Income Statements, Balance Sheets, Cash Flow Statements, Budget Variances, and Income vs. Budget Statements.
Flexible Output	Export all report data to an external file. Data types supported include ASCII text, delimited, Excel, Lotus 1-2-3, HTML, RTF or Microsoft Word. Output any report to the screen, a printer, or a variety of file formats.	Audit Report	Keep track of all changes to an account resulting from imported data, translation gains and losses, intercompany postings, and manually entered beginning balances and adjustments.
Consolidated Financial Statements	Three consolidated financial statements are included with Advanced Consolidations: Consolidated Balance Sheet, Consolidated Income Statement, and Consolidated Cash Flow Statement. These statements are boilerplates for the financial statements produced by the periodic activities in Advanced Consolidations.
Other Reports

Sage MAS 500 Advanced Consolidations