Database Explorer

{
  "dossier_id": "e9dc0945-7e0b-41ab-8caf-b89988746fd9",
  "key": "base_import",
  "value_json": {
    "adres": "Tjalk 35 23",
    "klant": "Gvozdas, Evaldas (E.), Gvozde, Akvile (A.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 MP",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "283000.00",
        "status": "Lopend",
        "artikel": "Woonnu Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Woonnu Annuïtair",
        "maatschappij": "Woonnu",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3284344-01",
        "passeeringangsdatum": "2021-11-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-09-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Scherp & Slim ORV annuïtair dalend",
        "tekendatum": "25569",
        "productnaam": "Scherp & Slim ORV annuïtair dalend",
        "maatschappij": "Hera Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "HL0136588",
        "passeeringangsdatum": "2021-11-15"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-D9393648-3308-412E-876F-4D822E83FC8A|1180(1)",
        "passeeringangsdatum": "2021-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-11-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-E8A46744-9A1F-46E8-B547-83709DDE9B51|1180(1)",
        "passeeringangsdatum": "2021-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "237549",
      "Gvozdas, Evaldas (E.), Gvozde, Akvile (A.)",
      "Tjalk 35 23",
      "8232 MP",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "3284344-01",
      "Woonnu",
      "Hypotheek",
      "Woonnu Annuïtair",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "HL0136588",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "ISW-D9393648-3308-412E-876F-4D822E83FC8A|1180(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "ISW-E8A46744-9A1F-46E8-B547-83709DDE9B51|1180(1)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "237549",
    "dossiernummer": "237549",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ae8ba55a-8b7e-4e1b-ab83-e8e71755676f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Soijo, Dennie (D.)",
      "adres": "Pinksterbloemweg 72",
      "email": "[email]",
      "postcode": "1338 MB",
      "woonplaats": "Almere",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Pinksterbloemweg 72",
      "postcode": "1338 MB",
      "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": "2020-07-23"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-07-23"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-07-23",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-07-23"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "248500.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3217305-01",
          "passeeringangsdatum": "2020-12-04"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-07-23",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-07-23"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "248500.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3217305-01",
          "passeeringangsdatum": "2020-12-04"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-10-09"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-10-09"
        }
      ],
      "crmdossier_id": "223901",
      "dossiernummer": "223901",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ae8ba55a-8b7e-4e1b-ab83-e8e71755676f",
  "key": "base_import",
  "value_json": {
    "adres": "Pinksterbloemweg 72",
    "klant": "Soijo, Dennie (D.)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1338 MB",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-23"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-23"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-07-23",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-23"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "248500.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3217305-01",
        "passeeringangsdatum": "2020-12-04"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-07-23",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-23"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "248500.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3217305-01",
        "passeeringangsdatum": "2020-12-04"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-10-09"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-10-09"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 8,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "223901",
      "Soijo, Dennie (D.)",
      "Pinksterbloemweg 72",
      "1338 MB",
      "Almere",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Dienst",
      "Advies nieuwe hypotheek starter/Aankoop",
      "Dienst BTW vrij",
      "3217305-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Vrij Leven Annuïtair",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "223901",
    "dossiernummer": "223901",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5862d343-6fbb-421d-b2c4-0f5d5681ff33",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Alferink, Bianca (BTM)",
      "email": "[email]",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Geest, Daniel van der (D)",
      "email": "[email]",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "354000.00",
          "status": "Lopend",
          "artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3216369-01",
          "passeeringangsdatum": "2020-11-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-11-02"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2822167",
          "passeeringangsdatum": "2021-02-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "489550.00",
          "status": "Finaal akkoord",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3584356",
          "passeeringangsdatum": "2025-11-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2629289",
          "passeeringangsdatum": "2018-05-01"
        }
      ],
      "crmdossier_id": "222722",
      "dossiernummer": "222722",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5862d343-6fbb-421d-b2c4-0f5d5681ff33",
  "key": "base_import",
  "value_json": {
    "adres": "",
    "klant": "Alferink, Bianca (BTM), Geest, Daniel van der (D)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "354000.00",
        "status": "Lopend",
        "artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3216369-01",
        "passeeringangsdatum": "2020-11-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-11-02"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2822167",
        "passeeringangsdatum": "2021-02-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "489550.00",
        "status": "Finaal akkoord",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3584356",
        "passeeringangsdatum": "2025-11-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2629289",
        "passeeringangsdatum": "2018-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "222722",
      "Alferink, Bianca (BTM), Geest, Daniel van der (D)",
      "LELYSTAD",
      "[email]",
      "[email]",
      "[telefoon]",
      "3216369-01",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Aflossingsvrij, Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2822167",
      "TAF",
      "Levensverzekering",
      "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
      "Overlijdensrisicoverzekering",
      "3584356",
      "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair",
      "2629289",
      "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "222722",
    "dossiernummer": "222722",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "916137f8-0b98-4c53-998d-5e753428760c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Aleksandrowicz, Beata Helena (BH)",
      "adres": "Foeliestraat 20",
      "email": "[email]",
      "postcode": "1314 KT",
      "woonplaats": "Almere",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Aleksandrowicz, Bogdan (B)",
      "adres": "Foeliestraat 20",
      "postcode": "1314 KT",
      "woonplaats": "Almere"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "234600.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3228819-01",
          "passeeringangsdatum": "2021-02-05"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-20"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "234600.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3228819-01",
          "passeeringangsdatum": "2021-02-05"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-20"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-12-02"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-22",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-22"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-12-02"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-22",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-22"
        }
      ],
      "crmdossier_id": "226163",
      "dossiernummer": "226163",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "916137f8-0b98-4c53-998d-5e753428760c",
  "key": "base_import",
  "value_json": {
    "adres": "Foeliestraat 20",
    "klant": "Aleksandrowicz, Beata Helena (BH), Aleksandrowicz, Bogdan (B)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1314 KT",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "234600.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3228819-01",
        "passeeringangsdatum": "2021-02-05"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-20"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "234600.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3228819-01",
        "passeeringangsdatum": "2021-02-05"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-20"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-12-02"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-22",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-22"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-12-02"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-22",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-22"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 8,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "226163",
      "Aleksandrowicz, Beata Helena (BH), Aleksandrowicz, Bogdan (B)",
      "Foeliestraat 20",
      "1314 KT",
      "Almere",
      "[email]",
      "[telefoon]",
      "3228819-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Vrij Leven Annuïtair",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "Eigen kantoor",
      "Hypotheekadvies",
      "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": "226163",
    "dossiernummer": "226163",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "a1489b29-1955-413e-abc3-8380ae3fd156",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Meide, van der (M.)",
      "adres": "Kopenhagenlaan 141",
      "email": "[email]",
      "postcode": "8232 RD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Weelden, Marike van (M)",
      "adres": "Kopenhagenlaan 141",
      "email": "[email]",
      "postcode": "8232 RD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "404900.00",
          "status": "Lopend",
          "artikel": "Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
          "maatschappij": "Woonnu",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3259986-01",
          "passeeringangsdatum": "2021-05-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-08-31"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-18A3956F-A7EB-4AEE-BA1E-58FC48876404|1003(1)",
          "passeeringangsdatum": "2021-05-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "21675.00",
          "status": "Lopend",
          "artikel": "Woonnu Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Woonnu Annuïtair",
          "maatschappij": "Woonnu",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3259986-01",
          "passeeringangsdatum": "2022-08-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-8479D55B-9BAE-4F3B-940F-B3F932448E14|1003(1)",
          "passeeringangsdatum": "2021-05-01"
        }
      ],
      "crmdossier_id": "147470",
      "dossiernummer": "147470",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "a1489b29-1955-413e-abc3-8380ae3fd156",
  "key": "base_import",
  "value_json": {
    "adres": "Kopenhagenlaan 141",
    "klant": "Meide, van der (M.), Weelden, Marike van (M)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 RD",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "404900.00",
        "status": "Lopend",
        "artikel": "Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
        "maatschappij": "Woonnu",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3259986-01",
        "passeeringangsdatum": "2021-05-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-08-31"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-18A3956F-A7EB-4AEE-BA1E-58FC48876404|1003(1)",
        "passeeringangsdatum": "2021-05-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "21675.00",
        "status": "Lopend",
        "artikel": "Woonnu Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Woonnu Annuïtair",
        "maatschappij": "Woonnu",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3259986-01",
        "passeeringangsdatum": "2022-08-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-8479D55B-9BAE-4F3B-940F-B3F932448E14|1003(1)",
        "passeeringangsdatum": "2021-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "147470",
      "Meide, van der (M.), Weelden, Marike van (M)",
      "Kopenhagenlaan 141",
      "8232 RD",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "3259986-01",
      "Woonnu",
      "Hypotheek",
      "Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-18A3956F-A7EB-4AEE-BA1E-58FC48876404|1003(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "Woonnu Annuïtair",
      "ISW-8479D55B-9BAE-4F3B-940F-B3F932448E14|1003(1)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "147470",
    "dossiernummer": "147470",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "092a9da1-3cc4-49ea-ad8f-d311433d4f41",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Adododji, Akuele (A)",
      "adres": "Punter 37 83",
      "email": "[email]",
      "postcode": "8242 EV",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Atayi, Germain (G)",
      "adres": "Punter 37 83",
      "postcode": "8242 EV",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Scherp & Slim ORV annuïtair dalend",
          "tekendatum": "25569",
          "productnaam": "Scherp & Slim ORV annuïtair dalend",
          "maatschappij": "Hera Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "HL0145297",
          "passeeringangsdatum": "2022-04-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "130783.00",
          "status": "Gepasseerd",
          "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "maatschappij": "ASN (voorheen BLG Wonen)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "10280645",
          "passeeringangsdatum": "2018-08-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "0.00",
          "status": "Gepasseerd",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "SVn",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "241.988.000",
          "passeeringangsdatum": "2018-07-30"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "203723.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1995325",
          "passeeringangsdatum": "2021-11-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-10-07"
        }
      ],
      "crmdossier_id": "159898",
      "dossiernummer": "159898",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "092a9da1-3cc4-49ea-ad8f-d311433d4f41",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 37 83",
    "klant": "Adododji, Akuele (A), Atayi, Germain (G)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 EV",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Scherp & Slim ORV annuïtair dalend",
        "tekendatum": "25569",
        "productnaam": "Scherp & Slim ORV annuïtair dalend",
        "maatschappij": "Hera Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "HL0145297",
        "passeeringangsdatum": "2022-04-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "130783.00",
        "status": "Gepasseerd",
        "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "maatschappij": "ASN (voorheen BLG Wonen)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "10280645",
        "passeeringangsdatum": "2018-08-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "0.00",
        "status": "Gepasseerd",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "SVn",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "241.988.000",
        "passeeringangsdatum": "2018-07-30"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "203723.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1995325",
        "passeeringangsdatum": "2021-11-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-10-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "159898",
      "Adododji, Akuele (A), Atayi, Germain (G)",
      "Punter 37 83",
      "8242 EV",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "HL0145297",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "10280645",
      "ASN (voorheen BLG Wonen)",
      "Hypotheek",
      "BLG Annuïteitenhypotheek (BLG Hypotheek)",
      "Annuitair",
      "241.988.000",
      "SVn",
      "1995325",
      "Lloyds Bank",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "159898",
    "dossiernummer": "159898",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "72bb1e4e-6ec2-4082-a282-5d5673558f93",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Baars, Mary (M)",
      "adres": "Tjalk 35 23",
      "email": "[email]",
      "postcode": "8232 MP",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Baars, Ton (A)",
      "adres": "Tjalk 35 23",
      "postcode": "8232 MP",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-08-31"
        },
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Gepasseerd",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-08-11"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "187403.00",
          "status": "Lopend",
          "artikel": "Woonnu Annuitair, Woonnu Annuitair, Woonnu Aflossingsvrij",
          "tekendatum": "25569",
          "productnaam": "Woonnu Annuitair, Woonnu Annuitair, Woonnu Aflossingsvrij",
          "maatschappij": "Woonnu",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3275167-01",
          "passeeringangsdatum": "2021-11-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Caravan, Auto",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Caravan, Auto",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Caravan, Inboedel, Opstal, Personenauto, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-09-01"
        }
      ],
      "crmdossier_id": "231822",
      "dossiernummer": "231822",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "72bb1e4e-6ec2-4082-a282-5d5673558f93",
  "key": "base_import",
  "value_json": {
    "adres": "Tjalk 35 23",
    "klant": "Baars, Mary (M), Baars, Ton (A)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 MP",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-08-31"
      },
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00",
        "status": "Gepasseerd",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen makelaardij",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-08-11"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "187403.00",
        "status": "Lopend",
        "artikel": "Woonnu Annuitair, Woonnu Annuitair, Woonnu Aflossingsvrij",
        "tekendatum": "25569",
        "productnaam": "Woonnu Annuitair, Woonnu Annuitair, Woonnu Aflossingsvrij",
        "maatschappij": "Woonnu",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3275167-01",
        "passeeringangsdatum": "2021-11-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Caravan, Auto",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Caravan, Auto",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Caravan, Inboedel, Opstal, Personenauto, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "231822",
      "Baars, Mary (M), Baars, Ton (A)",
      "Tjalk 35 23",
      "8232 MP",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Eigen makelaardij",
      "Verkoopdienst",
      "3275167-01",
      "Woonnu",
      "Hypotheek",
      "Woonnu Annuitair, Woonnu Annuitair, Woonnu Aflossingsvrij",
      "Aflossingsvrij, Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Caravan, Auto",
      "Aansprakelijkheid, Caravan, Inboedel, Opstal, Personenauto, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "231822",
    "dossiernummer": "231822",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "44c1217c-eebd-453a-99b7-aadf9292bbb4",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Dijk, Klaas van (K)",
      "adres": "Kogge 8 71",
      "email": "[email]",
      "postcode": "8242 AB",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Fijnenberg, Linda (L)",
      "adres": "Kogge 8 71",
      "postcode": "8242 AB",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Personal ORV BNP - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Personal ORV BNP - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-68D69AF3-70FA-4335-BB59-B7F00CC9B1C0|1145(2)",
          "passeeringangsdatum": "2021-07-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-37588838-D137-4F75-AFFD-4174D30BAF1F|1145(3)",
          "passeeringangsdatum": "2021-07-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "199593.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2021-12-28"
        },
        {
          "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": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-10-07"
        }
      ],
      "crmdossier_id": "231835",
      "dossiernummer": "231835",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "44c1217c-eebd-453a-99b7-aadf9292bbb4",
  "key": "base_import",
  "value_json": {
    "adres": "Kogge 8 71",
    "klant": "Dijk, Klaas van (K), Fijnenberg, Linda (L)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 AB",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Personal ORV BNP - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Personal ORV BNP - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-68D69AF3-70FA-4335-BB59-B7F00CC9B1C0|1145(2)",
        "passeeringangsdatum": "2021-07-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-37588838-D137-4F75-AFFD-4174D30BAF1F|1145(3)",
        "passeeringangsdatum": "2021-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "199593.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2021-12-28"
      },
      {
        "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": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-10-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "231835",
      "Dijk, Klaas van (K), Fijnenberg, Linda (L)",
      "Kogge 8 71",
      "8242 AB",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "ISW-68D69AF3-70FA-4335-BB59-B7F00CC9B1C0|1145(2)",
      "TAF",
      "Levensverzekering",
      "TAF Personal ORV BNP - Annuitair",
      "Overlijdensrisicoverzekering",
      "ISW-37588838-D137-4F75-AFFD-4174D30BAF1F|1145(3)",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "231835",
    "dossiernummer": "231835",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "cf2e7596-a6c3-41cd-a7d6-b72cefe02c81",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "George , Edward (E.)",
      "adres": "Vagerveld 29",
      "email": "[email]",
      "postcode": "2151 ZB",
      "woonplaats": "Nieuw-Vennep",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Vagerveld 29",
      "email": "[email]",
      "postcode": "2151 ZB",
      "woonplaats": "Nieuw-Vennep"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-5B9422D9-4849-4D60-8F8C-DF96AA860CF5|1238(1)",
          "passeeringangsdatum": "2022-04-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2926770",
          "passeeringangsdatum": "2022-04-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Woonlastenverzekering",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Woonlastenverzekering",
          "maatschappij": "Dazure",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "GWLB.400711",
          "passeeringangsdatum": "2022-04-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "254300.00",
          "status": "Lopend",
          "artikel": "Annuïteiten Hypotheek, Annuïteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Annuïteiten Hypotheek, Annuïteiten Hypotheek",
          "maatschappij": "Robuust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3310679-01",
          "passeeringangsdatum": "2022-04-01"
        }
      ],
      "crmdossier_id": "242838",
      "dossiernummer": "242838",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "cf2e7596-a6c3-41cd-a7d6-b72cefe02c81",
  "key": "base_import",
  "value_json": {
    "adres": "Vagerveld 29",
    "klant": "George , Edward (E.)",
    "plaats": "Nieuw-Vennep",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "2151 ZB",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-5B9422D9-4849-4D60-8F8C-DF96AA860CF5|1238(1)",
        "passeeringangsdatum": "2022-04-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2926770",
        "passeeringangsdatum": "2022-04-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Woonlastenverzekering",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Woonlastenverzekering",
        "maatschappij": "Dazure",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "GWLB.400711",
        "passeeringangsdatum": "2022-04-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "254300.00",
        "status": "Lopend",
        "artikel": "Annuïteiten Hypotheek, Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Annuïteiten Hypotheek, Annuïteiten Hypotheek",
        "maatschappij": "Robuust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3310679-01",
        "passeeringangsdatum": "2022-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "242838",
      "George , Edward (E.)",
      "Vagerveld 29",
      "2151 ZB",
      "Nieuw-Vennep",
      "[email]",
      "[email]",
      "[telefoon]",
      "ISW-5B9422D9-4849-4D60-8F8C-DF96AA860CF5|1238(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "2926770",
      "Levensverzekering",
      "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
      "Overlijdensrisicoverzekering",
      "GWLB.400711",
      "Dazure",
      "GoedIdee Woonlastenverzekering",
      "Woonlastenverzekering",
      "3310679-01",
      "Robuust",
      "Hypotheek",
      "Annuïteiten Hypotheek, Annuïteiten Hypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "242838",
    "dossiernummer": "242838",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "6d887564-f292-466c-89a5-d2519189c1f9",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bottse, Manouschka (M.V.R.)",
      "adres": "Krommehoekstraat 80",
      "email": "[email]",
      "postcode": "1104 KV",
      "woonplaats": "Amsterdam",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Helstone (F.G.)",
      "adres": "Krommehoekstraat 80",
      "email": "[email]",
      "postcode": "1104 KV",
      "woonplaats": "Amsterdam"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-04-22"
        }
      ],
      "crmdossier_id": "226627",
      "dossiernummer": "226627",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "6d887564-f292-466c-89a5-d2519189c1f9",
  "key": "base_import",
  "value_json": {
    "adres": "Krommehoekstraat 80",
    "klant": "Bottse, Manouschka (M.V.R.), Helstone (F.G.)",
    "plaats": "Amsterdam",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1104 KV",
    "products": [
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen makelaardij",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-04-22"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "226627",
      "Bottse, Manouschka (M.V.R.), Helstone (F.G.)",
      "Krommehoekstraat 80",
      "1104 KV",
      "Amsterdam",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen makelaardij",
      "Verkoopdienst"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "226627",
    "dossiernummer": "226627",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7b1fcc1f-05d2-4ec8-889f-0c411d9b738d",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Assem, Dennis van den (D)",
      "adres": "Galjoen 10 17",
      "email": "[email]",
      "postcode": "8243 MH",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Assem-Brandon, Petra van den (P.C.)",
      "adres": "Galjoen 10 17",
      "email": "[email]",
      "postcode": "8243 MH",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies Omzetting/Verhoging/Oversluiting",
          "tekendatum": "2021-07-16",
          "productnaam": "Advies Omzetting/Verhoging/Oversluiting",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-07-16"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "368017.00",
          "status": "Lopend",
          "artikel": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
          "maatschappij": "Munt Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1980172",
          "passeeringangsdatum": "2021-09-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-07-16"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life Woonlastenverzekering - AO",
          "tekendatum": "25569",
          "productnaam": "Credit Life Woonlastenverzekering - AO",
          "maatschappij": "Credit Life",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "5001271911",
          "passeeringangsdatum": "2021-10-01"
        }
      ],
      "crmdossier_id": "235951",
      "dossiernummer": "235951",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7b1fcc1f-05d2-4ec8-889f-0c411d9b738d",
  "key": "base_import",
  "value_json": {
    "adres": "Galjoen 10 17",
    "klant": "Assem, Dennis van den (D), Assem-Brandon, Petra van den (P.C.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 MH",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies Omzetting/Verhoging/Oversluiting",
        "tekendatum": "2021-07-16",
        "productnaam": "Advies Omzetting/Verhoging/Oversluiting",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-07-16"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "368017.00",
        "status": "Lopend",
        "artikel": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
        "maatschappij": "Munt Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1980172",
        "passeeringangsdatum": "2021-09-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-07-16"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Woonlastenverzekering - AO",
        "tekendatum": "25569",
        "productnaam": "Credit Life Woonlastenverzekering - AO",
        "maatschappij": "Credit Life",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "5001271911",
        "passeeringangsdatum": "2021-10-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "235951",
      "Assem, Dennis van den (D), Assem-Brandon, Petra van den (P.C.)",
      "Galjoen 10 17",
      "8243 MH",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies Omzetting/Verhoging/Oversluiting",
      "Dienst BTW vrij",
      "1980172",
      "Munt Hypotheken",
      "Hypotheek",
      "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
      "Aflossingsvrij, Annuitair",
      "Hypotheekadvies",
      "5001271911",
      "Credit Life",
      "Inkomensverzekering",
      "Credit Life Woonlastenverzekering - AO",
      "Woonlastenverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "235951",
    "dossiernummer": "235951",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d1d96ea8-3a18-41f4-ae78-8e24c0cce484",
  "key": "base_import",
  "value_json": {
    "adres": "Kennemerland 34",
    "klant": "Staniszweska , Izabela (IM)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 ER",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "156928945385",
        "passeeringangsdatum": "2017-06-13"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-04-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "66610.00",
        "status": "Offerte aangevraagd",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2026-06-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-03-16"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "67510.00",
        "status": "Beeindigd",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2026-06-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "316318.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2021-10-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2921412",
        "passeeringangsdatum": "2022-03-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.617732",
        "passeeringangsdatum": "2017-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 8,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "148431",
      "Staniszweska , Izabela (IM)",
      "Kennemerland 34",
      "8245 ER",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "156928945385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "*********",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "*********",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "2921412",
      "TAF",
      "Levensverzekering",
      "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
      "Overlijdensrisicoverzekering",
      "GEWI.617732",
      "Dazure",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdz ... [afgekapt: 286 tekens]

{
  "dossier_id": "64b35552-185f-4250-b403-e1ab3eea1720",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gim, Caspar (MC)",
      "adres": "Binnendijk 215",
      "email": "[email]",
      "postcode": "8244 AE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Binnendijk 215",
      "postcode": "8244 AE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-03-16"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-03-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "156275.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3165783-01",
          "passeeringangsdatum": "2020-06-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "156275.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3165783-01",
          "passeeringangsdatum": "2020-06-16"
        }
      ],
      "crmdossier_id": "209546",
      "dossiernummer": "209546",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "64b35552-185f-4250-b403-e1ab3eea1720",
  "key": "base_import",
  "value_json": {
    "adres": "Binnendijk 215",
    "klant": "Gim, Caspar (MC)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8244 AE",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-03-16"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-03-16"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "156275.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3165783-01",
        "passeeringangsdatum": "2020-06-16"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "156275.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3165783-01",
        "passeeringangsdatum": "2020-06-16"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "209546",
      "Gim, Caspar (MC)",
      "Binnendijk 215",
      "8244 AE",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3165783-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Vrij Leven Annuïtair",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "209546",
    "dossiernummer": "209546",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7e2c79a2-5a09-4fa9-ae15-b6acd3868a6c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Soelen, j van (JA)",
      "adres": "Horst 34 2",
      "email": "[email]",
      "postcode": "8225 NH",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Horst 34 2",
      "postcode": "8225 NH",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "176183.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": "1934506",
          "passeeringangsdatum": "2021-06-18"
        },
        {
          "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": "",
          "passeeringangsdatum": "2022-08-31"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-03-12"
        }
      ],
      "crmdossier_id": "230454",
      "dossiernummer": "230454",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7e2c79a2-5a09-4fa9-ae15-b6acd3868a6c",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 34 2",
    "klant": "Soelen, j van (JA)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 NH",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "176183.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": "1934506",
        "passeeringangsdatum": "2021-06-18"
      },
      {
        "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": "",
        "passeeringangsdatum": "2022-08-31"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-03-12"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "230454",
      "Soelen, j van (JA)",
      "Horst 34 2",
      "8225 NH",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "1934506",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "TAF",
      "Levensverzekering",
      "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "230454",
    "dossiernummer": "230454",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d1346c7e-d59e-470d-889f-9877993e331f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Giedrikas (M.)",
      "adres": "IJsselmeerlaan 89",
      "email": "[email]",
      "postcode": "8304 DE",
      "woonplaats": "Emmeloord",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Giedrikiene, Laura (L)",
      "adres": "IJsselmeerlaan 89",
      "email": "[email]",
      "postcode": "8304 DE",
      "woonplaats": "Emmeloord"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "26600.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2024-10-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-08-23"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-01-20"
        }
      ],
      "crmdossier_id": "277740",
      "dossiernummer": "277740",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "d1346c7e-d59e-470d-889f-9877993e331f",
  "key": "base_import",
  "value_json": {
    "adres": "IJsselmeerlaan 89",
    "klant": "Giedrikas (M.), Giedrikiene, Laura (L)",
    "plaats": "Emmeloord",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8304 DE",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "26600.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2024-10-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-08-23"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-01-20"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "277740",
      "Giedrikas (M.), Giedrikiene, Laura (L)",
      "IJsselmeerlaan 89",
      "8304 DE",
      "Emmeloord",
      "[email]",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "277740",
    "dossiernummer": "277740",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f4a946f5-c390-4b6b-8a41-9442225a1a79",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Hulst , Arnaud (A.R.)",
      "adres": "Sportlaan 42",
      "email": "[email]",
      "postcode": "7701 VR",
      "woonplaats": "Dedemsvaart",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Sportlaan 42",
      "postcode": "7701 VR",
      "woonplaats": "Dedemsvaart"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "143029.00",
          "status": "Lopend",
          "artikel": "Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "maatschappij": "Allianz",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3263412-01",
          "passeeringangsdatum": "2021-10-01"
        },
        {
          "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": "GEWI.607596",
          "passeeringangsdatum": "2015-08-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "112500.00",
          "status": "Gepasseerd",
          "artikel": "Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank via Adaxio",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.381.170",
          "passeeringangsdatum": "2015-08-12"
        }
      ],
      "crmdossier_id": "105856",
      "dossiernummer": "105856",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f4a946f5-c390-4b6b-8a41-9442225a1a79",
  "key": "base_import",
  "value_json": {
    "adres": "Sportlaan 42",
    "klant": "Hulst , Arnaud (A.R.)",
    "plaats": "Dedemsvaart",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "7701 VR",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "143029.00",
        "status": "Lopend",
        "artikel": "Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "maatschappij": "Allianz",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3263412-01",
        "passeeringangsdatum": "2021-10-01"
      },
      {
        "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": "GEWI.607596",
        "passeeringangsdatum": "2015-08-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "112500.00",
        "status": "Gepasseerd",
        "artikel": "Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank via Adaxio",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.381.170",
        "passeeringangsdatum": "2015-08-12"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "105856",
      "Hulst , Arnaud (A.R.)",
      "Sportlaan 42",
      "7701 VR",
      "Dedemsvaart",
      "[email]",
      "[telefoon]",
      "3263412-01",
      "Allianz",
      "Hypotheek",
      "Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
      "Annuitair",
      "GEWI.607596",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen",
      "1.381.170",
      "Lloyds Bank via Adaxio",
      "Annuiteitenhypotheek"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "105856",
    "dossiernummer": "105856",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "fa9c4b27-8bd8-4958-8261-6eb39412c5bc",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Peelen, Peelen - Middelkoop",
      "adres": "Baronie 39",
      "email": "[email]",
      "postcode": "8245 GM",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Baronie 39",
      "postcode": "8245 GM",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-11-06",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-11-06"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-11-06"
        }
      ],
      "crmdossier_id": "225109",
      "dossiernummer": "225109",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "fa9c4b27-8bd8-4958-8261-6eb39412c5bc",
  "key": "base_import",
  "value_json": {
    "adres": "Baronie 39",
    "klant": "Peelen, Peelen - Middelkoop",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 GM",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-11-06",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-11-06"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-11-06"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "225109",
      "Peelen, Peelen - Middelkoop",
      "Baronie 39",
      "8245 GM",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "225109",
    "dossiernummer": "225109",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "30c04ff0-941a-4bc6-83d9-6971cf176bda",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 14 33",
    "klant": "Lucassen, Raoul (R.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 DD",
    "products": [
      {
        "norm": "",
        "type": "Project",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Huis & Hypotheek Nederland C.O. B.V.",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-01-01"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies Omzetting/Verhoging/Oversluiting",
        "tekendatum": "2020-12-23",
        "productnaam": "Advies Omzetting/Verhoging/Oversluiting",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-12-23"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-12-23"
      },
      {
        "norm": "",
        "type": "Contract",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Uw Hypotheek",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-01-01"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "2020-12-23",
        "productnaam": "",
        "maatschappij": "Uw Hypotheek",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-12-23"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "226686",
      "Lucassen, Raoul (R.)",
      "Punter 14 33",
      "8242 DD",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "Huis & Hypotheek Nederland C.O. B.V.",
      "Project",
      "Eigen kantoor",
      "Dienst",
      "Advies Omzetting/Verhoging/Oversluiting",
      "Dienst BTW vrij",
      "Hypotheekadvies",
      "Uw Hypotheek",
      "Contract"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "226686",
    "dossiernummer": "226686",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7a3a8abe-17be-4413-9ed1-4b54a4e5261e",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ceylan (I.)",
      "adres": "Breehorn 92",
      "email": "[email]",
      "postcode": "8223 CS",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Breehorn 92",
      "postcode": "8223 CS",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-18"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-18"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-18",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-18"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-18",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-18"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "203834.00",
          "status": "Lopend",
          "artikel": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "tekendatum": "25569",
          "productnaam": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "maatschappij": "VENN Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1899792",
          "passeeringangsdatum": "2021-04-14"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "203834.00",
          "status": "Lopend",
          "artikel": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "tekendatum": "25569",
          "productnaam": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "maatschappij": "VENN Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1899792",
          "passeeringangsdatum": "2021-04-14"
        }
      ],
      "crmdossier_id": "224472",
      "dossiernummer": "224472",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "7a3a8abe-17be-4413-9ed1-4b54a4e5261e",
  "key": "base_import",
  "value_json": {
    "adres": "Breehorn 92",
    "klant": "Ceylan (I.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8223 CS",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-18"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-18"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-18",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-18"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-18",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-18"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "203834.00",
        "status": "Lopend",
        "artikel": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "tekendatum": "25569",
        "productnaam": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "maatschappij": "VENN Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1899792",
        "passeeringangsdatum": "2021-04-14"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "203834.00",
        "status": "Lopend",
        "artikel": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "tekendatum": "25569",
        "productnaam": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "maatschappij": "VENN Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1899792",
        "passeeringangsdatum": "2021-04-14"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "224472",
      "Ceylan (I.)",
      "Breehorn 92",
      "8223 CS",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij",
      "1899792",
      "VENN Hypotheken",
      "Hypotheek",
      "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "224472",
    "dossiernummer": "224472",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "42a231c2-fecb-4061-afc0-07df3bc30a67",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Link, Mario (M.G.)",
      "adres": "Andijkstraat 26",
      "email": "[email]",
      "postcode": "8304 CR",
      "woonplaats": "Emmeloord",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Andijkstraat 26",
      "postcode": "8304 CR",
      "woonplaats": "Emmeloord"
    },
    "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": "2020-09-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "175356.00",
          "status": "Lopend",
          "artikel": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2020-11-09"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-C1C08FC3-90A9-4888-B846-2C94CFD48A43|1054(1)",
          "passeeringangsdatum": "2020-12-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2633371",
          "passeeringangsdatum": "2018-05-01"
        }
      ],
      "crmdossier_id": "167486",
      "dossiernummer": "167486",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "42a231c2-fecb-4061-afc0-07df3bc30a67",
  "key": "base_import",
  "value_json": {
    "adres": "Andijkstraat 26",
    "klant": "Link, Mario (M.G.)",
    "plaats": "Emmeloord",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8304 CR",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-09-16"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "175356.00",
        "status": "Lopend",
        "artikel": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2020-11-09"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-C1C08FC3-90A9-4888-B846-2C94CFD48A43|1054(1)",
        "passeeringangsdatum": "2020-12-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2633371",
        "passeeringangsdatum": "2018-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "167486",
      "Link, Mario (M.G.)",
      "Andijkstraat 26",
      "8304 CR",
      "Emmeloord",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Aflossingsvrije Hypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Aflossingsvrij, Annuitair",
      "ISW-C1C08FC3-90A9-4888-B846-2C94CFD48A43|1054(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "2633371",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "167486",
    "dossiernummer": "167486",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "444a8ad7-21a2-44f5-a241-fb61c4454f50",
  "key": "base_import",
  "value_json": {
    "adres": "Hofstede 51",
    "klant": "Wilpen, Berendina van (B), Wilpen, John van (J)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8212 WD",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-10-27"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "212590.00",
        "status": "Lopend",
        "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
        "maatschappij": "IQWOON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3220087-01",
        "passeeringangsdatum": "2021-04-02"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "222949",
      "Wilpen, Berendina van (B), Wilpen, John van (J)",
      "Hofstede 51",
      "8212 WD",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3220087-01",
      "IQWOON",
      "Hypotheek",
      "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "222949",
    "dossiernummer": "222949",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "331e0ef7-b11e-41c5-aacf-271c42540af0",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Mackovic, Borisz (B)",
      "adres": "Kamp 20 51",
      "email": "[email]",
      "postcode": "8225 DT",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kamp 20 51",
      "postcode": "8225 DT",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-5E2941E1-2A77-4855-8A36-44E11A38B056|1073(1)",
          "passeeringangsdatum": "2020-12-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-5E2941E1-2A77-4855-8A36-44E11A38B056|1073(1)",
          "passeeringangsdatum": "2020-12-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "175000.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3213427-01",
          "passeeringangsdatum": "2020-11-27"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "175000.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3213427-01",
          "passeeringangsdatum": "2020-11-27"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-11-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-11-01"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-08-20",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-08-20"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-08-20",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-08-20"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-09-16"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-09-16"
        }
      ],
      "crmdossier_id": "222970",
      "dossiernummer": "222970",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "331e0ef7-b11e-41c5-aacf-271c42540af0",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 20 51",
    "klant": "Mackovic, Borisz (B)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 DT",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-5E2941E1-2A77-4855-8A36-44E11A38B056|1073(1)",
        "passeeringangsdatum": "2020-12-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-5E2941E1-2A77-4855-8A36-44E11A38B056|1073(1)",
        "passeeringangsdatum": "2020-12-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "175000.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3213427-01",
        "passeeringangsdatum": "2020-11-27"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "175000.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3213427-01",
        "passeeringangsdatum": "2020-11-27"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-11-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-11-01"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-08-20",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-08-20"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-08-20",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-08-20"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-09-16"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-09-16"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 10,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "222970",
      "Mackovic, Borisz (B)",
      "Kamp 20 51",
      "8225 DT",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "ISW-5E2941E1-2A77-4855-8A36-44E11A38B056|1073(1)",
      "TAF",
      "Inkomensverzekering",
      "Inkomensbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "3213427-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Vrij Leven Annuïtair",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe hypotheek starter/Aankoop",
      "Dienst BTW vrij",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "222970",
    "dossiernummer": "222970",
    "dossierstatu ... [afgekapt: 106 tekens]

{
  "dossier_id": "fcd[telefoon]ac2-b559-fe2d0bf4142d",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Zoeren (K.)",
      "adres": "Wijngaard 11",
      "email": "[email]",
      "postcode": "8253 LJ",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Wijngaard 11",
      "postcode": "8253 LJ",
      "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": "2020-06-29"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-29",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-29"
        }
      ],
      "crmdossier_id": "214280",
      "dossiernummer": "214280",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "fcd[telefoon]ac2-b559-fe2d0bf4142d",
  "key": "base_import",
  "value_json": {
    "adres": "Wijngaard 11",
    "klant": "Zoeren (K.)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8253 LJ",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-29"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-29",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-29"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "214280",
      "Zoeren (K.)",
      "Wijngaard 11",
      "8253 LJ",
      "Dronten",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "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": "214280",
    "dossiernummer": "214280",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "601e6871-7671-43cf-b85e-0a7f28ad2720",
  "key": "base_import",
  "value_json": {
    "adres": "Jacques Veltmanstraat 39",
    "klant": "Touqan, Abdallah (AT)",
    "plaats": "AMSTERDAM",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1065 EG",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-12-23"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Inboedelverzekering, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Inboedel",
        "tekendatum": "25569",
        "productnaam": "Inboedelverzekering, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Inboedel",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-04-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "500000.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": "3237154-01",
        "passeeringangsdatum": "2021-04-06"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2822303",
        "passeeringangsdatum": "2021-02-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "226944",
      "Touqan, Abdallah (AT)",
      "Jacques Veltmanstraat 39",
      "1065 EG",
      "AMSTERDAM",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Inboedelverzekering, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Inboedel",
      "Aansprakelijkheid, Inboedel, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
      "3237154-01",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair",
      "2822303",
      "TAF",
      "Levensverzekering",
      "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
      "Overlijdensrisicoverzekering",
      "Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "226944",
    "dossiernummer": "226944",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f95749e1-25d2-4c20-bdab-7b24ea7f4c63",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Juliana (H.J.)",
      "adres": "Schiplaan 418",
      "email": "[email]",
      "postcode": "1974 LD",
      "woonplaats": "IJmuiden",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Schiplaan 418",
      "postcode": "1974 LD",
      "woonplaats": "IJmuiden"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-08-20",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-08-20"
        }
      ],
      "crmdossier_id": "221788",
      "dossiernummer": "221788",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f95749e1-25d2-4c20-bdab-7b24ea7f4c63",
  "key": "base_import",
  "value_json": {
    "adres": "Schiplaan 418",
    "klant": "Juliana (H.J.)",
    "plaats": "IJmuiden",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1974 LD",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-08-20",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-08-20"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "221788",
      "Juliana (H.J.)",
      "Schiplaan 418",
      "1974 LD",
      "IJmuiden",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe hypotheek starter/Aankoop",
      "Dienst BTW vrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "221788",
    "dossiernummer": "221788",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "033a3d87-fa9f-42d9-8e8a-6d090ef73aee",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Iwanowa, Anna (A)",
      "adres": "Griend 23 8",
      "email": "[email]",
      "postcode": "8225 RX",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kowalski, Pawel (P.J.)",
      "adres": "Griend 23 8",
      "email": "[email]",
      "postcode": "8225 RX",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-05-26"
        },
        {
          "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": "GIEN.700359",
          "passeeringangsdatum": "2016-02-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-10-06"
        }
      ],
      "crmdossier_id": "209229",
      "dossiernummer": "209229",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "033a3d87-fa9f-42d9-8e8a-6d090ef73aee",
  "key": "base_import",
  "value_json": {
    "adres": "Griend 23 8",
    "klant": "Iwanowa, Anna (A), Kowalski, Pawel (P.J.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 RX",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-05-26"
      },
      {
        "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": "GIEN.700359",
        "passeeringangsdatum": "2016-02-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-10-06"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "209229",
      "Iwanowa, Anna (A), Kowalski, Pawel (P.J.)",
      "Griend 23 8",
      "8225 RX",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "GIEN.700359",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "209229",
    "dossiernummer": "209229",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "97119628-4d53-4d42-b593-fb920650168c",
  "key": "base_import",
  "value_json": {
    "adres": "Regenboogweg 17",
    "klant": "Czypek, Karollina (KM), Machniewski, Piotr Pawel (PP)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1339 AL",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-17"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "213731",
      "Czypek, Karollina (KM), Machniewski, Piotr Pawel (PP)",
      "Regenboogweg 17",
      "1339 AL",
      "Almere",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "213731",
    "dossiernummer": "213731",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "011eaffb-d9df-439b-bde3-20353610f1d0",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Meijer , Dave (D)",
      "adres": "Karveel 34 22",
      "email": "[email]",
      "postcode": "8231 BN",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Rutkowski, Celina (C)",
      "adres": "Karveel 34 22",
      "email": "[email]",
      "postcode": "8231 BN",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-17",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-17"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "226649.00",
          "status": "Lopend",
          "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3197932-01",
          "passeeringangsdatum": "2020-12-14"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-17"
        }
      ],
      "crmdossier_id": "213718",
      "dossiernummer": "213718",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "011eaffb-d9df-439b-bde3-20353610f1d0",
  "key": "base_import",
  "value_json": {
    "adres": "Karveel 34 22",
    "klant": "Meijer , Dave (D), Rutkowski, Celina (C)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 BN",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-17",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-17"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "226649.00",
        "status": "Lopend",
        "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3197932-01",
        "passeeringangsdatum": "2020-12-14"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-17"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "213718",
      "Meijer , Dave (D), Rutkowski, Celina (C)",
      "Karveel 34 22",
      "8231 BN",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij",
      "3197932-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
      "Annuitair",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "213718",
    "dossiernummer": "213718",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}