As powerful as QuickBooks is it will never meet all of the needs of all of the businesses who use it. The QuickBooks connector, QOCBD by FlexCorp makes it possible for you to have those reports, analysis tools, and automated processes you couldn’t get.
QODBC is an acronym for QuickBooks Open Database Connector and though this connector you can retrieve very specific information into Excel, Access, Crystal Reports, and even SQL Server. I have created two great new products so far using the connector with Excel, combining QODBC’s ability to both read from and write to QuickBooks with Excel’s powerful visual basic programming tool.
On great advantage for external accountants is that you can automatically connect to any company open in QuickBooks. This means you can use the same reporting, analysis, and automated processing tools with all of your QuickBooks clients simply by opening their company file.
So far I’ve used the connector to write an interactive cash flow manager and an application which accesses QuickBooks timekeeping table and payroll masters to forecast payroll cost by project and by service performed.
The possibilities are endless. Accounting applications are not designed to make decisions about how to record transactions. That is up to the accountant or bookkeeper. In that sense, accounting applications are “dumb”. They are simply receptacles of financial data that require human intelligence and interaction to be useful.
However, so much of the information we really want at our fingertips is buried in a series of time consuming steps and might involve an analytical thought process. If that thought process is always the same it can be programmed, programmed into one click on a toolbar; I repeat, one click. Imagine getting exactly what you need with one click.
In a programmable environment you can also apply rules to transaction processing. This allows you to create accounting entries based on complex rules and, with the QODBC connector; you can automatically write those transactions back into QuickBooks. Processes that might take hours can suddenly be done in minutes, or even seconds.
It’s pretty powerful and exciting stuff. The QODBC driver comes in a read only and a read write version and uses an SQL interface for reading data from QuickBooks. Writing transactions and updates into QuickBooks using Visual Basic are straight forward using ADODB recordsets.
Robert Guild designs specialized reports and automated analysis tools for QuickBooks clients to make decisions they can trust. He is a member of Intuit DeveloperNet and an Advanced Certified QuickBooks ProAdvisor. Visit www.ReportsUWant.com to see pre-designed analysis tools ready to buy or contact him about developing applications for your specific needs at rguild@ReportsUWant.com. You can also follow him on twitter at QBPro