Troubleshooting Guide

Overview

A report may display incorrect data, unexpected values, or unexplained errors. This can affect both new QQube users and reports that previously worked correctly.

Most data-accuracy problems are caused by synchronization interruptions, QuickBooks file corruption, configuration settings, filters, or report-specific issues rather than a QQube defect.

Possible Causes

• Interrupted synchronization. A crash or manually aborted synchronization can leave the QQube database incomplete. A later successful synchronization does not repair the earlier interruption; a complete reload is required.
• Synchronization errors. Most synchronization errors originate in the Intuit SDK and frequently indicate an implementation, permissions, or QuickBooks data problem.
• QuickBooks data corruption. This is more common in large company files or files containing many years of history.
• Incorrect QuickBooks preferences. Review the required QuickBooks preference settings.
• Financial Summary dates. Financial Summary data models use dates selected in the QQube Configuration Tool.
• Incorrect or hidden filters. The QQube report and the QuickBooks report being compared must use the same filters.
• Enhanced Inventory Receiving. When this QuickBooks feature is enabled, Inventory reports must exclude item bills or both the item receipt and bill may be counted.
• Custom field naming changes. Renaming custom fields can change their retrieval order and affect calculations tied to a specific custom field. Review the Custom Fields guide.
• Report corruption. A previously working workbook or report may itself become damaged.
• QQube defect. A product defect usually produces a repeatable extraction or transformation pattern after all other causes have been eliminated.

Basic Resolution

Complete the following steps in order.

Advanced Resolution

If the Complete Reload Has Errors

If the synchronization log still contains errors after the rebuild and complete reload—for example, Error 1000 or unreadable text—select the relevant log and use Send to CLEARIFY.

CLEARIFY can review the log and determine whether additional QuickBooks repair or QuickBooks Data Services assistance may be required.

If the Complete Reload Has No Errors

When the reload finishes successfully but the report still appears incorrect, check the report and comparison criteria.

Check Report Filters

• Document Current Posting State. Posted, Pending, and Non-Posting values are separate. Pending transactions can affect sales-report results.
• Active records. Filters for active accounts, customers, or items can change results. QuickBooks Inventory Valuation Summary and Stock Status by Item reports initially include active items only.
• Hidden filters. A filter may remain active even after its field has been removed from the visible report.

Check Accounting Basis and Dates

• Standard Monthly Period Financial Statements. These models use the QuickBooks Summary Reports Basis preference. If it is set to Accrual, the corresponding QQube financial statements and Trial Balance Activity are also accrual-based.
• Accounts Payable and Accounts Receivable. The extraction As Of Date is selected in the QQube Configuration Tool. An additional date filter is not required in the resulting data set.
• Trial Balance. Its date is also controlled in the QQube Configuration Tool.
• Standard Monthly Period Financial Statements. The QQube Configuration Tool controls the 36 accounting periods included in these models.

Isolate One Transaction

Reduce the report to one transaction that demonstrates the problem. Include identifying fields such as:

• Document Type
• Reference Number or Transaction Number
• Transaction Date
• Line Sequence Number
• Item Name
• Item Description

Compare that transaction directly with the corresponding transaction in QuickBooks.

Test the Report File

If the report worked previously but suddenly stopped working, run an Excel example from the QQube Configuration Tool.

If the QQube example works correctly, the issue is likely within the custom workbook or report rather than the synchronized QQube data.

If the Issue Remains

After completing both the basic and advanced troubleshooting steps, create a CLEARIFY support ticket.

Attach all of the following:

• The latest QQube synchronization log.
• A spreadsheet containing the single isolated transaction.
• A screenshot of the corresponding transaction in QuickBooks.
• A screenshot of the QuickBooks Transaction Journal for that transaction.

For an invoice, open the transaction and select Reports > Transaction Journal.

Bug-related tickets are investigated and responded to within 48 hours. CLEARIFY may request a copy of the QuickBooks company file when the behavior depends on data that has not been encountered previously.

If the issue is confirmed as a QQube defect, it is added to the correction queue and you will be notified when the fix becomes publicly available.