Solved

Sage line 50 - Consolidation (again!)

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
eConnect service 5 469
Sage 50 Data corruption 4 127
Networking Sage Peach tree 2011 6 90
Quickbooks default profile setup in public 15 56
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 …
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now