Automate RMD Calculations: 8-Step Annual Workflow for Advisors 2026

Key Takeaways

• Required Minimum Distributions (RMDs) carry a 25% excise tax penalty on the missed amount — making the stakes for deadline misses unusually high relative to other advisory compliance tasks.

• Most advisory firms track RMDs in spreadsheets or CRM notes, which require manual annual updates and create significant error risk as client populations age.

• The platform builds a systematic RMD annual workflow: eligibility identification in January, calculation routing to portfolio management, client notification sequences, and year-end completion verification — all without a care coordinator manually working through a list.

• The workflow integrates with financial advisor CRMs (Redtail, Wealthbox) and portfolio management platforms (Orion, Envestnet, Tamarac) without requiring a new system of record.

• SEC-registered RIAs number 15,400+ serving retail clients, according to SIFMA 2024 — and RMD compliance is a standard requirement across virtually every book that serves retirees.

TL;DR: RMDs are not optional for clients over 73 — missing one triggers a 25% excise tax on the undistributed amount, which creates both financial harm and regulatory exposure for the advisory firm. A well-built US Tech Automations workflow identifies every RMD-eligible client at the start of each year, routes calculations to the right team members, notifies clients with personalized distribution options, and verifies completion before December 31. The deciding factor is whether your portfolio management platform can export current account balances — if yes, full automation takes 3-4 weeks to configure.

What is an RMD calculation annual workflow automation? A systematic, date-triggered process that begins each January by identifying eligible clients, calculates their required distributions based on prior-year-end balances and IRS life expectancy tables, and routes distribution and client notification tasks through a documented workflow with completion tracking. The average advisor book size is $98M AUM, according to Cerulli Associates 2024 — for a typical retiree-heavy book, RMD management can involve 30-80+ client households annually.

Who this is for: Independent RIAs and wealth management teams with 20-200+ clients subject to RMDs, using Redtail or Wealthbox as their CRM and Orion, Envestnet, or Tamarac for portfolio management, facing annual pressure to complete all RMDs before December 31 without errors.

The Financial Services Automation Maturity Model for RMD Workflows

RMD calculation and distribution sits at Stage 2 in the financial services automation maturity model — it requires data exchange between portfolio management and CRM, but doesn't require AI or advanced modeling to execute well.

Stage 1: Foundational Wins

At Stage 1, advisors automate individual repetitive tasks: appointment reminders, document request follow-ups, client birthday greetings, and quarterly review reminders — all handled as standalone workflows.

Why start here before RMDs: Foundational workflows build your team's confidence with automation and establish the CRM-to-USTA integration that Stage 2 workflows depend on. If your CRM integration isn't established, the RMD workflow can't query client eligibility data.

For foundational financial automation, see how to build a new client onboarding to first meeting automation in US Tech Automations and how to build a quarterly portfolio review reminder in US Tech Automations.

Stage 2: Cross-Tool RMD Workflows

The RMD annual workflow is a Stage 2 workflow because it spans 4 systems: CRM (client data, eligibility, contact information), portfolio management (prior-year-end balances), client communication (outreach and notification), and task management (team routing, completion tracking).

Stage 2 capability requirements for RMD automation:

Stage 3: Predictive and AI-Assisted

At Stage 3, firms layer predictive modeling: optimal distribution timing (spreading across year vs. Q4), QCD opportunity identification, and Roth conversion analysis for clients near the RMD threshold. Most firms should nail Stage 2 compliance first.

Stage 1: Foundational Wins in RMD Management

Before building the full automated workflow, confirm that your foundational data is clean. The most common failure point in RMD automation is incorrect or incomplete client data — missing date of birth, incorrect account type classification (IRA vs Roth vs 403b), or stale beneficiary designations.

Foundational data audit checklist:

The platform can run this audit automatically by querying your CRM for all clients with a DOB indicating age 70-75+ and generating a data-quality report flagging missing or incomplete fields. Running this audit in November — before the workflow fires in January — catches data gaps before they become missed RMDs.

Stage 2: Cross-Tool Workflows — The Full RMD Annual Workflow

This is the core of the guide. The full RMD annual workflow in US Tech Automations runs from January through December 31, with 6 major workflow phases.

Phase 1 (January): Eligibility identification.
The workflow queries your CRM for all clients who will be age 73 or older during the current calendar year. It also identifies "first-year" clients (turning 73) who have the option to delay their first RMD to April 1 of the following year — and flags those clients for advisor review of the delay decision.

Phase 2 (January-February): Balance data ingestion.
The platform ingests December 31 prior-year account balances from your portfolio management platform. For Orion and Envestnet users, this is typically available via API or scheduled export by January 10. For custodian-held accounts (Schwab, Fidelity, TD Ameritrade), custodian year-end statements are parsed.

Phase 3 (February): Calculation routing.
For each eligible client, the system uses the IRS Uniform Lifetime Table (or Joint Life and Last Survivor Table for clients whose sole beneficiary is a spouse more than 10 years younger) to calculate the required distribution amount. The calculation is routed to the assigned advisor as a task for review — not sent directly to the client. The advisor confirms or adjusts before the workflow proceeds.

Phase 4 (February-March): Client notification.
After advisor confirmation, a personalized client notification fires: "Your Required Minimum Distribution for [Year] is [Amount]. Here are your options for how to take it." The notification includes: distribution amount, a summary of distribution options (direct deposit, reinvestment in taxable account, direct rollover to charity as QCD), and a scheduling link for a brief review call if the client has questions.

Phase 5 (March-November): Distribution tracking.
US Tech Automations monitors custodian distribution records (or advisor-entered confirmation) for each eligible client. Clients whose distributions haven't been taken by October 31 receive a reminder notification. Clients whose distributions haven't been taken by November 30 trigger an escalation task to the advisor.

Phase 6 (December): Year-end verification.
A final verification pass runs in the first week of December: all clients whose RMD is not confirmed as complete receive an urgent advisor notification. This final check ensures no client reaches December 31 without a confirmed distribution or an explicit advisor decision to delay (first-year clients only).

Bold extractable stats:

RMD penalty: 25% excise tax on undistributed amount per IRS Publication 590-B — making deadline misses one of the highest-cost advisory errors relative to the distribution amount.

SEC-registered RIAs: 15,400+ serving retail clients according to SIFMA 2024 — the vast majority of retiree-serving advisors face this workflow challenge annually.

Stage 3: Predictive and AI-Assisted RMD Optimization

Once the compliance workflow is automated, advanced practices add optimization analysis. These analyses route to advisors as separate tasks alongside the standard workflow:

QCD opportunity identification: Clients over 70.5 can make Qualified Charitable Distributions directly from an IRA to a qualified charity — satisfying up to $105,000 of their RMD annually without the distribution counting as taxable income. The system can flag clients who have charitable giving history in their CRM and route a QCD opportunity note to the advisor.

Distribution timing analysis: Taking the entire RMD in December concentrates income in Q4, which can affect quarterly estimated tax calculations. High-balance clients (large RMD amounts) can be flagged automatically for advisor review of spreading distributions across the year.

Roth conversion candidates: Clients who are pre-RMD age (under 73) with large traditional IRA balances may benefit from Roth conversions to reduce future RMD obligations. A CRM query can surface clients in this profile and route a conversion analysis task to the advisor.

Tool Stack by Stage: Vendor Landscape (Honest)

Common Anti-Patterns in RMD Workflow Management

Understanding what breaks RMD workflows helps you avoid the most common configuration errors.

Anti-pattern 1: Waiting until Q4. RMDs can be taken any time during the calendar year. Advisors who wait until November create unnecessary urgency, increase error risk, and miss QCD and timing optimization opportunities. Start the workflow in January.

Anti-pattern 2: Relying on custodian statements for December 31 balances. Statements often arrive in mid-January, compressing the calculation window. Configure your portfolio management platform to export December 31 balances in the first week of January — most platforms support this.

Anti-pattern 3: Sending distribution amounts to clients before advisor review. Calculation errors or unusual account situations (inherited IRAs, multiple account aggregation) require advisor judgment before the number reaches the client. The workflow must include an advisor approval step.

Anti-pattern 4: No escalation for non-responsive clients. If a client hasn't taken their RMD by November and isn't responding to email, the workflow needs to escalate to a phone call — not another automated email. Configure the escalation path explicitly.

Anti-pattern 5: No documentation for first-year delay decisions. First-time RMD clients can delay to April 1 of the following year. Document the rationale in the CRM. The platform logs this automatically when the advisor selects "delay approved" in the approval task.

Bold extractable stat:

Mid-size RIA annual compliance cost: $750K-$1.5M according to the FINRA 2024 small firm cost study — RMD errors that result in client tax penalties can add material legal and reputational cost on top of direct compliance spending.

Honest Vendor Comparison: USTA vs Redtail CRM for RMD Workflows

Where Redtail CRM wins: Redtail's compliance archiving, established advisor install base, and integration with Schwab and Fidelity custodians make it the right CRM for RIA compliance operations. The client data foundation that makes the RMD workflow possible lives in Redtail.

Where US Tech Automations wins: Redtail doesn't natively automate the annual RMD workflow — it stores the data, but the eligibility query, balance ingestion, calculation routing, client notification, and escalation logic all require manual steps or external tools. The platform provides the workflow orchestration that transforms Redtail data into a systematic annual process.

How to Build It: 8-Step Implementation

How does a financial advisory firm build an RMD calculation annual workflow in US Tech Automations?

1. Run the foundational data audit. Query your CRM for all clients age 70+ and audit the 6 data fields listed in Stage 1: DOB, account numbers, account type classification, prior-year balance source, beneficiary designations, and first-RMD-year status. Fix gaps before the workflow fires.

2. Connect your CRM to the platform. Establish the API connection to Redtail or Wealthbox. Map the fields the system will read: client ID, date of birth, account numbers, account type, and assigned advisor. Configure the API write-back for activity logs and task creation.

3. Connect your portfolio management platform. Configure a scheduled export (January 5-10) of December 31 prior-year account balances from Orion, Envestnet, or Tamarac. The platform ingests this file and maps balances to client accounts by account number.

4. Configure the January eligibility trigger. Set a January 2 trigger date (configurable) that fires the eligibility query: pull all clients with a DOB indicating age 73+ in the current year. Flag first-year clients separately. Output is the RMD-eligible client list for the current year.

5. Build the calculation routing task. For each eligible client, the system generates a task for the responsible advisor: client name, account number, December 31 balance, applicable life expectancy factor, calculated RMD amount, and first-year delay eligibility flag. The advisor reviews and approves or adjusts.

6. Build the client notification template. Create a personalized email template that includes: client first name, RMD amount, distribution options (direct deposit to bank account, check, direct to charity as QCD), deadline (December 31 or April 1 for first-year), and a scheduling link for a distribution review call. Client-specific fields populate from CRM and calculation data.

7. Configure the tracking and escalation schedule. Set follow-up triggers: October 31 — send distribution reminder to clients without confirmed completion; November 30 — send escalation task to advisor for all clients without confirmed completion; December 1 — mark all unconfirmed clients as high-priority for advisor outreach.

8. Set up year-end verification report. On December 15, the system generates a report showing every eligible client, their RMD status (complete, in-progress, delayed, not started), and the advisor assigned. This final report gives the team 2 weeks to close any remaining gaps before the December 31 deadline.

For the new client welcome workflow that introduces clients to the advisory relationship before RMDs become relevant, see how to build a new client welcome sequence in US Tech Automations.

For the financial client onboarding workflow that establishes the data foundation RMD automation relies on, see financial client onboarding automation how-to.

FAQs

What happens if the portfolio management platform doesn't have an API?

Many portfolio management platforms support scheduled CSV or Excel exports if they don't offer an API. The platform ingests scheduled file exports from a shared folder (Google Drive, SharePoint, or an SFTP server). The balance data arrives on the same schedule — the system parses the file and maps balances to client records by account number.

How does the workflow handle inherited IRA RMDs?

Inherited IRA RMDs follow different rules (10-year rule for most non-spouse beneficiaries, life expectancy rule for eligible designated beneficiaries). Accounts tagged as "Inherited IRA" in the CRM route to a separate calculation path the advisor manages directly, bypassing the standard Uniform Lifetime Table calculation.

Can the workflow handle multiple IRA accounts for the same client?

Yes. The IRS allows aggregation across IRA accounts — you can take the total RMD from one or more accounts. The system sums December 31 balances across all IRA accounts tagged to a client and calculates the aggregate RMD amount.

How do we handle clients who want to take their RMD as a Qualified Charitable Distribution?

The workflow includes QCD as a distribution option in the client notification template. When a client selects QCD, the system routes a QCD coordination task to the advisor — the direct custodian-to-charity transfer requires specific paperwork that the advisor manages. The workflow tracks the QCD completion and marks the RMD as satisfied when the custodian confirms the transfer.

What is the excise tax for missing an RMD?

The SECURE 2.0 Act (2022) reduced the excise tax for missed RMDs from 50% to 25% of the undistributed amount, with a further reduction to 10% if the distribution is taken within the correction window. This is still a material penalty — on a $50,000 RMD, a miss could cost a client $12,500 in excise tax. For this reason, the December 31 deadline is treated as a hard deadline in the workflow, not a target.

How long does the full workflow take to configure?

With established CRM and portfolio management connections, the full workflow takes 2-3 weeks to configure and test. The testing phase should include 5-10 historical client records to confirm calculation accuracy before going live.

Does the platform calculate the RMD itself, or does the advisor calculate it?

US Tech Automations performs the initial calculation using the prior-year-end balance and the applicable IRS life expectancy factor (Uniform Lifetime Table for most clients). The calculation is routed to the advisor as a task — the advisor reviews and confirms before any client communication. The advisor retains full responsibility for the final RMD amount; the platform provides the starting calculation and the workflow structure.

Glossary

Required Minimum Distribution (RMD): The minimum annual withdrawal IRS rules require from tax-deferred retirement accounts (Traditional IRA, SEP-IRA, SIMPLE IRA, 401k, 403b, 457b) once you reach age 73.

Uniform Lifetime Table: The IRS table used to calculate RMDs for most account owners; life expectancy factors decrease annually, increasing the required distribution percentage each year.

Qualified Charitable Distribution (QCD): A direct IRA-to-charity transfer that counts toward the RMD and is excluded from taxable income. Available to IRA owners age 70.5 and older, up to $105,000 annually.

First-year delay option: Allows a client's first RMD (year they turn 73) to be delayed until April 1 of the following year — resulting in 2 RMDs in that second year.

Excise tax: IRS penalty for missing an RMD deadline — 25% of the undistributed amount, reducible to 10% if corrected within the correction window.

Eligible designated beneficiary: IRA beneficiary category (surviving spouse, minor child, disabled/chronically ill individual, or person within 10 years of owner's age) eligible for life-expectancy RMD treatment rather than the 10-year rule.

Portfolio balance aggregation: Summing December 31 prior-year balances across all IRA accounts owned by a single client to derive the total annual RMD amount.

Request a Demo: Build Your RMD Annual Workflow

RMD deadlines are non-negotiable. Advisors who manage them systematically spend far less time and carry far less risk than those relying on spreadsheets and manual reminders.

The platform builds the eligibility identification, balance ingestion, calculation routing, client notification, and year-end verification workflow so your team can confidently close every RMD before December 31.

Request a demo with US Tech Automations to see the RMD annual workflow configured for your CRM and portfolio management platform.