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 | 1 |
| 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 | 6,903 | 1,51,41,74,294.29 |
| Ours | Credit note | 3,309 | -6,05,95,768.93 |
| Ours | Receipt | 367 | -1,37,00,38,538.97 |
| Ours | Debit note | 52 | 5,69,066.36 |
| Ours | Journal | 37 | -37,05,775.91 |
Rows excluded
Kept out of the figures, never silently dropped
| other_customer | 213 |
| totals | 2 |
| closing_balance | 1 |
| opening_balance | 1 |
Parse warnings
16 raised while reading the files, grouped by kind
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
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
unresolved_credit_note_reference4
- Credit note 26-27/June/08/16 references "FDTWG06422895", which is neither an invoice number nor a counterparty reference — Credit Note Register row 482
- Credit note 26-27/June/08/17 references "FLGWN07211865", which is neither an invoice number nor a counterparty reference — Credit Note Register row 483
- Credit note 26-27/June/08/18 references "FBSWN06107174", which is neither an invoice number nor a counterparty reference — Credit Note Register row 484
- Credit note 26-27/June/14/29 references "FDGN08073730", which is neither an invoice number nor a counterparty reference — Credit Note Register row 569
missing_voucher_number2
- 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
credit_note_without_reference1
- Credit note 26-27/Apr/30/06 has no reference document — Credit Note Register row 208