QReportGrabber - Accessing QuickBooks Reports the Easy Way by FLEXquarters

Search for Answers

Intelligent FAQ Search. Type in your keywords to search for the answers you need.

by FLEXquarters

Create live links to QuickBooks reports or report data, using a familiar QuickBooks like interface - all from within Excel. Never import, cut, or paste report data again!

This unique and innovative add-in is available via an Excel menu, gives you easy access to all available QuickBooks reports or report data, allows you to create live data links to multiple report data sources in one workbook, and presents filter and column options not available in QuickBooks.

QReportGrabber allows you to create a live data link between QuickBooks report data and an Excel spreadsheet – all from within Excel.

No more cutting and pasting every time you update your spreadsheet.

Update your QuickBooks data in Excel with one mouse click.

Place report columns in any cell or sheet you designate.

Uses the familiar QuickBooks look and feel to produce the reports you want, the way you want.

You can query and create live links for:

Complete reports

Report row data only (no subtotals or totals)

Report Subtotals only

Report Totals only

There is no other product besides QReportGrabber that allows you to create a live link between Excel and a particular portion of a report; previously this could only be done by exporting a report to QuickBooks, then cutting and pasting.

Accessing QuickBooks Data the Easy Way

Limitations of the QuickBooks export feature:
Exporting reports and linking them to QuickBooks has been improved in the 2004 edition but it is still necessary to manipulate your spreadsheet with cutting, pasting, deleting, sorting, etc. to get the desired results you want. QReportGrabber is a tool that allows you to create links to specific data sections from a report to Excel – in any format, filtering, or sorting scheme.

The difference between QTableGrabber and QReportGrabber:
QTableGrabber inserts data from tables and fields that have been exposed through the Intuit qbXML SDK via an ODBC driver (QODBC from FLEXquarters). Although the tables are deemed “relational” via the ODBC driver, QuickBooks files are still “flat file”, and thus combining several tables to produce information can be slow when large amounts of data are involved.

We use the QuickBooks reporting engine to derive faster results for certain data queries. The report “Transactions By Account” would be a good example. Using QTableGrabber, would require you to relate a dozen tables to the Account List table. Using QReportGrabber, would allow you to query the same data using one of several reports options in QuickBooks – in a much shorter period of time.

Using Microsoft Query is possible but cumbersome:
It is possible to manually request report data through Microsoft Query, but it would require detail knowledge of the necessary query syntax. QReportGrabber hides the details from the end user; just pick and click.

With QReportGrabber Build Excel Spreadsheets as Easy as This:

Target Markets

Accountants, Bookkeepers, and Pro-Advisors who create analytical and informational spreadsheets for their clients.

QuickBooks Users who want to update spreadsheet data – either for their own use, or to give to their financial advisors – without extensive exporting, cutting, pasting and formatting.

QuickBooks Pro, Premiere, and Enterprise Users can benefit from the use of this Excel Add-In

Evaluation Download
If you would like to evaluate QReportGrabber for free before purchasing, simply download the product below! No registration code is required during the first 30 days. To start using QReportGrabber, you first need to run QuickBooks on your computer logged in as an Administrator and open your company file, or one of the sample company files that came with QuickBooks. This is for security reasons.

QReportGrabber Download (22.6MB)
Note: When installing this product select "Australia" as your region. QReportGrabber requires Microsoft Office 2000 or later. Does not work with Microsoft Office 95.

If you are unable to download our products over the internet you can order a QODBC Product Family CD-ROM to be sent out to you by clicking here. QReportGrabber supports Australian, New Zealand and Singapore editions of QuickBooks 2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003 Pro, Premier, Accountant and Enterprise. QReportGrabber doesn't work with QuickBooks EasyStart, Accounting (formally known as Lite), Plus or Small Business Editions.

Announcement List
To be alerted to news about QReportGrabber, product releases, beta test cycles, new features and promotions subscribe to QODBC News Asia Pacific.

QReportGrabber Pricing :

Description	SKU #	Price
QReportGrabber for QuickBooks Pro, Premier, Accountant and Enterprise 2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003 Australian Edition	QROZ4	A$385.00
QReportGrabber for QuickBooks Pro, Premier, Accountant and Enterprise 2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003 New Zealand, Singapore or SE Asia Edition	QRAP4	A$350.00

Customer Helpdesk System Implemented for Tech Support

With the increased amount of pre-sales and technical questions, due to the popularity of our products, we had to rethink our previous methods of handling these types of phone calls and email. So to serve you in a more efficient manner, we have implemented the centralised QODBC support system from USA which is a web based ticket system that you as a customer can input into directly with a much faster response time.

The Customer Helpdesk system has a FAQ (Frequently Asked Questions) knowledge base section that can be accessed using the "Search for Answers" keyword search function on our web pages, often finding the answers immediately. The FAQ Knowledge Base is growing on a daily basis, so if you can’t find what you’re looking for within your "Search for Answers" keyword search, submit a Support Ticket. Your question or technical problem will receive a same day reply even if you are just evaluating our products or a fully registered user. We have 6 technical people monitoring this system in order to provide you with resource direction or answers to your questions. Click here to go to the QODBC HelpDesk System to submit a Support Ticket.

Telephone Support Pricing:
When you purchase a QODBC product you are entitled to Free Installation Support for the first 30 days from the date of purchase. Program anomalies will be addressed at no charge and updaters posted on our web site. Evaluation and other support issues will be subject to a A$33.00 per incident fee. Make sure you have the Serial Number of your purchased product and call 03 9761 3644 or +61 3 9761 3644 during our normal office business hours between 9am to 5pm week days Australian EST (with the exception of Public Holidays).

Telephone Support Incidents
Evaluation and non-installation support issues are subject to a A$33.00 per incident fee. Program anomalies will be addressed at no charge and updaters posted on our web site. Please make sure you have the Serial Number of your purchased product and call 03 9761 3644 or +61 3 9761 3644 during our normal office business hours between 9am to 5pm week days Australian EST (with the exception of Public Holidays) or send your support emails to support@DataAccess.com.au along with your payment receipt.

Payments for Support Incidents may be made by clicking here or by using the following link: http://www.dataaccess.com.au/en-gb/dept_113.html

Q: What is ODBC?
A: ODBC (Open DataBase Connectivity) is a specification designed by Microsoft to allow Windows applications to access multiple database systems through a single method with no regard for various file formats. SQL (Structured Query Language) is used as the method for accessing data through ODBC. Vendors of ODBC drivers (like this one) follow the specifications for ODBC so that any ODBC compliant application can access the data available through the driver.

Q: What is QODBC?
A: QODBC is an ODBC driver (DLL) for QuickBooks Accounting format files. QuickBooks Accounting stores it's data in it's own proprietary DBMS file format. This driver allows users of any ODBC compliant front-end application to read and write data contained in QuickBooks Accounting format files similarly to any other ODBC enabled database.

Q: What can I do with QODBC?
A: QODBC opens up the QuickBooks Accounting files created by thousands of custom programs to the new world of database connectivity. Microsoft Access or Visual Basic can be used to merge QuickBooks Accounting data with other data sources to produce complex reports, or to run mass file updates based on multiple criteria.

Q: What kind of learning curve is there for QODBC?
A: After quick installation of the driver, no training is required! This driver is transparent, requires no learning curve and works in exactly the same fashion of other ODBC drivers. Users of ODBC compliant front-end applications do not necessarily need to learn SQL language to access the QuickBooks database files. Many of these ODBC compliant applications simply present wizards enabling the user to create queries against the database.