Excess Contribution Calculator
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.
If you already know your excess amount, skip to Step 2.
Limits change yearly; check IRS.gov for the current tax year.
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.
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.
- 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.
- 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.
- 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.
- 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%.
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).
Makeup of the $1,328.33 withdrawal in the worked example: three quarters principal, one quarter earnings.
| Check (excess / AOB / ACB) | NIA | Total withdrawal | Penalty / 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.
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.
| Account | 2026 limit | Does 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
- Internal Revenue Service. Publication 590-A, Contributions to Individual Retirement Arrangements (IRAs), including Worksheet 1-4. Accessed October 21, 2026.
- Internal Revenue Service. Retirement Topics: IRA Contribution Limits. Accessed October 21, 2026.
- Internal Revenue Service. About Form 5329, Additional Taxes on Qualified Plans (including IRAs) and Other Tax-Favored Accounts. Accessed October 21, 2026.
- 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.
- Internal Revenue Service. T.D. 9056, Net Income Calculation for Returned Contributions, Federal Register. Accessed October 21, 2026.
- Internal Revenue Service. Ten differences between a Roth IRA and a designated Roth account (recharacterization of conversions). Accessed October 21, 2026.
- Ascensus. Calculating Earnings for Timely IRA Excess Removals and Recharacterizations. Accessed October 21, 2026.
- Internal Revenue Service. Changes to the 2022 instructions for Form 5329 (SECURE 2.0 corrective distribution earnings note). Accessed October 21, 2026.
- Internal Revenue Service. Consequences to a participant who makes excess deferrals to a 401(k) plan. Accessed October 21, 2026.
- Spencer Fane LLP. 2026 Inflation Adjustments (IRA, HSA and HDHP limits). Accessed October 21, 2026.
