Aung Chit Moe · Python automation portfolio

Files in. Clear reports out.

Monthly sales consolidation with a record of every accepted, rejected and duplicate row.

Synthetic demonstration. Fictitious transactions; this is a portfolio example, not client work. Revenue is quantity × unit price; taxes, discounts, refunds and FX are outside scope.
Accepted transactions20
Rejected rows9
Duplicate copies3
Revenue · USD1,987.97

Monthly revenue

2026-01
323.00
2026-02
658.50
2026-03
1,006.47

Why rows were rejected

  • Same ID, conflicting values2
  • Currency differs from report currency1
  • Ambiguous or unsupported date format1
  • Date does not exist in the calendar1
  • Value is not a valid number1
  • Required value is missing1
  • Quantity is not a valid positive whole number1
  • Price is invalid or has too many decimals1

Monthly detail

MonthRegionProductTransactionsUnitsRevenue
2026-01eastdesk lamp1375.00
2026-01eastnotebook11254.00
2026-01northnotebook1522.50
2026-01northusb cable11067.50
2026-01southdesk lamp1250.00
2026-01southusb cable1854.00
2026-02eastdesk lamp16150.00
2026-02eastusb cable118121.50
2026-02northdesk lamp14100.00
2026-02northnotebook12090.00
2026-02southdesk lamp15125.00
2026-02southnotebook11672.00
2026-03eastdesk lamp19225.00
2026-03eastusb cable124162.00
2026-03northdesk lamp17175.00
2026-03northnotebook125112.50
2026-03northorganizer1329.97
2026-03southdesk lamp18200.00
2026-03southnotebook12090.00
2026-03southpen11012.00

Reconciliation: 32 input rows = 20 accepted + 9 rejected + 3 duplicate copies. This run read 4 files. All amounts are USD.

Download Excel report · Cleaned data · Rejected rows · Run manifest