Membership

Current Information

This document has been temporarily hijacked. Becoming a member is not a very clear process either online or at the space. For now, this document seeks to help alleviate that.

Our current membership page on the AHA web site is available at: http://www.allhandsactive.org/membership/

Things that need doing

1. Make it clear how to become a member at AHA
2. Make it clear how to become a member online
3. When someone intiates an automated payment via paypal, they should:
   1. Be taken to a page thanking them + include details on:
      1. What forms need to be filled (This is now happening)
         1. That they can pick these forms up at the shop as well
      2. What they should do with these forms once they are filled out
      3. Who they can contact for more information
      4. When they can expect keys/code/etc.
   2. A notification to whoever handles membership needs to be sent
   3. Receive an automated email detailing the same as above
4. When someone makes a payment at AHA via cash / check / credit
   1. The same information needs to be relayed as if they had paid online
   2. A notification to whoever handles membership needs to be sent
5. Make sure our membership information is up to date and consistent across
   1. AHA Website
   2. Google Drive
   3. Wiki
   4. Print material at shop
   5. Board, Staff mental banks
6. Assemble a wiki page that covers the process of becoming a member from start to finish
   1. From the perspective of AHA as an organization
   2. From the perspective of a potential new member
7. Checklist for when someone is getting their key / code
   1. Digital Copy of Welcome Card located on AHA local network: \\aha-control\shared\dropbox\Official AHA Stuff\Labels & General Notices\New Member Welcome Card\
   2. Physical Copy of Welcome Cards are in the AHA Admin Locker #33
   3. Who has what Key / Code: Kept on Private Google Members Doc (Current AHA Shop Directors w/Google Accounts can access + Josh Williams + Jamie Finerman)
      1. Someone needs to walk through this with the new member. They should check off each item as it is covered

Updating the Member List

The member list can be viewed here, this is not public as it includes payment, codes, etc.

How to update this?

Get payment information from Squareup.com

1. Log into Squareup.com with our allhandsactive@gmail.com account
2. Click on "Sales"
3. Click on "Transactions"
4. Change the time period to the previous month, or as long as it takes to get back to the last point we updated member data
5. Click on "Export" and choose "Transactions"
   1. Download this to a file on your computer, but please remember to delete it after.
6. Open the file in your favorite spreadsheet software.
7. Sort the spreadsheet by the column "Description"
   1. Find 301 and 301 - Membership payments. Ideally all member payments submitted through square should include the name of the person who the membership is for, and the month they are paying for.
   2. If not, you will have to email the list to try and figure this out.
8. Entering in the information for when someone paid for membership according to the square spreadsheet, into the AHA Members Spreadsheet:
   1. In the Google AHA Members Spreadsheet, add a column for the month you are recording payments for. There is a good chance this column is already there.
   2. Feel free to "Hide" columns if they are for a month over 2 months prior.
9. Make sure you add:
   1. Date they paid
   2. The month they are paying for
   3. Make sure your initials are in the first column for every row you edit.

Get payment information from Paypal.com

1. Log into our paypal account with the allhandsactive@gmail.com account
2. Click on "History"
3. Select "Download History"
4. Change the date range to the last 45 days, or whatever it takes to get to the point we last updated membership data
5. File type "Comma Delimited - All Activity"
6. Select "Include Shopping Cart details"
7. Click "Download History" button!
8. Open CSV file in your favorite spreadsheet software.
9. Sort the spreadsheet by the column "Item Title"
   1. Find the "Membership" items.
   2. Most people pay either $20 (Reduced) or $50 (Standard). One or two people pay $25. Consider them "Reduced"
   3. Backyard Brains Pays approx. $20 p/person, they have a lot!
10. Entering in the information for when someone paid for membership according to the paypal spreadsheet, into the AHA Members Spreadsheet:
    1. In the Google AHA Members Spreadsheet, if necessary add a column for the month you are recording payments for. There is a good chance this column is already there.
    2. Feel free to "Hide" columns if they are for a month over 2 months prior.
11. Make sure you add:
    1. Date they paid
    2. The month they are paying for
    3. Make sure your initials are in the first column for every row you edit.