On This
Page
Questions
and Answers
Detailed Field Listings
- by Group
Special Offer Order
Form |
|
Overview
4/30/08 Note: Our web site is currently being revised. Our new product (OfficeQ6) is now available and adds support for QuickBooks 2006, 2007, and 2008. Click the ORDER button above for ordering info. The information below will be updated in the next few weeks.
OfficeQ is the first (and
only) product available that fully extracts ALL significant accounting
information from U.S. and Canadian QuickBooks® data files.
It operates identically with versions
of QuickBooks® from 4 (circa 1996) through 2005 and extracts data (such as full payroll
transactions) that is
not available using any other solution.
Unlike any other
product available, it directly reads and interprets the binary
data of .QBW data files and does not require or use any functionality
of the QuickBooks® program itself. It provides access to a significant
amount of data that is not available using Intuit's QBXML interface or any
other solution. It also works identically with all years and versions of QuickBooks®.
It was developed
for use by business system developers, addin developers, accountants,
consultants, and technically oriented end users. It is a mature product and has been
shipping since January 1998 - with regular updates and continual
enhancements. OfficeQ is the export solution used by virtually
every major accounting software vendor who includes QuickBooks
data import functionality.
OfficeQ is an easy to use library that can be used with most
Windows 98 / NT / 2000 / XP development environments. It ships
with a sample program that creates a complete Microsoft Access 97
/ 2000 / XP database clone of any QuickBooks® file and several
Microsoft Excel 97 / 2000 / XP macros (VBA modules) that produce
reports not possible with QuickBooks® itself.
It
provides full support for Windows QuickBooks®, QuickBooks
Pro®, QuickBooks Premier®, and QuickBooks Enterprise ® U.S. versions 4, 5, 6,
99, 2000, 2001, 2002, 2003, 2004, and 2005 as well as Canadian versions
5, 6, 2000, 2001, 2002, 2003, 2004, and 2005. Both single and multuser
files are supported.
All normal accounting 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, payroll history, other names, terms, shipping
methods, to do notes, custom captions, 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
3 types of credit card transactions.
Implementation
OfficeQ is an open architecture library written
as a simple, easy to install Windows DLL with 8 API calls. It reads
QuickBooks® binary files directly and doesn't require the
QuickBooks® program to be present, nor does it require any
action by the user - such as manually exporting files.
It was a very difficult product to engineer - over 950 binary fields
and links had to be individually decoded, requiring several man
years of bit level decoding, programming, and testing effort. It
is currently in use by over 7000 customers and has been field tested
against over 30000 real world QuickBooks® files - including
files up to 408MB in size.
OfficeQ comes in 2 variations
- both export identical data. OfficeQ is targeted primarily
at end users and sells for $179. It can be used with any 32 bit Visual Basic for Applications
(VBA) supporting program - such as Microsoft Access, Excel, Word,
Project, Powerpoint, any 32 bit version of Visual Basic, Visio,
etc.
Although the samples we provide use Microsoft Excel
and Microsoft Access (either can be easily converted to 2000 / XP),
the standard variation of OfficeQ can also be used to import data
using any product that supports VBA DLLs, including:
- MS Access
- MS Excel
- MS Outlook
- Visual Basic
|
- MS Word
- MS Project
- MS Powerpoint
- Office 97+
|
- Visio
- Visual Studio
- Sql Server
- Generic VBA
|
OfficeQ Pro adds an ActiveX Automation
DLL. It sells for $299
(see the special offer below). In addition to the products listed
above, it supports 32 bit versions Microsoft Visual C++, FoxPro,
SQL Server, Borland Delphi, C++ Builder, Visual dBase, Sybase Powerbuilder,
ActiveState Perl, or any other environment that can access ActiveX
Automation DLLs.
Both products open up many new opportunities
for companies with accounting or software development expertise
- or end users who need more powerful reporting capabilities.
Potential
Uses
Business system developers can completely
import all data for use by other programs. These programs can be
used in conjunction with QuickBooks®.
Accountants, consultants,
tax preparers, and advisors can provide more powerful services to
their clients. Hundreds of different reports can be created that
are not possible with QuickBooks® itself.
End users
can increase sales and decrease expenses by taking maximum advantage
of information that already have - but can't access through other
means.
Documentation
The yellow panel at the left contains links to documentation on the OfficeQ product.
The Questions
and Answers page provides more detailed information about how
OfficeQ can be used, how it operates with other programs,
what sample applications will be available, etc.
Complete
data listings are also available there - broken down into 6 groups.
Restrictions
The standard OfficeQ and OfficeQ Pro products are licensed
for use by a single person on a single computer at one time. This
includes use on a local area network (within the same locale).
Use over a wide area network (such as internet TCP/IP) or use where
the QuickBooks data file has been transferred to the licensees computer
using a wide area network requires a special license agreement which
is significantly more expensive. Email us at info@datablox.com if
you have questions concerning this.
|
