Data quality

Load 1 · started 10/26/26 18:09 UTC · finished 10/26/26 18:09 UTC · 2 files

Files

Every file of the latest load and what the loader did with it. For a loaded sales file, what the file's own total declares against what was loaded from it, and how many of its rows a later file has since replaced.

VIP1 file

									Warnings	Declared 9L	Loaded 9L	9L difference	Declared $	Loaded $	$ difference
Accounts/VIP/Glenn Accounts Badlands.xlsx	vip_accounts	loaded	01/01/26 – 10/14/26	10/14/26	10/15/26	2	4	0	reader_read_excel_file 1	—	—	—	—	—	—	—

LibDib1 file

									Warnings	Declared 9L	Loaded 9L	9L difference	Declared $	Loaded $

Reconciliation

Each LibDib account's orders, 9L and dollars as the latest customer list states them, against what was loaded for it from the order files. Only the accounts that differ are listed.

No LibDib customer list is loaded.

Review queue

What the loader flagged for a person to look at, by kind, rule and severity, and how much of it is still open.

Review duplicates →

Kind	Rule	Severity	Open	Resolved	Dismissed
account_duplicate_candidate	name_zip	info	1	0	0
account_unmatched	identity_incomplete	warning	1	0

Match summary

Every account-based figure in this app rides on these matches.

Source	Id kind	Method	Status	Accounts	Current lines	Current 9L
LibDib	libdib_order_key	synthesized	review	3	4	2.5
VIP	vip_outlet_id	new_identity	matched	2	0

Listing reconciliation

Each outlet's this-year 9L as the VIP accounts file lists it, against the 9L loaded for that outlet over the same window. Only the outlets that differ are listed.

0 of 2 outlets equal

Outlet	Account	Window	Accounts file	Listed 9L	Loaded 9L	9L difference	Distributors
38000001	NF-ND-00001	01/01/26 – 10/14/26	Accounts/VIP/Glenn Accounts Badlands.xlsx	1.0	0.0	1.0	0

Coverage

Which months each sub-source holds, and its 9L. Filled: the month is complete. Dashed: the source has reported only part of it. Hover a month for its grain.

Sub-source	Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
libdib	2026	—	—	2.5

Month provenance

For each sub-source and month, how many files and fact rows its figures come from, how many rows carry derived physical cases, and whether the month is still provisional.

Sub-source	Month	Files	Fact rows	Derived rows	Export date	Status
libdib	Oct 2026	0	0	0	10/14/26

Identity

All-time 9L volume per state by the kind of account it is on, and how many accounts of each kind the state has. The sentinel share is the state-unclassified and unmatched volume over the state's total.


ID	0.5	0.0	0.0	0.5	0.0%
SD	0.5	0.0