How to Track Household Donations with a Spreadsheet or Printable Template

How to set up a simple donation tracker in Google Sheets, Excel or on paper: what to record, how to keep receipts with it, and how to plan drop-offs, pickups and family handovers.

11 min readDecluttering and donation planning4 viewsHow to Track Household Donations with a Spreadsheet or Printable Template
— · 0 votes
Contents
  1. What is a donation tracker?
  2. What should you record in a charitable donation tracking spreadsheet?
  3. How detailed should the item list be?
  4. How do you track cash and noncash contributions?
  5. Spreadsheet or printable template: which donation tracker suits your household?
  6. How to set up a free donation tracker template step by step
  7. Useful tabs for a household donation log
  8. How does a donation tracker help with drop-off planning and appointments?
  9. Keeping questions for the charity in one place
  10. Recording family handovers before donating
  11. How to keep donation receipts with your tracker
  12. How do you keep a donation log useful over time?
  13. When should you share your donation tracker?
  14. Donation tracker ideas for everyday situations

A household donation tracker is one list where you record what you gave away, to which charity, on which date and with which receipt. You can keep it in Google Sheets, Excel or a printed template. The same list can also hold pickup appointments, questions for the charity and notes about items promised to family, so nothing has to live only in your head. Seven columns are enough to start: date, charity name, donated items, cash or noncash, estimated value if you need one, receipt status, and notes.

What is a donation tracker?

A donation tracker, also called a donation log or charitable giving tracker, is a running record of the gifts a household makes to charities and community groups. It covers both cash and noncash contributions, from a monthly gift to a food bank to a box of outgrown children's clothes taken to a charity shop.

Decluttering usually happens in small batches spread over weeks or months. Without a record, these questions are hard to answer later:

  • Did the winter coats go to the shelter, or are they still in the car?
  • Where is the receipt from the furniture pickup in March?
  • Did we already offer Grandma's sewing machine to a cousin before donating it?
  • Which charity said it doesn't accept mattresses or car seats?

A tracker answers these in seconds. It also gives you a tidy summary at the end of the year if you need one for your records or your tax paperwork.

What should you record in a charitable donation tracking spreadsheet?

Record enough to identify each donation and find its receipt later, and no more. A short, consistent entry beats a detailed one you stop filling in. The table below lists useful columns with an example row for each.

ColumnWhat to enterExample
Donation dateThe day the items left your home or the payment went through14 Sept 2026
Charity nameThe organisation's full name, plus the branch or location if it has severalRiverside Family Shelter, Elm Street drop-off
TypeCash (including card or bank transfer) or noncash (goods)Noncash
Donated itemsA short description, grouped by category2 bags women's clothing, 1 box kitchenware
ConditionA quick note such as new, good or fairGood, all washed
Amount or estimated valueThe cash amount, or an estimated value for goods if you need oneLeft blank, or your own estimate
ReceiptReceived, requested or none, plus where it is storedPaper receipt in Donations folder
NotesAnything you might want to know laterStaff said they need towels in winter

If you use the log only for decluttering, you can drop the value column. If you may claim donations on a tax return, keep it, and check your country's official guidance or a tax professional on how to value used goods and what proof you need. The rules differ between countries and can depend on the size of the gift.

How detailed should the item list be?

Describe donated items in a way you would recognise a year from now. For everyday clothing and household goods, category and quantity are usually enough, for example "3 bags of children's clothes, sizes 4–6". For single items of higher value, such as a sofa, a laptop or a bicycle, add a brief description and, if you like, a photo reference such as "photo saved 14 Sept".

How do you track cash and noncash contributions?

Keep cash and noncash contributions in the same tracker, but mark each entry with a type so you can filter them apart. They need different evidence:

  • Cash contributions include cash, cheques, card payments, bank transfers and recurring online gifts. Your bank statement shows the payment, and the charity's acknowledgement or email receipt confirms it went to them. Record the amount and how you paid.
  • Noncash contributions are goods such as clothes, toys, books, furniture and appliances. The proof is usually a receipt or drop-off slip from the charity, often with the value left blank for you to complete. Record what you gave and its condition.

For recurring gifts, one line per month keeps the list easy to read. You can also use one line per year with a note such as "£10 monthly, January–December" if your statements already show each payment.

Spreadsheet or printable template: which donation tracker suits your household?

The best donation tracker template is the one your household will actually open. Choose by who needs to see it and where you will be when you add entries.

FormatWorks well whenThings to keep in mind
Donation tracker in Google SheetsSeveral family members add entries, often from a phone at the drop-off pointNeeds an account and internet access for full use. Share it only with people you trust.
Donation tracker template in ExcelOne person manages the records on a home computer and likes sorting and totalsSharing depends on where the file is saved. Keep a backup.
Printable templateYou prefer paper, are clearing a relative's home without a laptop, or want a sheet on the fridgeNo automatic totals. Keep it in a folder with the receipts, and consider typing it up at year end.

Many households combine the formats. A printed sheet sits in the hallway beside the donation box, and once a month someone copies the entries into the spreadsheet.

How to set up a free donation tracker template step by step

You do not need to buy or download anything to create a free donation tracker template. A blank spreadsheet or a ruled page is enough. These steps work in Google Sheets, Excel or most other spreadsheet apps.

  1. Create a new file and name it clearly, for example "Household Donations 2026".
  2. Add the column headings in the first row: Date, Charity name, Type, Donated items, Condition, Amount or value, Receipt, Notes.
  3. Freeze the top row so the headings stay visible as the list grows.
  4. Add a drop-down for Type with two options, Cash and Noncash, so entries stay consistent. Use the data validation feature in your spreadsheet app.
  5. Add a drop-down for Receipt with options such as Received, Requested and None.
  6. Enter one past donation as a test, ideally something you gave recently and still remember clearly.
  7. Add a simple total under the Amount or value column if you want a yearly figure, using the SUM function.
  8. Save it where you will find it: pinned on your phone, bookmarked, or printed and placed in a labelled folder.

For a printable template, draw the same columns on a page in landscape orientation, leave generous row height for handwriting, and print a few copies at once.

Useful tabs for a household donation log

One tab is enough for most households. If you are decluttering a whole home or handling a family move, a few extra tabs keep related information together:

  • Donations: the main log described above.
  • To donate: items waiting to go, with the intended charity.
  • Charities: names, addresses, opening hours, what each accepts and refuses, and the contact name for pickups.
  • Family and friends: items offered to relatives, who said yes, and when they will collect.
  • Questions: things you still need to check before giving something away.

How does a donation tracker help with drop-off planning and appointments?

A donation tracker turns scattered reminders into one calm list. Instead of sticky notes, text messages and half-remembered phone calls, the next step for every bag and box sits in one place.

Drop-off planning works smoothly with a "To donate" tab containing these columns: Item or bag, Charity, Plan (drop-off or pickup), Appointment date and time, Status. Some everyday examples:

  • A furniture pickup: "Dining table and 4 chairs, Community Furniture Project, pickup booked Tuesday 10:00–12:00, leave by garage door, confirmation number in Notes."
  • A combined errand: "Books to library sale and clothes to charity shop, both on Saturday morning, same street."
  • A seasonal drive: "Warm coats for winter appeal, school collection closes Friday."

When an item leaves the house, move it from "To donate" to the main log and add the date and receipt status. The list then shows only what is still waiting.

Keeping questions for the charity in one place

Note questions as they come up so you can ask them all in one call or visit. Typical questions include:

  • Do you accept electrical items, mattresses, children's car seats or opened toiletries?
  • Do you collect large items, and how far ahead should we book?
  • Will you provide a receipt, and will you fill in the value or leave that to us?
  • Are there items you particularly need at the moment?

Write the answer next to each question with the date you asked. Charities change what they accept, so a dated answer shows how current the information is.

Recording family handovers before donating

Family handovers often come before charity donations, especially when clearing a parent's home or downsizing. A "Family and friends" tab with columns for Item, Offered to, Date offered, Answer, and Collection date helps avoid misunderstandings, for example:

  • "Dad's toolbox, offered to Sam on 2 Oct, yes, collecting at half-term."
  • "Wedding china, offered to all three siblings on 2 Oct, no replies yet, decide by 1 Nov, then donate."

A gentle deadline written into the tracker lets everyone see when an unclaimed item will move on to a charity, without anyone having to chase.

How to keep donation receipts with your tracker

Keep donation receipts in one place and note that place in the tracker. Then your records and your proof always match. Two simple systems work well:

  1. Paper: one folder or envelope per year, labelled "Donations 2026". Put each receipt in on the day you get it and tick Received in the log.
  2. Digital: photograph or scan each paper receipt and save it to a folder with a clear file name such as "2026-09-14 Riverside Shelter.jpg". Save email receipts in a dedicated email folder or label.

If you leave a drop-off point without a receipt, mark it as Requested and add a reminder to ask next time. Some unattended donation bins provide no receipt at all. Note "None, donation bin" so you know the gap is expected.

How do you keep a donation log useful over time?

A donation log stays useful when updating it takes less than a minute and happens at a predictable moment. These habits help:

  • Log at the moment of giving. Add the entry from your phone in the car park, or drop the paper slip into the folder as soon as you get home.
  • Do a short monthly check. Look for missing receipts, items that have sat in "To donate" for weeks, and unanswered questions.
  • Start a new tab or sheet each year so annual totals and receipts stay separate.
  • Keep descriptions consistent. Use the same category words, such as clothing, books, toys, kitchen and furniture, so filtering works.
  • Forgive the gaps. If a few donations were never logged, add what you remember with a note such as "approximate date" and carry on.

When should you share your donation tracker?

Share a donation tracker when other people are actively giving items away, making decisions about shared belongings, or preparing financial records. Keep it private the rest of the time. Common moments to share:

  • During a family clear-out: give siblings or a partner edit access so everyone can see what has been offered, claimed and donated.
  • Before a pickup you won't be home for: share the appointment details and the list of items with whoever will be there.
  • At tax time: share the year's summary and receipts with the person who prepares your return, if donations are relevant to it.
  • When handing over responsibility: if someone else is taking over a relative's affairs, the log shows what has already left the home and where it went.

Before sharing, check the Notes and Charities tabs for personal details such as addresses, phone numbers or access instructions. Shared spreadsheets let you choose between view-only and edit access, so you can match the access level to the person's role.

Donation tracker ideas for everyday situations

A donation tracker adapts to different stages of household life. Here are practical ways to set one up for common situations:

  • Families with growing children: a running "Outgrown" section, plus notes on which friends or relatives want hand-me-downs before anything goes to a charity.
  • A move or downsizing: room-by-room entries and a pickup schedule timed before moving day.
  • Clearing a relative's home: a shared Google Sheets tracker with family handover columns and a clear record of where each larger item went.
  • Seasonal decluttering: one tab per season, so you can see what tends to pile up and which charities run collections at that time of year.
  • Regular giving alongside decluttering: cash gifts and goods in the same charitable giving tracker, filtered by type when you need a summary.

Start small: one sheet, a few columns and the next bag you take out of the door. The tracker can grow as your needs do. Even a simple list will save you from searching for a receipt or wondering whether something has already gone.