Exporting Specific Transaction Information from QB

Posted on 2009-02-12
Last Modified: 2012-05-06
When running a custom detail transaction report out of QB, to excel, I am looking to export all BILLS (with splits) with date the BILL was paid.  Presently, it seems that I can only run a report that gives me the date that the BILL was entered in to QB.  

I don't want to use a report with BILL PAYMENT, b/c then it doesn't allow me to see the splits (ie - the detailed chart of accounts listing for a bill).  

What I am trying to do, is create an excel program that:

1.)  takes the raw data from QB
2.)  isolates each transaction by project (using class), chart of accounts and payment date in order to create an automated "Actual" in a Budget v. Actual Report in excel.

QB raw data would be feeding the "Actual" side of the excel.

I am a wiz in excel, but QB is proving a pain in the ars and tripping me up...  thanks for your help in advance.
Question by:lmertz
    LVL 5

    Expert Comment

    Have you considered an QODBC driver?  The biggest problem with this option is understanding the quick books data file to extract the information.  Since you state you are a wiz in Excel this may be a good option.

    Author Comment

    Thanks for this.  I did look at the QODBC driver yesterday evening.  That works fine.  The problem I am having is the way the QB architecture is setup.  What I need is an output that provides me with the bills (and corresponding split detail) as well as the payment transaction.

    There is seemingly no unique identifier between bill posting and bill payments, that also include split detail of the bills paid.
    LVL 5

    Accepted Solution

    Would this help sort out the relationships?

    If you are not in the US pick the specific country

    Can you modify any internal report to give you what you want (maybe not in the proper format)?
    LVL 5

    Expert Comment

    I guess you could also hire someone to write the report for you

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
    You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now