QuickBooks ODBC Drivers and Extraction Software

 

                   Bobalston9  AT  yahoo   DOT  com

 

 

 

ODBC Drivers:

http://www.qodbc.com/QODBC.htm

 

            Free version – access list tables only – no transaction data

            Read-only version $99

            Read/Write version $199



http://www.hcit.co.uk/LinkBook/          supports Quickbooks Basic version


Free trial version allows limited record access

Read-only version $190

Read-write version $380 – May still be a Beta version




Data Extraction software:

Digital Cows Free Quickbooks Exporter – Digital Cows Technologies - FREE – this one works quite well.  But note that to use the tables extracted to Access you must understand the logical relationships between the data.  Not trivial.

 

I have personally used the digital cows free extraction software, which extracts to a MS Access database.  Works slick.

 

 

Digital Cows Deluxe Exporter - $79

 

            http://www.quickbooksusers.com/.forums/showthread.php3?s=aef8709b618302a6aed7abff94d78da3&threadid=3464

 

 

 

Datablox Office Q -  $99  thru 12/31/2003 – normally $179

 

            Only extraction software I am aware of that extracts all data including Budget data

(although the SDK2003 and Quickbooks 2004 gives you access to Budget data in terms of a report)

 

 

Synergration – Access Books - $99

 

Synergration – AccessBooks+ - $129 – Adds ability to export raw report data.

“The easy to use interface lets you specify the report and filter criteria to export.  Click on the image to the right to view this interface.  With the raw report data and the built in report writer in Access you can finally generate the reports you've been wanting.”

 

Synergration – AccessBooks Updater - $199 – Provides for updating Quickbooks data from Access

 

Synergration – Xbooks - $179  - Links QuickBooks to Excel

 

Synergration – AccessBooks Realtime - $199   - Real time sync between Quickbooks and an Access database

“accessBooks Real Time dynamically synchronizes an Access, SQL Server, or MySQL database with your QuickBooks company file.  All changes made in QuickBooks are automatically replicated to the database.  Put an end to after-hours database dumps or slow ODBC interfaces.  With accessBooks Real Time you get high performance access to current QuickBooks data.”

 

Synergration – AccessBooks Realtime + - $299 – Same as above except sync runs as a system service.

 

 

 

 

 

 

E-mail invoices, Reports and Statements

Most add-on products to email QuickBooks output do so by adding a PDF printer driver that ‘prints” the report to a pdf file which can then be attached to an e-mail.

 

CutePFD Printer

 

Totally free PDF printer software.  It is what I am using.  After the file is created you must manually attach it to an e-mail.

 

 

eDocPrinter Pro  - License $29 – Free trial version which marks reports with watermark after page 3 and an invisible hotlink at the top of each page to the software web site.

Nice feature allows it to automatically invoke your e-mail software and setup a new e-mail with the file already attached.

 

QBAutomation - $ 38/$49.50/$69 for Basic/Standard/Professional versions respectively

“You can email not only invoices. Other items ready for email are credit memos, purchase orders, statements, sales receipts and estimates. All this can be one by a few mouse clicks.”

 

AutoReporter - $95

Automates processing of reports.  Includes distribution of reports via email.

 

Invoy for QuickBooks - $179

“Now send HTML-formatted QuickBooks™ invoices, estimates, statements, receipts and purchase orders via email or fax!  Documents are emailed as true HTML, not attached images.   No special client-side viewer software required, just their normal email reader.”

 

 

 

 

Quickbooks Support Forums

 

http://groups.google.com/groups?q=alt.comp.software.financial.quickbooks&ie=UTF-8&oe=UTF-8&hl=en

 

http://www.quickbooksusers.com/.forums/

 

http://www.quickbooks.com/support/boards/index.html        Intuit’s forums – currently not available

 

http://groups.yahoo.com                                                         Search for Quickbooks – there are a handful of forums

 

Sleeter Group QuickBooks Forum

 

Quickbooks Add-ons ONLY

 

 

 

 

 

 

Quickbooks Recommended 3rd Party Add-Ons

 

BlockTax – World’s Largest List of QuickBooks Add-ons

 

All third Party Software

 

3rd Party Utilities: Importing & Exporting