What is an expense ratio?

It's the annual fee a mutual fund or ETF charges as a percentage of your invested assets. A 0.5% expense ratio means the fund keeps €5 of every €1,000 you have invested, every year. It's deducted silently against the fund's NAV — you don't see it as a line item on your statement.

How is the impact calculated?

Net return = gross return − expense ratio, compounded monthly. The helper runs two parallel projections — one at the gross rate (the zero-fee twin) and one at the net rate (your fund). The dollar gap between them at the end of your horizon is the total opportunity cost.

Why is the opportunity cost so much larger than the fees I actually paid?

Every euro paid in fees is also a euro that doesn't compound for the rest of your horizon. On a 30-year window at 7% gross returns, a euro of fees paid in year 1 would have grown to about €7.60 in your account by year 30. The book value of fees is what the fund charged you. The opportunity cost is what those fees plus their compound growth would have been.

What gross return should I assume?

For long-horizon retirement modelling, 6-8% is a defensible assumption for diversified global equities. Bond-heavy portfolios should use 3-5%. Cash / money-market funds run 4-5% in 2026. The point of the tool isn't to predict your return — it's to show the fee gap, which compounds the same way at any return level.

Does the tool model taxes?

No. To approximate, multiply your gross return by (1 − marginal-tax rate × dividend yield fraction) before entering it. For tax-sheltered accounts (US Roth IRA, UK ISA, IE PRSA), use the gross rate directly.

What about front-end loads or 12b-1 fees?

Those aren't modelled directly. A 5% front-end load on every contribution is equivalent to roughly an extra 0.5% expense ratio over 10 years, declining at longer horizons. The cleanest approximation is to bump the fund's expense ratio up by 0.3-0.5% in this tool to account for the load.

Is monthly compounding the right granularity?

Fund NAVs update daily, but the difference between monthly and daily compounding on a long horizon is in the 5th decimal place. We use monthly because it lines up cleanly with how most people contribute. The headline answer would shift by less than 0.1% if we switched to daily.

How does this differ from your other calculators?

The savings goal calculator solves for one of three variables (deposit, time, or final balance) assuming a single fixed rate — it doesn't model fees vs gross return as two separate inputs. The investment return calculator handles irregular cash flows and computes CAGR or XIRR on what already happened. This tool is the fee-decision tool: it isolates the cost of one specific cost component (the expense ratio) over a long horizon.

Is anything sent to your servers?

No. The math runs entirely in your browser. No figures, no fund names, no balances — nothing leaves the page. The CSV download is generated locally.

What is the best PDF bank statement converter?

The best converter depends on your accounting software. For QuickBooks, look for one that exports a native .qbo file (Web Connect format) — that skips column mapping entirely. For Xero, a tool that produces a Xero-template CSV with merged Money-In/Out columns will save the most time. StatementEdge handles both natively, plus Sage, Excel, CSV, and generic OFX, with automatic balance-chain reconciliation that flags any extraction error before you import.

How do I convert a PDF bank statement to QuickBooks?

The most reliable path is to convert the PDF directly into a QuickBooks Web Connect file (.qbo) instead of going through CSV. CSV import in QBO requires manual column mapping and breaks on UK/EU number formats. A .qbo file imports natively with no mapping. Upload your PDF to a converter that supports .qbo output (such as StatementEdge), download the .qbo, then in QBO go to Banking → Upload from file → File upload.

How do I convert a bank statement PDF to Excel?

Use a converter that respects your bank's locale (US, UK, EU, etc.) and emits an Excel file with ISO dates and signed amount columns. Generic OCR tools often misread comma decimals as thousands separators or split Money-In/Money-Out columns into two separate amount fields. Specialised converters like StatementEdge normalise these automatically before export.

Are PDF bank statement converters safe to use?

Safety depends on three things: where the file is processed, whether it's retained, and whether your data is used for AI training. StatementEdge processes files in the EU (Frankfurt), auto-deletes the source PDF within 1 hour by default, and uses AI providers with no-training settings enabled. Look for these guarantees on any converter you're considering — many tools store statements indefinitely and may be in jurisdictions without GDPR protection.

What's the difference between QBO, QFX, and OFX file formats?

All three are based on the Open Financial Exchange (OFX) SGML format from the late 1990s. .ofx is the generic format, accepted by GnuCash, MoneyDance, Beancount, and many open-source tools. .qfx is Quicken's flavour, identical to OFX 1.0.2 with Quicken-specific headers. .qbo is Intuit's QuickBooks Desktop and Online flavour, which adds an INTU.BID tag identifying the originating financial institution. For QuickBooks use .qbo; for Quicken use .qfx; for anything else use .ofx.

How do I convert scanned (image) bank statements?

Scanned PDFs don't have a text layer, so traditional CSV-export tools fail on them. You need a converter with vision capability — one that can read pixels, not just embedded text. StatementEdge detects scanned pages automatically and routes them through a vision model with the same balance-chain verification as digital PDFs, so you still get a reconciled output even from an image-only source.

Can I batch-convert multiple bank statements at once?

Yes. StatementEdge accepts multiple PDFs in a single drag-and-drop or file selection — each becomes its own conversion job and the results page shows per-file status with the reconciliation verdict for each. For programmatic batch processing, the REST API is available on every plan (free tier included) and exposes the same conversion endpoint.

Free tool

Expense ratio impact helper — what a fund's fees really cost you

A 1% expense ratio doesn't sound like much. Over 30 years at typical equity returns, it eats roughly a quarter of your final balance. Enter your inputs below and see the real number — plus a side-by-side compare for two funds. Runs in your browser.

Mode

Initial investment

Lump-sum you start with. Set to 0 if you're building from scratch.

Monthly contribution

€/mo

Time horizon (years)

Gross annual return (before fees)

What the underlying index returns annually. Long-run global equities sit around 6-8%.

Fund A — expense ratio

Fund B — expense ratio

Benchmarks:

Scenarios:

Difference after 30 years

€171,988.93

Fund A ends ahead. The ER spread between the two — 0.80% per year — compounds to a real, life-changing gap on a multi-decade horizon.

Fund A

ER 0.05%

€1,003,819.17

Net return: 6.95%
Fees paid: €5,567
Opportunity cost: €11,991
Fee drag: 1.2%

Fund B

ER 0.85%

€831,830.24

Net return: 6.15%
Fees paid: €83,180
Opportunity cost: €183,980
Fee drag: 18.1%

Growth chart

Zero-fee Fund A Fund B

Fund A wins by €171,988.93. The spread between a 0.05% and 0.85% expense ratio over 30 years comes entirely from fees — both funds saw the same gross return assumption.

Net of fees: 6.95% · CAGR realised on contributions: 5.03%

Computed entirely in your browser. Nothing is uploaded or stored.

Runs in your browser: No upload, no signup. Your file never leaves your device.
Free and unmetered: Use it as often as you need. No daily quota, no credit card.
EU-built, GDPR-first: Hosted in Frankfurt. Built by a small EU team that takes privacy seriously.

Why the headline percentage is misleading

An expense ratio is the slice of your invested assets that the fund manager keeps every year, charged silently against the NAV. On a fund prospectus you'll see a number like 0.04% for a Vanguard S&P 500 ETF, 0.65% for a typical 401k target-date fund, or 1.5% for a legacy load-heavy mutual fund. Those numbers sound tiny — about the size of a rounding error on your monthly returns. But two things make them much larger than they appear.

First, expense ratios are charged on the whole balance, every year. As your balance grows, the dollar amount of the fees grows with it. Second, every dollar paid in fees is a dollar that doesn't stay in your account compounding for the next 30 years. The real cost of an expense ratio is not the fee itself, it's the fee plus all the compound growth that fee would have earned. On long horizons the lost growth is several times larger than the cash fees you actually paid.

The math, made explicit

Net return = gross return − expense ratio. That's the standard simplification used by Vanguard, Morningstar, and the SEC's published fee-impact tools. A fund with a 7% gross return and a 0.85% expense ratio compounds at 6.15% for the investor. Over short horizons that 0.85% gap is invisible. Over 30 years it adds up — and the helper above plots the gap year-by-year against the zero-fee path so you can see exactly where the divergence becomes meaningful.

The two numbers the helper surfaces are subtly different and both matter:

Cash fees paid — the book-value sum of the annual expense charges. This is the figure a fund company would, if it had to, write you a refund for.
Opportunity cost — the gap between your actual balance and a hypothetical zero-fee twin of the same fund. This is the real cost. On a 30-year horizon at typical equity returns the opportunity cost is roughly 3-5x the cash fees paid, because every fee dollar also gives up its own compound growth.

What a 1% expense ratio actually costs

The Vanguard founder John Bogle ran this calculation in the 1990s and the result remained one of his most-cited talking points: at 7% gross returns, a fund with a 1% expense ratio loses about 25% of the would-be final balance to fees over a 30-year horizon. Said differently: if a no-fee twin compounded €100,000 into €761,000, the 1% expense ratio twin only compounds into about €574,000 — a gap of nearly €187,000. You paid the fund manager not a 1% slice of returns but a quarter of your lifetime wealth.

That math is what the helper renders for you, with your actual numbers. The default scenario — index ETF vs active fund over 30 years — illustrates the classic comparison: a 0.05% ETF beats a 0.85% active fund by a margin that's usually somewhere between €120k and €300k depending on starting balance and contributions.

Real-world expense ratios to benchmark against

The helper has a row of one-click benchmarks for context. The ranges below are 2026 industry medians; your specific fund could sit anywhere within them.

Passive index ETFs (Vanguard, iShares Core, SPDR): 0.03-0.10% for US large-cap, 0.07-0.20% for global. The cheap end of the market.
UK / EU UCITS ETFs: 0.10-0.30% for broad-market index UCITS. Marginally more expensive than US ETFs because the UCITS regulatory framework adds cost; the gap has narrowed sharply since 2020.
401k / retirement plan default funds: 0.40-0.90% for target-date / lifecycle funds. The fund-of-funds wrapper adds a layer of cost on top of the underlying ETFs.
Actively-managed mutual funds (stockpicker): 0.60-1.20% is the industry median. Funds in this range have underperformed their index benchmark on 75-85% of 15-year windows in published academic studies — meaning most active investors pay an above-index fee for a below-index return.
Legacy load-heavy funds:1.30-1.75% plus an upfront load (a one-time fee of 3-5% on every contribution). Largely held by inheritance accounts and people who haven't moved off a broker recommendation from 1995.
Hedge funds:typically “2 and 20” — 2% expense ratio plus 20% of profits. Not modelled by this tool; the performance-fee layer adds a non-linear cost that needs its own calculator.

How to use the comparison mode

The default mode is side-by-side: fund A vs fund B. This is the decision most investors actually face. Should I roll a target-date 401k fund into a self-managed index portfolio? Is switching brokerages worth it? Is the actively-managed fund my advisor recommends worth the premium?

Enter your initial balance and any monthly contributions.
Set the time horizon — match this to your actual goal.
Enter the gross annual return you expect (use the underlying-index assumption, not the fund's reported return — both funds get the same gross figure).
Enter the two expense ratios you're comparing.
Read the headline answer — it's the dollar gap between the two funds at the end of your horizon. The CSV download gives you the year-by-year detail.

Inputs the tool deliberately doesn't take

Real-world fund-cost calculations have more variables than the five we surface. We left these out because they'd clutter the tool without changing the answer materially for most users:

Taxes on dividends / capital gains.These depend on your account type (tax-sheltered vs taxable), jurisdiction, and your marginal rate. If you're modelling a taxable account, multiply the gross return by (1 − marginal rate × dividend yield fraction) and enter the resulting after-tax number.
Front-end / back-end loads. A 5% upfront load compounds into roughly the same drag as ~0.5% expense ratio over 10 years — i.e., not nothing. If your fund has a load, add 0.3-0.5% to its expense ratio as a rough proxy.
Trading-cost drag (bid-ask spread, market impact). On a passive index fund this is invisible. On a high-turnover active fund it can be 0.2-0.5% per year beyond the headline ER. Conservative: add it to your active-fund ER input.
Variable returns.The tool uses a constant annual return; markets don't. The helper's job isn't to predict your end balance — it's to surface the fee-vs-no-fee gap, which compounds the same way whether returns are bumpy or smooth.

Reconciling against a real brokerage statement

If you're comparing the tool's projection against a real account, the helper's exact-fee numbers and your brokerage's reported balance will be close but not identical. The differences come from the items above — specifically rebalancing trades, securities-lending revenue offsets (some ETFs lend out underlying shares and credit a portion back), and the day-count convention the fund uses to charge the expense ratio.

To extract a year-by-year reality check, drop a PDF copy of your brokerage statement into our main bank statement converter— it extracts every dividend reinvestment, fee debit, and end-of-year balance as line items. You can then sum the fee debits and compare against the helper's cash-fees-paid number.

For a goal-based projection where the recurring deposit is the unknown, the savings goal calculator solves for it directly. For a pure CAGR / XIRR on a single position (no expense-ratio modelling, but irregular cash flows supported), use the investment return calculator.

Worked example: the 30-year fund switch decision

Suppose you're 35, have €100,000 in a workplace-default target-date fund charging 0.65%, and contribute €1,000/mo. You could roll the same allocation into a self-managed three-ETF portfolio at a 0.06% weighted expense ratio. Both portfolios are invested in the same global equity market, so use 7% as the gross-return assumption for both.

Set the helper to compare mode, label A “Target-date 401k (0.65%)”, label B “Self-managed 3-ETF (0.06%)”, time horizon 30 years. The result: the self-managed portfolio ends roughly €370,000 ahead. The gross-return assumption didn't change. The asset allocation didn't change. The only difference was 59 basis points of annual expense ratio — and that difference compounded into more than the entire starting balance you began with.

This is the calculation every investor should run at least once before they commit to a long-term fund. The answer changes people's behaviour more than any other single piece of financial math.

FAQ

What is an expense ratio?: It's the annual fee a mutual fund or ETF charges as a percentage of your invested assets. A 0.5% expense ratio means the fund keeps €5 of every €1,000 you have invested, every year. It's deducted silently against the fund's NAV — you don't see it as a line item on your statement.
How is the impact calculated?: Net return = gross return − expense ratio, compounded monthly. The helper runs two parallel projections — one at the gross rate (the zero-fee twin) and one at the net rate (your fund). The dollar gap between them at the end of your horizon is the total opportunity cost.
Why is the opportunity cost so much larger than the fees I actually paid?: Every euro paid in fees is also a euro that doesn't compound for the rest of your horizon. On a 30-year window at 7% gross returns, a euro of fees paid in year 1 would have grown to about €7.60 in your account by year 30. The book value of fees is what the fund charged you. The opportunity cost is what those fees plus their compound growth would have been.
What gross return should I assume?: For long-horizon retirement modelling, 6-8% is a defensible assumption for diversified global equities. Bond-heavy portfolios should use 3-5%. Cash / money-market funds run 4-5% in 2026. The point of the tool isn't to predict your return — it's to show the fee gap, which compounds the same way at any return level.
Does the tool model taxes?: No. To approximate, multiply your gross return by (1 − marginal-tax rate × dividend yield fraction) before entering it. For tax-sheltered accounts (US Roth IRA, UK ISA, IE PRSA), use the gross rate directly.
What about front-end loads or 12b-1 fees?: Those aren't modelled directly. A 5% front-end load on every contribution is equivalent to roughly an extra 0.5% expense ratio over 10 years, declining at longer horizons. The cleanest approximation is to bump the fund's expense ratio up by 0.3-0.5% in this tool to account for the load.
Is monthly compounding the right granularity?: Fund NAVs update daily, but the difference between monthly and daily compounding on a long horizon is in the 5th decimal place. We use monthly because it lines up cleanly with how most people contribute. The headline answer would shift by less than 0.1% if we switched to daily.
How does this differ from your other calculators?: The savings goal calculator solves for one of three variables (deposit, time, or final balance) assuming a single fixed rate — it doesn't model fees vs gross return as two separate inputs. The investment return calculator handles irregular cash flows and computes CAGR or XIRR on what already happened. This tool is the fee-decision tool: it isolates the cost of one specific cost component (the expense ratio) over a long horizon.
Is anything sent to your servers?: No. The math runs entirely in your browser. No figures, no fund names, no balances — nothing leaves the page. The CSV download is generated locally.