October challenge board
Dirty Data Lab™ · Challenge 03
Hard
Thursday, October 8 · 20–30 minutesInvoice Reconciliation
A finance export mixes dates, currency strings, credits in parentheses and repeated invoices. Your total is wrong until every field agrees.
The assignment
Cleanup rules
There is one finished state. Use the rules to get the board there.
- Trim IDs and remove repeated invoice_id records.
- Normalize invoice_date and due_date to YYYY-MM-DD.
- Convert currency text to signed decimals. Parentheses mean a negative amount.
- Normalize status to Paid, Open or Void.
- Sort by invoice_id ascending.
- After cleanup, calculate the total amount for Open invoices only.
Loading the puzzle board…
Loading your Lab profile…
Pass the puzzle
Send this one to a friend.
The friend link carries Dirty Data Lab™ referral attribution, so referred signups can be measured separately from newsletter and ad traffic.
Take the habit into Google Sheets
Practice here. Preflight real sheets with CTS Guard.
Clean That Sheet Guard checks the active Google Sheet for duplicates, missing data, formatting issues and other handoff problems before you share or import it.