529 Plan Tracking: Modeling Multiple Kids' College Savings with 2026's New K-12 Rules

helpful_veteran · March 28, 2026, 1:51am

Hey everyone,

I hope this finds you all well! I’ve been meaning to post about this topic for a while, and with 2026’s significant 529 rule changes, I figured now is the perfect time to discuss how we’re tracking these accounts in Beancount.

The Big 2026 Changes

If you haven’t caught up on the news yet:

K-12 withdrawal limit DOUBLED from $10,000 to $20,000 per student (thanks to the One Big Beautiful Bill Act of 2025)
Qualified K-12 expenses expanded (effective July 2025) to include curriculum materials, textbooks, tutoring services, educational therapies, and standardized test fees
This is a game-changer for families considering private school or supplemental education

Why I’m Posting This

I’ve been tracking my kids’ 529 plans in Beancount for about 3 years now, and I’ve learned a lot through trial and error. But with these new 2026 rules, I’m rethinking my structure. More importantly, I see a lot of new parents joining our community, and I want to help them avoid the mistakes I made when I started.

The Core Tracking Challenge

Managing 529 accounts in Beancount involves juggling several dimensions:

Investment Tracking:

Contributions (with gift tax considerations - $19,000/person limit in 2026)
Investment returns and market value updates
State tax deduction eligibility (varies widely by state)
Multiple beneficiaries (if you have multiple kids)

Expense & Tax Compliance:

Qualified education expenses with proper documentation
The new $20,000 annual K-12 limit per student
Reconciliation with Form 1099-Q and Form 1098-T at tax time
7-year record retention requirement for audit protection

My Current (Evolved) Account Structure

After several iterations, here’s what I’ve settled on:

Assets:Investments:529:KidName
Assets:Investments:529:KidName:Cash
Assets:Investments:529:KidName:Funds

Income:Investments:529:KidName:Gains

Expenses:Education:KidName:Tuition
Expenses:Education:KidName:Curriculum
Expenses:Education:KidName:Tutoring
Expenses:Education:KidName:TestFees

Key lessons from my journey:

Start simple. I initially tried to model every tax implication in the account structure and it was a nightmare. Metadata is your friend for that.
One account per child. Don’t try to track multiple beneficiaries in one account - you’ll regret it at tax time.
Separate cash from investments. Makes it easier to track purchase/sale activity and reconcile with provider statements.

Metadata That Actually Matters

Here’s what I tag on transactions:

On contributions:

2026-03-15 * "529 Contribution"
  Assets:Checking                           -5000 USD
  Assets:Investments:529:Child1              5000 USD
    gift-tax-year: "2026"
    contributor: "Parent1"
    state-deductible: "TRUE"

On qualified expenses:

2026-02-10 * "Private School Tuition - Spring Semester"
  Assets:Investments:529:Child1             -8000 USD
  Expenses:Education:Child1:Tuition          8000 USD
    qualified: "K12-tuition"
    receipt: "receipts/2026/tuition-spring.pdf"
    academic-year: "2025-2026"

Questions for Discussion

1. How are you handling the NEW 2026 K-12 qualified expenses?

Tutoring is now explicitly qualified - are you tracking it separately?
Curriculum materials - how granular do you get? (Every workbook vs just major purchases?)
Standardized test fees - AP exams, SAT, ACT all count now

2. Investment price tracking - automated or manual?

I’ve been using beans.price with Yahoo Finance integration - works great
Anyone built importers for specific 529 providers? (I’m with Vanguard)

3. State tax quirks

Some states DON’T recognize federal K-12 qualified expense rules
Some states recapture deductions if you withdraw for K-12
How are you tracking state-specific rules in your ledger?

4. Form 1099-Q reconciliation workflow

What queries do you run to make sure withdrawals = qualified expenses?
Any tips for making tax season less painful?

Mistakes I Made (So You Don’t Have To)

Over-engineering early on. I tried to track every possible tax scenario and ended up with 20+ accounts I never used. Start simple!
Not linking receipts. I thought I’d “remember” what expenses were for. Nope. Link those PDFs/images in metadata from day one.
Ignoring price updates. I manually entered prices… until I had 3 months of stale data and my net worth was way off. Automate this!
Not reconciling quarterly. Waiting until tax season to reconcile is a recipe for stress. Do it every 3 months.

Why This Matters (Especially in 2026)

529 accounts can grow substantially over 18 years. Getting the tracking right means:

Audit-proof documentation (IRS can request records going back 7 years)
Confidence you’re on track for college cost projections
No tax season panic trying to reconstruct qualified expenses
Clean data for state tax deduction claims
Peace of mind

With the 2026 K-12 expansion to $20,000 and new qualified expenses, more families will be using these accounts earlier. That means MORE transactions to track and MORE complexity.

Let’s Learn Together

I know I don’t have all the answers - I’m still learning! I’d love to hear:

What’s working for your 529 tracking setup?
Anyone dealt with beneficiary changes? (e.g., one kid gets scholarship, transfer to sibling)
Tax pros: what do you wish your clients tracked better?
Parents of multiple kids: how do you keep it all organized?

Looking forward to the discussion!

— Mike

tax_tina · March 28, 2026, 1:52am

Mike, this is EXACTLY the kind of question I love seeing! As an Enrolled Agent who’s helped countless clients navigate 529 tax reporting, I can tell you that getting the tracking right from day one is one of the smartest financial decisions you can make.

You’re Ahead of the Curve

The fact that you’re thinking about this NOW, with the 2026 rule changes fresh, puts you miles ahead of the typical taxpayer I see during tax season who’s trying to reconstruct a year’s worth of qualified expenses from memory and a shoebox of receipts.

Critical Tax Documentation Points

Let me emphasize a few things from the IRS compliance perspective:

1. Form 1099-Q Reconciliation is Non-Negotiable

Every year, your 529 provider will issue Form 1099-Q showing:

Box 1: Total distributions
Box 2: Earnings (the portion subject to tax if misused)
Box 3: Basis (your original contributions)

Here’s the thing most people miss: Form 1099-Q doesn’t tell you ANYTHING about how the money was spent. That’s on YOU to prove. When 529 funds are used for qualified expenses, there’s usually nothing to report on your tax return. But if the IRS ever questions it, you need ironclad documentation.

Your metadata approach with qualified: "K12-tuition" is perfect. I’d also recommend adding:

form-1099q-year: "2026" to match withdrawals to the correct tax year
academic-institution: "School Name" for K-12 expenses (helps if audited)

2. The State Tax Trap

This is where people get burned: Not all states recognize federal K-12 qualified expense rules.

For example:

California, Colorado, Delaware, Hawaii, Michigan, Montana, and Nevada do NOT offer state tax benefits for K-12 withdrawals
Some states will RECAPTURE previously claimed deductions if you withdraw for K-12

Your metadata field state-deductible: "TRUE" is smart, but I’d go one step further:

2026-03-15 * "529 Contribution"
  Assets:Checking                           -5000 USD
  Assets:Investments:529:Child1              5000 USD
    gift-tax-year: "2026"
    contributor: "Parent1"
    state-deduction-eligible: "TRUE"
    state-k12-recapture-risk: "FALSE"  # Check your state!

3. The New 2026 K-12 Qualified Expenses (and Their Limits)

You asked about how granular to get with curriculum materials and tutoring. Here’s my professional recommendation:

Track these separately:

Tuition (always qualified, subject to $20,000 annual limit)
Curriculum materials: textbooks, workbooks, digital tools (NEW for 2026, subject to limit)
Tutoring services (NEW for 2026, subject to limit)
Educational therapies for students with disabilities (NEW for 2026)
Standardized test fees: AP exams, SAT, ACT, CLEP (NEW for 2026)

Do NOT count as qualified for K-12:

Computers and internet access (qualified for COLLEGE, not K-12)
Room and board (only for post-secondary education)
Transportation
Sports/activity fees (unless part of required curriculum)

The $20,000 limit is per student, per year, and applies to ALL K-12 expenses combined. If you have two kids and two 529 accounts, you can withdraw up to $40,000 total ($20K per child).

4. The 7-Year Record Retention Rule

IRS can audit returns going back 3 years normally, or 6 years if they suspect substantial underreporting. Best practice: Keep 529 documentation for 7 years after the tax return is filed.

Your approach of linking receipts in metadata (receipt: "receipts/2026/tuition-spring.pdf") is excellent. Just make sure those files are backed up! I’ve seen clients lose documentation due to hard drive failures and it’s devastating during an audit.

Common Mistakes I See Every Tax Season

Mistake #1: Relying on Form 1098-T
Form 1098-T (from colleges) is INCOMPLETE. It doesn’t include:

Room and board costs
Books and supplies purchased outside the bookstore
Computers and internet access
K-12 tuition (not reported on 1098-T at all)
Student loan repayments (up to $10K lifetime, another use of 529 funds)

Don’t use 1098-T as your source of truth. Use YOUR Beancount ledger.

Mistake #2: Mixing Tax Years
529 distributions and qualified expenses must occur in the same tax year. If you withdraw in December 2026 but pay tuition in January 2027, you’ve created a tax problem.

Add metadata: tax-year: "2026" on BOTH the withdrawal and the expense to ensure they match.

Mistake #3: Ignoring the Gift Tax Reporting Threshold
You mentioned the $19,000 per person limit in 2026. That’s correct. But here’s what people forget:

If you contribute MORE than $19,000 in one year:

You won’t owe gift tax (lifetime exemption is $13.61 million in 2026)
But you MUST file Form 709 (Gift Tax Return)

If you’re doing superfunding (5 years of contributions at once = $95,000 per person), you MUST elect to spread it over 5 years on Form 709. Track this carefully:

2026-01-15 * "529 Superfunding Contribution - Year 1 of 5"
  Assets:Checking                           -95000 USD
  Assets:Investments:529:Child1              95000 USD
    superfunding: "TRUE"
    superfunding-year: "1/5"
    superfunding-start: "2026"
    gift-tax-annual-allocation: "19000"  # K per year for 5 years

My Recommended Beancount Workflow for Tax Compliance

Quarterly (Every 3 Months):

Reconcile 529 account balances with provider statements
Verify all withdrawals have matching qualified expense documentation
Check that metadata is complete (qualified category, receipt link, etc.)
Run a query: Total withdrawals = Total qualified expenses for the year so far

Annually (January):

When Form 1099-Q arrives, reconcile Box 1 (distributions) with your Beancount withdrawal total
Reconcile your qualified expenses with the $20,000 K-12 limit (if applicable)
Generate a report showing: Withdrawals by category, qualified expenses by category, any shortfall/excess
If withdrawals > qualified expenses, calculate tax owed on excess (earnings portion × your tax rate + 10% penalty)

Tax Season (February-April):

Provide your tax preparer (or yourself) with:
- Form 1099-Q from 529 provider
- Beancount report: Qualified expenses by category
- Supporting documentation (receipts, tuition bills)
If 100% of withdrawals went to qualified expenses: Nothing to report on tax return
If excess withdrawals: Report earnings portion on Form 1040, calculate penalty

Questions You Should Be Asking Your 529 Provider

What’s the account’s aggregate contribution limit? (Varies by state: $235K-$529K)
Does my state offer a tax deduction for contributions? What’s the annual limit?
Does my state recapture deductions for K-12 withdrawals?
What’s the process for changing beneficiaries? (In case one kid gets a scholarship)
Can I link my 529 account to Plaid or similar for automated transaction imports?

Final Thoughts

Mike, your account structure and metadata approach are solid. My only additions would be:

Add form-1099q-year metadata to tie withdrawals to the correct tax form
Track state-specific K-12 recapture risk
Build a quarterly reconciliation habit (don’t wait for tax season)
Test your system with ONE child’s account before replicating to the second

And to answer your question about “what queries do you run” - here’s the key one:

SELECT account, sum(position) WHERE account ~ '529' AND year = 2026

This shows total 529 activity for the year. You can then filter by metadata to separate contributions vs withdrawals vs qualified expenses.

The peace of mind you’ll have during tax season is worth every minute spent setting this up correctly. I’ve seen too many clients with $10K+ in penalties because they couldn’t prove their expenses were qualified. Don’t be that person!

— Tina