Donation Acknowledgment Letter Template
The other 448 need what their own facts require: the deductible amount on a gala ticket, a description with no value on donated goods.
Free download · No account needed
The default acknowledgment says thank you for your gift of $X, and no goods or services were provided in return. For cash under $250 from a donor who received nothing back, that is exactly right, and in a normal quarter it is about two thirds of the batch. For the rest it is thin, and for a seventh of the batch it is untrue. A gala ticket buyer who paid $150 for a $58 dinner deducts $92, not $150.
So the artifact is a router rather than a letter. Every gift gets classified on four facts before a word is written: the form the gift took, what the donor received in return and what it was worth, the amount of the single contribution, and who the legal donor is. Exception Log then holds one row per gift that is not plain cash, carrying the fact that triggered it, the rule that fact triggers, and what the default letter would have said instead.
In the worked example a 1,260-gift quarter worth $493,582 puts 812 records on the default letter and routes 448 elsewhere. 276 of those are template swaps. The other 172 are gifts the default letter states something false about, and a restricted grant in the same batch needs its restriction recorded against the award reporting will draw on. The gala alone collected $52,000, delivered $25,268 of dinner and auction value, and left $27,042 deductible. A gift the CRM never recorded never reaches this queue, which three-way reconciliation catches and receipting cannot.
The gifts the default letter is wrong about, and why
The exceptions with the rule that put them there, the pricing behind every deductible amount, and the batch by route.
Exception Log
Illustrative, for a fictional community health nonprofit called Cedar Line Community Health. Fourth-quarter batch, 1,260 gift records, $493,582 recorded. 22 worked rows stand for the 448 gifts that routed away from the default letter. The last column is what makes this sheet persuasive to somebody who thinks the current process is fine.
| Gift | Fact that routes it | Routes to | What the default letter says | To state |
|---|---|---|---|---|
| Gala ticket | Paid $150, received a dinner worth $58 | Letter 2 | Gift of $150.00, no goods or services provided | $92.00 |
| Auction, residence week | Bid $6,400 on a lot worth $3,600 | Letter 2 | Gift of $6,400.00 | $2,800.00 |
| Auction, physiotherapy course | Bid $620 on a lot with a $690 list price | Letter 2 | Gift of $620.00 | $0.00 |
| Tables and chairs | Property, claimed value over $5,000 | Signature | Donation valued at $8,400.00 | Donor determines |
| Ultrasound unit | Property, claimed value over $5,000 | Signature | Donation valued at $26,900.00 | Donor determines |
| Print works donation | CRM memo field reads donated goods | Held | Donation valued at $920.00 | Needs a description |
| 300 shares of stock | Instructed 24 Dec, settled 29 Dec | Letter 4 | Gift of $9,300.00 on 24 December | Shares, issuer, 29 Dec |
| Volunteer mileage | Driver's own unreimbursed fuel, 3 routes | Letter 5 | Gift of $742.00 | Services, no amount |
| Fund grant for gala tables | A fund grant cannot pay for a benefit | Referred | Gift of $3,000.00 | Not receiptable as sent |
| Employer match | Match against an employee gift on another date | Letter 6 | Gift of $5,000.00, both gifts merged | $2,500.00 to the employer |
| Cheque dated 31 Dec | Postmarked 31 Dec, opened 6 Jan | Letter 1 | Gift of $5,000.00 on 6 January | $5,000.00 on 31 Dec |
| Twelfth monthly gift | $32 a month, $384 a year, no single gift at $250 | Letter 1 | Correct as sent | $32.00 |
| Restricted grant | Reporting condition attached to the award | Letter 1 | Unrestricted gift of $25,000.00 | Record the restriction |
Four of these are the shape of the whole problem. The physiotherapy lot sold below the value of what the winner received, so nothing is deductible and the letter has to say so; the sentence nobody wants to write is the one that makes the other 34 auction letters credible. The stock gift has three candidate dates and only the settlement date belongs on the letter. The 31 December cheque is in the donor's earlier year and the postmark is the evidence. And the recurring donor at $32 a month never has a single gift that reaches the threshold, so the annual summary everybody sends is a courtesy rather than the document the donor relies on.
Quid Pro Quo Benefit Schedule
One row per benefit rather than per gift, priced once, with the source in its own column. The deductible amount on every ticket and lot is computed from this sheet.
| Benefit | Lots | Paid each | Value each | Deductible each | Deductible total | Value source |
|---|---|---|---|---|---|---|
| Harvest Table dinner ticket | 96 | $150 | $58 | $92 | $8,832 | Caterer invoice 4418 |
| Week at a Truckee residence | 1 | $6,400 | $3,600 | $2,800 | $2,800 | Three comparable nightly rates |
| Signed print, edition of 40 | 1 | $1,100 | $480 | $620 | $620 | Gallery retail price |
| Restaurant tasting for six | 3 | $1,150 | $610 | $540 | $1,620 | Published menu price |
| Case of wine | 8 | $740 | $340 | $400 | $3,200 | Retailer shelf price |
| Weekend cabin stay | 2 | $2,300 | $1,180 | $1,120 | $2,240 | Owner's published rate |
| Physiotherapy course of six | 1 | $620 | $690 | $0 | $0 | Clinic list price |
| Garden design consultation | 1 | $1,650 | $400 | $1,250 | $1,250 | Designer's hourly rate |
| Silent-auction basket | 15 | $480 | $210 | $270 | $4,050 | Retail price of the contents |
| Framed sports memorabilia | 6 | $480 | $520 | $0 | $0 | Dealer price, comparable items |
| Spa day package | 3 | $1,260 | $450 | $810 | $2,430 | Spa's published package price |
| Membership, recurring privileges only | 41 | $75 | Token | $75 | $3,075 | Within the published insubstantial test |
| Event total | 137 | $52,000 | $25,268 | $27,042 |
Two things fall out of pricing the benefit rather than asserting it. A letter set that states the amount paid tells 137 donors they may deduct $52,000, which overstates the deductible total by $24,958, and the disclosure that prevents it is worth $10 per contribution in penalty exposure, capped at $5,000 per event. The second is subtler: seven lots sold at or below the value of the item, and a negative deduction does not exist, so the deductible total across the auction is $18,210 rather than the $17,900 you get by subtracting one column total from the other. The per-lot floor is what makes those two figures differ, and the difference is exactly the lots somebody overbid on in the wrong direction.
Gift Register
The batch by route, with the substantiation each letter has to carry and what is still outstanding at 31 days from the batch close.
| Route | Records | Recorded value | Letter | Outstanding | Status |
|---|---|---|---|---|---|
| Online cash under $250 | 704 | $41,832 | Letter 1 | 0 | Sent |
| Mailed cheque under $250 | 108 | $9,180 | Letter 1 | 0 | Sent |
| Cash of $250 or more | 214 | $186,300 | Letter 1 | 0 | Sent |
| Gala ticket | 96 | $14,400 | Letter 2 | 96 | Re-issue |
| Gala auction purchase | 41 | $37,600 | Letter 2 | 41 | Re-issue |
| In-kind under $5,000 | 19 | $22,450 | Letter 3 | 5 | Part sent |
| In-kind over $5,000 | 3 | $41,800 | Letter 3 | 3 | Blocked |
| Marketable securities | 7 | $63,900 | Letter 4 | 0 | Sent |
| Volunteer unreimbursed expense | 6 | $4,720 | Letter 5 | 0 | Sent |
| Donor-advised fund grant | 34 | $52,500 | Letter 6 | 0 | Sent |
| Employer matching gift | 28 | $18,900 | Letter 6 | 0 | Sent |
| Batch total | 1,260 | $493,582 | 145 |
Six letters cover 1,260 records, and the register is what makes the split visible: 812 records on the default letter, 276 on a template swap, and 172 the default letter states something untrue about. The three property gifts over $5,000 are the highest-value block in the batch at $41,800, and they are blocked on one signature from a named official rather than on any writing. The 137 gala letters that already went out are the reason the outstanding column reads 145 rather than 8: a letter that overstates a deductible amount is harder to withdraw than a letter that has not been sent, so re-issuing is slower than sending late would have been.
What is in the pack
Exception Log
One row per gift that is not plain cash, carrying the triggering fact, the rule it triggers, and what the default letter would have said.
Routed on four facts, not on the amount
Form of the gift, what the donor received in return, the amount of the single contribution, and who the legal donor is. In that order.
Quid Pro Quo Benefit Schedule
Every benefit priced once with its source named, so the deductible amount on each ticket and lot is computed rather than asserted.
Six letters, not one
Cash, quid pro quo, property, securities, volunteer expenses and institutional donors, each carrying only the substantiation its own facts require.
In-kind letters with no value on them
The property gets described and the value stays in the ledger, which is the in-kind mistake that runs in both directions.
The gifts that stop the batch
Property over $5,000, unpriced benefits and unresolved donors go to a named owner instead of quietly joining the default queue.
How it works
- 1
Send the gift export
Whatever columns your CRM produces, including whatever the annual appeal just wrote back into it. If it has no field for the form of the gift or for benefits received, that absence is the first finding.
- 2
Classify before writing
Four facts per record, established in order. Starting from the amount column is what puts a gala ticket in the default queue.
- 3
Price what you gave back
One row per benefit with the invoice, published rate or retail comparable named. Anything unpriced blocks its letters rather than getting an estimate.
- 4
Split the queues and check
Templates for the bulk, a named owner for everything that needs a person, then an audit for values on letters that must not carry one.
Frequently asked questions
Does one letter really not work?
For 812 of 1,260 gifts it works exactly. The problem is the other 448, and specifically the 172 where the default letter states something untrue. That means a deductible amount that is too high, or a value on a property gift that the organisation is not the party responsible for determining.
What has to be in an acknowledgment for a donor to use it?
The organisation's name, the amount of any cash, a description of any property, and a statement about goods or services provided in return. A written acknowledgment is required for any single contribution of $250 or more, and the description of property carries no value.
How is the deductible amount on a gala ticket worked out?
The payment less the fair market value of what the donor received, so a $150 ticket to a $58 dinner leaves $92. A disclosure statement is required whenever the payment exceeds $75, and skipping it costs $10 per contribution up to $5,000 per event.
Who signs the form for a large property gift?
An official authorised to sign the organisation's returns, or somebody specifically designated for that form. The donee organisation must complete and sign the acknowledgment part for property claimed above $5,000. Signing acknowledges receipt of what is described, not the appraised value.
Do we put a value on an in-kind letter?
No. Describe the property and leave the value out, because determining it belongs to the donor. The organisation still needs its own figure for its financial statements, so it lives in the ledger and on the Gift Register. Both facts are true in different places.
A foundation grant arrived. Is that a gift?
It is a grant, and a letter is the least of what it needs. The restriction and the document that created it belong in the award record that funder research started, and its reporting conditions become deadlines the moment the money lands.
Why classify before writing anything?
Because starting from the amount column gets a third of the batch wrong. It is the same order a proposal gets structured against a funder's published criteria before drafting, and the same reason a portal upload gets checked before the deadline hour.
Related
Holds each funder's own definition of every indicator, so one quarter of programme data produces the number each report actually asked for.
Funder research and prospect packReads a foundation's own filings for the grants it paid, which is where a restricted gift's conditions were set long before the cheque arrived.
More free templates
A corporate sponsorship proposal template that costs every comped seat and printed placement before quoting a price, so the deal nets what it should.
Major Gift Moves Management Template17 open prospects worth $3,095,000, seven stalled at $925,000: a template that flags a missed commitment and a silent stall as different problems.
Nonprofit Annual Appeal Letter TemplateOne ask string on 8,400 reply slips held 120 donors $5,850 below what they had already given. An appeal template that derives every ask from giving history.
Nonprofit Donation Reconciliation TemplateOne December, three totals: $86,686.40 at the processor, $70,788.41 at the bank, $90,615.40 in the CRM. Two bridges that close, and the gifts nobody recorded.
Find out which letters in your batch are wrong
Send the gift export and the event detail. The first thing back is the count of gifts the default letter states something untrue about.
Route my batch