The Great Wealth Transfer: Tracking Inheritance and Gifts in Beancount

General
1

Hey everyone!

Just came across some staggering statistics: $84 trillion is expected to transfer from Baby Boomers to younger generations through 2045 (Cerulli Associates). Updated projections even suggest $124 trillion by 2048 (Bankrate). This is the largest intergenerational wealth transfer in history!

Many of us in the Beancount community are either:

  • Planning to give wealth to heirs (parents, grandparents)
  • Expecting to receive inheritances or gifts (younger folks)

My Question: How Do You Track This in Beancount?

I’m trying to figure out the best way to track both sides of this equation. Here’s what I’m wrestling with:

For Giving (Parents/Grandparents)

If you’re planning to give wealth to children or grandchildren:

  1. How do you account for planned future gifts? Do you create liability accounts?
  2. Annual gift tax exclusion (2026: $19,000/person) - how to track who got what?
  3. Estate planning in Beancount - anyone tracking trust transfers?
  4. Lifetime gift tax exemption tracking (2026: $13.99M) - worth tracking for wealthy folks?

For Receiving (Heirs)

If you’re expecting to receive inheritance:

  1. Do you include expected inheritance in net worth projections? (Seems optimistic but some FIRE calculators do this)
  2. How to account for inheritance when received? Income:Inheritance or something else?
  3. Tracking inherited assets with cost basis for future tax planning
  4. Sudden wealth management - anyone have Beancount workflows for large windfalls?

My Current Approach (Incomplete)

Right now, I’m experimenting with:

; Potential inheritance (not counted in current net worth)
2024-01-01 open Assets:Contingent:Inheritance
2024-01-01 open Equity:ContingentInheritance

; When/if received:
2026-05-01 * "Inheritance from parents"
  Assets:Checking                50000.00 USD
  Income:Inheritance            -50000.00 USD

But this feels incomplete. How do you track:

  • Inherited stocks with stepped-up cost basis?
  • Real estate inheritance?
  • Inherited retirement accounts (with RMD requirements)?

The Wealth Transfer Statistics

According to research:

  • $53+ trillion will come from Baby Boomer households (63% of transfers)
  • 42% of transfers ($35.8T) will come from the wealthiest 1.5% of households
  • $11.9 trillion will go to charities (also needs tracking for donors!)

This isn’t just rich people stuff - even modest inheritances can significantly impact financial plans.

Real-World Example

My parents (not wealthy, but comfortable) are thinking about:

  • Gifting $19K/year to me tax-free (annual exclusion)
  • Potentially helping with my down payment fund
  • Eventually leaving their house (worth ~$400K)

I want to track this properly in Beancount:

  • Receiving the annual gifts
  • How it affects my financial goals
  • Tax implications when the house is inherited (stepped-up basis vs current value)

Questions for the Community

  1. Has anyone already solved this in Beancount? Templates or examples?
  2. Should inheritance be counted in FIRE calculations before receiving? Seems risky but mathematically it matters
  3. How do you handle the emotional side? It’s weird tracking parents’ eventual passing as “income”
  4. Tax tracking for inherited assets - best practices?

Would love to hear how others are navigating this. This is literally the largest wealth transfer in human history and I suspect many of us are either giving, receiving, or both!

Sources:

2

This is such an important topic, @finance_fred! As a CPA who helps families navigate wealth transfers, I can share some professional guidance on the Beancount tracking aspect.

Tax and Accounting Structure for Wealth Transfers

Annual Gifts (The $19K Exclusion)

The 2026 annual gift tax exclusion is indeed $19,000 per person. Here’s how I recommend tracking it:

For Givers:

2026-01-15 * "Annual gift to daughter"
  Assets:Checking                    -19000.00 USD
  Expenses:Gifts:AnnualExclusion      19000.00 USD
    gift_recipient: "daughter"
    gift_year: 2026
    cumulative_to_recipient: 76000.00 USD  ; 4 years total

Track cumulative gifts in metadata - critical for estate planning!

For Receivers:

2026-01-15 * "Gift from parents"
  Assets:Checking                     19000.00 USD
  Income:Gifts:Parental              -19000.00 USD
    gift_tax_free: TRUE
    reported_on_return: FALSE  ; Gifts under exclusion not reported

The Cost Basis Problem You Mentioned

This is CRITICAL and many people get it wrong:

Gifted Assets (During Lifetime):

  • Receiver keeps donor’s cost basis (“carryover basis”)
  • If your parents bought stock for $10K, now worth $50K, and gift it to you
  • Your cost basis = $10K (theirs)
  • When you sell at $50K, you owe tax on $40K gain

Inherited Assets (After Death):

  • Receiver gets stepped-up basis to FMV at death
  • Same stock: Parents’ basis $10K, FMV at death $50K
  • Your cost basis = $50K (stepped-up)
  • Sell immediately = $0 gain!

Beancount tracking:

2026-03-15 * "Inherited stock - stepped up basis"
  Assets:Brokerage:VTI               100 VTI @ 250.00 USD  ; FMV at death
  Income:Inheritance                -25000.00 USD
    original_basis: 10000.00 USD
    stepped_up_basis: 25000.00 USD
    inherited_from: "father"
    date_of_death: 2026-03-10

This metadata is ESSENTIAL for future tax planning!

Estate Tax Considerations

The 2026 lifetime exemption is $13.99M (individual), $27.98M (married couple). Only estates above this owe federal estate tax.

Most families won’t hit this, but if tracking is needed:

2024-01-01 open Equity:LifetimeGiftExemptionUsed
  cumulative_gifts_over_annual_exclusion: 0 USD
  remaining_lifetime_exemption: 13990000 USD

Every gift over annual exclusion reduces lifetime exemption (but doesn’t trigger tax until exemption exhausted).

Inherited Retirement Accounts - Special Rules!

This is where it gets complex. Inherited IRAs/401(k)s have new rules:

SECURE Act 2.0 (2020+):

  • Most non-spouse beneficiaries must withdraw within 10 years
  • No more “stretch IRA” for most heirs
  • RMDs may apply during the 10 years (if decedent was taking RMDs)

Track this carefully:

2026-05-01 * "Inherited IRA from father"
  Assets:Retirement:InheritedIRA     200000.00 USD
  Income:Inheritance                -200000.00 USD
    inherited_account_type: "Traditional IRA"
    decedent_age_at_death: 75
    required_distribution: "10-year rule"
    annual_rmd_required: TRUE
    must_deplete_by: 2036-05-01

Then track annual RMDs:

2026-12-31 * "Inherited IRA RMD - year 1 of 10"
  Assets:Retirement:InheritedIRA     -18000.00 USD
  Income:InheritedIRA:RMD             18000.00 USD
    taxable_as_ordinary_income: TRUE
    remaining_balance: 182000.00 USD

Real Estate Inheritance

For your parents’ $400K house scenario:

2028-06-15 * "Inherited parents' home"
  Assets:RealEstate:InheritedHome    400000.00 USD  ; FMV at death (stepped-up)
  Income:Inheritance                -400000.00 USD
    original_purchase_price: 150000.00 USD
    fmv_at_inheritance: 400000.00 USD
    property_address: "123 Main St"

If you sell immediately:

2028-08-01 * "Sale of inherited home"
  Assets:RealEstate:InheritedHome   -400000.00 USD
  Assets:Checking                    395000.00 USD  ; After closing costs
  Expenses:RealEstate:ClosingCosts     5000.00 USD
    capital_gain: 0 USD  ; Sold at stepped-up basis

The Emotional Tracking Question

You asked about the awkwardness of tracking parents’ passing. I tell clients: This isn’t morbid, it’s responsible.

Use separate account namespaces:

  • Assets:Actual:* - Money you have now
  • Assets:Contingent:* - Potential inheritance (not counted in net worth)

Only move from Contingent to Actual when received.

FIRE Calculations

Should you count inheritance before receiving it?

My professional advice: NO for core FIRE number, YES for sensitivity analysis.

Create scenarios:

  • Conservative: Zero inheritance assumed
  • Moderate: 50% of expected inheritance at age 65
  • Optimistic: 100% of expected inheritance at median actuarial age

Never base your FIRE date on inheritance. But DO model how it changes plans if it happens.

Common Mistakes

  1. Not tracking cost basis - Leads to overpaying taxes
  2. Confusing gift vs inheritance basis - Massive tax implications
  3. Ignoring inherited IRA RMD rules - Can trigger penalties
  4. Not documenting FMV at death - Burden of proof is on you!
  5. Forgetting state estate taxes - Some states have much lower thresholds

One Last Thing: Charitable Giving

$11.9T going to charity! If you’re planning charitable bequests:

2026-01-01 open Expenses:Charitable:Bequests
  planned_bequest_to_charity: 100000 USD
  charity_name: "Local Food Bank"
  estate_percentage: 10%

This helps heirs understand estate distribution plans.

Happy to discuss specifics! Wealth transfer is complex but Beancount can handle it beautifully with proper structure. :clipboard:

3

@finance_fred - This hits close to home. My parents are in their early 70s and we’ve been having “the conversation” about inheritance. It’s awkward, but necessary.

My Personal Experience Receiving Inheritance

Last year (2025), my grandfather passed away and left me 0K. Here’s exactly how I tracked it in Beancount, and lessons learned:

Initial Recording

2025-08-15 * "Inheritance from grandfather"
  Assets:Checking                     50000.00 USD
  Income:Inheritance                 -50000.00 USD
    inherited_from: "William Chen (grandfather)"
    estate_executor: "Uncle David"
    date_of_death: 2025-07-22
    probate_completed: 2025-08-10

What I Wish I’d Done Differently

Document EVERYTHING immediately:

  • I should have requested the estate’s appraisal documents right away
  • Needed for future tax purposes (especially if inheritance included appreciated assets)
  • The executor won’t keep records forever!

Separate the emotional from the financial:

  • I created a ledger comment section for memories/gratitude
  • The financial tracking is clean and professional
  • But I added personal notes that made it feel less cold:
2025-08-15 * "Inheritance from grandfather"
  ; Personal note: Grandpa worked 40 years as a teacher
  ; He saved diligently so his grandkids could have opportunities
  ; This money represents a lifetime of sacrifice - use it wisely
  Assets:Checking                     50000.00 USD
  Income:Inheritance                 -50000.00 USD

This helped me process the emotional side while keeping finances organized.

The Contingent Account Approach

@accountant_alice’s suggestion about Assets:Contingent:* is brilliant! After receiving my inheritance, I started tracking potential future inheritance from my parents:

; Note: This is NOT counted in my net worth calculations
2025-09-01 * "Estimated future inheritance - for planning only"
  Assets:Contingent:Inheritance       250000.00 USD  ; Rough estimate
  Equity:ContingentInheritance       -250000.00 USD
    estimated_assets: "Parents' home (0K) + retirement accounts (0K)"
    split_with: "Sister (50/50)"
    actuarial_timing: "2045-2055 estimate"
    note: "Do NOT count toward FIRE number!"

This lets me run “what-if” scenarios in my retirement planning without fooling myself into thinking I have money I don’t actually have yet.

My BQL Query for Actual vs Contingent

I created a custom query to separate real net worth from scenarios:

SELECT 
  'Actual Net Worth' as category,
  sum(position) as amount
WHERE
  account ~ '^Assets' 
  AND NOT account ~ 'Contingent'
UNION ALL
SELECT 
  'Contingent (Not Real!)' as category,
  sum(position) as amount
WHERE
  account ~ 'Contingent'

This gives me:

  • Actual Net Worth: 5K (money I have)
  • Contingent: 0K (money I might someday have)

Keeps me honest!

Advice from Someone Who’s Been Through It

  1. Don’t rush financial decisions after receiving inheritance

    • I put the 0K in a HYSA for 6 months
    • Gave myself time to grieve and think
    • Then made rational allocation decisions

  2. Track the “before and after” impact

    • My net worth jumped 25% overnight
    • Had to recalibrate my FIRE calculations
    • Moved my FIRE date up by 3 years!

  3. Be grateful but realistic

    • Inheritance is a gift, not an entitlement
    • My grandfather didn’t owe me anything
    • Track it as Income:Inheritance - it IS income

  4. Consider the giver’s intent

    • Grandpa wanted education/home down payment use
    • I added metadata tracking that intent:
intended_use: "Education savings for future children"
allocated_to_goal: "Assets:Goals:FutureEducation"

The Uncomfortable Truth About Wealth Transfer

Here’s what nobody talks about: You benefit financially from your parents passing away. That feels gross to say out loud!

But being systematic about tracking doesn’t mean you’re being callous. It means you’re being responsible with the fruits of their lifetime of work.

My approach: Treat potential inheritance with respect
by planning wisely, but never counting on it or wishing for it.

One More Thing: Talk to Your Parents!

The best inheritance planning tool isn’t Beancount - it’s having honest conversations while everyone’s still healthy.

Ask:

  • “Do you have a will/trust?”
  • “Who’s the executor?”
  • “Where are important documents?”
  • “What are your wishes?”

This isn’t morbid. It’s loving. And it makes the Beancount tracking much cleaner when the time comes, because you know exactly what to expect.

@finance_fred - The fact that you’re thinking about this systematically shows maturity. Your future self (and your family) will thank you. :blue_heart:

4

From a practical bookkeeping perspective, I’ve helped several small business clients navigate business inheritance - when they inherit family businesses or when they’re planning to pass their business to their kids.

Business Inheritance Tracking

Receiving a Business:

2025-04-01 * "Inherited father's plumbing business"
  Assets:Business:Inventory            50000.00 USD  ; FMV at death
  Assets:Business:Equipment            80000.00 USD  ; Stepped-up basis
  Assets:Business:AccountsReceivable   25000.00 USD
  Liabilities:Business:AccountsPayable -15000.00 USD
  Liabilities:Business:EquipmentLoan   -30000.00 USD
  Income:Inheritance                  -110000.00 USD  ; Net value
    business_name: "Chen Plumbing LLC"
    inherited_from: "father"
    business_valuation_date: 2025-03-15
    valuation_method: "Asset-based approach"

Gift of Business Equity (Common for Family Businesses)

Many parents gift equity gradually to reduce estate tax:

2026-01-10 * "Annual gift of 5% business equity from parents"
  Assets:Business:Equity                 19000.00 USD  ; 5% x 0K valuation
  Income:Gifts:BusinessEquity           -19000.00 USD
    gifted_equity_percentage: 5%
    cumulative_ownership: 25%  ; Now own 25% total
    remaining_parent_ownership: 75%
    valuation_date: 2025-12-31

Practical Workflow for Annual Exclusion Gifts

One client (coffee shop owner) uses Beancount to track annual gifts to two kids:

January 1st each year:

2026-01-01 * "Annual gift to daughter - 2026 exclusion"
  Assets:Personal:Checking              -19000.00 USD
  Expenses:Gifts:Daughter2026            19000.00 USD
    gift_year: 2026
    cumulative_total_daughter: 95000.00 USD  ; 5 years

2026-01-01 * "Annual gift to son - 2026 exclusion"
  Assets:Personal:Checking              -19000.00 USD
  Expenses:Gifts:Son2026                 19000.00 USD
    gift_year: 2026
    cumulative_total_son: 95000.00 USD

Then he runs a query to track totals:

SELECT 
  sum(position) as total_gifted_daughter
WHERE 
  account ~ 'Expenses:Gifts:Daughter'

Simple, clean, and ready for tax time!

My Recommendation: Keep It Simple

Don’t over-complicate inheritance tracking. Most people just need:

  1. Clear account naming: Income:Inheritance for received, Expenses:Gifts for given
  2. Metadata for details: Who, when, value, tax treatment
  3. Separate contingent from actual: Don’t count money you don’t have yet

That’s 90% of what most families need. The other 10% (trusts, estate planning) - hire a lawyer and CPA, then track what they tell you to track!

Happy to help if anyone wants template structures for common scenarios. :bar_chart: