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 14Each 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 14Donations 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 14Both 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 15A short write-up of the 2026 totals and how each line is defined, with links to both reports.
Cleaner records going forward
Everything below is live in production.
Duplicate households and contacts are flagged
Live October 15Salesforce 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.
Renewals from a second household member
Live October 15When 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 15Current 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 15Salesforce 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.
Addresses and certification dates on the rosters
Asked for by Josh on behalf of the chapters.
Mailing addresses chapter by chapter
Live October 12Each 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 13The certifications report now carries the member’s chapter, so it can be filtered by chapter.
Certification expiration dates
Live October 15Current 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 15Laurie, Josh and David are now chapter officers on all 29 chapters, with roster access, so they can open any chapter’s portal view.
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.
Still open on October 16
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.
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.
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.
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