tax-reporting 0.2.1

Bulgarian tax reporting analyzers for investment activity

Tax Reporting (Bulgaria / НАП)

Python-based CLI for generating Bulgarian annual tax reporting outputs from real-world investment data (IBKR, crypto exchanges, P2P platforms).

The goal of this project is simple:

Process complex investment activity and generate declaration-ready results in minutes instead of days of manual work.

This repository provides a transparent, extensible engine that handles real-world edge cases across multiple platforms.

It is especially useful if:

• you invest across multiple brokers and platforms
• you want to avoid manual Excel workflows
• you need full visibility into how results are calculated

The project is evolving based on real usage and feedback, with the aim to cover the majority of practical investment scenarios over time.

Who is this for

• Individual investors managing their own tax reporting
• Users with activity across multiple platforms (IBKR, crypto, P2P, etc.)
• Accounting professionals exploring automation or evaluating tooling for client workflows
• Developers or advanced users who want full control and transparency

The repository now includes:

• FX services (bnb_fx, crypto_fx)
• Binance analyzers
• Coinbase report analyzer (spot transactions mapped to shared crypto IR engine)
• Kraken report analyzer (spot ledger mapped to shared crypto IR engine)
• Finexify fund analyzer (fund events mapped to shared fund IR engine)
• P2P analyzers:
• Afranga (payer-level Appendix 6 extraction + withheld-tax carry-through)
• Estateguru (aggregate Appendix 6 mapping)
• Lendermarket (aggregate Appendix 6 mapping)
• Iuvo (aggregate Appendix 6 mapping)
• Robocash (aggregate Appendix 6 mapping)
• Bondora Go & Grow (aggregate Appendix 6 mapping)
• IBKR activity statement analyzer (trades + interest + dividends + CFD/PIL adjustments)

Some areas are still intentionally phased and evolving (for example broader asset coverage and additional appendices).

Commercial Usage

This project is free for personal use.

Companies (e.g. accounting firms) may evaluate the tool internally.

Using this tool to provide paid services (e.g. tax reporting for clients) requires a commercial license.

See COMMERCIAL_USAGE.md for full details.

Contact

For commercial usage or collaboration:

• Email: [e-mail]
• LinkedIn: https://www.linkedin.com/in/todorppetrov/

Please include a short description of your use case.

Installation & Usage

Install uv once:

macOS:

brew install uv

Windows (PowerShell):

irm https://astral.sh/uv/install.ps1 | iex

Linux:

curl -LsSf https://astral.sh/uv/install.sh | sh

Option 1 - Try instantly (no install)

uvx tax-reporting --help

uvx runs a published Python CLI in an ephemeral, cached environment without installing it globally.

Example single analyzer run:

uvx tax-reporting ibkr \
  --input path/to/ibkr_activity_statement.csv \
  --tax-year 2025 \
  --tax-exempt-mode listed_symbol

Example aggregate run:

uvx tax-reporting \
  --input-dir path/to/reports \
  --tax-year 2025 \
  --output-dir output

Option 2 - Install globally

uv tool install tax-reporting
tax-reporting --help

uv tool install installs a persistent command-line tool in uv's managed tool environment.

After installing, run:

tax-reporting coinbase \
  --input "path/to/Coinbase Report.csv" \
  --tax-year 2025

Command Choice

• uvx tax-reporting -> run without installing
• uv tool install tax-reporting -> install once
• tax-reporting ... -> run the installed CLI

Important: uvx tax-reporting and uv tool install tax-reporting work after the package is published to PyPI or another configured package index. Before publishing, use the development workflow below or install from Git.

Prebuilt Binaries

GitHub Releases may include standalone binaries:

• Windows x64: download tax-reporting-windows-x64.zip, unzip it, then run tax-reporting.exe.
• macOS Apple Silicon: download tax-reporting-macos-arm64.tar.gz, extract with tar -xzf, then run ./tax-reporting.
• macOS Intel: download tax-reporting-macos-x64.tar.gz, extract with tar -xzf, then run ./tax-reporting.

macOS may warn because the binaries are unsigned. Technical users can also use uvx tax-reporting after the package is published to PyPI.

macOS unsigned binary warning

The macOS binaries are not currently Apple-notarized or signed with a Developer ID certificate.

Because of this, macOS Gatekeeper may show a warning such as:

“tax-reporting” cannot be opened because Apple cannot check it for malicious software.

If you trust the downloaded binary, you can allow it from:

System Settings → Privacy & Security → Open Anyway

Alternatively, you can run it from Terminal after removing the quarantine attribute:

xattr -d com.apple.quarantine ./tax-reporting-macos-arm64
chmod +x ./tax-reporting-macos-arm64
./tax-reporting-macos-arm64 --help

Example: IBKR + Kraken (real-world workflow)

These are sanitized real-world-style reports intended for demonstration purposes.

examples/inputs/
  ibkr_activity_statement_sample_sanitized.csv
  kraken_report_since_inception_sample_sanitized.csv
  spb8-input-file.csv

uv run tax-reporting \
  --input-dir examples/inputs \
  --tax-year 2025 \
  --spb8-input-file examples/inputs/spb8-input-file.csv \
  --clean-output \
  --display-currency BGN \
  --output-dir output/examples

uv run tax-reporting ibkr \
  --input examples/inputs/ibkr_activity_statement_sample_sanitized.csv \
  --tax-year 2025 \
  --display-currency BGN \
  --output-dir output/examples/ibkr

uv run tax-reporting kraken \
  --input examples/inputs/kraken_report_since_inception_sample_sanitized.csv \
  --tax-year 2025 \
  --display-currency BGN \
  --output-dir output/examples/kraken

Per-analyzer outputs: output/examples/ibkr/, output/examples/kraken/. Aggregated output: output/examples/aggregated_tax_report_2025.txt. This mirrors real-world multi-provider workflows.

СПБ-8 (BNB Declaration)

СПБ-8 is a Bulgarian National Bank declaration for certain foreign assets and liabilities. This tool helps prepare the data for the declaration, but it does not submit anything to BNB.

Currently, IBKR SPB-8 data is derived automatically from the IBKR Activity Statement where safe. The SPB-8 CSV is a manual completion and override file for missing or uncertain values.

Quick start:

1. Run the tool normally, without an SPB-8 input file:

uv run tax-reporting \
  --input-dir examples/inputs \
  --tax-year 2025 \
  --output-dir output/examples

2. The tool writes output/examples/spb8-input-file.csv.
3. Fill any missing start amount and end amount values, or override generated values if needed.
4. Run again:

uv run tax-reporting \
  --input-dir examples/inputs \
  --tax-year 2025 \
  --spb8-input-file output/examples/spb8-input-file.csv \
  --output-dir output/examples

5. Use the generated СПБ-8 section in the TXT output to fill the official BNB form.

CLI options:

• --spb8-input-file PATH reads a completed SPB-8 CSV. Filled values override analyzer-derived values; empty values fall back to analyzer-derived values when available. In aggregate mode this option is optional when exactly one .csv file with spb8 in its filename exists in --input-dir. If --include-pattern is used, automatic SPB-8 detection only considers files matching that pattern. If multiple matching files are present, pass --spb8-input-file explicitly. The diagnostics report lists the selected SPB-8 input file under Detected inputs as spb8-input.
• --no-spb8 disables SPB-8 generation.
• --spb8-exclude-crypto excludes crypto platforms from SPB-8.

Input CSV header:

account name,platform,type,country,ISIN,currency,start amount,end amount

Columns:

• account name: account/report label.
• platform: supported platform alias, for example kraken, coinbase, lendermarket.
• type: 01, 02, 03, 04, or the full Bulgarian type label.
• country: Bulgarian or English country name; inferred from platform if empty.
• ISIN: - for types 01/02/03; real ISIN for type 04.
• currency: 3-letter currency code for types 01/02/03; - for type 04.
• start amount, end amount: NAV/balance for types 01/02/03; quantity/size for type 04.

The generated template includes detected manual platforms and analyzer-derived SPB-8 rows. For IBKR securities, it includes one type 04 row per ISIN. If Corporate Actions are detected, IBKR type 04 start amounts may be left empty for manual completion.

Automatically inferred/calculated where possible:

• platform, type, country
• IBKR cash from Cash Report (Starting Cash / Ending Cash) by original currency
• IBKR securities with ISIN from Open Positions, Trades, Transfers, and instrument metadata

Usually filled manually:

• P2P beginning/end NAV
• crypto beginning/end NAV; crypto SPB-8 data is not automatically generated yet
• fund beginning/end NAV; fund SPB-8 data is not automatically generated yet
• any row left blank in the template
• IBKR type 04 start quantities when Corporate Actions make reconstruction unsafe

Limitations and warnings:

• securities without ISIN are excluded and reported for review
• crypto platforms are treated in this report as type 03 foreign accounts with EUR currency by default; confirm this interpretation with your accountant
• Bulgaria platforms are not included in filing rows
• IBKR Transfers are used for SPB-8 beginning quantity reconstruction only; unsupported transfer rows produce warnings
• corporate actions such as stock splits, reverse splits, spin-offs, acquisitions, and mergers are not handled yet
• if Corporate Actions are present, review the IBKR section manually because it may affect SPB-8 and taxes
• unknown IBKR Activity Statement sections produce one consolidated warning for manual review

IBKR SPB-8 principle:

• IBKR securities are derived automatically from holdings/open positions.
• IBKR beginning security quantities use Trades and supported Transfers (Stocks, Treasury Bills) for instruments still present in Open Positions.
• When Corporate Actions are present, type 04 start quantities are left empty unless supplied through --spb8-input-file.
• Transfers do not affect tax PnL or Appendix 5; tax logic continues to use IBKR Closed Lots.
• IBKR cash is derived automatically from Cash Report, not Net Asset Value.
• Cash Report uses Starting Cash as beginning balance, Ending Cash as ending balance, Currency as the original currency, and Total as the amount.
• Base Currency Summary is ignored.
• Multiple cash currencies produce multiple SPB-8 cash lines.
• Use the SPB-8 input CSV to override or complete IBKR type 04 quantities when needed.

Example output:

СПБ-8
- Тип на вземането: 03. Сметки, открити в чужбина
  Матуритет:
  Държава: Ирландия
  Валута: EUR
  Размер в началото на отчетната година (в хиляди валутни единици): 10.36
  Размер в края на отчетната година (в хиляди валутни единици): 3.91

For type 01/02/03, values are shown in thousands of currency units. For type 04, securities are shown as quantities by ISIN.

Development

Setup:

git clone <repository-url>
cd <repository-directory>
uv sync

Run:

uv run tax-reporting --help

Development workflow:

uv run tax-reporting ibkr \
  --input path/to/ibkr_activity_statement.csv \
  --tax-year 2025 \
  --tax-exempt-mode listed_symbol

uv run pytest
uv run ruff check .

uv add <package>
uv sync

What the uv commands mean:

• uv run = execute a command inside the project environment
• uv add = add a dependency to pyproject.toml
• uv sync = create/update the environment from pyproject.toml and uv.lock

No need for:

• pyenv
• virtualenv
• pip install
• PYTHONPATH hacks

Publishing / Release Process

Maintainers publish the package so users can run:

uvx tax-reporting
uv tool install tax-reporting

Required pyproject.toml metadata:

[project]
name = "tax-reporting"
version = "..."

[project.scripts]
tax-reporting = "report_analyzer.cli:main"

Build:

uv build

Publish:

uv publish

Recommended secure publishing:

• Use PyPI Trusted Publishing via GitHub Actions.
• Avoid long-lived PyPI API tokens.

After publishing:

uvx tax-reporting --help
uv tool install tax-reporting
tax-reporting --help

Important: these commands only work once the package is available on PyPI or another configured index.

Git install before publishing:

uvx git+ssh://[e-mail]/<owner>/<repo>.git
uv tool install git+ssh://[e-mail]/<owner>/<repo>.git

Release Notes

GitHub Release notes are the canonical release notes for released binaries. Public release notes are stored under docs/public-releases/v<version>.md.

Release tags use v<version>, normally based on project.version in pyproject.toml.

When creating a GitHub Release in the public repository, the Build Binaries workflow requires the matching committed Markdown file:

docs/public-releases/<tag>.md

Maintainers can ask Codex to generate release notes with:

$tax-release-notes public

PyPI/TestPyPI publishing does not upload separate per-release notes from this workflow. PyPI users should be directed to GitHub Releases or the changelog via the README and project URLs.

Unified CLI Reference

Single analyzer mode:

uv run tax-reporting <alias> \
  --input <file> \
  --tax-year 2025 \
  --output-dir output/<alias>

Aggregate mode (auto-detect + run all + aggregate declaration summary):

uv run tax-reporting \
  --input-dir <folder> \
  --tax-year 2025 \
  --output-dir output

Display currency examples:

uv run tax-reporting coinbase \
  --input "path/to/Coinbase Report.csv" \
  --tax-year 2025 \
  --display-currency EUR

uv run tax-reporting \
  --input-dir path/to/reports \
  --tax-year 2025 \
  --output-dir output \
  --display-currency BGN

Auto-detection notes:

• file stem is tokenized by non-alphanumeric separators and lower-cased
• analyzer detection rules are token-set based (case-insensitive)
• example: Binance_REPORT...PNL.csv matches Binance futures detection tokens
• if multiple files match the same analyzer alias, all are processed and accumulated in aggregate mode

Aggregate filename conventions (so files auto-detect without --analyzer-input):

• ibkr (.csv): filename contains ibkr, or both interactive and brokers
• binance_futures (.csv): filename contains:
  • binance + report + pnl, or
  • binance + futures
• coinbase (.csv): filename contains coinbase
• kraken (.csv): filename contains kraken
• finexify (.csv): filename contains finexify
• afranga (.pdf): filename contains afranga
• estateguru (.pdf): filename contains estateguru
• lendermarket (.pdf): filename contains lendermarket
• iuvo (.pdf): filename contains iuvo
• robocash (.pdf): filename contains robocash
• bondora_go_grow (.pdf): filename contains:
  • bondora, or
  • go + grow, or
  • go + and + grow

Practical naming examples:

• IBKR Activity Statement 2025.csv
• Binance Report PnL.csv
• Coinbase Report - since inception.csv
• Kraken Report - since inception.csv
• Finexify report 2025.csv
• Afranga report.pdf
• Estateguru report.pdf
• Lendermarket-v2-Report 2025.pdf
• Iuvo report.pdf
• Robocash report.pdf
• Go & Grow report.pdf

Important detection constraints:

• extension must match analyzer expectations (.csv or .pdf above)
• multiple files per analyzer are supported and are processed cumulatively in aggregate mode
• if naming is non-standard, use --analyzer-input alias=path overrides

Aggregate mode global options:

• --input-dir
• --include-pattern (optional glob)
• --analyzer-input alias=path (repeatable override, including repeated same alias for multiple files)
• --opening-state-json VALUE (repeatable generic opening-state mapping for stateful analyzers)
• --tax-year
• --output-dir
• --cache-dir (shared FX cache override for all analyzers that use FX services)
• --display-currency {EUR,BGN} (TXT rendering only; calculations stay in EUR; BGN uses BNB FX at YYYY-12-31)
• --log-level
• --clean-output

--include-pattern uses standard glob matching (via fnmatch):

• *.csv -> only CSV files
• *report*.pdf -> PDFs containing report
• to match literal [ and ] in filenames, escape them in glob form:
  • *[[]tax-analyzer[]]*
  • example:
    • --include-pattern "*[[]tax-analyzer[]]*"

Group/analyzer override options:

• --p2p-secondary-market-mode
• --afranga-secondary-market-mode
• --estateguru-secondary-market-mode
• --lendermarket-secondary-market-mode
• --iuvo-secondary-market-mode
• --robocash-secondary-market-mode
• --bondora-go-grow-secondary-market-mode
• --ibkr-tax-exempt-mode
• --ibkr-eu-regulated-exchange (repeatable and supports comma-separated values)
• --ibkr-closed-world
• --ibkr-report-alias

--ibkr-tax-exempt-mode defaults to listed_symbol in aggregate mode.

Opening-state input rule:

• opening state is generic and applies to any analyzer that supports it
• no opening state means the input is treated as since-inception/full-history
• single-analyzer mode uses --opening-state-json state.json
• aggregate mode accepts one simple --opening-state-json state.json only when exactly one detected input supports opening state
• aggregate mode with multiple stateful inputs uses repeated mappings, for example:
  • --opening-state-json kraken-main.csv=states/kraken-main.state.json
  • --opening-state-json coinbase:coinbase-main.csv=states/coinbase-main.state.json
• the mapping left side may be a detected input basename, relative path, absolute path, or alias:selector
• aggregate mode also auto-detects sibling sidecars named <input-stem>.state.json
• CLI mappings override auto-detected sidecars
• .state.json files are not analyzed as input reports
• aggregate mode does not chain state from one input file into another; each input is analyzed independently

Display currency rule (all analyzers, single + aggregate):

• default is EUR
• --display-currency BGN converts declaration-facing TXT monetary values from EUR to BGN
• conversion is rendering-only (no calculation/aggregation changes)
• conversion uses services.bnb_fx on 31 Dec of the selected tax year
• technical metadata for this conversion is shown in the sibling diagnostics TXT file

TXT output boundary:

• main TXT reports are Bulgarian and taxpayer/accountant-facing
• main TXT reports use a two-level structure: compact settings/modes/checks near the top, clean declaration values in the middle, and detailed methodology notes at the bottom
• main TXT reports contain declaration sections, deduplicated actionable errors/warnings/manual-review items near the top, analyzer assumptions, and what to do next
• diagnostics TXT reports contain sorted technical/audit/debug details, raw parser messages, normal filesystem paths, and tracebacks when useful
• stdout is intentionally short: status, main report path, diagnostics path, and summary counts
• expected analyzer issues use structured diagnostic codes; free-form warnings are only a defensive fallback and should not appear in normal reports for known conditions
• analyzer settings or interpretation notes that affect tax treatment or auditability are emitted as structured main-report notes so both individual and aggregate reports show them; compact audit/config/check notes belong near the top, while detailed methodology notes belong in the bottom methodology section
• analyzer-specific warning/manual-review sections are normalized into the shared report structure instead of being rendered as duplicate body sections

Aggregate output:

• per-analyzer subfolders under <output-dir>/<alias>/...
• aggregated_tax_report_<tax_year>.txt at <output-dir>/
• aggregated_tax_report_<tax_year>.diagnostics.txt at <output-dir>/
• aggregate TXT starts with a Bulgarian top status banner
• individual analyzer outputs also have sibling *.diagnostics.txt files

BNB FX (services.bnb_fx)

What you can do:

• Use BNB XML export only (CSV is no longer supported).
• Get a historical FX quote by symbol and date.
• Get a direct conversion rate from one supported currency to another.
• Convert an amount from one supported currency to another.
• Auto-fetch and cache the whole quarter on cache miss.
• Preload cache for any date period.
• Preload cache for full years.
• Use either default cache location (~/.cache/tax_reporting/bnb_fx) or a custom directory.
• Always receive quotes as EUR for 1 symbol unit.
• If a requested date has no published rate, automatically use the closest previous available date.

Rate semantics:

• rate returned by get_exchange_rate() is always for 1 unit of the requested symbol.
• Example for USD: rate=0.85 means 1 USD = 0.85 EUR.
• For EUR, returned rate is always 1.
• get_conversion_rate(source, target, date) returns the multiplier from source to target.
• convert_amount(amount, source, target, date) returns amount * get_conversion_rate(...).

From Python code

Get one rate (auto-fetch quarter if needed):

from services.bnb_fx import get_exchange_rate

rate = get_exchange_rate("USD", "2024-10-15")
print(rate.symbol, rate.date, rate.rate, rate.base_currency)
# rate is always "EUR for 1 symbol unit"

Get a direct conversion rate:

from services.bnb_fx import get_conversion_rate

usd_to_chf = get_conversion_rate("USD", "CHF", "2024-10-15")
print(usd_to_chf)
# multiplier for USD -> CHF on the requested date

Convert an amount:

from decimal import Decimal

from services.bnb_fx import convert_amount

amount_chf = convert_amount(Decimal("100"), "USD", "CHF", "2024-10-15")
print(amount_chf)

Build cache for an arbitrary period:

from services.bnb_fx import build_cache

result = build_cache(["USD", "EUR"], "2024-01-01", "2024-12-31")
print(result.fetched_count, result.skipped_count, result.failed_count)

Build cache for full years:

from services.bnb_fx import build_cache_for_symbols_and_years

result = build_cache_for_symbols_and_years(["USD"], [2023, 2024, 2025])
print(result.fetched_count, result.rows_written)

Use a custom cache directory:

uv run python - <<'PY'
from decimal import Decimal

from services.bnb_fx import convert_amount, get_exchange_rate

rate = get_exchange_rate("USD", "2024-10-15", cache_dir="output/fx-cache")
print(rate.rate, rate.base_currency)

amount_bgn = convert_amount(Decimal("100"), "EUR", "BGN", "2024-10-15", cache_dir="output/fx-cache")
print(amount_bgn)
PY

Query multiple dates with automatic fallback to previous available day:

from services.bnb_fx import get_exchange_rate

for d in ["2025-10-11", "2025-10-12"]:
    fx = get_exchange_rate("USD", d)
    print(d, "->", fx.date.isoformat(), fx.rate)  # requested -> effective

From CLI

Build cache for period:

uv run python -m services.bnb_fx.cli period \
  --symbols USD,EUR \
  --start-date 2024-01-01 \
  --end-date 2024-12-31

Build cache for full years:

uv run python -m services.bnb_fx.cli years \
  --symbols USD \
  --years 2023,2024,2025

Build cache into a custom folder:

uv run python -m services.bnb_fx.cli period \
  --symbols USD \
  --start-date 2024-01-01 \
  --end-date 2024-03-31 \
  --cache-dir output/fx-cache

Get one rate:

uv run python -m services.bnb_fx.cli get-rate \
  --symbol USD \
  --date 2024-10-15

Get multiple dates:

uv run python -m services.bnb_fx.cli get-rate \
  --symbol USD \
  --dates 2025-10-11,2025-10-12

get-rate output columns:

• requested_date
• effective_date (may be earlier if no rate on requested date)
• symbol
• eur_for_1_symbol

Current Structure

• src/report_analyzer/: unified analyzer CLI package (single and aggregate modes)
• src/main.py: backwards-compatible wrapper delegating to unified CLI
• src/config.py: central project paths
• src/logging_config.py: minimal logging setup
• src/integrations/: integration packages (crypto, fund, p2p, ibkr)
• src/integrations/crypto/shared/: shared crypto IR models, generic analyzer, shared outputs/runtime helpers
• src/integrations/crypto/coinbase/: Coinbase parser, mapper, and orchestrator
• src/integrations/crypto/kraken/: Kraken parser, mapper, and orchestrator
• src/integrations/crypto/binance/: Binance crypto analyzers
• src/integrations/fund/shared/: shared fund IR models, generic analyzer, and outputs/state helpers
• src/integrations/fund/finexify/: Finexify parser, mapper, and orchestrator
• src/integrations/p2p/shared/: shared P2P Appendix 6 result model and renderer
• src/integrations/p2p/afranga/: Afranga PDF parser and orchestrator
• src/integrations/p2p/estateguru/: Estateguru PDF parser and orchestrator
• src/integrations/p2p/lendermarket/: Lendermarket PDF parser and orchestrator
• src/integrations/p2p/iuvo/: Iuvo PDF parser and orchestrator
• src/integrations/p2p/robocash/: Robocash PDF parser and orchestrator
• src/integrations/p2p/bondora_go_grow/: Bondora Go & Grow PDF parser and orchestrator
• src/integrations/shared/: analyzer registration contracts, autodetect, and aggregate reporting
• src/integrations/ibkr/activity_statement_analyzer.py: IBKR analyzer facade/orchestrator
• src/integrations/ibkr/sections/: IBKR business/source processing modules (trades, interest, dividends, tax_withholding, open_positions, instruments, etc.)
• src/integrations/ibkr/appendices/: IBKR declaration shaping/output modules
• src/integrations/ibkr/constants.py: IBKR domain constants and country maps
• src/integrations/ibkr/models.py: IBKR typed models/errors/result structures
• src/integrations/ibkr/shared.py: shared IBKR parsing/matching/conversion helpers
• src/services/bnb_fx/: BNB XML client + quarter cache + CLI
• src/services/crypto_fx/: crypto-to-EUR layer (pair resolution + Binance hourly pricing + CLI)
• src/services/pdf_reader.py: shared machine-generated PDF text extraction utility
• src/integrations/shared/rendering/: canonical declaration-facing appendix renderers (Приложение 5/6/8/9/13) reused by both individual analyzers and aggregated output
• tests/test_imports.py: import smoke tests
• tests/services/bnb_fx/: BNB FX tests
• tests/services/crypto_fx/: crypto FX tests
• tests/integrations/crypto/binance/: Binance analyzer tests
• tests/integrations/crypto/: shared crypto IR/analyzer tests
• tests/integrations/crypto/coinbase/: Coinbase analyzer tests
• tests/integrations/crypto/kraken/: Kraken analyzer tests
• tests/integrations/fund/: shared and Finexify fund analyzer tests
• tests/integrations/p2p/: shared + platform-specific P2P analyzer tests
• tests/integrations/ibkr/: IBKR tests (organized by sections/ and appendices/)
• tests/integrations/shared/: unified CLI/shared registry and discovery tests
• output/: output directory kept in git via .gitkeep Default analyzer outputs are written under this repo folder (for example output/binance/futures/).

Code Structure And Conventions

• Keep analyzer behavior stable first: refactors must preserve outputs, labels, calculations, and review semantics.
• Simpler analyzers may stay single-file; more complex analyzers can be split when it clearly improves readability and safety.
• For IBKR, keep the analyzer facade/orchestrator thin and explicit, and move cohesive parsing/calculation/output logic into IBKR-local modules.
• Put new source/business logic in the most relevant existing module (do not append to a giant function/file).
• Keep appendix builders focused on declaration shaping and final presentation; keep source parsing/matching logic in source-oriented modules.
• Reuse existing helpers when there is real duplication; avoid speculative abstractions or framework-like pipelines.
• Cross-analyzer consistency should come from a stable result/output contract, not from forcing identical internal folder layouts.

Integration Docs

• Binance integrations: src/integrations/crypto/binance/README.md
• Coinbase integrations: src/integrations/crypto/coinbase/README.md
• Kraken integrations: src/integrations/crypto/kraken/README.md
• Shared crypto engine: src/integrations/crypto/shared/README.md
• Fund integrations: src/integrations/fund/README.md
• Shared fund engine: src/integrations/fund/shared/README.md
• Finexify fund analyzer: src/integrations/fund/finexify/README.md
• P2P integrations: src/integrations/p2p/README.md
• Shared P2P engine: src/integrations/p2p/shared/README.md
• Afranga P2P analyzer: src/integrations/p2p/afranga/README.md
• Estateguru P2P analyzer: src/integrations/p2p/estateguru/README.md
• Lendermarket P2P analyzer: src/integrations/p2p/lendermarket/README.md
• Iuvo P2P analyzer: src/integrations/p2p/iuvo/README.md
• Robocash P2P analyzer: src/integrations/p2p/robocash/README.md
• Bondora Go & Grow P2P analyzer: src/integrations/p2p/bondora_go_grow/README.md
• IBKR integrations: src/integrations/ibkr/README.md

Binance futures PnL cashflow analyzer

Pure realized-cashflow analyzer (no FIFO/carryover), based on Binance Futures PnL / Transaction History CSV:

uv run tax-reporting binance_futures \
  --input path/to/binance_futures_pnl.csv \
  --tax-year 2025

IBKR activity statement analyzer

uv run tax-reporting ibkr \
  --input path/to/ibkr_activity_statement.csv \
  --tax-year 2025 \
  --tax-exempt-mode listed_symbol \
  --report-alias account1

IBKR Activity Statement period requirements:

• The input must cover exactly January 1 through December 31 of the selected --tax-year.
• The analyzer validates the Statement -> Period row, for example January 1, 2025 - December 31, 2025.
• The IBKR account base currency must be EUR. The analyzer validates Account Information -> Base Currency before tax calculations start.
• Wrong or missing periods fail by default because tax reporting and SPB-8 can be incorrect.
• --skip-period-validation exists only for development/testing with partial reports. Do not use it for real tax reporting.
• --tax-exempt-mode defaults to listed_symbol; the effective mode is printed in the Bulgarian TXT report because it affects tax treatment.

IBKR Equity and Index Options handling:

• Asset Category = Equity and Index Options is taxable by default and is declared in Appendix 5, Table 2, code 508.
• Normal closed options and expired options with an attached IBKR ClosedLot are processed through the same sale/acquisition ClosedLot model used for stocks.
• Option Order, SubTotal, Total, and MTM rows are not used as primary tax calculation sources.
• Exercised/assigned options without an option ClosedLot do not create standalone option P/L; the generated stock lot is expected to carry adjusted basis/proceeds.
• Options are excluded from Appendix 8 holdings and SPB-8 because they are derivative contracts, not directly held securities for the tool's SPB-8 securities model.

IBKR CFD and PIL handling:

• CFD are treated as cash-settled derivative financial instruments and realized CFD results are declared in Appendix 5, Table 2, code 508.
• IBKR Notional Value is treated as exposure / P/L calculation base, not as a real sale/acquisition value.
• Appendix 5 CFD trade values are based on realized CFD P/L: positive P/L increases the income/sale side, while negative P/L increases the cost/loss side by absolute value. This avoids artificial inflation of Appendix 5 turnover from CFD notional values.
• CFD holdings are not declared in Appendix 8 and are excluded from SPB-8; the tool does not infer an underlying ISIN from CFD symbols.
• IBKR CFD financing / CFD interest from Fees is processed as a separate adjustment, not derived from CFD Notional Value / Basis, and is netted into Appendix 5 by default. Use --no-net-cfd-financing to send positive financing to Appendix 6, code 606, and skip negative financing.
• Payment in Lieu of Dividend (Ordinary Dividend) is not treated as a real dividend and is processed separately from CFD trade P/L. Negative PIL is netted into Appendix 5 by default; use --no-net-pil to skip negative PIL. Positive PIL always goes to Appendix 6, code 606.
• This is a practical interpretation for synthetic broker cashflow adjustments; confirm treatment with your accountant if needed.

IBKR Futures handling:

• Futures are daily cash-settled derivatives and use Mark-to-Market Performance Summary as the taxable P/L source.
• Futures Trades rows and Cash Report / Cash Settling MTM rows are not added on top of MTM.
• Futures notional/contract value is not used as sale/acquisition value.
• Appendix 5 Table 2 code 508 maps positive MTM totals to the sale/income side and negative MTM totals to the acquisition/cost side by absolute value.
• Futures MTM rows affect monetary totals only; the Appendix 5 informational trade count uses actual Futures Trades executions, not MTM row count.
• Futures are excluded from SPB-8 because they are derivative/cash-settled contracts, not real securities with ISIN.

Optional venue override inputs (activates closed-world venue classification for this run):

uv run tax-reporting ibkr \
  --input path/to/ibkr_activity_statement.csv \
  --tax-year 2025 \
  --tax-exempt-mode execution_exchange \
  --eu-regulated-exchange TGATE \
  --eu-regulated-exchange "ENEXT.FR,NYSE"

Closed-world without adding extra regulated exchanges:

uv run tax-reporting ibkr \
  --input path/to/ibkr_activity_statement.csv \
  --tax-year 2025 \
  --tax-exempt-mode execution_exchange \
  --closed-world

IBKR appendix credit math note:

• Appendix 8 credit math is computed per company first (source-of-truth calculation), then optionally presented aggregated by country in country-list mode.
• Appendix 9 credit math remains country-level.
• IBKR also runs a minimal open-position reconciliation safety check (Open Positions Summary vs signed Trades Order quantities, by canonical instrument) and triggers manual review on mismatch/unmatched instruments.
• IBKR venue classification supports:
  • open-world mode (default): unmapped venues stay review-worthy
  • closed-world mode (activated by --eu-regulated-exchange or --closed-world): built-in EU regulated + CLI overrides become the effective regulated universe for this run
  • in closed-world mode, readable normalized venues are forced to non-regulated classification unless explicitly regulated (only invalid/garbled values remain review-worthy)
• IBKR diagnostics output includes Audit Data with encountered venue categories and active classification mode.
• In listed_symbol mode, execution exchange is documented once as a global informational note (no per-row informational noise).

Coinbase report analyzer

uv run tax-reporting coinbase \
  --input "path/to/Coinbase Report - since inception.csv" \
  --tax-year 2025

Finexify fund analyzer

uv run tax-reporting finexify \
  --input "path/to/finexify.csv" \
  --tax-year 2025

Afranga P2P analyzer

uv run tax-reporting afranga \
  --input "path/to/afranga_statement.pdf" \
  --tax-year 2025

Notes:

• secondary-market mode defaults to appendix_6
• appendix_5 mode is reserved for future analyzers and currently fails explicitly as not supported

Additional P2P analyzers

Estateguru:

uv run tax-reporting estateguru \
  --input "path/to/Estateguru report.pdf" \
  --tax-year 2025

Lendermarket:

uv run tax-reporting lendermarket \
  --input "path/to/Lendermarket report.pdf" \
  --tax-year 2025

Iuvo:

uv run tax-reporting iuvo \
  --input "path/to/Iuvo report.pdf" \
  --tax-year 2025

Robocash:

uv run tax-reporting robocash \
  --input "path/to/Robocash report.pdf" \
  --tax-year 2025

Bondora Go & Grow:

uv run tax-reporting bondora_go_grow \
  --input "path/to/Go & Grow report.pdf" \
  --tax-year 2025

P2P tax-mapping quick reference:

• Estateguru: code 603 = Interest + Penalty + Indemnity; code 606 = positive(Bonus (Borrower)) + positive(Bonus (EG)) + positive(Secondary market profit/loss)
• Lendermarket: code 603 = Interest + Late Payment Fees + Pending Payment interest; code 606 = Campaign rewards and bonuses (non-negative only)
• Iuvo: code 603 = Interest income + Late fees + Interest income iuvoSAVE; code 606 = positive(Campaign rewards) + positive(secondary-market aggregate)
• Robocash: code 603 = Earned interest; code 606 = positive(Earned income from bonuses)
• Bondora Go & Grow: code 603 = Interest Accrued; code 606 = positive(Bonus income received on Bondora account)

Optional:

uv run tax-reporting coinbase \
  --input "path/to/Coinbase Report - since inception.csv" \
  --tax-year 2025 \
  --output-dir output/coinbase \
  --cache-dir ~/.cache/tax_reporting

Opening-state mode (recommended after first filing year):

uv run tax-reporting coinbase \
  --input "path/to/Coinbase Report - 2025-only.csv" \
  --tax-year 2025 \
  --opening-state-json output/coinbase/coinbase_report_since_inception_state_end_2024.json \
  --output-dir output/coinbase \
  --cache-dir ~/.cache/tax_reporting

Opening-state contract:

• for --tax-year YYYY, state_tax_year_end in --opening-state-json must be < YYYY
• without --opening-state-json, the analyzer runs in since-inception/full-history mode
• with opening state, analyzer applies ledger/state math only for rows where:
• state_tax_year_end < row.timestamp.year <= tax_year
• rows <= state_tax_year_end and rows > tax_year are ignored for ledger/state
• declaration totals still include only row.timestamp.year == tax_year

Aggregate opening-state examples:

uv run tax-reporting \
  --input-dir inputs \
  --tax-year 2025 \
  --opening-state-json states/only-stateful-input.state.json

uv run tax-reporting \
  --input-dir inputs \
  --tax-year 2025 \
  --opening-state-json kraken-main.csv=states/kraken-main.state.json \
  --opening-state-json coinbase.csv=states/coinbase.state.json

Sidecar convention:

• kraken-report.csv -> kraken-report.state.json
• coinbase.xlsx -> coinbase.state.json
• some.report.v2.csv -> some.report.v2.state.json

Kraken report analyzer

uv run tax-reporting kraken \
  --input "path/to/kraken_ledger.csv" \
  --tax-year 2025

Opening-state mode (recommended after first filing year):

uv run tax-reporting kraken \
  --input "path/to/kraken_ledger_2026.csv" \
  --tax-year 2026 \
  --opening-state-json output/kraken/kraken_report_since_inception_state_end_2025.json \
  --output-dir output/kraken \
  --cache-dir ~/.cache/tax_reporting

Coinbase analyzer highlights:

• input supports Coinbase preamble + header row with or without leading ID column
• architecture is layered: Coinbase parser + Coinbase->IR mapper + shared generic crypto analyzer
• supports Buy, Sell, Convert, Send, Receive, Deposit, Withdraw, Withdrawal
• signed average-cost model per asset (quantity and total_cost_eur can be positive/negative/zero)
• realization is on closing legs only (supports partial closes and long<->short flips in a single trade)
• declaration totals include only realized closing-leg results in --tax-year (while basis uses full history)
• Convert is lowered to two IR legs with shared operation id: source Sell + target Buy (target can close an existing short)
• Coinbase statements value rule is enforced: Total = Subtotal + Fees; use Total for economic value, except Convert source uses Subtotal
• Coinbase transaction semantics are applied directly: Deposit/Withdraw as fiat movements, Send/Receive as crypto movements
• Receive can close an existing short before opening/adding long:
• CARRY_OVER_BASIS uses provided Cost Basis (EUR)
• GIFT forces zero basis
• NON-TAXABLE uses market EUR value at receive timestamp (no basis expected)
• Send rows do not accumulate in Appendix 5 totals
• Send is validated only against existing long holdings in this analyzer version
• EUR conversion via existing bnb_fx and crypto_fx
• outputs:
• enriched IR CSV (*_modified.csv) with IR columns plus EUR/tax columns
• Subtotal (EUR) / Total (EUR) and position-after audit columns are intentionally omitted from output CSV
• IR numeric columns (Quantity, Proceeds, Fee, Cost Basis) keep Decimal precision from mapping/analysis (no forced 8-decimal quantization)
• tax columns (Purchase/Sale/Profit/Net) are filled only on closing legs with non-zero realized PnL
• declaration TXT (Приложение 5 / Таблица 2) with manual-check summary
• informational manual check overrides metric (count of non-empty Review Status rows)
• year-end state JSON (*_state_end_<tax_year>.json) for incremental runs
• no separate *_ir.csv is produced; *_modified.csv is the primary IR CSV

For full Coinbase rules and edge-case behavior, see:

• src/integrations/crypto/coinbase/README.md

Kraken analyzer highlights:

• Kraken ledger rows are mapped to shared IR; accounting/PnL logic is fully in integrations.crypto.shared.
• multi-row operations are grouped by refid and lowered to IR rows with shared Operation ID.
• spend+receive pairs map to one IR Buy; trade/tradespot pairs map to IR Sell + Buy.
• receive-like crypto deposits support Review Status workflows (CARRY_OVER_BASIS, GIFT, NON-TAXABLE).
• NON-TAXABLE receive-like rows are included as non-taxable inventory movement (affect holdings/state, no taxable PnL).
• output contract matches Coinbase:
• enriched IR CSV (*_modified.csv)
• declaration TXT
• year-end state JSON

For full Kraken rules and edge-case behavior, see:

• src/integrations/crypto/kraken/README.md

Crypto FX (services.crypto_fx)

get_crypto_eur_rate(symbol_or_pair, timestamp, exchange, is_future=False) resolves to a target symbol and returns EUR value for 1 unit of that symbol:

• Pair input: use QUOTE asset from exchange metadata (binance / kraken)
• Single symbol: use symbol itself
• Kraken symbols are normalized for Binance pricing (for example XBT -> BTC)
• is_future=False: pair detection uses spot metadata (/api/v3/exchangeInfo for Binance, /0/public/AssetPairs for Kraken)
• is_future=True: pair detection uses futures metadata (/fapi/v1/exchangeInfo for Binance, /derivatives/api/v3/instruments for Kraken)
• Fiat shortcuts:
  • EUR -> 1 EUR
  • USD / USDT / USDC -> USD->EUR via bnb_fx
• Non-fiat symbols are priced via Binance hourly data on <SYMBOL>USDT (timestamp floored to hour), then converted USD->EUR via bnb_fx
• In futures mode, pricing tries Binance spot hourly close first, then falls back to Binance futures mark-price hourly candles (/fapi/v1/premiumIndexKlines)

CLI:

uv run python -m services.crypto_fx.cli get-rate \
  --symbol-or-pair ALCHUSDT \
  --exchange binance \
  --is-future \
  --timestamp 2025-10-11T10:30:15Z

License

This project is licensed under MIT + Commons Clause.

• Free for personal use
• Commercial usage requires a separate agreement

See LICENSE for details.