Free Excel templates

A free foreign tax credit calculator in Excel

Foreign income placed in its category, the standard deduction apportioned by gross income, the section 904(a) limitation of each category, the credit, and carryovers used oldest first with their last year.

A married couple earns foreign wages taxed heavily abroad, a little foreign investment income taxed lightly, and some United States interest and dividends. Their $8,432 of tax splits into a general limitation of $6,153, far below the $16,400 of tax on the wages, and a passive limitation of $825, above the $610 withheld, so the passive room absorbs $215 of an old carryover. The total credit is $6,978. The calculator lays the chain out for one return, ready for your own figures.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Foreign_Tax_Credit_Calculator.xlsx (18 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this calculator

This calculator is a simplified version of the companion workbook of The Foreign Tax Credit Handbook, which follows one couple through a full return: every foreign tax tested and translated at the rate of its day, incomes sourced and placed in their categories, a high-taxed rent moved to the general category, a Schedule K-3, the qualified dividends adjustment, two limitations, carryovers before and after the year, and four scenarios beside it.

Paperback PDF edition, $19.99

What is in the file

Inputs are in blue; everything else is a formula; the checks count the failures. Unused rows stay empty and change nothing.

1. Start here
What the calculator does, the rules it applies with the date they were read, what it leaves out, and a note that every example figure is a teaching assumption, not a market figure.
2. Inputs
Incomes by category (passive, general) and by source, foreign qualified dividends among them; directly related expenses and the deduction to apportion; the foreign taxes of each category; the United States tax before credits; the carryovers of each category by year of origin; and two declared switches, the de minimis election and the foreign earned income exclusion.
3. Calculator
The foreign source taxable income of each category after any adjustment, the limitation fraction, the limitation, the credit allowed with the carryovers it uses oldest first, the excess carried and the last year each balance can be used.
4. Checks
The controls of the calculator, each showing a gap that must read 0, and a count of the failures.

What the worked example returns

MeasureValue
Taxable income (gross income less the standard deduction)$88,400
Tax before credits (qualified dividends at 0 percent)$8,432
Foreign qualified dividends under $20,000No adjustment entered (exception assumed met)
General category: limitation / foreign tax$6,153 / $16,400
General category: credit / excess carried back or forward$6,153 / $10,247
Passive category: limitation / foreign tax of the year$825 / $610
Passive category: credit, of which from the 2019 carryover$825, of which $215
2019 carryover left, last usable year 2029$425
Total credit$6,978
Control blockEvery check at 0

The example couple is fictional and every input is a teaching assumption: a joint return with foreign wages of $88,000 (general category, foreign tax $16,400), foreign qualified dividends of $7,900 and foreign interest of $3,900 (passive category, foreign tax $610), United States interest of $14,700 and qualified dividends of $6,100, the $32,200 standard deduction, and a passive carryover of $640 from 2019. Every check of the control block reads 0. The calculator is separate from the book's case: read its figures against each other, not against the book's couple.

How to use it on your own return

  1. Source each income first, then enter it in its category: wages and active business income in general, dividends, interest and passive rents in passive.
  2. Enter only creditable foreign income taxes, net of any refundable part, in the category of the income they fall on.
  3. Enter the United States tax before credits from the return, and the deduction to apportion: itemized deductions not tied to any income, or the standard deduction.
  4. Enter each carryover with its category and its year of origin, from Schedule B (Form 1116) of the prior year.
  5. Read the Checks tab before any figure: a count above zero means a cell to fix.

Rules described as read in November 2026 (26 U.S.C. 904 as applied by the IRS Instructions for Form 1116 (2025) and IRS Publication 514 (2025), and the 2026 joint rate schedule of Rev. Proc. 2025-32). Education only, not tax advice: the facts of your own return govern, and your tax adviser decides.

Questions people ask

What does the foreign tax credit calculator do?

For one individual return, it takes incomes by category and by source, the foreign taxes of each category, the United States tax before credits and the carryovers by year of origin, apportions the deduction by gross income, and returns the foreign source taxable income, the limitation and the credit of each category, the excess carried and its last usable year.

Which rules does it apply?

As read in November 2026: the section 904(a) fraction computed separately for the passive and general categories, the apportionment of the standard deduction by gross income as in the Instructions for Form 1116 (2025), the qualified dividends adjustment with the factor 0.4054 when foreign qualified dividends reach $20,000, and carryovers used oldest first within their category for ten years.

What if my foreign qualified dividends are under $20,000?

The calculator then records, as a declared assumption, that the adjustment exception is met. For 2025 returns the exception also has a taxable income test; check it, and the 2026 figures, in the instructions for the year.

What does it leave out?

The creditability tests, the year a tax counts, translation into dollars, the high-taxed income kickout, losses and their recapture, Schedule K-3 detail, treaties, the alternative minimum tax and state rules. The book's full workbook covers most of them on one case.

Can I rely on it to fill Form 1116?

No. It is built for a first pass and for learning the mechanics. The return needs its own figures and documents, and the conclusions belong to your tax adviser.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbook of The Foreign Tax Credit Handbook goes further: a registry of every foreign tax with its date and rate of exchange, the creditability tests, the high-taxed income test item by item, a Schedule K-3, the qualified dividends adjustment on both sides of the fraction, carrybacks on an amended return, and the deduction, de minimis and exclusion scenarios.

See the book and its free files →

Related reading