The Fidelity return of excess calculator helps you determine the amount you must withdraw from your Fidelity retirement account when you have contributed more than the IRS annual limit. You enter your excess contribution amount and the calculator returns the adjusted earnings (or losses) that must be removed along with the excess. This article explains how the calculation works, what inputs you need, and how to handle the result correctly.
Formula
The IRS requires that when you remove an excess contribution, you also remove the net income attributable to that contribution. The formula is:
Net income = Excess contribution × (Adjusted closing balance − Adjusted opening balance) / Adjusted opening balance
- Excess contribution – the dollar amount you contributed over the annual limit (e.g., $1,000).
- Adjusted opening balance – the fair market value of the account at the beginning of the computation period, plus any contributions made during the period, minus any distributions made during the period (excluding the excess contribution itself).
- Adjusted closing balance – the fair market value at the end of the computation period, plus any distributions made during the period, minus any contributions made during the period (excluding the excess contribution).
The computation period typically runs from the day the excess contribution was made to the day you request the removal. If the excess was spread over multiple contributions, you may need to calculate net income separately for each contribution or use the IRS’s alternative method.
Worked Example
Suppose you contributed $1,000 too much to your Fidelity IRA on January 15. On July 15, you decide to remove it. During that 180-day period, the account’s adjusted opening balance was $50,000 (value at start plus contributions minus distributions) and the adjusted closing balance was $52,000 (value at end plus distributions minus contributions).
- Subtract the adjusted opening balance from the adjusted closing balance: $52,000 − $50,000 = $2,000.
- Divide that difference by the adjusted opening balance: $2,000 / $50,000 = 0.04.
- Multiply the excess contribution by that ratio: $1,000 × 0.04 = $40.00.
- Total withdrawal = excess + earnings = $1,000 + $40 = $1,040.00.
The calculator shows the same result: adjusted earnings of $40.00 and a total withdrawal of $1,040.00.
Assumptions
- The computation period is the exact number of days you enter, and the opening and closing balances are those on the relevant dates.
- All contributions and distributions during the period are accounted for in the adjusted balances.
- The excess contribution is a single lump sum; for multiple contributions, you may need to run separate calculations.
- The account is a traditional or Roth IRA; the same formula applies to both, but tax treatment differs.
When to Use This Calculator
Use this calculator when you have received a notice from Fidelity or the IRS that you exceeded the annual contribution limit (e.g., $7,000 for 2024 if under 50, $8,000 if 50 or older). You must generally remove the excess plus earnings by the tax filing deadline (including extensions) to avoid a 6% excise tax each year the excess remains. The calculator works for any retirement account that holds excess contributions, not just Fidelity, but the inputs should come from your Fidelity statement.
If your account lost money during the period, the net income will be negative, meaning you remove less than the excess. The calculator handles that automatically because the formula produces a negative number. For example, if the adjusted closing balance is $48,000 instead of $52,000, the ratio is −0.04, and the net income is −$40, so the total withdrawal is $960.
How to Get the Adjusted Balances from Fidelity
Fidelity does not provide a specific “adjusted opening balance” line on your statement, but you can reconstruct it:
- Find the fair market value of the account on the day before the excess contribution was made (or the day of, if no other activity).
- Add any contributions made during the period (other than the excess itself).
- Subtract any distributions (withdrawals, rollovers, conversions) made during the period.
- For the closing balance, take the value on the day you request the removal, add distributions, subtract contributions (other than the excess).
If you made multiple contributions, you may need to use the IRS’s “net income attributable to excess contributions” worksheet (Publication 590-A) which allows a single calculation using the total excess and the period from the first excess contribution to the removal date.
Common Mistakes and Misconceptions
A frequent mistake is using the account’s current balance without adjusting for contributions and distributions. That leads to an incorrect net income figure. Another error is forgetting that the excess contribution itself is not included in the adjusted opening balance—it is added to the balance for the purpose of the formula, but the formula already accounts for it by using the excess amount separately.
People also confuse the return of excess with a regular withdrawal. A return of excess is not subject to the 10% early withdrawal penalty if done by the deadline, but the earnings portion is taxable in the year of the contribution for a traditional IRA (or in the year of removal for a Roth IRA, depending on your situation). Always consult a tax professional for your specific case.
Another misconception: you cannot simply withdraw the excess amount alone. The IRS requires the net income to be removed as well, even if that income is negative. If you only withdraw the excess, the IRS may still treat the earnings as a distribution and you may owe tax and penalty.
How to Execute the Return of Excess with Fidelity
To actually process the removal, you must contact Fidelity or use their online form. You will need to specify the tax year, the amount of excess, and the date you want the removal effective. Fidelity will calculate the net income using their own figures, which may differ slightly from your own if you used different dates or balances. The calculator here gives you an estimate to plan ahead.
After the removal, Fidelity will issue a 1099-R form for the distribution. The earnings portion is reported as taxable income, and the excess portion is generally not taxable if it was nondeductible. Keep records of your calculation and the confirmation from Fidelity.
Alternatives to Returning Excess
If you have not yet filed your tax return, you can also recharacterize the excess contribution to a different type of IRA (e.g., from Roth to traditional) if allowed, but this option was eliminated for conversions after 2017. Another alternative is to apply the excess to next year’s contribution limit, but that only works if you have not yet contributed for that year and the excess is within the next year’s limit. The 6% excise tax is often cheaper than the hassle of removing, but it accrues each year, so removal is usually the better long-term choice.
If the excess is small, you might also consider simply paying the 6% excise tax and leaving the money in the account, but that is rarely advisable because the tax repeats annually until corrected. This calculator helps you decide by showing how much you would need to withdraw.
Frequently Asked Questions
Does Fidelity have its own return of excess calculator?
Fidelity does not offer a public online calculator specifically for return of excess. They provide the necessary forms and will compute the net income when you request the removal. This page gives you a transparent way to estimate the amount yourself before contacting them.
What if the account lost money – do I still have to remove the full excess?
No. If the net income is negative, you remove the excess minus the loss. For example, if your excess was $1,000 and the loss attributable is $40, you withdraw $960. The IRS allows this because you are returning the actual amount that would have been in the account had the excess not been made.
Can I use this calculator for a 401(k) excess contribution?
Yes, the same formula applies to employer plans, but the deadlines and tax treatment differ. For 401(k) plans, excess deferrals must be distributed by April 15 of the following year to avoid double taxation. The adjusted balances should reflect the plan’s investment gains or losses.
What is the deadline to return an excess contribution?
Generally, you must remove the excess plus earnings by the due date of your federal tax return, including extensions (usually October 15 if you file an extension). If you miss that deadline, you may still remove it later, but you will owe the 6% excise tax for each year it remains, and the earnings will be taxed as a normal distribution.
How do I know if I have an excess contribution?
Fidelity will typically send you a notice if you exceed the annual limit, or you may realize it when preparing your taxes. The IRS also tracks contributions via Form 5498. Common causes are contributing to multiple IRAs, or contributing more than your earned income for the year.
Is the earnings calculation the same for Roth and traditional IRAs?
Yes, the formula is the same. The difference is in tax treatment: for a traditional IRA, the earnings are taxable in the year of the contribution; for a Roth IRA, the earnings are taxable in the year of removal if the account is under 5 years old or you are under 59½. The excess itself is not taxable if it was a nondeductible contribution.
Related
Formula used
in m | Excess contribution | USD | 1000 | 0 in d | Days in account | days | 180 | 0 in a | Adjusted opening balance | USD | 50000 | 0 in b | Adjusted closing balance | USD | 52000 | 0 out e | Adjusted earnings | USD | m * (b - a) / a | 2 out w | Total withdrawal | USD | m + e | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation with the constants and conversion factors written on the page, rounded as each result states. See method and constants, the disclaimer or report an error.
More in this section
- Calcium Nitrate Boiling Point
- Cation Formula for Magnesium Nitrate0.0788 mol/L
- Potassium Nitrate Solubility in Water: Full Data25.9 g/100 mL
- Molar Mass of KNO2: Formula & Calculation0.1373 mol/L
- Greenhouse Grade Potassium Nitrate: Uses & Rates0.2000 mol/L
- Potassium Nitride Formula & How to Write It