The Tax Software Vendor Lock-In Tax: Paying $2,400/Year for Data You Already Have in Beancount

General
1

I need to make a confession that’s been bothering me as a former IRS auditor turned tax preparer: I pay Drake Tax $200/month—$2,400/year—to store data I already have perfectly organized in Beancount. And I know I’m not alone in this.

The Absurd Duplication Problem

Here’s what drives me crazy: My Beancount ledger has every transaction with perfect categorization, supporting documentation, timestamps, and an audit trail that would make any IRS examiner happy. Every business expense is tagged with its tax category. Every 1099 is recorded. Every estimated payment is tracked.

But when tax season rolls around? I sit down with Drake Tax and manually re-enter everything. Or I export CSV files and wrangle them into Drake’s finicky import format (which breaks half the time). I’m essentially paying $2,400/year to rent storage space for my own data in a proprietary format.

The 2026 Pricing Reality

Let’s talk numbers, because this affects everyone differently:

Professional tax software in 2026:

  • Drake Tax: ~$200/month during tax season ($2,400/year for year-round access) - best value, community favorite
  • ProSeries: Unlimited bundles or pay-per-return, mid-market pricing, form-based approach
  • Lacerte: High-powered but expensive, for complex firms with demanding clients

Consumer options:

  • TurboTax Premium: $139 federal + $64 per state for personal returns
  • Fine for W-2 employees, but limitations hit fast with self-employment, rentals, or crypto

For context: I’m paying professional software prices because my clients need multi-state returns, depreciation schedules, and audit support. But the core data entry? That’s already done in Beancount.

The Lock-In Trap

Here’s where it gets worse. After 5+ years with Drake Tax, I have:

  • Multi-year carryforward data (NOLs, capital losses, depreciation schedules)
  • Saved client tax profiles
  • Historical e-file records
  • Custom diagnostic rules

Switching to ProSeries or Lacerte means either manual re-entry of historical data or accepting incomplete carryforward tracking. The switching cost isn’t just this year’s subscription—it’s reconstructing years of tax history.

And the IRS e-file ecosystem keeps us locked in: paid preparers MUST use IRS-approved e-file software. We can’t just fill out PDFs and submit them. The approved software list? All commercial products.

Open Source Hope (With Realistic Limitations)

I’ve researched alternatives:

  • OpenTaxSolver (OTS): Free, calculates Federal/State personal income taxes, works on all platforms
  • UsTaxes: Open source Form 1040 filing (web + desktop), privacy-focused, actively maintained

But here’s the problem: neither integrates with Beancount. I’d still need to manually transcribe data from Beancount reports to open source tax calculators. And for paid preparers, we can’t e-file with these tools anyway.

What I Want to Know

I’m sharing this frustration because I suspect many of you are facing the same absurd situation:

  1. Has anyone built a Beancount-to-Schedule-C/E workflow? Even semi-automated would be huge.

  2. What’s your current solution? Are you paying the tax software subscription? Using a CPA who manually re-enters everything? Found a clever workaround?

  3. For FIRE folks or simple returns: Is OpenTaxSolver actually viable? Or does it lack critical features?

  4. Would the community value a “Beancount Tax Report Generator”? Something that outputs year-end summaries in formats tax software can import (or at least formatted for easy manual entry)?

The irony isn’t lost on me: Beancount gives us perfect transaction-level accounting with complete transparency and audit trails… and then we pay $1,200-$6,000/year to commercial software to duplicate that work in a black box.

There has to be a better way. What’s working for you?

Background: Tina Washington, IRS Enrolled Agent, Phoenix AZ. Using Beancount for client audit-ready records for 6 years, Drake Tax for actual filing. The cognitive dissonance is real.

2

Tina, this hits home hard. Let me translate your $2,400/year into FIRE language: that’s $60,000 invested over 25 years at 7% real return. For someone targeting a $1.5M portfolio to retire, that’s 4% of your freedom number just… evaporating into tax software subscriptions.

My Admittedly Imperfect Workaround

I’ve been tracking everything in Beancount for 6 years (FIRE journey: from -$40K student loans to $380K net worth). Here’s my janky but functional tax workflow:

Step 1: Year-End Export

  • Run Beancount query to generate income statement by tax category
  • Export to CSV with columns matching TurboTax import expectations (mostly)
  • For investments: separate script exports Schedule D (capital gains) with cost basis, dates, proceeds

Step 2: Manual Mapping Theater

  • Open TurboTax Premium ($139, not $2,400 but still annoying)
  • Import CSVs where they work (about 60% success rate)
  • Manually fix the 40% that breaks (foreign characters, long descriptions, edge cases)
  • Total time investment: 2-3 hours annually

Step 3: Sanity Check

  • Compare TurboTax final numbers to Beancount query totals
  • Usually find 1-2 transcription errors this way

The Cost-Benefit Math:

  • Time saved vs full manual entry: ~4 hours
  • Cost: $139 TurboTax Premium vs $2,400 Drake
  • Acceptable because my return is relatively simple: W-2 + investment income + HSA contributions

What I HAVEN’T Solved:

  • Capital loss carryforwards still manually tracked year-to-year in TurboTax (Beancount doesn’t track tax basis adjustments automatically)
  • Crypto transactions are a nightmare (I maintain separate spreadsheet, then import to both Beancount AND TurboTax separately)
  • State tax optimization (live in WA with no income tax, but have CA income from side projects - manually calculated)

My Question for You, Tina

For someone with simple tax situation (W-2 salary + index fund investing + no rentals/business), is OpenTaxSolver actually sufficient? Or are there hidden gotchas that TurboTax/Drake catch automatically?

I’m genuinely curious if I could drop to $0 tax software cost by:

  1. Maintaining Beancount with perfect categorization (already doing this)
  2. Generating my own Schedule D from investment transactions (already scripted)
  3. Using OpenTaxSolver for federal form calculation (the missing piece)
  4. State return handled separately (WA has none, so this is easy for me)

The Real Challenge: What’s the minimum viable integration between Beancount and tax filing? We don’t need full automation. We just need:

  • Reliable CSV templates that tax software actually accepts
  • Or… pre-formatted tax schedules that reduce transcription errors
  • Or… better yet, a Beancount plugin that outputs IRS-readable XML? (Probably overkill)

The FIRE mindset says: every dollar not spent on subscriptions is a dollar working toward freedom. But the risk-averse side says: don’t mess with the IRS over $139/year.

Where’s the balance?

Context: Frederick Chen, Seattle. 6 years into FIRE journey. Beancount user since 2020. Tracking every transaction to calculate exact FI date (currently projecting 2031 at 43 years old if market cooperates). $139 TurboTax subscription bothers me more than it probably should.

3

This thread captures exactly why I ended up with a hybrid approach that I’m… mostly satisfied with (but it still feels inefficient).

My Journey Through Tax Software Hell

2018-2020: Used TurboTax Deluxe, simple W-2 + investment income, Beancount tracked everything beautifully, tax time was just manual transcription (annoying but manageable).

2021: Bought first rental property. Suddenly needed TurboTax Premier for Schedule E (rental income/expenses). Cost jumped to $89 → $119. Fine, whatever.

2022: Bought second rental property. Depreciation schedules across multiple properties, passive activity loss limitations, multi-state filing (rentals in different states). TurboTax started feeling inadequate for complexity. Found a local CPA.

2023-Present: Pay CPA $800/year. She uses Lacerte (expensive professional software). I send her Beancount-generated reports: P&L by property, expense breakdowns, rental income summaries. She manually re-enters everything into Lacerte.

The Cognitive Dissonance

Here’s what kills me: My Beancount ledger has:

  • Perfect categorization by property (using account hierarchy: Expenses:Rental:Property1:Repairs, etc.)
  • Every receipt linked via metadata tags
  • Depreciation tracked with custom Python scripts (27.5 year straight-line, component depreciation for major improvements)
  • Multi-year basis calculations for Section 1250 recapture exposure

My CPA’s Lacerte has: manual re-entry of all the above, but with built-in depreciation tables, carryforward tracking, and diagnostic warnings I wouldn’t catch on my own.

The cost:

  • $800/year CPA fee (includes review, e-file, basic audit support)
  • BUT: probably saves me 20+ hours of tax form complexity hell
  • AND: provides professional liability shield (if IRS audits, CPA represents me)

Is $800/year for “manual data re-entry + professional review” reasonable? My FIRE brain says no. My “don’t want to face IRS alone” brain says yes.

I Actually Tested OpenTaxSolver (Here’s What Happened)

Last year I got curious and ran my return through OpenTaxSolver in parallel with my CPA’s Lacerte filing. Just to see.

What worked:

  • Basic 1040 calculations were correct
  • Standard deduction, income calculations, tax brackets all matched
  • Interface is… functional (not pretty, but gets the job done)

What was painful:

  • Schedule E (rental income) required manual entry of EVERY property expense line by line
  • No automatic depreciation calculations - I had to input depreciation amounts manually from my Python scripts
  • Multi-state filing meant downloading separate state tax calculators, each with different interfaces
  • No carryforward tracking - had to manually reference 2023 return for capital loss carryovers

Time investment: 8 hours vs 2 hours with TurboTax vs 30 minutes just sending reports to CPA.

Conclusion: For simple W-2 returns, OpenTaxSolver is absolutely viable. For rental properties, self-employment, or complex situations? The time cost exceeds any software subscription savings.

The Real Vendor Lock-In Isn’t Software—It’s The IRS E-File Ecosystem

Fred mentioned this, but it deserves emphasis: paid tax preparers MUST use IRS-approved e-file software. The approved list? All commercial products. Zero open source options.

So even if we built perfect Beancount-to-tax-form automation, professional CPAs/EAs like Tina can’t use it for client filing. They’re legally locked into Drake/ProSeries/Lacerte.

The lock-in isn’t technical—it’s regulatory.

What Would Actually Help

I’ve been thinking about this for 3 years (since I started hating my CPA workflow). Here’s what I’d love to see:

1. Beancount Tax Report Templates

  • Pre-formatted reports matching Schedule C/E line items
  • CPA gets PDF that’s formatted like tax forms (easy visual mapping to Lacerte/Drake)
  • Reduces transcription errors

2. CSV Export Standard for Professional Tax Software

  • Community-maintained CSV templates for Drake, ProSeries, Lacerte import
  • Not perfect, but reduces manual entry even if 60% success rate (as Fred mentioned)
  • Document exactly which fields map to which tax form lines

3. “Tax Interview” Plugin

  • Asks questions to identify which tax forms you need
  • Generates relevant reports from Beancount data
  • Outputs: “You need Schedule C, Schedule E, Form 8825, Form 4562” + generated reports

4. Depreciation Tracking Plugin (someone please build this)

  • Track asset purchases with metadata: 2022-03-15 * "Rental Property Roof Replacement" #depreciation #property1
  • Automatically calculate depreciation schedules
  • Generate Form 4562 data in CSV format
  • Track accumulated depreciation for basis adjustments

Would these eliminate the $800 CPA fee? Probably not—I value professional review. But they’d reduce CPA time (maybe fee drops to $500?), increase data accuracy, and make me feel less silly about duplicate data entry.

To Answer Fred’s Question

For W-2 + investment income, is OpenTaxSolver sufficient?

Yes, with caveats:

  • If you’re comfortable manually entering data (it’s not streamlined)
  • If you double-check calculations against IRS instructions (no hand-holding)
  • If you have time to learn the interface (2-3 hours first year)
  • If your state has an OpenTaxSolver calculator (not all do)

Benefits:

  • $0 cost vs $139 TurboTax
  • Privacy (your data isn’t Intuit’s product)
  • Control (you see exactly how calculations work)

Trade-offs:

  • No automatic carryforward (manually track capital losses, credits, etc.)
  • No “maximizer” features (TurboTax suggests deductions you might miss)
  • Interface is purely functional, not user-friendly

For your situation (WA resident, W-2 + investments, no state tax), I’d say try OpenTaxSolver with TurboTax as backup. Run both, compare results, see which workflow you prefer. The $139 vs $0 decision is worth 2-3 hours of experimentation.

Background: Michael Chen, San Francisco. 4+ years Beancount user. 2 rental properties. CPA handles tax filing ($800/year). Tracking depreciation in Beancount with custom scripts. Still searching for the “optimal” workflow that probably doesn’t exist.