I don't see a way to report on total actual costs and revenue by site if I use a tenant: site structure for customers. I expect to have about 400 distinct customers using 100 sites this year. so, for example, If I set up my customer/job structure as tenant/site like this: customer job type description Tenant A: site 01 weekly rent 6/01/19-6/07/19 $200 Tenant B: site 02 seasonal rent 6/01/19-9/31/19 $1,000 Tenant C: site 01 weekly rent 6/08/19-6/14/19 $300 Tenant D: site 03 weekly rent 6/01/19-6/07/19 I don't see a way to filter/summarize the job profitability reports so I can see all costs/revenue by site: for example, I want to be able to see: site total actual cost total revenue site 01 $xxx $500 site 02 $xxx $1,000 ....... site 100 $xxx $xxxxx but I think I will see: Tenant A:site 01 $xxx $200 Tenant B site 02: $xxx $1,000 Tenant C: site 01 $xxx $300 I don't see a way to generate a report by site across tenants unless a setup the structure as site: tenant I don't see a way to use classes to do this as the only reporting by class I see is the P&L that goes across the page not down the page.
... View more
Regarding rental units, I have 100 units(campsites), some of which are rented for the season by 1 “tenant”, some of which are rented weekly so they have up to about 12 different “tenants” per year. I don’t see being able to use class for the sites due to the large number (100) and limited class reporting(columns only in p&l format).The income summary and job profitability reports(summary and detail) seem to be most useful for this number of units. The earlier discussion has been very instructive but I am uncertain in this case whether to set up the customer:job structure as unit:tenant or tenant: unit. Any suggestions?
... View more