Money
Scope: 3 Oct 2026 · Cost centre: OFFICE · 3 receipts, 9 journals and 2 payments
AED 130K collected 3 Oct 2026; AED 124K of it is post-dated cheques to confirm, and AED 3.2K arrived without naming an invoice.
- Post-dated cheques
- AED 124K1 cheque to confirm cleared · 95% of collected
- Names no invoice
- AED 3.2K1 receipt
- Cleared via owner's account
- AED 210K3 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
Covers 10% of the AED 1.20M invoiced: the rest has no purchase price in the data.
- Sold below cost
- None found
- Under the 10% margin floor
- None
Cleared by journal to the owner's account
AED 210K of customer invoices were cleared by 3 journals to Mr Saeed Current Account; no payment into a bank or cash account shows in the export.
| Invoice | Customer | Invoiced | Cleared | Amount |
|---|---|---|---|---|
| INVOFF-2026-8854 | SAIF & SA-AD | 3 Oct | same day | AED 119,544 |
| INVOFF-2026-8853 | Hassan Makki | 3 Oct | same day | AED 46,080 |
| INVOFF-2026-8852 | HAJI SAEED (MAMLAKT AL OUD ) | 3 Oct | same day | AED 23,040 |
3 of the 5 invoices issued in scope (16% of AED 1.20M invoiced, gross) are settled by journal within the export; none by a receipt.
By customer
Customer invoices cleared by journal to the owner's account.
Not cash: these journals clear what the customer owes without money reaching a company bank or cash ledger, so they are never added to collections.
Journals crediting customers (11)
Each journal with the ledger it debits, the invoices it names and its narration. Optional journals are shown struck through: they count in no figure.
More detailDiscounts by journal, journals with no customer
Sales discounts by journal
6 counted journals, AED 17,907.09 in all.
- SALES DISCOUNTAED 17,907.09
2 more journals are optional (memorandum) in Tally, AED 2,080.00: listed in the journals above but not counted, as Tally keeps them out of the books until regularised.
Journals with no customer
Journals in scope that touch no customer ledger, so they settle no customer balance.
- None in scope.
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.