Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

Exporting Specific Transaction Information from QB

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.
0
lmertz
Asked:
lmertz
  • 3
1 Solution
 
ajames9000Commented:
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.

http://wareseeker.com/Business-Finance/qodbc-driver-for-quickbooks-8.00.00.242.zip/437282
0
 
lmertzAuthor Commented:
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.
0
 
ajames9000Commented:
Would this help sort out the relationships?

http://doc.qodbc.com/qodbc/Qodbc_20_us.html

If you are not in the US pick the specific country

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

Can you modify any internal report to give you what you want (maybe not in the proper format)?
0
 
ajames9000Commented:
I guess you could also hire someone to write the report for you

http://www.qbgarage.com/services/custom-reports/
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now