Skip to main content

Sales reports

Written by Ionut

In your admin account on ebriza.com, you have access to a series of reports, regardless of your Ebriza subscription - the Global Reports.

We provide 12 sales reports.

Attention! The reports are always run only for the location you are logged into!

  1. Customers: Track the products sold on receipts to which you have added a customer; you can filter by product or customer.

  2. Discounts: Track all discounts offered at the location, with and without VAT.

  3. Deliveries: Track totals by delivery platform and payment method - only for users of delivery integrations - see here how to integrate all orders into the Ebriza tablet.

  4. Payment Methods: Track the total collected by payment methods.

  5. Payment Methods and Users: Track the total collected by users and payment methods.

  6. Profit: Track sales for each product, alongside the purchase cost and gross profit - available only for users of the Management or Management Premium application.

  7. Protocol: You can track the consumption recorded under protocol at the location you are logged into - see here how to set the protocol amount for employees. Attention: the report gives you the protocol totals, not the list of products. If you want to see which products were issued under protocol and in what quantities, you need a custom report - see the question below.

  8. Returns: Track returned products and those from canceled receipts - see here how to limit the possibility of returns.

  9. Top Categories: Track the best-selling categories, select to see the top 5, 10, or 15.

  10. Top Products: Track the best-selling products, select to see the top 5, 10, or 15.

  11. Top Tags: Track the best-selling tags, select to see the top 5, 10, or 15 - see here how to set tags for products.

  12. Total Sales: Track overall totals, broken down by VAT rates.

How do I set the date? In the "Date" filter, you have several predefined intervals (today, yesterday, this week, this month, the last 30 days, etc.), and under the "Manual" option, you can choose the start date and time, and then the end date and time of the interval for which you want to run the report.

What does the 5, 10, 15, 500# filter mean? This filter indicates how many results the report will return - click on the filter to change the number or choose "all".

What does the "Grouping" filter mean? From this filter, you choose how the data in the report should be grouped: by hour, day, week, month, or year. Example: I run a report for "this month".

  • Choose grouping "day": I will have one line for each day of the month for each result in the report.

  • Choose grouping "month": I will have a single line with cumulative data for the entire month for each result in the report.

What do Total Gross Sales and Total Collected mean?

  • Total Gross Sales: The sum of the prices of sold products, before discount.

  • Total Collected: The total amount collected, after applying discounts.

Contact the Ebriza support team if you need assistance navigating the reports.

Frequently asked questions:

Q: How do I see sales broken down by day (e.g. last month, each day separately)?

A: Use the Revenue, number of orders and average receipt report:

  1. Go to www.ebriza.comMenu → Reports.

  2. Search for the Revenue, number of orders and average receipt report.

  3. Choose grouping by day.

  4. Select the desired period (e.g. last month).

  5. From the three dots on the right, choose the table view; you can export from there as well.

Q: Why does running a report take so long, and what can I do?

A: The most common reason is a very large date range (for example „from the beginning" = since the account was opened). The longer the period and the larger the data volume, the slower the report runs.

The solution — running in the background:

  1. Let the report run. After about 1 minute, a popup appears stating the report is taking longer.

  2. Choose to run it in the background — you can keep working in the meantime.

  3. When the report is ready you can access it, and you receive an email confirmation with a link to open it.

For very large periods, narrow the interval if you don't need the entire history.

Q: How do I export receipts to CSV or Excel, receipt by receipt (not totals)?

A: The receipt list is not taken from Reports, but from the Sales menu. Reports aggregate data by period and grouping (VAT totals, payment methods, collections by day or hour). To export the receipt list to a file: go to ebriza.com, open Sales, filter the period, select the receipts (from the checkbox at the top of the table, you can choose “All (N)” for all rows in the current filter), click the download button, select “Export”, then use the three-dot menu to choose CSV or Excel. Detailed steps are available here — (Sales Menu).

Q: I want to see which products were issued on protocol, broken down by individual product. How can I do this?
A: The standard Protocol report gives you the protocol totals, but not the breakdown by product. The table view does not help here either: it only changes the way the information is displayed and does not add columns that are not available in the report. To get a breakdown by product, you need a custom report, which is delivered through the Insights application and configured by the Ebriza Support team. Write to us and tell us two things: what type of report you need (for example, protocol broken down by product) and which columns it should contain (for example, product name, quantity, value, date, user). Once configured, the report remains saved in your account and can be run at any time. For more details about custom reports, see the Insights Application article.

Q: I need information that is not included in any standard report. What should I do?
A: First, check whether there is a standard report that contains everything you need. If there is, use that report. If the standard report only provides part of the information you requested (for example, only the total, while you need a breakdown by products, categories, or employees), then you need a custom report. Write to us and we will configure it for you. See the Insights Application article.

Q: In the tablet app, I can't choose the period I'm interested in (for example, June). Where can I find it?

A: In Ebriza POS NEXT, the Sales section has a period filter with fixed options — today, yesterday, current week, previous week, current month, previous month — and that's it; there is no option to freely select dates in the app. For any other period, go to ebriza.com → Reports → Total Sales, set the date filter to “Manual”, and choose the start date and end date from the calendar (for example, June 1 - June 30). If you want a single total for the entire period, set the “Grouping” filter to “Month”; if you leave it set to “Day”, you will get one row for each day in the selected period — this is the most common reason why a report may appear to show a different period than the one requested. The format in which the date is displayed (day.month.year or with “/”) does not affect the report results.

Q: I want to know how many units of an item I sold during a specific period. Which report should I use?

Answer:

A: It depends on what type of item you mean, because in Ebriza there are two different things, with two different answers. First, check which one you are interested in — names such as “coffee”, “beer”, or “meat” can refer either to a menu product or to a stock item/raw material purchased by the kilogram or litre.

  • If you want to know how much of a MENU PRODUCT was sold (the one you select in the POS, as it appears in the Product Catalog): use the sales reports on this page. Go to www.ebriza.com -> Menu -> Reports, select the period using the “Date” filter, and run the Top Products report. From the 5, 10, 15, 500# filter, you can select “all” so that the results are not limited to the first entries. If you have the Inventory app, the Profit report shows sales for each product together with the purchase cost and gross profit.

  • If you want to know how much of a STOCK ITEM or RAW MATERIAL was CONSUMED (the item you receive and keep in stock): the answer is not in the sales reports. Go to the Inventory app -> History, search for the stock item by name or SKU code, filter by the Sale movement type, and set the period. For an overview of the entire period, run Reports -> Inventory Report, where sale-type stock outflows are shown for each stock item.

The two figures are not interchangeable. A sale only reduces inventory if the product recipe uses that stock item or raw material: a product without a recipe can be sold without affecting any stock, so you can have “I sold 120 portions” and “0 was consumed from stock” at the same time. Conversely, the same raw material can be included in the recipes of several products, so its consumption cannot be determined from the sales of a single product. For details, see the article “How are sales deducted from stock?”.

Q: Can I generate a daily sales report that also displays the Z report number for each day?

A: Yes, through a custom report. The standard “Payments, number of orders and average receipt” report is grouped by day, but it does not have a column for the Z report number, and the table view cannot add columns that are not included in the report. However, the Z number is recorded on each fiscal receipt in sales, so it can be included as a regular column in a custom report, alongside the date, payments, number of receipts, and average receipt. Custom reports are delivered through the Insights application and configured by the Ebriza Support team: tell us which columns you want the report to contain and the period you will use it for most often, and if the Insights application is not yet installed on your account, let us know and we will help you. You do not need the Z report printed from the cash register for this — that report covers only one day. See the article “Insights Application” for details.

Q: Where can I see how much I collected in cash (or through each payment method) over a specific period?

A: On www.ebriza.com, under Menu → Reports, in the Sales category, you have three dedicated reports:

  • Payment methods: shows the Total collected, broken down by each payment method (cash, card, meal vouchers, bank transfer, etc.). This is the report to use for “how much did I collect in cash”. Available on any account.

  • Payment methods and users: shows the same totals, additionally broken down by user. Available on any account.

  • Payment methods and cash registers: shows the same totals, broken down by cash register. This is available only while the Insights application is installed and active on the account (included in the Titanium package; on Pro and Premium, it can be installed from the Marketplace). See the Insights application article for details.

The period is selected using the “Date” filter in the report, just like in the other sales reports - you don’t need to add anything manually or go through the list of receipts.

If you need to track cash with its balance, cash entries, and payments (not just the total collected from sales), use the Cash Register application in the administration account - see the “Cash Register” application article.

Attention: the exact name in the menu is “Payment methods” - there is no report called “Sales by payment methods”. The Cash Register report is a different report, under the Accounting category, and does not show collections by payment method.


[tags: reports, sales reports, payment methods, total, ebriza reports]

Did this answer your question?