Week of October 5

The 2024 to 2026 gift history is updated from the revised import file

Laurie’s revised gift file for January 2024 to May 2026 and the June and July files were applied to the matching gifts in Salesforce, and exact duplicate gifts were removed. Online renewals now keep the member’s anniversary date, and the chapter portal now shows the same members as the chapter reports. Grants picked up confidence, deliverables and processed amounts.

27,644 Gifts matched to the file January 2024 to May 2026 gifts now carrying the file’s campaign, source code, batch and designation
2,198 Duplicate gifts removed Exact copies of a gift already matched to the file
3,184 Duplicate memberships removed So the online renewal form finds one membership for those members
2,420 Member statuses filled in Active members whose contact status was blank, so they show on chapter rosters
Gift data

Imported gifts updated from the files

Amounts did not change. Where the file had a different gift date, the file’s date was used, and gifts with no donor picked up their household. Every gift was checked against the file after the update.

January 2024 to May 2026 file

Done October 5

27,644 gifts now carry the campaign, source code, batch and designation from the revised file. Each gift’s fund follows its designation. The designation “Summit Stewardship” is now named Advocacy Program Donations, as in the file.

Exact duplicates removed

Done October 5

2,198 gifts that were exact copies (same donor, date and amount) of a gift already matched to the file were removed. None had a batch, receipt, soft credit, membership or payment attached. Gifts in that period went from 41,795 to 39,597.

June and July files

Done October 6

2,641 gifts from the June (May 29 to June 30) and July (July 1 to August 7, plus HPIC) files now carry the file’s campaign, source code, batch and designation. “Member Retension” was recorded as Member Retention, and six source codes from the files were added to Salesforce.

Gift Entry

Gift entry grid and batches

Open grids need a browser refresh to pick up the change.

Gifts saved before a batch is picked

Live October 6

Gifts saved before a batch is selected now stay on screen and join the batch as soon as one is picked, so nothing needs to be re-keyed. A warning shows while no batch is selected, and the batch picker shows the batch number first, then the deposit reference.

Two batches rebuilt

Done October 6

The four credit card gifts from the evening of October 5 ($215) and the three checks dated August 21 ($190) are each in their own batch, and both batches balance.

Covered processing fee

Live October 8

A Covered Processing Fee checkbox is on every gift, next to Amount. The “Yes, I’ll cover the 3% processing fee” option is on the online forms, hidden until the fee calculation is tested.

Membership

Renewals, staff and household addresses

Online renewals keep the anniversary date

Live October 8

A renewal paid up to 60 days after expiration now extends from the original expiration date: a membership that expired September 30, 2026 and was renewed October 3 runs to September 30, 2027. Early renewals are never shortened. Renewals more than 60 days late start from the month of payment. The payment, the renewal opportunity and the thank-you email all show the corrected date.

October 9: 21 earlier online renewals and 7 dues payments were moved to the correct expiration. No emails were sent.

Paid renewals recorded, duplicates removed

Done October 9

19 paid online renewals are now recorded, each with its new expiration. 3,184 duplicate memberships were removed, so the renewal form finds a single membership for those members. No emails were sent.

Staff checkbox

Live October 8

A Staff checkbox is on every contact. Staff are left out of the Mailchimp sync, though an unsubscribe from a staff member still goes through. 43 staff contacts are marked.

Household addresses

Done October 6

680 households created from the web forms now carry their contact’s mailing address. A change to a contact’s mailing address now updates the household, and a change to a household’s address updates its contacts.

Chapter portal and reports

Rosters match the chapter reports

All live October 8.

Same members as the reports

Live October 8

The portal roster now uses the same rule as the chapter reports, so a chapter’s roster count equals its report count. 2,420 active members whose contact status was blank were filled in, and new members now get their status and Member Since date automatically. Member since is now a column on the roster.

Certification level and next level

Live October 8

Each member’s certification level and what they need for the next level now show in the roster, with a sort and two new columns in the download.

Certifications in chapter reports

Live October 8

A new Certifications by Chapter report lists certification holders for any chapter. All 28 chapter reports gained Certification Level, Next Level and Certifications Held columns, filled for 686 certification holders.

Grants

More on the grant record

Live October 8.

Confidence30%, 60% or 90%. Net Projected Amount is the award (or the request until an award is entered) times Confidence, and 0 when declined or withdrawn.
DeliverablesNarrative, Budget and Photos checkboxes, at every stage.
ProcessedProcessed Amount and Date fill from the grant’s gifts once they are in a gift batch. Refunds are subtracted; pledges and in-kind gifts are not counted.
ReportsReports Outstanding counts by each requirement’s status. Setting a requirement to Submitted ticks its Submitted box.
Close-outA grant can be withdrawn or declined straight from Awarded. The old Status field and the empty Application Forms list are no longer on the grant page.
Carried into the next week

Still open on October 9

Forms
3% processing fee calculation

When the option is ticked, the card is charged the gift plus 3%. The option stays hidden until tested.

Forms
Renewal form lookup and chapter labels

Narrowing how the renewal form finds a membership. Adding the town to chapter names on the join and renew forms once Laurie’s list arrives.

Gift Entry
Find Batch search and alternatives to the grid

Search batches by date, number or deposit reference, newest first, with Add Row and Save at the bottom. Two other ways to enter gifts are being compared.

Data
Duplicate alerts and merging

Duplicate alerts for households and contacts, with step-by-step merge instructions. Built and tested, not yet live.

Next
Household addresses and planned giving

New web-form households picking up the address automatically · the planned giving build, once the layout arrives.

Earlier recap: week of September 28 · Later recap: week of October 12