She Built a Spreadsheet for Her Mother’s Medicare Bills and Found $847 Missing From 5 Months of Social Security Payments

A Portland accountant discovered her mother's Social Security COLA raise was wiped out by a Medicare Part D auto-enrollment switch. Here's what she found.

She Built a Spreadsheet for Her Mother's Medicare Bills and Found $847 Missing From 5 Months of Social Security Payments
She Built a Spreadsheet for Her Mother's Medicare Bills and Found $847 Missing From 5 Months of Social Security Payments

A cost-of-living adjustment is supposed to protect Social Security recipients from inflation — but when Medicare Part D premiums climb faster than the COLA percentage, the raise that arrives in January can quietly vanish before it ever reaches a beneficiary’s bank account.

That gap is exactly what Elaine Kirby uncovered when she sat down to review her mother’s finances early this year. The discovery did not happen in a financial planner’s office or after a call to the Social Security Administration. It happened on a Tuesday evening in March 2026, over a folding table at a free VITA tax preparation clinic in Northeast Portland — where I had gone to report on how middle-income families navigate the intersection of benefit changes and tax season.

The Spreadsheet That Started Everything

When I first sat down with Elaine Kirby at the clinic, I noticed immediately that she had brought two laptops — one for her own return, one loaded with her mother Margaret’s financial documents going back fourteen months. Elaine is the kind of person who stress-tests assumptions for a living. She works in corporate accounting, reconciles seven-figure budgets quarterly, and does not trust a number she hasn’t personally verified.

She was 32, sharply dressed for a Tuesday, and visibly tired in the way people get when they’ve been solving other people’s problems on top of their own. Her husband sat nearby keeping their teenager occupied with a phone. A thick manila folder sat between us on the table, tabbed with Post-it notes in three colors.

“I literally built a spreadsheet the night before I came to the clinic. I had every Medicare EOB, every Social Security notice going back to January. My mom thought I was being dramatic. I wasn’t being dramatic — she was $847 short.”
— Elaine Kirby, Senior Accountant, Portland, OR

Margaret, Elaine’s mother, is 68 and a retired middle school teacher living in Beaverton, just outside Portland. She began collecting Social Security retirement benefits in early 2023. Her monthly direct deposit through the end of 2025 was approximately $1,843, after the standard Medicare Part B premium of $185 per month was deducted from her gross benefit, according to Medicare.gov.

What the 2026 COLA Was Supposed to Do

The Social Security Administration announced a 2.5 percent cost-of-living adjustment effective January 2026, consistent with the prior adjustment year. For Margaret, that rate should have translated to roughly $46 more per month before Medicare deductions — pushing her gross benefit from approximately $1,843 to around $1,889, according to the SSA’s COLA information page.

2.5%
2026 COLA adjustment rate

$46
Expected monthly increase for Margaret

$18
Actual net increase received

Elaine had already factored in the Part B premium increase to approximately $190 per month — a $5 difference. What she hadn’t fully anticipated was the Part D problem. Medicare Part B premiums are automatically deducted from Social Security payments before deposit, per SSA’s Medicare overview, but Part D plans run separately through private insurers — and that separation created the blind spot.

During the Annual Enrollment Period the previous fall, Margaret’s original Part D plan had quietly stopped operating in Washington County, Oregon. She was auto-enrolled in a replacement plan by the insurer — a process that is technically permitted under Medicare rules but that many beneficiaries do not notice until they see their first January bill or, in Margaret’s case, their first pharmacy receipt.

⚠ IMPORTANT
Medicare beneficiaries can be automatically enrolled in a new Part D plan if their existing plan exits their service area. The replacement plan may carry different premium levels, formulary tiers, and copay structures — and beneficiaries have a limited Special Enrollment Period to make changes after such a switch. Many receive the notice by mail and miss it entirely.

The Formulary Change That Compounded Everything

This is where Elaine’s color-coded spreadsheet became essential. Margaret’s original Part D plan covered her brand-name blood pressure medication at a Tier 2 copay of $14 per monthly fill. The auto-enrolled replacement plan classified the same drug as Tier 4 — preferred brand — at $141 per fill. That single formulary reclassification added $127 to Margaret’s out-of-pocket costs every month.

On top of that, the new plan’s monthly premium was $67.20, compared to the $38.50 Margaret had been paying — a jump of $28.70 per month that arrived with no explanation and no opt-in.

“The COLA was supposed to give her breathing room. Instead, she called me in February saying her Part D plan wanted $67 for a medication that cost her $14 last year. She thought she’d done something wrong. She hadn’t done anything wrong.”
— Elaine Kirby, Senior Accountant, Portland, OR
How Margaret’s January Numbers Stacked Up (Jan–May 2026)
1
COLA Gross Increase — Approximately $46/month added to gross Social Security benefit at 2.5%

2
Part B Premium Increase — $5/month additional deduction reduced net COLA gain to roughly $41

3
Part D Premium Jump — New auto-enrolled plan charged $67.20/month vs. prior $38.50, adding $28.70/month in costs

4
Formulary Tier Change — Blood pressure medication reclassified from Tier 2 ($14) to Tier 4 ($141), adding $127/month

5
Net Result — Margaret’s effective monthly income fell by approximately $169 compared to her expectations entering 2026

Elaine calculated that over the first five months of 2026, the compounded effect of the auto-enrollment switch and the formulary reclassification represented roughly $847 in unplanned costs — a number that landed especially hard for a retiree on a fixed income with no pension supplement beyond Social Security.

KEY TAKEAWAY
The 2026 COLA of 2.5% added approximately $46/month to Margaret’s gross Social Security benefit. But a Part B premium increase, a Part D auto-enrollment switch, and a formulary tier change combined to leave her effectively $169/month worse off than she had planned — erasing the COLA entirely and then some.

What Elaine Did Next — and What She Could Not Undo

Elaine filed a formal coverage complaint with Medicare and reached out to Oregon’s Senior Health Insurance Benefits Assistance (SHIBA) program, which provides free Medicare counseling to state residents. Through SHIBA, she learned that Margaret had a Special Enrollment Period available specifically because the plan change had been involuntary — a window Elaine hadn’t known existed until a counselor walked her through it.

Margaret used that enrollment window to switch to a comparable plan with Tier 2 coverage for her blood pressure medication. The SHIBA counselor also identified that Margaret might qualify for Oregon’s Medicare Savings Program, which can help cover Part D premiums for beneficiaries within certain income bands. After submitting an application through the Oregon Health Authority, Margaret received a $28/month premium reduction beginning in April 2026.

“It doesn’t fix everything,” Elaine told me plainly. “But $28 back every month for my mom is $28 she can put toward groceries or gas. The five months before we caught it — that money is just gone.”

“If I wasn’t in this field, there’s no way she would have caught it. And that terrifies me — because most people aren’t accountants. Most people just see the deposit amount and assume everything is right.”
— Elaine Kirby, Senior Accountant, Portland, OR

The Prescription Problem Closer to Home

While Margaret’s situation was the primary reason Elaine had come to the clinic that Tuesday, she wasn’t there solely for her mother. Elaine herself was wrestling with a prescription cost problem that had surfaced four months earlier, when her employer switched group health providers from Providence Health Plan to a regional PPO network in November 2025.

Elaine takes levothyroxine for a thyroid condition diagnosed in 2021. Under Providence, a 90-day supply had cost her $62. Under the new PPO plan, the same medication was classified as a non-preferred generic. As of March 2026, each 90-day fill was costing her $247.

Prescription Detail Previous Plan (Providence) New PPO Plan
Levothyroxine (90-day supply) $62 $247
Monthly equivalent cost ~$20.67/month ~$82.33/month
Annual out-of-pocket difference $248/year $988/year

“I make decent money,” she said, almost apologetically. “And I still had to decide which prescription to delay last month. That’s not a position I ever thought I’d be in at 32.” She laughed, but it was the kind of laugh that doesn’t reach the eyes.

Elaine is not a Medicare beneficiary and does not qualify for Medicare’s Extra Help program. Her open enrollment window won’t reopen until November 2026. She has filed a formulary exception request with her insurer — a process she described as “sending a very formal letter into a void” — and was still waiting for a determination when we spoke.

When I left the clinic that evening, I thought about what it costs to be capable in a system that rewards persistence. Elaine had the tools to find the gap in her mother’s benefits and the vocabulary to fight for a resolution. She got partial relief for Margaret. For herself, she was still waiting. With a teenager heading to college in less than a year, both problems landing simultaneously felt, as Elaine put it, “like a math problem where someone keeps adding variables without telling you.”

The numbers eventually balanced — mostly. But the five months of costs that preceded the correction are not coming back.

Related: She Checked Her Social Security Statement at 40 and Found a Number That Stopped Her Cold

Related: He Earns Too Much for Medicaid and Too Little for His Prescriptions — One Year From Medicare, Curtis Kessler Is Just Waiting

.pvv-faq-section details summary::-webkit-details-marker{display:none}.pvv-faq-section details summary::marker{display:none;content:””}.pvv-faq-section details[open] summary .pvv-faq-arrow{transform:rotate(90deg)}

Frequently Asked Questions

Can Medicare auto-enroll you in a new Part D plan without your approval?
Yes. According to Medicare.gov, if your existing Part D plan stops operating in your service area, Medicare can automatically enroll you in a replacement plan. Beneficiaries receive advance notice by mail and typically have a Special Enrollment Period to switch to a different plan after the involuntary change.
How much did the 2026 COLA increase Social Security benefits?
The 2026 COLA was 2.5%, consistent with the prior year’s adjustment. For a beneficiary receiving approximately $1,843 per month, that rate translates to roughly $46 more per month in gross benefit before any Medicare premium deductions are applied, per the SSA’s COLA information.
What is Oregon’s Medicare Savings Program and who qualifies?
Oregon’s Medicare Savings Program, administered through the Oregon Health Authority, helps income-eligible beneficiaries cover Medicare premiums. Qualifying individuals may receive reductions on Part B or Part D costs. Income and asset limits apply, and applications are submitted through the Oregon Health Authority.
What happens to Social Security payments when Medicare Part B premiums increase?
Medicare Part B premiums are automatically deducted from Social Security payments before the deposit is made. The standard Part B premium was $185 per month in 2025, according to Medicare.gov. When Part B premiums increase, beneficiaries receive less in their direct deposit even if their gross Social Security benefit went up due to COLA.
What is a Medicare Part D formulary exception request?
A formulary exception is a formal request asking a Part D insurer to cover a drug at a lower cost-sharing tier, typically requiring documentation from a prescribing physician confirming medical necessity. Under Medicare rules, insurers are required to respond to standard exception requests within 72 hours.
158 articles

Sloane Avery Wren

Senior Benefits Writer covering Social Security, Medicare, and retirement policy. M.P.P. University of Michigan. Former CBPP researcher. NSSA Certified.

Leave a Reply

Your email address will not be published. Required fields are marked *