Your Cart
Loading

Year-End Charitable Giving & Tax Receipt System 2026 — Donation Log & Receipt Tracker Excel + Guide

On Sale
$29.00
$29.00
Added to cart

Giving Tuesday is Tuesday, December 1, 2026, and every donation must be made by December 31, 2026 to count for tax year 2026. If you give to many charities, the hard part is not the giving — it is finding every receipt when you file in early 2027.


This system fixes that. Log each gift in under a minute. The workbook flags every gift of $250 or more that needs a written acknowledgment from the charity, tracks which receipts you hold and which are missing, and totals your giving per charity and against your budget — all with live formulas.


WHAT YOU GET

- year-end-giving-tax-system.xlsx — a working Excel workbook with real formulas. No macros. Works in Microsoft Excel and Google Sheets.

- year-end-giving-tax-system-guide.pdf — a 3-page printable guide: setup, sheet-by-sheet help, the $250 acknowledgment rule in plain words, key 2026–2027 dates, and receipt habits that work.


THE FIVE SHEETS

1. Start Here — two yellow input cells: your annual giving budget and tax year 2026. Quick answers (total given, budget left, donations, missing receipts, largest gift) update on the same page.

2. Donation Log — one row per gift: date, charity, category, amount, method, receipt received Y/N, plus a formula column that flags any single gift of $250 or more: YES — written acknowledgment needed.

3. Receipt Checklist — mirrors the Log by formula, so there is nothing to retype. Each gift shows Received — file it, or MISSING — follow up now, with a live missing-receipt count (COUNTIF) and a follow-up action per row.

4. Charity Summary — SUMIF totals per charity, COUNTIF gift counts, and formula columns for each charity's % of total given and % of budget, plus a check total that must match the Log.

5. Year-End Summary — one dashboard: budget, total given, % of budget given, budget left, number of donations, receipts still missing, largest gift, average gift, count of gifts at $250 or more, number of charities, and a filing status line. All cells are live formulas.


SAMPLE PRE-LOADED: $3,000 budget, tax year 2026 → 12 donations totalling $2,610.00, $390.00 of budget left, 10 charities, largest gift $500.00, average gift $217.50, 5 gifts at $250 or more, and 3 receipts still missing so you can see the flags work. Delete the sample rows and type your own gifts.


WHY NOT A PRINTABLE? A printable log cannot flag the $250 rule, cannot count your missing receipts, and cannot total your giving per charity. This workbook does all three as you type.


Instant download (.xlsx + .pdf). Digital product — no physical item ships. Personal use.


DISCLAIMER: This is a general record-keeping tool only. It does not give personalized tax advice and does not tell you what you may deduct. General rules are cited to IRS Publication 526, IRS Publication 1771, and Internal Revenue Code Section 170(f)(8). Check those sources, or ask a qualified tax professional, for your own case.

You will get the following files:
  • XLSX (13KB)
  • PDF (8KB)