NEXUS
DATA INTELLIGENCE / CLIENT REPORTING
SYNTHETIC SALES REPORT · 04 / FINANCIAL OPERATIONS
From inconsistent files to trusted KPIs
Standalone report generated by Python from
sales.csv + customers.xlsx.SYNTHETIC DATA ONLY
Recognized revenue$56,975.50USD · paid / completed only
Valid sales records19296.0% of source rows
Excluded records8Every exclusion is logged
ReconciliationPASSValid + excluded = 200 input rows
Revenue by month
Revenue by category
Revenue by segment
Quality issues
| Issue | Affected rows |
|---|---|
| Conflicting Order Id | 2 |
| Exact Duplicate Order Id | 1 |
| Invalid Date | 1 |
| Invalid Quantity | 1 |
| Invalid Status | 1 |
| Invalid Unit Price | 1 |
| Unknown Customer | 1 |
A single rejected record may have multiple issues.
Revenue policy & controls
| Paid or completed orders | 159 |
| Fully refunded orders | 18 / $6,724.60 gross refunded value |
| Cancelled orders | 15 / $6,399.50 cancelled value |
| Source / accepted / excluded | 200 / 192 / 8 |
Revenue is recognized only for paid or completed orders. Fully refunded and cancelled orders are excluded from recognized revenue and displayed separately, never subtracted twice. This is a demo policy, not an accounting standard.