Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Excess Contribution Calculator
Retirement Calculators

Excess Contribution Calculator

Published onSeptember 29, 2025 Updated onOctober 21, 2026 1:11 pm

Put too much into your IRA or Roth IRA this year and the IRS charges a 6% excise tax for every year the excess sits there. Fixing it means withdrawing not just the excess but also the earnings it generated, and those earnings follow a specific IRS formula called net income attributable (NIA). This calculator runs that formula from your excess amount and account balances, then tells you the total to withdraw, the 6% annual penalty at stake, and your correction options with deadlines.

Excess Contribution Calculator
Compute the IRS net income attributable (NIA) on an excess contribution and the exact total withdrawal needed to correct it.
Step 1: Find your excess (optional)

If you already know your excess amount, skip to Step 2.

Limits change yearly; check IRS.gov for the current tax year.

Step 2: NIA inputs

Account value just before the excess contribution, plus contributions and transfers since.

Current account value, plus distributions, transfers and recharacterizations taken out since the contribution.

Excess contribution
Net income attributable (NIA)
Total withdrawal required
6% annual penalty at stake
Severity: –

Educational estimate only, not tax advice. The NIA formula follows IRS Publication 590-A. Confirm the final withdrawal figure with your custodian before acting.

Quick Answer

On a $1,000 excess with an adjusted opening balance of $30,000 and an adjusted closing balance of $39,850, the net income attributable is $328.33, so the total withdrawal required is $1,328.33. Correct it by your tax filing deadline (including extensions) and the $60.00 per year excise tax never applies. The formula is the one on Worksheet 1-4 of IRS Publication 590-A.

Key takeaways

  • You withdraw the excess plus its earnings, never the excess alone, when you correct before the deadline.
  • The adjusted closing balance adds back distributions and transfers taken out during the period. Getting that sign wrong is the most common NIA error.
  • The 6% tax repeats every year the excess remains, and it is capped at 6% of the account value at year end, a detail most summaries skip.
  • Your custodian runs this same calculation when you file the removal request. This tool lets you check their figure before you sign.
6%
Excise tax per year the excess remains (IRC 4973)
$7,500
2026 IRA contribution limit, $8,600 at age 50 or older
Filing deadline
Correct by your tax filing deadline, extensions included, to avoid the tax
Form 5329
Where the 6% tax is reported for any year it applies
On this page
  • Quick Answer
  • How to use the excess contribution calculator
  • The IRS NIA formula, exactly as published
  • Worked example: a $1,000 excess in an account that grew 32.83%
  • Getting the adjusted balances right: the plus sign everyone flips
  • Your three correction options, in deadline order
  • The limits that create excesses, and the scope of this tool
  • If you missed the deadline: what the 6% really costs
  • What competing calculators and guides miss
  • Frequently asked questions
  • Add This Calculator to Your Website
  • References

How to use the excess contribution calculator

If you know the excess amount, go straight to Step 2. If you only know what you contributed and what your limit was, Step 1 works the excess out for you.

  1. Step 1 (optional): enter total contributions and your IRS annual limit. When you click Calculate Correction, the excess field is filled with contributions minus limit, or set to zero if you stayed under the limit. If you fill in only one of the two fields, the excess field is left exactly as you typed it.
  2. Step 2: enter the excess, the adjusted opening balance and the adjusted closing balance. The definitions in the next sections matter more than the arithmetic: most wrong answers come from an AOB or ACB built the wrong way.
  3. Read the result: the headline is the total withdrawal (excess plus NIA). Below it sit the NIA itself, the 6% annual penalty you avoid by acting in time, a severity reading based on the excess as a share of the closing balance, and a correction analysis that restates the formula with your numbers and lists the three options.

After a result is showing, editing any field recalculates live, which makes it easy to test a corrected ACB figure. Nothing is calculated until you click the button the first time.

The IRS NIA formula, exactly as published

NIA = Excess × (ACB − AOB) ÷ AOB. Total withdrawal = Excess + NIA. Annual excise tax if uncorrected = Excess × 6%.

Net income attributable = Excess contribution × (Adjusted closing balance − Adjusted opening balance) ÷ Adjusted opening balance
Total withdrawal required = Excess contribution + Net income attributable

This is Worksheet 1-4 in IRS Publication 590-A, and the regulation behind it is 26 CFR 1.408-11. The logic is a pro-rata allocation: the account grew (or shrank) by (ACB − AOB) ÷ AOB over the computation period, so the excess is assigned that same percentage gain or loss. The computation period starts immediately before the excess contribution went in and ends immediately before it comes out. The formula does not track what your specific dollars bought; it treats the account as one pool, which is why two people with the same balances get the same NIA even if their investments differed.

Worked example: a $1,000 excess in an account that grew 32.83%

You contributed $1,000 too much. The account was worth $30,000 just before that contribution (the adjusted opening balance, with the period's contributions added in), and it is worth $39,850 just before the corrective withdrawal (the adjusted closing balance).

1. Growth: ($39,850 − $30,000) ÷ $30,000 = 32.83%→ 2. NIA: $1,000 × 32.83% = $328.33→ 3. Withdraw: $1,000 + $328.33 = $1,328.33
Excess contribution
$1,000.00
Earnings (NIA)
$328.33

Makeup of the $1,328.33 withdrawal in the worked example: three quarters principal, one quarter earnings.

Check (excess / AOB / ACB)NIATotal withdrawalPenalty / year
$2,000 / $50,000 / $45,000 (account fell)$-200.00$1,800.00$120.00
$8,000 contributed, $7,000 limit (Step 1) / $30,000 / $39,850$328.33$1,328.33$60.00
$1,234.56 / $10,000.25 / $11,234.75$152.40$1,386.96$74.07
$50,000 / $200,000 / $260,000$15,000.00$65,000.00$3,000.00

Each row is a real run of this calculator. The first row is the one people doubt, so check it by hand: the account fell 10%, the excess is assigned a 10% loss, and you withdraw $200 less than you over-contributed. A negative NIA is a genuine IRS outcome, not an error state.

Getting the adjusted balances right: the plus sign everyone flips

The adjusted opening balance is the account value immediately before the excess contribution, plus that contribution and every other contribution, transfer and recharacterization into the account during the computation period. The adjusted closing balance is the account value immediately before the corrective withdrawal, plus any distributions, transfers and recharacterizations taken out during the period.

Both adjustments add. That is what Worksheet 1-4 says on its face (line 2 adds distributions to the closing value; line 3 adds contributions to the opening value), and the regulation's definitions say the same. Yet widely read guides, including a major personal-finance publisher's excess-contribution page, define the closing balance as the current value minus distributions and transfers. Follow that version after taking a mid-period distribution and you understate the account's growth, understate the NIA, and under-withdraw, which leaves part of the excess technically uncorrected. If your custodian's figure differs from yours, compare ACB construction first; it is the usual source of the gap. Ascensus, which administers IRAs for much of the industry, walks through the same plus-side construction in its guide to earnings on timely excess removals.

Your three correction options, in deadline order

The right option depends on the calendar. All three are priced with your numbers inside the calculator's correction analysis; the sequence below is how a timely correction normally runs.

1
Discover and measure. Work out the excess (Step 1 of the tool) and the NIA. Common triggers: a raise pushing you over the Roth income phase-out, contributions to two IRAs that combine over the limit, or contributing more than your taxable compensation.
2
Withdraw the excess plus NIA before the filing deadline (Option 1). File a "return of excess contribution" request with the custodian of the IRA holding the excess; the NIA calculation is performed on that IRA only. Done by the deadline, including extensions, the contribution is treated as never made and the 6% tax never applies. The earnings are taxable in the year of the original contribution, and you will get a Form 1099-R for the distribution.
3
Or recharacterize (Option 2). Move the excess plus its earnings to the other IRA type by trustee-to-trustee transfer before the same deadline, if you are eligible for the receiving type. A regular contribution can still be recharacterized; a Roth conversion cannot, for conversions made after 2017.
4
If the deadline has passed (Option 3). The 6% tax applies for that year on Form 5329 and repeats each year the excess remains. You can still withdraw the excess (without earnings, after the deadline) or let future years' unused contribution room absorb it, which stops the tax going forward but does not refund past years. How the earnings side of a retirement withdrawal is taxed is covered by the 403b withdrawal calculator for workplace accounts.

The limits that create excesses, and the scope of this tool

An excess is measured against your personal limit, not the headline one. For 2026 the IRA limit is $7,500, or $8,600 if you are 50 or older, per the IRS's retirement topics page on IRA contribution limits; your limit is the smaller of that figure and your taxable compensation, and Roth eligibility phases out at higher incomes, which is the single most common way an excess happens.

Account2026 limitDoes this calculator's NIA apply?
Traditional IRA / Roth IRA$7,500 ($8,600 at 50+)Yes. The formula is written for IRAs (Publication 590-A, Regulation 1.408-11).
HSA$4,400 self-only / $8,750 family (+$1,000 at 55+)No. An HSA excess also draws a 6% excise tax on Form 5329, but the HSA custodian computes the earnings portion; do not use the IRA worksheet for it.
401(k) elective deferrals$24,500 ($32,500 at 50+)No. Excess deferrals are corrected through the plan by April 15 of the following year with no extension relief, and an uncorrected excess is taxed twice. Different rules, different deadline.

One more cap worth knowing: the 6% tax for a year cannot exceed 6% of the value of the IRA at the end of that year. On a small account with a large excess, the account value, not the excess, sets the tax. The tool reports the plain excess × 6% figure, which is the amount at stake in the normal case; the year-end cap is a Form 5329 computation.

If you missed the deadline: what the 6% really costs

The tax is 6% of the excess for each year, or part of a year counted at year end, that the excess stays in the account. A $1,000 excess left for three years costs $180 in excise tax alone, and the earnings question changes too: after the deadline you withdraw the excess without the NIA, because the earnings stay in the IRA.

Two tax details on the earnings side are often stated wrong. The NIA on a timely correction is taxable in the year of the original contribution, and since the SECURE 2.0 change it is not also hit with the 10% additional tax on early distributions for corrective distributions made on or after December 29, 2022; older articles that add that 10% are out of date. What the earnings do to your broader tax picture depends on your other income, which is where an after tax yield calculator helps frame the comparison, and the mechanics of IRS penalty computation generally mirror the underpayment penalty calculator: small rate, applied relentlessly, until the underlying problem is fixed.

What competing calculators and guides miss

Most content ranked for this keyword explains the NIA formula but stops at the explanation, or computes only part of the correction:

  • LegalClarity's earnings guide: the clearest walkthrough of AOB and ACB, with the regulation cited. Guide only: no tool, and you still do the arithmetic yourself across four gathered values.
  • The Motley Fool's Roth excess page: good plain-language correction steps, but its adjusted closing balance definition subtracts distributions and transfers, the opposite sign from Worksheet 1-4 line 2 and Regulation 1.408-11. On an account with mid-period distributions, that error flows straight into the withdrawal amount.
  • Beagle and similar blog calculators-by-article: restate the formula with an example and leave the earnings figure for you to supply or estimate, which is the one number readers actually cannot supply.
  • Ascensus and custodian practice guides: technically the strongest sources, written for plan administrators, with loss-of-earnings penalties and valuation-date rules that bury the individual reader's actual question.
  • The gap this page fills: the worksheet computed from balances, the excess derived from contributions and limit when you do not know it, the penalty priced per year, a severity reading, and the ACB sign error named and corrected with the primary sources linked.

Frequently asked questions

Any amount above your IRS limit for the year, including contributions made after you became ineligible (for example, earning too much for a direct Roth IRA contribution) and amounts exceeding the limit for your age and account type.

A 6% excise tax applies for each year the excess remains in the account, reported on Form 5329. Removing the excess plus its earnings before your tax filing deadline (including extensions) avoids the penalty.

Yes. If the account lost value during the computation period, the NIA formula returns a negative number, which reduces the total amount you must withdraw.

Yes. The NIA portion is taxable income for the year the original contribution was made. The 10% additional tax on early distributions no longer applies to earnings removed with a timely corrective distribution made on or after December 29, 2022, following the SECURE 2.0 change; older guidance that adds the 10% tax to corrective distributions is out of date.

The 6% penalty applies for that year and keeps applying each year until the excess is removed or absorbed by unused contribution room in a future year.

In many cases yes: moving the excess plus earnings to a different IRA type before the deadline can fix the problem without a straight withdrawal, depending on eligibility rules for the receiving account. Recharacterizing a regular contribution is still allowed; recharacterizing a Roth conversion is not, for conversions made after 2017.

Your custodian calculates it officially when you request a removal of excess contribution, because the withdrawal must come out of the IRA that holds the contribution. This calculator lets you check the custodian's figure independently: if your number and theirs differ, the usual cause is the adjusted closing balance, which must add back distributions and transfers made during the computation period.

Not directly. The NIA worksheet here is the IRA formula from Publication 590-A and Regulation 1.408-11. An excess 401(k) deferral follows a different correction: it must be distributed by April 15 of the following year, with no filing-extension relief, or it is taxed twice. An HSA excess also draws a 6% excise tax on Form 5329, but the HSA custodian computes the earnings portion under its own procedure.

Add This Calculator to Your Website

Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.

Powered by Calculator Zilo

References

  1. Internal Revenue Service. Publication 590-A, Contributions to Individual Retirement Arrangements (IRAs), including Worksheet 1-4. Accessed October 21, 2026.
  2. Internal Revenue Service. Retirement Topics: IRA Contribution Limits. Accessed October 21, 2026.
  3. Internal Revenue Service. About Form 5329, Additional Taxes on Qualified Plans (including IRAs) and Other Tax-Favored Accounts. Accessed October 21, 2026.
  4. U.S. Department of the Treasury. 26 CFR 1.408-11, Net income calculation for returned or recharacterized IRA contributions (Cornell Legal Information Institute). Accessed October 21, 2026.
  5. Internal Revenue Service. T.D. 9056, Net Income Calculation for Returned Contributions, Federal Register. Accessed October 21, 2026.
  6. Internal Revenue Service. Ten differences between a Roth IRA and a designated Roth account (recharacterization of conversions). Accessed October 21, 2026.
  7. Ascensus. Calculating Earnings for Timely IRA Excess Removals and Recharacterizations. Accessed October 21, 2026.
  8. Internal Revenue Service. Changes to the 2022 instructions for Form 5329 (SECURE 2.0 corrective distribution earnings note). Accessed October 21, 2026.
  9. Internal Revenue Service. Consequences to a participant who makes excess deferrals to a 401(k) plan. Accessed October 21, 2026.
  10. Spencer Fane LLP. 2026 Inflation Adjustments (IRA, HSA and HDHP limits). Accessed October 21, 2026.

Related calculators

Retirement CalculatorsFederal Employee Retirement Calculator Your federal pension is not a mystery number on a benefits statement: it is a formula you can run yourself.Retirement Calculators Fire Calculator FIRE stands for Financial Independence, Retire Early, and this calculator answers its two central questions:...Retirement CalculatorsIra Conversion To Roth CalculatorA Roth conversion moves money from a Traditional IRA into a Roth IRA, and you pay income tax on the converted amount now instead of later.Retirement CalculatorsSocial Security Early Retirement CalculatorClaiming Social Security at 62 instead of 67 cuts your monthly check by 30%, permanently, and waiting until 70 raises it by 24% above the full amount.Retirement Calculatorsenworth Long Term Care Calculator Long term care is the expense almost nobody budgets for and almost everybody eventually faces.Retirement CalculatorsWithdrawal Retirement CalculatorRetirement is a distribution problem: a pile of money has to become a paycheck that lasts as long as you do.

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search