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
Solved

Sage line 50 - Consolidation (again!)

Posted on 2010-11-08
2
1,801 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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. …
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 shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

791 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