Overview
Dashboard
Today's sales
AED 8,420
▲ 12% vs last MondayBottles produced
6,240
4 batches · yield 96.4%Expiry-risk stock ≤ 48 h
340 units
FEFO push activeReceivables
AED 46,750
AED 8,200 over 30 daysSales by channel — last 14 days
Daily AED · hover for exact figures
Produced vs sold — last 7 days
Units · the gap becomes tomorrow's FEFO queue
Sales by route — today
Cash + credit, live from van devices
Channel mix — August to date
Where the litres go
Expiry watch — next 48 hours
FEFO queue · move these first
| Batch | Product | Units | Location | Expires |
|---|---|---|---|---|
| B-260730-02 | Buttermilk Gooseberry200 ml | 120 | Cold room | Tomorrow |
| B-260730-04 | Lassi200 ml | 96 | Dispatch | Tomorrow |
| B-260731-01 | Buttermilk Original200 ml | 84 | Van UAQ-01 | In 2 days |
| B-260731-03 | Curd500 g | 40 | Cold room | In 2 days |
Receivables by chain
Outstanding · ageing
| Lulu 4 outlets | 18,900 | 0–30 d | |
| Nesto 3 outlets | 12,450 | 0–30 d | |
| Talal Market 2 outlets | 8,200 | 31–60 d | |
| Madeena 2 outlets | 7,200 | 0–30 d |
Activity
| 09:42 | LPO L-88245 received — Nesto, Ajman |
| 09:10 | Batch B-260803-03 passed QC — 1,560 units |
| 08:55 | Van AJM-02 reconciled · variance AED 0.00 |
Today's batches
Monday, 3 August · shift A
| Batch | Product | Units | Yield | Expiry | QC |
|---|---|---|---|---|---|
| B-260803-01 | Buttermilk Original | 2,160 | 97.1% | 8 Aug | Pass |
| B-260803-02 | Buttermilk Spicy | 1,140 | 96.0% | 8 Aug | Pass |
| B-260803-03 | Curd | 1,560 | 96.6% | 13 Aug | Pass |
| B-260803-04 | Buttermilk Ginger & Curry Leaves | 1,380 | 95.8% | 8 Aug | QC hold |
Log a batch
Batch code, expiry and labels are automatic
QC checklist opens automatically. Stock enters the cold room under FEFO the moment QC passes.
Daily output & yield — last 7 days
Columns show units bottled · the line tracks batch yield %
Cold room
4,820
units on handDispatch area
1,150
staged for routesOn vans
1,315
across 5 routesOnline reserve
240
synced to web storeFEFO pick queue
Sorted by expiry — the system always offers these first
| Pick | Batch | Product | Units | Expires |
|---|---|---|---|---|
| PICK FIRST | B-260730-02 | Buttermilk Gooseberry | 120 | 4 Aug |
| PICK FIRST | B-260730-04 | Lassi | 96 | 4 Aug |
| Next | B-260731-01 | Buttermilk Original | 84 | 5 Aug |
| Next | B-260731-03 | Curd | 40 | 5 Aug |
| Queue | B-260801-02 | Buttermilk Spicy | 310 | 6 Aug |
| Queue | B-260803-01 | Buttermilk Original | 2,160 | 8 Aug |
Raw materials & packaging
Reorder points watch themselves
| Fresh milk chilled, litres | 2 days | OK | |
| Culture packs | 6 days | OK | |
| 200 ml bottles | 5 days | OK | |
| Bottle caps | 1.5 days | Reorder now | |
| Labels 4 flavours | 4 days | Watch |
Expiry write-offs — weekly trend
Units written off · down 41% since FEFO picking went live in June
Route UAQ-01 · Al Salamah
Driver Anas · 14 stops planned
| # | Stop | Area | Status | AED |
|---|
End-of-day reconciliation
Route UAQ-01 · live
Lulu · 4 outlets
38,400
Aug sales · AEDNesto · 3 outlets
27,150
Aug sales · AEDTalal Market · 2
11,900
Aug sales · AEDMadeena · 2
9,850
Aug sales · AEDLPO inbox → delivery note → tax invoice
One flow, no re-typing — every document carries the batch numbers
| LPO | Outlet | Lines | Value AED | Status | |
|---|---|---|---|---|---|
| L-88245 | Nesto — Ajman, Nuaimiya | 6 | 1,428.00 | New | |
| L-88231 | Lulu — Umm Al Quwain | 6 | 1,852.20 | Delivered | |
| L-88219 | Talal Market — UAQ | 4 | 746.55 | Invoiced | |
| L-88202 | Madeena — Ajman | 5 | 903.00 | Invoiced |
Tax invoices — August
Select an invoice to preview
| Invoice | Customer | Total AED | Status |
|---|---|---|---|
| INV-2026-01842 | Lulu — UAQ | 1,852.20 | Sent |
| INV-2026-01839 | Talal Market — UAQ | 746.55 | Paid |
| INV-2026-01836 | Madeena — Ajman | 903.00 | Paid |
| INV-2026-01831 | Nesto — Ajman | 1,428.00 | Sent |
VAT snapshot — August to date
| Standard-rated sales (5%) | AED 25,930.00 |
| Output VAT collected | AED 1,296.50 |
| Input VAT recoverable | AED 412.30 |
| Net VAT position | AED 884.20 |
Invoice preview
Exactly what the customer receives
Every invoice carries batch numbers for full traceability, prints in the FTA Arabic-English format, and is already structured for the Accredited Service Provider hand-off — mandatory for B2B from 1 July 2027.