29

Money

1–3 Oct 2026 · 34 receipts, 15 journals and 10 payments · gross; invoices net of VAT

AED 1.06M collected 1–3 Oct 2026; AED 566K of it is post-dated cheques to confirm, and AED 410K 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
Gross margin where cost is known
11.9%AED 19K on AED 162K

Covers 5% of the AED 3.27M invoiced: the rest has no purchase price in the data.

Sold below cost
None found
Under the 10% margin floor
2 items
Cleared to the owner's account
AED 1.95M
4 journals · 4 customers · "Mr Saeed Current Account"
Sales discounts by journal
AED 21K
11 journals · 2 optional not counted (AED 2,080)
This export's invoices cleared by journal
AED 1.95M
9 of 29 invoices · 60% of the amount invoiced
Other journal credits
None
No other journal credits a customer in the export

Cleared by journal to the owner's account

AED 1.95M of customer invoices were cleared by 4 journals to Mr Saeed Current Account; no payment into a bank or cash account shows in the export.

special goods sent to alouetter customer, payment done by bank, raghu make deal with haji saeed,
Narration on journal blnceclr, as recorded in Tally. Shown verbatim; the platform does not interpret it.
Invoices in this export cleared this way
InvoiceCustomerInvoicedClearedAmount
INVOFF-2026-8845
Alouette(2)
1 Octsame dayAED 403,200
INVOFF-2026-8844
Alouette(2)
1 Octsame dayAED 398,400
INVOFF-2026-8842
Alouette(2)
1 Octsame dayAED 349,776
INVOFF-2026-8846
Alouette(2)
1 Octsame dayAED 337,032
INVOFF-2026-8843
Alouette(2)
1 Octsame dayAED 246,840
INVOFF-2026-8854
SAIF & SA-AD
3 Octsame dayAED 119,544
INVOFF-2026-8853
Hassan Makki
3 Octsame dayAED 46,080
INVOFF-2026-8852
HAJI SAEED (MAMLAKT AL OUD )
3 Octsame dayAED 23,040
INVOFF-2026-8847
Hassan Makki
1 Oct3 OctAED 21,132

9 of the 29 invoices issued in scope (60% of AED 3.27M 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 (17)

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.

17 rows
InvoicesNarration (as recorded)
blnceclr
JOURNAL VOUCHER
Confirm
1 Oct
Owner's account
Mr Saeed Current Account
AED 1,735,248“special goods sent to alouetter customer, payment done by bank, raghu make deal with haji saeed,”
3 Oct
Owner's account
Mr Saeed Current Account
AED 119,544None
3 Oct
Owner's account
Mr Saeed Current Account
AED 67,212None
3 Oct
Owner's account
Mr Saeed Current Account
AED 23,040None
8832
JOURNAL VOUCHER
3 Oct
Sales discount
SALES DISCOUNT
AED 13,752No bill namedNone
9884-10327
Journal
1 Oct
Sales discount
SALES DISCOUNT BR1
AED 2,381None
8825
JOURNAL VOUCHER
3 Oct
Sales discount
SALES DISCOUNT
AED 1,361.01No bill namedNone
8740
JOURNAL VOUCHER
3 Oct
Sales discount
SALES DISCOUNT
AED 1,228.50“for foc items”
Page 1 of 3
More detail

Sales discounts by journal

11 counted journals, AED 21,053.09 in all.

  • SALES DISCOUNTAED 17,907.09
  • SALES DISCOUNT BR1AED 3,146.00

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.

  • OCT 2026 · 2 Oct
    TALLY SERVER AND SERVICE (other) against PREPAID - TALLY SERVER (prepaid)
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.