Boxsti.WORKING SAMPLE / FICTIONAL DATA

Three CSV files.
One checked sales report.

A small, reproducible example of mapping different column names, standardizing formats, removing exact duplicates and separating records that need review.

60Imported rows / 3 files
54Accepted sales lines
3Duplicates excluded
3Rows needing review
All customers, transactions and amounts are fictional. This is a sample workflow, not a client case study or a claim of measured time savings.
01 / Map the filesThree documented header and date formats become one consistent structure.
02 / Check the recordsRequired fields, dates, quantities, SKUs and currency are validated. Exceptions stay visible.
03 / Prepare the reportAccepted rows feed the sales totals. Every row retains its source filename and row number.

Accepted sales: USD 18,488.00

1,074 units across 54 accepted sales lines. Sales = quantity × unit price; taxes, discounts and shipping are outside this demo.

RegionUnitsSales / USD
North365$6,199.50
South358$6,289.75
Online351$5,998.75

Clean output / first eight rows

OrderDateFictional customerProductUnitsSales / USD
S-10012026-10-01Cedar Cafe (Demo)Pantry boxes8$100.00
S-10022026-10-02Birch Bakery (Demo)Paper cups15$131.25
S-10032026-10-03Oak Catering (Demo)Cleaning kits22$528.00
S-10042026-10-04Willow Bistro (Demo)Napkin packs29$478.50
S-10052026-10-05Harbor Deli (Demo)Paper bags11$101.75
S-10062026-10-06Maple Kitchen (Demo)Serving trays18$576.00
S-10072026-10-07Cedar Cafe (Demo)Pantry boxes25$312.50
S-10082026-10-08Birch Bakery (Demo)Paper cups32$280.00

Exceptions / nothing silently filled in

Source fileCSV rowOrderStatusReason
branch_north.csv20S-1002DuplicateExact normalized duplicate of branch_north.csv:3
branch_north.csv21R-1ReviewMissing customer
branch_south.csv20S-1020DuplicateExact normalized duplicate of branch_south.csv:3
branch_south.csv21R-2ReviewMissing or invalid positive whole quantity
online_orders.csv20S-1038DuplicateExact normalized duplicate of online_orders.csv:3
online_orders.csv21R-3ReviewInvalid date; expected %d-%m-%Y

Download clean CSV · Download exception list · Download Excel report