What version of Quickbooks are you using? I use Pro 2013 and I can do all that right there in Quickbooks. It just takes a little set up in the beginning but then has endless reports you can create. Login to read more.