Week of October 26

Recurring gifts now charge from Salesforce through Stripe

All 56 active recurring gifts from iMIS were moved onto Stripe, with a daily charge job, a summary email to Laurie and Bridget, and a way for donors to cancel or pause online. Gift entry gained a beta grid and a full acknowledgement template picker. Jennifer’s new giving and appeal reports went live, and 1,211 online gifts were given source codes.

56 Recurring gifts on Stripe Every active iMIS recurring gift, matched to its donor and card, $2,302.25 in scheduled amounts
1,211 Online gifts given source codes New online gifts are now coded each night as well
1,800 Online gifts set to Don’t Send Web gifts under $500 already thanked by email, cleared from the letter queue
97 Household addresses filled in Households missing an address now carry their members’ shared address
Recurring gifts

Recurring gifts moved from iMIS to Stripe

Built from the files Laurie sent on October 28. The first real charge run is Monday, November 2.

56 recurring gifts loaded

Live October 28

Every active recurring instruction from iMIS was matched to its donor in Salesforce and to the saved card in Stripe, 56 of 56: 47 monthly, 6 yearly and 3 quarterly. A job runs at 5 AM each day, charges the gifts that are due and records each one as a gift in Salesforce with its fund and source code. A declined card marks the gift Failing and is never retried until the card is updated. 30 gifts ($828.75) are due on November 2.

Recurring gift page and list views

Live October 28

Each recurring gift has its own page with charging, fund and coding, card on file and dates. Two list views, Recurring Gifts - Active and Recurring Gifts - Did Not Go Through, show what is running and what needs a new card.

Daily summary, review marker and Cancelled status

Live October 29

The charge summary email now goes to Laurie and Bridget. Recurring gifts have a Cancelled status and a Reviewed checkbox, and all 56 loaded gifts were marked Reviewed. Each gift is reserved before it is charged, which guards against charging it twice on the same day.

Donors can cancel or pause online

Live October 29

After signing in on the renewal site, a donor sees their recurring gifts and can cancel, or skip the next one to three payments. The donor gets a confirmation email and Laurie and Bridget are notified.

Member portal sign-in and manage-gift link

Live October 30

Members who share an email address with someone else now sign in to the record that holds their membership. A new link takes recurring donors straight to their gift: Manage Your Recurring Gift

Gift Entry and acknowledgements

A beta grid and every letter template in one place

The current grid is unchanged apart from the check number change below.

Gift Entry (Beta)

Live October 27

A new Gift Entry (Beta) tab is open to Bridget, Jennifer and Laurie, alongside the current grid. It has a source code default and column, an Add membership button, the acknowledgement status In Review for Signature, and the payment types Recurring Gift, Donor Advised Fund and IRA / QCD.

Acknowledgement template picker

Live October 27

All 8 letter templates, plus Automatic, can be picked for a gift in the grid. The letter follows the pick in the preview, the PDF, the email and the Word letters, single or batch. The Trails templates are shared with Bridget, Jennifer and Laurie.

Check number for more payment types

Live October 27

The current grid now takes a check number for Bequest, Matching Gift, Payroll Deduction gifts, as Bridget asked, and also for Donor Advised Fund and IRA / QCD.

Online gifts under $500 skip the letter

Live October 26

Web gifts under $500 already get an email thank-you, so they are now set to Don’t Send for the printed letter. About 1,800 earlier web gifts were updated. Web gifts of $500 or more still go to the letter queue.

Letter date and refund batches

Live October 29

Acknowledgement letters now print the date of the gift, as Bridget asked, rather than the batch date. Refunds now go into a daily refund batch, ready for Laurie to record.

Reports and data

Jennifer’s giving reports and cleaner coding

Report counts were checked against the gift records on the day they went live.

LYBUNT $500 and up

Live October 26

Households that gave $500 or more last year and nothing yet this year: 296 households, $495,532.57 given last year. A column shows the fund of each household’s last gift. The giving totals behind it were refreshed first so the list matches the gift records exactly.

Gifts entered in the last 7 and 14 days

Live October 26

Two reports of recently entered gifts, grouped by board category, with a column showing whether each came in online or by staff entry.

Appeal results

Live October 26

Appeal Results by Source Code shows dollars raised by the Trails, Summit Steward and Advocacy appeals, by source code: 395 gifts, $65,674.27. Campaign + Source Code This Year covers every campaign.

Source codes on online gifts

Live October 27

Online gifts are now given a source code each night after they are batched. 1,211 earlier online gifts were coded: 721 renewals, 398 new memberships, 79 annual fund gifts and 13 advocacy gifts. 64 were left blank where no matching code exists.

Household addresses

Done October 27

A household now keeps its address when one of its contacts is saved without one. 97 of 98 households missing an address now carry their members’ shared address. The last one has two different addresses on file and needs a check.

Portal and partners

Chapter portal, Fire Tower and Parking BOXX

Chapter portal columns and filter

Live October 27 to 29

Josh’s requests: a Member type column (October 27) and a Constituent ID column (October 28), both sortable and in the download. A New members (last 12 months) filter followed on October 29, counting first-time joins only, not rejoins.

Fire Tower completion files

Live October 29

Each Fire Tower completion form now creates a record in Salesforce with the uploaded story and stewardship files attached, and the files are emailed to the Fire Tower contacts. I’ll check the first real submission.

Parking BOXX access

Done October 27

The Parking BOXX connection now sees only the membership number, phone, type, status and expiration, and parking passes. No names, addresses or plates. The API guide and credentials went to the vendor, and test member numbers were prepared.

Digital membership card

Pilot October 27

Members can show a membership card with a QR code on the renewal site after signing in. It is open to testers only for now; ADK staff with an @adk.org address were added on October 29.

Open at week’s end

Carried into the next week

Mon Nov 2
First recurring charge run

30 gifts, $828.75, at 5 AM. I’ll check every charge, any declines and the summary email that morning.

Forms
Recurring option on the online donation form

In progress, not yet live. The saved-card step still has to be proven before it is switched on, and Laurie’s OK is needed on fund names and the authorization wording.

Laurie
Waiting on lists and wording

Department and project code lists for Sage · where the manage-gift link goes and what it says · wording for donor cancellations · cleanup of the older batches marked Ready to Post.

Letters
Advocacy acknowledgement templates and Jennifer’s next reports

The Advocacy templates are built once the final files arrive. Jennifer’s reports on letters still to be sent, tribute notifications and membership raised are next.

Earlier recap: week of October 19 · Later recap: week of November 2