I need a report designed to allow me to analyze each job my company performs. There is a quick books report that gives me the times I need, however it does not pull over a "custom field" that I need. I want a report similar the excel file attached where it will automatically calculate each value listed on the report.
The fields highlighted in yellow are those that will pull from my quickbooks file, the others will automatically calculate.
I found a program online (QODBC Driver) and have installed it that allows me to pull all of the quickbooks data I need into Excel or Outlook as an external data source. I just dont know how to only pull the data I need.
6 freelancers are bidding on average $207 for this job
I am a professional with several years experience developing Office and database applications for a range of clients. I am especially proficient in advanced SQL and Excel.