Form 965 (Schedule D) – aggregate foreign cash position guide

Editorial Standards

How we research, review, and update this guide

Every Accountably guide is researched against primary IRS sources, reviewed by a U.S. CPA, and refreshed as guidance evolves. Read our Editorial Guidelines to see how we source, fact-check, and update our content.

The number that decides how much of a Section 965(a) inclusion is taxed at the cash rate versus the non-cash rate is not on Form 965 itself. It comes off Schedule D, line 19, which is the larger of line 17 or line 18. Get that comparison wrong and the 15.5% cash slice and the 8% non-cash slice land in the wrong proportions.

Years after most teams filed the transition tax away, Schedule D still resurfaces because installment and deferral filers keep filing the 965 package annually while a net liability remains, and the schedule runs across eight years. The aggregate foreign cash position pulls in cash, net receivables, and other liquid assets, all stated in U.S. dollars at the spot rate on the measurement dates. As of January 2, 2026, the Rev. January 2019 layout is still current, so keep using it.

Key Takeaways

• Schedule D reports your aggregate foreign cash position across all specified foreign corporations, and that figure drives how much of your Section 965(a) inclusion is treated as “cash” versus “non‑cash,” which then affects the 965(c) deduction (cash earnings face an effective 15.5 percent rate and non‑cash earnings an effective 8 percent rate, so the line 19 figure directly controls how much inclusion lands in the higher bucket – there is no single blended rate).
• The aggregate foreign cash position is the greater of the final cash measurement date amount or the average of the first and second cash measurement dates, and “cash position” includes cash, net accounts receivable, and defined cash‑equivalent assets.
• Amounts must be expressed in U.S. dollars, with translation at the spot rate on the relevant cash measurement dates, including for receivables, payables, and foreign currency balances.
• If you elected 965(h) installments or you have a 965(i) deferral, you continue filing the 965 package annually while any net 965 tax liability remains unpaid, and you must keep paying installments on the statutory 8‑year schedule.
• As of January 2, 2026, the latest IRS listing still shows Schedule D (Form 965) Rev. January 2019 as the current revision, so keep using that layout and attach it with your annual 965 filing when applicable.

What is Form 965 Schedule D

Schedule D, U.S. Shareholder’s Aggregate Foreign Cash Position, is where you compute and report your total foreign cash position across all specified foreign corporations you own directly or indirectly. The Code defines “aggregate foreign cash position” and “cash position,” and those definitions control what belongs on this schedule. In plain terms, you gather each SFC’s cash, net A R, and cash‑equivalent assets, you apply the required measurement dates, then you roll up your pro rata shares to one number that feeds the 965(c) deduction math.

How the “aggregate foreign cash position” is determined

Section 965 says your aggregate foreign cash position equals the greater of two figures:

• The sum of your pro rata shares of each SFC’s cash position on the final cash measurement date, that is, the close of the last tax year of each SFC that begins before January 1, 2018, or
• One half of the sum of your pro rata shares on the first and second cash measurement dates, defined as the close of the tax year immediately preceding the year that ends before November 2, 2017, and the close of the tax year that ends before November 2, 2017.

This is not optional framing. It is the statutory mechanism that pegs your “cash” portion, which then changes your effective rate via the 965(c) deduction and related rate‑equivalent percentages (the look‑back to the two prior measurement dates is Congress’s anti‑stuffing safeguard – without it, taxpayers could have stripped cash out of SFCs just before year‑end to shrink the 15.5 percent cash bucket, which is why §965(c)(3)(A) forces you to use the larger of current‑year or the two‑year average).

What belongs in “cash position”

Cash position includes three buckets:

• Cash
• Net accounts receivable, accounts receivable minus accounts payable
• Cash‑equivalent assets, for example actively traded marketable property with an established market, commercial paper, CDs, government securities, foreign currency, and short‑term obligations under one year, plus any asset the Secretary treats as economically equivalent.

Translate non‑USD amounts at the spot rate on the relevant cash measurement date. The IRS has been explicit that each measurement is expressed in U.S. dollars.

Who must file and when

If you took a Section 965(a) inclusion, you filed Schedule D in the inclusion year. Many taxpayers also continue to file the 965 package annually while any 965 net tax liability remains unpaid under a valid 965(h) installment election or a 965(i) deferral for S corporation shareholders. Corporate filers track their net 965 liability on Form 965‑B, individuals and estates on Form 965‑A, and they keep filing those forms each year until the liability is fully paid or otherwise disposed. Attach the relevant 965 schedules, including Schedule D and Schedule E, with your income tax return for that reporting year.

The 8‑year installment schedule, timing, and annual obligations

If you elected 965(h), your installments follow a back‑loaded schedule, 8 percent in each of years one through five, 15 percent in year six, 20 percent in year seven, and 25 percent in year eight (the year‑eight payment is more than three times the size of any of the first five – taxpayers who elected installments on a 2017 inclusion hit that 25 percent payment in 2025, so plan the cash for it now rather than treating the eight installments as roughly equal). Each installment is due on the unextended due date of your return for that tax year, and the IRS expects installment payments to be made separately and credited to the original 965 tax year. Interest and additions to tax can apply if an installment is late.

As of January 2, 2026, the IRS continues to instruct taxpayers to keep reporting 965 liabilities annually on Form 965‑A or 965‑B for any year in which a 965 amount remains unpaid, and to continue making installments until the balance is zero or a transfer or acceleration applies.

What gets reported on Schedule D

On Schedule D you list each specified foreign corporation, provide identifiers, and compute your pro rata share of that entity’s cash position on the required cash measurement dates. You translate to U.S. dollars where necessary, total all SFCs, and compute the aggregate foreign cash position that ultimately feeds Form 965 and the §965(c) deduction calculation. The IRS’s own materials and internal manuals consistently reference Schedule D and Schedule E together, which is why reviewers expect a clean tie‑out from D to E in your workpapers.

Why the tie‑out to Schedule E matters

Schedule E provides the line‑by‑line detail behind your aggregate cash, so agents and reviewers can see which SFCs, which dates, and which balances support the rolled‑up number. If the math between D and E is off, or if entity identifiers are inconsistent, you are inviting a notice or an adjustment. Keep your file naming, versioning, and cross‑references disciplined to speed the review and protect your deduction position.

Step‑by‑step completion with an audit‑ready checklist

You want Schedule D to pass review on the first round. Use this flow so you do not get trapped in revisions or version ping‑pong.

Step 1, confirm your SFC list and ownership

• Pull the complete list of specified foreign corporations from your Section 965 file.
• Map legal names to consistent short names, and include country, fiscal year‑end, and entity IDs.
• Record your ownership percentages for each measuring date. If ownership changed, document it in a short memo so reviewers are not guessing.

Step 2, gather cash position details by measuring date

• For each SFC, collect balances that belong in “cash position,” cash, net A R, and cash‑equivalents.
• Use source files, bank statements, GL details, and sub‑ledgers.
• Note any offsets or exposures that would distort net A R. Keep it clean and explain your logic in one paragraph per SFC.

Step 3, translate to USD and compute your pro rata share

• Translate non‑USD balances at the required spot rates for each measuring date.
• Apply your pro rata ownership to each SFC’s cash position.
• Show the math once in a transparent workpaper with columns for local currency, FX rate, USD, and pro rata USD. Do not make reviewers chase formulas across tabs.

Step 4, compute the aggregate foreign cash position

• Roll up all SFCs into a single summary tab.
• Label the two figures you must compare for the “greater of” rule, then clearly flag the final result.
• Tie the final aggregate number to the exact line on Schedule D. Cross‑reference that cell to your summary.

Step 5, tie out to Schedule E and the rest of the 965 package

• Every SFC on Schedule D should appear on Schedule E with matching identifiers.
• The D total must reconcile to the E detail.
• Add a one‑page reconciliation that a reviewer can scan in 30 seconds.

Step 6, attach what the IRS expects to see

Use this quick map to keep your package complete.

Attachment	What it includes	Where it ties
SFC cash position detail by measuring date	Cash, net A R, cash equivalents, FX, pro rata	Schedule D, line‑by‑line
Ownership memo	Direct, indirect, and changes	Schedules A, B, and D
E&P and inclusion support	E&P pools, deficits, inclusions	Schedules A–C and E
Rate‑equivalent summary	Cash vs non‑cash split and deduction math	Schedule E and Form 965
Installment support	965(h) or 965(i) statements, Form 965‑A or 965‑B	Annual 965 filing

Workpaper structure that speeds review

If your team is buried, structure will save you. Here is a simple pattern that cuts partner review time.

File naming and version control

• Use consistent names, for example “SFCName_SchD_CashPos_YYYYMMDD_v01.xlsx.”
• Lock a “Final” folder when you reach partner sign‑off.
• Keep a change log, date, who changed it, what changed, and why.

One‑page summaries per SFC

• First page shows the three measuring dates, local balances, FX, USD, and pro rata.
• Second page holds support references, GL extracts, bank statements, and notes.
• If you need more than two pages to explain, add an executive summary at the top.

Review ladder and checklists

• Preparer marks the checklist, senior validates math and FX, reviewer checks tie‑outs, and a final reviewer looks only at cross‑schedule consistency.
• Include a red‑flag section, unusual FX, negative net A R, missing bank confirms, or timing quirks.
• Require comments for any override.

Common errors, and how to fix them fast

• Wrong or missing identifiers, fix by cross‑checking entity names and IDs against prior‑year filings and your master entity register.
• Understated cash position, fix by adding cash‑equivalents and net A R, not just bank balances.
• FX translation errors, fix by anchoring rates to the correct measuring date and showing rates in a locked reference tab.
• D to E mismatch, fix by building Schedule E first, then rolling totals to D and locking both with a reconciliation.
• Installment year oversight, fix by adding a standing calendar reminder and a short annual checklist for 965‑A or 965‑B plus the D and E schedules.

A clean Schedule D is not about heroics. It is about SOPs, consistent workpapers, and a calm review ladder.

A quick example to make this real

Say you own three SFCs. One holds currency and T‑bills, one is heavy on receivables, and one has a mix of money‑market funds and payables. You collect balances on the three measuring dates, translate them, and compute your pro rata shares. On your summary, the average of the first two dates equals 4.8 million, while the final date total equals 5.2 million. Your aggregate foreign cash position becomes 5.2 million. You roll that number into Schedule D, tie it to Schedule E detail, and your 965(c) deduction math follows from the cash versus non‑cash split. A reviewer can follow your logic in two minutes because the trail is linear and labeled.

Where disciplined delivery helps firms scale

Many firms do not stall because they cannot find clients. They stall because delivery breaks under peak load. Schedule D is a classic bottleneck. Without SOPs, standard workpapers, and a layered review, you get rework, missed tie‑outs, and partners stuck in review loops. If your team is stretched, consider a structured offshore delivery model that works inside your systems and templates, follows your SOPs, and keeps continuity even when someone is out. At Accountably, we integrate trained offshore teams into your workflow with standardized workpapers and a multi‑layer review so partners spend less time fixing files and more time on client strategy. Use that kind of structure if you need capacity without chaos.

Measuring dates, FX, and clean examples

You do not want confusion about “which date gets which rate.” Write the rules at the top of your workpaper so every preparer applies them the same way.

The three cash measurement dates you will see

Label	What it means	How you will see it in files
First measuring date	Close of the SFC tax year immediately preceding the year that ends before November 2, 2017	Prior year close, often two periods back
Second measuring date	Close of the SFC tax year that ends before November 2, 2017	The period that ends right before the law’s reference point
Final measuring date	Close of the last SFC tax year that begins before January 1, 2018	The inclusion year’s SFC year end

• Translate non‑USD balances using the spot rate on each measuring date.
• Show the rate source and keep a screenshot or download in your file.
• If a subsidiary books receivables in EUR and the parent reports in USD, translate at the EUR rate as of each measuring date, then apply your pro rata share.

A reviewer should be able to recreate your USD numbers from your local currency columns and the labeled spot rate. If they cannot, fix the workpaper before you route it.

What counts in “cash position” vs what does not

Keep this table in your template so no one guesses.

Include vs exclude quick map

Include in cash position	Notes	Common exclusions	Notes
Bank cash and demand deposits	By currency, reconcile to bank confirms	Inventory, prepaid expenses	Not cash equivalents
Actively traded money‑market funds	Marketable, short duration	Equity method investments	Not cash or cash equivalent for this purpose
Government securities and T‑bills	Short‑term, actively traded	Long‑term notes receivable	Maturity beyond one year
Commercial paper and CDs	One year or less	Intercompany equity balances	Not A R, not cash equivalent
Foreign currency on hand	Translate at spot rate	Derivatives not functioning as cash equivalents	Document treatment separately
Net A R, that is A R minus A P	Show both A R and A P clearly	Deferred tax assets or liabilities	Outside the definition

Tip, put A R and A P in one visible section so the “net” is obvious. If A P exceeds A R for a given SFC, do not net below zero. Disclose the negative in a footnote and show zero for “net A R” in the cash position.

A short case study you can relate to

A regional firm inherited a client with five SFCs and an installment election in place. The prior files mixed cash and noncash details and the D to E tie‑out did not match. We rebuilt the SFC schedules, created one‑page summaries, and locked FX rates to the correct measurement dates. The next review cycle took one hour instead of three, the installment notice cleared, and the partner finally moved the client into advisory planning instead of chasing workpaper mismatches.

Final one‑page checklist before you file

• SFC list is complete and identifiers match prior‑year filings.
• Cash, net A R, and cash equivalents are captured for each measuring date.
• FX rates are documented and applied at the correct dates.
• Pro rata ownership is labeled and applied consistently.
• “Greater of” rule is shown in a simple side‑by‑side and the winner is flagged.
• Schedule E detail ties to Schedule D totals, with a short reconciliation.
• 965‑A or 965‑B installment schedules are updated and included.
• File names, versions, and a change log are in the folder.
• A reviewer can follow the logic in two minutes without asking where numbers came from.

Keep your Schedule D simple, transparent, and tied to Schedule E. That is what speeds review and lowers risk.

Closing note

Use this guide as your model for every 965 cycle. If you want more capacity during peak periods, build SOPs and a review ladder that your entire team follows, then add trained hands into that structure. The result is steadier delivery, fewer notices, and partners who get their time back for client strategy. This is how you keep the quality high while you scale.

Common Mistakes We See Every Season

We see the same handful of mistakes repeat every §965(h) installment cycle. Most trace back to teams treating Schedule D as a one-time 2017 exercise rather than a live workpaper that has to reconcile every year a §965 balance remains on the return.

Reusable Checklists

Copy these into your §965 SOP folder. They are the steps my team runs every installment year and on every amended-return touch.

Keep Schedule D (Form 965) Season From Stalling

The §965 transition tax was a one-time event for tax years 2017 and 2018, but the Schedule D workpaper is still very much live. The §965(h) installment schedule back-loads payments (8% in years one through five, then 15%, 20%, and 25%), so 2025 is the final installment year for taxpayers who elected in 2017, and the 25% balloon is often two to three times the size of any prior payment (per IRC §965(h)(1), as published on IRS.gov). Pair that with continuing IRS examination activity on remaining §965 balances, and Schedule D has to stay audit-ready for years longer than most teams budgeted for back in 2017.

The teams that handle this cleanly treat Schedule D as a permanent file rather than a 2017 artifact. The fixes are mechanical and worth standardizing across every U.S. shareholder engagement.

• Lock the Schedule E to Schedule D tie-out: columns (b), (d), and (f) on Schedule D map to Schedule E columns (b)(3), (c)(3), and (d)(3). Reviewers should refuse the file if cross-ticks are missing.
• Document the line 17 vs line 18 comparison every year, even when nothing material has changed. A one-line workpaper note showing the LARGER pick on line 19 saves senior review time later.
• Maintain an FX translation log: rate used, rate source, and measurement-date support for each SFC. Examiners ask for this first.
• Track the installment schedule against the original §965(h) election. The 25% year-eight payment is where cash-flow surprises hit the client.
• For any amended return, isolate the Schedule D recompute as a separate workpaper layer so the reviewer can see what changed since the original filing.

This is the kind of recurring work that benefits from a structured delivery team running the file year after year: SOP-driven, documented, and reviewable. Accountably's U.S. accounting and tax delivery teams handle Schedule D refreshes, §965(h) installment tracking, and audit support inside your existing templates, so production stays clean without disrupting the client relationship.

FAQs

Do I still need to file Schedule D if I already filed in the inclusion year?

Yes, if you have an unpaid Section 965 net tax amount under a valid 965(h) installment election or a 965(i) deferral, you continue to file the 965 package annually. That package generally includes Form 965‑A or 965‑B and supporting schedules, and firms often include Schedule D and Schedule E for continuity and clarity.

Which exchange rate do I use for translation?

Use the spot rate on each cash measurement date. Document the rate source and save the evidence. Apply the rate to each cash‑position component before you compute your pro rata share.

Are intercompany receivables included in cash position?

Yes, intercompany receivables belong in A R. You still net A R and A P to arrive at net A R, then include that net amount in cash position. Keep a short note that identifies related party balances and any eliminations so a reviewer is not surprised.

What if an SFC changed its year end around the inclusion period?

Anchor your measuring dates to the statutory definitions. If the SFC’s year end shifted, annotate the workpaper with a timeline, show the old and new year ends, and make sure your three measurement dates still match the correct statutory periods.

How should I handle negative net A R?

Do not reduce other SFCs’ positive net A R with a negative from one entity. Record zero for the net A R component of that SFC’s cash position, disclose the negative in a footnote, and keep the support, A R aging and A P listing, in the file.

How do Schedule D and Schedule E tie together?

Schedule D shows the rolled‑up aggregate foreign cash position. Schedule E shows the entity‑level detail and the rate‑equivalent percentage computation. Your D total must reconcile to the sum of the E detail. Build E first, then roll to D – Schedule E applies the §965(c)(3)(B) cash‑equivalent classifications (net A R, short‑term obligations under one year, foreign currency on hand, actively traded money‑market and government securities) that raw corporate books will not capture on their own, so going to D directly from the GL almost always understates cash position.

Do I need to amend if I find a missed cash equivalent after filing?

If the error is material to the 965(c) deduction or any installment amounts, prepare a corrected package, include a clear reconciliation, and evaluate whether an amended return or an administrative adjustment request is required. Document the materiality assessment and the decision.

How long should I keep the supporting workpapers?

Keep them at least for the statute of limitations plus any extended periods tied to installments and carryovers. Because 965 installments can run several years, retain the full package and rate support through final payment, then follow your firm’s retention policy.