1. A family purchased too many memberships.
   
2. A contact was granted a membership by an Admin that is not associated with an order.
   
3. A contact has an order for a membership that has an outstanding balance.
   

Scenario #1 - There are more Members than the number of Orders for membership.

Ex) The Dashboard reports 406 Members, but the Form only shows 171 Orders.

1. Go to Store & Forms / Reports / Membership SKU Catalog Report.  This will show you the number of memberships granted by each active membership SKU.
   

1. Next, go to the Form Summary for the Membership Form. (Store & Forms / Forms / Membership Form / blue "summary" button next to the form.) 
   
2. Be sure to set the date range to include all membership sales from this form. Otherwise, it defaults to the current year dates and won't capture sales prior to the beginning of the current system year (e.g. spring sales prior to a current year beginning July 1) if there were any.
   
3. The Form Summary will show the number of each SKU that was purchased from the Membership Form.
   
4. If you add the numbers together, they should equal the number of members. (be sure to double the numbers that count for two memberships and omit any numbers that belong to a SKU that doesn't grant membership.)
   
5. If these numbers match, then your memberships numbers are accurate. If these numbers do not match, then proceed to Scenario #2.
   

Scenario #2 - The number of Members shown on the Dashboard is higher than the number of memberships purchased on the form.

Ex) The Dashboard shows 406 Members, but the Membership Form Summary total only indicates there should be 404 Members.

1. Check for Cancelled Orders for membership (Store & Forms / Orders.) Enter the date range and select "Cancelled Orders."
   
2. From this list, open any cancelled orders to see if membership was purchased on the order.
   
3. If so, check the contact record to see if the person is still showing as a member. Cancelling an order does NOT remove membership status - this has to be done manually after the order is cancelled.
   

1. Check the Ordered Items Report (Store & Forms / Reports / Ordered Items.)  Enter the date range memberships were sold and filter for only membership SKUs.
   
2. If you add the number of each SKU purchased (be sure to double the numbers that count for two memberships) and it matches your Dashboard number, a membership SKU was purchased but not tagged to the form.
   
3. To resolve, you can click on the blue number in the Qty column to view a list of who purchased each SKU. You can compare these names with the names on your Form Report to find which memberships are missing from the form.
   

1. If the Ordered Items Report number still doesn't match the Dashboard number, then either
   
1. an Admin granted a manual membership and did not create an actual order for the membership
   
2. or students are tagged as members when they shouldn't be. 
   
2. The best way to check for this is compare your Membership Form Report to your Contact List.
   
3. Download your Membership Form Report to excel - detail (Store & Forms / Forms / blue Report button) and sort by last name.
   

1. Then go to People / Contacts. Filter for all statuses and membership types.
   
2. Scroll down the list of contacts and look for people that have the membership icon next to their name, but that are not listed as members on the form report. This will indicate those that were tagged as members without purchasing memberships.
   

1. To check to be sure students aren't being marked as members if you're not tracking/offering student memberships, go to People / Students / filter for Student Members. This is a good report to glance through to help find discrepancies.
   
2. If a student is listed as a member, you can check the orders on the contact record to see if the membership was purchased as an "extra" or see if there is no record of a purchase and the student was tagged manually.
   

Scenario #3 - The number of Members shown on the Dashboard is lower than the number of memberships purchased on the form.

Ex) The Dashboard shows 653 Members but the Membership Form Summary Report shows 660 memberships purchased.

1. membership orders that are not paid (the system only grants membership after payment is complete).
   
2. or if a person purchased too many memberships.
   

1. Go to Store & Forms / Reports / Fulfillment Worksheet (This will only work if your membership SKUs have been set up as Deliverable.}
   
2. If they have not, you can set them that way by going to Store & Forms / Catalog / select the SKU / Sales Information tab.
   
3. Set the date range and filter for the membership SKUs,
   
4. Scroll down to look for orders that were not paid and have a balance due.
   
5. In this example, there are 5. These 5 memberships won't show up in your membership numbers or on your accounting since they are not paid.  660 - 5 = 655, which is still 2 more than the number of memberships shown on the Dashboard.
   

1. Using the same Fulfillment report, customize the sort to be by primary contact name.
   
2. Then scroll down and look for people who purchased more than one membership - their name will appear twice.
   
3. If they purchased more than one membership, there may be an extra membership that did not get applied to a person, depending how many people are listed on their contact record. The system tags purchased memberships first to the primary person, then to the secondary, then to students.
   
4. In this example, someone bought a total of 4 memberships, but only 2 people are listed on the contact record. So only 2 of the 4 memberships purchased are being applied.  655 pd members - 2 pd members = 653 members as shown on the Dashboard (the numbers balance.)