You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

The treasurer is supposed to create a report for the club annually, and may want to understand club finances at other times to decide on raises, price increases, donation drives, etc.. We have various resources to support this.

Publicly-viewable

This page is currently public. Anything sensitive (including links to link-shared sensitive documents) should be elsewhere (or this page should get moved to the private treasury area of the wiki).


SquaresDB payment metrics

https://squaresdb.mit.edu/gate/pay-stats/ provides links to CSV files with each subscription and dance payment in the last ~two years (more specifically: since the start of the latest subscription period that started at least two years ago). There's a spreadsheet

 that generates some basic stats (average, min, max sub price, revenue breakdown by sub vs dance and payment method, etc.) from that data and could be modified to produce more stats. To update it, replace the "dances" and "subs" tabs with a fresh download of the respective CSV files from SquaresDB.

  • No labels