Solved

Sage line 50 - Consolidation (again!)

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sage line 500 v6 5 644
accounting software 2 141
bank transaction downloader ? 1 67
PayPal & WooCommerce: Configuring products on PayPal? 2 84
A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 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

12 Experts available now in Live!

Get 1:1 Help Now