Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesNonprofit & CommunityFundraising & DonorsDonor Database

SpreadsheetFundraising & DonorsFree

Donor Database

Track every donor and gift, with lifetime giving, LYBUNT and SYBUNT flags, giving levels and a suggested next ask.

Shown with sample data

Colour

Donor Database

Track every donor and gift, with lifetime giving, LYBUNT and SYBUNT flags, giving levels and a suggested next ask.

Raised this fiscal year
$15,325
Donor retention
67%
Last year’s donors who gave again
LYBUNT donors
2
Call before year end
LYBUNT dollars at risk
$5,500
Active donors this year
6
Gifts logged
18
Average gift
$2,251
Thank-yous overdue
1
Giving this fiscal year by donor
  • Harborview Community Foundation$12,500
  • Margaret & Alan Okafor$1,500
  • Grace Fellowship Church$800
  • Linda Park$200
  • Priya Nair$200
  • Elena Vasquez$125
Raised by appeal
  • Grant$22,500
  • Year-end appeal$12,800
  • Major gift visit$4,000
  • Online giving$725
  • Spring gala$300
  • Monthly giving$200

How to use it

  1. 1Set the first day of your fiscal year on the Settings sheet (January 1 or July 1 for most organisations).
  2. 2List each donor once on the Donors sheet, spelled exactly as you will type them on the Gifts sheet.
  3. 3Log every gift on the Gifts sheet the day it arrives, with fund, appeal and method, and mark the thank-you when it is sent.
  4. 4Work the Donors sheet by status: call LYBUNT donors first, then SYBUNT, then upgrade Current donors with the Next ask amount.
  5. 5Adjust the giving levels on the Levels sheet to match your own recognition circles.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A free donor database that works like the reports in paid CRMs. Log each gift once on the Gifts sheet and every donor’s record updates itself: lifetime giving, last gift date, this year and last year, a LYBUNT or SYBUNT flag for lapsed donors, a giving level and a suggested next ask amount. Retention rate and dollars at risk sit at the top, so you know who to call before year end.

Who it’s for

  • Small shops not ready for a paid CRM
  • Year-end renewal calls to LYBUNT donors
  • Board reports on donor retention and giving levels

What’s included

  • Donors sheet: One row per donor, updated automatically from the Gifts sheet.
  • Gifts sheet: Every gift received, one row per gift.
  • By appeal sheet: Raised and the number of entries for each appeal.
  • Levels sheet: Giving levels, highest first, based on a donor’s best of this or last fiscal year.
  • Settings sheet: Fiscal year and ask rules.

How to use it

  1. 1Set the first day of your fiscal year on the Settings sheet (January 1 or July 1 for most organisations).
  2. 2List each donor once on the Donors sheet, spelled exactly as you will type them on the Gifts sheet.
  3. 3Log every gift on the Gifts sheet the day it arrives, with fund, appeal and method, and mark the thank-you when it is sent.
  4. 4Work the Donors sheet by status: call LYBUNT donors first, then SYBUNT, then upgrade Current donors with the Next ask amount.
  5. 5Adjust the giving levels on the Levels sheet to match your own recognition circles.

Tips

  • LYBUNT donors (gave Last Year But Unfortunately Not This year) are the cheapest money you will ever raise. A personal call or note before the fiscal year closes recovers a large share of them.
  • Thank every donor within 48 hours. The Gifts sheet flags any thank-you that is overdue.
  • Use one spelling per donor. "Margaret & Alan Okafor" and "The Okafors" will count as two donors.
  • Retention matters more than acquisition: the sector average is only around 40–45%, so every point you add is real money.

Questions

What do LYBUNT and SYBUNT mean?

LYBUNT is a donor who gave Last Year But Unfortunately Not This year. SYBUNT gave Some Year But Unfortunately Not This year (and not last year either). Both are lapsed donors worth a renewal ask, LYBUNTs most urgently.

How is donor retention calculated?

Donors who gave last fiscal year and again this fiscal year, divided by all donors who gave last fiscal year. The KPI at the top of the Donors sheet does this for you.

How is the next ask amount worked out?

Current and new donors are asked to upgrade: their best year so far plus the increase on the Settings sheet (15% by default), rounded to the nearest $25. LYBUNT donors are asked to renew at last year’s total, SYBUNT donors at their largest single gift, and prospects at the first-ask amount.

When should we move to a real CRM?

Usually once you pass 1,000 active donors, run several appeals at once or need online giving to sync automatically. This sheet exports cleanly to CSV for import when you are ready.

Related searchesdonor database templatedonor tracking spreadsheetlybunt sybunt reportdonor management excelnonprofit donor listdonor retention

Details

Format
Spreadsheet
Category
Fundraising & Donors
Sheets
5
Setup
20 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFundraising & DonorsFree

Donor Database

Track every donor and gift, with lifetime giving, LYBUNT and SYBUNT flags, giving levels and a suggested next ask.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Fundraising & Donors
Sheets
5
Setup
20 min
Level
Intermediate
Price
Free

Your copy is private to you.

More fundraising & donors templates

View all

Organization Name Street Address · City, State ZIP · Phone · Website Tax ID (EIN): 00-0000000 · Organization Name is a tax-exempt organization under Section 501(c)(3) of the Internal Revenue Code.

Date

Re: Thank you for your gift of $500.00 received on November 12, 2026

Dear Ms. Okafor,

Thank you for your generous gift of $500.00 to Organization Name. Because of you, twelve children in our Reading Bridges after-school program will have a trained tutor beside them twice a week this winter, the kind

This is your fifth year standing with our students, and your loyalty means more than we can say. Gifts like yours are what keep our doors open on the afternoons when children need us most.

DocumentFundraising & Donors

Donation Acknowledgment Letter

A warm thank-you letter that doubles as a tax receipt, with a gift table and the goods-and-services statement donors need.

10 min setupPreview

Grant Proposal: Reading Bridges After-School Literacy Program

ApplicantRiverside Youth Alliance
Tax ID (EIN)00-0000000
ContactMaya Torres, Director of De

1. Executive Summary

Riverside Youth Alliance requests $45,000 to expand Reading Bridges, our after-school literacy program, from two to three elementary schools in East Riverside. In 2027, Reading Bridges will give 120 strugglin

2. Organization Background and Capacity

Founded in 2009, Riverside Youth Alliance serves 1,400 young people a year through mentoring, tutoring and summer learning. Our annual budget is $1.2 million and we employ 14 staff and 160 volunteers.

  • •Track record: Since 2021, 86% of Reading Bridges students have gained at lea
  • •Partnerships: We hold data-sharing agreements with Riverside Unified School Dis
  • •Leadership: Program Director Andre Wallace is a former reading specialist with
DocumentFundraising & Donors

Grant Proposal

A complete, funder-ready proposal: need statement, SMART objectives, methods, evaluation, budget table, narrative and sustainability.

45 min setupPreview
Nonprofit Budget5 sheets

Total expenses

$963,500

Program expense ratio

72%

Admin ratio

14%

Expenses by function
72%
  • Program services
  • Fundraising
  • Management & general
SpreadsheetFundraising & Donors

Nonprofit Budget

An annual operating budget with program, management and fundraising split, restricted funds, revenue mix and key ratios.

30 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ