Money
Scope: 1–3 Oct 2026 · Category: Gift sets · 34 receipts, 15 journals and 10 payments
AED 1.06M collected 1–3 Oct 2026; AED 566K of it is post-dated cheques to confirm, and AED 410K arrived without naming an invoice.
- Post-dated cheques
- AED 566K4 cheques to confirm cleared · 54% of collected
- Names no invoice
- AED 410K17 receipts · largest AED 350K
- Cleared via owner's account
- AED 1.95M4 journals; not cash, never counted as collected
Money leaking
12 open price and margin findings, AED 33K at stake, most urgent first.
- High severity:Confirm4 invoice lines priced below their delivery notesInvoiced below the delivery note·Confirm the AED 8,748 cut on 4 invoice lines billed below their delivery-note prices was approved; 2 now at or below cost (largest: INVOFF-2026-8851 for OUD ARD GULF PERFUME TRADING LLC, AED 4,896).AED 8.7Kat stake
- Medium severity:Check priceKhamrah 100ml priced at AED 59.00, 15% below its medianBelow the usual price·Check the AED 59.00 price of Khamrah 100ml for Tourath on sales order SOBR2-2026-1843 before it is invoiced: AED 6,678 below the usual AED 69.50 on 636 pcs.AED 6.7Kat stake
- Medium severity:Check priceHAMNAM INDUSTRIES INC - CANADA's order SOBR1-2026-2991 prices Now Women 100ml at its purchase price (and 1 more item)Order under the margin floor·Check HAMNAM INDUSTRIES INC - CANADA's order SOBR1-2026-2991 before it is invoiced: Now Women 100ml is priced at its purchase price (AED 26.50) on 1,918 pcs, AED 5,699 short of a 10% margin.AED 5.7Kat stake
- Medium severity:Check priceMusk Mood 100ml priced at AED 31.00, 23% below its medianBelow the usual price·Check the AED 31.00 price of Musk Mood 100ml for Alouette(2) on sales invoice INVOFF-2026-8842: AED 7,128 below the usual AED 40.00 on 792 pcs.AED 7.1Kat stake
- Low severity:Check priceSaiyaara's order SOBR2-2026-1695 prices Haya 100ml at its purchase priceOrder under the margin floor·Check Saiyaara's order SOBR2-2026-1695 before it is invoiced: Haya 100ml is priced at its purchase price (AED 44.25) on 360 pcs, AED 1,770 short of a 10% margin.AED 1.8Kat stake
What the money received settles
Of AED 1.06M received, 61% pays invoices issued before the export, 39% names no invoice, and none pays an invoice issued in it.
- Pays earlier invoicesAED 644K61%
- Pays invoices in the exportAED 00%
- Names no invoiceAED 413K39%
- Paid by a receiptAED 00%
- Cleared by journalAED 1.95M60%
- No settlement in the dataAED 1.32M40%
Post-dated cheques to confirm (4)
AED 565,887 from TIME MACHINE PERFUMES L.L.C, deposited to ADIB (ABU DHABI ISLAMIC BANK). Clearance is not in the Day Book.
Who paid
The largest 6 of 20 customers who paid.
Receipts (34)
Every customer receipt in scope and the invoices it settles. An invoice outside the export links to what the data says about it.
More detailBy day, by channel and cost centre, earlier invoices being paid
Collections by day
By voucher date and how the money arrived. Post-dated cheques count on their cheque date.
- Bank (transfer or cheque)
- Post-dated cheque
- Cash
How the money arrived
From the receipt's money side: a cash ledger, or a bank account (post-dated cheques apart).
- Bank (transfer or cheque) · 17 receiptsAED 450K43%
- Post-dated cheque · 4 receiptsAED 566K54%
- Cash · 13 receiptsAED 40K4%
Earlier invoices being paid (9)
Invoices issued before the export that receipts in scope settle, AED 644K in all. Their dates and totals are outside this data.
- INVOFF-2026-8559AED 266,662TIME MACHINE PERFUMES L.L.C · 2 receipts (post-dated cheques)
- INVOFF-2026-8564AED 164,052TIME MACHINE PERFUMES L.L.C · 1 receipt (post-dated cheques)
- INVOFF-2026-8393AED 135,173TIME MACHINE PERFUMES L.L.C · 1 receipt (post-dated cheques)
- INVBR1-2026-9259AED 71,500SARVINOZ- UZB · 8 receipts
- INVOFF-2025-6918AED 3,039CK INTERNATIONAL · 1 receipt
- INVBR1-2026-10386AED 1,464Ghelly - Philpine · 1 receipt
- INVBR1-2026-10352AED 1,188ASLAM-QATAR · 1 receipt
- INVBR1-2026-10365AED 576MAGUTTE- SOW · 1 receipt
- INVBR1-2026-9218AED 97Jarah-Senegal · 1 receipt
How this is countedMatching, cheques, the owner's account, open balances
- How receipts are matched
- A receipt settles an invoice only where Tally names it (a bill allocation against a reference). Nothing is matched by amount; a receipt that names no invoice is listed as such, and amounts recorded on account count as not allocated.
- Only posted vouchers settle
- Optional (memorandum) receipts and journals are not in Tally's books, so they settle no invoice and count in no figure. They stay listed, struck through.
- Post-dated cheques
- Counted as collected on the cheque date. Whether a cheque was deposited or cleared is not in the Day Book, so each one is listed to confirm.
- Owner's account is not cash
- A journal that credits a customer and debits the owner's account clears the customer's balance without money reaching a company bank or cash ledger. It is shown apart and never added to collected. The class comes from the ledger name until a ledger mapping in Settings confirms it.
- Collected beside invoicing
- Set side by side for size only. Most receipts in a short window pay invoices issued before it, and the window's own invoices are paid later or cleared by journal, so collected is not the share of this period's invoices that was paid.
- Open balances
- A Day Book holds no open balances, so what customers owe, and for how long, needs Tally's bill-wise outstanding report with credit terms.