The Earnings Record

There is a spreadsheet the federal government has been keeping on you since your first legitimate paycheck. Every year of earnings, line by line, going back to whenever you first showed up in the system with a Social Security number and a W-2.

That spreadsheet is going to determine one of the largest assets you will ever own. For a lot of households, the lifetime value of Social Security benefits exceeds the value of the retirement portfolio they spent thirty years obsessing over.

And almost nobody checks it.

Monday we mapped the income thresholds that grade you two years later. This is the same idea stretched across a career. The work you did in 1998 is being graded now, by a ledger you have probably never opened.

You cannot audit something you do not understand, so here is the machinery in plain language.

The agency takes your entire earnings history and indexes the older years upward to account for wage growth over time. A year of earnings from the early nineties gets scaled up so it can be fairly compared to a year of earnings from last decade. This matters, because it means your old low-paying years are not quite as worthless as they look on the raw statement.

Then it picks your highest thirty-five indexed years and throws the rest away. Adds them up, divides by four hundred twenty months, and produces your average indexed monthly earnings.

Here is where it gets interesting. That average runs through a formula with two bend points, and the formula is aggressively progressive. The first slice of your average gets replaced at a very high rate. The next slice gets replaced at a much lower rate. Everything above the second bend point gets replaced at a rate so low it is almost a rounding error.

The practical consequence catches people off guard. If you are a high earner, an extra year of high income might move your benefit by a trivial amount, because you are deep into the low-replacement zone. But if you are anywhere near the first bend point, an extra good year can be genuinely significant.

And then the zeros.

Thirty-five years. If you worked thirty-one, the formula does not average thirty-one years. It plugs in four zeros and averages thirty-five.

Four zeros dropped into that average drags the whole thing down, and because of where the bend points sit, the damage is rarely proportional to what you would expect. This hits certain people much harder than others. Anyone who took years out for caregiving. Anyone who spent time in a job that did not participate in the system. Anyone who started earning late. Anyone who retired early and stopped contributing at fifty-five instead of sixty-two.

This is why the audit has a second half. It is not only about fixing errors in what is recorded. It is about seeing clearly whether one or two more working years would replace a zero, and what that swap is actually worth.

Create an account at the Social Security Administration website if you do not have one, or log into the one you already have. The paper statements that used to arrive in the mail were largely discontinued for working-age people years ago, which is a substantial part of why nobody checks this anymore.

Download the full statement, not the summary view. You want the year-by-year earnings table showing both the amount taxed for Social Security and the amount taxed for Medicare. Those two columns are not always the same and the difference is sometimes the first clue that something is wrong.

Open a spreadsheet with four columns. Year. Reported earnings from the statement. Your own figure. Difference.

Now fill in the third column from your own records. Old W-2 forms if you kept them. Tax returns, which most people can retrieve going back several years through the tax agency's own transcript service. Pay stubs. If you built a document archive after we covered that a few weeks back, this is exactly the payoff moment.

Do not skip years you feel confident about. Confidence is not evidence, and the errors tend to hide in the years you are least suspicious of.

Errors cluster in predictable places. Look here first.

Zero years where you know you worked. The most obvious and the most common. Usually an employer reporting failure or a mismatch between the name on the filing and the name on your record.

Name change years. This is the single biggest source of missing earnings and it disproportionately hits women. You got married, changed your name with your employer, but the update never propagated to the Social Security record. Wages get reported under a name the system does not recognize and land in a suspense file. Look hard at the two or three years surrounding any name change.

Self-employment years. Self-employment income only credits if you actually filed a Schedule SE and paid the self-employment tax. Plenty of people had a profitable side business, reported the income, and got no Social Security credit because the form was never filed. Check every year you had business income.

Years where reported earnings look capped. There is an annual maximum amount subject to Social Security tax. If you see a year sitting exactly at the cap, that is normal for high earners. If you see a year sitting at what looks like a random ceiling, that is a flag.

Multiple employer years. If you had three jobs in one year, all three should have reported. Frequently one did not.

The first and last years of employment. Partial years get botched constantly, particularly when they straddle a calendar boundary.

Now the part with the clock on it.

There is a statute of limitations on correcting the earnings record, and the general window is a little over three years from the year in question. After that, corrections are still possible but the evidence standard climbs steeply and you are relying on the agency's discretion.

The good news is that certain kinds of proof will open the door even on very old years. A W-2 form. A tax return showing the wages. Pay stubs. A written statement from the employer. What will not work is your recollection or a general sense that the number seems low.

Gather the documentation for each disputed year and contact the agency to open a correction. Do it in writing where you can, and keep a copy of everything you send. If you end up on a phone call, take notes obsessively. I record these kinds of calls with Fathom so I have an actual transcript rather than a half-remembered summary, because these matters take months and get handed between people.

Expect this to be slow. Budget several months, not several days.

Separate from errors, ask the strategic question. How many years of actual earnings do you have? If it is fewer than thirty-five, what would one more working year do?

The mechanics are straightforward. An additional year does not add to your record so much as it replaces your lowest indexed year. If your lowest year is a zero, you are swapping a zero for a full year, and that can move the number meaningfully. If your lowest year is already a solid indexed figure, the swap is marginal.

This reframes a decision people usually make on vibes. Working one more year is not just one more year of salary. It might also be a permanent increase to an inflation-adjusted lifetime income stream. Or it might be worth almost nothing. The record tells you which.

The record determines the size of the benefit. Claiming age determines how much of it you get.

Claiming before full retirement age permanently reduces the monthly amount. Delaying past full retirement age increases it by roughly eight percentage points per year until seventy, at which point the credits stop and there is no reason to wait longer. That delayed credit is a guaranteed, inflation-adjusted return that is very hard to replicate anywhere else in a portfolio.

A few mechanics that get overlooked. Survivor benefits are based on the higher earner's record, which means the higher earner delaying is partly a decision on behalf of the surviving spouse and often the strongest argument for waiting. Spousal benefits have their own rules and their own timing. And if you claim and then regret it within twelve months, there is a withdrawal form that lets you undo it once, provided you pay back what you received.

Claiming strategy deserves its own treatment and I am not going to compress it into three paragraphs here. Get the record right first. There is no point optimizing the claiming date on a benefit calculation that is built on bad data.

This is not a one-time project. It is an annual check that takes fifteen minutes once the sheet exists.

Set a recurring reminder for the same week every year. I have a scenario running in Make.com that fires annually, drops the reminder into my task list, and attaches the link to the reconciliation sheet so there is no friction between the reminder and the work.

For the reconciliation itself, pulling numbers off old tax transcripts is exactly the sort of tedious document parsing that machines do better than people. I feed the documents through Galaxy.ai and have it extract the wage figures into a table I can paste straight into the comparison column.

The reason recurrence matters is the statute of limitations. If you check every year, every error you find is inside the window and easy to fix. If you check once at sixty-two, half of what you find is outside the window and you are negotiating.

Every system we build here has the same shape. Find the thing that is quietly running in the background, look directly at it, and correct it while correction is still cheap.

The earnings record is the purest version of that. It has been accumulating for decades. It is almost certainly slightly wrong. Nobody is going to tell you. And the cost of finding out late is measured in monthly payments you will not receive for the rest of your life.

Ninety minutes this week. That is the whole ask.

I put together The Earnings Record Audit Kit to run this end to end. It includes the reconciliation sheet template with all four columns pre-built, the six-point error checklist with what evidence resolves each type, a documentation tracker for the correction process, a plain-language walkthrough of the bend point formula so you can see where you actually sit on the curve, and the replacement year calculator for the one-more-year decision.

Reply to this email with the word RECORD and it is yours.

Go pull the statement. It has been sitting there the whole time.

Alex Rivera
Wealth Architect at The Wealth Grid

This is educational content, not tax, legal, or financial advice. Program rules, formulas, and thresholds change. Verify current details with the Social Security Administration directly and consult a qualified professional before making claiming decisions.