OfficeQ is a product of DataBlox Inc.
OfficeQ SQL Query
OfficeQ1 by DataBlox is a powerful QuickBooks data extraction utility that provides data for many purposes including custom reporting. This product has been sold since 1997 and is in wide use by business system developers, add-in developers, accountants, consultants, and end users. OfficeQ is one of the best export solutions that can be used to extract QuickBooks data for conversion to other accounting systems.
OfficeQ fully extracts your significant accounting data from either U.S. and Canadian QuickBooks data files for QuickBooks 2005 through 2014 (as of November 2013). It extracts data that many other products miss such as full payroll and full transaction data. It also extracts data to a data model that is powerful and easy to understand, especially for transactions - which comprise about 90% of most company files.
All normal 'list' data stored in the QuickBooks file can be exported - including accounts, budgets, classes, terms, inventory items, customers, customer types, customer messages, jobs, job types, vendors, vendor types, employees, time records, payroll items, other names, terms, shipping methods, to do notes, etc.
You can also export all types of transactions in normal dual entry accounting format - including journal entries, transfers, checks, deposits, sales orders, cash sales, customer estimates, customer invoices, statement charges, customer payments, credit memos, inventory adjustments, inventory assemblies, purchase orders, item receipts, vendor bills, vendor bill payments, vendor bill credits, sales tax payments, paychecks, payroll liability checks, payroll year to date adjustments, payroll liability adjustments, and all others used by QuickBooks.
OfficeQ is an open architecture library written as a simple, easy to install ActiveX Automation Windows library program with 8 API calls. OfficeQ includes strong support for Microsoft Excel as well as Microsoft Access; however, its data can be easily translated to other databases such as Microsoft SQL or Sybase Central for ASA/ASE.
When extracting data from QuickBooks using a tool like this, transactions are always the most difficult aspect to master. Because of that OfficeQ includes many sample queries whose purpose is both educational and useful for direct output.
There are multiple different transaction types in QuickBooks and some data fields are identical across all types. Other data fields are a subset of the types, and still others are unique to a particular type. The best way to learn transactions is to extract the data from a small QuickBooks file, print out the table / field listings on this site, and experiment by running the queries and observing results.
There are 2 complex SQL features that need to be mastered to produce the most powerful transaction queries. One in the SQL join - and the other is the pivot. There are many examples provided by OfficeQ to help you learn these as well.
There are many useful queries contained in OfficeQ such as transaction statistics, queries for detecting incomplete data (such as class not entered or wrong quantity counts), queries showing activities per day of week, queries calculating profit dollars several ways, and listings of transactions posted to retained earnings. Once you master the use of this tool, you will find that you can extract all the data you are seeking, in the format you want it, and for the purposes you want it.
So if you are considering acquisition of a professional QuickBooks data extraction tool, OfficeQ maybe just the utility you are looking for.
1-OfficeQ is a product of DataBlox Inc.; 15916 East 16th Ave.; Spokane Valley, WA 99037; 509-892-3552.