Eagle Consulting Group Joins Net@Work

Eagle Consulting Group Has Merged With Net@Work, A Top Worldwide Sage Software Business Partner.

The Eagle team will continue to work with you and support your Sage MAS and CRM installations. We remain committed to your IT and business needs - rest assured that the voices and faces you've come to know and trust will still be there to take your calls.

This is a big win our valued customers. With our combined teams we can now offer you expanded services and support, providing a true advisor for all your IT initiatives.

Visit us at www.netatwork.com

Phone: 212-997-5200
575 Eighth Avenue (corner of 38th st.) New York, NY 10018

Phone: 201-735-9560
29J Commerce Way Totowa, NJ 07512

» View Message from Debra Ellis, President, Eagle Consulting

» View Official News Release

Eagle Consulting is now part of Net@Work, a leading Sage MAS 500 VAR Headquarted in NY with offices nationwide.

Please call 212-997-5200 or click here For MAS 500 Support, Sales, Consulting in New York, New Jersey, Connecticut, North Carolina, and Texas

Sage MAS 500 Advanced Consolidations
Sage MAS 500 Advanced Consolidations is used with General Ledger and Multicurrency 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 Inquires Reports Examples
Setup Utilities Integration 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 statements 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 Multicurrency 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.) Multicurrency 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.
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, for example, the Reconciliation Report, Eliminations Report, and the 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.
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 Multicurrency, Accounts Payable, and Accounts Receivable. The Sage MAS 500 modules that may be integrated with Advanced Consolidation are:
  • Multicurrency Management
  • Accounts Payable
  • Accounts Receivable
  • General Ledger
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

(212) 997-5200

Sage Software Select Partner in New York City and the Tri-State Area for
Sage MAS 90, Sage MAS 200 and Sage MAS 500 accounting software

575 Eight Ave. 10th Floor | New York, NY 10018

(212) 997-2484 fax

site map | home

Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are property of their respective owners.

Visit Net@Work for Sage MAS 500, MAS 90, MAS 200, ACCPAC, SALESLOGIX, SAGECRM, SAGE ABRA HR, services in New York NY, New Jersey NJ, Texas TX, Connecitcut CT, North Carolina NC Boston, MA