IRS Forms

Form 990 Schedule D Guide – Donor‑Advised Funds, Endowments

Form 990 Schedule D made simple. Learn the triggers, how to report donor‑advised funds and endowments, disclose collections and escrow accounts, and reconcile audits in Parts XI and XII with clear Part XIII notes.

Accountably Editorial Team 13 min read Nov 27, 2025 Updated Nov 27, 2025
I still remember a late February call with a nonprofit CFO who was calm about revenue but worried about one thing, Schedule D. Not the form itself, the fear of getting tripped up by donor‑advised funds, endowments, and that GAAP to Form 990 reconciliation. If that sounds familiar, you are in the right place.

You will see exactly when Schedule D applies, what to disclose, and how to keep auditors and regulators comfortable without turning month end into a fire drill.

If you answer Yes on Form 990 Part IV lines 6 through 12a, you attach Schedule D and complete only the parts those lines trigger. Parts XI and XII are required only if you received audited financial statements and marked Yes on line 12a.

Key Takeaways

  • You attach Schedule D when Form 990 Part IV lines 6 through 12a are Yes, then you complete only the applicable parts.
  • Schedule D covers donor‑advised funds, conservation easements, collections, escrow or custodial arrangements, endowments, and specific asset and liability details.
  • If you have audited financials and answered Yes on Part IV line 12a, complete Parts XI and XII to reconcile audited totals to Form 990. Use Part XIII for explanations.
  • Many triggers tie back to Part X thresholds, for example 5 percent of total assets for certain investments and other assets, and land, buildings, and equipment on line 10a requires Part VI.
  • As of December 2024, the IRS made Schedule D instructions continuous use, which means they apply for tax year 2024 and later until replaced. Always check for updates before filing.

What Schedule D Is and Why It Matters

Think of Schedule D as the transparency layer on top of your core Form 990. It pulls forward the items donors, boards, auditors, and the IRS care about most, donor‑advised funds, endowments, collections and conservation easements, escrow and custodial balances, and breakouts of assets and liabilities that can materially affect how people read your financial position. The checklist in Part IV of Form 990 decides which parts you must complete, so you save time by focusing on the items you actually have.

If your organization has audited financial statements and you marked Yes on Part IV line 12a, Schedule D also becomes the bridge between GAAP and the return. You reconcile revenue and expenses so the 990 tells the same economic story your audit tells, just in tax form language. You will use Part XIII for short, plain explanations so anyone reviewing your return understands why numbers differ.

Who Must File Schedule D

Use the Part IV Checklist of Required Schedules. If any of lines 6 through 12a are Yes, you must attach Schedule D and complete the parts that apply. Lines 6 through 9 cover donor‑advised funds, conservation easements, collections, and escrow or custodial arrangements. Lines 10 through 12a cover endowments, certain asset categories, other liabilities, and the audited financials reconciliation. If you answered Yes to 12b, Parts XI and XII are optional, not required.

Several triggers connect to the balance sheet on Form 990 Part X. For example, if program‑related investments or other assets are at least 5 percent of total assets, you will complete the related Schedule D sections. If Part X line 10a, land, buildings, and equipment, has a balance, Part VI of Schedule D is required. These links explain why tracking thresholds during the year, not just at filing, prevents last‑minute scrambles.

Organizations eligible for Form 990‑EZ usually do not file Schedule D, since most of these triggers sit on the full Form 990. If you do file a full 990 by choice, you must include all required schedules, including Schedule D if the checklist says so.

When You Must Attach Schedule D

Here is a simple way to make the decision fast.

  • Check Part IV lines 6 to 12a on Form 990.
  • For each Yes, complete the linked Schedule D part.
  • If you reported escrow or custodial amounts on Part X line 21 or you act as an agent for funds that are not on your Part X balance sheet, complete Part IV of Schedule D and explain terms in Part XIII. Credit counseling and similar arrangements belong here.
  • If you received audited financials and marked Yes on Part IV line 12a, complete Parts XI and XII, then use Part XIII to explain key reconciling items.

Tip, do a quick crosswalk before you start the return. Map each potential trigger to your ledger account codes and supporting files so your team can pull what they need in minutes, not hours.

Donor‑Advised Funds, the Definition You Must Use

If you checked Yes on Part IV line 6, complete Schedule D Part I. A donor‑advised fund is a separately identified fund or account that your organization owns and controls, and a donor or donor advisor has, or expects to have, advisory privileges over distributions or investments. This IRS definition is specific, use it before you decide what belongs in Part I.

There are clear exclusions. A fund that distributes only to a single named organization, or a scholarship‑type fund where advice is given only through an independent committee with safeguards, is not a donor‑advised fund for Schedule D. The instructions also allow the Secretary to exempt certain committee‑advised or single‑purpose funds. When in doubt, test your facts against the exceptions before you report.

You will list contributions in, grants out, and ending book balances for donor‑advised funds held during the year, then keep your narrative tight in Part XIII to explain custodial mechanics or differences from your financial statement presentation. This keeps your audit trail clean and your reviewer happy.

How to Report Donor‑Advised Funds, a Practical Walkthrough

Start with the Part I grid. Include every donor‑advised fund held at any point in the year, not just at year end. Track contributions, distributions, and year‑end balances. If your financials treat some arrangements as liabilities or agency funds under GAAP, remember, the IRS definition controls for Schedule D purposes. You can clarify GAAP versus Form 990 treatment in Part XIII so the audit story and the return stay aligned.

Quick classification table you can adapt

Fund or Account Advisory Privileges DAF Status Custody Notes
Community Giving A Yes, donor recommends grants DAF Held by sponsor
Scholarship Pool B Committee, donor has no control Not a DAF Committee meets independence rules
Single Beneficiary C Grants only to one named charity Not a DAF Single‑organization exclusion applies

Keep the support behind each call. Save the governing documents, committee charters, and correspondence that show who can advise and how grants are approved. If something changes midyear, add a short note in Part XIII so the timeline is clear.

GAAP versus IRS, what to reconcile

Your audit might net investment fees, include unrealized gains in investment income, or present agency‑like balances differently. On Schedule D, Parts XI and XII are where you reconcile audited revenue and expenses to the 990. Only include investment expenses netted against investment income on line 4a of the reconciliations. Use Part XIII for brief explanations, for example unrealized gains removed from revenue, or investment fees shown gross on the return.

One common pitfall is donated services. GAAP can present donated services in notes or even on the face of statements in certain models, but Form 990 does not treat donated services as revenue. Describe them in Part III of the core return if they are mission critical, do not record them as revenue in Part VIII, and do not try to force them into Schedule D reconciliations as income items.

Conservation Easements, what Part II expects

If you marked Yes on Part IV line 7, complete Part II. Report the count of easements that were modified, transferred, released, extinguished, or terminated during the year. Then use Part XIII to explain each change. The instructions are clear that amending, assigning, or otherwise altering an easement is a reportable event, which means you should keep clean documentation of monitoring and enforcement activity, site visits, violations, and outcomes.

Tie revenue reporting for qualified conservation contributions to your books and financials, then keep the cross references consistent on Schedules A, B, and M if those apply to the same gifts. Clear cross‑references will save you time later if an examiner requests tie outs.

Endowment Funds, how to present five years with confidence

If you marked Yes on Part IV line 10, complete Part V for endowments. Follow FASB ASC 958 definitions. Separate donor‑restricted endowments, permanent and term, from board‑designated, also called quasi endowments. Report beginning balances, contributions, investment earnings and losses, appropriations for spending, fees, and ending balances, for the current year and the prior year, and disclose percentages held in each category at year end. If another organization holds endowment funds for your benefit, include that information as well.

Use Part XIII to explain your spending policy in plain language, for example a five percent draw based on a multi‑year average, any board actions that moved amounts into or out of quasi endowments, and whether you have underwater endowments. If you follow ASC 958, keep your note disclosures and Part V aligned, the same categories and logic will make your reviewers’ lives easier.

Practical checklist you can run before filing:

  • Map each endowment column to the general ledger and investment statements.
  • Reconcile realized and unrealized activity to manager reports.
  • Confirm appropriations match board minutes and policy.
  • If funds are underwater, prepare a one line explanation of policy and impact for Part XIII.

A quick word on capacity and workflow. If your team is already buried in close and audit support, set a mini calendar for Schedule D items right after the audit fieldwork window. That habit turns five years of endowment data from a time sink into a copy, paste, verify task, and it protects review time for actual analysis, not chasing numbers.

Assets, Liabilities, and Investment Disclosures, how to avoid late‑night fixes

When Schedule D is triggered by Part IV and Part X thresholds, your goal is simple, make your balance sheet easy to trust. That means clean workpapers, clear naming, and a short narrative for anything that could confuse a reviewer. You will likely touch three core areas, fixed assets, securities and program‑related investments, and other liabilities.

Fixed assets, Schedule D Part VI

If Part IV line 11a is Yes or Form 990 Part X line 10a is nonzero, complete Part VI. Lay out land, buildings, and equipment by class, then show cost or basis, accumulated depreciation, and ending book value. Separate assets used in operations from investment real estate, since review notes and ratios often depend on that split.

Practical steps you can run in one sitting:

  • Verify beginning balances to last year’s filed return and audit. If you had a prior‑period adjustment, describe it briefly in Part XIII so the trail stays clean.
  • Tie additions and disposals to the fixed asset subledger, invoices, and board approvals when needed.
  • Recalculate depreciation for reasonableness. Agree methods and useful lives to policy, then cross‑foot totals back to the trial balance.
  • If you hold investment real estate, present it separately and keep rent roll support in the file.
  • Use a short naming convention, for example “FA‑Bldg‑MainOffice” or “FA‑Equip‑StudioA,” so reviewers can scan quickly.

A quick internal review trick, export the fixed asset roll‑forward into a one page summary that mirrors the Part VI rows. Reviewers spend less time hunting and more time approving.

Securities and program‑related investments, Parts VII and VIII

Parts VII and VIII are triggered by Part X thresholds, often the 5 percent of total assets rule. Start by confirming whether other securities or program‑related investments meet or exceed 5 percent of total assets at year end. If they do, complete the applicable part. Identify closely held stock and any case where you hold 5 percent or more of a single class of publicly traded stock. Then document valuation methods, for example quoted market prices or manager statements, and keep any Level 3 valuation memos with your file.

Simple threshold check you can copy:

  • Total assets at year end, 50,000,000
  • 5 percent threshold, 2,500,000
  • Other securities balance, 2,900,000, Part VII required
  • Program‑related investments, 1,100,000, below threshold, Part VIII not required

Cross‑check the amounts to general ledger accounts, custodial statements, and any audit footnotes. If your audit nets investment expenses, remember that the return shows revenue and expenses on a gross basis, and you will reconcile that later in Parts XI and XII.

Other liabilities, Schedule D Part X

Part X looks simple, and it is, if you slow down for ten minutes. Confirm the trigger first, a Yes on Part IV lines 11e or 11f or an amount on Part X line 25, then present a breakdown of other liabilities that agrees to the balance sheet. Use separate lines for federal income tax liability and related party payables. If you have an uncertain tax position recorded under GAAP, include it here and use Part XIII to explain what it represents. If your audit includes contingencies that do not meet recognition thresholds, do not record them as liabilities on the return, keep the explanation in the notes and the workpapers.

A short disclosure often saves a week of back and forth. For example, “Includes accrued excise tax on investment income and payable to related supporting organization, settled in April 2026.” That one sentence sets expectations and shows control.

Year‑round workflow so Schedule D stops being a scramble

When teams rush, quality slips. A few small habits make Schedule D a normal part of close, not a one‑time panic.

  • Add tags for Schedule D in your chart of accounts, for example D‑PartVI for fixed asset classes or D‑PartVII for other securities. Reviewers can filter the ledger and get a clean pull in seconds.
  • Keep a tiny Part XIII library. Any time you write a clear explanation for an audit footnote or a board packet, drop that sentence into a shared doc. At filing time, you have ready‑made narratives.
  • Build a one page “Audit to 990” map. List common reconciling items, unrealized gains, donated services, and netted investment fees, and where they land on the return.
  • Use a two‑stage review, preparer to senior, then a quality pass that only checks tie‑outs and narratives. This keeps partner time focused on real risk, not formatting.
  • If your internal capacity is thin during peak season, consider a controlled offshore workpaper track. The key is structure, SOPs, standard naming, and a layered review. At Accountably, we have seen firms cut Schedule D review time by standardizing workpapers, setting turnaround SLAs, and adding a short, consistent Part XIII note for every triggered section. The method matters more than headcount.

If you close the books with Schedule D in mind, March feels a lot calmer. Your reviewers will thank you, and your audit will move faster because the documentation is already squared away.

Reconciling audited financials to Form 990, Parts XI and XII without the guesswork

If you answered Yes on Part IV line 12a, you received audited financial statements, and Parts XI and XII are required. Start with audited totals for revenue, gains, support, and expenses. Then list reconciling items so the return tells the same story, just in the IRS format.

What usually changes:

  • Remove unrealized gains or losses that are included in audited revenue but do not belong in Form 990 Part VIII revenue.
  • Reverse donated services and use the narrative in the core return to acknowledge them, because they are not revenue on the 990.
  • Gross up investment income and investment expenses if the audit nets them. The 990 shows both, which means you add back the fees to revenue and show the expense in Part IX.
  • Reclassify grants or agency transactions where the audit shows them in a different section, for example grants made that need to move to the grants line in Part IX.
  • Align restricted activity. The audit tracks releases from restriction using GAAP rules. The 990 focuses on the character of the revenue and expense. Your notes in Part XIII explain any timing differences.

A simple example flow:

  • Audited total revenue, 12,000,000
  • Less unrealized gains, 800,000
  • Less donated services, 150,000
  • Add investment fees netted in audit, 120,000
  • Form 990 Part VIII total, 11,170,000

Write a line or two in Part XIII for each reconciling item. Keep it plain, for example “Audit presents investment income net of 120,000 of fees, Form 990 presents revenue and expense gross.” That shows the reviewer you understand the rule and applied it on purpose.

FAQs

What common Schedule D mistakes trigger IRS questions?

Most letters come from missing triggered parts, numbers that do not tie to Part X, unexplained reconciliation items, or inconsistent reporting across Schedules D, A, B, and M. Prevent these by running a pre‑file tie‑out, confirming each Yes on Part IV has a matching Schedule D part, and adding a one line explanation in Part XIII for any odd movement.

What documentation should we keep for Schedule D?

Keep board minutes, endowment policies and spending approvals, custodian statements, fixed asset roll‑forwards with invoices, appraisal and valuation reports, escrow or agency agreements, monitoring logs for conservation easements, and the audit to 990 reconciliation worksheet. Add a short index so an examiner can tie from the return to the workpaper in a single step.

How do fiscal year changes affect Schedule D parts?

Update column headings to the correct tax year, then make sure your five‑year endowment table still covers the right periods. Use Part XIII to explain any partial year, conversion entry, or restatement, and reference the audit note that shows the change.

Are mergers or dissolutions midyear a big deal for Schedule D?

Yes, and they can be handled cleanly. Update endowment and asset tables to reflect transfers in or out, revise other liabilities for assumed or settled items, and explain material events in Part XIII with dates and amounts. Keep the merger agreement and closing statements in the file so your tie‑outs are easy.

Do software mapping choices affect Parts XI and XII?

They do. If your accounting or tax software nets investment fees, your reconciliation will be wrong unless you add the fees back to revenue and record the expense separately. Review your mapping for donated services, unrealized gains, and agency transactions before you finalize the return.

How can we speed up review without losing control?

Standardize the file. Use consistent names for workpapers, keep a one page summary for each triggered part, and add a pre‑review checklist that verifies ties to Part X and the trial balance. Many teams save hours by keeping a living Part XIII library of trusted explanations they can copy and adjust.

Wrap up and next steps

Schedule D rewards preparation. When you start with the Part IV checklist, keep tight support for endowments, securities, fixed assets, and other liabilities, and write short explanations for your GAAP to 990 differences, you lower the chance of surprises and keep the audit in sync with the return. You also protect board confidence, because the numbers line up and the story is clear.

If your team wants help turning this into a repeatable system, consider a structured workpaper and review model. At Accountably, we integrate trained offshore teams into firm workflows with SOP‑driven files, layered review, and predictable turnaround, which reduces revision cycles and partner review time. Use that capacity to focus on the calls only you can make, policy, stewardship, and strategy.

Key actions you can take this week:

  • Run a five‑minute threshold check against Part X to see which Schedule D parts will trigger.
  • Build a one page audit to 990 map for common reconciling items.
  • Create a small Part XIII library, start with endowment spending policy, investment fee gross up, and unrealized gain removal.
  • Add Schedule D tags to chart of accounts and fixed asset classes so pulls are instant at year end.

Every Form Represents Work Your Team Has to Deliver

Accountably embeds trained offshore teams into your workflow – so your firm handles more returns without more burnout.

30-Day Guarantee 150+ Firms SOC 2 Aligned