Accounting and bookkeeping · Workflow guide

Review Gross Profit by Product

Build a product-level gross-profit review from the underlying sales and cost records. Do not assume that a headline sales total or a payment receipt is already a profit measure.

Audience: Authorised finance staffPermission-awareReviewed 16 November 2026

Where to start

Accounting reports and the relevant sales, item and Warehouse records available in your workspace.

Before you start

Agree the reporting period, product identifiers, revenue definition and cost-of-sales method with the finance owner. Product-level cost data must be available and reliable.

Follow these steps

  1. Choose one reporting period and a consistent set of product identifiers. Check that sales and cost records use compatible item references.
  2. Review the approved net sales basis, including the treatment of discounts, returns and credit notes. Use the organisation’s agreed reporting definitions.
  3. Identify the cost of sales attributable to those products and the same period. Reconcile source quantities and valuation before relying on the result.
  4. Calculate gross profit as net sales less the corresponding cost of sales. Where a percentage is needed, divide gross profit by net sales only when the denominator is meaningful.
  5. Investigate products with missing cost, negative quantity or unusually high margins. A zero cost may indicate incomplete data rather than a genuinely cost-free sale.
  6. Reconcile the product totals with the relevant Accounting reports and document any allocation or timing difference.

Understand the limits of the result

Gross profit is not net profit or available cash. Operating expenses, financing, tax and settlement timing may sit outside the selected calculation. Keep the measure labelled accurately.

The current accounting guidance uses Warehouse views, General Ledger and financial reports rather than promising a universal single product-profit screen. The available analysis depends on enabled modules and the quality of source data.

Check the result

  • Revenue and cost refer to the same products and period.
  • Returns and credits follow the agreed reporting treatment.
  • Missing costs and reconciliation differences are visible rather than hidden.
Access and data safety

Use approved finance access and your organisation’s accounting policy. Do not delete or repost financial history to make a total agree. Investigate the source and obtain approval for corrections, especially in a closed period.