Home   Overview   Screenshots   How to Buy   Help Page   Testimonials   Videos 

Report Combiner

Help Comments

1. To avoid duplicate index error messages when using Combiner 6 and later, uncheck the "Use account numbers" box in QuickBooks Accounting Preferences or assign an account number to every account in your charts of account. This not not required for version 6.15 and later and 8.02 and later.

2. The QuickBooks Accounting preference "Show lowest subaccount only" should be unchecked or grayed out.

3. The Combiner does not include Account numbers in the accounts transferred to the optional "Consolidating" QuickBooks file. You can manually add account numbers to the accounts in the "Consolidating" QuickBooks file and they will appear on QuickBooks reports. As an alternative, you can use QuickBooks to export the charts of accounts from your individual company files and to import them into the consolidating file. This will add the account number to accounts transferred to the consolidating file by the Combiner. 

4. To create an optional QuickBooks Consolidating file (using QuickBooks 2006). The process for other years of QuickBooks will be similar.

1. Click File>New Company
2. Click Skip Interview.
3. Type in a Company Name such as "Consolidating File for xxx" and click Next.
4. Highlight "No Type" for the chart of accounts and click Next.
5. Save the new file
6. Open the new file and and open and close the "Receive Payments" screen. When you do this, QuickBooks, adds the "Undeposited Funds" account to the chart of accounts with an internal identifier needed to to correctly handled the account on the Statement of Cash Flows
7. Use step 5 on Combiner 6 to add data to this optional file.

5. To create a consolidating balance sheet in the "Consolidating" QuickBooks file: 

1. Create a Custom Summary Report.
2. Change "Display columns by" to Class.
3. Change "Display rows by" to Balance Sheet.
4. Change the Account filter to All accounts.
5. Change the Report Title to Balance Sheet or Consolidating Balance Sheet.
6. Memorize the report for future use.

7. If you have transferred a date range to the consolidating file and need to adjust that date range, you can

8. If QuickBooks says you cannot login automatically, try the following:

A. Remove the Combiner from QuickBooks integrated applications and go through the initial connection process again. (this may or may not work). If it doesn't, try B below

B. Corrupted lgb file
    1. In QB, remove all integrated applications
    2. Click F2 and find the location and name of the QB file you have open.
    3. Close the QB file
    4. Using Windows Explorer, go to the location noted in step 2 and find the company QBW file. Then find the file with same name but an lgb extension instead   of the qbw extension. Delete the lgb file (don't delete the .qbw file).
    5. Use the Combiner and go through the initial connection process again.

9. If you are using Canadian QuickBooks 2005 to 2007 and version 6 of the Report Combiner, you need to set "Automatic Login" in QuickBooks using the U.S. QuickBooks 2002 to 2004 and CA, UK and AU QuickBooks 2003 to 2007 section of the following page http://www.q2q.us/dtuconnection.htm

Copyright 2002-2014 by Karl Irvin