Validation | Quarterly Accounting Manager

Validation diagnostics

Find the reasons behind warnings and invalid rows without changing the stored validation results.

Quality score 100.0% Invalid rows carry full weight; actionable warnings 25%

Raw rows 190,069 Successfully staged

Normalized 190,069 Mapped rows

Valid 190,068 No reasons

Information 0 Non-actionable context

Ignored 1 Excluded zero activity

Warnings 0 Actionable review

Invalid 0 Correction required

Files awaiting mapping 0 0 staged rows not yet normalized

Normalized reconciliation: 190,069 = 190,068 valid + 0 information + 1 ignored + 0 warning + 0 invalid. Awaiting mapping is separate and counts 0 file(s) containing 0 staged row(s) without normalized counterparts.

Validation reasons

Choose a reason to filter the exception rows below.

Clear filter

Reason	Total	Information	Ignored	Warnings	Invalid
Zero activity row	1	0	1	0	0

Validation exceptions

1 rows for “Zero activity row”

Export CSV

File / row	DSP/profile	Diagnostic	Reasons	Label / recording	Country	Mechanicals	Amount
2601 - Spotify.csv Source row 17004	Spotify Spotify Monthly v1	ignored	Zero activity row	Playaz Recordings DJ Hype Jappa — Kill Something	AD	No	— 0.00000000	Inspect

Row inspector

2601 - Spotify.csv · source row 17004 · stored ignored / diagnostic ignored

Raw imported row

[
    "2601",
    "",
    "Spotify",
    "Playaz Recordings",
    "",
    "Kill Something",
    "DJ Hype Jappa",
    "GBLSB2500009",
    "Kill Something",
    "",
    "",
    "",
    "",
    "0",
    "1.176301474",
    "",
    "",
    "",
    "",
    "N",
    "AD",
    "EUR"
]

Normalized values

{
    "period": "2601",
    "day": null,
    "store": "Spotify",
    "label": "Playaz Recordings",
    "catalogue_number": null,
    "track_title": "Kill Something",
    "track_artist": "DJ Hype Jappa",
    "isrc": "GBLSB2500009",
    "album_title": "Kill Something",
    "album_artist": null,
    "ean": null,
    "downloads": null,
    "streams": null,
    "currency": null,
    "country": "AD",
    "mechanicals": 0,
    "amount": "0",
    "exchange_rate": "1.176301474",
    "gbp_amount": null
}

Activity totals

No accounting calculations applied

Downloads0 Streams3,241,303 Supplied GBP total— Reconciliation gap0

Amounts by currency

Raw supplied amount only

Currency	Rows	Amount
Missing	190,068	10947.39678450

Per-file validation summary

Stored counts across all five validation severities.

File	Mapping	Raw	Normalized	Awaiting DSP rows	Valid	Information	Ignored	Warnings	Invalid	Import exceptions
2601 - Spotify.csv	mapped	189,822	189,822	0	189,821	0	1	0	0	0 skipped / 0 malformed
2401 - Boomplay.csv	mapped	247	247	0	247	0	0	0	0	0 skipped / 0 malformed