Eight checks on files you haven't cleaned yet. raw is the supplier feed exactly as it arrives (the column names have spaces and capitals), categories its category list, and members and orders the membership tables.
Write each check so it would work on next week's file: compute from the table rather than reading values off the screen.