29

Money

Scope: 1–3 Oct 2026 · Cost centre: OFFICE · Category: Body mists

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.

Collected
AED 572K6 receipts; 99% of it pays bills from before the window
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.

7 more
Order under the margin floor 5 · AED 8.7KBelow the usual price 6 · AED 16KInvoiced below the delivery note 1 · AED 8.7K

4 from the receipts and cheques in the export (AED 566K), highest priority first.

  • Cheques to confirm 4
  1. 1
    Cheque 5325 from TIME MACHINE PERFUMES L.L.C, AED 164,052, dated 2 Oct: confirm it cleared
    ConfirmConfirm cheque clearedcheque date 2 Oct, 1 day before the as-of date
    Settles INVOFF-2026-8564 AED 164,052 · issued before the export
    Also in flight:Orders in the export not yet invoiced AED 76KDelivered on note DNOFF-2026-8798, no invoice in export AED 283K
    Action: Confirm the cheque was deposited and cleared; follow up immediately on any return.
    RECEIPT VOUCHER 458 TIME MACHINE PERFUMES L.L.C
    AED 164,052
    cheque
    Priority67
    Size100
    Lateness1
    Exposure100
  2. 2
    Cheque 5310 from TIME MACHINE PERFUMES L.L.C, AED 142,500, dated 1 Oct: confirm it cleared
    ConfirmConfirm cheque clearedcheque date 1 Oct, 2 days before the as-of date
    Settles INVOFF-2026-8559 AED 142,500 · issued before the export
    Also in flight:Orders in the export not yet invoiced AED 76KDelivered on note DNOFF-2026-8798, no invoice in export AED 283K
    Action: Confirm the cheque was deposited and cleared; follow up immediately on any return.
    RECEIPT VOUCHER 456 TIME MACHINE PERFUMES L.L.C
    AED 142,500
    cheque
    Priority67
    Size100
    Lateness1
    Exposure100
  3. 3
    Cheque 5298 from TIME MACHINE PERFUMES L.L.C, AED 135,173, dated 1 Oct: confirm it cleared
    ConfirmConfirm cheque clearedcheque date 1 Oct, 2 days before the as-of date
    Settles INVOFF-2026-8393 AED 135,173 · issued before the export
    Also in flight:Orders in the export not yet invoiced AED 76KDelivered on note DNOFF-2026-8798, no invoice in export AED 283K
    Action: Confirm the cheque was deposited and cleared; follow up immediately on any return.
    RECEIPT VOUCHER 449 TIME MACHINE PERFUMES L.L.C
    AED 135,173
    cheque
    Priority67
    Size100
    Lateness1
    Exposure100
  4. 4
    Cheque 5312 from TIME MACHINE PERFUMES L.L.C, AED 124,162, dated 3 Oct: confirm it cleared
    ConfirmConfirm cheque clearedcheque date 3 Oct, the as-of date
    Settles INVOFF-2026-8559 AED 124,162 · issued before the export
    Also in flight:Orders in the export not yet invoiced AED 76KDelivered on note DNOFF-2026-8798, no invoice in export AED 283K
    Action: Confirm the cheque was deposited and cleared; follow up immediately on any return.
    RECEIPT VOUCHER 457 TIME MACHINE PERFUMES L.L.C
    AED 124,162
    cheque
    Priority67
    Size100
    Lateness0
    Exposure100
Overdue items, credit exposure and late payers need more data
Ranking debts by age needs open balances, which a Day Book does not hold.
Makes this live: Tally's bill-wise outstanding report with due dates, customer credit terms and limits, and some payment history.
How the queue is ordered
Priority
Average of three scores from 0 to 100: size (amount against the large-item threshold), lateness (days late against the high-risk threshold) and exposure (other money in flight with the customer against the credit limit, or the large-item threshold when no limit is known).
Size
Amount at stake against the large-item threshold (AED 50,000, Settings: receivables). At or above it scores 100.
Lateness
Days late against the high-risk threshold (180 days). For a receipt, days since it arrived unallocated; for a cheque, days since its date; for an open item, days past due.
Exposure
Other money in flight with the customer: invoices with no settlement in the export, orders not yet invoiced, and goods delivered with no invoice in the export; for an open item, the customer's other open items and orders against the credit limit.
Working an item
Happens in Tally or with the customer; the platform records nothing in Tally. An alert linked from a row can be acknowledged or assigned in the Action Center.
How this is counted
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.