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.