Excess Contribution Calculator
Retirement accounts such as IRAs and 401(k)s offer incredible tax advantages—but they come with strict contribution limits. If you accidentally contribute more than allowed, you’ll be subject to excess contribution penalties unless you take corrective action quickly.
The Excess Contribution Calculator helps you identify how much you’ve over-contributed and how much needs to be withdrawn—including any earnings generated on the excess.
What Is an Excess Contribution?
An excess contribution occurs when you deposit more than the legal limit into a tax-advantaged account like a Traditional IRA, Roth IRA, 401(k), or HSA.
Exceeding the contribution limit can lead to:
- A 6% penalty per year on the excess amount (until corrected)
- Required removal of both the excess amount and any earnings on it
Formula
The excess contribution is calculated as:
Excess = Actual Contributions − Annual Limit
To avoid penalties, you must remove:
Excess + Earnings on Excess = Total Removal Amount
If earnings are negative, you may remove less than the excess.
How to Use the Calculator
- Enter the Annual Contribution Limit – Set by the IRS each year (e.g., $7,000 for IRAs in 2024 for age 50+).
- Enter Actual Contributions Made – The total you contributed for the year.
- Enter Earnings on the Excess – Earnings or losses generated by the excess amount.
- Click Calculate.
- View the Excess Contribution and Total Amount to Withdraw.
Example
Let’s say:
- Contribution limit = $6,500
- You contributed = $8,000
- Earnings on excess = $150
Excess = 8,000 − 6,500 = $1,500
Total to remove = 1,500 + 150 = $1,650
You must withdraw $1,650 to correct the over-contribution.
Frequently Asked Questions (FAQs)
1. What accounts does this apply to?
IRAs, Roth IRAs, 401(k)s, HSAs, and other tax-deferred accounts with contribution limits.
2. What’s the penalty for not correcting excess contributions?
A 6% penalty annually on the excess amount until it’s corrected.
3. Can I fix an excess contribution?
Yes. Withdraw the excess and earnings by the tax deadline (usually April 15 + extension).
4. What if I lose money on the excess contribution?
If your excess generated a loss, you only need to withdraw the reduced amount.
5. How do I calculate earnings on excess contributions?
Use a prorated method or contact your account custodian—they often provide the calculation.
6. Can I re-contribute the excess in a future year?
Yes, if you have unused contribution room in the following year.
7. Does this apply to Roth IRAs?
Yes. Roth IRAs have contribution limits based on income and filing status.
8. Can I fix the mistake after filing my taxes?
Yes. You may amend your return or file IRS Form 5329 if needed.
9. Is the 6% penalty one-time or annual?
It’s an annual penalty until the excess is removed.
10. What if I made excess contributions across multiple accounts?
You must calculate the total excess per individual limit, not per account.
11. Can I carry over excess contributions?
Yes, but they count toward next year’s limit and are still penalized unless corrected.
12. What’s the deadline for fixing an excess contribution?
Generally, tax day of the following year (April 15), including extensions.
13. Do Roth conversions count toward limits?
No. Conversions from Traditional to Roth IRA aren’t treated as contributions.
14. What if I’m eligible for catch-up contributions?
Make sure you’re including those in your limit. For example, $7,000 for age 50+.
15. Can I use this calculator if I don’t know my earnings yet?
You can estimate, but it’s best to use your provider’s actual earnings statement.
16. What if the excess was contributed due to employer error?
Still needs correction. Contact HR or plan administrator for guidance.
17. Can this calculator work for multiple excesses?
Yes—sum all excess contributions and earnings to calculate the total.
18. Is it better to fix the excess before or after filing taxes?
Before. Correcting before tax filing can help avoid penalty forms and fees.
19. What if I over-contributed to a spouse’s IRA?
Each person has their own annual limit. Calculate separately.
20. What form do I use to report penalties?
IRS Form 5329 is used to report and calculate excise taxes on excess contributions.
Conclusion
Over-contributing to retirement accounts is more common than you might think—and if unaddressed, it can lead to costly penalties. Thankfully, correcting it is simple once you know the numbers.