Money
Scope: 3 Oct 2026 · Category: Attars & oils · 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
Money out, not collections. AED 160K left the company on 2 payment vouchers in 3 Oct 2026: salaries through the payroll clearing account and running costs. None of it is a customer payment, and none of it goes to the suppliers of the 3 purchase invoices in the export (AED 1.92M).
By spend group
Groups inferred from ledger names. A ledger mapping in Settings overrides the inference.
- 1Payroll (clearing)2 lines · 2 vouchersAED 160K99.8%
- 2Bank & exchange charges2 lines · 2 vouchersAED 2940.2%
Paid from
The bank or cash ledger each payment is credited to.
- ADIB (ABU DHABI ISLAMIC BANK)AED 160K100%
By ledger class
The class of each ledger debited, inferred from its name.
- PayrollAED 160K100%
- ExpenseAED 2940%
Payment lines (4)
One row per ledger debited on a payment voucher. Classes and spend groups are inferred from ledger names and marked so.
More detailPayroll, owner's drawings, supplier payments
Payroll clearing
Salaries leave through a clearing account; individual pay is not in the export.
- Payment 649 · 3 OctAED 37,000+ AED 63 charges
- Payment 650 · 3 OctAED 122,525+ AED 231 charges
Exchange-house charges on these transfers, AED 294, are grouped under bank and exchange charges.
Owner's drawings
Payments charged to the owner's account.
- None in scope.
Supplier payments
Purchases in the export, and the payments that would settle them.
- Purchase invoices in the export
- 3 · AED 1.92M
- Paid to those suppliers in the export
- None in the export
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.