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.

These are the sales reports available to you:

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 revenue: you track the general totals for the period — Total gross sales (before discount), Total discount granted, Total collected (including tips) and Total collected without VAT. There is also a Total POS revenue variant. Please note: this report does NOT have a breakdown by VAT rate — for VAT rates use the reports in the Accounting category, see the question below.

  13. Vanzari produse (Product sales): shows the quantity sold and the amounts for each individual product, and can be sorted by any column - this is the report to use for product rankings, both best-selling and least-selling. This report is listed under its Romanian name, Vanzari produse.

  14. Garanție (SGR deposit): tracks the value of the SGR deposit invoiced on your receipts over a period. The report shows one row per day, with the columns Data creare (creation date), Cantitate vanduta (quantity sold) and Total incasat (total collected), and a total row at the bottom of the table, where you read the figure for the whole selected period. Its only filter is "Data" (date). Storno lines and protocol orders are excluded. This is a standard report, available on any account - you do not need the Insights application for it. This report is listed under its Romanian name, Garanție.

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.

How do I sort a report by a column?

Click the header of the column you want to order by. The first click sorts ascending, from the smallest value to the largest; clicking the same column a second time reverses it and sorts descending. This works on any column of the report and is not saved - it only changes how you are viewing the results right now. For a ranking such as "the most", "the fewest" or "top", you do not need a custom report: sorting the column is enough.

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 which products sell the least (or the most)?

A: Use the "Vanzari produse" report (product sales - the report is listed under its Romanian name):

  1. Go to www.ebriza.com, then Menu, then Reports, in the Sales category.

  2. Open the report named exactly "Vanzari produse". Watch out for two common mix-ups: it is not the "Top products" report (that one only shows the first 5, 10 or 15 entries, so it cannot show you the slow sellers), and it is not the "Sales" category in the reports menu, which contains several reports.

  3. Choose the period from the "Data" (Date) filter. The report opens on "Today", so change the filter if you want last month or another interval.

  4. Click the header of the "Cantitate vanduta" (quantity sold) column. The first click sorts ascending, so the least-sold products appear first. A second click reverses the order and shows you the best sellers.

  5. If you have several locations: the report runs only for the location selected at the top of the screen and it has no multi-location filter. Run it for the first location, note the products, then switch the location from the selector at the top and run it again.

The report has the following columns: Nume produs (product name), Cantitate vanduta (quantity sold), Total vanzari brut (total gross sales), Total discount oferit (total discount given), Total incasat (total collected) and Total incasat fara TVA (total collected excluding VAT). There is also a "Produs" (product) filter if you are interested in a single product.

"Vanzari produse" is a standard report, available on any account - you do not need the Insights application for it and you do not need to request a custom report.

Please note: a product that was not sold at all during the selected period does not appear in the report, because the report aggregates existing sales. So "the
least-sold" means the products with the smallest quantity among those that were sold at least once. The report excludes voided lines, protocol orders and unfinished orders, and displays a maximum of 500 rows.

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.com → Menu → 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: I want a VAT report on sales (my accountant asks me for sales by VAT rate). Which report do I use?

A: You have two standard reports, but not in the Sales category — they are in Reports -> the Accounting category, and they open on any account, without the Insights app and without a custom report:

- Sales by VAT rates — the sales total broken down by each VAT rate.

- Sales by VAT rates and product type — the same breakdown, plus the product type (goods, finished product, service).

Choose the period from the "Date" filter and open the one you need, depending on whether or not you need the breakdown by product type. Details in the article Accounting Reports. Please note: the Total revenue report in the Sales category does NOT have a breakdown by VAT rate, and the Monetary Report breaks down supplier entries by VAT group, not sales by rate. For the VAT on purchase invoices, at the actual rate of each line, write to us — a custom report is needed there.

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 date range 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, open the Reports menu, and select the “Total payments” (or “Total POS payments”) report. From the report’s “Date” filter, select the desired period: for the previous month, you can use the “Previous month” shortcut directly, while for any other interval, select “Manual”, which opens a calendar where you can choose the start and end dates (for example, June 1 - June 30). The total for the selected period is displayed directly in the report, so no further steps are required.

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

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): go to www.ebriza.com, then Menu, then Reports, and run the "Vanzar produse" report (product sales - listed under its Romanian name). Choose the period from the "Data" (Date) filter and read the "Cantitate vanduta" (quantity sold) column; if you want a single product, use the
    "Produs" filter. Click the "Cantitate vanduta" column header to order the products - first click ascending, second click descending. If you only want a short ranking of the best sellers, you can also use the "Top products" report, where the 5, 10, 15, 500# filter lets you choose how many entries to see. 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. Please note: the Cash Register is not a report inside Reports; it is a separate item in the left-hand menu, with that name, and it is shown only if the user has Read or Write permission for it.

Attention: the exact name in the menu is „Payment methods" — there is no
report called „Sales by payment methods". The „Monetar" report is a different report, in the Accounting category, and it does not show collections by payment method.

Attention: the report opens on “Today” by default, so the date filter must be changed - this is the most common reason why the report appears to show a different period than the one requested. The “Total payments” report does not have a “Grouping” filter; its only

Q: My accountant asks me every month for the value of the SGR deposits invoiced on my receipts. Which report do I use?

A: Use the standard "Garanție" report (SGR deposit - the report is listed under its Romanian name):

Go to www.ebriza.com, then Menu, then Reports, in the Sales category.

Open the report named exactly "Garanție".

Choose the period from the "Data" (date) filter. The report opens on "Today", so for last month use the "Last month" shortcut, and for any other interval choose "Manual".

The value appears directly. The report shows one row per day, with the columns Data creare (creation date), Cantitate vanduta (quantity sold) and Total incasat (total collected), and a total row at the bottom of the value columns holding the figure for the whole period - you do not have to add the days up yourself.

"Garanție" is a standard report, available on any account - you do not need the Insights application and you do not need to request a custom report for this.

Please note: "Total incasat" includes VAT, and the report has no breakdown by VAT rate. If you need the rates, use the "Vânzări pe cote TVA" or "Vânzări pe cote TVA si tip produs" reports in the Accounting category. The report filters the SGR deposit lines by itself, excludes storno lines and protocol orders, and runs only for the location selected at the top of the screen, so if you have several locations run it once for each.


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

Did this answer your question?