Skip to content
On this page

Sales and product reports

Last updated: 6 November 2026 · 5 min read

These reports show what sells, to whom and what each item earns you, and what you bought. Most are under Selling in the Reports menu; Profit on each item is under Profit and spending. Use them to decide what to reorder and what to stop stocking.

Before you start: Pick the date range first. See Reports overview for how the filters, saved views and exports work.

Best sellers#

Reports > Selling > What sells best opens Sales by Product. Its second tab, Best sellers, ranks your products for the dates you choose. It opens on this month.

  1. Select the Best sellers tab, then narrow the list with Category (1), Brand or Unit if you want, and choose a Business Location.
  2. Under Rank by, choose Revenue, Quantity (2) or Gross profit. The Ranking table and the Top 10 chart reorder at once.
  3. Read the cards: Revenue (without VAT, after discounts, less returns), Gross profit, Units sold, Products sold and the Top product. Each card compares with the previous period.

Best sellers tab with the Category filter and the Quantity ranking button marked

In the Ranking table, each product shows its quantity, revenue, gross profit, margin, the change from the previous period and the Stock left, so you can see at a glance when a fast seller is running low. Use Export to save the ranking.

Product sell report and grouping#

The first tab of Sales by Product lists every product sold. You choose how the lines are grouped.

  1. Use the filters at the top: Business Location, Date Range, Product, Customer, Category and Brand. Select More filters for Customer Group and the time of day.
  2. Choose a grouping button above the table: By product (1), By day (2), By category (3) or By brand. Every line shows each invoice line on its own.
  3. Read the cards: the Revenue, Units sold, Invoices, Average selling price and Top product.

Sales by Product with the By product, By day and By category buttons marked

Use By day to see which days are busy, and By category or By brand to see which part of the range earns the most. The Sold items with stock source and cost button opens the next report.

Sold items cost#

Reports > Profit and spending > Profit on each item shows each item you sold and the purchase it came from, so you can see what you really made on it. The page is called Gross Margin by Item (COGS).

  1. Choose the dates in Sold between (1). You can also filter by Business Location, Customer and Supplier. Select More filters (2) to filter by the date of the purchase.
  2. Read the cards: Units sold (after returns), Cost (what you paid, without the VAT you get back), Revenue and Gross Profit with the margin.
  3. In the table, each row is one sold item with the sold date, invoice number, customer, location, the purchase it was taken from (Stock from), the supplier, and its quantity, cost, revenue, gross profit and margin.

Gross Margin by Item (COGS) with the date range and More filters marked

Product purchase report#

Reports > Selling > What I bought lists every product you bought, from whom and at what price. The page is called Purchases by Product.

  1. Type a name, SKU or barcode in Product (1), or choose a Supplier (2) or Brand.
  2. Read the cards: Total spent, Units bought (with how many were returned to suppliers), Suppliers and Products bought.
  3. Choose Every line to see each purchase line with its reference number, date, quantity after returns, unit cost and subtotal, or By product to add the lines up for each product.

Purchases by Product with the Product search box and the Supplier filter marked

Bought vs sold#

Bought vs sold by product is the third view of Purchases by Product. It compares, month by month, how much of each product you bought with how much sold. It opens on the last three months.

  1. Select Bought vs sold by product (1). It has its own Date Range (2) and a Category filter.
  2. Choose By category, By brand or By supplier to decide how the products are grouped.
  3. Read the cards. Sell-through is the share of what you bought that has sold. Slow movers counts the products bought in these dates of which less than 25% has sold.
  4. In the table, each product shows the Stock now, then Bought and Sold for each month, and a Whole range column with its sell-through. Use Export to save it.

Purchases by Product with the Bought vs sold by product view and its date range marked

Tip: Read the Whole range column to find products that sit on the shelf, then think twice before you reorder them.

Customer groups report#

Customer Groups Report is the third tab of Sales by Product. It shows which kinds of customers your sales come from.

  1. Select the Customer Groups Report tab (1), then choose the Date Range (2) and Business Location.
  2. Read Net sales, the Top group and how many customers belong to a group out of those who bought.
  3. In the table, each group shows its invoices, customers, sales, returns, net sales, average invoice and Share. Sales without a group are listed as No group. Select a group to see what it bought.

Customer Groups Report tab with the tab and the Date Range button marked

Note: A sale counts under the customer group it was made with, even if the customer has moved to another group since. Set up groups under Contacts > Customer Groups.

Discounts given#

Reports > Selling > Discounts given shows how much discount you gave, returns and deleted sales, by cashier.

  1. Choose the From (1) and To dates and a Business Location, then select Show (2).
  2. Read the cards: Discounts given, Discounted invoices and Returns.
  3. In the table, each cashier shows their invoices, discounted invoices, Order discount, Line discounts, Total discount, the percentage of sales before discount, returns and deleted sales. Biggest discounts under it lists the largest single discounts, with the invoice, cashier and customer.

Discounts given with the From date and the Show button marked

Use CSV, Excel or PDF at the top of the page to save the report.

Watch the video

Tutorial 6: Close the day and see your profit in BillBook (2:59)