Week of October 19

Older gifts now carry their batch and campaign

Gifts brought over from iMIS now show the gift batch and campaign they came in on, and their fund amounts match the gift. Most duplicate gifts and duplicate renewal memberships were cleared out. Online forms now offer to cover the card fee, and the renewal thank-you goes to the person who renewed.

958 Duplicate gifts removed $116,429.38 of gifts recorded twice across 2024 to 2026
38,683 Older gifts given their batch Across 3,835 iMIS batches recreated in Salesforce
1,676 Fund amounts corrected Older gifts whose fund lines added up to more than the gift
268 Duplicate renewals merged Staff-entered renewals folded into the existing membership
Gift history

Older gifts read correctly

Each change below was checked with totals before and after. No emails went out.

Gift batches for iMIS gifts

Done October 22

The old iMIS batches now exist as Gift Batch records, marked Posted. 38,683 gifts are linked to their batch, so batched gifts went from 2,720 to 41,403. Every older gift that has an iMIS batch number now shows its batch. The gift count and total did not change (44,147 gifts, $5,991,146.17). These batches are never picked up by the Sage export.

Campaigns for iMIS appeal codes

Done October 22

2,847 gifts with an appeal code but no campaign are now linked. Where the code matched an existing campaign, the gift went there. The rest sit under a new parent campaign, iMIS Appeals (no campaign), with one child campaign per appeal code. Every gift with an appeal code now has a campaign.

Fund amounts on older gifts

Done October 22

1,676 gifts from 2024 and 2025 had a fund line larger than the gift itself. The iMIS records confirmed the gift amount, so each fund line now equals its gift. Fund totals came down by $376,809.46. The figures sent for the Board meeting were not affected.

Duplicate gifts

Done October 19

958 gifts ($116,429.38) that repeated the same donor’s gifts on the same day were removed. 41 that need a closer look were left in place. A large 2025 estate gift was also corrected to $266,771.56 on October 21. 2025 gifts in Salesforce now total $2,196,376.59.

Membership

Renewals land on one membership

Live October 21 and 22.

Renewal thank-you goes to the renewer

Live October 21

When a spouse or other household member renews, the “Thank you for renewing” email now goes to that person and greets them by name. A new Renewed By field on the membership shows who renewed. If the primary member renews, or the renewer has no email, the primary gets it as before.

Duplicate renewal memberships merged

Done October 21

278 renewals entered as a second membership were folded into the member’s existing one: 10 by hand, then 268 more ($15,490 of dues). Each membership now has its new expiration and exactly one open 2027 renewal. Staff renewals now fold based on the date of the dues gift.

Gift grid after a merge

Live October 22

If a membership is merged after a gift is entered, the grid now moves the gift row to the remaining membership. A deleted gift or merged donor shows a plain message. On October 21 a batch from October 9 was balanced, 32 of 32 lines.

Forms, reports and portal

Card fees, Board reports and the chapter roster

Cover the card fee

Live October 21

The Join, Renew and Donate forms now have a checkbox to cover the 3% card fee. The forms show the total that will be charged. When a member covers the fee, next year’s renewal still asks for the dues alone.

Reports for the Board meeting

Live October 19

New and Reactivated Donors 2026 lists donors with a 2026 gift and none in 2024 or 2025, split into Private Donations, Membership and Public Grants: 2,914 donors, 3,376 gifts, $313,413.29 when checked. Gifts by Fund This Year opens on Unrestricted Donations and can be switched to any fund.

Primary chapter on the leadership roster

Live October 22

Chapter leaders now see a Primary chapter Yes/No column for each member, can sort on it, and get it in the CSV download. A hard refresh shows it if the page was already open.

Duplicate rule guide

Done October 20

Laurie has a workbook showing what flags a duplicate household or contact, and how to merge them.

As of October 23

Carried into the next week

Forms
Card fee: live test and label wording

A test join and donation with the fee ticked, then refunded, and the final wording of the fee label.

Reports
Donations listed before Membership

On New and Reactivated Donors 2026, the order flips so Private Donations and Public Grants show first and are not cut off by the long Membership list. Built and tested, not yet live.

Campaigns
The Campaigns tab on Account and Contact

Older gifts now link to campaigns, but the Campaigns tab on a donor’s page lists campaign members, which were never loaded. Adding them from the gifts is the next step.

Membership
Remaining duplicate memberships

111 still open: 98 that need a person to look at them, starting with 25 possible double payments, and 13 waiting on a final check. One member may have paid twice.

Next
Also in progress

Nightly Sage export with Skyfin · auto-renewal test through Stripe · the gift membership form · “Send a note to the family” on tribute gifts · the rest of the 2025 gift total against the reconciled file.

Earlier recap: week of October 12 · Later recap: week of October 26