Mathproven

Donor retention rate from a gift list

Open a gift list that covers this year and last year and type the year. The page counts last year's donors and how many of them gave again this year (retained) or did not (lapsed), splits them into first-year donors (first gift in the list dated last year) and repeat donors (they also gave before last year), and sets what the retained donors gave this year against what all of last year's donors gave last year. Each rate is shown as its two counts and the percentage.

The gift list is read in your browser and stays on this device. Nothing is uploaded.

Donors who gave last yearFirst-year, gave againFirst-year, lapsedRepeat, gave againRepeat, lapsedRetained plus lapsed equals last year
Last year's donors, each in exactly one group.
1. Gift list

The file is read in this browser and is not uploaded.

This tool counts donors by the dates of the gifts in your list and adds up what each gave. It does not compare a rate with any outside figure or say what to do about any donor.

What gets checked

Your numbersThe mathThe checksVerifiedNot verified
A result that fails a check is marked not verified. It is never shown as correct.

How it works

  1. Open the gift list. Drop a .csv or .xlsx file with one row per gift, covering at least this year and last year. Gifts from earlier years tell first-year donors from repeat donors. It is read in the browser.
  2. Check the column mapping. Columns are matched from the header words. Donor name, gift date, and gift amount are needed. With a donor id, gifts are grouped by the id; without one, by the name with case, accents, punctuation, and spacing ignored, the same rule the LYBUNT report uses.
  3. Type the year. The year box starts as the latest year in the list and can be changed. Last year is the year before it.
  4. Read the four rates. Donor retention is last year's donors who gave again this year over all of last year's donors. First-year retention is the same for donors whose first gift in the list is dated last year; repeat retention for donors who also gave before last year. Dollar retention is what the retained donors gave this year over what all of last year's donors gave last year. Each percentage is rounded to one decimal place, halves rounded away from zero.
  5. Review, print, or download. The verification certificate lists every check. Print the result, or download Excel or CSV with sheets for the rates, the groups, and the donors.

Worked example

A made-up gift list with seventeen gifts from nine donors, dated 2023 to 2026, and the year 2026 typed. Last year is 2025.

DonorGroupGiven in 2025Given in 2026
Sasha IlungaFirst-year, gave again in 2026$75.00$99.50
Jordan FeldsparFirst-year, lapsed$250.00$0.00
Tatum BrennanFirst-year, lapsed$40.00$0.00
Harper QuinlanRepeat, gave again in 2026$150.00$200.00
Morgan AbaraRepeat, gave again in 2026$60.00$80.00
Rowan DelacroixRepeat, lapsed$500.00$0.00
Quinn HalvorsenNot a 2025 donor: new in 2026$0.00$25.00
Reese TanakaNot a 2025 donor: came back in 2026$0.00$300.00
Elliot VargaNot a 2025 donor: no gift in 2025 or 2026$0.00$0.00

Six donors gave in 2025: three retained and three lapsed. Donor retention is 3 / 6 = 50.0%. Of the three first-year donors, one gave again: 1 / 3 = 33.3%. Of the three repeat donors, two did: 2 / 3 = 66.7%. The retained donors gave $200.00 + $99.50 + $80.00 = $379.50 in 2026, against $1,075.00 given by all six in 2025, so dollar retention is $379.50 / $1,075.00 = 35.3%. Tatum Brennan's gift on December 31, 2025 counts in 2025. The three donors who were not 2025 donors are in no rate.

The example uses made-up names and numbers.

Questions

What is the donor retention rate?

The number of last year's donors who gave again this year, divided by the number of donors who gave last year. A donor gave in a year when the list has at least one gift row for them dated from January 1 to December 31 of that year. New donors this year and donors who came back after a year without a gift are in neither number.

What is the difference between first-year and repeat retention?

First-year retention counts only last year's donors whose first gift in the list is dated last year. Repeat retention counts only last year's donors who also gave before last year. The two groups together are all of last year's donors, so first-year plus repeat always equals the donor retention denominator. A list that starts last year has no repeat donors, and the page warns about it.

How is dollar retention worked out?

What the retained donors gave this year, divided by what all of last year's donors gave last year, both added in whole cents from the list. It can be above 100% when retained donors gave more this year than all of last year's donors gave last year.

What does the page show when there were no donors last year?

It shows the rate as no donors last year, with its counts of 0 over 0, rather than 0% or 100%. The same applies to first-year or repeat retention when that group is empty, and to dollar retention when last year's gifts add up to zero or less.

How are refunds and negative gifts handled?

The same way as on the LYBUNT report: a gift row entered as a negative amount still counts as a gift in its year and is added in as written, so it can lower the dollar figures. The page warns about it with the row number.

Does the page say whether a rate is good or bad?

No. It counts and adds from the gift list and shows each rate with its numerator and denominator. It does not compare the rate with any outside figure or say what to do about it.

Why is one donor counted twice?

Two spellings of one name are two donors when the list has no donor id and the names differ by more than case, accents, punctuation, or spacing. The donor de-duplication page finds donor entries with the same name, the same email, or the same address so they can be merged first.

This tool calculates and checks numbers. It is not legal, tax, or medical advice.

Template updates by email

At most four emails a year, when the free templates and rate tables for nonprofits and churches are updated for a new quarter. Each has a one-click unsubscribe link.

Only the address typed here is sent, never anything from a file opened on this page. Nothing is added until the link in the confirm email is opened. Mathproven is a product of OpenSlot LLC, PO Box 96, Paintsville, KY 41240, USA. Privacy.