To find a year of donation receipts in your email, search for the words organisations use in their receipts, limit the search to the April to March year, save each message as a PDF, and list them in one sheet by organisation, date and amount. An hour spent once makes the next year easier, because you can then add each receipt as it arrives.
Which search terms and filters surface the receipts?
The examples below use the search operators Gmail understands. Other email apps have similar filters, so check how yours handles dates and subjects. Dates are written year, month, day, and the range runs across an April to March year, for example the year ending in March 2026.
- donation receipt after:2025/03/31 before:2026/04/01
- subject:(receipt OR acknowledgement OR acknowledgment) donation after:2025/03/31 before:2026/04/01
- thank you for your donation after:2025/03/31 before:2026/04/01
- contribution receipt has:attachment after:2025/03/31 before:2026/04/01
- from:(an organisation's name) after:2025/03/31 before:2026/04/01
Run each in turn and note the matches. Then check the spam folder and any other email addresses you use, since receipts often go to whichever address you typed into a payment page.
What if a receipt is not in the inbox?
Work from your own records instead. Look at your UPI and bank statements for payments to charities, trusts and temples, then search your email for each organisation's name. If you find a payment but no receipt, write it on a separate follow-up list, and write to the organisation asking for the acknowledgement, quoting the date, amount and UPI reference number from your statement.
How do you save the receipts as PDFs?
- Open the message and choose print, then pick save as PDF as the destination.
- If the receipt is an attached PDF, download it as it is.
- Name each file: year, month, day, organisation, amount. For example 2025-12-08 child education trust 2500.
- Save all files into one folder named for the financial year, such as Donations 2025-26.
- Back the folder up with your other important records.
Saving the PDF matters because email accounts get cleaned up and old attachments can vanish. A saved file in your own folder is yours.
What should the one-sheet list look like?
One row per receipt, with these columns:
| Column | Example entry |
|---|---|
| A: Organisation | Child education trust |
| B: Date of receipt | 08-12-2025 |
| C: Mode | UPI |
| D: Amount in rupees | 2500 |
| E: Receipt number | R-0412 |
| F: File name | 2025-12-08 child education trust 2500 |
The total for the year is a single formula, valid in Excel and Google Sheets: =SUM($D$2:$D$200). To total one organisation, use =SUMIFS($D$2:$D$200, $A$2:$A$200, "Child education trust"). Say your sheet shows ₹2,500, ₹1,000 and ₹500 for three different organisations; the sheet total of ₹4,000 should equal the sum you get by adding them by hand. These figures are made up, and the check is worth doing with real ones.
Check each saved file once before moving on. Open it and confirm the amount, the date and the organisation's name are visible, because a PDF saved from a long email thread sometimes cuts off the part you needed. If the receipt is only a line inside a message, save the whole message and not just that line.
Can you do this automatically next year?
Set up a mail filter or label that tags messages containing donation, receipt or acknowledgement as you receive them. Then, once a month, spend ten minutes saving the new ones and adding a row. Checking a month at a time is far lighter than a December scramble.
If you also import your bank or card statements into SpendixAI, you can compare the donation rows there with the sheet, which makes a missing receipt easy to spot.
Whether any particular donation can be counted in a tax return depends on the organisation and the rules for the year. Rules and limits change, so give your CA the list and PDFs, and confirm the current position with them or the official source.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

