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:
| Bucket | Amount |
|---|---|
| Not Due | 150,000 |
| 1-30 days | 60,000 |
| 31-60 days | 25,000 |
| 61-90 days | 9,000 |
| > 90 days | 6,000 |
| Total Outstanding | 250,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.
| Item | System | Counted | Difference | Cost | Value |
|---|---|---|---|---|---|
| Item A | 480 | 470 | -10 | 10 | -100 |
| Item B | 300 | 305 | +5 | 8 | +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.
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
| # | Check | Where in Reyuko |
|---|---|---|
| 1 | Every invoice has Payment Terms | Sales > Invoice |
| 2 | Agent Remaining matches the agent's sheet | Inventory > Consignment, Outbound Return |
| 3 | Aging reviewed; reminders printed | Payment > Aging AR/AP |
| 4 | Cheques marked Cleared or Bounced | Payment > Cheques & Giro |
| 5 | Stock Opname for every warehouse | Inventory > Stock Opname |
| 6 | Expired, lost or damaged stock adjusted | Inventory > Adjustment |
| 7 | Agent commission journal posted | Accounting > Journal |
| 8 | Period closed | Accounting > Fiscal Period |
| 9 | Backup made and restore test recorded | Settings > Users & Subscription > Cloud Backup |
- Inventory > Stock Opname > Start Opname. Choose the location and date.
- Enter a Physical Qty on every product row, including zeros.
- 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.
Reyuko