Database Explorer

{
  "dossier_id": "072c00fd-f5a5-461f-976c-c56b403d36b8",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Berge, Nicole van den (N)",
      "adres": "Blokfluitstraat 18",
      "email": "[email]",
      "postcode": "1312 NX",
      "woonplaats": "ALMERE",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Holdorp, Ramon (R.E.)",
      "adres": "Blokfluitstraat 18",
      "email": "[email]",
      "postcode": "1312 NX",
      "woonplaats": "ALMERE"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-08-30"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2430196",
          "passeeringangsdatum": "2017-07-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "80566.00",
          "status": "Lopend",
          "artikel": "bijBouwe Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "bijBouwe Annuiteitenhypotheek",
          "maatschappij": "bijBouwe",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3027521-03",
          "passeeringangsdatum": "2021-02-01"
        }
      ],
      "crmdossier_id": "152357",
      "dossiernummer": "152357",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7e9fa2d0-3038-41dd-b4c1-05044492ee5b",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 27 48",
    "klant": "Kolsteeg, Diana (D.A)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 MR",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "124500.00",
        "status": "Gepasseerd",
        "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2840917",
        "passeeringangsdatum": "2016-02-12"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Hypotheek Opvang Polis - AO",
        "tekendatum": "25569",
        "productnaam": "Hypotheek Opvang Polis - AO",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "H112158",
        "passeeringangsdatum": "2015-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Pakket",
        "tekendatum": "25569",
        "productnaam": "Pakket",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Pakket",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2001-01-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Allianz Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Allianz Overlijdensrisicoverzekering",
        "maatschappij": "Allianz",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-51",
        "passeeringangsdatum": "2015-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "138310205385",
        "passeeringangsdatum": "2016-02-12"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 7,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "100541",
      "Kolsteeg, Diana (D.A)",
      "Horst 27 48",
      "8225 MR",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2840917",
      "Argenta (via Adaxio)",
      "Hypotheek",
      "Annuïteitenhypotheek (Argenta Hypotheek)",
      "Annuitair",
      "H112158",
      "Cardif",
      "Inkomensverzekering",
      "Hypotheek Opvang Polis - AO",
      "Woonlastenverzekering",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "Voogd & Voogd",
      "Pakket",
      "[telefoon]-51",
      "Allianz",
      "Levensverzekering",
      "Allianz Overlijdensrisicoverzekering",
      "Overlijdensrisicoverzekering",
      "138310205385",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "100541",
    "dossiernummer": "100541",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5614d077-71b4-468d-8165-769add9a4ae9",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kewalbansing - Awadpersad (R.G.)",
      "adres": "Kogge 11 74",
      "email": "[email]",
      "postcode": "8243 AC",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kewalbansing, Anil (A.)",
      "adres": "Kogge 11 74",
      "postcode": "8243 AC",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "53509.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "HollandWoont Annuitair",
          "tekendatum": "25569",
          "productnaam": "HollandWoont Annuitair",
          "maatschappij": "HollandWoont",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3250885",
          "passeeringangsdatum": "2025-12-01"
        }
      ],
      "crmdossier_id": "293630",
      "dossiernummer": "293630",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "072c00fd-f5a5-461f-976c-c56b403d36b8",
  "key": "base_import",
  "value_json": {
    "adres": "Blokfluitstraat 18",
    "klant": "Berge, Nicole van den (N), Holdorp, Ramon (R.E.)",
    "plaats": "ALMERE",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1312 NX",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-08-30"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2430196",
        "passeeringangsdatum": "2017-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "80566.00",
        "status": "Lopend",
        "artikel": "bijBouwe Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "bijBouwe Annuiteitenhypotheek",
        "maatschappij": "bijBouwe",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3027521-03",
        "passeeringangsdatum": "2021-02-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "152357",
      "Berge, Nicole van den (N), Holdorp, Ramon (R.E.)",
      "Blokfluitstraat 18",
      "1312 NX",
      "ALMERE",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2430196",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "3027521-03",
      "bijBouwe",
      "Hypotheek",
      "bijBouwe Annuiteitenhypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "152357",
    "dossiernummer": "152357",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "91a56b7f-21f2-4692-8092-9e1fd7c1b644",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Azemi (Q.)",
      "adres": "Kogge 11 10",
      "email": "[email]",
      "postcode": "8243 AC",
      "woonplaats": "Lelystad",
      "telefoon_prive": "*********"
    },
    "a2": {
      "adres": "Kogge 11 10",
      "postcode": "8243 AC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV.407970",
          "passeeringangsdatum": "2013-03-15"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "187727.00",
          "status": "Lopend",
          "artikel": "Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3212194-01",
          "passeeringangsdatum": "2020-10-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-11-02"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-BF6DDF9E-8655-49BA-AB58-603535946482|1065(1)",
          "passeeringangsdatum": "2020-12-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-05-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Opstal",
          "factuurbedrag": "",
          "offertenummer": "111851005385",
          "passeeringangsdatum": "2013-05-23"
        }
      ],
      "crmdossier_id": "97178",
      "dossiernummer": "97178",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "91a56b7f-21f2-4692-8092-9e1fd7c1b644",
  "key": "base_import",
  "value_json": {
    "adres": "Kogge 11 10",
    "klant": "Azemi (Q.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 AC",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV.407970",
        "passeeringangsdatum": "2013-03-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "187727.00",
        "status": "Lopend",
        "artikel": "Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt)",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt)",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3212194-01",
        "passeeringangsdatum": "2020-10-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-11-02"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-BF6DDF9E-8655-49BA-AB58-603535946482|1065(1)",
        "passeeringangsdatum": "2020-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-05-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Opstal",
        "factuurbedrag": "",
        "offertenummer": "111851005385",
        "passeeringangsdatum": "2013-05-23"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "97178",
      "Azemi (Q.)",
      "Kogge 11 10",
      "8243 AC",
      "Lelystad",
      "[email]",
      "*********",
      "GINV.407970",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen",
      "3212194-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-BF6DDF9E-8655-49BA-AB58-603535946482|1065(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Aansprakelijkheid",
      "Aansprakelijkheid, Opstal",
      "111851005385",
      "Voogd & Voogd",
      "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "97178",
    "dossiernummer": "97178",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "*********",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5172c8e0-89a2-4a88-a129-3a684120bd66",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Buddenberg, Lisa (L)",
      "adres": "Laurence Olivierstraat 8",
      "email": "[email]",
      "postcode": "1325 KC",
      "woonplaats": "Almere",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Laurence Olivierstraat 8",
      "postcode": "1325 KC",
      "woonplaats": "Almere"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-06-28"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "40021760",
          "passeeringangsdatum": "2017-10-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2431678",
          "passeeringangsdatum": "2017-08-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "126200.00",
          "status": "Gepasseerd",
          "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "maatschappij": "ASN (voorheen BLG Wonen)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "10244051",
          "passeeringangsdatum": "2017-08-28"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel",
          "factuurbedrag": "",
          "offertenummer": "160971835385",
          "passeeringangsdatum": "2017-08-28"
        }
      ],
      "crmdossier_id": "153597",
      "dossiernummer": "153597",
      "dossierstatus": "Geroyeerd",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5172c8e0-89a2-4a88-a129-3a684120bd66",
  "key": "base_import",
  "value_json": {
    "adres": "Laurence Olivierstraat 8",
    "klant": "Buddenberg, Lisa (L)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1325 KC",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-06-28"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "40021760",
        "passeeringangsdatum": "2017-10-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2431678",
        "passeeringangsdatum": "2017-08-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "126200.00",
        "status": "Gepasseerd",
        "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "maatschappij": "ASN (voorheen BLG Wonen)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "10244051",
        "passeeringangsdatum": "2017-08-28"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "tekendatum": "25569",
        "productnaam": "Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel",
        "factuurbedrag": "",
        "offertenummer": "160971835385",
        "passeeringangsdatum": "2017-08-28"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "153597",
      "Buddenberg, Lisa (L)",
      "Laurence Olivierstraat 8",
      "1325 KC",
      "Almere",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "40021760",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "2431678",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "10244051",
      "ASN (voorheen BLG Wonen)",
      "Hypotheek",
      "BLG Annuïteitenhypotheek (BLG Hypotheek)",
      "Annuitair",
      "160971835385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
      "Aansprakelijkheid, Inboedel"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "153597",
    "dossiernummer": "153597",
    "dossierstatus": "Geroyeerd",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5a441e2b-889d-4141-8d99-72c9f8921744",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Haasteren, Jim van (J)",
      "adres": "Horst 27 43",
      "email": "[email]",
      "postcode": "8225 MS",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Horst 27 43",
      "postcode": "8225 MS",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-84",
          "passeeringangsdatum": "2016-06-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "121000.00",
          "status": "Gepasseerd",
          "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "maatschappij": "Argenta (via Adaxio)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2864952",
          "passeeringangsdatum": "2016-06-15"
        }
      ],
      "crmdossier_id": "122413",
      "dossiernummer": "122413",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5a441e2b-889d-4141-8d99-72c9f8921744",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 27 43",
    "klant": "Haasteren, Jim van (J)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 MS",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-84",
        "passeeringangsdatum": "2016-06-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "121000.00",
        "status": "Gepasseerd",
        "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2864952",
        "passeeringangsdatum": "2016-06-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "122413",
      "Haasteren, Jim van (J)",
      "Horst 27 43",
      "8225 MS",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "[telefoon]-84",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "2864952",
      "Argenta (via Adaxio)",
      "Hypotheek",
      "Annuïteitenhypotheek (Argenta Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "122413",
    "dossiernummer": "122413",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "2850b95e-4807-4b41-b4a3-61b55c01f5b7",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Woznica, Bartlomiej (B)",
      "adres": "Schoener 35 17",
      "email": "[email]",
      "postcode": "8243 WK",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Schoener 35 17",
      "postcode": "8243 WK",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-12-05"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-36",
          "passeeringangsdatum": "2016-11-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "122700.00",
          "status": "Gepasseerd",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2902321",
          "passeeringangsdatum": "2016-12-23"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "17694.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "237.507.000",
          "passeeringangsdatum": "2016-12-23"
        }
      ],
      "crmdossier_id": "134372",
      "dossiernummer": "134372",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "2850b95e-4807-4b41-b4a3-61b55c01f5b7",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 35 17",
    "klant": "Woznica, Bartlomiej (B)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 WK",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-12-05"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-36",
        "passeeringangsdatum": "2016-11-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "122700.00",
        "status": "Gepasseerd",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2902321",
        "passeeringangsdatum": "2016-12-23"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "17694.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "237.507.000",
        "passeeringangsdatum": "2016-12-23"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "134372",
      "Woznica, Bartlomiej (B)",
      "Schoener 35 17",
      "8243 WK",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "[telefoon]-36",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "2902321",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair",
      "237.507.000",
      "SVn",
      "Starterslening"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "134372",
    "dossiernummer": "134372",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ed423f18-5b15-4fe6-a6be-3bdf08091888",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Lanting (E.)",
      "adres": "Harpstraat 52",
      "email": "[email]",
      "postcode": "1544 WL",
      "woonplaats": "Zaandijk",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Harpstraat 52",
      "postcode": "1544 WL",
      "woonplaats": "Zaandijk"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-03-09"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2021-02-16",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-02-16"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Financiële Planning",
          "tekendatum": "2021-02-16",
          "productnaam": "Financiële Planning",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-02-16"
        }
      ],
      "crmdossier_id": "155452",
      "dossiernummer": "155452",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5614d077-71b4-468d-8165-769add9a4ae9",
  "key": "base_import",
  "value_json": {
    "adres": "Kogge 11 74",
    "klant": "Kewalbansing - Awadpersad (R.G.), Kewalbansing, Anil (A.)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 AC",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "53509.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "HollandWoont Annuitair",
        "tekendatum": "25569",
        "productnaam": "HollandWoont Annuitair",
        "maatschappij": "HollandWoont",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3250885",
        "passeeringangsdatum": "2025-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "293630",
      "Kewalbansing - Awadpersad (R.G.), Kewalbansing, Anil (A.)",
      "Kogge 11 74",
      "8243 AC",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "3250885",
      "HollandWoont",
      "Hypotheek",
      "HollandWoont Annuitair",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "293630",
    "dossiernummer": "293630",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ed423f18-5b15-4fe6-a6be-3bdf08091888",
  "key": "base_import",
  "value_json": {
    "adres": "Harpstraat 52",
    "klant": "Lanting (E.)",
    "plaats": "Zaandijk",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1544 WL",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-03-09"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2021-02-16",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-02-16"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Financiële Planning",
        "tekendatum": "2021-02-16",
        "productnaam": "Financiële Planning",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-02-16"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "155452",
      "Lanting (E.)",
      "Harpstraat 52",
      "1544 WL",
      "Zaandijk",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij",
      "Financiële Planning"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "155452",
    "dossiernummer": "155452",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ebd95e4b-7eab-46e9-bf94-659aa219a3cc",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Matthijs, Yara (Y)",
      "adres": "Horst 1409",
      "email": "[email]",
      "postcode": "8225 LG",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Schrederhof (R)",
      "adres": "Horst 1409",
      "email": "[email]",
      "postcode": "8225 LG",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Interbank Persoonlijke Lening",
          "tekendatum": "25569",
          "productnaam": "Interbank Persoonlijke Lening",
          "maatschappij": "InterBank NV",
          "productsoort": "Persoonlijke lening",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-02-24"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-03-07"
        }
      ],
      "crmdossier_id": "146998",
      "dossiernummer": "146998",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ebd95e4b-7eab-46e9-bf94-659aa219a3cc",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 1409",
    "klant": "Matthijs, Yara (Y), Schrederhof (R)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 LG",
    "products": [
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Interbank Persoonlijke Lening",
        "tekendatum": "25569",
        "productnaam": "Interbank Persoonlijke Lening",
        "maatschappij": "InterBank NV",
        "productsoort": "Persoonlijke lening",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-02-24"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-03-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "146998",
      "Matthijs, Yara (Y), Schrederhof (R)",
      "Horst 1409",
      "8225 LG",
      "LELYSTAD",
      "[email]",
      "[email]",
      "[telefoon]",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Persoonlijke Lening",
      "Persoonlijke lening",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "146998",
    "dossiernummer": "146998",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "b1db4f47-eeb5-4193-8c3c-a66eee99ecb6",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Tijssen (S.)",
      "adres": "Penningkruidstraat 31",
      "email": "[email]",
      "postcode": "8245 JG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Veen, Siebe van der (S)",
      "adres": "Penningkruidstraat 31",
      "postcode": "8245 JG",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "206000.00",
          "status": "Lopend",
          "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
          "tekendatum": "25569",
          "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
          "maatschappij": "ABN AMRO",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "700.277.170",
          "passeeringangsdatum": "2015-02-23"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "DK 1%",
          "tekendatum": "25569",
          "productnaam": "DK 1%",
          "maatschappij": "DEFAM B.V.",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "60148312",
          "passeeringangsdatum": "2015-01-20"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV.408846",
          "passeeringangsdatum": "2015-02-01"
        }
      ],
      "crmdossier_id": "95658",
      "dossiernummer": "95658",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d34576df-48c7-40e4-aaec-28b3d8bd0f03",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Wielenga, Ronald (R.)",
      "adres": "Enkhuizerzand 28",
      "email": "[email]",
      "postcode": "8223 ZJ",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Enkhuizerzand 28",
      "postcode": "8223 ZJ",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "25864.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "238.186.000",
          "passeeringangsdatum": "2017-05-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "101500.00",
          "status": "Gepasseerd",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.579.680",
          "passeeringangsdatum": "2017-05-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.615096",
          "passeeringangsdatum": "2016-12-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "163591.00",
          "status": "Lopend",
          "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3326156-01",
          "passeeringangsdatum": "2022-05-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-11-24"
        }
      ],
      "crmdossier_id": "133451",
      "dossiernummer": "133451",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d34576df-48c7-40e4-aaec-28b3d8bd0f03",
  "key": "base_import",
  "value_json": {
    "adres": "Enkhuizerzand 28",
    "klant": "Wielenga, Ronald (R.)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8223 ZJ",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "25864.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "238.186.000",
        "passeeringangsdatum": "2017-05-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "101500.00",
        "status": "Gepasseerd",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.579.680",
        "passeeringangsdatum": "2017-05-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.615096",
        "passeeringangsdatum": "2016-12-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "163591.00",
        "status": "Lopend",
        "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3326156-01",
        "passeeringangsdatum": "2022-05-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-11-24"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "133451",
      "Wielenga, Ronald (R.)",
      "Enkhuizerzand 28",
      "8223 ZJ",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "238.186.000",
      "SVn",
      "Hypotheek",
      "Starterslening",
      "Annuitair",
      "1.579.680",
      "Lloyds Bank",
      "Lloyds Annuiteitenhypotheek",
      "GEWI.615096",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "3326156-01",
      "Hypotrust",
      "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "133451",
    "dossiernummer": "133451",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5b1610b6-e117-4a7c-a6ba-42911bb20ad4",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Sepetci (Y.)",
      "adres": "Wold 27 07",
      "postcode": "8225 BR",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "naam": "Sepetci (G.)",
      "adres": "Wold 27 07",
      "email": "[email]",
      "postcode": "8225 BR",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Interbank Doorlopend Krediet",
          "tekendatum": "25569",
          "productnaam": "Interbank Doorlopend Krediet",
          "maatschappij": "InterBank NV",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2014-02-10"
        }
      ],
      "crmdossier_id": "95863",
      "dossiernummer": "95863",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5b1610b6-e117-4a7c-a6ba-42911bb20ad4",
  "key": "base_import",
  "value_json": {
    "adres": "Wold 27 07",
    "klant": "Sepetci (Y.), Sepetci (G.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 BR",
    "products": [
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Interbank Doorlopend Krediet",
        "tekendatum": "25569",
        "productnaam": "Interbank Doorlopend Krediet",
        "maatschappij": "InterBank NV",
        "productsoort": "Doorlopend krediet",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2014-02-10"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95863",
      "Sepetci (Y.), Sepetci (G.)",
      "Wold 27 07",
      "8225 BR",
      "Lelystad",
      "[email]",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Doorlopend Krediet",
      "Doorlopend krediet"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95863",
    "dossiernummer": "95863",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "85d7ffb3-17b2-4591-9677-e1289ef4ff98",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Leeuwen, Maarten van (M)",
      "adres": "Kogge 08 31",
      "email": "[email]",
      "postcode": "8242 AB",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Noorderijk, Eva (E.V.A.)",
      "adres": "Kogge 08 31",
      "postcode": "8242 AB",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "155792.00",
          "status": "Lopend",
          "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "maatschappij": "Argenta (via Adaxio)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2676795",
          "passeeringangsdatum": "2014-05-23"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-93",
          "passeeringangsdatum": "2014-05-01"
        }
      ],
      "crmdossier_id": "101845",
      "dossiernummer": "101845",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "85d7ffb3-17b2-4591-9677-e1289ef4ff98",
  "key": "base_import",
  "value_json": {
    "adres": "Kogge 08 31",
    "klant": "Leeuwen, Maarten van (M), Noorderijk, Eva (E.V.A.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 AB",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "155792.00",
        "status": "Lopend",
        "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2676795",
        "passeeringangsdatum": "2014-05-23"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-93",
        "passeeringangsdatum": "2014-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "101845",
      "Leeuwen, Maarten van (M), Noorderijk, Eva (E.V.A.)",
      "Kogge 08 31",
      "8242 AB",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2676795",
      "Argenta (via Adaxio)",
      "Hypotheek",
      "Annuïteitenhypotheek (Argenta Hypotheek)",
      "Annuitair",
      "[telefoon]-93",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "101845",
    "dossiernummer": "101845",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "b1db4f47-eeb5-4193-8c3c-a66eee99ecb6",
  "key": "base_import",
  "value_json": {
    "adres": "Penningkruidstraat 31",
    "klant": "Tijssen (S.), Veen, Siebe van der (S)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 JG",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "206000.00",
        "status": "Lopend",
        "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
        "tekendatum": "25569",
        "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
        "maatschappij": "ABN AMRO",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "700.277.170",
        "passeeringangsdatum": "2015-02-23"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "DK 1%",
        "tekendatum": "25569",
        "productnaam": "DK 1%",
        "maatschappij": "DEFAM B.V.",
        "productsoort": "Doorlopend krediet",
        "factuurbedrag": "",
        "offertenummer": "60148312",
        "passeeringangsdatum": "2015-01-20"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV.408846",
        "passeeringangsdatum": "2015-02-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95658",
      "Tijssen (S.), Veen, Siebe van der (S)",
      "Penningkruidstraat 31",
      "8245 JG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "700.277.170",
      "ABN AMRO",
      "Hypotheek",
      "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
      "Annuitair",
      "60148312",
      "DEFAM B.V.",
      "Consumptief krediet",
      "DK 1%",
      "Doorlopend krediet",
      "GINV.408846",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95658",
    "dossiernummer": "95658",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "03c768cb-e1f2-4605-9e8c-5eb44f672a2d",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Booms, Ashwin (A.N.)",
      "adres": "Jol 17 15",
      "email": "[email]",
      "postcode": "8243 GD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 11 02 52 35"
    },
    "a2": {
      "adres": "Jol 17 15",
      "postcode": "8243 GD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-66",
          "passeeringangsdatum": "2015-07-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "20979.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "219.960.000",
          "passeeringangsdatum": "2015-07-15"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "125672.00",
          "status": "Lopend",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2782153",
          "passeeringangsdatum": "2015-07-15"
        }
      ],
      "crmdossier_id": "95165",
      "dossiernummer": "95165",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "03c768cb-e1f2-4605-9e8c-5eb44f672a2d",
  "key": "base_import",
  "value_json": {
    "adres": "Jol 17 15",
    "klant": "Booms, Ashwin (A.N.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 GD",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-66",
        "passeeringangsdatum": "2015-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "20979.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "219.960.000",
        "passeeringangsdatum": "2015-07-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "125672.00",
        "status": "Lopend",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2782153",
        "passeeringangsdatum": "2015-07-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95165",
      "Booms, Ashwin (A.N.)",
      "Jol 17 15",
      "8243 GD",
      "Lelystad",
      "[email]",
      "06 - 11 02 52 35",
      "[telefoon]-66",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "219.960.000",
      "SVn",
      "Hypotheek",
      "Starterslening",
      "Annuitair",
      "2782153",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95165",
    "dossiernummer": "95165",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06 - 11 02 52 35",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d88d4cf8-427c-4acf-b353-3590b0c9a058",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Fikkert, Mark (MEH)",
      "adres": "Archipel 26 19",
      "email": "[email]",
      "postcode": "8224 GX",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Archipel 26 19",
      "postcode": "8224 GX",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "25440.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "239.676.000",
          "passeeringangsdatum": "2017-11-23"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2427842",
          "passeeringangsdatum": "2017-09-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-06-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "100750.00",
          "status": "Gepasseerd",
          "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "maatschappij": "ASN (voorheen BLG Wonen)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "10249303",
          "passeeringangsdatum": "2017-11-23"
        }
      ],
      "crmdossier_id": "153237",
      "dossiernummer": "153237",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d88d4cf8-427c-4acf-b353-3590b0c9a058",
  "key": "base_import",
  "value_json": {
    "adres": "Archipel 26 19",
    "klant": "Fikkert, Mark (MEH)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 GX",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "25440.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "239.676.000",
        "passeeringangsdatum": "2017-11-23"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2427842",
        "passeeringangsdatum": "2017-09-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-06-16"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "100750.00",
        "status": "Gepasseerd",
        "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "maatschappij": "ASN (voorheen BLG Wonen)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "10249303",
        "passeeringangsdatum": "2017-11-23"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "153237",
      "Fikkert, Mark (MEH)",
      "Archipel 26 19",
      "8224 GX",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "239.676.000",
      "SVn",
      "Hypotheek",
      "Starterslening",
      "Annuitair",
      "2427842",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "10249303",
      "ASN (voorheen BLG Wonen)",
      "BLG Annuïteitenhypotheek (BLG Hypotheek)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "153237",
    "dossiernummer": "153237",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "756d6d99-591b-4e08-8853-6bbea77a698c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Broek, Michel van den (MWG)",
      "adres": "Bachdreef 85",
      "email": "[email]",
      "postcode": "3845 AD",
      "woonplaats": "Harderwijk",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Bachdreef 85",
      "postcode": "3845 AD",
      "woonplaats": "Harderwijk"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2367742",
          "passeeringangsdatum": "2017-04-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "153200.00",
          "status": "Gepasseerd",
          "artikel": "Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)",
          "maatschappij": "Delta Lloyd",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.585.792",
          "passeeringangsdatum": "2017-06-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-02-14"
        }
      ],
      "crmdossier_id": "147937",
      "dossiernummer": "147937",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "756d6d99-591b-4e08-8853-6bbea77a698c",
  "key": "base_import",
  "value_json": {
    "adres": "Bachdreef 85",
    "klant": "Broek, Michel van den (MWG)",
    "plaats": "Harderwijk",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "3845 AD",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2367742",
        "passeeringangsdatum": "2017-04-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "153200.00",
        "status": "Gepasseerd",
        "artikel": "Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)",
        "maatschappij": "Delta Lloyd",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.585.792",
        "passeeringangsdatum": "2017-06-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-02-14"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "147937",
      "Broek, Michel van den (MWG)",
      "Bachdreef 85",
      "3845 AD",
      "Harderwijk",
      "[email]",
      "[telefoon]",
      "2367742",
      "TAF",
      "Levensverzekering",
      "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
      "Overlijdensrisicoverzekering",
      "1.585.792",
      "Delta Lloyd",
      "Hypotheek",
      "Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "147937",
    "dossiernummer": "147937",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "8b0a98a6-a3df-4d70-b09c-27955d79b309",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Meerbeek (K.)",
      "adres": "Botter 24 11",
      "email": "[email]",
      "postcode": "8232 KD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Botter 24 11",
      "postcode": "8232 KD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "26129.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "238.991.000",
          "passeeringangsdatum": "2017-05-25"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "92481.00",
          "status": "Gepasseerd",
          "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek)",
          "maatschappij": "Rabobank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "4002.830.644",
          "passeeringangsdatum": "2017-05-25"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-03-29"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2389046",
          "passeeringangsdatum": "2017-05-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "40024935",
          "passeeringangsdatum": "2018-04-01"
        }
      ],
      "crmdossier_id": "149959",
      "dossiernummer": "149959",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "8b0a98a6-a3df-4d70-b09c-27955d79b309",
  "key": "base_import",
  "value_json": {
    "adres": "Botter 24 11",
    "klant": "Meerbeek (K.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 KD",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "26129.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "238.991.000",
        "passeeringangsdatum": "2017-05-25"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "92481.00",
        "status": "Gepasseerd",
        "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek)",
        "maatschappij": "Rabobank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "4002.830.644",
        "passeeringangsdatum": "2017-05-25"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-03-29"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2389046",
        "passeeringangsdatum": "2017-05-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "40024935",
        "passeeringangsdatum": "2018-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "149959",
      "Meerbeek (K.)",
      "Botter 24 11",
      "8232 KD",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "238.991.000",
      "SVn",
      "Hypotheek",
      "Starterslening",
      "Annuitair",
      "4002.830.644",
      "Rabobank",
      "Annuiteiten Hypotheek (Rabo Basishypotheek)",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2389046",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "40024935",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "149959",
    "dossiernummer": "149959",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "11ac965d-cd25-4564-be06-3ab37e7439fd",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Waleniak (M.Z.)",
      "adres": "Kamp 15 71",
      "email": "[email]",
      "postcode": "8225 DA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Waleniak, Mariusz (M.Z.)",
      "adres": "Kamp 15 71",
      "email": "[email]",
      "postcode": "8225 DA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2010-04-26"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "162223.00",
          "status": "Gepasseerd",
          "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Aflossingsvrij, Bankspaar",
          "factuurbedrag": "",
          "offertenummer": "Z-090-833304",
          "passeeringangsdatum": "2010-05-27"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "maatschappij": "Dazure",
          "productsoort": "Gelijkblijvende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV. 400506",
          "passeeringangsdatum": "2010-05-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Woonlastenverzekering",
          "tekendatum": "25569",
          "productnaam": "Woonlastenverzekering",
          "maatschappij": "ING",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "IN161014824",
          "passeeringangsdatum": "2010-07-01"
        }
      ],
      "crmdossier_id": "100479",
      "dossiernummer": "100479",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "11ac965d-cd25-4564-be06-3ab37e7439fd",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 15 71",
    "klant": "Waleniak (M.Z.), Waleniak, Mariusz (M.Z.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 DA",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2010-04-26"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "162223.00",
        "status": "Gepasseerd",
        "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Aflossingsvrij, Bankspaar",
        "factuurbedrag": "",
        "offertenummer": "Z-090-833304",
        "passeeringangsdatum": "2010-05-27"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "maatschappij": "Dazure",
        "productsoort": "Gelijkblijvende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV. 400506",
        "passeeringangsdatum": "2010-05-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Woonlastenverzekering",
        "tekendatum": "25569",
        "productnaam": "Woonlastenverzekering",
        "maatschappij": "ING",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "IN161014824",
        "passeeringangsdatum": "2010-07-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "100479",
      "Waleniak (M.Z.), Waleniak, Mariusz (M.Z.)",
      "Kamp 15 71",
      "8225 DA",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Z-090-833304",
      "ING Bank",
      "Hypotheek",
      "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
      "Aflossingsvrij, Bankspaar",
      "GINV. 400506",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Gelijkblijvend",
      "Gelijkblijvende Risicoverzekeringen",
      "IN161014824",
      "ING",
      "Inkomensverzekering",
      "Woonlastenverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "100479",
    "dossiernummer": "100479",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "01effa8f-5072-4c38-9524-b1fc3a36b38f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kondziolka (P.P.)",
      "adres": "Kamp 22 05",
      "postcode": "8225 DW",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "naam": "Przyklota (M.A.)",
      "adres": "Kamp 22 05",
      "postcode": "8225 DW",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Cardif",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "O46544",
          "passeeringangsdatum": "2012-05-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "155231.00",
          "status": "Lopend",
          "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente))",
          "tekendatum": "25569",
          "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente))",
          "maatschappij": "ING Bank",
          "productsoort": "Bankspaar",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2012-06-04"
        }
      ],
      "crmdossier_id": "99949",
      "dossiernummer": "99949",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "01effa8f-5072-4c38-9524-b1fc3a36b38f",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 22 05",
    "klant": "Kondziolka (P.P.), Przyklota (M.A.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 DW",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Cardif",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "O46544",
        "passeeringangsdatum": "2012-05-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "155231.00",
        "status": "Lopend",
        "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente))",
        "tekendatum": "25569",
        "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente))",
        "maatschappij": "ING Bank",
        "productsoort": "Bankspaar",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2012-06-04"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99949",
      "Kondziolka (P.P.), Przyklota (M.A.)",
      "Kamp 22 05",
      "8225 DW",
      "Lelystad",
      "O46544",
      "Cardif",
      "Levensverzekering",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente))",
      "Bankspaar"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99949",
    "dossiernummer": "99949",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "02480e5a-2151-4dd1-b79b-a3143d26bb38",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ozbek (E.)",
      "adres": "Punter 22 09",
      "postcode": "8242 DS",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "naam": "Ozdemir (M.)",
      "adres": "Punter 22 09",
      "postcode": "8242 DS",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "155500.00",
          "status": "Gepasseerd",
          "artikel": "Argenta Spaarhypotheek (Argenta Hypotheek), Argenta Aflossingsvrij (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Spaarhypotheek (Argenta Hypotheek), Argenta Aflossingsvrij (Argenta Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Aflossingsvrij, Spaar",
          "factuurbedrag": "",
          "offertenummer": "2019297",
          "passeeringangsdatum": "2011-06-14"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]",
          "passeeringangsdatum": "2011-05-04"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "PL D",
          "tekendatum": "25569",
          "productnaam": "PL D",
          "maatschappij": "De Nederlandse Voorschotbank B.V.",
          "productsoort": "Persoonlijke lening",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2010-12-31"
        }
      ],
      "crmdossier_id": "148715",
      "dossiernummer": "148715",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "02480e5a-2151-4dd1-b79b-a3143d26bb38",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 22 09",
    "klant": "Ozbek (E.), Ozdemir (M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 DS",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "155500.00",
        "status": "Gepasseerd",
        "artikel": "Argenta Spaarhypotheek (Argenta Hypotheek), Argenta Aflossingsvrij (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Spaarhypotheek (Argenta Hypotheek), Argenta Aflossingsvrij (Argenta Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Aflossingsvrij, Spaar",
        "factuurbedrag": "",
        "offertenummer": "2019297",
        "passeeringangsdatum": "2011-06-14"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]",
        "passeeringangsdatum": "2011-05-04"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "PL D",
        "tekendatum": "25569",
        "productnaam": "PL D",
        "maatschappij": "De Nederlandse Voorschotbank B.V.",
        "productsoort": "Persoonlijke lening",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2010-12-31"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "148715",
      "Ozbek (E.), Ozdemir (M.)",
      "Punter 22 09",
      "8242 DS",
      "Lelystad",
      "2019297",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Spaarhypotheek (Argenta Hypotheek), Argenta Aflossingsvrij (Argenta Hypotheek)",
      "Aflossingsvrij, Spaar",
      "[telefoon]",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "*********",
      "De Nederlandse Voorschotbank B.V.",
      "Consumptief krediet",
      "PL D",
      "Persoonlijke lening"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "148715",
    "dossiernummer": "148715",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "58d266ef-3cf2-421f-92bf-af6197f0c2f3",
  "key": "base_import",
  "value_json": {
    "adres": "Schouw 38 01",
    "klant": "Gumus , Mustafa (M)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 AC",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Brand New Day",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "528.321.65",
        "passeeringangsdatum": "2014-03-01"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "CRV DK standaard excl ord",
        "tekendatum": "25569",
        "productnaam": "CRV DK standaard excl ord",
        "maatschappij": "Credivance N.V.",
        "productsoort": "Doorlopend krediet",
        "factuurbedrag": "",
        "offertenummer": "60407165",
        "passeeringangsdatum": "2016-05-24"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "130000.00",
        "status": "Lopend",
        "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2670702/1",
        "passeeringangsdatum": "2014-04-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95113",
      "Gumus , Mustafa (M)",
      "Schouw 38 01",
      "8232 AC",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "528.321.65",
      "Brand New Day",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "60407165",
      "Credivance N.V.",
      "Consumptief krediet",
      "CRV DK standaard excl ord",
      "Doorlopend krediet",
      "2670702/1",
      "Argenta (via Adaxio)",
      "Hypotheek",
      "Annuïteitenhypotheek (Argenta Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95113",
    "dossiernummer": "95113",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "04367582-5a7f-4829-ba8f-41e4fe5733c7",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "De Pan , Maria (M.M.W.)",
      "adres": "Botter 26 14",
      "email": "[email]",
      "postcode": "8232 KE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Meyer, Michel (M)",
      "adres": "Botter 26 14",
      "postcode": "8232 KE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "164320.00",
          "status": "Gepasseerd",
          "artikel": "NIBC Extra Annuiteit",
          "tekendatum": "25569",
          "productnaam": "NIBC Extra Annuiteit",
          "maatschappij": "NIBC",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.332.832",
          "passeeringangsdatum": "2014-07-15"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Brand New Day",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "529.922.20",
          "passeeringangsdatum": "2014-05-23"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Hypotheek Opvang Polis - AO",
          "tekendatum": "25569",
          "productnaam": "Hypotheek Opvang Polis - AO",
          "maatschappij": "Cardif",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "H90693",
          "passeeringangsdatum": "2014-08-15"
        }
      ],
      "crmdossier_id": "95121",
      "dossiernummer": "95121",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "04367582-5a7f-4829-ba8f-41e4fe5733c7",
  "key": "base_import",
  "value_json": {
    "adres": "Botter 26 14",
    "klant": "De Pan , Maria (M.M.W.), Meyer, Michel (M)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 KE",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "164320.00",
        "status": "Gepasseerd",
        "artikel": "NIBC Extra Annuiteit",
        "tekendatum": "25569",
        "productnaam": "NIBC Extra Annuiteit",
        "maatschappij": "NIBC",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.332.832",
        "passeeringangsdatum": "2014-07-15"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Brand New Day",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "529.922.20",
        "passeeringangsdatum": "2014-05-23"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Hypotheek Opvang Polis - AO",
        "tekendatum": "25569",
        "productnaam": "Hypotheek Opvang Polis - AO",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "H90693",
        "passeeringangsdatum": "2014-08-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95121",
      "De Pan , Maria (M.M.W.), Meyer, Michel (M)",
      "Botter 26 14",
      "8232 KE",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "1.332.832",
      "NIBC",
      "Hypotheek",
      "NIBC Extra Annuiteit",
      "Annuitair",
      "529.922.20",
      "Brand New Day",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "H90693",
      "Cardif",
      "Inkomensverzekering",
      "Hypotheek Opvang Polis - AO",
      "Woonlastenverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95121",
    "dossiernummer": "95121",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "84543347-971b-4cf2-8b79-04f927782687",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kolfschoten, Jan-Willem van (JW)",
      "adres": "De Stelling 10 41",
      "email": "[email]",
      "postcode": "8232 EA",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Stelling 10 41",
      "postcode": "8232 EA",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "122500.00",
          "status": "Gepasseerd",
          "artikel": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2017-06-14"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-05-11"
        }
      ],
      "crmdossier_id": "151927",
      "dossiernummer": "151927",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "84543347-971b-4cf2-8b79-04f927782687",
  "key": "base_import",
  "value_json": {
    "adres": "De Stelling 10 41",
    "klant": "Kolfschoten, Jan-Willem van (JW)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 EA",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "122500.00",
        "status": "Gepasseerd",
        "artikel": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2017-06-14"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-05-11"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "151927",
      "Kolfschoten, Jan-Willem van (JW)",
      "De Stelling 10 41",
      "8232 EA",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Aflossingsvrij, Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "151927",
    "dossiernummer": "151927",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "58d266ef-3cf2-421f-92bf-af6197f0c2f3",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gumus , Mustafa (M)",
      "adres": "Schouw 38 01",
      "email": "[email]",
      "postcode": "8232 AC",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Schouw 38 01",
      "postcode": "8232 AC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Brand New Day",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "528.321.65",
          "passeeringangsdatum": "2014-03-01"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "CRV DK standaard excl ord",
          "tekendatum": "25569",
          "productnaam": "CRV DK standaard excl ord",
          "maatschappij": "Credivance N.V.",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "60407165",
          "passeeringangsdatum": "2016-05-24"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "130000.00",
          "status": "Lopend",
          "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "maatschappij": "Argenta (via Adaxio)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2670702/1",
          "passeeringangsdatum": "2014-04-15"
        }
      ],
      "crmdossier_id": "95113",
      "dossiernummer": "95113",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "359a3a33-7c54-40fc-bd1b-2478bd886a8d",
  "key": "base_import",
  "value_json": {
    "adres": "Neringpassage 168",
    "klant": "Chen, Xiao (X.C.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 JR",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Woonlastenverzekering",
        "tekendatum": "25569",
        "productnaam": "Credit Life Woonlastenverzekering",
        "maatschappij": "Credit Life",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "5001110493",
        "passeeringangsdatum": "2017-01-23"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "134334.00",
        "status": "Gepasseerd",
        "artikel": "Munt Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Munt Annuïteiten Hypotheek",
        "maatschappij": "Munt Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.490.440",
        "passeeringangsdatum": "2016-10-27"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Woonlastenverzekering",
        "tekendatum": "25569",
        "productnaam": "Credit Life Woonlastenverzekering",
        "maatschappij": "Credit Life",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "5001110495",
        "passeeringangsdatum": "2017-01-23"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.614242",
        "passeeringangsdatum": "2016-10-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-09-20"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "131809",
      "Chen, Xiao (X.C.)",
      "Neringpassage 168",
      "8224 JR",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "5001110493",
      "Credit Life",
      "Inkomensverzekering",
      "Credit Life Woonlastenverzekering",
      "Woonlastenverzekering",
      "1.490.440",
      "Munt Hypotheken",
      "Hypotheek",
      "Munt Annuïteiten Hypotheek",
      "Annuitair",
      "5001110495",
      "GEWI.614242",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "131809",
    "dossiernummer": "131809",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e24e9f45-7a34-4177-b7cc-edb11f2f0a98",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Geloof , Esther van 't (E.P.)",
      "adres": "Kamp 14 3",
      "email": "[email]",
      "postcode": "8225 GD",
      "woonplaats": "LELYSTAD"
    },
    "a2": {
      "adres": "Kamp 14 3",
      "postcode": "8225 GD",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "197970.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2021-10-08"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "215106.00",
          "status": "Gepasseerd",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2019-03-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-11-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "40030193",
          "passeeringangsdatum": "2019-03-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "40030275",
          "passeeringangsdatum": "2019-03-01"
        }
      ],
      "crmdossier_id": "180815",
      "dossiernummer": "180815",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e24e9f45-7a34-4177-b7cc-edb11f2f0a98",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 14 3",
    "klant": "Geloof , Esther van 't (E.P.)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 GD",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "197970.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2021-10-08"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "215106.00",
        "status": "Gepasseerd",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2019-03-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-11-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "40030193",
        "passeeringangsdatum": "2019-03-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "40030275",
        "passeeringangsdatum": "2019-03-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "180815",
      "Geloof , Esther van 't (E.P.)",
      "Kamp 14 3",
      "8225 GD",
      "LELYSTAD",
      "[email]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "*********",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Eigen kantoor",
      "Hypotheekadvies",
      "40030193",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "40030275"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "180815",
    "dossiernummer": "180815",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "48491420-9637-44f3-a99f-1f30a21b8f89",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kleijn, Theo de (T.G.)",
      "adres": "Horst 38 28",
      "email": "[email]",
      "postcode": "8225 NM",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Horst 38 28",
      "postcode": "8225 NM",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-07-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-04-22"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "149693.00",
          "status": "Gepasseerd",
          "artikel": "Argenta Aflossingsvrij (Argenta Hypotheek), Argenta Spaarhypotheek (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Aflossingsvrij (Argenta Hypotheek), Argenta Spaarhypotheek (Argenta Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Aflossingsvrij, Spaar",
          "factuurbedrag": "",
          "offertenummer": "2019307",
          "passeeringangsdatum": "2011-06-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-91",
          "passeeringangsdatum": "2011-05-23"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "134184075385",
          "passeeringangsdatum": "2015-07-29"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-07-01"
        }
      ],
      "crmdossier_id": "99011",
      "dossiernummer": "99011",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "48491420-9637-44f3-a99f-1f30a21b8f89",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 38 28",
    "klant": "Kleijn, Theo de (T.G.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 NM",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-07-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-04-22"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "149693.00",
        "status": "Gepasseerd",
        "artikel": "Argenta Aflossingsvrij (Argenta Hypotheek), Argenta Spaarhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Aflossingsvrij (Argenta Hypotheek), Argenta Spaarhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Aflossingsvrij, Spaar",
        "factuurbedrag": "",
        "offertenummer": "2019307",
        "passeeringangsdatum": "2011-06-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-91",
        "passeeringangsdatum": "2011-05-23"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "134184075385",
        "passeeringangsdatum": "2015-07-29"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-07-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99011",
      "Kleijn, Theo de (T.G.)",
      "Horst 38 28",
      "8225 NM",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2019307",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Aflossingsvrij (Argenta Hypotheek), Argenta Spaarhypotheek (Argenta Hypotheek)",
      "Aflossingsvrij, Spaar",
      "[telefoon]-91",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "134184075385",
      "Voogd & Voogd",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99011",
    "dossiernummer": "99011",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}