ActBlue Recurring vs One-Time Donation Export Fields Explained

Learn how ActBlue flags recurring vs one-time donations in CSV exports, including subscription IDs and recurring plan metadata for accurate finance reports.

When you export contribution data from ActBlue, every donation record carries specific flags that tell you whether it's a one-time gift or part of a recurring subscription. Finance directors need to separate these donation types correctly for FEC reporting, donor retention analysis, and accurate revenue forecasting. A single incorrect filter can throw off your monthly recurring revenue calculations by thousands of dollars.

The distinction between recurring and one-time donations appears in multiple export fields, not just one binary flag. ActBlue tracks subscription IDs, charge sequences, and recurring plan attributes across several columns. Understanding how these fields work together prevents common export mistakes like double-counting initial recurring charges or missing cancelled subscriptions that still show transaction records.

For more background on ActBlue's overall export structure, see our ActBlue export data cleaning overview.

What Are One-Time Donations in ActBlue?

One-time donations represent single contribution events with no future payment commitment. When a donor completes a one-time gift through your ActBlue form, the system processes one charge and closes that transaction. The donor's card is not stored for future automatic billing unless they separately opt into a recurring plan.

In your export data, one-time donations appear as standalone records with empty or null values in recurring-specific fields. You'll see a contribution amount, date, and donor information, but no subscription ID or recurring frequency indicator. These donations are the simplest to work with because each export row represents exactly one financial transaction.

One-time gifts typically represent a large share of contribution volume for most campaigns, though they represent a smaller percentage of lifetime donor value compared to recurring donors. Your export filters need to handle this majority case cleanly while preserving the ability to isolate recurring subscription activity.

What Are Recurring Donations in ActBlue?

Recurring donations operate as subscription plans where ActBlue automatically charges the donor's payment method at defined intervals—weekly or monthly. When a donor sets up a recurring gift, ActBlue creates a subscription record that generates new transaction entries each billing cycle until the donor cancels or the subscription expires.

Each recurring subscription has a unique subscription identifier that links all related charges together. The initial setup generates one transaction record, then subsequent billing cycles create additional records with the same subscription ID. A monthly $25 recurring donation running for six months will appear as six separate rows in your export, all sharing the same subscription identifier.

ActBlue recurring plans include start dates, end dates (if applicable), frequency settings, and status flags indicating whether the subscription is active, cancelled, or failed. These attributes appear across multiple export columns, requiring you to check several fields to fully understand a subscription's state.

ActBlue's Report Builder allows campaigns to filter and analyze contribution data by donation type, including recurring subscription status.

ActBlue (actblue.com)

How Do Recurring Donation Fields Appear in Your CSV Export?

ActBlue CSV exports include specific columns that identify donation type and track recurring subscription details. ActBlue's Report Builder uses customizable columns, so exact field names vary by export configuration. To find recurring-related fields, search your column headers for "recurring" — ActBlue recommends this approach in its own documentation. A boolean-style column indicating whether a contribution is recurring will show a true/false or yes/no value; a TRUE or Yes value indicates the transaction is part of a recurring subscription.

Depending on your Report Builder configuration, exports may also include fields such as:

Subscription identifier: A unique value linking all charges within the same recurring plan. Empty for one-time donations.

Recurring frequency: The billing interval (such as weekly or monthly) for recurring gifts.

Subscription start date: When the recurring plan began, distinct from individual charge dates.

Subscription or donor status: A status indicator for the recurring contribution, such as active, cancelled, or inactive.

Because ActBlue does not publish a fixed schema for these column names, treat the above as examples of the types of fields available rather than guaranteed column headers. Check your export's full CSV field reference and verify column names against your actual Report Builder download.

How Do You Filter Export Data by Donation Type?

The simplest filter applies to the boolean recurring indicator field. In Excel or Google Sheets, filter the "Recurring" column to show only FALSE values for one-time donations, or TRUE values for all recurring transactions. This gives you a quick split but doesn't separate initial recurring charges from subsequent ones.

To isolate initial recurring donations, you need a compound filter. ActBlue's Report Builder treats the first recurrence as a distinct concept you can filter for directly—check whether your export includes a dedicated first-recurrence indicator before building a manual workaround. If no such field is available, a common heuristic is to look for rows where the recurring flag is TRUE and the transaction date matches the subscription start date, which should approximate first charges in each recurring plan.

For subsequent recurring charges, filter for TRUE recurring flags where the transaction date is later than the subscription start date. These are the renewal payments that represent retained recurring revenue. Most finance directors track these separately because they have different accounting implications than new acquisition.

When you're working with large exports covering multiple months, sorting by Subscription ID groups all charges from the same recurring plan together. This makes it easy to spot cancelled subscriptions (where charge records stop appearing in later months) or failed payments (often flagged with specific status codes).

Manual filtering in spreadsheets becomes tedious fast. Teams managing dozens of ActBlue exports per cycle often automate this step—Start 14-Day Free Trial → kitworkflows.com lets you build workflows that automatically separate recurring and one-time donations in ActBlue exports, handling the multi-field logic without manual intervention.

What Common Problems Affect Recurring Donation Exports?

Cancelled recurring subscriptions create phantom records in your exports. Even after a donor cancels, the historical charge records remain in your data. If you filter only by the recurring flag without checking subscription status or end date, you'll count inactive subscriptions in your recurring donor metrics. Always cross-reference the status field or check whether the subscription end date has passed.

Failed recurring charges appear as transaction attempts with declined or failed status codes. These records show up in your export with the recurring flag set to TRUE but with a failed payment indicator. Including them in revenue totals will overstate your actual received funds. Filter for successful status codes when calculating financial totals.

Donors with an ActBlue Express account can edit the dollar amount of their recurring contribution; according to ActBlue's support documentation, the change applies only to future payments on the same recurring plan. How this update appears in your export data depends on your Report Builder configuration. Group records by donor email or donor ID rather than relying solely on subscription identifiers to avoid counting one donor's adjusted subscription as multiple distinct recurring donors.

Recurring giving programs generate substantial long-term value for campaigns, with recurring commitments accounting for a large share of total fundraising revenue.

ActBlue (actblue.com)

Refunded recurring donations appear in ActBlue's contribution data with a "Refunded" status indicator. ActBlue also provides a dedicated Refunds tab for listing refunds separately. Regardless of how refunds surface in your specific export configuration, exclude refunded contributions from revenue totals to avoid overstating actual received funds. Check for refund status fields or filter views when building financial summaries.

Step-by-Step: How to identify donation type and track recurring gift subscriptions in ActBlue CSV data

Open your ActBlue CSV export in a spreadsheet application and locate the column headers to identify recurring-specific fields.

Apply an initial filter to the "Recurring" or "Is Recurring" column to separate TRUE (recurring) from FALSE (one-time) donations.

Add a secondary filter on the "Subscription Status" field to show only Active subscriptions if you need current recurring donor counts.

Sort the filtered data by "Subscription ID" to group all transactions from the same recurring plan together for subscription-level analysis.

Create a pivot table or summary calculation that counts unique Subscription IDs to determine your total number of active recurring subscriptions versus counting individual charge records.

Cross-reference the transaction date with the subscription start date to separate initial recurring charges from subsequent renewal payments for accurate acquisition vs retention metrics.

What Are the Best Practices for Managing Recurring vs One-Time Data?

Always validate your filters using multiple fields, not just the binary recurring indicator. Check subscription status, end dates, and payment success flags together to avoid including cancelled or failed subscriptions in active donor counts.

Track subscription IDs consistently across export periods. When you merge monthly exports, use subscription IDs to deduplicate subscriptions that appear in multiple files. A subscription active in January and February should count as one recurring donor, not two.

Separate your analysis of initial recurring charges from subsequent charges. The first charge represents donor acquisition cost recovery and conversion metrics, while subsequent charges measure retention and lifetime value. Mixing these together obscures which marketing efforts drive sustainable recurring revenue.

Document your filter logic and field mappings. ActBlue occasionally updates export formats or field names. Written procedures ensure your team applies consistent criteria when export structures change.

Build automated checks that flag anomalies like subscription IDs appearing with different recurring amounts, status inconsistencies, or gaps in charge sequences. Manual review catches these issues, but automated validation catches them faster and prevents reporting errors from reaching stakeholders.