Skip to content
Training manualAccounting and reports

Sales and profitability reports

Where the margin actually is — by item, category, customer and branch — from the same postings as the books.

Because cost is a real weighted average and every sale posts its cost of goods sold, profitability here is not an estimate. The Profitability report breaks margin down by whatever you ask — item, category, customer, branch — over any period. Sales by Group and the dashboard give the daily view; Profit & Loss gives the accountant's. All of them read the same ledger, so they cannot disagree.

Sales and profitability reports
  1. Open Insights → Profitability. Pick the period and the branch, then group by item, category, customer or branch. Sort by margin to find what earns — and what does not.

  2. Every figure is net of sales returns, counted on the return's own date. The dashboard's Net sales are invoice totals after discounts (delivery fees included) less refunds, and its Cost of sales nets out the cost of returned goods, so both match Profit & Loss. Profitability takes each line's share of the invoice discount off its revenue and leaves delivery fees out, since they aren't an item's revenue. Sales by Group lists each return as a negative row under the method it was refunded through.

  3. Approved wastage shows there too. By item, branch or month each row gets a Wastage column and a Net after wastage column, so an item that is often thrown away can't look better than it is. By invoice, customer or salesman, where wastage has no owner, only the period's total wastage and the profit after it show in the cards at the top. Stock-count shortages are left out, since a shortage may be a miscount.

  4. Approved wastage shows there too. By item, branch or month each row gets a Wastage column and a Net after wastage column, so an item that is often thrown away can't look better than it is. By invoice, customer or salesman, where wastage has no owner, only the period's total wastage and the profit after it show in the cards at the top. Stock-count shortages are left out, since a shortage may be a miscount.

  5. Insights → Sales by Group shows revenue by category for the period, on screen and as a printable page.

    Sales and profitability reports — 5
  6. Profit & Loss, Sales by Group and Profitability each have Export to Excel and Print buttons (export needs the export permission). The Excel files carry the report's figures as numbers in the company's decimals, with a Total row; the print shows who printed it and when.

  7. The Profitability report has a Free units column: units given free by promotions. Their cost is already in Cost, but they are not in Qty, which counts paid units only, like the Reports page.

  8. Insights → Reports collects the sales reports with customer and branch breakdowns; each exports to Excel if your role allows export. The sales invoices, receipt vouchers and stock adjustments lists export to Excel too, with numbers as numbers and a Total row.

    Sales and profitability reports — 8
  9. The dashboard's period selector applies to all its cards at once — today, this week, this month, or any two dates — and each card is a shortcut into the matching report. Print gives the same cards, charts and tables on a landscape page; Export to Excel gives a workbook whose Data sheet lists every card and chart as a table and whose Charts sheet draws real Excel charts from those tables, so a figure you edit redraws its chart. Both follow your own Customize layout: hidden widgets are left out and the rest keep your order. The Orders card counts POS orders and the Service invoices card counts service invoices, each linking to its own list; Sales by Branch and Sales by User show both counts per row the same way (money figures include both).

Good practice

  • Run Profitability by customer quarterly. The customers on your best price list are not always the ones earning you the most.
  • A negative margin on an item nearly always means a purchase was entered after the sales — check the movement history first.