Ali's fixes — captured live on the real pilot
Screenshots taken from clients.plyolab.com/vishal/pilot/v1 (the actual product), signed in as Vishal.
Amex now shows its true size — and folds into AED
Home page: AMEX (consolidated) spend $34,152. In your earlier screenshot this read $9,299 — it was being divided by 3.6725 because the rows were mislabelled. Now correct.
Amex spend folded into the AED category totals
Drill into AMEX: Household spend $34,152 = AED 125,421.54 at the peg. Every category now carries both USD and AED — Travel: 82 lines, $16,636 = AED 61,096.17 — exactly what Ali asked for (card spend inside each head). Spend-by-cardholder shows all 4 holders.
Whole card statement books into one month + per-cardholder view
The ENBD card statement (24 Apr – 24 May) books as one unit, with Spend-by-cardholder breaking it across the family — the statement-month convention Ali journals by.
What's not done yet (Ali's remaining items)
#1 April statements — extraction is AED 704.70 off the statement's own total, so NOT loaded (a wrong May is worse than a late one); needs a clean re-extraction. · #2 Card 1175 attribution — registry checked, June-statement item open. · #5 Payable zero-out, #6 Per-line splits, #7 Cardholder matrix — not built yet.
Real client figures — unlisted (noindex). Say the word to password-lock or remove. Base AED, USD at the fixed 3.6725 peg.