Crunch Retention · Upload roster

Drop the month's two ABC exports exactly as they come out: Active Member Detail and Inactive Member Detail. Both are needed; last month's cancellations are read from the Inactive file. They are sent in pieces (compressed in your browser when it can be), joined into one roster, then checked: columns, row counts, clubs, duplicates, and how the month compares to the previous one. Nothing is scored until the checks pass.

Roster month (an export pulled on Sep 30 or Oct 1 is the October roster) Upload token Active export (.csv), or one file that already holds both Inactive export (.csv) Upload and check

Month	Rows	Active	Inactive	Clubs	Pending cancel	Uploaded	Checks