Solved

Sage line 50 - Consolidation (again!)

Posted on 2010-11-08
2
1,832 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

705 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