Real Estate Portfolio Tracking: Rental Income, Depreciation, and Property-Level P&L

Hey everyone,

I’ve been using Beancount for tracking my investment portfolio and personal finances for the past 3 years, and it’s been absolutely transformative for my FIRE journey. But now I’m expanding beyond index funds into real estate investing, and I’m hitting some complexity walls that I’d love the community’s help with.

The Challenge

I just closed on my second rental property (both single-family homes), and I’m realizing my simple account structure won’t scale. Here’s what’s keeping me up at night:

Property-Level Visibility: I need to see P&L for each property individually. Property A might be cash-flow positive while Property B is still underwater due to renovation costs. Right now, everything’s mixed together and I can’t easily tell which property is performing well.

Depreciation Tracking: The IRS lets residential rental properties depreciate over 27.5 years. I know I need to track this for tax purposes AND for when I eventually sell (depreciation recapture is real, folks). But how do you actually model this in Beancount? Do I create manual transactions each month? Use plugins? I’m lost.

Capital Improvements vs Repairs: This is the tax minefield. A new roof is a capital improvement (depreciable over time). Fixing a leaky faucet is a repair (immediately deductible). The distinction matters enormously for taxes, but tracking it correctly in Beancount has me confused. Do I use different account hierarchies? Metadata tags? Both?

1031 Exchange Planning: I’m already thinking about tax-deferred exchanges down the road. When I sell Property A and roll it into Property C, I need immaculate records of the original purchase price, all capital improvements, and accumulated depreciation. How do you structure your accounts so this data is readily available years from now?

Schedule E Alignment: My CPA uses Schedule E (Form 1040) for rental income reporting. It has specific expense categories (advertising, auto/travel, cleaning, insurance, repairs, etc.). Should I mirror these categories in my Beancount account structure? Or maintain my own structure and map it during tax season?

What I’ve Tried

Right now I have a basic structure like:

Assets:RealEstate:PropertyA
Assets:RealEstate:PropertyB
Liabilities:Mortgage:PropertyA
Liabilities:Mortgage:PropertyB
Income:Rental:PropertyA
Income:Rental:PropertyB
Expenses:RealEstate:Maintenance
Expenses:RealEstate:Insurance
Expenses:RealEstate:PropertyTax

But this doesn’t handle:

  • Separate expense tracking per property
  • Capital improvements vs repairs distinction
  • Depreciation schedules
  • Property basis tracking for future sale calculations

Questions for the Community

  1. Account Structure: What’s your recommended account hierarchy for tracking multiple rental properties? Do you create completely separate trees for each property, or share expense categories?

  2. Depreciation: How do you track depreciation in Beancount? Manual monthly/annual transactions? Plugins? Do you track it at all, or just let your tax software handle it?

  3. Capital Improvements: How do you distinguish and track capital improvements separately from repairs? Metadata? Account naming? Both?

  4. Property-Level Reporting: What Beancount queries or Fava features do you use to generate property-specific P&L statements?

  5. Tax Integration: How do you go from Beancount data to Schedule E? Manual extraction? Scripts? Do you have query templates?

I know this is a lot, but I’m committed to getting this right from the start. With the 2026 depreciation changes (thanks to the One Big Beautiful Bill Act restoring 100% bonus depreciation), there’s real money at stake in tracking this correctly.

Any advice, example account structures, or lessons learned from those of you managing rental properties in Beancount would be incredibly valuable!

– Fred

Fred, this is a great question and you’re smart to get this right from the start. I work with several clients who own rental properties, and proper tracking makes a huge difference come tax season (and during IRS audits, which I’ve helped clients survive).

Let me walk you through a professional approach that balances tax compliance with Beancount’s capabilities.

Account Structure: Mirror Schedule E

Yes, I strongly recommend mirroring IRS Schedule E categories in your Beancount structure. This makes tax preparation dramatically easier and reduces errors. Here’s the structure I recommend to clients:

Assets:RealEstate:1234-Oak-St:Building
Assets:RealEstate:1234-Oak-St:Land
Assets:RealEstate:5678-Elm-Ave:Building
Assets:RealEstate:5678-Elm-Ave:Land

Liabilities:Mortgage:1234-Oak-St
Liabilities:Mortgage:5678-Elm-Ave

Income:Rental:1234-Oak-St
Income:Rental:5678-Elm-Ave

Expenses:Rental:1234-Oak-St:Advertising
Expenses:Rental:1234-Oak-St:Auto
Expenses:Rental:1234-Oak-St:Cleaning
Expenses:Rental:1234-Oak-St:Insurance
Expenses:Rental:1234-Oak-St:Legal
Expenses:Rental:1234-Oak-St:Management
Expenses:Rental:1234-Oak-St:MortgageInterest
Expenses:Rental:1234-Oak-St:Repairs
Expenses:Rental:1234-Oak-St:Supplies
Expenses:Rental:1234-Oak-St:Taxes
Expenses:Rental:1234-Oak-St:Utilities
Expenses:Rental:1234-Oak-St:Other

Assets:RealEstate:1234-Oak-St:Improvements:Roof-2025
Assets:RealEstate:1234-Oak-St:Improvements:HVAC-2026

Key points:

  1. Separate Building from Land: Only the building depreciates (27.5 years residential). Land never depreciates. Split your purchase price proportionally based on the property tax assessment ratio.

  2. Property-Specific Expense Hierarchies: Notice each property gets its own complete expense tree. This gives you perfect property-level P&L isolation.

  3. Capital Improvements as Assets: Track capital improvements as separate asset sub-accounts under each property. This preserves your cost basis trail for 1031 exchanges and depreciation recapture calculations.

Depreciation: I Do Track It

Controversial opinion in the Beancount community: I do track depreciation, even though it’s non-cash. Here’s why:

  • Accurate Net Worth: Without depreciation, your balance sheet overstates asset values and net worth.
  • Basis Tracking: When you sell, accumulated depreciation affects your capital gains calculation AND must be recaptured as ordinary income (ouch).
  • 1031 Exchange Preparedness: You need exact depreciation figures to calculate adjusted basis for exchanges.

I create annual depreciation transactions (not monthly—too granular for most people):

2026-12-31 * "Annual depreciation - 1234 Oak St"
  Assets:RealEstate:1234-Oak-St:Building  -7272.73 USD
  Expenses:Rental:1234-Oak-St:Depreciation  7272.73 USD

For a $200,000 building (excluding land), that’s $200,000 ÷ 27.5 years = $7,272.73/year.

Capital Improvements vs Repairs: The $64,000 Question

The IRS distinction is critical:

  • Repairs: Maintain current condition (deduct immediately) → Expenses:Rental:PropertyX:Repairs
  • Capital Improvements: Add value, prolong life, or adapt to new use (depreciate over time) → Assets:RealEstate:PropertyX:Improvements:Description

Use both account naming AND metadata for bulletproof tracking:

2026-03-10 * "New roof installation - Oak St" ^improvement-roof-2026
  Assets:RealEstate:1234-Oak-St:Improvements:Roof-2026  12000.00 USD
  category: "capital-improvement"
  depreciation-start: "2026-03-31"
  useful-life: "27.5y"
  Liabilities:CreditCard:Chase

2026 Bonus Depreciation: A Game Changer

You mentioned the One Big Beautiful Bill Act—this is HUGE for you. For qualifying property placed in service after January 19, 2025, you can now take 100% bonus depreciation again (it was phasing down before).

This primarily applies to tangible personal property with shorter depreciation lives (appliances, carpets, fixtures) rather than the building structure itself. But if you do a cost segregation study (highly recommended for properties $500K+), you can accelerate depreciation on these components.

I recommend adding metadata to track bonus depreciation eligibility:

2026-04-01 * "New appliances - refrigerator, dishwasher, washer, dryer"
  Assets:RealEstate:1234-Oak-St:Improvements:Appliances-2026  4500.00 USD
  bonus-depreciation-eligible: true
  placed-in-service: "2026-04-01"
  Liabilities:CreditCard:Chase

Common Mistakes to Avoid

  1. Forgetting to Split Land: Land is never depreciable. If you depreciate the entire purchase price, the IRS will adjust your return.

  2. Mixing Property Expenses: Keep them separate from day one. Untangling commingled expenses during an audit is a nightmare.

  3. Losing Improvement Documentation: Keep receipts, invoices, and permits forever. Beancount metadata is perfect for linking to scanned documents.

  4. Ignoring Depreciation Recapture: When you sell, all accumulated depreciation gets taxed at 25% (not capital gains rates). Track it from the beginning.

Getting to Schedule E

At tax time, I use Beancount queries to extract data by property:

SELECT account, sum(position) 
WHERE account ~ "Expenses:Rental:1234-Oak-St"
GROUP BY account

This gives you a clean breakout by Schedule E category for each property. I have clients who generate these reports monthly for cash flow monitoring.

Hope this helps! Happy to answer follow-up questions.

Alice Thompson, CPA

Hey Fred!

Welcome to the wonderful world of rental property tracking! I’ve been managing 2 single-family rentals in Beancount for about 4 years now, and I remember feeling exactly as overwhelmed as you sound when I started. Let me share what actually works in practice (not just in theory).

My Real-World Account Structure

Alice’s advice is spot-on from a CPA perspective. Here’s how I implement it in my actual ledger—I’ve simplified a bit from the textbook approach because perfection is the enemy of done:

; Property 1: My first rental in Oakland
Assets:RealEstate:Oakland-Rental:Building
Assets:RealEstate:Oakland-Rental:Land
Liabilities:Mortgage:Oakland-Rental

Income:Rental:Oakland
Income:RealEstate:Oakland:CapitalGains  ; For eventual sale

; I do mirror Schedule E categories, but I don't use all of them
Expenses:Rental:Oakland:Insurance
Expenses:Rental:Oakland:MortgageInterest
Expenses:Rental:Oakland:PropertyTax
Expenses:Rental:Oakland:Repairs
Expenses:Rental:Oakland:Utilities
Expenses:Rental:Oakland:HOA
Expenses:Rental:Oakland:Property Management
Expenses:Rental:Oakland:Other

; Capital improvements live as separate assets
Assets:RealEstate:Oakland-Rental:Improvements:Kitchen-Remodel-2023
Assets:RealEstate:Oakland-Rental:Improvements:New-Roof-2024

Why this structure works for me:

  1. I only create expense accounts I actually use. If you’ve never paid for “Advertising” for your rental, don’t create that account yet.

  2. I use the property address nickname (Oakland-Rental, SanJose-Rental) instead of street numbers. Easier to remember when I’m entering transactions.

  3. For improvements, I include the year in the account name. In 2050 when I’m doing a 1031 exchange, I’ll thank past-me for that clarity.

My Workflow: Monthly Maintenance

Here’s my actual monthly workflow (takes about 30 minutes total for both properties):

Week 1 of the month:

  1. Import bank transactions for rent payments
  2. Import credit card charges for any property expenses
  3. Categorize everything to the property-specific accounts
  4. Add metadata tags for anything that might be audit-relevant

End of month:
5. Run my “property dashboard” query in Fava (I’ll share this below)
6. Check if either property is cash-flow negative
7. Screenshot the P&L and save it in a “monthly-snapshots” folder

End of year:
8. Create the annual depreciation transaction (one per property)
9. Generate Schedule E data export for my CPA
10. Archive the year’s transaction files

Depreciation: I Track It Too (But Simply)

I agree with Alice—I do track depreciation, but I keep it simple. One transaction per property per year:

2025-12-31 * "Depreciation - Oakland rental (year 2 of 27.5)"
  Assets:RealEstate:Oakland-Rental:Building  -6545.45 USD
  Expenses:Rental:Oakland:Depreciation
  property: "Oakland-Rental"
  year: "2/27.5"
  comment: "Building basis $180,000 / 27.5 years"

I include the “year X of 27.5” in metadata so I can track how much depreciation runway I have left. Also super helpful for explaining to my CPA during 1031 exchange planning.

Tip: I maintain a separate spreadsheet (I know, I know) tracking the exact depreciation schedule start date, initial basis, and accumulated depreciation for each property and each major improvement. Beancount handles the transactions, but the spreadsheet is my single source of truth for the math. When I eventually sell, I’ll need those exact figures.

Capital Improvements: The Metadata Is Key

For the repairs vs capital improvements distinction, I use both account structure AND heavy metadata:

Repair (immediately deductible):

2025-07-15 * "Fixed broken garbage disposal"
  Expenses:Rental:Oakland:Repairs  285.00 USD
  type: "repair"
  vendor: "Bob's Plumbing"
  receipt: "2025-07-15-bobs-plumbing.pdf"
  Liabilities:CreditCard:Chase

Capital Improvement (depreciable):

2024-06-01 * "Complete roof replacement - 30-year architectural shingles"
  Assets:RealEstate:Oakland-Rental:Improvements:New-Roof-2024  18500.00 USD
  type: "capital-improvement"
  vendor: "ABC Roofing"
  contract: "2024-06-01-abc-roofing-contract.pdf"
  useful-life: "27.5y"
  placed-in-service: "2024-06-15"
  Liabilities:CreditCard:Chase

The metadata fields I ALWAYS include for improvements:

  • type: "capital-improvement"
  • vendor: "Company Name"
  • useful-life: "27.5y" (or whatever applies)
  • placed-in-service: "YYYY-MM-DD"

Property-Level P&L: My Fava Query

This is my go-to query for Oakland property monthly P&L:

SELECT 
  account, 
  sum(position) AS total
WHERE 
  account ~ "Income:Rental:Oakland" OR 
  account ~ "Expenses:Rental:Oakland"
FROM year = 2026 AND month = 2

I run this monthly and compare: is my rent covering all expenses? If Property A is consistently cash-flow negative, I know I need to raise rent or reduce costs.

For annual reporting (to send my CPA), I drop the month filter and run it for the full year.

Lessons Learned (The Hard Way)

  1. Start simple, add complexity only when needed. I started with like 6 expense categories and added more as my needs grew. Don’t over-engineer on day 1.

  2. Tag everything with property metadata. Even though my account structure isolates by property, I ALSO tag every transaction with property: "Oakland-Rental". Redundant? Yes. Helpful when running queries? Absolutely.

  3. Backup your documents. Link to scanned receipts, contracts, inspection reports, everything. I use relative paths like receipts/2025/oakland/2025-07-15-bobs-plumbing.pdf in my metadata. When the IRS audits you in 2035, you’ll thank yourself.

  4. Separate checking accounts per property (if you can). It makes bank imports SO much cleaner. All Oakland transactions come from one bank account, all SanJose from another.

  5. The land/building split is crucial. Use your property tax assessment to determine the ratio. If the county says land is 20% of value and improvements are 80%, use that split. Defensible in an audit.

You’ve Got This

The fact that you’re asking these questions BEFORE you have a mess to clean up puts you way ahead. Start with a structure like Alice outlined or mine, stay consistent, and iterate as you learn.

Feel free to ask follow-ups—real estate + Beancount is my favorite topic and I’m always happy to help!

– Mike

Fred, as a former IRS auditor turned tax specialist, I want to emphasize something that Alice and Mike touched on but deserves its own spotlight: audit preparedness and 1031 exchange documentation.

You mentioned 1031 exchanges in your original post, which tells me you’re thinking long-term. Smart. Let me share what the IRS actually looks for when they audit rental property owners (and yes, real estate investors get audited more frequently than W-2 employees).

Documentation That Survives IRS Scrutiny

The IRS has three years from your filing date to audit most returns, but that extends to six years if they suspect you’ve understated income by 25%+ (easy to accidentally do with rental properties if you’re sloppy). And there’s no statute of limitations on fraud.

Bottom line: Keep immaculate records from day one.

What Beancount does brilliantly for audit defense:

  1. Timestamped, immutable transaction history (especially if you’re using Git version control)
  2. Complete transaction metadata linking to supporting documents
  3. Built-in balance assertions that prove your books reconcile
  4. Human-readable audit trail that you can literally print and hand to an auditor

Beancount transaction structure I recommend for audit readiness:

2026-03-01 * "Emergency plumbing repair - broken water heater" ^repair-2026-03-01
  Expenses:Rental:PropertyA:Repairs  1450.00 USD
  property: "123 Oak Street, Portland OR 97201"
  vendor: "Smith Plumbing LLC"
  vendor-ein: "93-1234567"
  invoice: "receipts/2026/03/smith-plumbing-invoice-2026-03-01.pdf"
  category: "repair"
  schedule-e-line: "14-repairs"
  description: "Water heater failed, emergency replacement, 40-gallon unit"
  Liabilities:CreditCard:Chase

Notice what I’m capturing:

  • Transaction tag (^repair-2026-03-01) for easy searching
  • Full property address in metadata (not just “PropertyA”)
  • Vendor EIN (helpful for 1099 reporting)
  • Link to scanned invoice/receipt
  • Schedule E line item mapping
  • Detailed description explaining WHY this is a repair (not a capital improvement)

1031 Exchange: The Records You’ll Need

When you execute a 1031 exchange, you need to calculate your adjusted basis in the relinquished property:

Adjusted Basis = Original Purchase Price + Capital Improvements - Accumulated Depreciation

The IRS will want documentation for EVERY component of that equation:

  1. Original Purchase Price: Closing statement from when you bought it
  2. Capital Improvements: Invoices, contracts, permits for every improvement
  3. Accumulated Depreciation: Every year’s depreciation schedule

If you can’t substantiate capital improvements with receipts, the IRS will disallow them. That increases your capital gain and your tax bill.

Beancount structure to track 1031 exchange readiness:

Create a dedicated “basis tracking” query that sums all the components:

; Original purchase (2024)
2024-05-15 * "Purchase - 123 Oak Street" ^property-purchase
  Assets:RealEstate:123-Oak-St:Building  200000.00 USD
  Assets:RealEstate:123-Oak-St:Land  50000.00 USD
  purchase-date: "2024-05-15"
  original-basis-building: "200000.00"
  original-basis-land: "50000.00"
  Liabilities:Mortgage:123-Oak-St

; Capital improvement (2025)
2025-06-01 * "New roof installation" ^improvement-roof-2025
  Assets:RealEstate:123-Oak-St:Improvements:Roof-2025  18000.00 USD
  improvement-type: "roof"
  depreciable: true
  useful-life: "27.5y"
  placed-in-service: "2025-06-15"
  Liabilities:CreditCard:Chase

; Annual depreciation (2025)
2025-12-31 * "Depreciation - 123 Oak St (Year 1)"
  Assets:RealEstate:123-Oak-St:Building  -7272.73 USD
  Expenses:Rental:123-Oak-St:Depreciation  7272.73 USD
  depreciation-year: "1"
  depreciation-method: "straight-line"
  basis-amount: "200000.00"

When it’s time for a 1031 exchange in 2030, you query:

  • Sum of all Assets:RealEstate:123-Oak-St:Improvements:* = total capital improvements
  • Sum of all annual depreciation transactions = accumulated depreciation
  • Adjusted basis = $200,000 (building) + $18,000 (improvements) - $36,363.65 (6 years × $7,272.73 depreciation) = $181,636.35

That adjusted basis determines:

  1. Your capital gain on the sale
  2. Your depreciation recapture tax (25% on the accumulated $36,363.65)
  3. Your basis in the replacement property

2026 Quarterly Estimated Tax Considerations

Since you’re holding rental properties, you likely have quarterly estimated tax obligations. Many new landlords forget this and get hit with underpayment penalties.

IRS safe harbor rules (to avoid penalties):

  1. Pay 90% of current year’s tax liability, OR
  2. Pay 100% of prior year’s tax liability (110% if AGI > $150K)

I recommend tracking quarterly estimated tax payments in Beancount:

2026-04-15 * "Q1 2026 estimated tax payment - Form 1040-ES"
  Expenses:Taxes:Federal:Estimated  5000.00 USD
  tax-year: "2026"
  quarter: "Q1"
  form: "1040-ES"
  Assets:Checking:PrimaryBank

2026-06-15 * "Q2 2026 estimated tax payment - Form 1040-ES"
  Expenses:Taxes:Federal:Estimated  5000.00 USD
  tax-year: "2026"
  quarter: "Q2"
  form: "1040-ES"
  Assets:Checking:PrimaryBank

Common Tax Mistakes with Rental Properties

Mistake #1: Not separating personal use from rental use
If you use the property personally for >14 days OR >10% of rental days (whichever is greater), your deductions get limited. Track every personal-use day in metadata.

Mistake #2: Deducting capital improvements immediately
A $15,000 kitchen remodel is NOT immediately deductible. It’s a capital improvement, depreciable over 27.5 years. Getting this wrong triggers audits.

Mistake #3: Missing the passive activity loss rules
If your income is >$150K, you may not be able to deduct rental losses against your W-2 income. Consult a tax pro on this one—it’s complex.

Mistake #4: Forgetting depreciation recapture on sale
When you sell, the IRS recaptures ALL depreciation you took (or SHOULD have taken, even if you forgot!) at 25%. This is ordinary income, not capital gains. Track it meticulously.

Tools I Recommend

For clients with rental properties in Beancount, I have them:

  1. Tag every transaction with property address, vendor, category
  2. Link to scanned documents for every invoice >$500
  3. Create annual depreciation summaries (I have a Python script for this)
  4. Run quarterly P&L reports to estimate tax payments
  5. Maintain a separate “tax planning” spreadsheet tracking cumulative depreciation, basis, and projected recapture

The Big Picture

You’re building a real estate portfolio. Done right, this could be generational wealth. Done wrong, it’s a tax nightmare that costs you thousands.

Beancount gives you the foundation for bulletproof record-keeping. Use it wisely:

  • Track everything
  • Tag everything
  • Document everything
  • Review quarterly
  • Consult a CPA annually (especially before your first sale or 1031 exchange)

Happy to answer follow-up questions. Tax compliance isn’t sexy, but it’s what lets you sleep at night when the IRS letter arrives.

Tina Washington, EA
Former IRS Auditor

Wow, this community is incredible! Alice, Mike, Tina—thank you for such thorough, actionable responses. I’m honestly blown away by the depth of knowledge here.

My Takeaways & Implementation Plan

After reading all your advice, here’s what I’m going to implement:

Account Structure:
I’m going with Alice’s recommended Schedule E-aligned structure, but starting simple like Mike suggested. I’ll create the full expense tree but only use accounts I actually need, adding more as my needs grow.

Assets:RealEstate:PropertyA:Building
Assets:RealEstate:PropertyA:Land
Assets:RealEstate:PropertyA:Improvements:{Description-Year}

Expenses:Rental:PropertyA:Insurance
Expenses:Rental:PropertyA:MortgageInterest
Expenses:Rental:PropertyA:PropertyTax
Expenses:Rental:PropertyA:Repairs
Expenses:Rental:PropertyA:Utilities
Expenses:Rental:PropertyA:Management
Expenses:Rental:PropertyA:Depreciation

And I love Mike’s advice about using property nicknames instead of street addresses. Way more memorable.

Depreciation Tracking:
You all convinced me—I’m tracking it. One annual transaction per property, exactly like Mike showed. The adjusted basis tracking for future 1031 exchanges alone justifies the extra work.

Metadata Standards:
Tina, your audit-ready transaction template is gold. I’m adopting your metadata fields:

  • property: (with full address)
  • vendor: and vendor-ein: (for 1099 tracking)
  • invoice: (relative path to scanned receipt)
  • category: (repair vs capital-improvement)
  • schedule-e-line: (tax mapping)

I’m also implementing Mike’s tip about tagging transactions with property metadata even when the account structure already isolates by property. Redundancy = resilience.

Follow-Up Questions

1. Depreciation Automation:
Mike, you mentioned you maintain a separate spreadsheet for depreciation schedules. Do any of you have Python scripts or Beancount plugins that auto-generate the annual depreciation transactions? Or do you manually create them each year?

2. Schedule E Query Templates:
Alice, you showed a basic query for extracting Schedule E data. Do you have a more complete template that maps to all the Schedule E lines (3-26)? Or do you just manually group accounts when preparing the tax return?

3. Fava Dashboards:
Has anyone built custom Fava dashboards specifically for real estate portfolio tracking? Something that shows:

  • Property-level P&L (monthly and YTD)
  • Cash-on-cash return
  • Accumulated depreciation per property
  • Projected basis for 1031 exchange

I’m willing to build this myself if it doesn’t exist, but figured I’d check if someone’s already solved this problem.

4. Cost Segregation Studies:
Tina mentioned cost segregation for accelerating depreciation. For those who’ve done this: do you model the segregated components (appliances, carpets, etc.) as separate improvement assets in Beancount? Or do you track the accelerated depreciation in your tax software and just keep the building as one asset in Beancount?

What I’m Doing This Weekend

  1. Restructure my existing Beancount accounts to the new hierarchy
  2. Split my purchase prices into Building vs Land (using property tax assessments)
  3. Reclassify my existing transactions with proper metadata
  4. Create my first annual depreciation transactions for 2024 and 2025
  5. Set up a receipts/ folder structure and start linking scanned invoices

This is going to take some time, but I can already see how much cleaner my financial picture will be.

Huge thanks again. This is exactly why I love the Beancount community—thoughtful, detailed, practical advice from people who’ve been in the trenches. You’ve saved me from months (years?) of trial and error.

I’ll report back once I’ve got everything restructured. And if I build any useful queries or tools, I’ll share them here.

– Fred

P.S. Mike, if you’re willing to share that depreciation tracking spreadsheet, I’d love to see it. Even just a screenshot or template would be super helpful.