generate rent roll report in quickbooks

[Michael Shadow]

I was wondering if anyone had any sugesstions on how to generate a rent roll report in quickbooks?

I have my tenants set up as customers and my invoicing is set up that each property is an item and each unit in each property is a sub item of that property.

I'd like to make a report so that I can see how much each tenant paid for each month. But when there is a tenant turn over I'd like to see the new tenants name in that same column.

Thanks,

-Michael