Module 09 · Reports, Controls and Routines

Gross Margin and Customer Profitability

Gross profit by customer: calculate revenue minus COGS and margin for each customer in Reyuko, and see what the report leaves out, such as net profit.

5 min readLesson 2 of 8 in this moduleUpdated 2026-10-24

Gross profit by customer is revenue minus COGS, and margin is gross profit divided by revenue. In Reyuko, the Gross profit by customer report (Contacts > Reports) shows Revenue, COGS, Gross profit and Margin for each customer. For example, revenue of 42,000,000 less COGS of 30,000,000 is gross profit of 12,000,000, a margin of 28.6%.

A big sale can still earn little. A customer who buys a lot at a thin margin and pays late may cost you more than they bring in. Reyuko gives you gross profit, which is what remains after the cost of the goods. It does not show what you spend to serve a customer.

Key takeaways

  • Gross profit is revenue minus cost of goods sold (COGS), and COGS comes from the stock that actually left.
  • "Customer profitability" in Reyuko means gross profit by customer, not net profit after operating costs.
  • Margin per invoice is not a report or a column in Reyuko.
  • Margin reports count finalized invoices only and do not subtract sales returns.
  • Rank customers by gross profit and margin, then check how long each one takes to pay.

What the margin reports show

Two main reports carry margin figures. Sales by category also shows Gross profit (no Margin %), which helps you see which product group carries your margin.

MenuReportColumns
Contacts > ReportsGross profit by customerRevenue, COGS, Gross profit, Margin
Sales > ReportsSales by productQty, Amount, Gross profit, Margin

Revenue is quantity times price, minus the line discount, before tax. COGS comes from the stock movements of each invoice, not from the product master price. If one invoice has several product groups, COGS is split across the lines in proportion to their value.

Illustration: Harbor Wholesale is a fictional business; numbers are examples.

Harbor sells 150 units of Wholesale Item A at 300,000 each, with a line discount of 20,000 per unit. The cost is 200,000 per unit.

LineCalculationAmount
Revenue150 × (300,000 − 20,000)42,000,000
COGS150 × 200,00030,000,000
Gross profit42,000,000 − 30,000,00012,000,000
Margin12,000,000 ÷ 42,000,00028.6%

What the reports do not show

Reyuko does not currently calculate these figures:

  • Margin per invoice. The Invoice list shows Total, Outstanding and Aging, not COGS or profit. See Margin per Invoice and per Customer for the workaround.
  • Net profit per customer. Gross profit excludes warehouse rent, delivery, staff time and the cost of waiting for payment.
  • Margin after returns. Sales returns are not subtracted, so a customer with many returns can look better than they are.

Gross margin is a ranking tool, not a full profit answer.

A practical customer check

Compare two retailers. Both pay the 300,000 list price, with different discounts.

Retailer R1 buys 150 units with the 20,000 discount. Revenue is 42,000,000, gross profit is 12,000,000, and margin is 28.6%. Retailer R2 buys 100 units with no discount. Revenue is 30,000,000, COGS is 20,000,000, gross profit is 10,000,000, and margin is 33.3%.

R2 has the better margin, but R1 earns more gross profit. If R2 pays in 90 days and R1 pays in 30, the margin alone is not enough. Check the aging for both before you change any terms. For that view, see Receivables vs Payables and Working Capital.

Doing this in Reyuko
  1. Go to Contacts > Reports and choose Gross profit by customer.
  2. Set From and To to the last three months, and tick Compare previous period.
  3. Click Export to save the figures. Sort by Gross profit, then by Margin.
  4. Go to Payment > Aging AR/AP for the same customers. This menu needs the Advanced level.
Gross profit is not profit

A customer with a high margin can still cost you money. Credit days, late payment follow-up, deliveries and returns cost money that these reports do not show.

Compare with Profit & Loss

Accounting > Reporting > Profit & Loss (Advanced) shows Gross Profit and Gross Margin for the whole business. Compare its gross profit with the total of your customer reports for the same period. If they do not match, check your version before you rely on either one.

Check yourself: which customer is worth more

R1 has gross profit of 12,000,000 on 42,000,000 revenue and pays in 30 days. R2 has gross profit of 10,000,000 on 30,000,000 revenue and pays in 90 days. Which has the better margin? Which earns more gross profit? Answer: R2 has the better margin, 33.3% against 28.6%. R1 earns more gross profit, 12,000,000 against 10,000,000. Neither figure includes the cost of R2's 60 extra days of credit.

Frequently asked questions

What is the formula for customer gross margin?

Gross profit is revenue minus cost of goods sold, and margin is gross profit divided by revenue. Harbor sells 150 units at 280,000 each after a 20,000 discount, so revenue is 42,000,000. With COGS of 30,000,000, gross profit is 12,000,000 and the margin is 28.6%. Reyuko's Gross profit by customer report calculates these figures for each customer.

Does Reyuko show net profit per customer?

No. Gross profit by customer shows revenue minus COGS only. Warehouse rent, delivery, staff time and the cost of waiting for payment are not allocated to customers. Treat the report as a ranking tool, not a full profit figure, and check payment days alongside it.

Can a customer with a higher margin earn less gross profit?

Yes. Retailer R1 buys 150 units at 280,000 net, giving revenue of 42,000,000 and gross profit of 12,000,000, a margin of 28.6%. Retailer R2 buys 100 units at 300,000 with no discount, giving revenue of 30,000,000 and gross profit of 10,000,000, a margin of 33.3%. R2 has the better margin, but R1 earns more gross profit.

How do discounts change a customer's margin?

A discount lowers revenue but not COGS, so the margin falls. At a cost of 200,000 per unit, a price of 300,000 gives a 33.3% margin. The same unit sold at 280,000 after a 20,000 discount gives 28.6%. Compare the Margin column across customers to see who receives the deepest discounts.

Where do I see margin for one invoice?

Reyuko does not show it. The Invoice list shows Total, Outstanding and Aging, without COGS or profit, and no report gives margin per invoice. For one invoice, work it out by hand from its lines and the stock cost. Use Gross profit by customer for a customer over a period, and Sales by product for product margin.

How do I find gross profit by customer in Reyuko?

Go to Contacts > Reports and choose Gross profit by customer. Each row shows Revenue, COGS, Gross profit and Margin for one customer, and Export saves the figures. Gross profit is revenue minus COGS, and margin is gross profit divided by revenue. For example, 42,000,000 − 30,000,000 = 12,000,000, which is 28.6% of 42,000,000.

Put this into practice in Reyuko

Reyuko's inventory, purchasing, sales, purchasing and reporting tools work together on one ledger, so your stock and your books always agree.

Download ReyukoSee what's included