Questions Regarding Sales Reports and Bill Customization in SambaPOS

Dear SambaPOS Support,

I am currently using SambaPOS and I have a few questions regarding reporting and bill customization:

  1. How can I generate a report to see total sales categorized by table and by delivery?
  2. Is it possible to include the location (e.g., customer address or branch) on the bill print?
  3. Can I assign each delivery bill to a specific driver and then generate a report showing how many deliveries that driver has completed?
  4. Is there a way to calculate and report how much cash a driver should return at the end of the day, based on the deliveries assigned to them?

I would greatly appreciate your guidance on how to configure these features.

Best regards,
Shalaw Faraj
Cafe Barbera - Darwaza

Hello @Cafe_Barbera,

You can check the below sources regarding your questions;

First of all you will need to have the Advanced Delivery Configuration on your SambaPOS;

4.12. Advanced Delivery Service Implementation V5.2.3 – SambaPOS Knowledgebase

1- How can I generate a report to see total sales categorized by table and by delivery?

Table revenue report sum, tables repeating itself over again - #14 by Bob_be

2- Is it possible to include the location (e.g., customer address or branch) on the bill print?

Search results for 'customer address bill' - SambaClub Forum

3- Can I assign each delivery bill to a specific driver and then generate a report showing how many deliveries that driver has completed?

Search results for 'driver report' - SambaClub Forum

4- Is there a way to calculate and report how much cash a driver should return at the end of the day, based on the deliveries assigned to them?

Deliverer Total - #25 by markjw

1 Like

Dear Nizam,
Thanks for your response. The report for table and delivery has been created successfully, but I want to create a report like (Item sales report) for both delivery and table separately or one report has separate them, because Item sales report is for both delivery and table.

Hello @Cafe_Barbera,

If you created separate Department/Ticket Types then you can use the below report code to achieve what you want;

Make sure to replace the Department/Ticket Type names with your owns.

[Item Sales by Department:3, 4, 3, 1, 2, 1]
>{REPORT ORDER DETAILS:O.Department,O.ExactTotal.Sum:(TY=Ticket)}
>{REPORT ORDER DETAILS:O.Department,O.ExactTotal.Sum:(TY=Delivery Ticket)}
>{REPORT ORDER DETAILS:O.Department,O.ExactTotal.Sum:(TY=Take Away)}

[Item Sales of Restaurant Department:4, 4, 3, 1, 2, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.ItemGroup,O.Quantity.Sum,O.Price:(TY=Ticket)}
>Total||{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(TY=Ticket)}

[Item Sales of Delivery Department:4, 4, 3, 1, 2, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.ItemGroup,O.Quantity.Sum,O.Price:(TY=Delivery Ticket)}
>Total||{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(TY=Delivery Ticket)}

[Item Sales of Take Away Department:4, 4, 3, 1, 2, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.ItemGroup,O.Quantity.Sum,O.Price:(TY=Take Away)}
>Total||{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(TY=Take Away)}

You can check the below image as reference.

1 Like

Thanks Nizam for your help, I was a little confused but I want an Item sales report based on Entities (Customers and Tables) not based on department.

Thanks

Hello @Cafe_Barbera,

Alright then you can check the previously shared below source for what you need;

Dear Nizam,
I think you didn’t understand me, I mean I want like this

Item Sales report by Entities
Table Report
Water 5 5000
Pizza 10 10000
..
..
..
..

Total Table: 15000

    Customers Report

Water 7 7000
Shisha 5 40000
..
..
..
..

Total Customer: 47000

Hello,

When you select a customer for a table, this item will be added to both the table report and the customer report. This could cause greater confusion. Did you ever consider this possibility ?

1 Like

Hello,
I used (Table) for table customers and I used (Customers) to delivery. and I want to use (Item Selected Report) for both (table and customers) but when I open it, it get both together.