Access Hospitality - Ideas Portal

Help us shape the future of our products by submitting your own ideas and reviewing ideas submitted by other users. If you see an idea you like, feel free to vote it up and add any comments that you feel would be beneficial.
This is a collaborative community, so please join in, contribute your innovative ideas and help our product teams to shape their roadmaps and future product development.

Our teams will review the ideas which have received the most votes on a regular basis, meaning that not all ideas will receive updates. When an idea has received enough votes, the status will be updated to 'Under Review' and then a decision made.

Create idea Subscribe
Status Accepted to Backlog
Product Access EPoS
Created by Guest
Created on Aug 25, 2026

RELATED IDEAS

Business Sheet formula for Covers broken down by Seating Area (based on paid-off track location)

Problem / Use Case

In fine dining and multi-area hospitality venues, customers frequently move between seating areas during a single visit. A typical scenario:

  • A group arrives and is seated in the Bar area for pre-dinner drinks. Their order is recorded against the table/track they occupy in the Bar.

  • They move to the Restaurant for their meal and further drinks. Their track/bill moves with them.

  • At the end of the evening, the Restaurant closes and the bill is settled (paid off) from the Bar till — because that is where the service staff are operating at close.

In this scenario, the covers should be attributed to the Seating Area of the track at the point of payment (i.e. the Bar area), not the POS/till used to settle the bill. This reflects where the guests were actually seated and served, which is the meaningful dimension for covers analysis.

Currently, the Business Sheet module has no formula that returns cover counts broken down by Seating Area. The closest available formulas are:

  • TimePeriodPOSCovers(Day No, Time Period, POS No...) — covers by time period and POS number

  • TimePeriodCovers(Day No, Time Period...) — covers by time period only

  • FunctionQty(Day No, 9) — total cover count via Function Type 9

None of these allow covers to be attributed to the Seating Area from which the track was paid off.

Desired Outcome

A new Business Sheet formula — suggested name AreaCovers — that returns the cover count attributed to one or more Seating Areas, based on the paid-off location of the track/table, following the same pattern as the existing Area sales breakdown family.

Suggested signature (consistent with the Business Sheet convention of Day No as the leading parameter):

=AreaCovers(Day No, Area No, ...)

  • 1st param: Day No (0 = week total)

  • 2nd param onwards: comma-separated Seating Area number(s) (0 = all areas)

A Last Year variant would also be desirable for YoY comparison:

=AreaLYCovers(Day No, Area No, ...)

This would allow sheet designers to build a covers-by-area breakdown table on a Business Sheet — for example, showing Bar covers vs Restaurant covers vs Terrace covers per day of the week — which is a standard requirement in fine dining reporting.

Context

  • Report type affected: Business Sheets (ricoSheet.js)

  • Formula family gap: The existing seating-area breakdown family (AreaPosGross, AreaMajorGross, AreaSalesGross, etc.) covers gross, VAT, discount, adjustment, and quantity — but covers are absent from this family entirely.

  • Closest existing formulas that fall short: TimePeriodPOSCovers (filters by POS, not Area) and FunctionQty(..., 9) (no area dimension).

  • Primary use case: Fine dining venues with multi-area service flows where track/table bills are moved between areas and paid off from a different till to where the guests are seated.

  • Attach files