Module 7 — The revenue cycle: gateways, marketplaces and returns

Level: Intermediate · Duration: 4 hours · Tracks: 🟣 · Prerequisite: Module 4

1. Objectives

By the end of this module you will be able to:

1. Pin down the moment revenue is recognised in every e-commerce selling model, based on control passing rather than on money arriving.
2. Break a settlement statement from a payment gateway or a marketplace down into a complete journal entry, however many lines it has.
3. Handle the awkward models: cash on delivery, buy now pay later (BNPL), subscriptions, vouchers, loyalty programmes, free shipping.
4. Build a monthly reconciliation procedure across three sources: the platform ↔ your books ↔ the bank.
5. Identify the "stuck money" in every channel and measure it as a percentage of your revenue.

2. Core concepts

2.1 When is revenue recognised?

The rule under the international standard for revenue from contracts (IFRS 15), in one practical sentence:

Revenue is recognised when control of the product passes to the customer — not on the order, not on the payment, and not on the bank settlement.

Principal or agent? The decisive question: who carries the inventory risk and who sets the price? If it is you, you are a principal and you record revenue gross. A store selling its own goods on Amazon is a principal — it records 199 as revenue and the Amazon commission as an expense, not 160 net.

2.2 Why recording "the net" is a disaster

A store that records only what lands in its bank loses:

2.3 The anatomy of a settlement statement

Any settlement statement — from any gateway or marketplace — is made up of these categories. Your job is to classify every line into one of them:

The verification rule: the total of all the lines must equal the opening balance of the receivable. If it does not, there is a line you have not classified — and it is usually the reserve withheld, the most famous "missing" line in store books.

2.4 The awkward models

Buy now pay later (Tabby / Tamara): the customer pays in instalments but the provider pays you within days, less a higher commission (5–8%). In accounting terms: an ordinary sale, and the commission is an expense. The collection risk is not yours — so do not record a receivable on the customer.

Free shipping: nothing is free. The shipping you absorb is a fulfilment expense deducted from contribution margin. A store that advertises "free shipping" and does not charge the cost to a separate account has no idea what the offer costs it.

Loyalty programmes: the points granted are a liability carved out of revenue at the moment of the sale, not a marketing expense when they are redeemed. The amount = the expected value of the points that will actually be used.

Shipping collected from the customer: revenue (account 4040), and the shipping cost is an expense. Do not offset them — you will lose any idea of whether you make or lose money on shipping.

2.5 The three-way reconciliation

    platform report  ←──①──→  your books  ←──②──→  bank statement
                          ╲                    ╱
                           ╲────────③─────────╱

Every difference must be explained by a named line, not settled with a "differences" entry. The recurring differences entry is where your mistakes hide — and sometimes your thefts.

2.6 The "stuck money" indicator

stuck money = the balances of (due from gateways + marketplaces + courier companies + reserves)
its ratio = stuck money ÷ revenue for the month

A ratio above 15% means your liquidity is hostage to other parties' settlement schedules. The negotiated fix: shorten the settlement cycle or reduce the reserve percentage — both are negotiable, and both are cheaper than a loan.

3. Worked example — a marketplace settlement statement, March 2026

Nuwa expanded onto Amazon.ae. The March statement:

Step 1 — separate the tax out of every line. The amounts above are tax inclusive:

Step 2 — write the entry:

31 March 2026 | JE-0xx | Ref: Amazon settlement statement MAR-2026
   Dr 1010 Bank                                            78,840.00
   Dr 1130 Due from marketplaces (reserve)                  6,000.00
   Dr 4020 Sales returns                                    8,000.00
   Dr 2100 VAT — Output (reversing the tax on returns)        400.00
   Dr 6030 Marketplace commissions                         18,000.00
   Dr 6020 Fulfilment and packing costs                     7,000.00
   Dr 6020 Storage fees                                     1,200.00
   Dr 6110 Marketing expense (platform advertising)         5,000.00
   Dr 1400 VAT — Input (900+350+60+250)                     1,560.00
        Cr 4010 Sales                                          120,000.00
        Cr 2100 VAT — Output                                     6,000.00
   Memo: settling the Amazon statement for March — a full breakdown of every line

Step 3 — check:
Debits = 78,840 + 6,000 + 8,000 + 400 + 18,000 + 7,000 + 1,200 + 5,000 + 1,560 = 126,000.00
Credits = 120,000 + 6,000 = 126,000.00 ✓

Step 4 — read what the entry revealed:

The decision that follows: the Amazon channel costs 27.9% against 4.1% for your own store. That does not mean shutting it down — Amazon brings you customers you cannot reach on your own. But it does mean that your pricing on Amazon has to differ from your pricing in your own store, and that the profitability of the two channels cannot be compared until each one carries its own cost. Had you recorded 78,840 as "sales" you would have known none of this.

4. Exercises

E7.1 — The moment of recognition (beginner). When is revenue recognised?
(a) An order paid on 28 March and shipped on 2 April — (b) a cash-on-delivery order delivered on 30 March and transferred by the courier on 8 April — (c) a gift voucher sold in March and used in July — (d) an annual subscription of 1,200 sold on 1 July — (e) an order shipped on 29 March that arrived on 3 April, with shipping terms of "delivery at the warehouse".

E7.2 — Breaking down a statement (intermediate). A gateway statement: sales 64,050 (tax inclusive) · refunds 3,150 (tax inclusive) · fees 1,830 + their tax 91.50 · reserve 2,000 · transferred 56,978.50. Write the full entry and check that it balances.

E7.3 — Principal and agent (intermediate). For each case: principal or agent, and how much revenue is recorded?
(a) You sell your own goods on Noon for 300, commission 40 — (b) you list a supplier's product and he ships it directly to the customer, you take 45 out of 300 and the supplier sets the price — (c) dropshipping where you set the price and carry the returns, you sell for 300 and pay the supplier 180.

E7.4 — Subscriptions and vouchers (intermediate→advanced). On 1 May: 150 gift vouchers were sold with a face value of 315 dirhams each (multi-purpose vouchers — no tax on issue), and 80 quarterly subscriptions were sold at 945 dirhams each (tax inclusive). During May, 40 vouchers were used and the first subscription box was shipped. Write the May entries, and calculate the liability balance at 31 May.

E7.5 — The three-way reconciliation (advanced). For June: the platform report says 340 orders worth 212,000 · your books say 336 orders worth 209,400 · the bank received 166,900. The known differences: 4 orders cancelled after shipping (2,600), fees and commissions 33,500, reserve 7,600. Prepare the three-way reconciliation memo, identify any unexplained difference, and propose a specific investigation step for it.

5. Mini project — "The channel settlement engine"

Deliverable: a reconciliation file that works on any statement from any platform.

What is required:

1. Build a "line dictionary" sheet that maps the name of every line on a statement to its account in your chart (extendable by adding a row).
2. Build a reconciliation sheet that takes the statement lines and produces the journal entry automatically, with a check cell for debits − credits = 0.
3. Add an "unexplained balance" cell = the opening receivable balance − the total of the classified lines. It must be zero.
4. Apply it to at least two different statements (a payment gateway + a marketplace) using the figures in this module.
5. Add a "channel profitability" sheet: the net revenue of each channel, its cost, its percentage, and a visual comparison.

Acceptance criteria:
- [ ] The Amazon entry balances at 126,000.00.
- [ ] The reserve is recorded as an asset, not as an expense.
- [ ] Every fee line is separated from its tax.
- [ ] The "unexplained" cell works: leave a line out on purpose and confirm it caught it.
- [ ] The channel profitability sheet shows each channel's cost as a percentage of its net revenue.

6. The test

9 questions · pass 7/9.

7. Completion standard

Mastery level (optional): download a real settlement statement from a platform you sell on, and break it down completely. Count the lines you did not know existed. Then work out the real cost of that channel as a percentage of its revenue — the number is usually higher than you assumed by an amount that will surprise you.