Self-service tool · No tax advisory/ case review · Results may vary – please verify
Interactive Brokers Advance Lump Sum (Vorabpauschale) for ETFs and Investment Funds
Last updated:
JulianAnyone holding ETFs or investment funds through Interactive Brokers will sooner or later encounter the advance lump sum (Vorabpauschale) in the German tax context. With a German broker, this is usually much simpler for the user: the advance lump sum is typically already determined by the broker, and the user essentially only needs to transfer the values into the tax documents or tax form. With Interactive Brokers, this is different. Here, the challenge lies primarily in bringing together all data relevant for the calculation of the advance lump sum completely and consistently. This includes in particular year-start and year-end values, received distributions, acquisition date, and position data at the FIFO lot level. The legal basis is formed in particular by § 18, § 19, and § 20 InvStG.
Note: KapitalTax supports the structured preparation of Interactive Brokers data for the German tax context. The content on this page and the analyses provided by KapitalTax are intended solely for general informational and data-preparation purposes and do not constitute individual tax or legal advice. Whether and how specific values should be taken into account in a personal tax return depends on the individual case.
For Interactive Brokers users, the advance lump sum is therefore one of the most important Germany-specific topics for fund and ETF holdings. Frequently searched terms include IBKR Vorabpauschale, Interactive Brokers advance lump sum, ETF tax Interactive Brokers, or advance lump sum ETF Germany.
For a complete overview of all tax-relevant topics at Interactive Brokers, you can read the IBKR tax return page. If you would like to see what a structured analysis looks like first, you can view the example report.
Why the Advance Lump Sum Is Particularly Relevant at Interactive Brokers
With German brokers, fund tax topics are largely pre-processed for the user. This significantly reduces the effort. With Interactive Brokers, on the other hand, primarily trading and account data are available. For the advance lump sum, this alone is not sufficient as long as the input variables required for the calculation are not completely available.
In practice, the following data is particularly relevant:
The actual difficulty with IBKR is therefore often not the mere determination that a holding is an ETF or fund, but the reliable consolidation of exactly these data points for each relevant fund lot.
What the Advance Lump Sum Means
The advance lump sum (Vorabpauschale) is a special tax rule for investment funds and ETFs in German tax law. It applies to both accumulating and distributing funds and is intended to ensure that fund holdings do not only become tax-relevant when actual distributions are made or units are sold. § 18 InvStG regulates that the advance lump sum is derived from the base return, reduced by distributions, and capped at the value increase plus distributions. In the acquisition year, a pro-rata reduction applies, and the deemed inflow date is generally the first business day of the following calendar year.
In practice, this means: the advance lump sum depends not only on whether an ETF is in the portfolio, but also on several statutory factors that are not always immediately apparent from the raw data alone.
How the Advance Lump Sum Is Calculated
The following variables are particularly relevant for the calculation:
P_start = first redemption price or exchange/market price of the calendar year
P_end = last redemption price or exchange/market price of the calendar year
n = number of units held
B = base interest rate (Basiszins)
A = distributions during the calendar year
m = considered holding period months in the acquisition year
1. Base Return (Basisertrag)
Base_return = P_start × 70% × B × n
This is the statutory starting point of the calculation.
2. Cap Limit (Kappungsgrenze)
The base return may not exceed the value increase of the fund unit in the calendar year plus distributions. In simplified terms:
Cap = max(0, (P_end − P_start) × n + A)
This prevents a higher amount from being applied than is legally permissible.
3. Capped Base Return
Base_return_capped = min(Base_return, Cap)
4. Pro-Rata Reduction in the Acquisition Year
If the fund unit was not held for the entire calendar year, the base return must be reduced on a pro-rata basis. § 18 InvStG provides for a monthly pro-rata reduction. In simplified terms:
Base_return_capped_prorated = Base_return_capped × (m / 12)
If a fund unit was acquired during the course of the year, not the entire year counts but only the relevant remaining period. This pro-rata reduction in the acquisition year is precisely one of the points where complete transaction and position data becomes particularly important at Interactive Brokers.
5. Advance Lump Sum (Vorabpauschale)
The advance lump sum is the amount by which the distributions fall short of the relevant base return. In simplified terms:
Advance_lump_sum = max(0, Base_return_capped_prorated − A)
This corresponds to the statutory logic of § 18 InvStG.
Why Calculation per FIFO Lot Is Relevant
For practical analysis, it is not sufficient to consider an ETF holding only at the overall position level. What matters is that the advance lump sum can be traced on a lot-by-lot basis when a holding consists of multiple acquisitions. The reason is simple: different acquisition dates lead to different holding periods in the acquisition year, and it is precisely this holding period that affects the pro-rata reduction. Therefore, in practice, the advance lump sum must be considered per FIFO lot so that acquisition date, remaining holding period, and subsequent sale are properly aligned.
This is particularly relevant at Interactive Brokers because active users often do not build ETF positions in a single purchase but over multiple points in time. Without lot logic, the advance lump sum quickly becomes imprecise.
Which Data KapitalTax Uses for the Advance Lump Sum
For the calculation of the advance lump sum, not only fund transactions are important, but above all the correct market data and income data. KapitalTax obtains market data directly from Interactive Brokers. This allows in particular the year-start and year-end values required for the calculation to be incorporated based on the market data available at IBKR. Additionally, received distributions from the portfolio data are taken into account.
This is precisely where the actual effort lies at Interactive Brokers: not the broad question of whether a holding is a fund, but whether for each affected fund lot the relevant annual values, distributions, and holding periods are completely available. Only then can the advance lump sum be reliably calculated.
Why Year-Start and Year-End Values Are So Important
The statutory logic of the advance lump sum is directly tied to the first and last redemption price or exchange/market price of the calendar year. Without these values, neither the base return at the starting point nor the cap can be properly derived. § 18 InvStG explicitly names these price variables as part of the calculation.
For a clean IBKR analysis, this means:
- Year-start values are required.
- Year-end values are required.
- Distributions must be completely available.
- In the acquisition year, the intra-year holding period must be taken into account.
- The calculation must remain traceable at the FIFO lot level.
This is precisely why the advance lump sum at Interactive Brokers often requires significantly more effort than with a German broker that already handles this preliminary work.
Partial Exemption: Why the Fund Type Still Matters
Even though at Interactive Brokers the actual difficulty usually lies in the input data for the calculation, the fund type remains important for the subsequent tax treatment. The partial exemption is governed by § 20 InvStG and depends on whether a holding is classified as an equity fund, mixed fund, real estate fund, foreign real estate fund, or other fund. For private investors, the partial exemption rates are 30% for equity funds, 15% for mixed funds, 60% for real estate funds, and 80% for foreign real estate funds; for other funds, no corresponding partial exemption applies.
KapitalTax distinguishes between different fund types in the analysis and performs a pre-categorization. The user can subsequently adjust this. For the advance lump sum, the fund type is therefore important – but typically not the most difficult part of the problem. The more complex part is usually the complete and lot-accurate provision of the calculation variables.
No Advance Lump Sum for ETCs
Also important is the distinction from ETCs. ETCs are typically not investment funds but rather debt securities linked to commodity performance. As such, they regularly do not fall under the advance lump sum framework of the Investment Tax Act. BaFin describes ETCs as debt securities with reference to commodity prices, not as investment funds.
In practice, this means: not every exchange-traded product with ETF-like usage behavior is actually an investment fund within the meaning of the InvStG. This distinction is particularly important for the tax treatment.
What Is Important Upon Subsequent Sale
Previously applied advance lump sums do not disappear without consequence. § 19 InvStG provides that previously applied advance lump sums reduce the capital gain upon subsequent sale. The law also clarifies that this reduction must be taken into account in full regardless of any partial exemption.
In practice, this means: the advance lump sum is not an isolated annual topic but also affects the subsequent treatment of a fund sale. This is precisely why clean documentation of the annually applied values is important.
Example: Tax Return 2025 and ETF Sale in August 2025
Can an advance lump sum appear in the tax return for 2025 for an ETF that you sold in August 2025?
Yes – but not for the calendar year 2025 due to the sale in August 2025.
For the current calendar year of the sale, practically: sale in 08/2025 = no advance lump sum for 2025 for this sold holding. Because an advance lump sum for 2025 would only come into consideration for units that are still in the portfolio at the end of 2025.
Why can an advance lump sum still appear in the 2025 tax return?
Because the advance lump sum is deemed to have been received for tax purposes on the first business day of the following year. Specifically, this means:
- The advance lump sum for 2024 is deemed received on January 2, 2025. Accordingly, the advance lump sums for 2024 are to be recorded in the 2025 tax return.
- If you still held the ETF on December 31, 2024, this advance lump sum for 2024 is included in your 2025 tax return.
- The fact that you later sold the ETF in August 2025 does not change this.
Exactly such cases illustrate why the advance lump sum does not depend solely on the sale date, but on the interplay of the holding at year-end, the statutory deemed inflow date, and the subsequent sale. The statutory deemed inflow on the first business day of the following year follows directly from § 18 InvStG.
How KapitalTax Prepares the Advance Lump Sum at IBKR
KapitalTax supports the structured preparation of the advance lump sum for fund and ETF holdings through Interactive Brokers. The focus is on the data that is actually needed for the calculation. This includes in particular:
This is especially helpful for IBKR users because the greatest difficulty often lies not in general ETF recognition but in bringing together the right values at the right time, completely and traceably.
Frequently Asked Questions About the Advance Lump Sum at Interactive Brokers
Summary
The advance lump sum at Interactive Brokers is primarily complex because the relevant input variables for the calculation are not already prepared by the broker in a German tax logic. Unlike with German brokers, with IBKR it must first be ensured that year-start values, year-end values, distributions, acquisition dates, and FIFO lots are completely and consistently available. Only on this basis can the advance lump sum be reliably calculated under § 18 InvStG.
Particularly important are:
Find out which topics beyond the advance lump sum are also relevant for many Interactive Brokers users on the tax return page.
Published on:
End the Tax Excel Marathon
Upload your IB Flex XML – and get the tables you actually need in minutes.
Create Free ReportNo broker credentials • Just Flex XML • Free • GDPR compliant