Report Combiner
Overview
Introduction:
The Report Combiner, extracts data from 1 to 999 QuickBooks company files and creates combining Profit and Loss statements and combining Balance Sheets.
In addition the Combiner can transfer the companies data to a new or existing QuickBooks "Consolidating" company file where it sets up each company as a separate class. After transferring the data into the QuickBooks Consolidating file, you can run any of the QuickBooks reports (Profit and Loss By Class etc.) on the imported data. The companies being combined don't have to be using the same charts of account.
Once imported into the QuickBooks "Consolidating" company file, intercompany transactions can be eliminated using Journal Entries. The Journal Entries can be applied to individual companies (classes) or you could create a new class (column) for the eliminating journal entries.
You can also use the Combiner to merge summary data from one file to another file. Some accountants maintain a QuickBooks file that has their clients QuickBooks data in it plus their adjustments for depreciation, accruals, prepaid amortization etc. Using the Combiner, you can easily transfer a summary of a clients activity for a time period (say a month) into a second QuickBooks file containing accountant's adjustments.
System Requirements:
Click the "How to Buy" link at the top of this page to see which years of QuickBooks the Combiner works with. The companies being combined must be on the same QuickBooks version. The companies being combined don't have to be using the same chart of accounts.
If you have Microsoft Access 2000-2013 installed on your computer, there is no additional software to buy. If you don't have Microsoft Access, you can download the free Microsoft Access Runtime engine from the "How to Buy" page at no cost. The Runtime engine will allow you to run the Report Combiner and any other Microsoft Access database.
Windows 2000, XP, Vista, Win 7, Win 8.
Flow Chart:
Contact:
If you have any questions or comments about this program, contact us at karl@q2q.us.
Trademarks:
QuickBooks is a registered trademark and service mark of of Intuit, Inc. in the United States and other countries. The Report Combiner is designed for use with QuickBooks 2002 and later software only. (See the "How to Buy" page for more information)