Week of September 21

Online gifts now batch themselves every morning

The nightly web gift batch went live on September 25 and placed every unbatched online gift since July 30 into a daily batch on its first run. Acknowledgement letters now come from ADK’s own Word templates, with one merged file per letter type for each run. Refunds, cancelled memberships and letter names were also updated this week.

604 Web gifts batched $34,827 in 27 daily batches, July 30 to September 25, on the first run
54 Household names updated Mailing names now include the middle name and suffix. No greetings changed
18 Memberships brought current Family terms extended to the paid-through date in the iMIS dues history
8 Cancelled memberships All now excluded from renewals, renewal reports and the renewal email
Gift Entry

Batches and refunds

The three items from the September 22 call on gifts, all live in production.

Nightly web gift batch

Live September 25

Every morning at 6 AM Eastern, Salesforce groups the previous day’s online gifts into one batch for that day, dated in Eastern time and carrying a deposit reference in the “9/25/26-Online” form finance already matches against. Batches open as Open and are reviewed like a staff batch.

First run27 batches, 604 gifts, $34,827, covering July 30 to September 25. No empty batches.
Late arrivalsA gift that comes in after the run joins its own day’s batch the next morning, never a new duplicate batch.
ScheduleRuns every day, weekends included.

Refunds write an offsetting entry

Live September 22

Marking a gift Fully Refunded or Partially Refunded now creates a matching negative entry. The original gift stays as received, so the pair nets to what ADK kept and the batch total settles on its own. Each reversal links back to the gift it reverses, and that link can be reported on. Manual negative adjustments can now be saved too.

Ready to Post batch status

Live September 22

Gift batches now move through Open, In Review, Ready to Post and Posted, as Laurie asked on the call.

Acknowledgements

Letters from ADK’s own templates

Word is now the one way letters are produced, so every letter carries the real letterhead.

Letters merge into the Word templates

Live September 22

Letters are filled into the 2026 Word templates themselves, so the fonts, margins, logo and board list are exactly as designed. Each letter is saved onto the gift, which leaves a record of what each donor received. To change a letter, upload a new version onto the existing template file.

Generate Letter for the acknowledgement team

Live September 24

The letter templates are shared with the staff who send acknowledgements, so Generate Letter (Word) works for them on the gift record and the list view. On the gift record, if a letter cannot be produced the screen now says why.

One merged file per letter type

Live September 24

Bridget asked for one document to review and print. Generate Word Letters on the list view now builds one Word file per letter type, with one letter per page, each page on the full letterhead. It is saved to the user’s own Files as ADK Acknowledgement Letters with the date and count. Each gift still keeps its own copy.

One button on each screen

Live September 24

The PDF and email-a-PDF buttons were taken off the acknowledgement screens, so letters only go out on the real letterhead. Staff print or save as PDF from Word.

Middle names and suffixes on letters

Live September 25

Jennifer noticed a middle name was not showing at the household level. The household mailing name, the one that prints on letters, now includes the middle name and suffix. 54 households were updated. The greeting (“Dear …”) stays on the first name, and no greeting changed.

Membership

Renewals, terms and lookup

The cancelled-membership change follows the ruling on the September 24 call.

Cancelled means no renewal

Live September 25

A cancelled membership is now kept out of renewal: no renewal is opened against it, it no longer appears on Members ready to renew or the Membership Renewal Report, and it does not get the renewal email. Any renewal still open when a membership is cancelled is closed. Reinstating the membership puts it back in the cycle. All 8 cancelled memberships are covered. Lapsed and expired members stay in the renewal cadence, and cancelled members can still receive appeals.

Terms from zero-dollar dues rows

Done September 22

Some iMIS dues rows carry a $0 amount with a paid-through date later than the last paid row. These are now honored as a real term. 18 family memberships were extended to that date, 5 of them moving from Expired back to Active. No email went out.

Member lookup by number

Live September 22

The member lookup page has a By member no. search. It accepts the ADK number or the older iMIS number, with or without the ADK- prefix or leading zeros, so a member can read out whichever number they have.

Lapsed and expired by chapter

Live September 25

The ADK Lapsed & Expired Members by Chapter report now limits Lapsed & Expired to the last six months. Memberships with no expiration date still show, so they can be reviewed rather than dropped.

Contacts with Certifications report

Live September 21

A new report lists every contact with their certifications: 2,951 certifications held by 729 people.

Still open

Carried into the next week

As of September 25.

Batches
Daily web batches

Fill in the expected count and total automatically so each daily batch reads as balanced · add the “leave this gift out of the batch” box to the gift page · a 6 AM recap email to the donations inbox with the day’s total · name who at ADK reviews the daily batches.

Letters
Review, then mark as sent

Bridget asked to review the merged file before gifts are marked sent. Also still to do: confirm the list-view run for every user and put a download link for the merged file on the batch screen.

Sage
Project code on the gift batch

Optional four-digit project code and name, shown on the gift, separate from Fund. Waiting on the code list from Laurie.

Membership
Lapsed and expired sweep

Moving members to Lapsed and Expired by date, as Laurie asked. It will update about 9,750 memberships the first time, so it starts with a small run after hours. Helper text on the Status field will explain the two thresholds.

Mail
Communication preferences and do-not-mail

Do-not-mail comes first, ahead of the Adirondac mailing pull. The full set of preferences will follow the solicitation codes list Laurie has.

Earlier recap: week of September 14 · Later recap: week of September 28