How to Create Department Reports in SambaPOS V5

V5 Question
1

Hello SambaPOS Community,

I’m currently working on setting up department-specific reporting in SambaPOS V5 and would appreciate some guidance.

I have multiple departments (e.g., Restaurant, Bar, Takeaway), and I’d like to generate reports that show sales, tickets, and item summaries per department. My goal is to be able to track performance and sales independently for each section.

Here’s what I’m looking to achieve:

  • A breakdown of total sales by department
  • Ticket count and average ticket value per department
  • Department-specific item sales or category sales

If anyone has experience setting this up either through Report Tags or any other method, I’d be grateful for your help.

Thanks in advance!

Best regards,
Emmanuel

2

you can try this

[Department Cashup Details:3, 3, 2,1]
>Manager:|{SETTING:CURRENTUSER}
Date:|{DATE}|{TIME}

@{REPORT PAYMENT DETAILS:T.Department,P.Amount.Sum::{0}:,}
>>Payment|Count|Total
>Dept:|$1
{REPORT PAYMENT DETAILS:P.Type,P.Amount.Count,P.Amount.Sum:(DE=$1)}
{REPORT CALCULATION DETAILS:C.Type,C.CalculationAmount.count,C.CalculationAmount.sum:(DE=$1)}
>Tax|{REPORT PAYMENT DETAILS:T.Tax.Sum:(DE=$1)}
>>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:(DE=$1)}

[Paid Tickets:3,3,3,3,3]
>Table|Amount|Tip|Payment|Time
@{REPORT PAYMENT DETAILS:T.Department.asc::,}
>Dept:|$1
{REPORT PAYMENT DETAILS:T.TicketNumber,[T.TotalAmount]-[CA.Tip],CA.Tip,P.Type,T.Time:(DE=$1)}

[Sales by Product Quantity:2.5, 2.5, 1.5, 2.5]
@{REPORT ORDER DETAILS:O.Department.asc::,}
@{REPORT ORDER DETAILS:O.Department,O.MenuItemName,O.ExactTotal.Sum.desc::,}
>Product|Portion|Count|Price
>Dept:|$1
{REPORT ORDER DETAILS:O.MenuItemName,O.PortionName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(DE=$1) and O.MenuItemName="$2"}
>>Total Items|{REPORT ORDER DETAILS:MT.productType,O.Quantity.sum.desc,O.ExactTotal.Sum.desc:(DE=$1)}

[Sales by Total Group Quantity:2, 1, 1]
@{REPORT ORDER DETAILS:O.Department::,}
>Dept:|$1
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Sum,O.ExactTotal.Sum:(DE=$1)}
2 Likes