Back to
Reports

How to generate the sales by brand report

In this tutorial you will learn how to generate a sales report by brand through the Statistics menu.

Important

  • This feature is available to Nex subscribers. Learn more about our plans.
  • Nex generates a report for a specific period, chosen by the user. The system uses the opening and closing date of the till to include the transactions made in the report. Therefore, it is recommended to open and close the cash register daily (more information).

What is the sales by brand report for?

The Brand report specifies all sales made by product brand with the quantities sold; It is useful to analyze which brands are the most sold and which are not, to bring future strategies on the purchase of products from their suppliers.

Shall we generate the sales by brand report together?

1. Access the STATISTICS menu, located in the sidebar at the bottom of the program.

2. Select the SALES BY PRODUCT AND BRAND report.

3. Click on the DATE to choose the PERIOD of the search.

4. Click to select the TYPE of the query, either by TRANSACTION or REGISTER DATE.

5. Click on the ARROW to EXPAND ALL RECORDS.

6. If you want, click on the THREE DOTS to PRINT or EXPORT the report. A file is generated in Excel (.xls) format.

Done! It has generated the sales report by brand.

Among the information provided by this report, we have:

  • Code. Prod.: Indicates the product code.
  • Product: Shows the product description.
  • Quantity: Indicates the number of units sold of this product.
  • Unit Cost: Unit cost price per product
  • Total cost: Total cost price sold per product
  • Unit sales_ Unit sales price.
  • Total sales: Total sales per product.
  • Earnings ($): Difference between cost price and sales price. (Sale price - Cost price = Earnings per unit sold).
  • Earnings (%): Percentage of earnings over the total cost price of the product; This is to say, which does not represent revenue per unit, but rather per total sales in the selected period.
  • Losses ($): Value of losses for total products sold in the selected period. Losses are generated when the sales price is lower than the registered cost price.
  • ‍Losses (%): Percentage of losses over the total cost price of the product.

See also:

See more Tutorials of  

Reports