Account Keeping Plus – Administration, Bookkeeping, Compliance News & Tips MYOB Reckon Quickbooks Xero Software TrainingSmall Business

Making Business Books and Accounting Come Alive! MYOB Reckon Xero

Reckon/Quickbooks – Combine Multiple Company Reports

Leave a comment


 

Reckon/Quickbooks – Combine Multiple Company Reports

Reckon/Quickbooks – Combine Multiple Company Reports

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.

  1. Launch QuickBooks and open a QuickBooks 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. 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 info@accountkeepingplus.com.au or call 0407 361 596 Australia

Advertisements

Author: accountkeepingplus

Administration, bookkeeping and compliance for small business, Training, trouble-shooting, or we can do the books and payroll for you! Self Managed Superannuation Fund Service Provider, free support MYOB Certified Consultant, Reckon/QuickBooks Professional Partner.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s