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 |
| 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 |
| Check 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 check 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.