Module 05 · Selling on Credit

Margin per Invoice and per Customer

Customer profitability analysis in Reyuko: Gross profit by customer shows revenue minus COGS for posted invoices, but not single-invoice margin or returns.

5 min readLesson 11 of 11 in this moduleUpdated 2026-10-24

Reyuko shows margin in its reports, by customer and by product, but not on each invoice in the invoice list. This lesson explains what the reports measure and how to check one invoice.

Key takeaways

  • Gross profit is revenue minus the cost of goods sold (COGS). It is not your profit after rent, salaries or vehicle costs.
  • Margin appears in three reports: Gross profit by customer, Sales by product and Sales by category.
  • The reports count only Finalized invoices in the date range you choose. An invoice still at Posted (reversible) is left out until you click Finalize.
  • Sales returns are not subtracted in these reports, so check returns yourself.
  • The invoice list has no margin column. Use the workaround below for a single invoice.

What the customer report measures

Go to Contacts > Reports and choose Gross profit by customer. Each row shows Revenue, COGS, Gross profit and Margin. Revenue for a line is the quantity times the price, minus the line discount times the quantity, before tax (see Discounts: Line, Invoice and Customer Tier). The report is explained in Gross Margin and Customer Profitability.

COGS is taken from the stock that actually left the warehouse, not from today's purchase price, so a sale keeps the cost it had when it was made.

Illustration: Harbor Wholesale is a fictional business; numbers are examples. In March, Harbor finalizes two invoices to Maju Retail Store. Together they have revenue of 20,000,000. The stock that left for those invoices cost 15,000,000. Gross profit is 5,000,000, and the margin is 25 percent (5,000,000 divided by 20,000,000).

Set From and To to choose the period. The default From is 1 January of the current year. Compare previous period is ticked by default and adds Previous and Change % columns.

COGS may be zero for invoices made from a Delivery Order

Stock sent on a Delivery Order is recorded under the Delivery Order number, so an invoice made from one may show COGS of 0 and a margin near 100 percent. Check your version. On a backup, create a Delivery Order, invoice it, then read that customer's row in Gross profit by customer.

Product and category reports

Go to Sales > Reports. Sales by product shows Qty, Amount, Gross profit and Margin for each product. Sales by category shows Qty, Amount, Gross profit and Share. It has no margin percentage, so calculate the margin yourself if you need it.

When one invoice has several products, Reyuko shares its COGS across those products in proportion to each line's value. Product margins are therefore approximate. Each report shows up to 500 rows; anything beyond that is grouped into a row called "Others".

What the reports leave out

  • Returns. These reports count invoices only, so a customer who returned goods can look more profitable than they are. Check the Sales Return list (Sales > Sales Return) for the same period and adjust by hand. See Sales Returns and Credit Notes.
  • Operating costs. Gross profit does not include rent, salaries or fuel.
Doing this in Reyuko

Check the margin for one customer over a period:

  1. Click Contacts in the sidebar, then Reports.
  2. In the Report selector, choose Gross profit by customer.
  3. Set From and To to the period you want.
  4. Find the customer's row and read Revenue, COGS, Gross profit and Margin.

A workaround for one invoice

Reyuko does not show margin for a single invoice. These two workarounds come close.

  1. Narrow the date range. Set Gross profit by customer to the invoice date. If that is the customer's only finalized invoice that day, the row is its margin. If other invoices fall that day, the row covers them all.
  2. Check the journal. A finalized invoice books Sales Revenue and a Cost of Goods Sold entry against inventory, or against Goods Shipped Not Invoiced (1-1203) when it comes from a Delivery Order. Open Accounting > Journal and find the entry (Advanced level). Check in your version that you can find it by invoice number.
Check yourself: why might a customer's margin look too high?

Answer: a sales return in the same period has not been subtracted. Reduce the revenue and COGS by the returned amounts from the Sales Return list.

Frequently asked questions

Why can two customers with equal sales have different margins?

Margin depends on what each customer buys, not only on how much. One customer may buy higher-margin products or receive smaller discounts, while the other buys lines with a higher cost of goods. Reyuko's Gross profit by customer report shows each customer's margin over a date range, so compare the totals there.

Why does a customer's margin still show the full sales after goods were returned?

Because the margin reports do not subtract Sales Return amounts. Returned goods still count in the customer's revenue and cost of goods sold, so the margin does not drop. Find the returns in the Sales Return list and subtract them yourself before you compare customers.

Why is a new invoice missing from Gross profit by customer?

The report counts only invoices with the status Posted in the date range you choose. An invoice still marked Posted (reversible) is left out. Check the status on the invoice, and make sure its date falls inside the From and To range before you read the totals.

Can I see margin by sales rep in Reyuko?

Not directly. Sales by sales rep shows the amount, transactions, average and share, with no cost or margin column. For margin, use Gross profit by customer for customer totals, or Sales by product for item margins, and read those alongside your rep sales.

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