Thank-You Tracker: Donor Gift Log & Acknowledgment Receipt Letters

$24.00

Instant download. Files: spreadsheet (.xlsx, made for Excel or Google Sheets; tested in LibreOffice only), PDF guide, gift-log import columns, optional Google Sheets script (UNTESTED). Secure checkout; your download link appears right after payment and is emailed to you.

Every gift deserves a thank-you. Some gifts also need one by law. Thank-You Tracker is a simple gift log for small nonprofits, churches and ministries. It shows you which gifts need a written acknowledgment, when each one is due and which ones you’ve already sent. It also fills in a printable receipt letter for you.

Under IRS Publication 1771, a donor cannot deduct a single contribution of $250 or more without a contemporaneous written acknowledgment from the charity. A written disclosure statement is required for payments over $75 made partly for goods or services. [1] Thank-You Tracker flags both kinds of gift automatically. Its receipt letter includes the elements Publication 1771 lists: your organization’s name, the cash amount or a description of donated property (without a value), and the correct goods-or-services statement. [1][2]

No subscription and no donor database to learn. It’s your own spreadsheet.

Features:

  • Gift log with dropdowns: date, donor, email, address, gift type, cash amount or property description
  • Automatic $250+ and quid pro quo >$75 flags, with each acknowledgment marked REQUIRED or Recommended [1]
  • A thank-you “due by” date based on your own standard (for example, 14 days), with a status column: Due, Overdue, OVERDUE (required), Sent
  • An IRS timing note on required acknowledgments (Pub 1771 says charities typically send them by January 31 of the following year) [1]
  • Printable receipt letter: pick a Gift ID and the letter fills in, including “no goods or services were provided”, a good-faith value of goods or services with the limited deductible amount, or “intangible religious benefits only” [1]
  • Year-end giving statement: pick a donor and a year to get one printable summary of their gifts (Pub 1771 allows one annual summary to cover several gifts) [1]
  • Dashboard: gifts, cash, $250+ count, acknowledgments sent, required-but-unsent, overdue, plus a month-by-month table
  • Optional Google Sheets script to save the receipt as a PDF and email it from your Gmail. UNTESTED, provided as-is
  • Made for Excel, Google Sheets and LibreOffice (tested by the maker in LibreOffice only)

What’s included:

  • Thank-You-Tracker.xlsx (6 tabs: Start Here, Settings, Gifts, Receipt, Year-End Statement, Dashboard; 1,000 gift rows)
  • Thank-You-Tracker-Guide.pdf (3-page quick-start guide with an IRS rules summary)
  • OPEN-IN-GOOGLE-SHEETS.txt and Gift-Log-import-columns.csv
  • ThankYouTracker-AppsScript-UNTESTED.txt (optional email helper, untested)

Digital download; nothing is shipped. This is a record-keeping template, not tax or legal advice. It does not cover vehicles, appraised property or other special cases (see Pub 1771 and Pub 526). Not affiliated with or endorsed by the IRS. The optional email script is untested. Sample rows are fictional examples. Licensed for use within your own organization.

Sources for claims: [1] IRS Publication 1771 (Rev. 11-2023): https://www.irs.gov/pub/irs-pdf/p1771.pdf. [2] IRS, “Charitable contributions: Written acknowledgments”: https://www.irs.gov/charities-non-profits/charitable-organizations/charitable-contributions-written-acknowledgments.

Reviews

There are no reviews yet.

Be the first to review “Thank-You Tracker: Donor Gift Log & Acknowledgment Receipt Letters”

Your email address will not be published. Required fields are marked *