Tracking GP% for individual revenue streams
I run a F&B business. Tracking Food, Beverage and Accommodation GPs has always been a KPI in our industry. Whilst it is possible to bespoke the new P&L report to provide an overall GP of all the above revenue streams combined it would be better if it were possible to report GP for each revenue stream, for instance Food Purchases as a % of Food Sales, or as %GP, beverage sales against beverage purchases etc.
Richard Edlmann
shared this idea
Hey Richard, you can actually do this by creating a custom profit and Loss report! You would need to have a seperate account for each Revenuestream and the COGS for each of the revenue streams (food, beverage, types of beverages etc).
Then you can edit the report and create row that you would group each revenue stream with that streams COGS giving you the Gross profit for eac Revenue stream. If you need more help building this you can reach out to our Xero Support team to help you with this.😊
