Module 09 · Reports, Controls and Routines

Sales by Customer, Product and Agent

Sales by customer report: read Amount, Transactions, Average and Share in Reyuko, and check which invoices and returns the figures include before you act.

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

Most wholesale questions start with sales: who bought the most, and which products move. Reyuko answers those with its operational reports, but has no report for sales by agent. This lesson shows what each report counts, its limits, and how to read agent sales.

Key takeaways

  • Sales reports count only finalized invoices (status Posted) dated in the range you pick.
  • Reyuko does not currently have a sales report by consignment agent.
  • Agent sales are read from the consignment Delivery Order and the invoices linked to it.
  • Reports have no customer, sales rep or category filter inside the report itself.
  • Sales returns are not subtracted in these reports.

The reports that exist

Reyuko keeps its sales reports in two menus, with the same controls: a Report choice, From and To dates, and Compare previous period.

MenuReportColumns
Contacts > Reports (Basic)Sales by customerAmount, Transactions, Average, Share
Contacts > Reports (Basic)Gross profit by customerRevenue, COGS, Gross profit, Margin
Sales > Reports (Intermediate)Sales by productQty, Amount, Gross profit, Margin
Sales > Reports (Intermediate)Sales by categoryQty, Amount, Gross profit, Share
Sales > Reports (Intermediate)Sales by sales repAmount, Transactions, Average, Share

Sales by sales rep groups by the Staff field on the invoice. It is for your own salespeople, not for consignment agents.

Four reading rules apply to every report:

  1. Only finalized invoices count. An invoice at Posted (reversible) does not appear.
  2. Delivery Orders are not counted. Goods that left on a DO but were never invoiced are missing from the totals.
  3. Rows are capped at 500. Extra rows are grouped into a line called Others.
  4. Sales returns are not subtracted. Check Sales > Sales Return separately. See Sales Returns and Credit Notes.

Agent sales: what Reyuko does not do

Reyuko does not currently have a sales report by agent. The sales rep report reads the Staff field, not the agent.

You can still track agent sales. Reyuko shows the quantity an agent sold on each consignment DO, because each invoice created from that DO is linked to it. You read that figure per DO and add up the agents yourself. For the monthly routine, see Tracking Consignment Stock per Agent. For the commission side, see Agent Sales Reports and Commission Calculation.

Doing this in Reyuko
  1. Go to Inventory > Consignment (Advanced) and open the Outbound Return tab.
  2. On the Consignment DOs sub-tab, select the consignment Delivery Order. The list shows DO No., Agent and Date.
  3. Read Sent, Sold, Returned and Remaining for each product. Remaining equals Sent minus Sold minus Returned.
  4. Go to Sales > Reports, choose Sales by product, set the month, and click Export to keep a copy.
Sold depends on your invoices

Sold counts only the invoices you created from that DO. If an agent sells goods and you do not invoice them, Sold stays low and Remaining stays high. If one invoice combines several DOs, Reyuko links it to the first DO only, so Sold for the others stays low. A DO is not marked as invoiced, so you cannot filter the list by invoice status. Compare Sold with the agent's own report before you pay the agent.

Reading the month correctly

The report uses the invoice date and the invoice status. The Delivery Order date does not matter.

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

Harbor ships 50 units to an agent on 28 March. The agent sells 30 units by 31 March. Harbor creates the invoice for those 30 units on 2 April, at 250,000 each. The March report shows nothing for that DO. The April report shows 30 × 250,000 = 7,500,000.

Status matters as much as the date:

Invoice dated 15 March, statusIn the March report?
DraftNo
Posted (reversible)No
Posted (finalized)Yes

To use Compare previous period, pick ranges of the same length. The report then adds Previous and Change % columns.

Check yourself: which invoice counts

An invoice dated 20 March is still Posted (reversible). Another invoice dated 22 March is finalized. Which one appears in the March Sales by product report? Answer: Only the 22 March invoice. Both dates are in the range, but only the finalized invoice counts.

Frequently asked questions

What should I look for in a sales by customer report?

Read four columns. Amount is the customer's total sales in the period, Transactions counts their invoices, Average is Amount divided by Transactions, and Share is their part of total sales. Set From and To to the period you want, then check whether one or two customers dominate before you act on the ranking.

Are unpaid invoices counted in Sales by customer?

Yes, if the invoice is finalized and its date falls within From and To. The report counts sales, not cash received, so an invoice with an outstanding balance still appears. To see the unpaid amount itself, open Payment > Aging AR/AP, which needs Advanced level.

Are sales returns subtracted from a customer's total?

No. Sales Return documents are not deducted in Sales by customer, so Amount shows sales before returns. Delivery Orders are also left out, so only invoices count. If a customer returned a lot, open the Sales Return list for that customer and net the figures yourself.

Which invoices does Sales by customer leave out?

Three conditions decide it. The invoice must be finalized (badge Posted), its date must fall within From and To, and it must be an invoice, because Delivery Orders are not counted. Drafts are excluded as well. If an expected invoice is missing, check its status and date, then run the report again.

Which report shows sales by sales rep?

Sales > Reports, under Sales by sales rep. It shows Amount, Transactions, Average and Share per rep, using the Staff field on each document. Like Sales by customer, it counts only finalized invoices. It is not an agent report: consignment goods are tracked on the Outbound Return tab, where each consignment delivery order shows Sent, Sold, Returned and Remaining.

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