Softwiro
Free Excel template

Donation Tracker Spreadsheet for Nonprofits (Excel)

A free Excel donation tracker for a small nonprofit, charity, school or club. You keep two lists: your donors, and your gifts. Each gift records the date, the donor, the fund or campaign it was for, the amount, how it was paid and whether you have thanked the donor. From those two lists the sheet works out each donor's total, first and latest gift, level and whether they have lapsed, how far every campaign is toward its goal, and what you raised each month. It opens in Excel, LibreOffice and Google Sheets, and it works in any currency.

Excel file (.xlsx) · 109 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
Year shown2026As of46342Amounts in $. Change year, date, goal and levels on Settings.
Raised this year16,955.00Donor level (all time)Donors
Annual goal50,000.00Major5
Share of goal raised33.9%Mid-level3
Gifts this year34Small6
Average gift this year498.68No gifts yet1
Donors giving this year14Major from 1000, Mid-level from 250
New donors this year14
Repeat donors (2+ gifts, all time)11
Lapsed donors2
Thank-yous still to send8
Gifts needing a fix (Check column)0
MonthRaisedGiftsNew donorsCumulative
Jan0.00000.00
Feb250.0011250.00
Mar5,120.00225,370.00
Apr75.00115,445.00
May0.00005,445.00
Jun1,500.00116,945.00
Jul0.00006,945.00
Aug0.00006,945.00
Sep400.00117,345.00
Oct5,020.0013712,365.00
Nov4,590.0015116,955.00
Dec0.000016,955.00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: The year's total raised, your annual goal and the share reached, gifts, average gift, donors giving, new, repeat and lapsed donors, thank-yous still to send and gifts that need a fix. Four charts: money raised by month, the running total for the year, raised against goal by fund, and raised by payment method. A small table counts donors by level.
  • Donations: One row per gift: date, donor ID, fund, amount, payment method, receipt number and whether the thank-you has gone out. It adds the donor's name and a Check column for missing amounts, unknown donor IDs and unlisted funds. Room for 600 gifts.
  • Donors: One row per donor with ID, name, email and type. It fills in the number of gifts, total given, given this year, average gift, first and latest gift, days since the latest gift, level (Major, Mid-level or Small) and status (Active, Lapsed or No gifts yet). Room for 150 donors.
  • Funds: Each fund or campaign with its goal and dates. It shows what has been raised, the number of gifts, the average gift, the share of goal, what is left to raise, days left, the amount needed per day to reach the goal, and a status such as Goal met or Ended short.
  • Settings: Organization name, currency symbol, the year to report on, today's date, the annual goal, the number of days after which a donor counts as lapsed, the two level thresholds, and your lists of payment methods and donor types.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most donation spreadsheets are a list of gifts with a total at the bottom. This one also tells you who to thank, who has gone quiet, and what a campaign still needs per day to reach its goal, so the spreadsheet drives your follow-up and not only your records. Anonymous gifts are supported: leave the donor ID empty. The sample is a small food bank with gifts dated through October and November 2026, so every sheet shows real numbers before you replace them with yours.

What should a donation tracker spreadsheet include?

At minimum: a unique donor ID, a name and a way to contact the donor, and for each gift the date, amount, payment method and the campaign or fund it was meant for. This template adds a receipt number and a thank-you flag because follow-up is where small organizations most often fall behind. Keep the columns few: every extra column is something a person has to fill in by hand on every gift.

Keep donors and gifts in two lists linked by the donor ID, and do not retype a donor's name on every gift. Change a name once on the Donors sheet and every gift shows it. Do not store card numbers or bank details in the file.

How do I track progress toward a fundraising goal in Excel?

Give every campaign a goal and an end date on the Funds sheet and pick the campaign from the dropdown on each gift. The sheet adds the gifts for each fund and divides by the goal. In the sample the Holiday Meals Appeal has raised 3,945.00 of its 25,000.00 goal (15.8%), leaving 21,055.00 to raise in 38 days, which is 554.08 a day. The Youth Literacy Program, whose end date has passed, reached 5,120.00 against 5,000.00 and shows Goal met.

Set your annual goal on Settings and the Dashboard shows the share reached. In the sample, 16,955.00 from 34 gifts is 33.9% of a 50,000.00 goal. The running-total chart shows whether you are on pace.

How do I find lapsed donors?

A donor is lapsed when their latest gift is older than the number of days you choose on Settings (180 in the sample) counted back from the as-of date. Two sample donors show as Lapsed. Filter the Donors sheet on Status to build your follow-up list, and thank them for their past gifts before asking for a new one.

The right number of days depends on your giving cycle. A donor who gives once a year is not lapsed after six months, so set 365 or more. Whether and how you may contact people is a matter for your local rules; check them. For event budgets see the project budget tracker and for day-to-day cash the cash book template.

How to use it

  1. On the Settings sheet type your organization name, currency symbol, the year to report on, today's date (the "as of" date), your annual goal, and the amounts that make a donor Major or Mid-level. Edit the payment methods and donor types if yours differ.
  2. On the Funds sheet list each fund or campaign with its goal and dates. Leave the goal empty for an ongoing fund such as a general fund.
  3. On the Donors sheet give each donor an ID (D001, D002...), a name, an email and a type. Their gifts, totals, level and status fill in by themselves.
  4. On the Donations sheet log each gift: date, donor ID, fund, amount, payment method and receipt number. Leave the donor ID empty for an anonymous gift. Mark Thank-you sent as Yes once you have thanked the donor.
  5. Open Funds to see how close each campaign is to its goal and how much is needed per day to reach it.
  6. Open Dashboard for the year so far: money raised, gifts, new and lapsed donors, thank-yous pending, and four charts.

Before you start:

  • Capacity: 600 donations, 150 donors and 20 funds. When the log is full, save a copy and start a new year's file with your donors list.
  • Keep only what you need about donors. Names and emails are enough; do not store card numbers or bank details in this file.
  • Log gifts in any order. The sheet finds each donor's first and latest gift by date.
  • "New donors" counts donors whose first gift in this file falls in that month. If you start the file part-way through your history, earlier donors will show as new.
  • A donor is Lapsed when their latest gift is more than the number of days on Settings before the as-of date. Change that number to suit your giving cycle.
  • Whether a gift is tax-deductible, and what a receipt must say, depends on where you are: check your local rules. The Receipt no. column is only your own reference.
  • The Dashboard fund chart shows the first 8 funds and the method chart the first 6 payment methods on your lists. Use one currency in one workbook.

Excel file (.xlsx) · 109 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Is this donation tracker really free?

Yes. Download it, use it for your organization and change anything you like. Nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

How many gifts and donors can it hold?

600 gifts, 150 donors and 20 funds. When the log is full, save a copy and start a new file for the next year, keeping your donors list.

Can I record anonymous gifts?

Yes. Leave the donor ID empty and the gift is counted in every total as Anonymous. It simply does not belong to any donor's record.

Does it produce tax receipts?

No. It records a receipt number so you can match your own receipts to gifts. What a receipt must contain and whether gifts are deductible depends on where you are, so check your local rules.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Charities and donations

More free templates

All templates · Free tools