TradeOne logo TRADEONEUSER GUIDE

Sales Reports

What These Reports Show

Reports > Sales Reports answers "How are we selling?" and "How much did we make?". You need the reports.sales permission. Everything on these pages is read-only.

Only completed sales are counted. Voided sales are left out, except on the Voided tab.

Using Any Report

Each tab has a date range:

  • From and To dates. They start as today. If you set From after To, To follows it.
  • From Time and To Time. They start at 00:00 and 23:59. Use them to look at one shift, for example 14:00 to 22:00.

Some tabs also have a location filter ("All locations"), a category filter or a staff filter. Figures update at once. If there is nothing in the range you see "No data for selected period."

Set the date range before comparing tabs.

Daily Sales

One row for each day, for each location and cashier: Date, Location, Cashier, Transactions, Revenue and Discounts. A Totals row sums them.

Revenue here is the total of the sales: after discount and including tax. Discounts is the sum of whole-sale discounts.

Use it to spot your busy days and compare cashiers.

Profit and Loss

One row for each product variant: Product, Variant, SKU, Qty Sold, Revenue, Cost, Gross Profit and GP%.

  • Revenue is the total of the item lines sold.
  • Cost is the cost of the goods sold: quantity times the cost recorded at the moment of sale. With batch pricing on, this is the cost of the batch the item came from.
  • Gross Profit is Revenue minus Cost. It is green when positive and red when negative.
  • GP% is Gross Profit divided by Revenue, times 100.

Example: 100 bottles of 20L water sold at KSh 150, cost KSh 100. Revenue KSh 15,000. Cost KSh 10,000. Gross Profit KSh 5,000. GP% is 33.3%.

You can filter by location. The Totals row sums everything.

Note

Gross profit is before expenses such as rent, salaries and electricity. TradeOne does not track those. A whole-sale discount and tax are not taken off the item lines here. See Why Two Reports Show Different Totals.

By Product

One row per variant: Product, Variant, SKU, Qty Sold and Revenue. Filter by All categories.

By Category

One row per category: Category, Transactions, Qty Sold and Revenue. Items with no category are grouped as "Uncategorized".

By Staff

One row per staff member: Staff, Transactions, Total Revenue and Avg Basket (the average sale value). A sale with no staff shows as "Unknown".

Top Products

Your best sellers. Use Show top (Top 5, 10, 20 or 50) and Sort by (revenue or quantity sold). Columns: Product, Variant, SKU, Qty Sold and Revenue.

Voided

Sales that were voided in the period, for checking: Ref #, Date, Cashier, Payment Method and Total. The Total voided figure sums them. Filter by All staff. If none you see "No voided sales for selected period."

Many voids by one cashier is a reason to look at the User Trail.

Salesperson

This tab shows only when Salesperson POS is on. One row per salesperson: Salesperson, Issued, Sold, Returned, Transactions and Revenue. See Salesperson POS.

Services

This tab shows only when Services is on. Per day and cashier: Date, Cashier, Transactions and Revenue for service sales. See Services.

Why Two Reports Show Different Totals

  • Daily Sales, By Staff and Services add up each sale's final total: after the discount, plus tax.
  • Profit and Loss, By Product, By Category and Top Products add up the item lines: before any whole-sale discount, and without tax.

So for a period with discounts or tax, Daily Sales and By Product will not match. Neither is wrong. They measure different things.

Exporting

Most tabs have two buttons:

  • Print / PDF opens a PDF of the report you are looking at.
  • Excel downloads a spreadsheet (.xlsx) you can open in Excel or Google Sheets.

The Voided tab has Print / PDF only.