Database Explorer

{
  "dossier_id": "3a14f96f-c54e-4e17-b3b9-368e5058a428",
  "key": "base_import",
  "value_json": {
    "adres": "Merenlaan 56",
    "klant": "Bottse, Robin (RRE), Frans, Abigal (AXQ)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 JB",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-745523EA-2E00-4A7B-9E1C-97205623430C|742(2)",
        "passeeringangsdatum": "2017-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-11-17"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag in behandeling",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-745523EA-2E00-4A7B-9E1C-97205623430C|742(1)",
        "passeeringangsdatum": "2017-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "159769",
      "Bottse, Robin (RRE), Frans, Abigal (AXQ)",
      "Merenlaan 56",
      "8226 JB",
      "LELYSTAD",
      "[email]",
      "06216080456",
      "ISW-745523EA-2E00-4A7B-9E1C-97205623430C|742(2)",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-745523EA-2E00-4A7B-9E1C-97205623430C|742(1)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "159769",
    "dossiernummer": "159769",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "06216080456",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e1f6c8c8-84d1-4932-9aea-317bd65d99d9",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Stadig, Niels (N)",
      "adres": "Grasmeent 100",
      "email": "[email]",
      "postcode": "1357 JM",
      "woonplaats": "Almere",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Zonnenberg, Diana (D)",
      "adres": "Grasmeent 100",
      "email": "[email]",
      "postcode": "1357 JM",
      "woonplaats": "Almere"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "280125.00",
          "status": "Gepasseerd",
          "artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek, Merius annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek, Merius annuiteitenhypotheek",
          "maatschappij": "Merius Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3004826",
          "passeeringangsdatum": "2018-04-13"
        },
        {
          "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": "2492418",
          "passeeringangsdatum": "2018-02-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-10-26"
        }
      ],
      "crmdossier_id": "159108",
      "dossiernummer": "159108",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "739fd492-a6d6-49a4-a9dc-0c674ed7151f",
  "key": "base_import",
  "value_json": {
    "adres": "Schouw 15 54",
    "klant": "Kampman, Tessa (T.E.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 ZJ",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "maatschappij": "Credit Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "7001094393",
        "passeeringangsdatum": "2016-10-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "133000.00",
        "status": "Gepasseerd",
        "artikel": "bijBouwe Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "bijBouwe Annuiteitenhypotheek",
        "maatschappij": "bijBouwe",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2883733",
        "passeeringangsdatum": "2016-09-30"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "127922",
      "Kampman, Tessa (T.E.)",
      "Schouw 15 54",
      "8232 ZJ",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "7001094393",
      "Credit Life",
      "Levensverzekering",
      "Credit Life Overlijdensrisicoverzekering Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "2883733",
      "bijBouwe",
      "Hypotheek",
      "bijBouwe Annuiteitenhypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "127922",
    "dossiernummer": "127922",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "739fd492-a6d6-49a4-a9dc-0c674ed7151f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kampman, Tessa (T.E.)",
      "adres": "Schouw 15 54",
      "email": "[email]",
      "postcode": "8232 ZJ",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Schouw 15 54",
      "postcode": "8232 ZJ",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "maatschappij": "Credit Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "7001094393",
          "passeeringangsdatum": "2016-10-15"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "133000.00",
          "status": "Gepasseerd",
          "artikel": "bijBouwe Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "bijBouwe Annuiteitenhypotheek",
          "maatschappij": "bijBouwe",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2883733",
          "passeeringangsdatum": "2016-09-30"
        }
      ],
      "crmdossier_id": "127922",
      "dossiernummer": "127922",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f603d0e0-44eb-4b0f-86a2-49fce894f453",
  "key": "base_import",
  "value_json": {
    "adres": "Kempenaar 12 43",
    "klant": "Kilicarslan-Serin, Serkan (O), Serin, Serkan (S)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 VN",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "ISW-DFD15E8F-E876-41F2-85DE-26AE4997A67B(1)",
        "passeeringangsdatum": "2016-11-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "134174",
      "Kilicarslan-Serin, Serkan (O), Serin, Serkan (S)",
      "Kempenaar 12 43",
      "8231 VN",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "ISW-DFD15E8F-E876-41F2-85DE-26AE4997A67B(1)",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "134174",
    "dossiernummer": "134174",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3daf28e1-4323-4140-b7fa-c97e7dc63169",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 12 1",
    "klant": "Huitinga, Thom (T), Kleuver, Sissy (S)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 DA",
    "products": [
      {
        "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": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "142304",
      "Huitinga, Thom (T), Kleuver, Sissy (S)",
      "Punter 12 1",
      "8242 DA",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "142304",
    "dossiernummer": "142304",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7e9fa2d0-3038-41dd-b4c1-05044492ee5b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kolsteeg, Diana (D.A)",
      "adres": "Horst 27 48",
      "email": "[email]",
      "postcode": "8225 MR",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Horst 27 48",
      "postcode": "8225 MR",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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"
        }
      ],
      "crmdossier_id": "100541",
      "dossiernummer": "100541",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "194f3437-7b9c-4d2f-8cd0-7377c57b70a5",
  "key": "base_import",
  "value_json": {
    "adres": "Leidseplein 14",
    "klant": "Putten, Jesse van der (JW), Siebrecht, K (KM)",
    "plaats": "Haarlem",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "2013 PX",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "396500.00",
        "status": "Gepasseerd",
        "artikel": "Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Bankspaarhypotheek (Obvion Compact Hypotheek) , Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Bankspaarhypotheek (Obvion Compact Hypotheek) , Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "maatschappij": "Obvion",
        "productsoort": "Aflossingsvrij, Annuitair, Bankspaar",
        "factuurbedrag": "",
        "offertenummer": "558.175.1",
        "passeeringangsdatum": "2017-04-06"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-12-10"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-12-22"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "141683",
      "Putten, Jesse van der (JW), Siebrecht, K (KM)",
      "Leidseplein 14",
      "2013 PX",
      "Haarlem",
      "[email]",
      "[email]",
      "[telefoon]",
      "558.175.1",
      "Obvion",
      "Hypotheek",
      "Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Bankspaarhypotheek (Obvion Compact Hypotheek) , Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Aflossingsvrij, Annuitair, Bankspaar",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "141683",
    "dossiernummer": "141683",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "194f3437-7b9c-4d2f-8cd0-7377c57b70a5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Putten, Jesse van der (JW)",
      "adres": "Leidseplein 14",
      "email": "[email]",
      "postcode": "2013 PX",
      "woonplaats": "Haarlem",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Siebrecht, K (KM)",
      "adres": "Leidseplein 14",
      "email": "[email]",
      "postcode": "2013 PX",
      "woonplaats": "Haarlem"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "396500.00",
          "status": "Gepasseerd",
          "artikel": "Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Bankspaarhypotheek (Obvion Compact Hypotheek) , Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Aflossingsvrije hypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Bankspaarhypotheek (Obvion Compact Hypotheek) , Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Aflossingsvrij, Annuitair, Bankspaar",
          "factuurbedrag": "",
          "offertenummer": "558.175.1",
          "passeeringangsdatum": "2017-04-06"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-12-10"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-12-22"
        }
      ],
      "crmdossier_id": "141683",
      "dossiernummer": "141683",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e21c3342-0c19-4947-a742-56d1f89939c5",
  "key": "base_import",
  "value_json": {
    "adres": "Botter 22 22",
    "klant": "Gaasenbeek, Remco (R), Jager, s (S)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 KW",
    "products": [
      {
        "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.615648",
        "passeeringangsdatum": "2017-01-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "145860.00",
        "status": "Gepasseerd",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.569.969",
        "passeeringangsdatum": "2017-01-31"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-12-05"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "144493",
      "Gaasenbeek, Remco (R), Jager, s (S)",
      "Botter 22 22",
      "8232 KW",
      "LELYSTAD",
      "[email]",
      "[email]",
      "[telefoon]",
      "GEWI.615648",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "1.569.969",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "144493",
    "dossiernummer": "144493",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e21c3342-0c19-4947-a742-56d1f89939c5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gaasenbeek, Remco (R)",
      "adres": "Botter 22 22",
      "email": "[email]",
      "postcode": "8232 KW",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Jager, s (S)",
      "adres": "Botter 22 22",
      "email": "[email]",
      "postcode": "8232 KW",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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.615648",
          "passeeringangsdatum": "2017-01-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "145860.00",
          "status": "Gepasseerd",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.569.969",
          "passeeringangsdatum": "2017-01-31"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-12-05"
        }
      ],
      "crmdossier_id": "144493",
      "dossiernummer": "144493",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e9b6143b-e266-4ccb-b4a7-3b97821ce9cf",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Broekhuis (E.J.F.)",
      "adres": "Langezand 59",
      "postcode": "8223 WE",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "naam": "Kemmer (D.B.)",
      "adres": "Langezand 59",
      "postcode": "8223 WE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "DK",
          "tekendatum": "25569",
          "productnaam": "DK",
          "maatschappij": "Voordeelbank B.V.",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2010-12-06"
        }
      ],
      "crmdossier_id": "150656",
      "dossiernummer": "150656",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "9c787c05-9b00-4133-b13f-ea8ad3c28f4e",
  "key": "base_import",
  "value_json": {
    "adres": "Archipel 16 32",
    "klant": "Niemoller, Paul (P)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 GH",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "194213.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": "2442618",
        "passeeringangsdatum": "2013-04-26"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95877",
      "Niemoller, Paul (P)",
      "Archipel 16 32",
      "8224 GH",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "2442618",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95877",
    "dossiernummer": "95877",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "14150da6-6739-48a6-bc43-c714601b940e",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bakker (R.)",
      "adres": "De Koningshof 53",
      "email": "[email]",
      "postcode": "8255 DH",
      "woonplaats": "Swifterbant",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Koningshof 53",
      "email": "[email]",
      "postcode": "8255 DH",
      "woonplaats": "Swifterbant"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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-04-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "179877.00",
          "status": "Lopend",
          "artikel": "Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel overstap Annuïteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel overstap Annuïteiten Hypotheek",
          "maatschappij": "Munt Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1944650",
          "passeeringangsdatum": "2021-07-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-08-31"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "155000.00",
          "status": "Lopend",
          "artikel": "Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten))",
          "tekendatum": "25569",
          "productnaam": "Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten))",
          "maatschappij": "Florius",
          "productsoort": "Aflossingsvrij",
          "factuurbedrag": "",
          "offertenummer": "1.663.976",
          "passeeringangsdatum": "2017-09-13"
        }
      ],
      "crmdossier_id": "151221",
      "dossiernummer": "151221",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "14150da6-6739-48a6-bc43-c714601b940e",
  "key": "base_import",
  "value_json": {
    "adres": "De Koningshof 53",
    "klant": "Bakker (R.)",
    "plaats": "Swifterbant",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8255 DH",
    "products": [
      {
        "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-04-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "179877.00",
        "status": "Lopend",
        "artikel": "Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel overstap Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel overstap Annuïteiten Hypotheek",
        "maatschappij": "Munt Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1944650",
        "passeeringangsdatum": "2021-07-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-08-31"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "155000.00",
        "status": "Lopend",
        "artikel": "Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten))",
        "tekendatum": "25569",
        "productnaam": "Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten))",
        "maatschappij": "Florius",
        "productsoort": "Aflossingsvrij",
        "factuurbedrag": "",
        "offertenummer": "1.663.976",
        "passeeringangsdatum": "2017-09-13"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "151221",
      "Bakker (R.)",
      "De Koningshof 53",
      "8255 DH",
      "Swifterbant",
      "[email]",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "1944650",
      "Munt Hypotheken",
      "Hypotheek",
      "Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel Overstap Aflossingsvrije Hypotheek, Munt Simpel overstap Annuïteiten Hypotheek",
      "Aflossingsvrij, Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "1.663.976",
      "Florius",
      "Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten)), Aflossingsvrij (Florius Profijt Twaalf (0% afsluitkosten))",
      "Aflossingsvrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "151221",
    "dossiernummer": "151221",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "662f7117-39fa-4b8c-b667-d88f956af149",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 35 24",
    "klant": "Frysztacki (D.A.), Grzesik (A.A.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 WJ",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Annuitair Dalende Risicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Annuitair Dalende Risicoverzekering",
        "maatschappij": "Cardif",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "O43402",
        "passeeringangsdatum": "2012-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99892",
      "Frysztacki (D.A.), Grzesik (A.A.)",
      "Schoener 35 24",
      "8243 WJ",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "O43402",
      "Cardif",
      "Levensverzekering",
      "Annuitair Dalende Risicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99892",
    "dossiernummer": "99892",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "662f7117-39fa-4b8c-b667-d88f956af149",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Frysztacki (D.A.)",
      "adres": "Schoener 35 24",
      "email": "[email]",
      "postcode": "8243 WJ",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Grzesik (A.A.)",
      "adres": "Schoener 35 24",
      "postcode": "8243 WJ",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Annuitair Dalende Risicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Annuitair Dalende Risicoverzekering",
          "maatschappij": "Cardif",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "O43402",
          "passeeringangsdatum": "2012-04-01"
        }
      ],
      "crmdossier_id": "99892",
      "dossiernummer": "99892",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e575b75b-114a-4eca-b5d2-aa14dee49ca0",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 17 16",
    "klant": "Colenberg, Tim (T), Klijnsma, Trudy (T)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 TN",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "264500.00",
        "status": "Gepasseerd",
        "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "maatschappij": "ABN AMRO",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "700.323.883",
        "passeeringangsdatum": "2016-01-29"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "115987",
      "Colenberg, Tim (T), Klijnsma, Trudy (T)",
      "Schoener 17 16",
      "8243 TN",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "700.323.883",
      "ABN AMRO",
      "Hypotheek",
      "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "115987",
    "dossiernummer": "115987",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e575b75b-114a-4eca-b5d2-aa14dee49ca0",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Colenberg, Tim (T)",
      "adres": "Schoener 17 16",
      "email": "[email]",
      "postcode": "8243 TN",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Klijnsma, Trudy (T)",
      "adres": "Schoener 17 16",
      "postcode": "8243 TN",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "264500.00",
          "status": "Gepasseerd",
          "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "maatschappij": "ABN AMRO",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "700.323.883",
          "passeeringangsdatum": "2016-01-29"
        }
      ],
      "crmdossier_id": "115987",
      "dossiernummer": "115987",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "9284d523-95cb-4791-ae51-493ed0a75f51",
  "key": "base_import",
  "value_json": {
    "adres": "Botter 11 02",
    "klant": "Abadi (M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 JL",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "156847.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-859858",
        "passeeringangsdatum": "2010-10-25"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "100639",
      "Abadi (M.)",
      "Botter 11 02",
      "8232 JL",
      "Lelystad",
      "[email]",
      "06 - 81 63 40 37",
      "Z 090-859858",
      "ING Bank",
      "Hypotheek",
      "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
      "Aflossingsvrij, Bankspaar"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "100639",
    "dossiernummer": "100639",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "06 - 81 63 40 37",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "9284d523-95cb-4791-ae51-493ed0a75f51",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Abadi (M.)",
      "adres": "Botter 11 02",
      "email": "[email]",
      "postcode": "8232 JL",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 81 63 40 37"
    },
    "a2": {
      "adres": "Botter 11 02",
      "postcode": "8232 JL",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "156847.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-859858",
          "passeeringangsdatum": "2010-10-25"
        }
      ],
      "crmdossier_id": "100639",
      "dossiernummer": "100639",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d13e9569-70f6-4cbb-b110-b5acd42f8285",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Boeijen, Wendy van (WD)",
      "adres": "Archipel 41 06",
      "email": "[email]",
      "postcode": "8224 HS",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kolfschoten, Michiel van (M)",
      "adres": "Archipel 41 06",
      "email": "[email]",
      "postcode": "8224 HS",
      "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": "2017-07-24"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "194000.00",
          "status": "Gepasseerd",
          "artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
          "maatschappij": "Merius Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3002997",
          "passeeringangsdatum": "2017-11-10"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "ORV Annuitair dalend",
          "tekendatum": "25569",
          "productnaam": "ORV Annuitair dalend",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "1300264377",
          "passeeringangsdatum": "2017-11-01"
        }
      ],
      "crmdossier_id": "154363",
      "dossiernummer": "154363",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d13e9569-70f6-4cbb-b110-b5acd42f8285",
  "key": "base_import",
  "value_json": {
    "adres": "Archipel 41 06",
    "klant": "Boeijen, Wendy van (WD), Kolfschoten, Michiel van (M)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 HS",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-07-24"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "194000.00",
        "status": "Gepasseerd",
        "artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
        "maatschappij": "Merius Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3002997",
        "passeeringangsdatum": "2017-11-10"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "ORV Annuitair dalend",
        "tekendatum": "25569",
        "productnaam": "ORV Annuitair dalend",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "1300264377",
        "passeeringangsdatum": "2017-11-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "154363",
      "Boeijen, Wendy van (WD), Kolfschoten, Michiel van (M)",
      "Archipel 41 06",
      "8224 HS",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3002997",
      "Merius Hypotheken",
      "Hypotheek",
      "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
      "Aflossingsvrij, Annuitair",
      "1300264377",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "ORV Annuitair dalend",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "154363",
    "dossiernummer": "154363",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7cab7326-17a1-4b69-a661-b8d7088a680b",
  "key": "base_import",
  "value_json": {
    "adres": "Majoraan 64",
    "klant": "Pruim, Jaap (J.A.), Stoop, Lotte (L.L.)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8252 BB",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Beeindigd",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.607002",
        "passeeringangsdatum": "2015-06-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "182500.00",
        "status": "Gepasseerd",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2016-11-28"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "103725",
      "Pruim, Jaap (J.A.), Stoop, Lotte (L.L.)",
      "Majoraan 64",
      "8252 BB",
      "Dronten",
      "[email]",
      "[telefoon]",
      "GEWI.607002",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "103725",
    "dossiernummer": "103725",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7cab7326-17a1-4b69-a661-b8d7088a680b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Pruim, Jaap (J.A.)",
      "adres": "Majoraan 64",
      "email": "[email]",
      "postcode": "8252 BB",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Stoop, Lotte (L.L.)",
      "adres": "Majoraan 64",
      "postcode": "8252 BB",
      "woonplaats": "Dronten"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Beeindigd",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.607002",
          "passeeringangsdatum": "2015-06-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "182500.00",
          "status": "Gepasseerd",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2016-11-28"
        }
      ],
      "crmdossier_id": "103725",
      "dossiernummer": "103725",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "9370bf61-e2bd-4aa1-b296-b60509b8d863",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 26 09",
    "klant": "Bos, Thea (MC)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 PA",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "114400.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2015-02-16"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95189",
      "Bos, Thea (MC)",
      "Horst 26 09",
      "8225 PA",
      "Lelystad",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95189",
    "dossiernummer": "95189",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "c6aa966c-9484-45d3-8118-854a0c5b76f1",
  "key": "base_import",
  "value_json": {
    "adres": "Diopter 31",
    "klant": "Chaoui (N.R.), Jong, de (L.N.)",
    "plaats": "AMSTERDAM",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1025 MR",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)",
        "passeeringangsdatum": "2017-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "145444",
      "Chaoui (N.R.), Jong, de (L.N.)",
      "Diopter 31",
      "1025 MR",
      "AMSTERDAM",
      "[email]",
      "[email]",
      "[telefoon]",
      "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "145444",
    "dossiernummer": "145444",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "c6aa966c-9484-45d3-8118-854a0c5b76f1",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Chaoui (N.R.)",
      "adres": "Diopter 31",
      "email": "[email]",
      "postcode": "1025 MR",
      "woonplaats": "AMSTERDAM",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Jong, de (L.N.)",
      "adres": "Diopter 31",
      "email": "[email]",
      "postcode": "1025 MR",
      "woonplaats": "AMSTERDAM"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)",
          "passeeringangsdatum": "2017-05-01"
        }
      ],
      "crmdossier_id": "145444",
      "dossiernummer": "145444",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "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": "41b76f8c-e0c1-43ec-aacf-51e903f0224b",
  "key": "base_import",
  "value_json": {
    "adres": "Kempenaar 05 34",
    "klant": "Nguyen, Phuong (TP)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 EA",
    "products": [
      {
        "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": "2452410",
        "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-07-27"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "146289.00",
        "status": "Gepasseerd",
        "artikel": "Merius annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Merius annuiteitenhypotheek",
        "maatschappij": "Merius Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3003564",
        "passeeringangsdatum": "2017-10-31"
      },
      {
        "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": "161289585385",
        "passeeringangsdatum": "2017-10-31"
      },
      {
        "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-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "155094",
      "Nguyen, Phuong (TP)",
      "Kempenaar 05 34",
      "8231 EA",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2452410",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3003564",
      "Merius Hypotheken",
      "Hypotheek",
      "Merius annuiteitenhypotheek",
      "Annuitair",
      "161289585385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
      "Aansprakelijkheid, Inboedel, Opstal",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Opstal, Inboedel, Aansprakelijkheid"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "155094",
    "dossiernummer": "155094",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "41b76f8c-e0c1-43ec-aacf-51e903f0224b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Nguyen, Phuong (TP)",
      "adres": "Kempenaar 05 34",
      "email": "[email]",
      "postcode": "8231 EA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kempenaar 05 34",
      "postcode": "8231 EA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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": "2452410",
          "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-07-27"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "146289.00",
          "status": "Gepasseerd",
          "artikel": "Merius annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Merius annuiteitenhypotheek",
          "maatschappij": "Merius Hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3003564",
          "passeeringangsdatum": "2017-10-31"
        },
        {
          "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": "161289585385",
          "passeeringangsdatum": "2017-10-31"
        },
        {
          "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-08-01"
        }
      ],
      "crmdossier_id": "155094",
      "dossiernummer": "155094",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "882ab23e-4a18-4828-a44e-6ec1ccf94898",
  "key": "base_import",
  "value_json": {
    "adres": "Wijnrank 4",
    "klant": "Doesburg, Kelly van (K), Hekman, Ben (B)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8253 LM",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-12-14"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-486C23BB-5EDE-4C03-82BF-54D4E7E029CE|750(3)",
        "passeeringangsdatum": "2018-01-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "153638",
      "Doesburg, Kelly van (K), Hekman, Ben (B)",
      "Wijnrank 4",
      "8253 LM",
      "Dronten",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-486C23BB-5EDE-4C03-82BF-54D4E7E029CE|750(3)",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "153638",
    "dossiernummer": "153638",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "882ab23e-4a18-4828-a44e-6ec1ccf94898",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Doesburg, Kelly van (K)",
      "adres": "Wijnrank 4",
      "email": "[email]",
      "postcode": "8253 LM",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Hekman, Ben (B)",
      "adres": "Wijnrank 4",
      "postcode": "8253 LM",
      "woonplaats": "Dronten"
    },
    "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-12-14"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-486C23BB-5EDE-4C03-82BF-54D4E7E029CE|750(3)",
          "passeeringangsdatum": "2018-01-01"
        }
      ],
      "crmdossier_id": "153638",
      "dossiernummer": "153638",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "84c153de-257b-4879-bcb7-6569168f5632",
  "key": "base_import",
  "value_json": {
    "adres": "Agorahof 131",
    "klant": "Vries, Mirjam de (M)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 JH",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "92581.00",
        "status": "Gepasseerd",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.496.918",
        "passeeringangsdatum": "2016-12-15"
      },
      {
        "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.614405",
        "passeeringangsdatum": "2016-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-10-12"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "132599",
      "Vries, Mirjam de (M)",
      "Agorahof 131",
      "8224 JH",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "1.496.918",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "GEWI.614405",
      "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": "132599",
    "dossiernummer": "132599",
    "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": "84c153de-257b-4879-bcb7-6569168f5632",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Vries, Mirjam de (M)",
      "adres": "Agorahof 131",
      "email": "[email]",
      "postcode": "8224 JH",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Agorahof 131",
      "postcode": "8224 JH",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "92581.00",
          "status": "Gepasseerd",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.496.918",
          "passeeringangsdatum": "2016-12-15"
        },
        {
          "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.614405",
          "passeeringangsdatum": "2016-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-10-12"
        }
      ],
      "crmdossier_id": "132599",
      "dossiernummer": "132599",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "94e47f3c-7340-4b6c-be6f-48ad8153b07e",
  "key": "base_import",
  "value_json": {
    "adres": "Werfweg 4",
    "klant": "Koffeman (A.D.), Prins (S.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 PG",
    "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": "2013-11-18"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "149919",
      "Koffeman (A.D.), Prins (S.)",
      "Werfweg 4",
      "8243 PG",
      "Lelystad",
      "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": "149919",
    "dossiernummer": "149919",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "94e47f3c-7340-4b6c-be6f-48ad8153b07e",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Koffeman (A.D.)",
      "adres": "Werfweg 4",
      "postcode": "8243 PG",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "naam": "Prins (S.)",
      "adres": "Werfweg 4",
      "postcode": "8243 PG",
      "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": "2013-11-18"
        }
      ],
      "crmdossier_id": "149919",
      "dossiernummer": "149919",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "c14391b3-b7f4-42f5-8765-e2d0e9e6a898",
  "key": "base_import",
  "value_json": {
    "adres": "Jol 16 37",
    "klant": "Gijsen, Stephany (SM), Hollander, Bryan (BW)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 EB",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "360000.00",
        "status": "Gepasseerd",
        "artikel": "Woongenot Annuïteit, Woongenot Annuïteit",
        "tekendatum": "25569",
        "productnaam": "Woongenot Annuïteit, Woongenot Annuïteit",
        "maatschappij": "Centraal Beheer (voormalig Woonfonds)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3050159-01",
        "passeeringangsdatum": "2018-05-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "429672.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1936212",
        "passeeringangsdatum": "2021-04-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "22250.00",
        "status": "Stukken naar notaris",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1936212",
        "passeeringangsdatum": "2022-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-12-07"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "2840155",
        "passeeringangsdatum": "2021-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "161134",
      "Gijsen, Stephany (SM), Hollander, Bryan (BW)",
      "Jol 16 37",
      "8243 EB",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "3050159-01",
      "Centraal Beheer (voormalig Woonfonds)",
      "Hypotheek",
      "Woongenot Annuïteit, Woongenot Annuïteit",
      "Annuitair",
      "1936212",
      "Lloyds Bank",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Lloyds Annuiteitenhypotheek",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2840155",
      "TAF",
      "Levensverzekering",
      "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "161134",
    "dossiernummer": "161134",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "c14391b3-b7f4-42f5-8765-e2d0e9e6a898",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gijsen, Stephany (SM)",
      "adres": "Jol 16 37",
      "email": "[email]",
      "postcode": "8243 EB",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Hollander, Bryan (BW)",
      "adres": "Jol 16 37",
      "postcode": "8243 EB",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "360000.00",
          "status": "Gepasseerd",
          "artikel": "Woongenot Annuïteit, Woongenot Annuïteit",
          "tekendatum": "25569",
          "productnaam": "Woongenot Annuïteit, Woongenot Annuïteit",
          "maatschappij": "Centraal Beheer (voormalig Woonfonds)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3050159-01",
          "passeeringangsdatum": "2018-05-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "429672.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1936212",
          "passeeringangsdatum": "2021-04-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "22250.00",
          "status": "Stukken naar notaris",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1936212",
          "passeeringangsdatum": "2022-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-12-07"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "2840155",
          "passeeringangsdatum": "2021-05-01"
        }
      ],
      "crmdossier_id": "161134",
      "dossiernummer": "161134",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e009fdc6-5896-443d-90f0-d486822002f1",
  "key": "base_import",
  "value_json": {
    "adres": "Westhoven 68",
    "klant": "Duinen, Marco van (J.R.M.), Harmsen, Suzanne (S)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8219 AG",
    "products": [
      {
        "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": "2617483",
        "passeeringangsdatum": "2018-03-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "323431.00",
        "status": "Gepasseerd",
        "artikel": "Woongenot Annuïteit, Woongenot Annuïteit",
        "tekendatum": "25569",
        "productnaam": "Woongenot Annuïteit, Woongenot Annuïteit",
        "maatschappij": "Centraal Beheer (voormalig Woonfonds)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3058261",
        "passeeringangsdatum": "2018-06-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-02-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "163913",
      "Duinen, Marco van (J.R.M.), Harmsen, Suzanne (S)",
      "Westhoven 68",
      "8219 AG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2617483",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "3058261",
      "Centraal Beheer (voormalig Woonfonds)",
      "Hypotheek",
      "Woongenot Annuïteit, Woongenot Annuïteit",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "163913",
    "dossiernummer": "163913",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "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": "e009fdc6-5896-443d-90f0-d486822002f1",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Duinen, Marco van (J.R.M.)",
      "adres": "Westhoven 68",
      "email": "[email]",
      "postcode": "8219 AG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Harmsen, Suzanne (S)",
      "adres": "Westhoven 68",
      "postcode": "8219 AG",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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": "2617483",
          "passeeringangsdatum": "2018-03-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "323431.00",
          "status": "Gepasseerd",
          "artikel": "Woongenot Annuïteit, Woongenot Annuïteit",
          "tekendatum": "25569",
          "productnaam": "Woongenot Annuïteit, Woongenot Annuïteit",
          "maatschappij": "Centraal Beheer (voormalig Woonfonds)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3058261",
          "passeeringangsdatum": "2018-06-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-02-07"
        }
      ],
      "crmdossier_id": "163913",
      "dossiernummer": "163913",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "01c1072c-d3e9-42dc-a6ab-c7d4c73698d5",
  "key": "base_import",
  "value_json": {
    "adres": "Langezand 118",
    "klant": "Hamchout, Nabil (N)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8223 WJ",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-01-30"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "163467",
      "Hamchout, Nabil (N)",
      "Langezand 118",
      "8223 WJ",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "163467",
    "dossiernummer": "163467",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "01c1072c-d3e9-42dc-a6ab-c7d4c73698d5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Hamchout, Nabil (N)",
      "adres": "Langezand 118",
      "email": "[email]",
      "postcode": "8223 WJ",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Langezand 118",
      "postcode": "8223 WJ",
      "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": "2018-01-30"
        }
      ],
      "crmdossier_id": "163467",
      "dossiernummer": "163467",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "21f40268-9212-46e9-8bcc-3510b245e5c8",
  "key": "base_import",
  "value_json": {
    "adres": "Galjoen 19 29",
    "klant": "Husslage, Maria (MS), Karper, Lambartes (LN)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 LX",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-08-21",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-08-21"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "126410",
      "Husslage, Maria (MS), Karper, Lambartes (LN)",
      "Galjoen 19 29",
      "8243 LX",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "126410",
    "dossiernummer": "126410",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "a91a1675-5264-4d67-9edd-f4c7bace8b3c",
  "key": "base_import",
  "value_json": {
    "adres": "Voorstraat 508",
    "klant": "Dijk, van (MG), Dijk, van (Y)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 KG",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "121198.00",
        "status": "Lopend",
        "artikel": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Aflossingsvrij",
        "factuurbedrag": "",
        "offertenummer": "2058189",
        "passeeringangsdatum": "2022-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "246099",
      "Dijk, van (MG), Dijk, van (Y)",
      "Voorstraat 508",
      "8226 KG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2058189",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
      "Aflossingsvrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "246099",
    "dossiernummer": "246099",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}