AI-Read a 1040 in Holistiplan — Tax Memo Plus QCD Election Workflow
Holistiplan reads a 1040 — a 1040-SR, a K-1, a Schedule E, a Schedule C — and produces a structured tax-return extract in roughly ninety seconds. The extract surfaces five highest-leverage planning opportunities consistently across the universe of advisor clients: the Roth conversion ladder (bracket fill to top of 22% or 24% with IRMAA cliff awareness), the tax-loss harvesting threshold ($3,000 ordinary offset + carryforward under IRC §1211), the QCD eligibility checkpoint (age 70.5+ under IRC §408(d)(8)), the charitable bunching strategy via a donor-advised fund, and the IRMAA two-year-lookback bracket management. For a client past 70.5 with charitable intent, the QCD election workflow is the highest-leverage of the five — and the most tightly bounded by tax law, custodian process, and Reg BI documentation. This lesson installs both: the five-opportunity scan from any Holistiplan extract, and the end-to-end QCD election workflow with QCD-vs-itemized comparison, IRMAA modeling, donor-letter generation, custodian QCD form package (Schwab, Fidelity, Pershing), and the Reg BI rationale memo.
Holistiplan as the Leverage Engine
Holistiplan's 10,000-firm install base by 2026 and its 2026 Enterprise Advisory Board announcement reflect a category benchmark position. The platform reads scanned or PDF tax returns via OCR-plus-LLM extraction and produces structured data: filing status, AGI / MAGI, taxable income, marginal and effective brackets, itemized vs standard deduction position, charitable contributions, capital gain / loss positions, qualified vs ordinary dividends, IRA / Roth contributions and distributions, RMD evidence, state tax, foreign tax credit, AMT exposure. The platform also flags year-over-year changes and surfaces planning opportunities via its own rules engine.
The advisor's job is to layer judgment on top of Holistiplan's extraction. Holistiplan surfaces a "Roth conversion opportunity"; the advisor evaluates whether the client's IRMAA cliff distance and pro-rata basis position make the recommendation defensible. Holistiplan flags "$8,400 unrealized losses"; the advisor checks wash-sale exposure under IRC §1091. Holistiplan notes "client age 71"; the advisor knows that means QCD eligibility under §408(d)(8) and a different RMD calendar under SECURE 2.0. The L2 Ch1.2 catch reflex applies at every step: verify the extracted figures against the source PDF, verify IRC citations, verify client-fit.
The Five Highest-Leverage Opportunities From a Holistiplan Scan
Opportunity 1 — Roth Conversion Ladder (Bracket Fill With IRMAA Awareness)
For clients with pre-tax IRA balances and a marginal bracket below 24% (post-TCJA 22% or 24% MFJ ranges depending on year), the Roth conversion to the top of the current bracket is high-leverage tax arbitrage. The advisor must check: (a) MAGI distance to next IRMAA cliff (two-year-forward Medicare premium impact), (b) pro-rata rule against aggregated pre-tax IRA basis under IRC §408(d)(2) read with §72(e)(8), tracked on Form 8606, (c) five-year clock implications (per-conversion clock + the contribution clock confusion from L2 Ch1.2), (d) state tax impact, (e) NIIT considerations. The L3 Ch2 50-household Roth conversion screen and L3 Ch2.2 per-client conversion sizing memo develop this at scale; the L2 Ch4 lesson surfaces it from the single-client tax scan.
Opportunity 2 — Tax-Loss Harvesting ($3,000 Ordinary Offset + Carryforward)
Capital losses under IRC §1211 offset capital gains without limit; up to $3,000 of net losses offset ordinary income annually; excess carries forward indefinitely under IRC §1212. Holistiplan flags TLH opportunities from the broker statement extract; the advisor verifies via Orion or the custodian. The wash-sale rule under IRC §1091 requires 30-day window absence on substantially identical securities. The L3 Ch1.1 workflow audit treats TLH as a recurring high-leverage workflow; the L2 Ch4 surface introduces the recognition.
Opportunity 3 — QCD Eligibility (Age 70.5+ Under IRC §408(d)(8))
Qualified Charitable Distributions allow IRA owners 70.5 or older to direct up to $108,000 (2025; verify current year via SSA / IRS source) per person from a traditional IRA directly to a qualified charity, excluding the distribution from gross income. QCDs satisfy RMDs (for clients 73+) dollar-for-dollar and — critically — reduce AGI, which itemized deduction-based charitable giving does not. The QCD election workflow is the lesson's central deep-dive below.
Opportunity 4 — Charitable Bunching With a Donor-Advised Fund
For clients whose annual charitable giving + state-and-local-tax cap puts them just below the standard deduction threshold, bunching multiple years of charitable giving into a single year via a donor-advised fund can flip them from standard to itemized for that year while preserving the giving cadence over time. The DAF receives the bunched gift in year 1 (full itemized deduction at the cliff year); grants flow from the DAF to the client's charities across years 1-3-5. Appreciated public stock to a DAF generally qualifies for the 30%-of-AGI capital-gain-property limit with five-year carryforward under IRC §170(b)(1)(C). Holistiplan flags charitable position; the advisor designs the bunching strategy.
Opportunity 5 — IRMAA Two-Year-Lookback Bracket Management
Medicare Income-Related Monthly Adjustment Amounts (IRMAA) for Part B and Part D premiums are based on MAGI from two years prior. A client whose current-year MAGI pushes into a new tier will see Medicare premium increases two years out. The planning lever: design current-year income (Roth conversion sizing, capital gain harvesting timing, deferred-comp election under IRC §409A, QCD usage) to stay below cliff thresholds. The L3 Ch4.2 lesson on Medicare IRMAA + coordinated income smoothing develops this in detail; the L2 Ch4 surface introduces the recognition.
The QCD Election Workflow — Deep Dive
The QCD election is the lesson's deep workflow because it sits at the intersection of tax law (IRC §408(d)(8)), RMD compliance (IRC §401(a)(9) under SECURE 2.0), IRMAA management, and charitable strategy. For a client 70.5 or older with charitable intent, the QCD typically beats the itemized-deduction alternative; the workflow that compares them and documents the recommendation closes the planning loop.
QCD vs Itemized Deduction Comparison
The choice between QCD and itemized-deduction charitable giving turns on the AGI impact. QCD reduces AGI directly (the distribution never enters AGI), which lowers Medicare IRMAA bracket exposure, NIIT, the Social Security taxability threshold, and any AGI-floor-based phaseouts. Itemized charitable deduction is "below the line" — it reduces taxable income but does not reduce AGI. For a client who is anywhere near an IRMAA cliff, a NIIT threshold, or any AGI-floor-based limitation, QCD wins on AGI mechanics regardless of itemized vs standard-deduction position.
For a client well below any AGI-sensitive threshold who is comfortably itemizing (large state tax above the SALT cap, large mortgage interest), the itemized charitable deduction provides similar dollar benefit. For a client below the standard-deduction threshold who would not have itemized anyway, QCD provides full AGI-reduction benefit that the standard-deduction-taker could not have captured.
The comparison matrix: (i) current-year AGI position, (ii) IRMAA distance, (iii) Social Security taxability bracket, (iv) NIIT threshold position, (v) state tax interaction, (vi) RMD requirement (if 73+, QCD also satisfies RMD), (vii) standard-vs-itemized position.
IRMAA Modeling
The QCD's IRMAA impact is two years forward. A client whose 2026 MAGI without QCD would put them at the third IRMAA tier two years out can — by directing $50,000 of RMD via QCD instead of cash distribution — drop one or two tiers, saving ~$2,000-$4,000 per person per year in Medicare premiums in 2028. For a couple, this is $4,000-$8,000 per year. The L3 Ch4.2 lesson develops the modeling; the L2 Ch4 QCD workflow assumes the modeling and routes through it.
Donor-Letter Generation
Each charitable recipient of the QCD must provide a contemporaneous written acknowledgment for the donor's records under IRC §170(f)(8). The acknowledgment must include: the donor's name, the amount of the contribution, a statement that no goods or services were provided in return (or a description and good-faith estimate if any were), and the date. The QCD-specific addition: the letter should explicitly note that the contribution was a QCD from the donor's IRA, so the donor can substantiate the QCD treatment on their 1040 (the QCD is reported on Form 1040 line 4a with the QCD-excluded portion on line 4b with the notation "QCD" — Holistiplan handles this on the extraction side; the L2 Ch4 advisor handles the documentation side).
The locked prompt for donor-letter drafting: "You are a senior CFP-certificant advisor drafting a donor-letter template for a QCD client. Client: [Name], age [Age], IRA custodian [Schwab / Fidelity / Pershing], charity recipient [Name], EIN [EIN], QCD amount [$X]. Draft a sample acknowledgment letter the charity should provide back to the donor, containing donor name, contribution amount, no-goods-or-services-provided statement, date, QCD treatment note, and the standard contemporaneous-acknowledgment language under IRC §170(f)(8). Format as a one-page template the charity's executive director can sign. Constraints: do not invent the EIN; do not draft on charity letterhead (the charity provides that); do not include legal advice (note 'consult tax advisor for tax treatment')."
Custodian QCD Form Package (Schwab, Fidelity, Pershing)
Each major custodian has a QCD election form (Schwab "Qualified Charitable Distribution Authorization," Fidelity "Charitable Distribution Form," Pershing "Charitable Distribution Request"). The form requires: IRA account number, distribution amount, recipient charity name + address + EIN, payee instructions (check direct to charity), donor signature with Medallion guarantee in some cases. The QCD must be transferred directly from the IRA to the charity — never received by the donor first, even briefly, or the QCD exclusion is lost. Custodian processing typically takes 10-15 business days; late-Q4 QCDs targeting RMD satisfaction must be initiated by mid-November at latest to clear by December 31.
The L2 Ch7.1 NIGO pre-check lesson covers the package coordination; the L3 Ch3.1 RMD calendar lesson surfaces the timing constraint at scale; for L2 Ch4 the discipline is that the workflow includes the form-package preparation as an output, with the SLA tag for mid-November initiation for year-end QCDs.
Reg BI Rationale Memo
The QCD recommendation is a Reg BI recommendation under §240.15l-1; the memo documents the consideration of alternatives and the client-specific rationale. The alternatives to enumerate: (a) cash distribution from IRA + itemized charitable deduction (the comparison above), (b) cash from taxable brokerage + itemized charitable deduction (different AGI impact), (c) appreciated public stock from taxable brokerage to charity (different basis treatment), (d) DAF bunching strategy (different multi-year pattern), (e) no charitable giving (rejected per client's stated intent).
The Care Obligation §240.15l-1(a)(2)(ii) requires documenting the client-specific reason for the QCD recommendation. Typical reasons: IRMAA bracket avoidance + RMD satisfaction + client's stated charitable cadence preference + the simplicity of QCD execution vs DAF. The L2 Ch7.2 lesson's four-alternative framework (originally rollover) generalizes to other Reg BI recommendations including QCD; the L2 Ch4 surfaces the QCD-specific application.
The Locked Orchestration Prompt for the QCD Workflow
Role. You are a senior CFP-certificant advisor running the QCD workflow for a charitably-inclined client age 70.5 or older. You never invent facts and you cite IRC sections only when I have provided them.
Context. Client [Name], age [Age], filing status [MFJ / single / HoH], current-year MAGI projected [$X], IRA balance at [Custodian] [$Y], RMD required this year [$Z if 73+, else N/A], charitable intent: [target $ amount to which charities, named]. IRMAA two-year-forward bracket position: [tier + distance to next cliff]. State of domicile: [State]. Itemizing this year (estimated): [yes / no].
Task. Produce: (1) QCD-vs-itemized comparison table with AGI impact, IRMAA impact, Social Security taxability impact, NIIT impact, state tax impact, RMD satisfaction impact. (2) Recommendation: QCD or itemized, with rationale. (3) Donor-letter template for each named charity. (4) Custodian QCD form package referencing the named custodian's specific form. (5) Reg BI rationale memo enumerating the five alternatives (cash + itemized, taxable cash + itemized, appreciated stock, DAF bunching, no giving) and the client-specific rationale.
Format. Comparison table as Markdown. Recommendation as one paragraph. Donor-letter template as draft text. Custodian package as a checklist of required fields. Reg BI memo as four-paragraph structure (recommendation, alternatives, rationale, client affirmation pending).
Constraints. (1) Do not invent the IRA balance, MAGI, IRMAA tier, or RMD amount — use only the figures I have provided. (2) Cite IRC §408(d)(8) for QCD eligibility (only IRC section I have authorized for this prompt). (3) Do not state the current-year QCD limit unless I have provided it. (4) Do not provide legal or tax advice — frame as "based on the facts you've shared." (5) For any data not provided, write [need: from Holistiplan / RightCapital / Wealthbox]. (6) Marketing language forbidden. (7) Custodian form package must reference the actual custodian's form name; do not invent.
The Archive and Substantiation Loop
The L3 Ch10.1 pipeline archives the five workflow artifacts (comparison, recommendation, donor letter, custodian package, Reg BI memo) under longer of Rule 204-2 (5 yrs) or Rule 4511 (3 yrs). The L4 Ch7 substantiation file uses the QCD workflow as one of the contemporaneous-evidence anchors for any AI-derived planning-capability marketing claim. The L4 Ch3 WSPs cover the principal review of the Reg BI memo before the trade direction is executed.
Key Takeaways
- Holistiplan's 10,000-firm install base reflects category benchmark for 1040 OCR-plus-LLM extraction; the platform surfaces five highest-leverage opportunities consistently — Roth conversion ladder, TLH ($3K + carryforward), QCD eligibility (70.5+ §408(d)(8)), charitable bunching to DAF, IRMAA two-year lookback.
- QCD vs itemized comparison turns on AGI impact — QCD reduces AGI (lowering IRMAA, NIIT, Social Security taxability); itemized is below-the-line and doesn't reduce AGI.
- IRMAA modeling shows real dollar magnitude — directing $50K of RMD via QCD can drop one to two IRMAA tiers, saving $2K-$4K per person per year ($4K-$8K per couple) in 2028 Medicare premiums.
- Donor-letter generation requires IRC §170(f)(8) contemporaneous written acknowledgment with donor name, amount, no-goods-or-services statement, date, plus the QCD treatment note.
- Custodian QCD form package: Schwab "Qualified Charitable Distribution Authorization," Fidelity "Charitable Distribution Form," Pershing "Charitable Distribution Request" — direct charity transfer required (never to donor first); 10-15 business day processing; mid-November initiation deadline for year-end RMD-satisfying QCDs.
- Reg BI rationale memo enumerates five alternatives: cash + itemized, taxable cash + itemized, appreciated stock to charity, DAF bunching, no giving — with client-specific rationale for the QCD selection.
- Archive + substantiation under L3 Ch10.1 pipeline and L4 Ch7 substantiation file; L4 Ch3 WSPs cover principal review of the Reg BI memo before custodian-form execution.
Skill.re