Solved

Sage line 50 - Consolidation (again!)

Posted on 2010-11-08
2
1,785 Views
Last Modified: 2012-05-10
Hi all,

Firstly, apologies if it seems that I have asked this question before.

I need to produce accounts for 5 different companies and also a consolidated group set of accounts.

Apparently Sage line 50 will do this for me.
However, when I visit the Sage website it could not find a mention of nominal ledger consolidation in Line 50.  (Altho' it does give the option of buying a multi-company licence).

Sage promote Line 200 as a consolidation package (far more expensive!!).

(Conspiracy theory ... they would prefer you to buy line 200 and undersell the functionality of line 50)

I guess my question is:
1. Can Sage 50 provide individual and group accounts.  Similarly I would expect to be able to product Balance Sheets (etc) for an individual company or a consolidated view.

2. Is my conspiracy theory right?

Thank you and good night!
0
Comment
Question by:Patrick O'Dea
2 Comments
 
LVL 10

Accepted Solution

by:
Bruce Denney earned 500 total points
ID: 34091166
Sage 50 will do what you want.

From the Sage 50 help file

Accounts Professional only


1.   From the Sage 50 Accounts menu bar, select File > Open > Company.

The Company List window appears.

Note: You must not consolidate companies that have different base currencies.

2.   Select your parent company from the list, then click OK.

3.   Open the Period End menu from the Sage 50 Accounts menu bar and choose Consolidation.

The Consolidation screen appears, listing all of the companies currently installed.

4.   Select the companies you wish to consolidate from the list shown.

5.   Click Consolidate.

A warning message appears, telling you that the company you are using is to be used as your parent company. If you want to continue, click Yes. To cancel the consolidation process, click No.

6.   Enter any adjustments you have into your parent company.

7.   Run your profit and loss and balance sheet reports for the consolidated parent company and check these are correct.

8.   Take a backup of your consolidated data from within the parent software and keep it in a safe place, as the next time you run consolidation, the existing data is overwritten.



0
 

Author Closing Comment

by:Patrick O'Dea
ID: 34091177
Thanks again.

The matter is now finalised!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question