How do I track tax-deductible amounts of contributions in bulk?

Overview

If multiple contributions include goods or services (such as event tickets or premiums), you may need to update the Fair Market Value (FMV) for many records at once. This allows the system to correctly calculate the Tax-Deductible Amount for each contribution.

This article shows two supported ways to do this in bulk, depending on your situation.

Result: The Tax-Deductible Amount updates automatically for all affected contributions.

Use this when

• You need to add or update Fair Market Value (FMV) on many contributions

• Donors received goods or services and only part of the gift is tax-deductible

• Updating records one-by-one would take too long

Before you begin

• Tax-deductible tracking must be enabled for the designation

  • If you’re not sure whether this is enabled, that’s okay—many volunteers don’t manage this

  • You may need to ask an admin or contact support

• You know the Fair Market Value (FMV) you need to apply

• You understand that FMV affects donor tax acknowledgements

Estimated time:

• Bulk Edit: 5–10 minutes

• Bulk Upload: 10–20 minutes

Choose the right bulk option

Quick decision:

• Same FMV for all → Bulk Edit

• Different FMV values → Bulk Upload

Option 1: Track tax-deductible amounts using Bulk Edit

Step 1: Open the Contributions Report

1. Start from the EveryAction Home Page.

2. Open the Contributions Report.

   • Use Search for a page and type Contribution Report if needed.

Step 2: Filter the contributions

1. Filter for the correct date range.

2. Narrow the report to only contributions that need FMV updates.

You may add Fair Market Value and Tax-Deductible Amount columns to review data first.

Step 3: Apply Bulk Edit

1. Select Report Actions → Bulk Edit.

2. Enter the Fair Market Value (FMV).

3. Apply the change.

What happens next

• The system automatically recalculates the Tax-Deductible Amount

• No manual math is required

Option 2: Track tax-deductible amounts using Bulk Upload

Step 1: Prepare a backup file

1. Export the contributions report with the contributions that need to be updated.

This backup can be used to restore data if needed.

Step 2: Open the Bulk Upload Wizard

1. From the home page, go to:
   Contacts → Bulk Upload → Bulk Upload New File

2. Or use Search for a page and type Bulk Upload New File.

Step 3: Select upload type

Choose Load Data with Contribution ID.

Step 4: Map Fair Market Value

1. Map your file’s column to Fair Market Value.

2. Choose whether to apply one value to all records or use column values.

Step 5: Finish the upload

1. Review mappings.

2. Click Finish.

Some uploads require administrator approval before processing.

Important compliance notes

• FMV is the value of goods or services provided—not the donation amount

• Tax-Deductible Amount = Contribution Amount – FMV

• These values appear on donor receipts and year-end acknowledgements

Quick check before you move on

✅ Correct contributions selected

✅ FMV values reviewed

✅ Backup saved (Bulk Upload)

If all are true, you’re done.

What else do you need help with?

• How do I review contribution data before sending year-end receipts?

• How do I create year-end gift receipts for postal mail?

Not what you’re looking for?

• Return to Overview: End-of-Year Giving & Tax Receipts to choose a different task.