Skip to content
The title slide and first slides of the Noncash Donation Log template

Noncash Donation Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (5)

Overview

Anyone who clears out a closet, a garage or a house uses this log to keep a record of goods given to charity. The Donations tab holds one row per group of items with the charity, category, condition, count and value for one item, and it multiplies them for you. The Charities tab lists each group with its tax ID and eligibility check, and counts drop-offs and gift value for each. The Dashboard shows value by category and by condition.

Write the entry the day you drop off, while you remember what was in the bags. Choose a condition honestly, since fair market value depends on it. Ask for a written receipt each time and mark the status so missing ones show in red. Keep photos and any price guide you used. Review the list with a tax professional, because gifts of higher value come with extra rules.

Useful for

  • Keep a dated list of everything given away during a move
  • Compare giving by category and by charity
  • Show a tax professional values, conditions and receipts together

What's included

  • 4 tabs: Dashboard, Donations, Charities, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Donations: a table
  • Charities: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Donations tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What should I keep for noncash donations?

Keep a receipt from the charity, a list of the items with their condition, how you found each value and the date you gave. Photos help with larger items. This log holds the list and shows which receipts are missing.

How do I value donated clothes and furniture?

Use the fair market value, which is what a buyer would pay for the item in its condition. Thrift-shop price lists and the prices of similar sold items are common references. Note your source in the item description and check IRS guidance.

Do I need an appraisal for a large donation?

Gifts above certain values can need extra forms or a written appraisal, and the IRS sets the limits and may change them. Read the current rules, or consult a preparer, before you give something valuable.

  • #tax-tracker
  • #noncash-donation-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…