# reports

report_id: 445926f6-f996-4f21-b9ac-96de57b764f4
report_type: crypto_inventory
title: JARVIS Finance System – Crypto-Bestandsübersicht
generated_at: 2026-05-14T20:26:54.506833+00:00
format: html
data_quality_status: warning
created_at: 2026-05-14T20:26:54.506833+00:00
file_path:
  /home/agent/jarvis_runtime/finance-system/reports/crypto_inventory_2026-05-14T202654.506024_0000_445926f6.html

summary_json:
  {"coin_count": 19, "data_quality_status": "warning", "total_value_chf": "0.0000", "wallet_count": 5}


# audit_log

audit_id: 781f60a7-b079-4b58-bd97-6ed0b9d3832d
timestamp: 2026-05-14T20:00:16.373467+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_ede605b274c5fd3e07c582c4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:00:16.373467+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:00:16.373467+00:00
new_values_json:
  {"asset_id": "cryptoasset_d990077f677822ae238571fe", "quantity": "1.19092", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 0029b7d9-36aa-4260-8f9f-f0a3c8453cf5
timestamp: 2026-05-14T20:00:16.397489+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_25a53ff7f2b3e82c69076efc
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:00:16.397489+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:00:16.397489+00:00
new_values_json:
  {"asset_id": "cryptoasset_a59d59de7003caab014f5a50", "quantity": "0.4848", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: ff3f508d-37db-4e03-b7dd-74d82be2779f
timestamp: 2026-05-14T20:00:16.427660+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_04f5a7bbc7ae944b9fa039a5
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:00:16.427660+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:00:16.427660+00:00
new_values_json:
  {"asset_id": "cryptoasset_69c3ce7ef1c93c72de019745", "quantity": "0.00000827", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: 16d7964a-9588-4756-93ea-e3e67b28a2eb
timestamp: 2026-05-14T20:02:16.599911+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1bf44d45e14b434466c62c19
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.599911+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.599911+00:00
new_values_json:
  {"asset_id": "cryptoasset_69c3ce7ef1c93c72de019745", "quantity": "4.1458", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}


audit_id: 640c27c9-0439-4fa4-bf96-bb07bb070157
timestamp: 2026-05-14T20:02:16.665973+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_42faa4ddf615c765100fab19
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.665973+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.665973+00:00
new_values_json:
  {"asset_id": "cryptoasset_2500f677b0de8802a4bf89ca", "quantity": "76.64476", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}


audit_id: b3f24353-9f5c-4826-bb16-a85221c23474
timestamp: 2026-05-14T20:02:16.719656+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8092b0278c9d333291a2df8f
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.719656+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.719656+00:00
new_values_json:
  {"asset_id": "cryptoasset_bebb859edbcf1636ae020883", "quantity": "3.89", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: c4a70c62-e146-45de-80e2-0937a49b2437
timestamp: 2026-05-14T20:02:16.774953+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_74bfcba2ecca66532a5f30e9
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.774953+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.774953+00:00
new_values_json:
  {"asset_id": "cryptoasset_e372b4e14a0a966832ee079e", "quantity": "0.06603", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: 43fc4a5a-212c-4f94-b426-a22a6973b2c1
timestamp: 2026-05-14T20:02:16.834588+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_e1ccd868b76de9eb9b910dbf
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.834588+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.834588+00:00
new_values_json:
  {"asset_id": "cryptoasset_c59843f8c5acd3b21a7c926f", "quantity": "99.546", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 466f0ce3-ff19-4e0f-9448-020240fc52fa
timestamp: 2026-05-14T20:02:16.887425+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_ec3b034a4b058aa1e724e602
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.887425+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.887425+00:00
new_values_json:
  {"asset_id": "cryptoasset_52c5dafd4cd27b874c95b37d", "quantity": "0.02949744", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: 363226c7-f1a7-4581-8a4f-579f716665cb
timestamp: 2026-05-14T20:02:16.946620+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_5dea158b010f8c3e3720a5f3
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.946620+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.946620+00:00
new_values_json:
  {"asset_id": "cryptoasset_2ab3669b3d5981a626da55a8", "quantity": "3.7", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: 3b3ba3f8-2f45-41f6-9825-a21940f215b5
timestamp: 2026-05-14T20:02:16.999816+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8128f6e2096d0b8bd97aaf40
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.999816+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.999816+00:00
new_values_json:
  {"asset_id": "cryptoasset_8b84f89418c998a1b3ba411d", "quantity": "591.35915997", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 2e575b29-9d57-48eb-9ae3-d4c2e1809938
timestamp: 2026-05-14T20:02:17.047417+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_f8b79a5f9425866cf11c0ea2
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.047417+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.047417+00:00
new_values_json:
  {"asset_id": "cryptoasset_9fd06021a9f142fdd0947c10", "quantity": "6845.2209", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 15e67c60-8d0e-41e0-a443-04dc88b0a0c4
timestamp: 2026-05-14T20:02:17.102027+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_21423276abdbbe8c15ef59c5
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.102027+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.102027+00:00
new_values_json:
  {"asset_id": "cryptoasset_b47f2001e497ca88f261120e", "quantity": "1106.3", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 537ca19c-fb00-4477-a2a8-3fdea1c50463
timestamp: 2026-05-14T20:02:17.158456+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_236c9fa241cf819fa26bbcb4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.158456+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.158456+00:00
new_values_json:
  {"asset_id": "cryptoasset_98a4d07afe75f30d91f74b83", "quantity": "0.00000005", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: e94a8b88-8c4e-4352-b146-7c5ac254b2e6
timestamp: 2026-05-14T20:02:17.183749+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1539a1d7762d657b8204a1bc
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.183749+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.183749+00:00
new_values_json:
  {"asset_id": "cryptoasset_98a4d07afe75f30d91f74b83", "quantity": "4436.4290262", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 71d1bd08-5b48-4ef9-9005-63078ec22e4e
timestamp: 2026-05-14T20:02:17.237028+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_d29d7ae91579d315c15f5f20
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.237028+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.237028+00:00
new_values_json:
  {"asset_id": "cryptoasset_5bede362c9a431037f70fa1e", "quantity": "6076.670747", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 988b23c6-df70-4db5-9e0e-ae84a720da22
timestamp: 2026-05-14T20:02:17.279223+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_47920b7da5806619988fff23
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.279223+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.279223+00:00
new_values_json:
  {"asset_id": "cryptoasset_272a5091996eb8f5df029660", "quantity": "1779.434766", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: ecd58e4b-53da-4920-b644-1f050e94c660
timestamp: 2026-05-14T20:02:17.306964+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8ee79062a432b98506a1acec
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.306964+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.306964+00:00
new_values_json:
  {"asset_id": "cryptoasset_272a5091996eb8f5df029660", "quantity": "170.68932217", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: a0ce8b09-306e-465e-837b-f3d39249d17d
timestamp: 2026-05-14T20:02:17.328975+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_ab74905d7ec536cdf2be8d1f
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.328975+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.328975+00:00
new_values_json:
  {"asset_id": "cryptoasset_272a5091996eb8f5df029660", "quantity": "10964.96647638", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 87e19c80-15d7-499f-804c-6ed44cb207a2
timestamp: 2026-05-14T20:02:17.372586+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_a9b4e4f91f418bcf6ab0a456
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.372586+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.372586+00:00
new_values_json:
  {"asset_id": "cryptoasset_470329d32a0a3d43bad12cef", "quantity": "6.69", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: 4279e698-68a1-44e3-b85a-03de143e1be1
timestamp: 2026-05-14T20:02:17.425848+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_9ce372b690769b43d49b68a4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.425848+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.425848+00:00
new_values_json:
  {"asset_id": "cryptoasset_c5f39996f2c8bdc29d042e24", "quantity": "49033.983", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: e45d6d04-da58-4886-8725-c5cdc7ca293b
timestamp: 2026-05-14T20:02:17.449349+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_7bf6705a8271fc8afa6e06b4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.449349+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.449349+00:00
new_values_json:
  {"asset_id": "cryptoasset_c5f39996f2c8bdc29d042e24", "quantity": "10904.2", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 9d1988d7-e8ff-42f7-b154-bb30e803bbac
timestamp: 2026-05-14T20:02:17.490335+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_a312fcc40df6d707bd5431f8
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.490335+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.490335+00:00
new_values_json:
  {"asset_id": "cryptoasset_567472cf2e850b16a90df5fd", "quantity": "863.110853", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: e1bf3b56-c580-41a3-94b3-69000b87f0a3
timestamp: 2026-05-14T20:02:17.557349+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_2bcb1c67db914ec839e27fba
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.557349+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.557349+00:00
new_values_json:
  {"asset_id": "cryptoasset_48790384d6062bb79c4903ac", "quantity": "203.2901", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 0d3d36f9-5611-43b8-a06a-fed31cc9637e
timestamp: 2026-05-14T20:02:17.585390+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_11ee6f5b5b5fc53d37d52920
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.585390+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.585390+00:00
new_values_json:
  {"asset_id": "cryptoasset_48790384d6062bb79c4903ac", "quantity": "124.73272", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}


audit_id: f563a2f8-bd27-4384-a0bc-72dbe557b3c6
timestamp: 2026-05-14T20:26:54.506931+00:00
source: reports
action: report_generated
entity_type: report
entity_id: 445926f6-f996-4f21-b9ac-96de57b764f4
old_values_json: {}
confirmation_timestamp: 2026-05-14T20:26:54.506931+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:26:54.506931+00:00
new_values_json:
  {"file_path": "/home/agent/jarvis_runtime/finance-system/reports/crypto_inventory_2026-05-14T202654.506024_0000_445926f6.html", "format": "html", "report_type": "crypto_inventory"}


audit_id: bdb726ac-b3f3-4566-b1d2-dcf82cd5d76e
timestamp: 2026-05-14T21:46:05.188407+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_0c4251cca1b3ab63c6279c4c
old_values_json: {}
user_text_note: Nachtrag aus initialer Crypto-Bestandsdatei, manuell geprüft
confirmation_timestamp: 2026-05-14T21:46:05.188407+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T21:46:05.188407+00:00
new_values_json:
  {"asset_id": "cryptoasset_8a4782e68d4ff24fd473be11", "quantity": "0.03576008", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 875fcff7-dff0-4497-8771-62c7e3bbbbf9
timestamp: 2026-05-14T21:46:05.200964+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_855f111abd945b23077ac7d9
old_values_json: {}
user_text_note: Nachtrag aus initialer Crypto-Bestandsdatei, manuell geprüft
confirmation_timestamp: 2026-05-14T21:46:05.200964+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T21:46:05.200964+00:00
new_values_json:
  {"asset_id": "cryptoasset_8a4782e68d4ff24fd473be11", "quantity": "0.32318582", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 4231dc78-1211-4580-b5d7-139a02b214e9
timestamp: 2026-05-15T10:09:51.822803+00:00
source: manual_review_queue
action: create_review_account_metadata
entity_type: account
entity_id: true-wealth-review-brokerage
old_values_json: {}
new_values_json: {"account_type": "brokerage", "currency": "CHF", "platform_id": "true-wealth"}
confirmation_timestamp: 2026-05-15T10:09:51.822803+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.822803+00:00
user_text_note:
  B5 pilot metadata-only brokerage account for True Wealth ETF review items; no cash/ledger/snapshot write.


audit_id: eebba623-71e8-494f-bb1d-be19586978b0
timestamp: 2026-05-15T10:09:51.823255+00:00
source: manual_review_queue
action: update_isin
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
user_text_note: B5 pilot: ISIN read from True Wealth review label; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823255+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823255+00:00
old_values_json:
  {"isin": null, "quality_flags": ["needs_manual_review", "snapshot_only", "missing_isin", "missing_ticker", "cost_basis_uncertain"]}

new_values_json:
  {"isin": "US9229087690", "quality_flags": ["needs_manual_review", "snapshot_only", "missing_ticker", "cost_basis_uncertain"], "readiness": "review_needed"}


audit_id: e99f2428-233f-44fb-870b-3f03c7be53d3
timestamp: 2026-05-15T10:09:51.823341+00:00
source: manual_review_queue
action: update_ticker_exchange
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"exchange": null, "ticker": null}
user_text_note: B5 pilot: ticker/exchange from known ETF primary listing; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823341+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823341+00:00
new_values_json:
  {"exchange": "NYSE ARCA", "readiness": "review_needed", "ticker": "VTI", "ticker_exchange_confirmed": 1}


audit_id: 85d7dc0b-2f60-4f47-9d5b-87e35025d82b
timestamp: 2026-05-15T10:09:51.823490+00:00
source: manual_review_queue
action: confirm_snapshot_date
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"snapshot_date_confirmed": 0}
new_values_json: {"readiness": "review_needed", "snapshot_date_confirmed": 1}
confirmation_timestamp: 2026-05-15T10:09:51.823490+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823490+00:00
user_text_note:
  B5 pilot: snapshot date missing in parser output; manually confirmed as review metadata only with quality note, no import.


audit_id: 9131c8f6-cfd4-4317-850e-2a4e5d83d178
timestamp: 2026-05-15T10:09:51.823590+00:00
source: manual_review_queue
action: confirm_instrument_mapping
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"mapped_instrument_id": null, "review_status": "open"}
user_text_note: B5 pilot: confirm instrument mapping by ISIN; no name-only mapping.
confirmation_timestamp: 2026-05-15T10:09:51.823590+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823590+00:00
new_values_json:
  {"mapped_instrument_id": "instrument-US9229087690", "readiness": "review_needed", "review_status": "mapped"}


audit_id: 07aa197e-a069-4771-b8b5-7e5bf50b7113
timestamp: 2026-05-15T10:09:51.823766+00:00
source: manual_review_queue
action: update_isin
entity_type: broker_import_review_item
entity_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
user_text_note: B5 pilot: ISIN read from True Wealth review label; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823766+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823766+00:00
old_values_json:
  {"isin": null, "quality_flags": ["needs_manual_review", "snapshot_only", "missing_isin", "missing_ticker", "cost_basis_uncertain"]}

new_values_json:
  {"isin": "US9220428588", "quality_flags": ["needs_manual_review", "snapshot_only", "missing_ticker", "cost_basis_uncertain"], "readiness": "review_needed"}


audit_id: 98c00c5f-eed4-4048-9ae6-77d107b5488f
timestamp: 2026-05-15T10:09:51.823828+00:00
source: manual_review_queue
action: update_ticker_exchange
entity_type: broker_import_review_item
entity_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
old_values_json: {"exchange": null, "ticker": null}
user_text_note: B5 pilot: ticker/exchange from known ETF primary listing; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823828+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823828+00:00
new_values_json:
  {"exchange": "NYSE ARCA", "readiness": "review_needed", "ticker": "VWO", "ticker_exchange_confirmed": 1}


audit_id: 2e606df8-ab5b-4c34-8705-f1767017eb23
timestamp: 2026-05-15T10:09:51.823986+00:00
source: manual_review_queue
action: confirm_instrument_mapping
entity_type: broker_import_review_item
entity_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
old_values_json: {"mapped_instrument_id": null, "review_status": "open"}
user_text_note: B5 pilot: confirm instrument mapping by ISIN; no name-only mapping.
confirmation_timestamp: 2026-05-15T10:09:51.823986+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823986+00:00
new_values_json:
  {"mapped_instrument_id": "instrument-US9220428588", "readiness": "review_needed", "review_status": "mapped"}


audit_id: 75609d24-d9ea-4c6f-82aa-82a809d72eba
timestamp: 2026-05-15T10:09:51.824173+00:00
source: manual_review_queue
action: update_isin
entity_type: broker_import_review_item
entity_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
user_text_note: B5 pilot: ISIN read from True Wealth review label; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.824173+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.824173+00:00
old_values_json:
  {"isin": null, "quality_flags": ["needs_manual_review", "snapshot_only", "missing_isin", "missing_ticker", "cost_basis_uncertain"]}

new_values_json:
  {"isin": "US92204A7028", "quality_flags": ["needs_manual_review", "snapshot_only", "missing_ticker", "cost_basis_uncertain"], "readiness": "review_needed"}


audit_id: 7344837d-30c8-4ef0-986a-f8b17e187711
timestamp: 2026-05-15T10:09:51.824242+00:00
source: manual_review_queue
action: update_ticker_exchange
entity_type: broker_import_review_item
entity_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
old_values_json: {"exchange": null, "ticker": null}
user_text_note: B5 pilot: ticker/exchange from known ETF primary listing; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.824242+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.824242+00:00
new_values_json:
  {"exchange": "NYSE ARCA", "readiness": "review_needed", "ticker": "VGT", "ticker_exchange_confirmed": 1}


audit_id: fc38d36e-b72a-4533-8444-76e345f3dd51
timestamp: 2026-05-15T10:09:51.824398+00:00
source: manual_review_queue
action: confirm_instrument_mapping
entity_type: broker_import_review_item
entity_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
old_values_json: {"mapped_instrument_id": null, "review_status": "open"}
user_text_note: B5 pilot: confirm instrument mapping by ISIN; no name-only mapping.
confirmation_timestamp: 2026-05-15T10:09:51.824398+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.824398+00:00
new_values_json:
  {"mapped_instrument_id": "instrument-US92204A7028", "readiness": "review_needed", "review_status": "mapped"}


audit_id: 852d0809-fcb0-47cf-bd5e-139f4b06a318
timestamp: 2026-05-15T10:10:55.706475+00:00
source: manual_review_queue
action: correct_detected_presence_flags
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"detected_market_value_present": 0, "detected_quantity_present": 0}
new_values_json: {"detected_market_value_present": 1, "detected_quantity_present": 1}
confirmation_timestamp: 2026-05-15T10:10:55.706475+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:10:55.706475+00:00
user_text_note:
  B5 pilot presence-only correction after verifying source table has quantity/value columns; no numeric data stored.


audit_id: a269e3d3-d758-4cb6-b84e-11be6447cb5c
timestamp: 2026-05-15T10:20:15.960489+00:00
source: broker_import_execution_plan
action: create_or_update_execution_plan
entity_type: broker_import_execution_plan
entity_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {}
user_text_note: B6a final dry-run execution plan created/updated; no productive import.
confirmation_timestamp: 2026-05-15T10:20:15.960489+00:00
created_by: phase_b6a
quality_status: ok
created_at: 2026-05-15T10:20:15.960489+00:00
new_values_json:
  {"payload_status": "ready", "quality_flags": ["cost_basis_uncertain", "fx_missing"], "review_item_id": "9122f3c2-eb76-4f92-b95d-1f9c2a99f686"}


audit_id: d7539363-e42e-4f3f-9c39-ab3b37ee3c0b
timestamp: 2026-05-15T10:20:15.960635+00:00
source: broker_import_execution_plan
action: create_or_update_execution_plan
entity_type: broker_import_execution_plan
entity_id: plan-1c6136ca-852d-4467-ae87-4924ea2bd305
old_values_json: {}
user_text_note: B6a final dry-run execution plan created/updated; no productive import.
confirmation_timestamp: 2026-05-15T10:20:15.960635+00:00
created_by: phase_b6a
quality_status: ok
created_at: 2026-05-15T10:20:15.960635+00:00
new_values_json:
  {"payload_status": "ready", "quality_flags": ["cost_basis_uncertain", "fx_missing"], "review_item_id": "1c6136ca-852d-4467-ae87-4924ea2bd305"}


audit_id: 15e84910-e293-424a-89c6-98c44b3fa6a5
timestamp: 2026-05-15T10:20:15.960699+00:00
source: broker_import_execution_plan
action: create_or_update_execution_plan
entity_type: broker_import_execution_plan
entity_id: plan-8cc9a511-e679-47ee-a57a-30fe53ea72a6
old_values_json: {}
user_text_note: B6a final dry-run execution plan created/updated; no productive import.
confirmation_timestamp: 2026-05-15T10:20:15.960699+00:00
created_by: phase_b6a
quality_status: ok
created_at: 2026-05-15T10:20:15.960699+00:00
new_values_json:
  {"payload_status": "ready", "quality_flags": ["cost_basis_uncertain", "fx_missing"], "review_item_id": "8cc9a511-e679-47ee-a57a-30fe53ea72a6"}


audit_id: eeb7bd54-f6f3-481a-b33e-ae64e333a796
timestamp: 2026-05-15T10:21:23.938362+00:00
source: broker_import_execution_plan
action: execute_mini_import
entity_type: transaction
entity_id: tx-0870b5b9-0c4e-4ffb-94b5-4eef18009b99
old_values_json: {}
confirmation_timestamp: 2026-05-15T10:21:23.938362+00:00
created_by: phase_b6b
quality_status: ok
created_at: 2026-05-15T10:21:23.938362+00:00
new_values_json:
  {"execution_plan_id": "plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686", "quality_status": "warning", "review_item_id": "9122f3c2-eb76-4f92-b95d-1f9c2a99f686", "transaction_type": "initial_position_snapshot"}

user_text_note:
  B6b productive mini-import of exactly one True Wealth reviewed initial snapshot. No values emitted to chat.


audit_id: d124b827-5cfd-4f7a-8cd3-edbd6382abbd
timestamp: 2026-05-15T10:48:28.447340+00:00
source: broker_import_execution_plan
action: execute_mini_import
entity_type: transaction
entity_id: tx-e13645cf-1681-4ac8-b57d-981aad88098c
old_values_json: {}
user_text_note: B6c second controlled mini-import from reviewed True Wealth execution plan; no mass import.
confirmation_timestamp: 2026-05-15T10:48:28.447340+00:00
created_by: phase_b6c
quality_status: ok
created_at: 2026-05-15T10:48:28.447340+00:00
new_values_json:
  {"execution_plan_id": "plan-1c6136ca-852d-4467-ae87-4924ea2bd305", "quality_status": "warning", "review_item_id": "1c6136ca-852d-4467-ae87-4924ea2bd305", "transaction_type": "initial_position_snapshot"}


audit_id: 53f3c5cc-5671-4201-86a9-7b9a8b9ae184
timestamp: 2026-05-15T10:58:02.511142+00:00
source: broker_import_execution_plan
action: execute_mini_import
entity_type: transaction
entity_id: tx-aecd65d3-148f-4e45-9e19-d5c2d85e8133
old_values_json: {}
user_text_note: B6d final controlled True Wealth mini-import from reviewed execution plan; no mass import.
confirmation_timestamp: 2026-05-15T10:58:02.511142+00:00
created_by: phase_b6d
quality_status: ok
created_at: 2026-05-15T10:58:02.511142+00:00
new_values_json:
  {"execution_plan_id": "plan-8cc9a511-e679-47ee-a57a-30fe53ea72a6", "quality_status": "warning", "review_item_id": "8cc9a511-e679-47ee-a57a-30fe53ea72a6", "transaction_type": "initial_position_snapshot"}


audit_id: 82d133d2-eed9-43b0-be1c-d5d296eed3ad
timestamp: 2026-05-15T12:56:13.842993+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_587a0304aacaba2a4bd3f0a6
old_values_json: {}
user_text_note: prepare catalog from existing instruments
confirmation_timestamp: 2026-05-15T12:56:13.842993+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T12:56:13.842993+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "NYSE ARCA", "isin": "US9220428588", "provider": "manual", "provider_symbol": null, "ticker": "VWO"}


audit_id: eba572a7-71c3-44a5-bd59-56a1014635b7
timestamp: 2026-05-15T12:56:13.870310+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ce8a71a4a3457ce6605edf16
old_values_json: {}
user_text_note: prepare catalog from existing instruments
confirmation_timestamp: 2026-05-15T12:56:13.870310+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T12:56:13.870310+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "NYSE ARCA", "isin": "US92204A7028", "provider": "manual", "provider_symbol": null, "ticker": "VGT"}


audit_id: 51910223-ff79-4e88-a95f-4c3db40e7d59
timestamp: 2026-05-15T12:56:13.897495+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_50d5fd9b1d080e95fe7429fc
old_values_json: {}
user_text_note: prepare catalog from existing instruments
confirmation_timestamp: 2026-05-15T12:56:13.897495+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T12:56:13.897495+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "NYSE ARCA", "isin": "US9229087690", "provider": "manual", "provider_symbol": null, "ticker": "VTI"}


audit_id: 4d743a95-e1f4-4577-a2af-9345a711055f
timestamp: 2026-05-15T14:25:28.676336+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_5332cdb66603ea6ffefdb64e
old_values_json: {}
user_text_note: Ist OK. Preis stand 14.05.2026: USD 59.94
confirmation_timestamp: 2026-05-15T14:25:28.676336+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:25:28.676336+00:00
new_values_json:
  {"account_id": "true-wealth-review-brokerage", "catalog_entry_id": "catalog_587a0304aacaba2a4bd3f0a6", "instrument_id": "instrument-US9220428588", "transaction_type": "manual_adjustment"}


audit_id: cf4f2095-b09f-497e-bd98-30d891459091
timestamp: 2026-05-15T14:26:42.800380+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_de2c4c482616312b7f28b5a5
old_values_json: {}
user_text_note: Ist OK. Preis stand 14.05.2026: USD 113.45
confirmation_timestamp: 2026-05-15T14:26:42.800380+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:26:42.800380+00:00
new_values_json:
  {"account_id": "true-wealth-review-brokerage", "catalog_entry_id": "catalog_ce8a71a4a3457ce6605edf16", "instrument_id": "instrument-US92204A7028", "transaction_type": "manual_adjustment"}


audit_id: df51e262-43db-49b2-bb55-0769535a28dd
timestamp: 2026-05-15T14:27:30.391153+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_70e832601465b74bc397bf0d
old_values_json: {}
user_text_note: Ist OK. Preis stand 14.05.2026: USD 364.71
confirmation_timestamp: 2026-05-15T14:27:30.391153+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:27:30.391153+00:00
new_values_json:
  {"account_id": "true-wealth-review-brokerage", "catalog_entry_id": "catalog_50d5fd9b1d080e95fe7429fc", "instrument_id": "instrument-US9229087690", "transaction_type": "manual_adjustment"}


audit_id: d50a5b8f-b49f-46fe-b9f4-a69440ddac82
timestamp: 2026-05-15T14:31:15.849689+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_82cca9f51734b1a1d04f7b7c
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:15.849689+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:15.849689+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument-US9220428588", "instrument_status": "unknown", "provider": "openfigi", "provider_market": "US", "provider_symbol": "VWO", "valuation_policy": "live_price"}


audit_id: 90b48367-fb64-4788-b473-6d980e29d417
timestamp: 2026-05-15T14:31:15.867548+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_378e3ce00a67c6393b6b2c5a
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:15.867548+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:15.867548+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "US", "isin": "US9220428588", "provider": "openfigi", "provider_symbol": "VWO", "ticker": "VWO"}


audit_id: 9cc36bb2-6531-4a00-a7d3-e3146846f9d3
timestamp: 2026-05-15T14:31:15.881336+00:00
source: instrument_price_mapping_candidate
action: select_mapping_candidate
entity_type: instrument_price_mapping_candidate
entity_id: ipmc_208b2282a32eef2a4890b7ab
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:15.881336+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:15.881336+00:00
new_values_json:
  {"instrument_id": "instrument-US9220428588", "mapping_id": "ipm_82cca9f51734b1a1d04f7b7c", "provider": "openfigi", "provider_symbol": "VWO"}


audit_id: 94a2fdbe-9c1b-49a1-9bc0-f775195270b4
timestamp: 2026-05-15T14:31:47.024914+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_8d538c9112b01f5c5131ef73
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:47.024914+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:47.024914+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument-US92204A7028", "instrument_status": "unknown", "provider": "openfigi", "provider_market": "US", "provider_symbol": "VGT", "valuation_policy": "live_price"}


audit_id: 3c71b065-1d03-400c-aca4-a3efceec30fd
timestamp: 2026-05-15T14:31:47.037958+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ef2e759ab744c1a3b1f52ebc
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:47.037958+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:47.037958+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "US", "isin": "US92204A7028", "provider": "openfigi", "provider_symbol": "VGT", "ticker": "VGT"}


audit_id: 841a8645-0d23-4ca9-ae9d-7e029733df17
timestamp: 2026-05-15T14:31:47.046696+00:00
source: instrument_price_mapping_candidate
action: select_mapping_candidate
entity_type: instrument_price_mapping_candidate
entity_id: ipmc_e31b9b9f614991e30e953a0f
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:47.046696+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:47.046696+00:00
new_values_json:
  {"instrument_id": "instrument-US92204A7028", "mapping_id": "ipm_8d538c9112b01f5c5131ef73", "provider": "openfigi", "provider_symbol": "VGT"}


audit_id: 4e24e0e8-c392-4a2e-8c54-14bf0d10bc25
timestamp: 2026-05-15T14:32:37.898125+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_971a1108ea37c7efb9dc03fa
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:32:37.898125+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:32:37.898125+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument-US9229087690", "instrument_status": "unknown", "provider": "openfigi", "provider_market": "US", "provider_symbol": "VTI", "valuation_policy": "live_price"}


audit_id: 09b9689f-cea7-4111-901f-a150e099d9a6
timestamp: 2026-05-15T14:32:37.909295+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_d7c9ae7fe9a2e0d3bcdb1d52
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:32:37.909295+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:32:37.909295+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "US", "isin": "US9229087690", "provider": "openfigi", "provider_symbol": "VTI", "ticker": "VTI"}


audit_id: c7f8d3f5-738a-4a9c-a90f-403aa261b877
timestamp: 2026-05-15T14:32:37.918201+00:00
source: instrument_price_mapping_candidate
action: select_mapping_candidate
entity_type: instrument_price_mapping_candidate
entity_id: ipmc_f7798e27a58fb8275f36c0f5
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:32:37.918201+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:32:37.918201+00:00
new_values_json:
  {"instrument_id": "instrument-US9229087690", "mapping_id": "ipm_971a1108ea37c7efb9dc03fa", "provider": "openfigi", "provider_symbol": "VTI"}


audit_id: 27a0b21c-680c-46be-88a9-b965b1c0d19b
timestamp: 2026-05-15T15:06:31.341449+00:00
source: dashboard_etf_review
action: confirm_etf_mapping
entity_type: instrument_price_mapping
entity_id: ipm_82cca9f51734b1a1d04f7b7c
old_values_json: {"mapping_status": "mapped"}
confirmation_timestamp: 2026-05-15T15:06:31.341449+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T15:06:31.341449+00:00
new_values_json:
  {"instrument_id": "instrument-US9220428588", "mapping_status": "user_confirmed", "provider": "openfigi", "provider_symbol": "VWO"}


audit_id: 7b7622ab-0d2e-4dd4-b1c9-64c5a584479e
timestamp: 2026-05-15T15:06:31.341535+00:00
source: dashboard_etf_review
action: confirm_etf_mapping
entity_type: instrument_price_mapping
entity_id: ipm_8d538c9112b01f5c5131ef73
old_values_json: {"mapping_status": "mapped"}
confirmation_timestamp: 2026-05-15T15:06:31.341535+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T15:06:31.341535+00:00
new_values_json:
  {"instrument_id": "instrument-US92204A7028", "mapping_status": "user_confirmed", "provider": "openfigi", "provider_symbol": "VGT"}


audit_id: 11c70fd2-547b-4351-9196-0156e0fd847c
timestamp: 2026-05-15T15:06:31.341559+00:00
source: dashboard_etf_review
action: confirm_etf_mapping
entity_type: instrument_price_mapping
entity_id: ipm_971a1108ea37c7efb9dc03fa
old_values_json: {"mapping_status": "mapped"}
confirmation_timestamp: 2026-05-15T15:06:31.341559+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T15:06:31.341559+00:00
new_values_json:
  {"instrument_id": "instrument-US9229087690", "mapping_status": "user_confirmed", "provider": "openfigi", "provider_symbol": "VTI"}


audit_id: dab2cd83-2f98-4983-8ded-a62a67e515de
timestamp: 2026-05-15T18:57:49.752498+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_7e8d93c374f0c35921908ac1
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.752498+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.752498+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "1880.985", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
  Adjusted crypto XLSX initial snapshot import; CoinGecko ID supplied in source; legacy CHF values ignored.


audit_id: c9acfdcf-33a3-451a-93c2-903bc1161651
timestamp: 2026-05-15T18:57:49.766394+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_d65b023d3dbcbe356c9aa3d7
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.766394+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.766394+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "682.71534972", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
  Adjusted crypto XLSX initial snapshot import; CoinGecko ID supplied in source; legacy CHF values ignored.


audit_id: 88f1ea67-eecf-41be-acb0-a179ecd05805
timestamp: 2026-05-15T18:57:49.784919+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_6cf26f2b18b8e587d831ec38
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.784919+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.784919+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "1154.5285", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
  Adjusted crypto XLSX initial snapshot import; CoinGecko ID supplied in source; legacy CHF values ignored.


audit_id: c1a1dbfe-0f0c-44b7-a501-446d5df5093e
timestamp: 2026-05-15T18:57:49.811449+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_77cd2d7ae1821495dac7a96b
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.811449+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.811449+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "5815.36346", "verification_status": "verified", "wallet_id": "wallet_35a9bacb19d0e1700fa9acac"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 4bb7956b-eb2b-4912-94d1-bd1301804397
timestamp: 2026-05-15T18:57:49.825366+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_60ffed693f0df17d5db22f27
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.825366+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.825366+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "55.832925", "verification_status": "verified", "wallet_id": "wallet_716284556b6168ce643d7011"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: b3a87617-9baf-4845-a480-4eb6371fe9ac
timestamp: 2026-05-15T18:57:49.853682+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_2dad4d1d23ec4cfb92e16c4e
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.853682+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.853682+00:00
new_values_json:
  {"asset_id": "cryptoasset_807263d8e19ec0a0fbbb0aeb", "quantity": "5.36812", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: eec448c6-b468-4283-8cdf-9897e267bacc
timestamp: 2026-05-15T18:57:49.867092+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_5346f54862271fd9dc97ea03
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.867092+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.867092+00:00
new_values_json:
  {"asset_id": "cryptoasset_807263d8e19ec0a0fbbb0aeb", "quantity": "4.3783", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 62d7df76-d1c2-4291-8612-999350e13ca0
timestamp: 2026-05-15T18:57:49.894922+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_5aad8aae1d240cb73d548281
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.894922+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.894922+00:00
new_values_json:
  {"asset_id": "cryptoasset_a727b75a784d02cfe4f187cb", "quantity": "17.81559", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 359be4d7-f641-4bdb-a765-582c8a5baede
timestamp: 2026-05-15T18:57:49.921445+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_2e16e9bf655c8a908bb5d2b1
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.921445+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.921445+00:00
new_values_json:
  {"asset_id": "cryptoasset_56e929b006b6354055e5d334", "quantity": "107.19552", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 1deb88e4-9357-4b3f-8a75-2757d24f8312
timestamp: 2026-05-15T18:57:49.947568+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8325b0d67bee03191c4a46fd
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.947568+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.947568+00:00
new_values_json:
  {"asset_id": "cryptoasset_5d8c0c9249eb4e443ee38d22", "quantity": "2561.2647", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 0381babc-853a-49f6-aabe-c833fc988bc7
timestamp: 2026-05-15T18:57:49.973864+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_acacba0cbeb2a92637718fa5
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.973864+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.973864+00:00
new_values_json:
  {"asset_id": "cryptoasset_b45590d11f42f55b673bf50f", "quantity": "1.9030286", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: e0fcc939-488c-4970-9bb5-1db18bf6ccf3
timestamp: 2026-05-15T18:57:49.986971+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1b6e8b602bef4f2915d73921
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.986971+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.986971+00:00
new_values_json:
  {"asset_id": "cryptoasset_b45590d11f42f55b673bf50f", "quantity": "0.5745352", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 5499d4df-bdf6-4c15-a715-9f7d146208e2
timestamp: 2026-05-15T18:57:49.999797+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_3b9ca31d40e4d62a59d848b5
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.999797+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.999797+00:00
new_values_json:
  {"asset_id": "cryptoasset_b45590d11f42f55b673bf50f", "quantity": "0.0202", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: d4319f85-3247-417e-9ce2-e540af9fa7f2
timestamp: 2026-05-15T18:57:50.025135+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_360e1468acb72d9f37330278
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.025135+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.025135+00:00
new_values_json:
  {"asset_id": "cryptoasset_2c03aef2ab39bb3ca9f759a7", "quantity": "0.12093431", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 7f8ecace-0717-4175-9e5d-e2626b58d76c
timestamp: 2026-05-15T18:57:50.061244+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8e4f091808561c18ec8879e4
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.061244+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.061244+00:00
new_values_json:
  {"asset_id": "cryptoasset_8335d0d6289e5d1dc68f51ba", "quantity": "1577.231877", "verification_status": "verified", "wallet_id": "wallet_2585cfa4e17d282a4938e4da"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 91def075-6e1f-437c-b0fe-6506b3375f49
timestamp: 2026-05-15T18:57:50.087447+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_90e6266973c5369fb88101df
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.087447+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.087447+00:00
new_values_json:
  {"asset_id": "cryptoasset_0b2a8d03cd5938dff10f2013", "quantity": "18.17779207", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 4023754a-718a-403c-b9f8-e12bd667fe20
timestamp: 2026-05-15T18:57:50.112763+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_199b4ecb61491bb0d7cddc33
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.112763+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.112763+00:00
new_values_json:
  {"asset_id": "cryptoasset_05ee5eb8c1ed2feadd0e2e90", "quantity": "315242.120103", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 34ac5802-f6fa-4602-880c-af7510d1ec8f
timestamp: 2026-05-15T18:57:50.137109+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1049d676d5ca95dcd1f7b170
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.137109+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.137109+00:00
new_values_json:
  {"asset_id": "cryptoasset_d9985b5dfe30ebb162d7e96b", "quantity": "202.20374053", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 47689325-8ad7-40e8-a1e6-825edd8f0098
timestamp: 2026-05-15T18:57:50.162585+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_dc7e90078e9a40c8e4ba26b3
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.162585+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.162585+00:00
new_values_json:
  {"asset_id": "cryptoasset_0fed5d47a2a5afddd52aeb3e", "quantity": "181.53426042", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 5d3ea5ca-66f4-4ebf-8c7b-758a468da725
timestamp: 2026-05-15T18:57:50.187463+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_42a243fc06025b3a255ef9c7
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.187463+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.187463+00:00
new_values_json:
  {"asset_id": "cryptoasset_27330d9a896ad4e3997c7503", "quantity": "209.09636964", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 9044db03-142e-4827-a084-6eaa86d97b66
timestamp: 2026-05-15T18:57:50.213668+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_0fd3d8e28c3f7f26232052b6
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.213668+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.213668+00:00
new_values_json:
  {"asset_id": "cryptoasset_bb516ab97b3ea319050f47df", "quantity": "899.38006", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 629dfe9b-c642-4cb5-92c5-1da80dbe7c64
timestamp: 2026-05-15T18:57:50.243207+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_4ffa8dc5cf833dbefe7a343b
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.243207+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.243207+00:00
new_values_json:
  {"asset_id": "cryptoasset_6feea8115f112302b2aa2ffa", "quantity": "1758.455617", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: a8bf9491-dc11-4fb8-b744-e2ada07f8f7d
timestamp: 2026-05-15T18:57:50.260369+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_d0c71206d063c98787b43930
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.260369+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.260369+00:00
new_values_json:
  {"asset_id": "cryptoasset_6feea8115f112302b2aa2ffa", "quantity": "740.813", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 199a63b2-20df-4f6b-a13e-df4e9b75d9bf
timestamp: 2026-05-15T18:57:50.294938+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_e13d03f4a7014b85c19f6fea
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.294938+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.294938+00:00
new_values_json:
  {"asset_id": "cryptoasset_6337d2b8583a17d376482b10", "quantity": "32.7346", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 1b1c0a85-417f-4375-b9f0-60d8a743ec6e
timestamp: 2026-05-15T18:57:50.312609+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8fc7297417655b1ff25aa9c6
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.312609+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.312609+00:00
new_values_json:
  {"asset_id": "cryptoasset_6337d2b8583a17d376482b10", "quantity": "7.390202", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: c7bc862a-36eb-4432-b98b-20a6f9588315
timestamp: 2026-05-15T18:57:50.346444+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_705b5da9462bcfca30017e19
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.346444+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.346444+00:00
new_values_json:
  {"asset_id": "cryptoasset_3cf5dec425d368f2b3d9e51b", "quantity": "6578.9473", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 3622e2eb-2406-458d-8f0e-3019f2b0db27
timestamp: 2026-05-15T18:57:50.380618+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_e62ab830dee435091e941729
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.380618+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.380618+00:00
new_values_json:
  {"asset_id": "cryptoasset_35fe9e3f11f68f0fd1120aa5", "quantity": "252.93264", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: ae77f391-6ccc-48ab-945e-67f9096a2ca0
timestamp: 2026-05-15T18:57:50.415987+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_84faadac6090ff25b6a43d57
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.415987+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.415987+00:00
new_values_json:
  {"asset_id": "cryptoasset_294c17ec1bc5d1cd4bad64d6", "quantity": "1.78458869", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 09e903bc-43c2-444f-839f-37c6e6c378df
timestamp: 2026-05-15T18:57:50.453229+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_0384fe07daa828e2a5887074
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.453229+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.453229+00:00
new_values_json:
  {"asset_id": "cryptoasset_d3ec9163a002d626e9e0fda0", "quantity": "748.37630822", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 2ed5bf78-323a-4345-97ac-5f2c56cf997e
timestamp: 2026-05-15T18:57:50.489387+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_b2d23f8639289d7b3d644d47
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.489387+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.489387+00:00
new_values_json:
  {"asset_id": "cryptoasset_fdfe1108bb188b2a2302fda8", "quantity": "111.879892", "verification_status": "verified", "wallet_id": "wallet_35a9bacb19d0e1700fa9acac"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


# transactions

transaction_id: tx-0870b5b9-0c4e-4ffb-94b5-4eef18009b99
transaction_type: initial_position_snapshot
account_id: true-wealth-review-brokerage
instrument_id: instrument-US9229087690
trade_date: 2026-05-14
settlement_date: 2026-05-14
quantity: 128
price_original: 364.71
currency_original: USD
fx_source: missing_in_source
fx_status: missing
gross_amount_chf: 36482.67
source_type: broker_import_reviewed_snapshot
source_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
external_transaction_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
row_hash: d91dcdb723e0725fc4d721d2c3083d3609a33c1bd04c191d3d548fbfaa55d38a
quality_status: warning
created_at: 2026-05-15T10:21:23.938094+00:00
updated_at: 2026-05-15T10:21:23.938094+00:00
notes:
  Initial Snapshot from reviewed True Wealth dry-run execution plan; cost basis/FX incomplete; no positions_snapshot direct write.


# 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


