Import Validation

Review selected persisted fields, row-level issues and reconciliation before confirming an import.

IMP-02
Frontend demonstration. All examples are synthetic. Save, upload, calculate, approve, export and permission actions are UI simulations until connected to authenticated PHP services.
Source rows
1,850
Accepted
1,811
Warnings
14
Rejected / excluded
25

Import issue queue

Inspect original sheet/row references, required fields, exclusions and reviewer notes.

Source-row trace
Actions
14 AM-0015 AM_CODE_UNMAPPED Error Rejected Retail Sales v2
27 CR-00078 PRODUCT_EXCLUDED Information Excluded Retail Sales v2
41 AM-0048 DUPLICATE_SOURCE_ROW Warning Review Retail Sales v2
56 AM-0077 PCR_MISSING Error Rejected Retail Sales v2
102 TOTAL AGGREGATE_ROW Information Excluded Collection v1
119 AM-0029 PERIOD_MISMATCH Error Rejected Data Sales v1

How issues are handled

Blocking errorsUnmapped employees, required missing fields, template mismatches, missing PCR and invalid formulas block confirmation.
WarningsDuplicates and other warnings require review or acknowledgement according to approved configuration.
Excluded rowsCollection totals and explicitly excluded products are traceable but not inserted as employee transactions.

Reconciliation safeguards

Original workbookPrivate file storage
Operational rowsRequired fields only
EvidenceFile, sheet and row
Accepted snapshotImmutable and versioned