Money
Margo
Margo works out what each product actually earns after the returns come back, the freight settles and the costs land.
What she watches.
Every cost that lands on an order: the sale, the settlement, the return, the freight. Then what is left when they have all arrived.
Find what's costing you margin.
| Product | 200W with camera |
|---|---|
| After returns | −₹41,800 after returns |
| View | Margin after returns, product level |
illustrative build · synthetic data
πCounter · Margin after returns · ₹
Worked example
| Product | Sold | Revenue | Returned | Refunds | Goods | Freight | Ad spend | Fees | What's left |
|---|---|---|---|---|---|---|---|---|---|
| 200W with camera | 312 | 18,72,000 | 71 | 4,26,000 | 9,98,400 | 2,84,300 | 1,84,000 | 21,100 | −41,800 |
| 120W panel | 486 | 14,58,000 | 38 | 1,14,000 | 7,29,000 | 2,18,700 | 62,400 | 16,400 | 3,17,500 |
| 100W panel · PMax | 274 | 6,85,000 | 29 | 72,500 | 3,56,200 | 1,23,300 | 74,500 | 7,700 | 50,800 |
| Garden light · 4 pack | 1,140 | 5,70,000 | 62 | 31,000 | 2,73,600 | 1,71,000 | 33,600 | 6,400 | 54,400 |
| Inverter 1kVA | 88 | 7,04,000 | 6 | 48,000 | 4,22,400 | 88,000 | 19,200 | 7,900 | 1,18,500 |
| Charge controller 40A | 402 | 3,21,600 | 17 | 13,600 | 1,60,800 | 60,300 | 11,400 | 3,600 | 71,900 |
| Mounting kit · tilt | 530 | 2,65,000 | 9 | 4,500 | 1,32,500 | 79,500 | 0 | 2,900 | 45,600 |
| Battery 100Ah | 61 | 9,15,000 | 4 | 60,000 | 6,10,000 | 1,52,500 | 24,800 | 10,200 | 57,500 |
| Cable run · 20m | 918 | 1,83,600 | 11 | 2,200 | 91,800 | 55,100 | 0 | 2,000 | 32,500 |
| Solar water heater | 37 | 5,55,000 | 5 | 75,000 | 3,33,000 | 1,29,500 | 18,600 | 6,200 | −7,300 |
| 300W panel · trade | 24 | 3,60,000 | 2 | 30,000 | 2,16,000 | not settled | 0 | 4,000 | not settled |
| Monitoring dongle | 205 | 1,02,500 | 3 | 1,500 | 41,000 | 20,500 | 8,900 | 1,100 | 29,500 |
- Product
- 200W with camera
- Sold
- 312
- Revenue
- 18,72,000
- Returned
- 71
- Refunds
- 4,26,000
- Goods
- 9,98,400
- Freight
- 2,84,300
- Ad spend
- 1,84,000
- Fees
- 21,100
- What's left
- −41,800
- Product
- 120W panel
- Sold
- 486
- Revenue
- 14,58,000
- Returned
- 38
- Refunds
- 1,14,000
- Goods
- 7,29,000
- Freight
- 2,18,700
- Ad spend
- 62,400
- Fees
- 16,400
- What's left
- 3,17,500
- Product
- 100W panel · PMax
- Sold
- 274
- Revenue
- 6,85,000
- Returned
- 29
- Refunds
- 72,500
- Goods
- 3,56,200
- Freight
- 1,23,300
- Ad spend
- 74,500
- Fees
- 7,700
- What's left
- 50,800
- Product
- Garden light · 4 pack
- Sold
- 1,140
- Revenue
- 5,70,000
- Returned
- 62
- Refunds
- 31,000
- Goods
- 2,73,600
- Freight
- 1,71,000
- Ad spend
- 33,600
- Fees
- 6,400
- What's left
- 54,400
- Product
- Inverter 1kVA
- Sold
- 88
- Revenue
- 7,04,000
- Returned
- 6
- Refunds
- 48,000
- Goods
- 4,22,400
- Freight
- 88,000
- Ad spend
- 19,200
- Fees
- 7,900
- What's left
- 1,18,500
- Product
- Charge controller 40A
- Sold
- 402
- Revenue
- 3,21,600
- Returned
- 17
- Refunds
- 13,600
- Goods
- 1,60,800
- Freight
- 60,300
- Ad spend
- 11,400
- Fees
- 3,600
- What's left
- 71,900
- Product
- Mounting kit · tilt
- Sold
- 530
- Revenue
- 2,65,000
- Returned
- 9
- Refunds
- 4,500
- Goods
- 1,32,500
- Freight
- 79,500
- Ad spend
- 0
- Fees
- 2,900
- What's left
- 45,600
- Product
- Battery 100Ah
- Sold
- 61
- Revenue
- 9,15,000
- Returned
- 4
- Refunds
- 60,000
- Goods
- 6,10,000
- Freight
- 1,52,500
- Ad spend
- 24,800
- Fees
- 10,200
- What's left
- 57,500
- Product
- Cable run · 20m
- Sold
- 918
- Revenue
- 1,83,600
- Returned
- 11
- Refunds
- 2,200
- Goods
- 91,800
- Freight
- 55,100
- Ad spend
- 0
- Fees
- 2,000
- What's left
- 32,500
- Product
- Solar water heater
- Sold
- 37
- Revenue
- 5,55,000
- Returned
- 5
- Refunds
- 75,000
- Goods
- 3,33,000
- Freight
- 1,29,500
- Ad spend
- 18,600
- Fees
- 6,200
- What's left
- −7,300
- Product
- 300W panel · trade
- Sold
- 24
- Revenue
- 3,60,000
- Returned
- 2
- Refunds
- 30,000
- Goods
- 2,16,000
- Freight
- not settled
- Ad spend
- 0
- Fees
- 4,000
- What's left
- not settled
- Product
- Monitoring dongle
- Sold
- 205
- Revenue
- 1,02,500
- Returned
- 3
- Refunds
- 1,500
- Goods
- 41,000
- Freight
- 20,500
- Ad spend
- 8,900
- Fees
- 1,100
- What's left
- 29,500
The freight invoice for the trade panel has not arrived. Margo will not estimate it, so that row reads not settled rather than a number nobody can defend.
illustrative build · synthetic data
Read by Margo · 05 Sep
What she may do without asking.
- Reads
- Everything financial
- Does without asking
- Nothing
- Waits for you
- Nothing. Margo only reports
- Never
- Reports a margin built on a cost nobody supplied
Margo will not quote a number she cannot define.
Your ecommerce. One connected AI team.
we build one of these at a time.
it belongs to the business we build it for.