The Lapsed Member Report lists those memberships that have become lapsed prior to the date specified on the General tab of the report parameters. If the membership was renewed after the date specified on this report, the membership will still show up on this report. It does not include those memberships that lapsed but were then renewed on or before the report date.

The report prints the total number of memberships.



For example, Tricia has a membership that expired on 01/15/2005 but was renewed on 2/15/2005. If the Lapsed On or Before date is set to 1/31/2005, this membership prints because the report takes into account any membership that lapsed within that time period. However, if the Lapsed On or Before date is set to 2/28/2005, this membership does not print because it was renewed within the date range specified on the report.




To print the report:

    • Click Reports, Membership Reports

    • Select Lapsed Member Report and click New

    • Go through each tab and fill out the appropriate parameters
    • Click Print or Preview


      The report prints the following information:


      • Member name - This is determined by the options selected on the Format tab, Name Formats. It is the for the primary member.
      • Membership - This column can show the program, category, and subcategory for the membership being displayed. This is selected on the Format tab, Detail. At least one of the three must be selected.
      • Date Expired - the date lapsed


      The following information can be optionally included on the report by selecting the Format tab, Detail.


        • Maiden names
        • Joint member names


        The following columns can be optionally included on the report by selecting the Format tab, Optional Columns. Only two optional columns may be selected.


          • Current Standing
          • Given by
          • No. children - It is calculated by totaling the Total number of children on this membership field on the Other Members and Card Information button of the membership record.
          • No. members - It is calculated by totaling the Total number of members on this membership field on the Other Members and Card Information button of the membership record.
          • Spouse Name