DataBlox OfficeQ - Overview
Questions and Answers
Detailed Field Listings - by Group
DEEP Data Extraction from QuickBooks Files
OfficeQ is the first and only product available that fully extracts ALL significant accounting information from U.S. and Canadian QuickBooks data files for all years of QuickBooks from 2005 through 2015 (previous versions of OfficeQ are available for QuickBooks versions back through 1996). It extracts data that other products miss - such as full payroll and full per transaction data including cost of goods. It also extracts data to a data model that is much more powerful and easier to understand than any other solution, especially for transactions - which comprise about 90% of most real world company files.
Recent changes to OfficeQ include much stronger support for Microsoft Excel. During 2013, we rewrote most of our sample applications to make them much more powerful using Microsoft Excel as the only extension. You no longer need to be a programmer to get the most out of OfficeQ!
All normal 'list' data stored in the QuickBooks file is 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. For details, see the fields listings at the left.
Also exported are all types of transactions in normal dual entry accounting form - 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 other used by QuickBooks.
OfficeQ is implemented as an easy to use library that can be used with most Windows XP / Vista / 7 / 8 environments. It ships with a program that creates a complete Microsoft Access 2000+ database clone of any QuickBooks file and a Microsoft Excel 2000+ VBA program that produce both a database clone and many reports not possible with QuickBooks itself.
The current version of OfficeQ is an open architecture library written as a simple, easy to install ActiveX Automation Windows library program with 8 API calls.
It provides full support for Windows QuickBooks, QuickBooks Pro, QuickBooks
Premier, and QuickBooks Enterprise U.S. versions 2005 thru 2015 as well
as Canadian versions 2008 thru 2015. Both single and multuser files
OfficeQ opens up many new opportunities for companies with accounting
or software development expertise - or end users who need more powerful
DataBlox also offers multiple license packs and unlimited
distribution license agreements.