Articles Blog
Reckon/Quickbooks – Combine multiple companies
- Details
-
Published on Thursday, 25 August 2016 11:20
Did you know you can use Reckon / Quickbooks to combine reports from multiple companies with data stored in separate Reckon/QuickBooks files (depending on your version), such as when you need to consolidate reports? Do you know how to combine each company data in one report? Some versions of Reckon/QuickBooks (eg Enterprise) have a built-in feature designed with this task in mind. The Combine Reports from Multiple Companies feature will enable you to create reports that combine the Balance Sheets, or Profit and loss, Statements of Cashflows and more. The combined data is exported as a Microsoft Excel spreadsheet, and you can further manipulate as required.
This applies to Reckon/QuickBooks Enterprise Solutions. It may vary slightly or significantly with other versions or products. See if your version has these features in these steps -
1. Launch Reckon / QuickBooks and open a file from the first company with which you want to work.
2. Click "Reports" on the main menu and select "Combine Reports from Multiple Companies."
3. Click "Add Files," locate the second company file, select it and then click the "Open" button.
4. Select the reports for which you want to view combined information. Available reports are listed in the Select Reports For Combining section.
5. Enter the date range you want to use in the From and To fields, respectively.
6. Click your desired report basis.
7. You can also Click "Combine Reports in Excel" to display the combined report from the two companies in a spreadsheet.
Get Your FREE “Avoid these GST mistakes”
There is 18 that the Tax Office see regularly – Get them right!
Need help? Not sure? Call for FREE 30min advice / Strategy session today!
Call 0407 361 596 Aust
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
