Implementation Guide: Auto-generate tax acknowledgment letters on donation receipt

Hardware Procurement

Document Scanner

Label Printer

Uninterruptible Power Supply

Staff Workstation (if upgrade needed)

Software Procurement

Prerequisites

Installation Steps

Step 1: Register Nonprofit with TechSoup and Apply for Software Grants

Register the nonprofit organization on TechSoup.org to access discounted software. This must be done first as the validation process takes 2–14 business days. You will need the organization's 501(c)(3) determination letter, EIN, and basic organizational info. Once validated, request QuickBooks Online Plus ($75/year) and verify Microsoft 365 nonprofit eligibility.

Step 2: Provision Microsoft 365 Nonprofit Tenant and Configure Email Domain

Set up the Microsoft 365 Business Basic nonprofit tenant (free for up to 300 users). Add the nonprofit's custom domain, configure Exchange Online mailboxes, and set up SPF, DKIM, and DMARC DNS records to ensure acknowledgment emails are delivered reliably and not marked as spam.

# SPF Record (TXT)
# Host: @
v=spf1 include:spf.protection.outlook.com -all
# TTL: 3600

# replace yourdomain and yourtenant with actual values

selector1._domainkey.yourdomain.org -> selector1-yourdomain-org._domainkey.yourtenant.onmicrosoft.com
selector2._domainkey.yourdomain.org -> selector2-yourdomain-org._domainkey.yourtenant.onmicrosoft.com

# DMARC Record (TXT)
# Host: _dmarc
v=DMARC1; p=quarantine; rua=mailto:dmarc-reports@yourdomain.org; pct=100
# TTL: 3600

# replace yourdomain-org with your actual tenant value

# MX Record
# Host: @
# Value: yourdomain-org.mail.protection.outlook.com
# Priority: 0
# TTL: 3600

Step 3: Create Stripe Account and Apply for Nonprofit Rate

Set up a Stripe account for the nonprofit to process online donations. Apply for the discounted nonprofit transaction rate (2.2% + $0.30 vs. standard 2.9% + $0.30). This saves the organization approximately $7 per $1,000 in donations processed.

Step 4: Install and Configure QuickBooks Online Plus

Activate the QuickBooks Online Plus subscription obtained through TechSoup. Configure the chart of accounts for nonprofit fund accounting, including donation revenue accounts, restricted vs. unrestricted funds, and program expense categories. This provides the accounting backbone that the donor CRM will sync to.

Step 5: Deploy Bloomerang CRM and Configure Organization Profile

Create the Bloomerang CRM account, configure the organization profile with all required IRS information, set up user accounts for staff, and configure role-based access controls. The organization profile information populates every auto-generated acknowledgment letter.

Step 6: Design IRS-Compliant Acknowledgment Letter Templates

Create email and print letter templates that include all IRS-required elements per Publication 1771. Build separate templates for: (1) standard cash donations, (2) donations with quid pro quo benefits (e.g., gala tickets), (3) in-kind/non-cash donations, and (4) year-end consolidated receipts. Each template must include the organization name, EIN, donation amount, date, and goods/services statement.

Required merge fields for all templates:

• {{Organization.Name}} — Legal name of the nonprofit
• {{Organization.EIN}} — Employer Identification Number
• {{Donor.FirstName}} {{Donor.LastName}} — Donor's full name
• {{Donor.Address}} — Donor's mailing address
• {{Transaction.Amount}} — Donation amount
• {{Transaction.Date}} — Date donation was received
• {{Transaction.Fund}} — Designated fund (if applicable)
• {{Transaction.PaymentMethod}} — Check, credit card, cash, etc.

[Organization Letterhead/Logo]

{{CurrentDate}}

Dear {{Donor.FirstName}},

Thank you for your generous contribution to {{Organization.Name}}.

This letter serves as your official tax receipt for the following donation:

Donor Name: {{Donor.FirstName}} {{Donor.LastName}}
Donation Amount: {{Transaction.Amount}}
Date Received: {{Transaction.Date}}
Payment Method: {{Transaction.PaymentMethod}}

No goods or services were provided in exchange for this contribution.

{{Organization.Name}} is a tax-exempt organization under Section 501(c)(3)
of the Internal Revenue Code. Our EIN is {{Organization.EIN}}.

Please retain this letter for your tax records.

With gratitude,

[Authorized Signer Name]
[Title]
{{Organization.Name}}
{{Organization.Address}}
{{Organization.Phone}}

Step 7: Import and Cleanse Existing Donor Data

Export donor records from the nonprofit's existing system (spreadsheets, legacy database, or another CRM) to CSV format. Clean and deduplicate the data, then import into Bloomerang. Map fields correctly to ensure acknowledgment letters merge properly.

Required Columns for Bloomerang Import CSV

Prepare your CSV with the following required columns before importing into Bloomerang:

• First Name
• Last Name
• Email
• Street Address
• City
• State
• Zip
• Phone
• Donor Type (Individual/Organization)
• Donation Amount
• Donation Date
• Payment Method
• Fund/Campaign

Data Cleansing Steps (Excel or Google Sheets)

Import Steps in Bloomerang

Step 8: Configure Automatic Acknowledgment Triggers and Rules

Set up the automation rules in Bloomerang that trigger acknowledgment letter delivery when a donation is recorded. Configure rules for different donation types, amounts, and delivery methods (email vs. print queue).

Step 9: Integrate Bloomerang with QuickBooks Online

Connect Bloomerang to QuickBooks Online so that donation transactions automatically sync to the accounting system. This eliminates double-entry and ensures the acknowledgment letter amounts match the accounting records.

Step 10: Configure Zapier Workflows for Extended Automation (If Needed)

Set up Zapier automations for workflows that extend beyond the CRM's native capabilities — such as logging donations to a Google Sheet for board reporting, sending Slack/Teams notifications for large gifts, or triggering a print workflow for physical letters via a connected printer service.

Zapier Account Setup

Sample Zap 1: Large Donation Notification

# Send a Teams message when a donation of $1,000 or more is received

Trigger: Bloomerang > New Transaction > Filter: Amount >= $1,000
Action: Microsoft Teams > Send Channel Message
  Channel: #development-team
  Message: '🎉 New donation of {{amount}} from {{donor_name}} on {{date}}'

Sample Zap 2: Google Sheets Donation Log

# Log every new transaction as a row in the 2025 Donation Log spreadsheet

Trigger: Bloomerang > New Transaction
Action: Google Sheets > Create Spreadsheet Row
  Spreadsheet: 'Donation Log 2025'
  Columns: Date, Donor Name, Amount, Fund, Payment Method, Receipt Sent (Yes)

Sample Zap 3: Backup Receipt Confirmation

# Email the executive director a confirmation whenever an acknowledgment
# letter is sent

Trigger: Bloomerang > New Transaction
Action: Gmail > Send Email
  To: executive.director@orgname.org
  Subject: 'Receipt sent to {{donor_name}} for ${{amount}}'
  Body: 'Automated acknowledgment letter was sent on {{date}}.'

Step 11: Install and Configure Hardware (Printer, Scanner, UPS)

Set up the physical hardware at the nonprofit's office for printing acknowledgment letters, scanning check donations, and protecting the primary workstation with battery backup.

HP LaserJet Pro MFP 4101fdw Setup

winget install HP.HPSmart

Fujitsu ScanSnap iX1600 Setup (if purchased)

APC Back-UPS Pro 1500VA Setup

Step 12: End-to-End Testing with Test Donations

Process a series of test donations through every donation channel (online form, manual check entry, recurring gift) and verify that acknowledgment letters are generated correctly, emails are delivered, print queue populates, and QuickBooks entries are created.

Custom AI Components

Donation Receipt Trigger Workflow

Type: workflow

The core automation workflow that monitors for new donation entries in the CRM and triggers the appropriate acknowledgment letter template based on donation type, amount, and donor communication preferences. This is a deterministic rule-based workflow, not an AI/ML component.

Workflow: Donation Receipt Auto-Trigger

Platform: Bloomerang Native Automation

Trigger Event: New transaction saved in Bloomerang (any source: online form, manual entry, import, recurring charge)

Decision Logic (Deterministic Rules)

ON new_transaction_saved:
  
  # Step 1: Determine template
  IF transaction.fund IN ['Gala', 'Event', 'Auction', 'Dinner']:
    template = 'quid_pro_quo_receipt'
    # Requires staff to enter FMV in transaction notes
  ELIF transaction.type == 'InKind':
    template = 'inkind_donation_receipt'
    # No dollar value stated per IRS rules
  ELIF transaction.type == 'Stock' OR transaction.type == 'Securities':
    template = 'stock_donation_receipt'
  ELSE:
    template = 'standard_cash_receipt'
  
  # Step 2: Determine delivery method
  IF donor.email IS NOT NULL AND donor.email_opt_in == True:
    send_email(template, donor.email)
    log_communication('Email receipt sent')
  
  IF transaction.amount >= 250 OR donor.email IS NULL:
    add_to_print_queue(template)
    log_communication('Letter queued for print')
  
  # Step 3: Sync to accounting
  sync_to_quickbooks(
    amount = transaction.amount,
    account = map_fund_to_qbo_account(transaction.fund),
    date = transaction.date,
    memo = f'Donation from {donor.full_name}',
    class = transaction.fund
  )
  
  # Step 4: Optional notifications (via Zapier)
  IF transaction.amount >= 1000:
    zapier_webhook('large_donation_alert', {
      donor: donor.full_name,
      amount: transaction.amount,
      date: transaction.date
    })

Bloomerang Configuration Steps

Year-End Consolidated Receipt Generator

Type: workflow A batch workflow that runs annually in January to generate consolidated tax receipts for all donors, summarizing their total giving for the previous calendar year. This satisfies IRS requirements and is especially valuable for donors who gave multiple smaller amounts throughout the year.

Implementation

Workflow: Year-End Consolidated Receipt Batch

Platform: Bloomerang Native + Manual Trigger

Trigger: Manual batch run by staff in first two weeks of January Schedule: Annually, between January 2 and January 15

Process

FOR each donor IN annual_summary WHERE total_giving >= 250:
  
  consolidated_receipt = generate_letter(
    template = 'year_end_consolidated_receipt',
    merge_fields = {
      donor_name: donor.full_name,
      donor_address: donor.mailing_address,
      org_name: org.legal_name,
      org_ein: org.ein,
      year: prior_year,
      donation_table: [
        {date, amount, fund, payment_method}
        FOR each transaction IN donor.transactions
        WHERE transaction.year == prior_year
      ],
      annual_total: SUM(donor.transactions.amount),
      goods_services_statement: 'No goods or services were provided in exchange for these contributions unless otherwise noted above.'
    }
  )
  
  # Delivery
  IF donor.email IS NOT NULL:
    send_email(consolidated_receipt, donor.email)
  
  add_to_print_queue(consolidated_receipt)  # Always print year-end letters

Year-End Receipt Template Required Fields

• Organization legal name and EIN
• Calendar year covered
• Donor name and address
• Table of all donations: Date | Amount | Fund | Payment Method
• Annual total
• Statement re: goods/services for each transaction
• Authorized signature block
• Statement: 'This letter serves as your official receipt for tax purposes for all contributions made to [Org Name] during [Year].'

Bloomerang Steps

Quid Pro Quo Benefit Calculator

Type: integration A helper component embedded in the donation entry form that calculates the tax-deductible portion of a quid pro quo donation by subtracting the fair market value of goods/services provided from the total contribution amount. This ensures the acknowledgment letter displays the correct deductible amount as required by the IRS.

Implementation: Custom field + template logic in Bloomerang

Create Custom Fields in Bloomerang

Staff Workflow for Quid Pro Quo Entry

When entering a quid pro quo donation:

Template Merge Logic

In the 'Quid Pro Quo Receipt' template, use these merge fields:

Dear {{Donor.FirstName}},

Thank you for your contribution of {{Transaction.Amount}} to 
{{Organization.Name}} on {{Transaction.Date}}.

In exchange for your contribution, you received the following:
{{Transaction.CustomField.DescriptionOfBenefits}}

The estimated fair market value of these goods/services is 
{{Transaction.CustomField.FairMarketValue}}.

Therefore, the tax-deductible portion of your contribution is 
{{Transaction.CustomField.TaxDeductibleAmount}}.

{{Organization.Name}} is a tax-exempt organization under Section 
501(c)(3) of the Internal Revenue Code. Our EIN is {{Organization.EIN}}.

Please retain this letter for your tax records.

Pre-populate Common Events

Create a reference table for staff and update it before each event. Share with all data entry staff.

IRS Compliance Notes

• Required for ANY contribution over $75 where benefits are provided
• The FMV must be a 'good faith estimate' — document how it was determined
• De minimis benefits (token items worth < $12.50) can be ignored
• Membership benefits can be disregarded if annual dues are $75 or less and benefits are 'low-cost articles'

Email Deliverability Monitor

Type: integration A monitoring integration that tracks acknowledgment email delivery rates, bounce rates, and spam complaints to ensure tax receipts actually reach donors. Uses Microsoft 365 message trace and Bloomerang delivery reports.

Implementation

Microsoft 365 Message Trace (Built-in)

• Access: Exchange Admin Center > Mail Flow > Message Trace
• Run weekly trace for messages FROM donations@orgname.org
• Filter for: Delivered, Failed, Pending, Bounced
• Export results to CSV for record-keeping

Bloomerang Communication Reports

• Navigate to Reports > Communication Reports
• Review: Emails Sent, Opened, Bounced, Unsubscribed
• Flag any bounced addresses for manual follow-up (print letter instead)

Monitoring Schedule

Weekly (Every Monday)

Monthly

Quarterly

Alert Thresholds

• Bounce rate > 5%: Investigate domain reputation
• Open rate < 40%: Check spam folder placement
• DMARC failures > 2%: Review DNS records

Zapier Alert (Optional)

Trigger: Schedule (Weekly, Monday 9 AM)
Action: Email to msp-team@mspname.com
Subject: 'Weekly Receipt Deliverability Check Reminder - [Org Name]'
Body: 'Run the weekly email deliverability check for [Org Name].
       Bloomerang: [login URL]
       M365 Admin: [admin URL]
       Checklist: [link to monitoring SOP]'

Testing & Validation

Client Handoff

Client Handoff Checklist

Training Sessions (2 sessions, 60-90 minutes each):

Session 1 — Daily Operations Training (for all development/admin staff):

• How to enter donations manually (check, cash, in-kind)
• How to verify an acknowledgment was sent (check communication log on donor record)
• How to process the print queue for physical letters (weekly batch)
• How to handle bounced emails (update donor record, queue print letter)
• How to enter quid pro quo donations with Fair Market Value
• How to look up a donor's receipt history
• How to add new donors to the system

Session 2 — Administration Training (for Executive Director and CRM Admin):

• How to edit acknowledgment letter templates
• How to run reports (donation summary, communication delivery, year-end)
• How to run the year-end consolidated receipt batch
• How to manage user accounts and permissions
• How to access QuickBooks sync status and resolve sync errors
• Overview of Zapier workflows (if configured) and how to check task usage

Documentation to Leave Behind:

Success Criteria to Review Together:

Maintenance

Ongoing Maintenance Plan

Weekly Tasks (15-30 minutes, performed by MSP or trained client staff):

• Review Bloomerang communication delivery report for bounced emails
• Process print queue for any queued physical letters
• Verify QuickBooks sync is current (no pending/failed syncs)
• Check Zapier task usage (if applicable) to ensure not approaching limits

Monthly Tasks (1 hour, performed by MSP):

• Run Microsoft 365 Message Trace for all receipt emails sent from donations@ mailbox
• Review DMARC aggregate reports for authentication failures
• Check Stripe dashboard for failed recurring donation charges
• Verify all software subscriptions are active and not approaching renewal
• Review CRM user accounts — disable any departed staff accounts
• Check for Bloomerang platform updates and review release notes

Quarterly Tasks (2-3 hours, performed by MSP):

Annual Tasks (4-6 hours, performed by MSP):

• January (Priority): Assist with year-end consolidated receipt batch generation
• February: Review IRS Publication 1771 for any changes to acknowledgment requirements; update templates if needed
• March: Annual review of all letter templates with client's CPA or legal counsel
• June: Mid-year check on Bloomerang subscription renewal; negotiate pricing if needed
• July: Review Microsoft 365 nonprofit licensing (grant terms may change annually)
• October: Pre-year-end review — verify all donor email addresses are current, clean bounce list
• December: Renew QuickBooks Online via TechSoup; renew any other annual subscriptions

SLA Considerations:

• Response time for receipt delivery issues: 4-hour response, 24-hour resolution (donors expecting immediate receipts)
• Response time for template errors: Next business day
• QuickBooks sync failures: 24-hour resolution
• Email deliverability degradation: 4-hour response (critical during fundraising campaigns)
• Platform outage: Escalate to Bloomerang support immediately; MSP monitors status page

Escalation Paths:

Cost of Ongoing Management:

• Recommended monthly retainer: $300-$500/month covering all weekly and monthly tasks
• Quarterly and annual tasks billed at hourly rate or included in managed tier
• Year-end receipt batch assistance: included in managed tier or $500 one-time annual fee

Alternatives

Replace Bloomerang ($125/month) with Little Green Light ($39-$99/month) as the donor CRM platform. LGL offers mail-merge acknowledgment letters, label printing, and integrations with QuickBooks, Mailchimp, Constant Contact, and Zapier. It handles all core receipt automation needs at a significantly lower monthly cost.

Use Donorbox as the primary donation platform instead of a full CRM. Donorbox provides embedded donation forms, automatic email receipts, recurring giving, and integrations with QuickBooks (via Commerce Sync) and Zapier. The Standard plan is free with a 2.95% platform fee, or the Pro plan is $139/month with a reduced 1.50% fee.

Use Zeffy as the donation and receipt platform. Zeffy is 100% free for nonprofits — no platform fees, monthly subscriptions, or setup costs. It automatically generates IRS and CRA-compliant tax receipts for all donations. Funded by optional donor tips rather than nonprofit fees.

Use DonorPerfect instead of Bloomerang for organizations needing more advanced receipt customization, batch processing, and accounting exports. DonorPerfect offers auto-generated thank-you emails, consolidated year-end receipts, .iif file exports for QuickBooks, and deep Constant Contact integration. Plans start at $99/month (Lite) up to $289/month (Essentials).

Use Salesforce Nonprofit Cloud with the 10 free licenses available to eligible 501(c)(3) organizations. Build custom acknowledgment letter automation using Salesforce Flows (formerly Process Builder) and email templates. Integrate with QuickBooks via third-party connectors (DBSync, Breadwinner) or Zapier.

Skip a dedicated donor CRM entirely and use Microsoft Excel for donor tracking combined with Word mail merge for generating acknowledgment letters. Staff manually trigger the mail merge process after entering donations into the spreadsheet. Emails are sent via Outlook.