Data quality
What the engine can and cannot vouch for in this run
Checks
Every fatal check passed. 6 warning(s) need attention but do not invalidate the figures.
| Pass | Every difference on a matched invoice decomposes into a known cause | |
| Pass | Ledger opening balance plus vouchers ties to the closing balance | |
| Pass | Every counterparty register row became a payment line or a logged drop | |
| Warning | Every in-coverage invoice appears in both systems These invoices exist on one side only and need chasing | 362 |
| Warning | No invoice number appears twice in our ledger The same invoice number was raised more than once | 6,902 |
| Warning | Every document reference parsed These references need a manual mapping before they count | 1 |
| Warning | No invoice is booked under two counterparty references These are kept separate rather than merged, and need a decision on which reference is live | 5 |
| Warning | Every counterparty note is attributed to an invoice Unattributed notes distort the invoices they should have reduced | 48 |
| Warning | An invoice-wise outstanding report was supplied Without it, receipt allocation cannot be derived and outstanding cannot be compared |
Documents read
After de-duplication: the register repeats a document on every payment row
| Side | Type | Count | Value |
|---|---|---|---|
| Theirs | Invoice | 7,738 | 1,55,93,36,073.31 |
| Theirs | Debit note | 2,703 | -4,76,74,714.88 |
| Theirs | TDS memo | 130 | -41,193.63 |
| Theirs | Provisional debit note | 14 | -11,239.36 |
| Theirs | Unclassified | 1 | -53,438.67 |
| Ours | Invoice | 13,806 | 3,02,83,48,588.58 |
| Ours | Credit note | 6,680 | -12,22,68,576.43 |
| Ours | Receipt | 734 | -2,74,00,77,077.94 |
| Ours | Debit note | 104 | 11,38,132.72 |
| Ours | Journal | 74 | -74,11,551.82 |
Rows excluded
Kept out of the figures, never silently dropped
| totals | 4 |
| closing_balance | 2 |
| opening_balance | 2 |
| other_customer | 2 |
| repeated_header | 1 |
Parse warnings
1,233 raised while reading the files, grouped by kind
register_reference_conflict1,211
- FKIDN42234244 points at FKIDN42234244 in the ledger but 2526/2535 in the register; the ledger was used — Credit Note Register
- FKIDN41869652 points at FKIDN41869652 in the ledger but 2526/2597 in the register; the ledger was used — Credit Note Register
- FKIDN42249455 points at FKIDN42249455 in the ledger but 2526/2735 in the register; the ledger was used — Credit Note Register
- FKIDN42248229 points at FKIDN42248229 in the ledger but 2526/2702 in the register; the ledger was used — Credit Note Register
- FKIDN42247948 points at FKIDN42247948 in the ledger but 2526/2703 in the register; the ledger was used — Credit Note Register
- FKIDN42110550 points at FKIDN42110550 in the ledger but 2526/2705 in the register; the ledger was used — Credit Note Register
- FKIDN42262342 points at FKIDN42262342 in the ledger but 2526/2682 in the register; the ledger was used — Credit Note Register
- FKIDN42050156 points at FKIDN42050156 in the ledger but 2526/2577 in the register; the ledger was used — Credit Note Register
- and 1,203 more
unresolved_credit_note_reference7
- Credit note YNPL24-25/5541 references "FDGN05850256", which is neither an invoice number nor a counterparty reference — Credit Note Register row 73
- Credit note 646 references "FMSWG05087325", which is neither an invoice number nor a counterparty reference — Credit Note Register row 74
- Credit note 25-26/Jan/23/1 references "FKIND45330227", which is neither an invoice number nor a counterparty reference — Credit Note Register row 410
- Credit note 26-27/June/08/16 references "FDTWG06422895", which is neither an invoice number nor a counterparty reference — Credit Note Register row 2128
- Credit note 26-27/June/08/17 references "FLGWN07211865", which is neither an invoice number nor a counterparty reference — Credit Note Register row 2129
- Credit note 26-27/June/08/18 references "FBSWN06107174", which is neither an invoice number nor a counterparty reference — Credit Note Register row 2130
- Credit note 26-27/June/14/29 references "FDGN08073730", which is neither an invoice number nor a counterparty reference — Credit Note Register row 2202
unparseable_doc_number5
- Document number could not be parsed: "20250902-0600159-YNPL5-26/2499" — Aug 2025 to till date row 738
- Document number could not be parsed: "20251001-0600157-YNPL258-26/2985" — Aug 2025 to till date row 1272
- Document number could not be parsed: "20251121-0700010-YNPL235-26/3570" — Aug 2025 to till date row 2378
- Document number could not be parsed: "GST Recovery_FY_Apr'19 to Mar'25_307" — Aug 2025 to till date row 3260
- Document number could not be parsed: "20260801-0600155-YNPL26/2425" — Aug 2025 to till date row 8722
missing_voucher_number4
- Credit Note New has no voucher number, so it cannot be attributed to an invoice — Ledger YNPL row 35
- Credit Note New has no voucher number, so it cannot be attributed to an invoice — Ledger YNPL row 36
- Credit Note New has no voucher number, so it cannot be attributed to an invoice — YNPL Ledger row 35
- Credit Note New has no voucher number, so it cannot be attributed to an invoice — YNPL Ledger row 36
type_from_erp_id4
- Document number "20250902-0600159-YNPL5-26/2499" was unparseable; type taken from ERP id FKIIN — Aug 2025 to till date row 738
- Document number "20251001-0600157-YNPL258-26/2985" was unparseable; type taken from ERP id FKIIN — Aug 2025 to till date row 1272
- Document number "20251121-0700010-YNPL235-26/3570" was unparseable; type taken from ERP id FKIIN — Aug 2025 to till date row 2378
- Document number "20260801-0600155-YNPL26/2425" was unparseable; type taken from ERP id FKIIN — Aug 2025 to till date row 8722
credit_note_without_reference2
- Credit note 25-26/Mar/31/20 has no reference document — Credit Note Register row 587
- Credit note 26-27/Apr/30/06 has no reference document — Credit Note Register row 1903