Week of October 12

Duplicate checking is on and the 2026 revenue reports are live

This week Salesforce started flagging duplicate households and contacts, and two new reports split 2026 giving into public, membership and donations, and by program. Chapter rosters now show certification expiration dates. Online renewals from a second household member now extend the household membership and send the renewal email.

$1,473,536 2026 giving by sector Public $232,341 · Membership $502,100 · Donations $739,094, as of October 14
4 Duplicate rules switched on Two for households and two for contacts. They flag and report, and never block a save
62 Recently expired certifications Lapsed in the last 90 days, now shown in red on the chapter rosters
29 Chapters with staff access Laurie, Josh and David added to every chapter roster, including inactive chapters
Reports

2026 revenue by sector and by program

Built for Jennifer ahead of the October 15 budget meeting. The totals were checked against the gift records.

Revenue by Sector This Year

Live October 14

Each 2026 gift is classed as Public (a government agency, or a nonprofit passing through federal, state or municipal money) or Private. Private is then split into Membership (Membership Dues, plus card fees covered on memberships) and Donations (every other fund). The report is net of refunds.

Donations by Program This Year

Live October 14

Donations are grouped by program, with Summit Stewardship shown separately from Trails. Older funds with no program tag were matched by name, so no donation is left unassigned. The program lines add up to the Donations total.

Gift lines and donor names on both reports

Live October 14

Both reports now show each gift line with its primary contact, not only the totals. Six test households ($327 in all) are filtered out, so the figures cover real gifts only.

2026 write-up for Jennifer

Sent October 15

A short write-up of the 2026 totals and how each line is defined, with links to both reports.

Membership and data

Cleaner records going forward

Everything below is live in production.

Duplicate households and contacts are flagged

Live October 15

Salesforce now flags a possible duplicate when two households share a name and ZIP code or the same couple’s names, and when two contacts share a name and ZIP code or a name and email. Saving is never blocked, so web forms keep working.

OrderMerge the households first, then the contacts. A contact merge across two different households is refused with a reminder to merge the households first.
After a mergeThe household’s giving totals are recalculated and its chapters are tidied up.

Renewals from a second household member

Live October 15

When someone renews online for a household whose membership is in another member’s name, the payment now moves onto the existing household membership, which is extended and sends the “Thank you for renewing” email. The renewal stays on one membership and sends the renewal email, not a welcome. The renewal Laurie reported was corrected the same day.

“New Member” tag in Mailchimp

Live October 15

Current members who joined in the last six months now carry a New Member tag in Mailchimp, from the nightly sync. The tag drops off after six months. It covers joins entered by hand as well as online joins, and the Mailchimp automation can now be built on it.

Annual parking passes

Live October 15

Salesforce has a new Parking Pass record: the member, plate, start and end dates, and Active or Cancelled. Eight staff with membership access can add and edit passes. A read-only Salesforce login was set up for the Parking BOXX gate system, and its sign-in was tested.

Chapter leadership portal

Addresses and certification dates on the rosters

Asked for by Josh on behalf of the chapters.

Mailing addresses chapter by chapter

Live October 12

Each chapter record has a Show Mailing Addresses In Portal box. When it is ticked, that chapter’s leaders see addresses on the roster and in the download. Glens Falls-Saratoga was switched on October 13. The roster also has a new Has certifications button.

Chapter column on the certifications report

Live October 13

The certifications report now carries the member’s chapter, so it can be filtered by chapter.

Certification expiration dates

Live October 15

Current certifications show “(expires MM/DD/YYYY)”. An expanded member row lists anything that lapsed in the last 90 days in red, and renewed certifications drop off that list. The download has a new Recently Expired Certifications column, and the roster search covers it.

Staff on every chapter

Done October 15

Laurie, Josh and David are now chapter officers on all 29 chapters, with roster access, so they can open any chapter’s portal view.

Acknowledgements

Cleaner thank-you letters

Live October 15.

The four new Unrestricted letters Jennifer sent are loaded, with their review comments removed. Letters skip the organization line when a gift has none, and optional phrases leave no extra space when empty. Donor names and addresses are printed exactly as they are recorded.

Carried into the next week

Still open on October 16

Grid
Gift entry grid: Find batch search, and staff feedback

The Find batch box searches by batch date, batch number or deposit reference. It was built and tested, and was waiting to go live. Bridget’s requests were being gathered into one list with any others: an “In Review for Signature” acknowledgement status, four more payment methods and a notes field.

Forms
Join form birthdate, the 3% fee option and Apple Pay

A birthdate check that shows the format and corrects or stops bad entries was built on test copies of the two Join forms for review, not yet on the live forms. Salesforce already handles covered fees on renewals, and the checkbox still had to be added to the forms. The Apple Pay donation form was still in Stripe test mode for Laurie to try.

Gift memberships
Gift memberships: the donor gets the gift, the recipient gets the membership

The proposed setup was being prepared for Laurie’s comment. Two questions were open before the build: who is asked at the first renewal, and whether the buyer’s payment counts as dues or a donation.

Next
Auto-renewal test, Sage export and the merge guide

An end-to-end test of a card auto-renewal on renewal day · the daily batch export for Skyfin’s Sage imports · a list for Laurie of what sets off each duplicate rule, so she can bring up a merge when needed · Parking BOXX credentials to the vendor.

Earlier recap: week of October 5 · Later recap: week of October 19