The team was buried, the workpapers were inconsistent, and the review loop kept bouncing between versions. If you have felt that mix of rush and risk, this guide is for you.
When you button up Schedule D, you lower audit risk, speed reviews, and protect your 965(c) deduction math. Small errors here ripple through your entire return.
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.
- 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.
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. 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 Schedule E 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.
FAQs for Form 965 Schedule D
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.
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.
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.