Money
Scope: 1–3 Oct 2026 · Cost centre: OFFICE · Category: Gift sets
AED 572K collected 1–3 Oct 2026; AED 566K of it is post-dated cheques to confirm, and AED 3.2K arrived without naming an invoice.
- Post-dated cheques
- AED 566K4 cheques to confirm cleared · 99% of collected
- Names no invoice
- AED 3.2K1 receipt
- 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
Order under the margin floor 5 · AED 8.7KBelow the usual price 6 · AED 16KInvoiced below the delivery note 1 · AED 8.7K
What the money received settles
Of AED 572K received, 99% pays invoices issued before the export, 1% names no invoice, and none pays an invoice issued in it.
Money receivedAED 572,174 · 6 receipts
- Pays earlier invoicesAED 569K99%
- Pays invoices in the exportAED 00%
- Names no invoiceAED 3.2K1%
Invoices issued in scopeAED 3,102,992 gross · 15 invoices
- Paid by a receiptAED 00%
- Cleared by journalAED 1.95M63%
- No settlement in the dataAED 1.16M37%
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
Customers by money received.
Receipts (6)
Every customer receipt in scope and the invoices it settles. An invoice outside the export links to what the data says about it.
Select a row for the receipt6 rows
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) · 2 receiptsAED 6.3K1%
- Post-dated cheque · 4 receiptsAED 566K99%
- Cash · 0 receiptsAED 00%
By cost centre
Earlier invoices being paid (4)
Invoices issued before the export that receipts in scope settle, AED 569K 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)
- INVOFF-2025-6918AED 3,039CK INTERNATIONAL · 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.