# broker_import_dry_runs

dry_run_id: 465c61a7-855a-494c-bf1f-0d7eedda91b7
source_name: PostFinance
source_platform: PostFinance
source_file_label: [runtime-file-redacted]
source_file_type: docx
source_hash: 59ec092da349092c29187801b3b96d77e7685cf22ca667f56b5703fac3f73040
source_filename_hash: 59ec092da349092c29187801b3b96d77e7685cf22ca667f56b5703fac3f73040
snapshot_date_status: missing
detected_sections_json: ["table_1", "table_2", "table_3", "table_4", "table_5"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.590490+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"cost_basis_uncertain": 33, "missing_isin": 33, "missing_ticker": 33, "needs_manual_review": 34, "snapshot_only": 34}

summary_json:
  {"blocked_positions": 33, "candidate_cash_rows": 1, "candidate_positions": 33, "mapped_positions": 0, "rows_total": 40, "source_file_type": "docx", "source_platform": "PostFinance"}


dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
source_name: True Wealth
source_platform: True Wealth
source_file_label: [runtime-file-redacted]
source_file_type: docx
source_hash: 6d55404a91397dc52b8162663c15de00172f9c806d3803db9114a3e970ec63a8
source_filename_hash: 6d55404a91397dc52b8162663c15de00172f9c806d3803db9114a3e970ec63a8
snapshot_date_status: missing
detected_sections_json: ["table_1"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.610688+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"cost_basis_uncertain": 17, "missing_isin": 17, "missing_ticker": 17, "needs_manual_review": 18, "snapshot_only": 18}

summary_json:
  {"blocked_positions": 17, "candidate_cash_rows": 1, "candidate_positions": 17, "mapped_positions": 0, "rows_total": 19, "source_file_type": "docx", "source_platform": "True Wealth"}


dry_run_id: cc21d566-0eeb-4e1f-ab69-f9b99356073d
source_name: Raiffeisen
source_platform: Raiffeisen
source_file_label: [runtime-file-redacted]
source_file_type: xlsx
source_hash: 67e2f92384bf608c8e06772c90519fbfce8f8f58ed475d4cee5c87dd263d476f
source_filename_hash: 67e2f92384bf608c8e06772c90519fbfce8f8f58ed475d4cee5c87dd263d476f
snapshot_date_status: missing
detected_sections_json: ["sheet_1"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.626152+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"aggregate_only": 4, "cash_snapshot_candidate": 3, "missing_instrument_details": 4, "needs_manual_review": 7}

summary_json:
  {"blocked_positions": 4, "candidate_cash_rows": 3, "candidate_positions": 4, "mapped_positions": 0, "rows_total": 8, "source_file_type": "xlsx", "source_platform": "Raiffeisen"}


# broker_import_execution_plans

execution_plan_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US9229087690
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: d91dcdb723e0725fc4d721d2c3083d3609a33c1bd04c191d3d548fbfaa55d38a
execution_status: imported
transaction_id: tx-0870b5b9-0c4e-4ffb-94b5-4eef18009b99
created_at: 2026-05-15T10:20:15.960216+00:00
updated_at: 2026-05-15T10:21:23.938094+00:00
executed_at: 2026-05-15T10:21:23.938094+00:00
notes: B6b mini-import executed for exactly one reviewed payload.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "36482.67", "instrument_id": "instrument-US9229087690", "price_original": "364.71", "quantity": "128", "snapshot_date": "2026-05-14", "source_id": "9122f3c2-eb76-4f92-b95d-1f9c2a99f686", "source_row_ref": "table1:row14", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


execution_plan_id: plan-1c6136ca-852d-4467-ae87-4924ea2bd305
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US9220428588
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: 69b0d49e21558dff03555e0dd70509e800f81507a014215c18722548f809b63b
execution_status: imported
transaction_id: tx-e13645cf-1681-4ac8-b57d-981aad88098c
created_at: 2026-05-15T10:20:15.960591+00:00
updated_at: 2026-05-15T10:48:28.447099+00:00
executed_at: 2026-05-15T10:48:28.447099+00:00
notes: B6c second controlled mini-import from reviewed True Wealth execution plan; no mass import.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "11476.56", "instrument_id": "instrument-US9220428588", "price_original": "59.94", "quantity": "245", "snapshot_date": "2026-05-14", "source_id": "1c6136ca-852d-4467-ae87-4924ea2bd305", "source_row_ref": "table1:row15", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


execution_plan_id: plan-8cc9a511-e679-47ee-a57a-30fe53ea72a6
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US92204A7028
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: 4af3459e24c3edf73a406bad31c4ebe4ece6ca7dcefa8acb175c3d1798e49ca1
execution_status: imported
transaction_id: tx-aecd65d3-148f-4e45-9e19-d5c2d85e8133
created_at: 2026-05-15T10:20:15.960672+00:00
updated_at: 2026-05-15T10:58:02.510937+00:00
executed_at: 2026-05-15T10:58:02.510937+00:00
notes: B6d final controlled True Wealth mini-import from reviewed execution plan; no mass import.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "32095.35", "instrument_id": "instrument-US92204A7028", "price_original": "113.45", "quantity": "362", "snapshot_date": "2026-05-14", "source_id": "8cc9a511-e679-47ee-a57a-30fe53ea72a6", "source_row_ref": "table1:row17", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


# instrument_price_mapping_candidates

candidate_id: ipmc_208b2282a32eef2a4890b7ab
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: openfigi
candidate_provider_symbol: VWO
candidate_exchange: US
candidate_currency: USD
candidate_name: VANGUARD FTSE EMERGING MARKE
candidate_instrument_status: unknown
confidence: high
evidence_source: openfigi_isin_mapping
evidence_note: ISIN match; currency match
review_status: selected
created_at: 2026-05-15T13:22:27.088798+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name passt fuzzy; OpenFIGI ISIN-Datenquelle


candidate_id: ipmc_5edff637f58a03d45e2785e7
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VWO
candidate_exchange: NYSEArca
candidate_currency: USD
candidate_name: Vanguard Emerging Markets Stock Index Fund
candidate_instrument_status: unknown
confidence: medium
evidence_source: yahoo_finance_search
evidence_note: ticker+exchange match; requires manual review
review_status: rejected
created_at: 2026-05-15T13:22:27.089261+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name teilweise ähnlich; Yahoo Search Fallback


candidate_id: ipmc_7bfb02f1cc92277e6a744dc0
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VEU.XA
candidate_exchange: CXA
candidate_currency: USD
candidate_name: VWORLDXUS CDI 1:1 [VEU]
candidate_instrument_status: unknown
confidence: low
evidence_source: yahoo_finance_search
evidence_note: name-only or weak provider match; manual review required
review_status: rejected
created_at: 2026-05-15T13:22:27.089323+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: equity
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
recommended_action: reject_candidate
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Yahoo Search Fallback

risk_flags:
  Assetklasse abweichend,Name unsicher,Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden


candidate_id: ipmc_8890e40a9041eafbac939cd2
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VWOB260515C00067000
candidate_exchange: OPR
candidate_currency: USD
candidate_name: VWOB May 2026 67.000 call
candidate_instrument_status: unknown
confidence: medium
evidence_source: yahoo_finance_search
evidence_note: ticker+exchange match; requires manual review
review_status: rejected
created_at: 2026-05-15T13:22:27.089405+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Name unsicher,Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Yahoo Search Fallback


candidate_id: ipmc_e31b9b9f614991e30e953a0f
instrument_id: instrument-US92204A7028
isin: US92204A7028
candidate_provider: openfigi
candidate_provider_symbol: VGT
candidate_exchange: US
candidate_currency: USD
candidate_name: VANGUARD INFO TECH ETF
candidate_instrument_status: unknown
confidence: high
evidence_source: openfigi_isin_mapping
evidence_note: ISIN match; currency match
review_status: selected
created_at: 2026-05-15T13:22:27.968162+00:00
updated_at: 2026-05-15T14:31:47.037509+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name teilweise ähnlich; OpenFIGI ISIN-Datenquelle


# instrument_import_candidates

candidate_id: instrument_candidate_37cfc02a663c3af46558a155
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 2
raw_name: / / 6 : : Konsolidiert in
raw_ticker: 16:23
raw_currency: CHF
raw_quantity: 14
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Unknown
proposed_ticker: 16:23
proposed_currency: CHF
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.197570+00:00
updated_at: 2026-05-15T20:48:32.707188+00:00
review_note:
  Ticker '16:23' and product name '/ / 6 : : Konsolidiert in' appear to be parsing errors or non-standard identifiers. Cannot map to a valid instrument. Requires manual review.


candidate_id: instrument_candidate_19c943637f01e4d7acc1885d
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 102
raw_name: ADBE
raw_ticker: ADBE
raw_currency: USD
raw_quantity: 20 260.65
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Adobe Inc.
proposed_ticker: ADBE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198000+00:00
updated_at: 2026-05-15T20:48:32.706450+00:00
review_note:
  ISIN is empty. Ticker ADBE corresponds to Adobe Inc., but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_90ea94052680d069c2265925
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 112
raw_name: ANET
raw_ticker: ANET
raw_currency: USD
raw_quantity: 36 143.60
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Arista Networks, Inc.
proposed_ticker: ANET
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198103+00:00
updated_at: 2026-05-15T20:48:32.706843+00:00
review_note:
  ISIN is empty. Ticker ANET corresponds to Arista Networks, but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_073d04d4cbe2e793877e6275
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 122
raw_name: APC
raw_ticker: APC
raw_currency: EUR
raw_quantity: 190
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Unknown/Deprecated
proposed_ticker: APC
proposed_currency: EUR
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198251+00:00
updated_at: 2026-05-15T20:48:32.706924+00:00
review_note:
  ISIN is empty. Ticker APC is ambiguous (e.g., Associated Press, or former APC Energy). Currency EUR suggests European listing, but ticker is primarily US. High risk of ambiguity. Manual verification required.


candidate_id: instrument_candidate_92a693b025538e765b52393e
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 132
raw_name: APP
raw_ticker: APP
raw_currency: USD
raw_quantity: 13 372.386
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: DoorDash, Inc.
proposed_ticker: DASH
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198350+00:00
updated_at: 2026-05-15T20:48:32.706965+00:00
review_note:
  ISIN is empty. Ticker APP is currently used by Booking Holdings (formerly Priceline). The product name 'APP' likely refers to DoorDash, which trades under DASH. Ticker mismatch detected. Manual verification required.


candidate_id: instrument_candidate_637d6d093be4a119fce6f939
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 143
raw_name: AVGO
raw_ticker: AVGO
raw_currency: USD
raw_quantity: 56
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Broadcom Inc.
proposed_ticker: AVGO
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198397+00:00
updated_at: 2026-05-15T20:48:32.707013+00:00
review_note:
  ISIN is empty. Ticker AVGO corresponds to Broadcom Inc., but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_ea496ba063247a7efbf2fc74
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 163
raw_name: BABA
raw_ticker: BABA
raw_currency: USD
raw_quantity: 46 170.82391
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Alibaba Group Holding Ltd
proposed_ticker: BABA
proposed_exchange: NYSE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198439+00:00
updated_at: 2026-05-15T20:48:32.707047+00:00
review_note:
  ISIN missing. Ticker BABA corresponds to Alibaba Group Holding Ltd on NYSE. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_19716bb81f8a16940852e7f1
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 172
raw_name: CRWD
raw_ticker: CRWD
raw_currency: USD
raw_quantity: 12 423.00
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: CrowdStrike Holdings Inc
proposed_ticker: CRWD
proposed_exchange: NASDAQ
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198480+00:00
updated_at: 2026-05-15T20:48:32.707077+00:00
review_note:
  ISIN missing. Ticker CRWD corresponds to CrowdStrike Holdings Inc on NASDAQ. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_1ec1155cea3d7ec5750a4c17
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 182
raw_name: GOOG
raw_ticker: GOOG
raw_currency: USD
raw_quantity: 96
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Alphabet Inc Class C
proposed_ticker: GOOG
proposed_exchange: NASDAQ
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198523+00:00
updated_at: 2026-05-15T20:48:32.707106+00:00
review_note:
  ISIN missing. Ticker GOOG corresponds to Alphabet Inc Class C on NASDAQ. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_2f05b84424048fa128f1a705
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 191
raw_name: MCD
raw_ticker: MCD
raw_currency: USD
raw_quantity: 14 129.97071
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: McDonald's Corp
proposed_ticker: MCD
proposed_exchange: NYSE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198569+00:00
updated_at: 2026-05-15T20:48:32.707156+00:00
review_note:
  ISIN missing. Ticker MCD corresponds to McDonald's Corp on NYSE. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_4f35bed10b8653aff2436c97
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 201
raw_name: MSFT
raw_ticker: MSFT
raw_currency: USD
raw_quantity: 19 402.66
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Microsoft Corporation
proposed_ticker: MSFT
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198611+00:00
updated_at: 2026-05-15T20:48:32.707227+00:00
review_note:
  ISIN is empty. Ticker alone is not enough for confirmation. Manual verification required to assign correct ISIN.


candidate_id: instrument_candidate_73995e5e983c42f19d7e3fde
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 253
raw_name: PANW
raw_ticker: PANW
raw_currency: USD
raw_quantity: 31 168.50
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: PANW
proposed_ticker: PANW
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198847+00:00
updated_at: 2026-05-15T20:48:32.707380+00:00
review_note:
  ISIN is empty. Ticker alone is not sufficient for confirmation. Manual verification required to assign correct ISIN and exchange.


candidate_id: instrument_candidate_d6dd6a84b6e7fc87d2282f7b
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 308
raw_name: BCHE
raw_ticker: BCHE
raw_currency: USD
raw_quantity: 98
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: BCHE
proposed_ticker: BCHE
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199052+00:00
updated_at: 2026-05-15T20:48:32.707511+00:00
review_note:
  ISIN is empty. Ticker BCHE is not unique enough for confirmation. Requires manual verification of the underlying asset.


candidate_id: instrument_candidate_bbbdba0e4d56ee9db9072c23
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 317
raw_name: IUIT
raw_ticker: IUIT
raw_currency: USD
raw_quantity: 400
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: IUIT
proposed_ticker: IUIT
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199090+00:00
updated_at: 2026-05-15T20:48:32.707541+00:00
review_note:
  ISIN is empty. Ticker IUIT is not unique enough for confirmation. Requires manual verification of the underlying asset.


candidate_id: instrument_candidate_2210109058da8500d7d28d97
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 326
raw_name: WTAI
raw_ticker: WTAI
raw_currency: USD
raw_quantity: 68
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: WTAI
proposed_ticker: WTAI
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199141+00:00
updated_at: 2026-05-15T20:48:32.707567+00:00
review_note:
  ISIN is empty. Ticker WTAI is not unique enough for confirmation. Requires manual verification of the underlying asset.


# budget_plan_items

plan_item_id: bplan_7018cd98726d44f6
plan_month: 2026-01
category_id: bcat_38c8f7bf53964431
monthly_amount_chf: 583.3333333333334
cadence: monthly
source_type: excel_seed_dry_run
notes: Budget Seed Review 2026
created_at: 2026-05-17T07:57:37Z
updated_at: 2026-05-17T07:57:37Z
name:
  Spezielle einmalige Anschaffungen (Pneu, Möbel, Mathe-Nachhilfe, Pool, Sonnensegel, Reitlager, Eisenhorn, Dreame)


# budget_transaction_candidates

transaction_candidate_id: btxcand_d35e7483a7f73aca158e4061
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R29
source_type: akb_bank
transaction_date: 2026-04-21
amount_original: 1178.00
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 40f5ed969a1703b9785eefb33a60049c
description:
  Belastung e-banking / Ref.-Nr. 1521838513 EINWOHNERGEMEINDE WINDISCH DOHLENZELGSTRASSE 6 5210 WINDISCH Schweiz Ursprünglicher Auftraggeber: MARCEL GASSER, MELANIE GASSER-SCHWAGER 000000000110320005120901003


transaction_candidate_id: btxcand_350449992652771cd748e75e
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R30
source_type: akb_bank
transaction_date: 2026-04-21
amount_original: 2400.00
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 8762b3fb49857ca8f2c3437da17929cb
description:
  Belastung e-banking / Ref.-Nr. 1521838535 HELVETIA SCHWEIZERISCHE LEBENSVERSICHERUNGSGESELLSCHAFT AG ST. ALBAN-ANLAGE 26 4002 BASEL Schweiz Mitteilung: 1210.P0.75275593 Ursprünglicher Auftraggeber: MARCEL GASSER 010075275593010526044401004


transaction_candidate_id: btxcand_02950f34fa882acf986f2523
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R43
source_type: akb_bank
transaction_date: 2026-04-07
amount_original: 4796.30
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 9faa3be050a7ddef8c54ef8382786da3
description:
  Belastung e-banking / Ref.-Nr. 1517440460 VISECA PAYMENT SERVICES AG HAGENHOLZSTRASSE 56 8050 ZUERICH Schweiz Ursprünglicher Auftraggeber: MARCEL GASSER 000000000011075681090589545


transaction_candidate_id: btxcand_077bfb60651ebf2c950f4dd4
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R44
source_type: akb_bank
transaction_date: 2026-04-07
amount_original: 133.85
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: bf65318c0a803f6930ce778d32b63ce5
description:
  Belastung e-banking / Ref.-Nr. 1517440446 JAKOB VOGT AG MITTELDORFSTRASSE 7 5234 VILLIGEN Schweiz Mitteilung: RECHNUNG NR. 189176 VOM 01.04.2026 Ursprünglicher Auftraggeber: MELANIE U. MARCEL GASSER 801472000000000000001891766


transaction_candidate_id: btxcand_183c754cb3c79308f95fab1d
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R53
source_type: akb_bank
transaction_date: 2026-03-23
amount_original: 132.26
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 91746fe25cf31c8a0c89c295308daa25
description:
  Belastung e-banking / Ref.-Nr. 1511192635 VISECA PAYMENT SERVICES AG HAGENHOLZSTRASSE 56 8050 ZUERICH Schweiz Ursprünglicher Auftraggeber: MARCEL GASSER 000000000011075681090589545


transaction_candidate_id: btxcand_b1eb9d6aea826b31439ec199
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R54
source_type: akb_bank
transaction_date: 2026-03-23
amount_original: 67.99
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 72aa7ce3a44c14258e2ed0f5dbda6fd7
description:
  Belastung e-banking / Ref.-Nr. 1511192618 KLARNA BANK AB SVEAVAEGEN 46 111 34 STOCKHOLM Schweden Mitteilung: VIDAXL.CH Ursprünglicher Auftraggeber: MELANIE GASSER 771600000013982424040092646


transaction_candidate_id: btxcand_26d832b5a74759d0edb7b6b5
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R59
source_type: akb_bank
transaction_date: 2026-03-19
amount_original: 580
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 1adef39248d64efe9138bc930477f39c
description:
  Belastung e-banking / Ref.-Nr. 1510052520 GISI EDITH BIRCHHOF 1 5412 GEBENSTORF Schweiz Mitteilung: VALERIE GASSER 06.04. - 10.04.2026 Ursprünglicher Auftraggeber: MELANIE GASSER


transaction_candidate_id: btxcand_c19fdcf158fc4f773892566f
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R60
source_type: akb_bank
transaction_date: 2026-03-19
amount_original: 580
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: ab9e1a5b46c4756230e1742103c2b4b2
description:
  Belastung e-banking / Ref.-Nr. 1510052495 GISI EDITH BIRCHHOF 1 5412 GEBENSTORF Schweiz Mitteilung: EMILIA GASSER 06.04. - 10.04.2026 Ursprünglicher Auftraggeber: MELANIE GASSER


transaction_candidate_id: btxcand_3640c5b3c570642189f85c5c
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R61
source_type: akb_bank
transaction_date: 2026-03-19
amount_original: 36
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 45a9c70740dc3ede0615464dae80718c
description:
  Belastung e-banking / Ref.-Nr. 1510052533 KLARNA BANK AB SVEAVAEGEN 46 111 34 STOCKHOLM Schweden Mitteilung: TALLOW Ursprünglicher Auftraggeber: MELANIE GASSER 771600000018410135040092614


transaction_candidate_id: btxcand_7c88369cdf743a9cf52d558b
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R93
source_type: akb_bank
transaction_date: 2026-02-16
amount_original: 1565.00
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 756b9cae2237a4e16a10dbced2db51a7
description:
  Belastung e-banking / Ref.-Nr. 1498782151 ABTEILUNG FINANZEN AARGAU SEKTION TRESORERIE 5004 AARAU Schweiz Ursprünglicher Auftraggeber: MARCEL GASSER 236111510325110000001000005


transaction_candidate_id: btxcand_0c9dec68d5e7ff250ea322cb
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R94
source_type: akb_bank
transaction_date: 2026-02-16
amount_original: 13842.60
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: bbd9a69b26abb4bc71503856a62f6361
description:
  Belastung e-banking / Ref.-Nr. 1498782177 STEUERBEZUG AARGAUER GEMEINDEN 5004 AARAU Schweiz Ursprünglicher Auftraggeber: MARCEL GASSER 104123236111510726110000007


transaction_candidate_id: btxcand_9e09cecdb26d0a54dcb4bb14
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R201
source_type: akb_bank
transaction_date: 2025-10-28
amount_original: 247.15
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 1da99f7cae5912efaec8fee9eaacd9bf
description:
  Belastung e-banking / Ref.-Nr. 1458992597 Dr. med. dent. Andre Raetzer Stapferstrasse 28 5200 Brugg Schweiz Mitteilung: PP - 945/7223 - 225060357 Ursprünglicher Auftraggeber: Gasser Melanie 803884000000072232256035775


transaction_candidate_id: btxcand_12276c1d7b9ba7b193ce902b
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R202
source_type: akb_bank
transaction_date: 2025-10-28
amount_original: 90
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 1c70e23c3d887361242773bea2802b05
description:
  Belastung e-banking / Ref.-Nr. 1458992617 Goenner-Vereinigung der Schweizer Paraplegiker-Stiftung 6207 Nottwil Schweiz Mitteilung: Herzlichen Dank fuer die Erneuerung Ihrer Mitgliedschaft 2026 Ursprünglicher Auftraggeber: Melanie und Marcel Gasser 420343560400000003541970389


transaction_candidate_id: btxcand_e1ab1d21eb39da8e31ed86f8
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R221
source_type: akb_bank
transaction_date: 2025-10-10
amount_original: 106.35
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: ee54fb72d2817fe831911cd9173a1566
description:
  Belastung e-banking / Ref.-Nr. 1453198426 Dr. med. dent. Carol Erzberger Landstrasse 99 5430 Wettingen Schweiz Mitteilung: PP - 17227/23534 - 225244640 Ursprünglicher Auftraggeber: Gasser Marcel und Melanie 040905000000235342254464074


transaction_candidate_id: btxcand_3351c911de5a86111450f6d9
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R222
source_type: akb_bank
transaction_date: 2025-10-10
amount_original: 1228.00
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: b9c98a4c35a0c0a27541b48c1499807a
description:
  Belastung e-banking / Ref.-Nr. 1453198401 Einwohnergemeinde Windisch Dohlenzelgstrasse 6 5210 Windisch Schweiz Ursprünglicher Auftraggeber: Marcel Gasser, Melanie Gasser-Schwager 000000000110320005001861001


transaction_candidate_id: btxcand_5d1fc74dd2224966fe8fe9f6
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R281
source_type: akb_bank
transaction_date: 2025-07-25
amount_original: 14.55
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 07edb350296787f1d4fd11954a66267f
description:
  Belastung e-banking / Ref.-Nr. 1426520814 POST CH AG WANKDORFALLEE 4 3030 BERN Schweiz Ursprünglicher Auftraggeber: MARCEL GASSER 104020346628030400011049692


transaction_candidate_id: btxcand_1f82dfb9bce19af5ec877c9a
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R282
source_type: akb_bank
transaction_date: 2025-07-25
amount_original: 719.2
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 3c14bfb285fdf4b23fd38efa0b419378
description:
  Belastung e-banking / Ref.-Nr. 1426520786 NACHFUEHRUNGSGEOMETER KREIS BRUGG NEUMARKT 1 5201 BRUGG AG Schweiz Ursprünglicher Auftraggeber: MARCEL GASSER 000000000213510602504531002


transaction_candidate_id: btxcand_7b1bdedd386f03d79ceba0ad
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R323
source_type: akb_bank
transaction_date: 2025-06-02
amount_original: 5913.25
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 26b6340a0b973f0df2e6ce32845da82a
description:
  Belastung e-banking / Ref.-Nr. 1408632441 SONNENSEGEL VETSCH AG SCHLOSSTALSTRASSE 209 8408 WINTERTHUR Schweiz Mitteilung: NUMMER 55290 Ursprünglicher Auftraggeber: GASSER MELANIE 000000000000000000000552906


transaction_candidate_id: btxcand_d6e54dc23424a28fb73908d7
source_file_label: Kontoauszug_360 Tage_AKB.csv
source_row_or_range: R324
source_type: akb_bank
transaction_date: 2025-06-02
amount_original: 339.85
currency_original: CHF
confidence: 0.85
status: transfer_candidate
notes: {"transaction_type": "transfer", "reason": "possible_internal_transfer"}
created_at: 2026-05-18T08:15:04Z
updated_at: 2026-05-18T08:15:04Z
classification: transfer_candidate
review_reason: possible_internal_transfer
rule_id: transfer_candidate
raw_fingerprint: 3a531c6260f5221c2828ef972229de6a
description:
  Belastung e-banking / Ref.-Nr. 1408632409 ROTHEN MEDIZINISCHE LABORATORIEN AG KORNHAUSGASSE 2 4051 BASEL Schweiz Mitteilung: RECHNUNG NR. 2673850 Ursprünglicher Auftraggeber: MARCEL GASSER 000000000000000000026738502


transaction_candidate_id: btxcand_e17e3390a4dcf5fcfd9945cb
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-05-13:12:20:27:MMM Brugg Neumarkt:253:36
source_type: migros_receipts
transaction_date: 2026-05-13
description: Migros Bon MMM Brugg Neumarkt
merchant: MMM Brugg Neumarkt
amount_original: 27.90
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_fb05da1269e846bb
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: f3e0159d8ef11bcfb03fc5a19e26b138
raw_fingerprint: f3e0159d8ef11bcfb03fc5a19e26b138
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 2, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_ef211fde4a2819c4aae60917
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-05-12:18:18:27:M Windisch:260:60
source_type: migros_receipts
transaction_date: 2026-05-12
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 218.73
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_0af4f2631aad4918
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 28b9971957089de890e0aeec0bc3d463
raw_fingerprint: 28b9971957089de890e0aeec0bc3d463
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 38, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_a09487412ca07c4278a90938
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-05-06:15:12:24:MMM Brugg Neumarkt:267:191
source_type: migros_receipts
transaction_date: 2026-05-06
description: Migros Bon MMM Brugg Neumarkt
merchant: MMM Brugg Neumarkt
amount_original: 341.89
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_6b18ec2381ba48c7
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 85f593224f0018af26ee91740758c995
raw_fingerprint: 85f593224f0018af26ee91740758c995
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 48, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_61eee9f6aaeaef5a64371582
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-05-04:11:09:20:M Windisch:259:22
source_type: migros_receipts
transaction_date: 2026-05-04
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 146.55
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_30518bcece1a445d
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 0ed4cfd1615e0fdaaea121434a53c7a2
raw_fingerprint: 0ed4cfd1615e0fdaaea121434a53c7a2
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 24, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_a8d15230cc0defbedb8b7df2
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-29:17:14:42:M Windisch:262:76
source_type: migros_receipts
transaction_date: 2026-04-29
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 270.01
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_cbce0ecfc4dd4485
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: f9e75b7752fc66991c6c7faaf2212a92
raw_fingerprint: f9e75b7752fc66991c6c7faaf2212a92
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 55, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_e63bd40d0212205afa8d636b
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-24:14:05:40:MMM Brugg Neumarkt:275:63
source_type: migros_receipts
transaction_date: 2026-04-24
description: Migros Bon MMM Brugg Neumarkt
merchant: MMM Brugg Neumarkt
amount_original: 65.85
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_a101bfc5f6e7442d
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 810b92da9b5d9a425b13dbd19ba82e42
raw_fingerprint: 810b92da9b5d9a425b13dbd19ba82e42
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 7, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_caaab602ba9fe44b378e8a3b
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-23:13:36:16:MMM Brugg Neumarkt:600:11
source_type: migros_receipts
transaction_date: 2026-04-23
description: Migros Bon MMM Brugg Neumarkt
merchant: MMM Brugg Neumarkt
amount_original: 418.76
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_186869b414454ffe
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 4a11426038b7efdab5b5e3e3c2d7c088
raw_fingerprint: 4a11426038b7efdab5b5e3e3c2d7c088
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 65, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_82cd6dc629a2118031e3dbf0
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-21:16:03:00:M Windisch:600:7
source_type: migros_receipts
transaction_date: 2026-04-21
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 87.00
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_1593deac2ebd4f74
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 90482fb6c5880df948e7f84c2d43e645
raw_fingerprint: 90482fb6c5880df948e7f84c2d43e645
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 19, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_0f9e0b4770221a483cb6e507
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-18:12:53:02:M Windisch:261:52
source_type: migros_receipts
transaction_date: 2026-04-18
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 30.25
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_dcf6d377a77f41f2
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: e8023e5dcda86ca4493686025728281a
raw_fingerprint: e8023e5dcda86ca4493686025728281a
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 9, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_6ae603a9b4814e34956c4f22
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-16:18:21:08:MMM Brugg Neumarkt:600:30
source_type: migros_receipts
transaction_date: 2026-04-16
description: Migros Bon MMM Brugg Neumarkt
merchant: MMM Brugg Neumarkt
amount_original: 285.10
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_406174faa77a4843
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 082e29205a806c9cfcea12e1473a7d04
raw_fingerprint: 082e29205a806c9cfcea12e1473a7d04
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 57, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_8247fae167c491553b561297
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-10:09:47:59:MMM Brugg Neumarkt:600:7
source_type: migros_receipts
transaction_date: 2026-04-10
description: Migros Bon MMM Brugg Neumarkt
merchant: MMM Brugg Neumarkt
amount_original: 212.16
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_028f0258a64c4f20
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 7989e53a5fe729dbee915ab84797907b
raw_fingerprint: 7989e53a5fe729dbee915ab84797907b
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 37, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_e90ff95e587c8dd8b4e1263e
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-07:17:23:07:M Windisch:256:180
source_type: migros_receipts
transaction_date: 2026-04-07
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 273.16
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_271e58da64174215
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 999cea044f2f8334af8e94fa65cd54fe
raw_fingerprint: 999cea044f2f8334af8e94fa65cd54fe
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 50, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_e5999b3da7d15d481437c9e1
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-04-02:10:37:05:M Windisch:600:4
source_type: migros_receipts
transaction_date: 2026-04-02
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 256.24
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_bb79a073b226444b
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 8c1220da61b5efc019eb60cfd5279e18
raw_fingerprint: 8c1220da61b5efc019eb60cfd5279e18
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 33, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_0bf6a52e7fa2cbc467bcc6ce
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-30:17:59:57:M Windisch:252:87
source_type: migros_receipts
transaction_date: 2026-03-30
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 352.87
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_e023da1b190140d9
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: d7494fcc7854f63ce9ca33baa9670bf5
raw_fingerprint: d7494fcc7854f63ce9ca33baa9670bf5
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 56, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_9182a0817eaf8cbc67c34e8e
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-25:13:22:35:M Windisch:600:5
source_type: migros_receipts
transaction_date: 2026-03-25
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 543.37
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_164959fcf40f4a37
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 45df8f224d64add24223dd4e8020fe56
raw_fingerprint: 45df8f224d64add24223dd4e8020fe56
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 72, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_d5d617b1a3bfacab600d467e
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-20:18:26:48:M Windisch:600:17
source_type: migros_receipts
transaction_date: 2026-03-20
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 0.40
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_ecb154848380489f
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: afcaaed32f2e0188ac95f8bc306125c4
raw_fingerprint: afcaaed32f2e0188ac95f8bc306125c4
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 1, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_89ec06ff2b1da02cf0483ba9
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-20:18:02:19:M Windisch:600:16
source_type: migros_receipts
transaction_date: 2026-03-20
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 166.62
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_b6640cdd155b48c4
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 08c8c4a2f6f8c59b762043cbc6a283ea
raw_fingerprint: 08c8c4a2f6f8c59b762043cbc6a283ea
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 28, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_994633619c4959e30237936a
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-18:12:40:14:M Windisch:600:5
source_type: migros_receipts
transaction_date: 2026-03-18
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 54.30
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_e15be218c71c4bae
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: b0df97a2a424c40344ce8f188dfda040
raw_fingerprint: b0df97a2a424c40344ce8f188dfda040
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 16, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_41e8d08e6ed3ce4a1066d379
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-17:17:43:52:M Windisch:600:7
source_type: migros_receipts
transaction_date: 2026-03-17
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 89.98
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_d7ad76dc888e4890
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 2837129262210fc2fd13cc889d43bb5d
raw_fingerprint: 2837129262210fc2fd13cc889d43bb5d
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 21, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_18c23989833fc4eae64da43d
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-12:13:23:59:M Windisch:600:9
source_type: migros_receipts
transaction_date: 2026-03-12
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 199.71
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_5855dac5c56e4f90
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: d62b98b970a9346926ae3e607e62eb50
raw_fingerprint: d62b98b970a9346926ae3e607e62eb50
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 42, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_5aab4735d47814ad89b30917
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-10:14:33:49:M Windisch:600:7
source_type: migros_receipts
transaction_date: 2026-03-10
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 183.75
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_3fc6e657b7824283
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 025f443e063a27c5fc19baf4fccadaee
raw_fingerprint: 025f443e063a27c5fc19baf4fccadaee
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 32, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_7fb1d1e53f5c085c3442a328
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-03-07:12:52:09:M Windisch:252:43
source_type: migros_receipts
transaction_date: 2026-03-07
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 135.95
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_a8d81d1a475c4132
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 85816b2f7731d15803d3f00abffec4b1
raw_fingerprint: 85816b2f7731d15803d3f00abffec4b1
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 29, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_7ca53c8fe12131d2e7076660
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-02-28:12:13:34:M Windisch:260:34
source_type: migros_receipts
transaction_date: 2026-02-28
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 131.25
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_336d93ddb2194882
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 499db65d8b780d85ccc06b352673d77f
raw_fingerprint: 499db65d8b780d85ccc06b352673d77f
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 27, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_be8b2af35d4fd66ff585b23e
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-02-26:12:29:19:M Windisch:600:2
source_type: migros_receipts
transaction_date: 2026-02-26
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 191.60
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_153d5533d59a4325
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 5244cbbc507e1ff3a6ba26867916d224
raw_fingerprint: 5244cbbc507e1ff3a6ba26867916d224
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 25, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_d437ba19d2721f0ba98ee28c
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-02-24:13:44:56:M Windisch:600:7
source_type: migros_receipts
transaction_date: 2026-02-24
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 187.95
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_bce30088acf74c8c
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 9c6c3f4999a7f2202ef5d87ad14920e4
raw_fingerprint: 9c6c3f4999a7f2202ef5d87ad14920e4
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 31, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_da805d2042d8832689b41262
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-02-21:15:31:38:M Windisch:261:71
source_type: migros_receipts
transaction_date: 2026-02-21
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 111.35
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_fc34c8cecf014271
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 638469fad5294b7825dc3da189c6ca6a
raw_fingerprint: 638469fad5294b7825dc3da189c6ca6a
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 15, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_3b517fe7e34a1446545d9d64
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-02-18:17:49:53:MM Frick:259:39
source_type: migros_receipts
transaction_date: 2026-02-18
description: Migros Bon MM Frick
merchant: MM Frick
amount_original: 181.45
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_13c961bf2d554173
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 4c419f3c7e2e3f0c2d53b87defcd1a18
raw_fingerprint: 4c419f3c7e2e3f0c2d53b87defcd1a18
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 40, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_9b0f0e34425a2e6edbe95306
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-02-07:10:56:44:M Windisch:600:4
source_type: migros_receipts
transaction_date: 2026-02-07
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 39.97
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_b02eeb784ef34c0c
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 263c39045dbcf778cb10a4c8adfc0115
raw_fingerprint: 263c39045dbcf778cb10a4c8adfc0115
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 12, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_93db4614c935c6143670da6e
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-02-04:16:29:27:M Windisch:600:7
source_type: migros_receipts
transaction_date: 2026-02-04
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 274.46
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_df21fdf9ee5243af
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 82f2948310b454518128b58271e12fca
raw_fingerprint: 82f2948310b454518128b58271e12fca
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 51, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_bafc5628a7354a43417c4250
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-01-27:13:24:29:M Windisch:600:2
source_type: migros_receipts
transaction_date: 2026-01-27
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 347.81
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_16f7834ac4264493
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 4ae9c44843b99382fd782f7a31a9e2d0
raw_fingerprint: 4ae9c44843b99382fd782f7a31a9e2d0
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 36, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_a0d558acfab3fafc6ac71af7
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-01-23:16:41:01:M Windisch:600:8
source_type: migros_receipts
transaction_date: 2026-01-23
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 197.01
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_a9e321df58b54100
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 26565c7472e8838b9dbca9eaa46be779
raw_fingerprint: 26565c7472e8838b9dbca9eaa46be779
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 26, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_68c3e97e7aed4bd55b0a7cbe
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-01-21:09:41:07:M Windisch:600:3
source_type: migros_receipts
transaction_date: 2026-01-21
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 126.35
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_b67a85d5858940cb
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: b0664b055730a06e96c3ea2ac6e072ec
raw_fingerprint: b0664b055730a06e96c3ea2ac6e072ec
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 17, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_9d706737d30722929a70bddb
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-01-19:17:17:39:MM Frick:252:35
source_type: migros_receipts
transaction_date: 2026-01-19
description: Migros Bon MM Frick
merchant: MM Frick
amount_original: 54.10
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_795f78b977894657
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: c33a254580cfdb4fa5774c9adecf75cf
raw_fingerprint: c33a254580cfdb4fa5774c9adecf75cf
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 10, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_89026fd291aa62b2af701d08
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-01-17:11:07:52:M Windisch:600:6
source_type: migros_receipts
transaction_date: 2026-01-17
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 17.55
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_74cf02455c0a4854
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 253e80854c46a1acbb842d066a8c31d3
raw_fingerprint: 253e80854c46a1acbb842d066a8c31d3
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 4, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_e7f7ce9c1e7728d348f9e3d2
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-01-13:13:41:58:M Windisch:600:4
source_type: migros_receipts
transaction_date: 2026-01-13
description: Migros Bon M Windisch
merchant: M Windisch
amount_original: 266.55
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_b0306c86d19d404d
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: 70074f885b3d6a676fdf84dc7b8bf318
raw_fingerprint: 70074f885b3d6a676fdf84dc7b8bf318
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 39, "article_rows_are_detail_only": true}


transaction_candidate_id: btxcand_ea78b3993329672120a5ac89
source_file_label: 2026 Migros Einkäufe.csv
source_row_or_range: BON:2026-01-02:13:56:42:MM Wettingen Landstrasse:600:8
source_type: migros_receipts
transaction_date: 2026-01-02
description: Migros Bon MM Wettingen Landstrasse
merchant: MM Wettingen Landstrasse
amount_original: 287.90
currency_original: CHF
proposed_category_id: bcat_food_household
proposed_category_name: Essen & Haushalt
duplicate_of_transaction_id: btx_0b77cbbc6860469d
confidence: 0.90
status: duplicate_candidate
created_at: 2026-05-18T08:15:08Z
updated_at: 2026-05-18T08:15:46Z
classification: migros_receipt_food_household
review_reason: duplicate_detection_v1
rule_id: migros_receipt_food_household
rule_name: Migros Bon = Essen & Haushalt
receipt_key: de19ef5c3c801349641e0c7b6187f6f6
raw_fingerprint: de19ef5c3c801349641e0c7b6187f6f6
status_label: Mögliches Duplikat
notes:
  {"rule": "migros_receipt_food_household", "legacy_threshold_chf": "50.00", "line_items": 62, "article_rows_are_detail_only": true}


