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.
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.
Check the margin for one customer over a period:
- Click Contacts in the sidebar, then Reports.
- In the Report selector, choose Gross profit by customer.
- Set From and To to the period you want.
- 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.
- 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.
- 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.
Reyuko