← Projects

Bill Bench

Exhibit NO. 006

Turn messy bills into a month-end workbook.

For month-end review: three inconsistent exports become five sheets, with every row traceable. For a similar classification workflow with email instead of bills, see Headersort.

125 sample rows accounted for: 114 retained, 3 duplicates, 8 incomplete.

Explore project Source
Raw export to categorised billsSynthetic sample · seed 42

Source export

CAD
DEMO UTILITY 02A:6$1,453.94
demo software 03 A:71182.26
Demo-Lease-04A:8CAD 549.36
Normalise · categorise · trace

Categorised bills

CAD
Demo Utility 02Utilities1,453.94
Demo Software 03Software1,182.26
Demo Lease 04Rent549.36

3 of 125 sample rows · A:6–8 in the source workbook.