Donors who gave more or less than last year
Open a gift list that covers two years and type the later one. Each donor who gave in both years is listed as an upgrade (gave more), the same, or a downgrade (gave less), with the difference in dollars. Donors who gave in only one of the two years have groups of their own, and one table carries last year's total to this year's, group by group.
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.
The year typed is compared with the year before it. A fiscal year is named for the calendar year it ends in: with a July start, 2026 runs from July 2025 to June 2026.
Groups
From one year's total to the next
Donors
This tool compares what the gifts in your list add up to in two years. It does not say what to do about any donor.
What gets checked
- Every donor in the gift list is in exactly one group, and the report has no donor who is not in the list.
- Every donor is in the group their own gifts give. A separate routine works this out again by comparing each gift date with the first day of each year, and shares no arithmetic with the routine that builds the report.
- Each donor's two amounts equal that donor's rows in the gift list added up again, and the change is the difference between them.
- Each group's donor count and amounts equal its own donors added up.
- The totals for the two years and for other dates each equal the gifts in the list dated then, and the three add up to the whole gift list.
- Last year's total, plus and minus each group's change, equals this year's total, with each step worked out again from the gift list.
- Every donor's change added up equals this year's gifts minus last year's gifts, so the total is reached two ways.
- For a calendar year, the LYBUNT report on the same list agrees about who gave in which year.
- Warnings are shown when either year has no gifts, when the list stops before the last month of the year, when any gift is dated after the year, and when any gift 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 the two years to compare. It is read in the browser. A workbook built from the gift log template on this site opens as it is.
- 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, punctuation, and spacing ignored.
- Choose the years. Pick the month the year starts in, January for a calendar year. The year box starts as the latest year in the list and can be changed. A fiscal year is named for the calendar year it ends in.
- Compare each donor. A donor gave in a year when the list has at least one gift from them dated in that year. Donors who gave in both years are compared on what their gifts for each year add up to, to the cent.
- Review, print, or download. The verification certificate lists every check. Print the report, or download Excel or CSV with sheets for the groups, the year-to-year steps, and the donors.
Worked example
A made-up gift list with fourteen gifts from seven donors, dated 2022 to 2025, and the year 2025 typed, so 2025 is compared with 2024.
| Donor | Group | Given in 2024 | Given in 2025 | Change |
|---|---|---|---|---|
| Avery Lindqvist | Gave more in 2025 than in 2024 | $250.00 | $400.00 | $150.00 |
| Devon Achterberg | Gave more in 2025 than in 2024 | $120.00 | $120.25 | $0.25 |
| Casey Marchetti | Gave the same in 2024 and 2025 | $75.50 | $75.50 | $0.00 |
| Blake Oyelaran | Gave less in 2025 than in 2024 | $500.00 | $200.00 | -$300.00 |
| Emery Vasquez-Holt | Gave in 2024, not in 2025 | $60.00 | $0.00 | -$60.00 |
| Finley Okonkwo | Gave in 2025, not in 2024 | $0.00 | $40.00 | $40.00 |
| Harper Nakamura | No gift in 2024 or 2025 | $0.00 | $0.00 | $0.00 |
Two donors gave more, one the same, and one less. Giving in 2024 was $1,005.50. Donors who gave more added $150.25, the donor who gave less took off $300.00, the donor with no gift in 2025 took off $60.00, and the donor new to the two years added $40.00, which gives $835.75, the gifts dated 2025 in the list.
The example uses made-up names and numbers.
Questions
What is a donor upgrade or downgrade?
An upgrade is a donor whose gifts in one year add up to more than their gifts the year before. A downgrade is a donor whose gifts add up to less. On this page both words apply only to donors with at least one gift in each of the two years.
Does one larger gift make a donor an upgrade?
No. The page compares what each donor's gifts add up to over the whole year, so three gifts of $50.00 and one gift of $150.00 count as the same.
Can the two years be fiscal years?
Yes. Choose the month the year starts in. A fiscal year is named for the calendar year it ends in, so with a July start, FY2026 runs from July 2025 to June 2026.
Can the report be run part-way through the year?
It can, and the page warns when the list stops before the last month of the year. A whole last year is then being compared with part of this one, so a donor can show as giving less, or as not giving, only because this year's gifts are not in yet.
How are reversed gifts treated?
A correction entered as a negative gift is added in as written and lowers the year it is dated in. The page warns about it and gives the row number.
Does the page say which donors to contact?
No. It compares the gifts in the list and adds up the differences. What is done with the list is up to the organization.
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.