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.
| Menu | Report | Columns |
|---|---|---|
| Contacts > Reports | Gross profit by customer | Revenue, COGS, Gross profit, Margin |
| Sales > Reports | Sales by product | Qty, 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.
| Line | Calculation | Amount |
|---|---|---|
| Revenue | 150 × (300,000 − 20,000) | 42,000,000 |
| COGS | 150 × 200,000 | 30,000,000 |
| Gross profit | 42,000,000 − 30,000,000 | 12,000,000 |
| Margin | 12,000,000 ÷ 42,000,000 | 28.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.
- Go to Contacts > Reports and choose Gross profit by customer.
- Set From and To to the last three months, and tick Compare previous period.
- Click Export to save the figures. Sort by Gross profit, then by Margin.
- Go to Payment > Aging AR/AP for the same customers. This menu needs the Advanced level.
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.
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.
Reyuko