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.
The file is read in this browser and is not uploaded.
These are matched from the header words. Check them and change any that are wrong. Donor name, gift date, and gift amount are needed; a donor id keeps two spellings of one name together.
Last year is the year before it. It starts as the latest year in the list.
Retention rates
Each percentage is the fraction beside it, rounded to one decimal place, halves rounded away from zero. A rate whose denominator is zero is shown as no rate.
Groups
Donors
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
- Every donor in the gift list is in exactly one group, and no donor who is not in the list is in any group.
- Every donor is in the group their own gift dates give. A separate routine works this out again by comparing each gift date with the first and last day of the two years, and shares no arithmetic with the routine that builds the result.
- Retained plus lapsed equals last year's donors, and first-year plus repeat equals last year's donors, each counted again from the gift list.
- Each donor's amounts for last year and this year equal that donor's rows in the gift list added up again, and each group's count and amounts equal its own donors added up.
- The dollar figures tie to the list: last year's total equals the gifts dated last year, and the groups' gifts this year add up to the gifts dated this year.
- Each rate is its own numerator over its own denominator, and its percentage is that exact fraction rounded to one decimal place. A rate whose denominator is zero is shown as no rate, never as 0% or 100%.
- The LYBUNT report on this site, run on the same list and year, passes its own checks and has exactly the same donors as given in both years (retained) and as given last year, not this year (lapsed).
- Warnings are shown when the list has no gift dated last year, none dated before last year (so every donor counts as first-year), any dated after the year, or any gift that is zero or negative.
- Every row with data is accounted for: used, listed as left out (with its row number and the reason), or listed as unreadable. An unreadable row marks the result not verified.
How it works
- 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.
- 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.
- 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.
- 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.
- 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.
| Donor | Group | Given in 2025 | Given in 2026 |
|---|---|---|---|
| Sasha Ilunga | First-year, gave again in 2026 | $75.00 | $99.50 |
| Jordan Feldspar | First-year, lapsed | $250.00 | $0.00 |
| Tatum Brennan | First-year, lapsed | $40.00 | $0.00 |
| Harper Quinlan | Repeat, gave again in 2026 | $150.00 | $200.00 |
| Morgan Abara | Repeat, gave again in 2026 | $60.00 | $80.00 |
| Rowan Delacroix | Repeat, lapsed | $500.00 | $0.00 |
| Quinn Halvorsen | Not a 2025 donor: new in 2026 | $0.00 | $25.00 |
| Reese Tanaka | Not a 2025 donor: came back in 2026 | $0.00 | $300.00 |
| Elliot Varga | Not 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.