Giving by fund and month
Open the gift list your organization keeps: one row per gift with the donor, date, amount, and fund. The page adds the gifts up by fund and by calendar month, from the first month in the list to the last, and shows a total for every fund and every month. Each figure is then added up a second time straight from the gift list.
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; the fund column sets the rows of the table.
Giving by fund and month
This tool arranges and adds up the gifts in your list by the fund and the gift date written on each row. It does not decide which fund a gift belongs to.
What gets checked
- Every cell of the table equals the gifts in the list with that fund and that month, added up again by a separate routine that shares no arithmetic with the one that builds the table.
- Every fund total equals its own months added across, and equals that fund's gifts in the list.
- Every month total equals its funds added down, and equals that month's gifts in the list.
- The gift list, the fund totals, and the month totals all add up to the same grand total.
- Every gift falls in exactly one cell: the gift counts by fund and by month both equal the number of gifts in the list.
- There is one row for every fund in the list and no other, and the month columns run from the earliest gift to the latest with no calendar month missing or repeated. A month with no gifts is shown as zeros.
- Zero or negative gifts are added in as written and flagged as a warning with their row numbers.
- 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. 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, and the fund column sets the rows. Any choice can be changed; with no fund column every gift goes in one row.
- Total by fund and month. Each gift is placed by the fund written on its row and the calendar month of its gift date. The table has one row per fund in name order and one column per month, with a total at the end of every row and under every column.
- Review, print, or download. The verification certificate lists every check. Print the table, or download Excel or CSV; the Excel file also holds the gifts in fund and date order with their row numbers in your file.
Worked example
A made-up gift list with seven gifts to three funds during 2026. Months with no gifts (May, July, August, October, November) are zero in every row and are left out of this table to keep it narrow; the page shows all twelve.
| Fund | January | February | March | April | June | September | December | Total | Gifts |
|---|---|---|---|---|---|---|---|---|---|
| Building | $0.00 | $0.00 | $500.00 | $0.00 | $300.00 | $0.00 | $0.00 | $800.00 | 2 |
| General | $250.00 | $100.00 | $0.00 | $0.00 | $0.00 | $1,000.00 | $0.00 | $1,350.00 | 3 |
| Missions | $0.00 | $0.00 | $0.00 | $75.50 | $0.00 | $0.00 | $125.25 | $200.75 | 2 |
| Total | $250.00 | $100.00 | $500.00 | $75.50 | $300.00 | $1,000.00 | $125.25 | $2,350.75 | 7 |
Across: Building $500.00 + $300.00 = $800.00, General $250.00 + $100.00 + $1,000.00 = $1,350.00, Missions $75.50 + $125.25 = $200.75. Down, the seven months with gifts add up to $2,350.75, the same as the three fund totals and the same as the gift list. The file's own total line on row 9 is listed as left out.
The example uses made-up names and numbers.
Questions
Which gift list layouts does it read?
Any .csv or .xlsx with a header row and one row per gift. The tool does not assume one layout: it matches header words, shows its choices, and every column can be changed. When a needed column cannot be found, the page says which one and links to a form for requesting support for that format.
Which date decides the month?
The date in the column chosen as the gift date, and nothing else. A gift dated January 31 is in January and one dated February 1 is in February. The page does not move a gift to another month for any reason.
What happens to a gift with no fund?
It goes in a row named (no fund), so it is still counted and the totals still add up to the list. Fund names are used exactly as written: General and General Fund are two rows.
How is this different from the year-end giving statements page?
That page groups the same list by donor and prints one statement for each. This one ignores who gave and groups by fund and month, which is the shape of a report for a board or a finance committee, or for setting beside monthly deposits.
How are the figures checked?
A separate routine goes back to the gift list for every cell, every fund, and every month, adds with whole-number arithmetic in cents, and compares. A figure moved from one month to the next, or from one fund to another, fails a check even when the grand total still agrees.
This tool calculates and checks numbers. It is not legal, tax, or medical advice.