Workspace   /   Sales data quality
Local Python applicationCS
CSV QUALITY & SALES REPORTS

Your data, ready to work.

Turn a messy sales export into a clear, traceable report.

Loading your report…
YOUR NEXT EXPORT

Make the messy part simple.

Upload a sales CSV from Excel or another system. Processing runs in your local Python application.

UTF-8 · up to 2 MB · 10,000 rows

Required columns and supported values

One order per row, with a unique order ID. Headers: order_id,date,customer,product,quantity,unit_price,status. English and common Spanish column names are accepted. Optional currency must match your selection. Extra columns are listed but excluded from clean exports.

Statuses: paid / pending / refunded, or pagado / pendiente / reembolsado. Prices have up to two decimal places, without thousands separators. Currency conversion and multi-line orders are outside this demo.
CLEAR RULES, TRACEABLE RESULTS

What happens to every row

  1. Match column names, trim outer whitespace and normalize dates, prices and known statuses.
  2. Reject missing fields, invalid dates, nonpositive quantities, malformed prices and unknown statuses.
  3. Keep the first exact duplicate; log the repeated rows. Different values sharing an order ID send the entire group to review.
  4. Keep paid, pending and refunded orders in clean data. Sum paid orders only; display other statuses separately.
  5. Preserve source row numbers. Export clean CSV, a review log, a JSON summary and a standalone HTML report.
This is an operational sales summary, not an accounting ledger. No tax, profit or exchange-rate calculations. Never guesses missing values.
READY TO HAND OVER

Take the report with you.

Clean data, the exception log and a report you can open without installing anything.

Exports include the loaded data. Check the report before sharing it.