eye.jpg
 
                      AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.885.3631
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems.  Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
                            AMDG
Quickbooks Data Extraction and Reporting
                             
Intuit Quickbooks dominates the small business accounting software market
                             
I recently started extracting data from Quickbooks, and have prepared an Excel VBA application that extracts the contents of each Quickbooks table into its own Excel workbook.  
                             
This screen shot is a simplified version of my data extractor.  There are more than 150 tables in the Quickbooks database.  This simplified screen shot only lists 8 of those tables.  This program is dirt easy to use.  Quickbooks has a simple procedure for installing the Quickbooks ODBC driver onto any Windows computer.  Once the ODBC drivers are installed, it is another simple task to authorize a Quickbooks user to be able to extract data from the database.  After the user has been authorized, he/she can then select whatever subset of the tables they wish to extract to Excel by turning the desired selections GREEN and clicking on the EXTRACT DATA button.
 
                           
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
The program then builds a folder with Excel workbooks, each workbook containing the contents of each selected table.  The user can update the files at any time.
                             
Once the data has been migrated into these Excel tables, the sky is the limit.  One report I generated was to allow the user to identify what Estimates (Quotes) have been translated into Sales Orders.  The user sees an interface like this:
   
   
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
In this case the user asks the question: "How many estimates (quotes) did we provide to Acme Products in the first 5 months of 2018.  Look at all of our products from AMM Automation.
                             
In just a few seconds, this report appears, which tells the user that 5 quotes were made, 3 of which resulted in sales.
                             
 
                           
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
                             
This report can be quickly adapted to run off of any Quickbooks installation.  Further modifications/enhancements can be made as desired.
                               
AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631 
This web page was last updated at 06/24/2018 03:44 PM and is written in EXCEL!
AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach