Do you have multiple companies with data stored in separate Reckon/QuickBooks files, and need to consolidate reports? Do you know how to combine each company data in one report? Some versions of Reckon/QuickBooks (eg Enterprise xxxx) 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.
- Launch QuickBooks and open a QuickBooks file from the first company with which you want to work.
- Click “Reports” on the main menu and select “Combine Reports from Multiple Companies.”
- Click “Add Files,” locate the second company file, select it and then click the “Open” button.
- Select the reports for which you want to view combined information. Available reports are listed in the Select Reports For Combining section.
- Enter the date range you want to use in the From and To fields, respectively.
- Click your desired report basis.
- Click “Combine Reports in Excel” to display the combined report from the two companies in a spreadsheet.
Need help? Not sure? Call for FREE 30min advice / strategy session today! 0407 361 596 Aust
***BEFORE you BUY Ask us for a competitive software price BELOW retail – no obligation!
You also get FREE 30 min to assist in setting up your company in the software, and FREE ongoing email or phone support – no-one offers as much! Call and you also get Free “Avoid these GST mistakes” – there’s 18 that the Tax Office see regularly – get them right! Email email@example.com or call 0407 361 596 Australia