Profit v Loss Reports

[Datkin1]

I operate a business which trades as a café during the daytime.  The same space is also sometimes used for evening events.

One these occasions I need to be able to identify the value of sales between 9am and 5pm (for example) and then, separately, the value of sales from 5.01pm until end of day (let’s say 11pm).

For these AND ALL OTHER days/occasions I need values/data in all of the rows below (or filters to give the same result):-

Location

Date

Daytime/Evening

Value of sales excluding VAT

Value of VAT

Value of Gross Sales

COST OF SALES – by this I mean take the cost price from the Item (product) record and give me the total value (net, VAT, gross).

If Square reports look at the Item record for the sales price, why can they not also look at the Item record for the cost price.  Surely all business need to know their costs of goods sold?