Open the sample
See the result.
Check the rows.
Explore a complete order report. Follow each accepted, duplicate and rejected row back to its source.
Fictional sample. Saved results.
No code included in the free sample.
The included sample
Every row accounted for.
Saved report USD
Accepted revenue
$973.69
48 units across 16 accepted orders
By month
| Month | Orders | Units | Revenue |
|---|
By category
| Category | Orders | Units | Revenue |
|---|
Totals include accepted orders only. Exact duplicates and rejected records are excluded.
Accepted orders
Validated rows used in the totals.
Scroll sideways to see all columns.
| CSV row | Order ID | Date | Category | Qty | Unit price | Revenue |
|---|
USD throughout. Revenue = quantity × unit price. Source row numbers include the CSV header.
Needs review
2 exact duplicates and 8 rejected rows. Original values shown.
Scroll sideways to see all columns.
| CSV row | Order / date | Category | Qty / price | Result | Reason |
|---|
All versions of conflicting order IDs are withheld. Nothing in this preview edits or repairs the source file.
Run it on your orders
The full Python kit.
Generate the same report from your own CSV in the supported format. Includes source code, an input template, a Quick Start guide and category settings you can edit without changing the code.
One-time digital download on Contra.
Before you buy Python 3.10+ and openpyxl are required. The kit accepts a fixed six-column order schema and USD. Categories are set in a JSON list. Stationery, Home and Accessories are the defaults.
order_id,order_date,category,quantity,unit_price,currencySaved Excel values are refreshed by rerunning the script. Arbitrary store exports and other currencies require code changes. Each row must represent one complete order.