Module 09 · Reports, Controls and Routines

Case Study: One Month at Harbor Wholesale, with Checklists

Daily weekly monthly routine for distributors, shown through one month of receivables, stock count, agent stock and the close-then-backup order.

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

This lesson follows Harbor Wholesale through one month.

Harbor Wholesale is fictional; numbers are examples.

Key takeaways

  • Bulk reminders print letters one at a time, not email or WhatsApp.
  • Start Opname locks the location being counted.
  • Reyuko does not count agent stock or calculate agent commission. Check both outside the system.
  • Gross profit by customer does not subtract sales returns.
  • Close the period, then back up.

Weeks 1 and 2: sales and a transfer

Harbor's regular invoices totalled 310,000 (77,500, 80,000, 72,500 and 80,000 by week). Each comes from a Delivery Order, with Net 30 picked on every document.

In Week 2, Harbor moved 200 cartons of Item A from Main to Branch. Reyuko does not check source balances, so the warehouse checked Stock List first. The transfer posts at once, with no journal.

Weeks 3 and 4: stock with Agent Ana

In Week 3, Harbor sent 120 cartons of Item A (unit cost 10) to Agent Ana on a Delivery Order with Consignment ticked. Ana reported 80 sold at 14 each, so that order produced 1,120 of revenue and 800 of cost of sales.

In Week 4, Ana returned 15 unsold cartons to Main. On Outbound Return, Remaining is 120 − 80 − 15 = 25 cartons.

Ana's 10% commission is 112, so Ana pays the net 1,008. Reyuko does not calculate commission, so the accountant posts a manual Journal entry (Dr Commission Expense 112, or an expense account you create; Cr the agent receivable 112), and the 1,008 receipt goes through Receivable.

Month-end: collections

Harbor's receivables at month-end, from Aging AR/AP:

BucketAmount
Not Due150,000
1-30 days60,000
31-60 days25,000
61-90 days9,000
> 90 days6,000
Total Outstanding250,000

Overdue is 100,000, or 40%. Bulk reminders uses one tone per run, so Harbor runs it twice: Friendly (Minimum overdue 10,000), then Firm for the 31+ day accounts, ticked by hand.

A returned cheque was marked Bounced in Cheques & Giro. Reyuko has no Deposited status, so cheques stay Pending until they clear or bounce.

Month-end: stock count

In Week 4, Harbor counted Main with Stock Opname, which locks Main until it finishes.

ItemSystemCountedDifferenceCostValue
Item A480470-1010-100
Item B300305+58+40

On Finish & Post, the deficit of 100 goes to Inventory Loss Expense and the surplus of 40 to Adjustment / Stock-count Gain: a net loss of 60.

At Branch, 12 cartons of Item C expired. Reyuko does not remove expired stock itself, so Harbor posted an Expired/Scrapped adjustment: 12 at cost 6, or 72.

Blank count rows

A blank row in Stock Opname is neither counted nor adjusted. Enter 0 for an empty shelf.

Month-end: reports and close

Harbor exports Contacts > Reports > Gross profit by customer: revenue 310,000, cost of goods 248,000, gross profit 62,000, a margin of 20%. Harbor had no returns this month, but still checks the Sales Return list, because the report ignores returns.

When every count and journal is posted, Harbor closes the period in Accounting > Fiscal Period, then backs up (see Backups and Restore Test).

The month-end checklist

#CheckWhere in Reyuko
1Every invoice has Payment TermsSales > Invoice
2Agent Remaining matches the agent's sheetInventory > Consignment, Outbound Return
3Aging reviewed; reminders printedPayment > Aging AR/AP
4Cheques marked Cleared or BouncedPayment > Cheques & Giro
5Stock Opname for every warehouseInventory > Stock Opname
6Expired, lost or damaged stock adjustedInventory > Adjustment
7Agent commission journal postedAccounting > Journal
8Period closedAccounting > Fiscal Period
9Backup made and restore test recordedSettings > Users & Subscription > Cloud Backup
Doing this in Reyuko
  1. Inventory > Stock Opname > Start Opname. Choose the location and date.
  2. Enter a Physical Qty on every product row, including zeros.
  3. Check the Variance, then click Finish & Post, or Cancel Opname to unlock the location.
Check yourself: the count

Stock Opname shows 480 on system and 470 counted, at cost 10. Which journal?

Answer: deficit 10 × 10 = 100, so Dr Inventory Loss Expense 100, Cr Inventory 100.

Frequently asked questions

How do I calculate the share of receivables that is overdue?

Add every aging bucket except Not Due, then divide by Total Outstanding. Harbor's Aging AR/AP shows 60,000 in 1-30 days, 25,000 in 31-60, 9,000 in 61-90 and 6,000 over 90, so 100,000 is overdue out of 250,000, or 40%. Read 40% against your own past months, not against a fixed benchmark.

Does a count surplus cancel a deficit on the same Stock Opname?

No. Each row is valued and posted on its own. In Harbor's count, Item A's deficit of 10 units at 10 each (value 100) goes to Inventory Loss Expense and Item B's surplus of 5 units at 8 each (value 40) goes to Adjustment / Stock-count Gain. The two entries net to a loss of 60, so a surplus on one item does not hide a shortage on another.

Why does gross profit look higher after a return?

Gross profit by customer ignores sales returns, so a return does not reduce the gross profit it shows. Harbor had no returns that month, but still checked the Sales Return list before trusting the margin. Open the list for the same period and adjust the margin by hand.

Which cheque step should be finished before closing the month?

Clear or bounce every pending cheque in Payment > Cheques & Giro before you close the month. A Pending cheque keeps its amount in the Cheques Pending Clearance account, 1-1005, not in the bank, until it is cleared. Use Confirm Clearance for a cheque the bank has paid, and Record Rejection for one that bounced, which puts the invoice back to outstanding.

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