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.

Money leaking

12 open price and margin findings, AED 33K at stake, most urgent first.

Order under the margin floor 5 · AED 8.7KBelow the usual price 6 · AED 16KInvoiced below the delivery note 1 · AED 8.7K
Receivables ageing needs an outstanding snapshot
A Day Book lists three days of vouchers. Receipts in it settle bills issued long before, so what each customer owes, and for how long, cannot be rebuilt from it. Rather than show a partial number, the platform waits for the report that states it.
Makes this live: Tally's bill-wise outstanding report (receivables) as of the export's last day, with each customer's credit terms and limits. With them, this tab ages every open bill, ranks customers by exposure and feeds the collections queue.

What the export does say: “bill pending” on each invoice

Tally's e-invoicing fields record a pending amount on every invoice when it is exported. It is shown as recorded, beside what the export itself settled.

Bill pending, as recorded
AED 3.10M
on 15 invoices · equals the full invoice on 15 of 15
Settled within the export
AED 1.95M
9 of these invoices, by receipt or journal
Not a current receivable. The field is a snapshot taken when each invoice was exported; settlements entered afterwards (even the same day) do not change it, and later payments are not in this data.
15 rows
3 Oct 2026AED 1,007,556AED 1,007,556Nothing in the export
1 Oct 2026AED 403,200AED 403,200
AED 403,200byblnceclr(owner's account journal, 1 Oct)
1 Oct 2026AED 398,400AED 398,400
AED 398,400byblnceclr(owner's account journal, 1 Oct)
1 Oct 2026AED 349,776AED 349,776
AED 349,776byblnceclr(owner's account journal, 1 Oct)
1 Oct 2026AED 337,032AED 337,032
AED 337,032byblnceclr(owner's account journal, 1 Oct)
1 Oct 2026AED 246,840AED 246,840
AED 246,840byblnceclr(owner's account journal, 1 Oct)
3 Oct 2026AED 119,544AED 119,544
AED 119,544by8854(owner's account journal, 3 Oct)
2 Oct 2026AED 116,510.40AED 116,510.40Nothing in the export
3 Oct 2026AED 46,080AED 46,080
AED 46,080by8853(owner's account journal, 3 Oct)
3 Oct 2026AED 23,040AED 23,040
AED 23,040by8852(owner's account journal, 3 Oct)
Page 1 of 2
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.