Skip to content

LYBUNT and SYBUNT calculator

LYBUNT (last year but unfortunately not this year) donors gave last fiscal year but not yet this one. SYBUNT (some year but unfortunately not this year) donors gave in an earlier year, not last year or this year. Add a gift export to count both lists, total what they gave, and compare retention with the Fundraising Effectiveness Project’s 2025 figures.

What are LYBUNT and SYBUNT?

Two lists of past donors who have not given this fiscal year, split by how long they have been away. Together they cover every lapsed donor in your file.

LYBUNT: last year but unfortunately not this year

A donor who gave in your last fiscal year and has not given so far in the current one. With a fiscal year that starts in July, a donor who gave in March 2026 and not since July 1 is a LYBUNT donor.

SYBUNT: some year but unfortunately not this year

A donor who gave in an earlier fiscal year, but not last year and not so far this year. A donor whose last gift came two or more fiscal years ago is a SYBUNT donor.

LYBUNT and SYBUNT compared
LYBUNTSYBUNT
Stands forLast year but unfortunately not this yearSome year but unfortunately not this year
Last giftLast fiscal yearTwo or more fiscal years ago
First moveA renewal ask before the fiscal year endsA reactivation appeal

Some donor databases count LYBUNT donors inside SYBUNT. This calculator keeps the two lists apart, so every lapsed donor appears on exactly one of them.

How this calculator counts

The same rules run on every file, and the same file always gives the same numbers. Nothing is estimated or forecast.

The benchmarks come from the Fundraising Effectiveness Project’s 2025 data. FEP reports calendar years and pools nonprofits that each receive between $5,000 and $25 million in gifts a year.How to calculate donor retention, with FEP’s tables.

  1. A donor is one value of the donor column (an ID, an email or a name). The calculator does not merge two IDs for one person.
  2. Refunds and adjustments net against the donor’s total for the fiscal year of the refund’s date. A donor counts as giving in a year only when that net total is above zero.
  3. Fiscal years are named by the year they end in, so July 2025 to June 2026 is FY2026. The current year is the fiscal year that contains the as-of date. Gifts after the as-of date are not counted.
  4. LYBUNT: gave last fiscal year and has not given so far this fiscal year.
  5. SYBUNT: gave in an earlier fiscal year, but not last year and not so far this year. Some donor databases count LYBUNT donors inside SYBUNT; this calculator keeps the two lists apart.
  6. Retention rate: donors who gave two fiscal years ago and gave again last year, divided by all donors who gave two fiscal years ago. It shows only when the file covers both full years. A file whose first gift falls in the first 31 days of a year counts as covering that year.
  7. Renewed so far: donors who gave last year and have given again this year, divided by all of last year’s donors.
  8. First-time and repeat: a first-time donor in the base year (two fiscal years ago) has no earlier gift in the file. First-time means first gift in your file, not first gift ever.
  9. Gift-size bands use FEP’s ranges and the donor’s total for the year. A total of exactly $5,000 counts as Midsize and exactly $50,000 as Supersize.
  10. Likely recurring donors who stopped: three or more gifts of mostly the same amount in the 12 months up to the last gift, spaced a steady 25 to 100 days apart; a last gift in the past two years; and no gift since for more than 1.5 times the usual gap plus 15 days. A gift file has no plan record, so the list comes from the gift pattern: check each donor’s plan. With a recurring column mapped, only the marked gifts count: two are enough, and the same-amount and gap tests are dropped.

What to do with each list

LYBUNT: renew before the year ends

These donors gave last year, so a renewal ask is still timely. Start at the top of the downloaded list: the largest gift-size band first, then the donors with the most years in a row. For a loyal donor, a short personal note reads better than a second copy of the general appeal.

SYBUNT: give them a reason to return

These donors have been away for a year or more. Send a reactivation appeal that thanks them for what they made possible and shows what has happened since. Check addresses before you mail.

Recurring donors who stopped: act fast

A recurring gift can stop because a card expired or a bank account changed. Check each plan in your donor database, contact the donor soon after the missed gift, and make it easy to restart.

A step-by-step guide to keeping more donors

A gift export is a snapshot.

In Ignite, LYBUNT and SYBUNT are ready-made segments that refresh daily, and the rule behind each one is visible. The Retention agent works your live donor data to assess lapse risk, recommend recovery moves for interrupted recurring gifts, and rank which donors need attention now. It proposes the move and shows the evidence.

Questions about LYBUNT, SYBUNT and the calculator.

What does LYBUNT mean in fundraising?

LYBUNT stands for "last year but unfortunately not this year." A LYBUNT donor gave in your last fiscal year and has not given so far in the current one. These donors are usually your best renewal list: they gave recently, and many gave in earlier years too. Work the list before your fiscal year ends, starting with the largest donors and the ones who gave the most years in a row.

What does SYBUNT mean in fundraising?

SYBUNT stands for "some year but unfortunately not this year." A SYBUNT donor gave in an earlier fiscal year, but not last year and not so far this year. They have been away longer than LYBUNT donors, so they usually need a reason to come back, such as a reactivation appeal that thanks them for their past support.

Does the calculator upload my donor file?

No. Your browser reads the file on your computer and does the counting there. Nothing from the file is sent to StratusLIVE or anyone else, and the tool area is masked from our session recordings. If you fill in the form to unlock the downloads, we receive your contact details and the totals shown on the page, never a donor row.

Read the data privacy policy

What file does the calculator need?

A CSV file with one row per gift and at least three columns: a donor ID (or an email or a name), the gift date, and the amount. Most donor databases can export a gift list like this from a report or a query. If your export is an Excel file, save the sheet as CSV first. The sample file shows the format.

Why do my counts differ from my donor database’s LYBUNT report?

Definitions vary. Some systems count LYBUNT donors inside SYBUNT, some use the calendar year instead of your fiscal year, and some leave out soft credits or count pledges. This calculator counts every readable gift row up to the as-of date, nets refunds, keeps the two lists apart, and does not merge two IDs for one person. Check the fiscal year start and the as-of date first: they explain most differences.

How does the calculator find recurring donors who stopped?

A gift file has no record of a recurring plan, so the calculator looks for the pattern: three or more gifts within a year, mostly of the same amount, at a typical gap of 25 to 100 days, and then a pause longer than 1.5 times that gap plus 15 days. It does not assume a monthly schedule. If your file has a column that marks recurring gifts, map it and the calculator uses that column instead.

Where do the benchmarks come from?

From the Fundraising Effectiveness Project’s 2025 data, which pools 7.8 million donors at 15,102 nonprofits that each receive between $5,000 and $25 million in gifts a year. FEP reports calendar years, so the comparison is closest when your fiscal year starts in January. Our retention guide explains the formula and FEP’s tables.

Read the retention guide

What do I get when I fill in the form?

The full LYBUNT and SYBUNT lists and the list of likely recurring donors who stopped, as CSV files ready for a mail merge, and a board summary as a Word document and a print view. The results and the top 25 rows of each list stay free without the form. Someone on our team may follow up about your results and about Ignite. You can opt out at any time.