Recovering from wrong amount in attempted Timely Withdrawal of Excess Roth Contribution

[SoCalRetiree]

I made excess Roth contributions for 2021 and 2022 (early in the next calendar year, $7000 each year), and discovered this in 2023 before filing for 2022.

Before the filing deadline (as extended for California), I withdrew enough to cover both the 2022 contribution +/- the gain/loss and the 2021 principal contribution, and filed a 2021 1040X reporting that year's excess contribution. However, due to my naivete and hastiness at the time, the withdrawal came out in multiple chunks, the first of which was $7000 -- not quite enough to cover the contribution for 2022 plus the few day's gain.

I have since generated a spreadsheet that subdivides the 2022 contribution +/- gain/loss across the first two withdrawals.  Its contents are complicated enough to make me wary of trying to communicate it to either the IRS (in the required explanatory note), or to my broker (to request a proper 1099R).  I did not contact my broker to request a non-standard Roth 1099R for 2023, so I have received one that reports a simple total of the withdrawals under code Q (I am over 59 1/2).

Generating a replacement 1099R is described by @DanaB27, although I remain unsure which of the codes is appropriate for each of the 2021 and 2022 repayment portions.

The IRS will of course receive a copy of the original 1099R from my broker, so any difference between the two is a complication.

A possibly lower-risk strategy would be to abandon my claim of timely withdrawal for 2022 and simply file a 1040X for that year as well, reporting another $7000 excess contribution.  That way, the 1099R could report the same code letter for both, with a simple sum of $14000.

Would a broker-generated 1099R reporting the proper code be less likely than a self-generated replacement to cause trouble with the IRS, for my 2023 1040 filing?

Whether broker- or self-generated, what should be the 1099 code(s)?

[LeticiaF1]

Yes, it would be best if a broker generated a corrected 1099-R, the code they would need to use is Code 8.  Code 8 is used to report Excess contributions plus earnings/excess deferrals according to IRS Form 1099-R instructions.  

[SoCalRetiree]

Thanks for your reply @LeticiaF1. Reviewing the 1099-R instructions, I note that the term "timely" does not appear in any context specific to Roth's. There are instructions requiring an attempt to compute earnings on Roth withdrawals:

... for the distribution of excess Roth IRA
contributions, report the gross distribution in box 1 and only
the earnings in box 2a. Enter Code J and Code 8 or P in
box 7.

To the question of which code should be used, there is this:

Use Code Q for a distribution from a Roth IRA if you know that the participant
meets the 5-year holding period and:
• The participant has reached age 591/2,
• The participant died, or
• The participant is disabled.
Note. If any other code, such as 8 or P, applies, use Code J.

I read the above as requiring both codes 8 and J required, if claiming a timely withdrawal.

I am wondering if the 1099-R instructions generally assume timely corrective withdrawal is being claimed, since from what I have read elsewhere, a untimely withdrawal amount should equal the original contribution -- with the 6% penalty charged according to rules laid out elsewhere. A recent confirmation of that from a custodian of Roth IRAs:

Untimely corrections must be reported on IRS Form 1099-R as an early or normal withdrawal, depending on your age.

Where for someone over 59 1/2, a "normal withdrawal", is presumably code Q.