29

Data health

Tally Day Book, 1–3 Oct 2026 · every check, import and source record behind the figures

Download data

The export balances: every voucher and document total reconciles; 3 invoice numbers are on two vouchers and 8 lines carry goods without a value.

Every imported record of MAMLAKT AL OUD PERFUME TRADING LLC -may2026, 1–3 Oct 2026. Page filters do not apply; checks rerun whenever the data, mappings or settings change.

Vouchers imported
256248 counted in figures
Checks passed
9 of 245 flagged · 10 noted
Duplicates kept out
AED 189K3 invoices counted once
Latest data
3 Oct 2026imported 24 Oct 2026

Checks and audit trail

Bookkeeping in All actions

Quality checks

24 rules on every record: 9 pass, 10 noted and handled by a stated rule, 5 flagged for a person. A rule never edits data.

IntegrityDoes the data add up? Vouchers balance, totals reconcile, transfers conserve stock.
3 pass
  • Pass
    Debits equal credits on every accounting voucher
    All 97 accounting vouchers balance, item lines included.
    97 examined · 0 found
    voucher_balance
  • Pass
    Document totals equal goods + VAT + rounding
    All 184 itemised documents reconcile (largest rounding AED 0.2).
    184 examined · 0 found
    invoice_totals
  • Pass
    Stock transfers conserve quantity
    All 6 transfers move the same quantity out as in.
    6 examined · 0 found
    transfer_balance
DuplicatesIs each economic event counted once?
1 pass · 1 flagged
  • Flagged
    Each invoice number counted once
    3 invoice numbers recorded twice; AED 188,664 kept out of sales.
    32 examined · 3 found
    duplicate_invoice
    3 invoice numbers, shown side by side below
  • Pass
    Invoice numbers are not reused for different sales
    No invoice number is shared by different sales.
    32 examined · 0 found
    invoice_number_reused
ClassificationIs every voucher understood, and counted under the right rule?
2 pass · 1 flagged · 3 noted
  • Pass
    Every voucher type is mapped to a category
    All 25 voucher types are mapped.
    25 examined · 0 found
    unknown_voucher_type
  • Pass
    Categories agree with the source's invoice flag
    Every invoice category carries the source's invoice flag, and no other does.
    256 examined · 0 found
    classification_conflict
  • Noted
    Cancelled vouchers excluded
    1 cancelled voucher excluded from all figures.
    256 examined · 1 found
    cancelled
    Show the issue
    Info
    1 cancelled voucher

    DELIVERY NOTE-BR2 DNBR2-2026-9243

    What the platform does: Excluded from all figures; kept for audit.

    DELIVERY NOTE-BR2 DNBR2-2026-9243
  • Flagged
    Optional (memorandum) vouchers kept out of figures
    4 optional vouchers not counted (plus 3 optional duplicates handled above).
    256 examined · 4 found
    optional
    Show the issue
    Warning
    4 optional vouchers are not countedAED 131,742

    Optional vouchers are recorded in Tally but not posted to the books: Sales Order SOOFF-2026-3116 (AED 129,662), JOURNAL VOUCHER 7595 (AED 200), JOURNAL VOUCHER 8333 (AED 1,880), SALES BRANCH1 SOBR1-2026-3207 (AED 0).

    What the platform does: Shown on their pages and in Data Health; excluded from figures until regularised in Tally.

    Sales Order SOOFF-2026-3116JOURNAL VOUCHER 7595JOURNAL VOUCHER 8333SALES BRANCH1 SOBR1-2026-3207
  • Noted
    Post-dated vouchers identified
    5 post-dated vouchers, counted on their own date.
    256 examined · 5 found
    post_dated
    Show the issue
    Info
    5 post-dated vouchers

    4 customer receipts are post-dated cheques worth AED 565,887; clearance is not evidenced in this export.

    What the platform does: Counted on the cheque date; marked as post-dated wherever shown.

    RECEIPT VOUCHER 449RECEIPT VOUCHER 456RECEIPT VOUCHER 458Journal OCT 2026RECEIPT VOUCHER 457
  • Noted
    Vouchers altered after their date
    46 vouchers were altered after their date (latest alteration 2026-10-07).
    256 examined · 46 found
    altered_after_entry
LinksDo documents reference each other, and do the references resolve inside the export?
1 pass · 1 flagged · 3 noted
CompletenessAre the fields that figures depend on filled in?
1 pass · 2 flagged · 1 noted
  • Flagged
    Item lines carry a quantity or an amount
    4 lines carry neither a quantity nor an amount (3 without an item either).
    1,092 examined · 4 found
    empty_lines
    Show the issue
    Warning
    4 empty item lines

    Lines with neither a quantity nor an amount on DELIVERY NOTE-BR2 DNBR2-2026-9243, DELIVERY NOTE-BR3 DNBR3-2026-4343, SALES BRANCH1 SOBR1-2026-3207, Sales Order SOOFF-2026-3100; 3 name no item.

    What the platform does: Kept for audit; they contribute nothing to any figure.

    DELIVERY NOTE-BR2 DNBR2-2026-9243DELIVERY NOTE-BR3 DNBR3-2026-4343SALES BRANCH1 SOBR1-2026-3207Sales Order SOOFF-2026-3100
  • Pass
    Item lines run in their document's direction
    Every item line runs in its document's direction.
    1,091 examined · 0 found
    reversed_lines
  • Noted
    Item lines with quantity carry a value
    8 lines have a quantity but no value (free goods or missing price).
    1,091 examined · 8 found
    zero_value_lines
    Show the issue
    Info
    8 lines have quantity but no value

    5,329 units on 8 lines, e.g. DNOFF-2026-8476 SPRAY YARA ELIXIR 100ml ( 48) LAT; SOBR2-2026-1695 SPRAY SUMMER FOREVER 100ML(48)AH; SOBR2-2026-1695 SPRAY SO CANDID POUR HOMME 100ML(48)AH.

    What the platform does: Counted in quantities, not in values.

    Delivery Note DNOFF-2026-8476SALES BRANCH2 SOBR2-2026-1695SALES BRANCH1 SOBR1-2026-2991SALES NASEER-SO SONAS-2026-944Sales Order SOOFF-2026-3091
  • Flagged
    Trading documents carry a cost centre
    1 document has no cost centre. 2 take theirs from their item lines (none on the voucher).
    213 examined · 1 found
    missing_cost_centre
    Show the issue
    Warning
    1 document has no cost centreAED 350,000

    RECEIPT VOUCHER 549 (AED 350,000)

    What the platform does: Grouped under "No cost centre" in branch views.

    RECEIPT VOUCHER 549
Master dataAre customers and products identified consistently?
1 pass · 3 noted
  • Noted
    Products resolved to a brand
    420 of 443 products resolved to a brand from their names; 23 need a mapping.
    443 examined · 23 found
    unresolved_brand
    Show the issue
    Info
    23 products without a brand

    Item names carry no recognised brand code, e.g. GIFT SET 3PCS COLLECTION - AMEERAT AL ARAB (Spray+Hairmist+Deo 200ml) (24); GIFT SET 3PCS COLLECTION - AMEERAT AL ARAB (Spray+Deo+A/F) (24); GIFTSET - ART OF UNIVERSE-3PCS (20pcs) EDP 100ML+20ML+DEO200); PERFUME DAK COLLECTIONS GRAPEFRUIT EXRACT 100 ML 48.

    What the platform does: Grouped as "Unresolved" in brand views; set the brand on the product page.

    GIFT SET 3PCS COLLECTION - AMEERAT AL ARAB (Spray+Hairmist+Deo 200ml) (24)GIFT SET 3PCS COLLECTION - AMEERAT AL ARAB (Spray+Deo+A/F) (24)GIFTSET - ART OF UNIVERSE-3PCS (20pcs) EDP 100ML+20ML+DEO200)PERFUME DAK COLLECTIONS GRAPEFRUIT EXRACT 100 ML 48PERFUME VALERIO UOMO (INTENSE) 80ML (48)FRAGRANCE MIST KENZIE VANILLA 70 250ML(12*4)FRAGRANCE MIST KENZIE EXOTIC APPLE CRUSH 250ML(12*4PERFUME ASTRAELLA 100ML (48)and 15 more
  • Pass
    Customer names are distinct
    No customer names look like variants of each other.
    96 examined · 0 found
    party_name_variants
  • Noted
    Customers have a country
    79 of 96 customers have a country on their documents.
    96 examined · 17 found
    customer_country
  • Noted
    Custom fields understood
    4 custom fields found; their meaning is to be confirmed with the client.
    4 examined · 4 found
    custom_fields
    Show the issue
    Info
    4 custom Tally fields of unconfirmed meaning

    MLKT_SOSTATUS (166), BASICNUMPACKAGESG (302), CHRISDISC1M (12), CHRISDISC2M (12)

    What the platform does: Shown on documents verbatim; used in no figure until their meaning is confirmed.

    MLKT_SOSTATUSBASICNUMPACKAGESGCHRISDISC1MCHRISDISC2M

The same invoice, recorded twice

3 invoice numbers are on two vouchers each (same number, party and value). Counted once; summing vouchers would add AED 188,664 of sales that happened once.

Invoiced sales, net of VAT
If both were summed
AED 3,454,985
Counted
AED 3,266,321
AED 188,664 would be counted twice: sales overstated by 5.8%.
Invoices
If both were summed
32 vouchers
Counted
29 invoices
3 vouchers repeat an invoice already counted.
Average invoice
If both were summed
AED 108K
Counted
AED 113K
Averages and counts change too, not only totals.
Customer share of invoiced salesIf both summedCountedChange
Alouette(2)50.2%53.1%+2.9 pts
SAEED HADIYA MUHAMMED HADIYA29.2%30.8%+1.7 pts
SAIF & SA-AD recorded twice6.9%3.7%−3.3 pts
Comercial Multi Spa3.4%3.6%+0.2 pts
Hassan Makki recorded twice3.3%2.1%−1.2 pts
Dakhoon Trading Perfumes FZC LLC1.7%1.8%+0.1 pts
HAJI SAEED (MAMLAKT AL OUD ) recorded twice1.3%0.7%−0.6 pts
INVOFF-2026-8852·HAJI SAEED (MAMLAKT AL OUD ) same number, party and value different GUIDs
AED 23,040 kept out of sales
KeptSales voucher
Counted
Tally GUID
fc781dac-49c3-4394-ac58-f02392cb676f-0000d52a
Alteration id
105265
Optional in Tally
No (posted)
Item lines
2 lines · 2 distinct items
Orders · deliveries cited
1 · 1
Goods, net of VAT
AED 23,040.00
Party total
AED 23,040.00
Entered by
rvkmhd
Kept outINVOICE voucher
Duplicate · not counted
Tally GUID
fc781dac-49c3-4394-ac58-f02392cb676f-0000d52d
Alteration id
105271
Optional in Tally
Yes (memorandum, not posted)
Item lines
1 line · 1 distinct item
Orders · deliveries cited
0 · 1
Goods, net of VAT
AED 23,040.00
Party total
AED 23,040.00
Entered by
rvkmhd
Why this one was kept
  • Same invoice number, party (HAJI SAEED (MAMLAKT AL OUD )) and value on 2 vouchers with different source ids.
  • Kept the posted voucher; INVOICE is optional (memorandum) in Tally.
  • Kept "Sales" with 2 distinct items; the other lists a generic assorted item that hides the product mix.
INVOFF-2026-8853·Hassan Makki same number, party and value different GUIDs
AED 46,080 kept out of sales
KeptSales voucher
Counted
Tally GUID
fc781dac-49c3-4394-ac58-f02392cb676f-0000d52b
Alteration id
105266
Optional in Tally
No (posted)
Item lines
2 lines · 2 distinct items
Orders · deliveries cited
1 · 1
Goods, net of VAT
AED 46,080.00
Party total
AED 46,080.00
Entered by
rvkmhd
Kept outINVOICE voucher
Duplicate · not counted
Tally GUID
fc781dac-49c3-4394-ac58-f02392cb676f-0000d52f
Alteration id
105274
Optional in Tally
Yes (memorandum, not posted)
Item lines
1 line · 1 distinct item
Orders · deliveries cited
0 · 1
Goods, net of VAT
AED 46,080.00
Party total
AED 46,080.00
Entered by
rvkmhd
Why this one was kept
  • Same invoice number, party (Hassan Makki) and value on 2 vouchers with different source ids.
  • Kept the posted voucher; INVOICE is optional (memorandum) in Tally.
  • Kept "Sales" with 2 distinct items; the other lists a generic assorted item that hides the product mix.
INVOFF-2026-8854·SAIF & SA-AD same number, party and value different GUIDs
AED 119,544 kept out of sales
KeptSales voucher
Counted
Tally GUID
fc781dac-49c3-4394-ac58-f02392cb676f-0000d52c
Alteration id
105267
Optional in Tally
No (posted)
Item lines
1 line · 1 distinct item
Orders · deliveries cited
1 · 1
Goods, net of VAT
AED 119,544.00
Party total
AED 119,544.00
Entered by
rvkmhd
Kept outINVOICE voucher
Duplicate · not counted
Tally GUID
fc781dac-49c3-4394-ac58-f02392cb676f-0000d530
Alteration id
105276
Optional in Tally
Yes (memorandum, not posted)
Item lines
1 line · 1 distinct item
Orders · deliveries cited
0 · 1
Goods, net of VAT
AED 119,544.00
Party total
AED 119,544.00
Entered by
rvkmhd
Why this one was kept
  • Same invoice number, party (SAIF & SA-AD) and value on 2 vouchers with different source ids.
  • Kept the posted voucher; INVOICE is optional (memorandum) in Tally.
  • Kept "Sales" with 1 distinct item; the other lists a generic assorted item that hides the product mix.

Voucher types and what counts

256 vouchers of 25 types; every type is mapped to a category. Optional, cancelled and duplicate vouchers are kept and shown, not counted.

Each type is mapped by its exact Tally name: 72 sales orders, 65 delivery notes, 32 invoice records / 29 distinct numbers, 34 customer receipts, 13 goods receipts, 3 purchase invoices, 9 stock journals, 10 payments, 18 journals.

Sales orders
72
70 counted · 2 optional
4 voucher types
Delivery notes
65
64 counted · 1 cancelled
5 voucher types
Sales invoices
32
32 invoice records / 29 distinct numbers
29 counted · 3 duplicate
6 voucher types
Customer receipts
34
all counted
2 voucher types
Goods receipts
13
all counted
2 voucher types
Purchase invoices
3
all counted
1 voucher type
Stock journals
9
all counted
1 voucher type
Payments
10
all counted
2 voucher types
Journals
18
16 counted · 2 optional
2 voucher types
Voucher type (as named in Tally)CategoryDecided byVouchersCountedOptionalCancelledDuplicateExample
SALES BRANCH1Sales orderBuilt-in list2524100SOBR1-2026-3060
SALES BRANCH2Sales orderBuilt-in list2121000SOBR2-2026-1695
Sales OrderSales orderBuilt-in list2120100SOOFF-2026-3042
SALES NASEER-SOSales orderBuilt-in list55000SONAS-2026-947
Delivery NoteDelivery noteBuilt-in list2323000DNOFF-2026-8476
DELIVERY NOTE-BR1Delivery noteBuilt-in list1818000DNBR1-2026-10317
DELIVERY NOTE-BR2Delivery noteBuilt-in list1211010DNBR2-2026-9153
DELIVERY NOTE-NASEERDelivery noteBuilt-in list1010000DNNSR1-2026-1811
DELIVERY NOTE-BR3Delivery noteBuilt-in list22000DNBR3-2026-4342
SalesSales invoiceBuilt-in list1515000INVOFF-2026-8842
SALES BR1 INVSales invoiceBuilt-in list99000INVBR1-2026-10394
INVOICESales invoiceBuilt-in list30003INVOFF-2026-8852
SALES BR2 INVSales invoiceBuilt-in list33000INVBR2-2026-9215
SALES BR3 INVSales invoiceBuilt-in list11000INVBR3-2026-4344
SALES NSR INVSales invoiceBuilt-in list11000INVNASR-2026-2007
BR1 ReceiptCustomer receiptBuilt-in list27270001344
RECEIPT VOUCHERCustomer receiptBuilt-in list77000449
STOCK RCVDGoods receiptBuilt-in list1212000DESLH020261001402
Receipt NoteGoods receiptBuilt-in list11000BP/CRS/261547
PurchasePurchase invoiceBuilt-in list3300083474
Stock JournalStock journalBuilt-in list990001183
PaymentPaymentBuilt-in list88000300
PAYMENT VOUCHERPaymentBuilt-in list22000132
JournalJournalBuilt-in list990002978/10388
JOURNAL VOUCHERJournalBuilt-in list97200blnceclr
25 voucher typesall mapped256248413

Import history

1 import; the figures come from 3days DayBook.xml. Importing the same file again changes nothing.

Importing the same file again changes no figure: every record is recognised by its source identity and left unchanged. Each voucher is identified by its Tally GUID: a repeated file only updates “last seen”, a revised voucher keeps its earlier content, and an older revision than the one held is recorded as stale and ignored.
  1. 3days DayBook.xmlcurrent
    24 Oct 2026, 16:11 · by setup
    19.3 MB · checksum 73fd7b38932e…
    tally-xml 1.0.0 · UTF-16LE
    1 Oct to 3 Oct 2026
    MAMLAKT AL OUD PERFUME TRADING LLC -may2026
    256 records
    256 new
More detail

Reconciliation

What the export can prove about itself, and what needs a snapshot from Tally to prove.

  • Reconciles
    Voucher balance: debits equal credits
    All 97 accounting vouchers balance, item lines included. See the check
  • Reconciles
    Document totals: goods plus VAT plus rounding equal the party amount
    All 184 itemised documents reconcile (largest rounding AED 0.2). See the check
  • Reconciles
    Transfer conservation: stock moved out equals stock moved in
    All 6 transfers move the same quantity out as in. See the check
  • Reconciles
    Billed quantities equal the delivery or receipt notes they bill
    All 126 billed lines whose note is in the export match its quantity. See the check
  • Needs data
    Stock balance: opening plus movements equals closing, per item and location
    A Day Book holds movements, not balances, so stock on hand cannot be reconciled from it.
    Makes this live: A Tally stock summary snapshot (quantity by item and location) at the start and end of the export period.
  • Needs data
    Receivables: open bills agree with customer balances
    Receipts in the export settle bills issued before it, so open balances cannot be rebuilt from three days.
    Makes this live: Tally's bill-wise outstanding report (receivables) as of the export's last day.
  • Needs data
    Cash and bank: movements agree with ledger balances
    Bank and cash movements are in the export; their opening and closing balances are not.
    Makes this live: Closing balances of bank and cash ledgers (a trial balance) for the export period.

Custom fields

Fields the company added to Tally. Kept verbatim and shown on documents; used in no figure until their meaning is confirmed with the client.

  • MLKT_SOSTATUS Meaning unconfirmed · not used in figures
    Document field · 166 occurrences on 166 documents · 2 distinct values · Payments, Customer receipts, Goods receipts, Delivery notes, Sales invoices, Sales orders, Purchase invoices, Journals
    Update × 120Approved × 46

    Shown on documents as “workflow status (custom field)”. Its values look like an approval state, which only the client can confirm.

  • BASICNUMPACKAGESG Meaning unconfirmed · not used in figures
    Item line field · 302 occurrences on 83 documents · 34 distinct values · Delivery notes, Sales orders, Sales invoices
    12 × 11424 × 566 × 400 × 2836 × 104 × 7
  • CHRISDISC1M Meaning unconfirmed · not used in figures
    Item line field · 12 occurrences on 7 documents · 10 distinct values · Sales invoices
    0.08 × 20.058 × 20.044 × 10.09 × 10.05 × 10.052 × 1
  • CHRISDISC2M Meaning unconfirmed · not used in figures
    Item line field · 12 occurrences on 7 documents · 12 distinct values · Sales invoices
    15.18 × 128.80 × 123.35 × 117.60 × 121.50 × 123.56 × 1
MLKT_SOSTATUS by document category
Update120 documents · 72%
Sales orders 52 · Delivery notes 43 · Sales invoices 18 · Customer receipts 3 · Payments 1 · Goods receipts 1 · Purchase invoices 1 · Journals 1
Approved46 documents · 28%
Delivery notes 20 · Sales orders 20 · Sales invoices 6

166 documents carry the field; the rest leave it empty.

Sources

The XML file is one transport. An adapter turns each export format into format-neutral records; a new source needs a new adapter and nothing else.

Reading now
  • Tally XML export (Day Book)
    adapter tally-xml · version 1.0.0 · active
Planned
  • Tally XML-over-HTTP (scheduled pull)
    tally-http · planned
  • Tally ODBC (scheduled pull)
    tally-odbc · planned
  • CSV snapshots (stock, receivables, masters)
    csv-masters · planned

Downloads

CSV files of the normalised data, UTF-8, one row per record. Derived from the model; no raw source text.

Source records

Every imported document, with whether it counts in figures and, if not, why. Open one for its lines, links, quality notes and the stored source record.

CSV
Opens the document with its stored source record256 rows
132
PAYMENT VOUCHER
Payment1 OctCASHAED 4,000
Counted
133
PAYMENT VOUCHER
Payment1 OctCASHAED 1,080
Counted
300
Payment
Payment1 OctAL ATLAL REAL ESTATEAED 17,500
Counted
449
RECEIPT VOUCHER
Customer receipt1 OctTIME MACHINE PERFUMES L.L.CAED 135,173
Countedpost-dated
456
RECEIPT VOUCHER
Customer receipt1 OctTIME MACHINE PERFUMES L.L.CAED 142,500
Countedpost-dated
549
RECEIPT VOUCHER
Customer receipt1 OctHA TRADINGAED 350,000
Counted
640
Payment
Payment1 OctCASHAED 1,400
Counted
641
Payment
Payment1 OctCASHAED 1,170
Counted
642
Payment
Payment1 OctCASHAED 840
Counted
643
Payment
Payment1 OctCASHAED 20,300
Counted
Page 1 of 26

Data as of 3 Oct 2026, the last voucher date in the export. Checks and links are recomputed whenever the data, mappings or settings change. Rules and thresholds