Database Explorer

{
  "dossier_id": "b0437227-d3d6-4768-9e71-483b0d6fd64a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gogai, Shabnum (SGG)",
      "adres": "Hollands Diepstraat 69",
      "email": "[email]",
      "postcode": "8226 EG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kalloe, Anand (VA)",
      "adres": "Hollands Diepstraat 69",
      "postcode": "8226 EG",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-07-04"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "204283.00",
          "status": "Lopend",
          "artikel": "bijBouwe Aflossingsvrije hypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "bijBouwe Aflossingsvrije hypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
          "maatschappij": "bijBouwe",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3074795-01",
          "passeeringangsdatum": "2018-09-05"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Life Care Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Life Care Overlijdensrisicoverzekering",
          "maatschappij": "Cardif",
          "productsoort": "Gelijkblijvende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "3120979",
          "passeeringangsdatum": "2009-11-01"
        }
      ],
      "crmdossier_id": "171324",
      "dossiernummer": "171324",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "b0437227-d3d6-4768-9e71-483b0d6fd64a",
  "key": "base_import",
  "value_json": {
    "adres": "Hollands Diepstraat 69",
    "klant": "Gogai, Shabnum (SGG), Kalloe, Anand (VA)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 EG",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-07-04"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "204283.00",
        "status": "Lopend",
        "artikel": "bijBouwe Aflossingsvrije hypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "bijBouwe Aflossingsvrije hypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
        "maatschappij": "bijBouwe",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3074795-01",
        "passeeringangsdatum": "2018-09-05"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Life Care Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Life Care Overlijdensrisicoverzekering",
        "maatschappij": "Cardif",
        "productsoort": "Gelijkblijvende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "3120979",
        "passeeringangsdatum": "2009-11-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "171324",
      "Gogai, Shabnum (SGG), Kalloe, Anand (VA)",
      "Hollands Diepstraat 69",
      "8226 EG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3074795-01",
      "bijBouwe",
      "Hypotheek",
      "bijBouwe Aflossingsvrije hypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
      "Aflossingsvrij, Annuitair",
      "3120979",
      "Cardif",
      "Levensverzekering",
      "Life Care Overlijdensrisicoverzekering",
      "Gelijkblijvende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "171324",
    "dossiernummer": "171324",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
  "key": "base_import",
  "value_json": {
    "adres": "Griend 32 62",
    "klant": "Baljé (C.), Mollink, Raymon (R.L.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 SV",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "391000.00",
        "status": "Aanvraag aanvullen (vanuit maatschappij)",
        "artikel": "ASN Bespaarhypotheek Annuïtair, ASN Bespaarhypotheek Annuïtair",
        "tekendatum": "25569",
        "productnaam": "ASN Bespaarhypotheek Annuïtair, ASN Bespaarhypotheek Annuïtair",
        "maatschappij": "ASN Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "21103375",
        "passeeringangsdatum": "2026-05-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "389000.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2329895",
        "passeeringangsdatum": "2026-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "298444",
      "Baljé (C.), Mollink, Raymon (R.L.)",
      "Griend 32 62",
      "8225 SV",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "21103375",
      "ASN Bank",
      "Hypotheek",
      "ASN Bespaarhypotheek Annuïtair, ASN Bespaarhypotheek Annuïtair",
      "Annuitair",
      "2329895",
      "Lloyds Bank",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "298444",
    "dossiernummer": "298444",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f5e4e84a-9466-4ade-bd16-e3318382b45d",
  "key": "base_import",
  "value_json": {
    "adres": "Lathyruspad 10",
    "klant": "Luking, Pietersma (S.)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1338 XL",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "321094.00",
        "status": "Dossier compleet naar MIJ",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2025-12-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "310000.00",
        "status": "Aanvraag aanvullen (vanuit maatschappij)",
        "artikel": "Woonnu Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Woonnu Annuïtair",
        "maatschappij": "Woonnu",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3587585",
        "passeeringangsdatum": "2025-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "293585",
      "Luking, Pietersma (S.)",
      "Lathyruspad 10",
      "1338 XL",
      "Almere",
      "[email]",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "3587585",
      "Woonnu",
      "Woonnu Annuïtair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "293585",
    "dossiernummer": "293585",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3d03e026-3338-4cbe-8667-71b1e1a0b5ac",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Pijnappel, Jan (J.)",
      "adres": "Griend 17 29",
      "email": "[email]",
      "postcode": "8225 RM",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "adres": "Griend 17 29",
      "postcode": "8225 RM",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-09-26"
        }
      ],
      "crmdossier_id": "278978",
      "dossiernummer": "278978",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3d03e026-3338-4cbe-8667-71b1e1a0b5ac",
  "key": "base_import",
  "value_json": {
    "adres": "Griend 17 29",
    "klant": "Pijnappel, Jan (J.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 RM",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-09-26"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "278978",
      "Pijnappel, Jan (J.)",
      "Griend 17 29",
      "8225 RM",
      "Lelystad",
      "[email]",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "278978",
    "dossiernummer": "278978",
    "dossierstatus": "Nieuw",
    "email_partner": "",
    "telefoonnummer": "",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "b555e83c-741b-455e-845b-be5ce49dbe9b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gwizdz (D.J.)",
      "adres": "Nobelweg 1",
      "email": "[email]",
      "postcode": "3899 BN",
      "woonplaats": "Zeewolde"
    },
    "a2": {
      "naam": "Gwizdz -Wojcik",
      "adres": "Nobelweg 1",
      "email": "[email]",
      "postcode": "3899 BN",
      "woonplaats": "Zeewolde"
    },
    "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": "2025-04-08"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2025-04-08"
        }
      ],
      "crmdossier_id": "287260",
      "dossiernummer": "287260",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "b555e83c-741b-455e-845b-be5ce49dbe9b",
  "key": "base_import",
  "value_json": {
    "adres": "Nobelweg 1",
    "klant": "Gwizdz (D.J.), Gwizdz -Wojcik",
    "plaats": "Zeewolde",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "3899 BN",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2025-04-08"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2025-04-08"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "287260",
      "Gwizdz (D.J.), Gwizdz -Wojcik",
      "Nobelweg 1",
      "3899 BN",
      "Zeewolde",
      "[email]",
      "[email]",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "287260",
    "dossiernummer": "287260",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "894bbe0a-8787-422c-b99d-78bc2f64792b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gangapersad (Z.)",
      "adres": "Gerrit van der Veenlaan 240",
      "email": "[email]",
      "postcode": "2552 WL",
      "woonplaats": "'s-Gravenhage",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Tjin A Lim (M.E.)",
      "adres": "Gerrit van der Veenlaan 240",
      "postcode": "2552 WL",
      "woonplaats": "'s-Gravenhage"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEHYA.121423",
          "passeeringangsdatum": "2025-07-15"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2025-05-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2025-07-11"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "199868.00",
          "status": "Offerte/renteaanbod ontvangen",
          "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": "2025-07-15"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "40097730",
          "passeeringangsdatum": "2025-08-01"
        }
      ],
      "crmdossier_id": "288610",
      "dossiernummer": "288610",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "894bbe0a-8787-422c-b99d-78bc2f64792b",
  "key": "base_import",
  "value_json": {
    "adres": "Gerrit van der Veenlaan 240",
    "klant": "Gangapersad (Z.), Tjin A Lim (M.E.)",
    "plaats": "'s-Gravenhage",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "2552 WL",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEHYA.121423",
        "passeeringangsdatum": "2025-07-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2025-05-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2025-07-11"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "199868.00",
        "status": "Offerte/renteaanbod ontvangen",
        "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": "2025-07-15"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "40097730",
        "passeeringangsdatum": "2025-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "288610",
      "Gangapersad (Z.), Tjin A Lim (M.E.)",
      "Gerrit van der Veenlaan 240",
      "2552 WL",
      "'s-Gravenhage",
      "[email]",
      "[telefoon]",
      "GEHYA.121423",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "40097730",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "288610",
    "dossiernummer": "288610",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ea2a2165-0500-4cec-9570-550e84f11142",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Radchuk (A.R.)",
      "adres": "Ringdijk 90",
      "postcode": "8244 BC",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "naam": "Radchuk (P.)",
      "adres": "Ringdijk 90",
      "email": "[email]",
      "postcode": "8244 BC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "355500.00",
          "status": "Aanvraag aanvullen (vanuit maatschappij)",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2025-11-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "371235.00",
          "status": "Aanvraag nieuw",
          "artikel": "HollandWoont Annuitair",
          "tekendatum": "25569",
          "productnaam": "HollandWoont Annuitair",
          "maatschappij": "HollandWoont",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "ISW-6B52B61B-7B6D-4B5A-A054-E722D1606DEE(1)",
          "passeeringangsdatum": "2025-09-01"
        }
      ],
      "crmdossier_id": "288140",
      "dossiernummer": "288140",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ea2a2165-0500-4cec-9570-550e84f11142",
  "key": "base_import",
  "value_json": {
    "adres": "Ringdijk 90",
    "klant": "Radchuk (A.R.), Radchuk (P.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8244 BC",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "355500.00",
        "status": "Aanvraag aanvullen (vanuit maatschappij)",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2025-11-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "371235.00",
        "status": "Aanvraag nieuw",
        "artikel": "HollandWoont Annuitair",
        "tekendatum": "25569",
        "productnaam": "HollandWoont Annuitair",
        "maatschappij": "HollandWoont",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "ISW-6B52B61B-7B6D-4B5A-A054-E722D1606DEE(1)",
        "passeeringangsdatum": "2025-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "288140",
      "Radchuk (A.R.), Radchuk (P.)",
      "Ringdijk 90",
      "8244 BC",
      "Lelystad",
      "[email]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "ISW-6B52B61B-7B6D-4B5A-A054-E722D1606DEE(1)",
      "HollandWoont",
      "HollandWoont Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "288140",
    "dossiernummer": "288140",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "cc191942-3ceb-43f1-9447-d01d148bfc6a",
  "key": "base_import",
  "value_json": {
    "adres": "Malakkastraat 79",
    "klant": "Diaz Garcia",
    "plaats": "'s-Gravenhage",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "2585 SK",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "401000.00",
        "status": "Renteaanbod aan klant verzonden",
        "artikel": "Obvion Woon Hypotheek Annuitair",
        "tekendatum": "25569",
        "productnaam": "Obvion Woon Hypotheek Annuitair",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "759289",
        "passeeringangsdatum": "2026-03-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "423000.00",
        "status": "Rente-aanbod getekend ontvangen",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2026-03-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "391000.00",
        "status": "Aanvraag nieuw",
        "artikel": "Obvion Woon Hypotheek Annuitair",
        "tekendatum": "25569",
        "productnaam": "Obvion Woon Hypotheek Annuitair",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "ISW-6DA635A7-7701-4406-869F-43BD96DDCA85(1)",
        "passeeringangsdatum": "2026-03-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "287278",
      "Diaz Garcia",
      "Malakkastraat 79",
      "2585 SK",
      "'s-Gravenhage",
      "[email]",
      "[telefoon]",
      "759289",
      "Obvion",
      "Hypotheek",
      "Obvion Woon Hypotheek Annuitair",
      "Annuitair",
      "*********",
      "ING Bank",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "ISW-6DA635A7-7701-4406-869F-43BD96DDCA85(1)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "287278",
    "dossiernummer": "287278",
    "dossierstatus": "Nieuw",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "c6406b9a-7e46-4796-8d98-9f789737f132",
  "key": "base_import",
  "value_json": {
    "adres": "Ridderplantsoen 21",
    "klant": "Ali (S.H.N.), Khanum (S.)",
    "plaats": "Utrecht",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "3523 HX",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2025-08-26"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2025-08-26"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "265000.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "maatschappij": "ABN AMRO",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2025-10-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "291749",
      "Ali (S.H.N.), Khanum (S.)",
      "Ridderplantsoen 21",
      "3523 HX",
      "Utrecht",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ABN AMRO",
      "Hypotheek",
      "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "291749",
    "dossiernummer": "291749",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "385fc1c2-0eff-433e-bdca-159b4113921a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Graaf, de (B.B.A.)",
      "adres": "Túnkershôf 13",
      "email": "[email]",
      "postcode": "8574 TD",
      "woonplaats": "Bakhuizen",
      "telefoon_prive": "*********"
    },
    "a2": {
      "naam": "Leijen (J.)",
      "adres": "Túnkershôf 13",
      "email": "[email]",
      "postcode": "8574 TD",
      "woonplaats": "Bakhuizen"
    },
    "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": "2024-06-18"
        }
      ],
      "crmdossier_id": "275645",
      "dossiernummer": "275645",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "385fc1c2-0eff-433e-bdca-159b4113921a",
  "key": "base_import",
  "value_json": {
    "adres": "Túnkershôf 13",
    "klant": "Graaf, de (B.B.A.), Leijen (J.)",
    "plaats": "Bakhuizen",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8574 TD",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-06-18"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "275645",
      "Graaf, de (B.B.A.), Leijen (J.)",
      "Túnkershôf 13",
      "8574 TD",
      "Bakhuizen",
      "[email]",
      "[email]",
      "*********",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "275645",
    "dossiernummer": "275645",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "*********",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5efa3b6c-6a51-4314-a025-c044b671ecd3",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kahle (F)",
      "adres": "Wold 13 19",
      "email": "[email]",
      "postcode": "8225 BV",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Wold 13 19",
      "postcode": "8225 BV",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Auto",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Auto",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Personenauto",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-11-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "211150.00",
          "status": "Lopend",
          "artikel": "ASR Annuïteiten, ASR Annuïteiten, ASR Annuïteiten",
          "tekendatum": "25569",
          "productnaam": "ASR Annuïteiten, ASR Annuïteiten, ASR Annuïteiten",
          "maatschappij": "ASR Hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2002386",
          "passeeringangsdatum": "2021-12-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "140450.00",
          "status": "Gepasseerd",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.572.514",
          "passeeringangsdatum": "2017-01-10"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-12-12"
        },
        {
          "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.615869",
          "passeeringangsdatum": "2017-01-01"
        }
      ],
      "crmdossier_id": "144999",
      "dossiernummer": "144999",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "9370bf61-e2bd-4aa1-b296-b60509b8d863",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bos, Thea (MC)",
      "adres": "Horst 26 09",
      "postcode": "8225 PA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Horst 26 09",
      "postcode": "8225 PA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "114400.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2015-02-16"
        }
      ],
      "crmdossier_id": "95189",
      "dossiernummer": "95189",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5efa3b6c-6a51-4314-a025-c044b671ecd3",
  "key": "base_import",
  "value_json": {
    "adres": "Wold 13 19",
    "klant": "Kahle (F)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 BV",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Auto",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Auto",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Personenauto",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-11-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "211150.00",
        "status": "Lopend",
        "artikel": "ASR Annuïteiten, ASR Annuïteiten, ASR Annuïteiten",
        "tekendatum": "25569",
        "productnaam": "ASR Annuïteiten, ASR Annuïteiten, ASR Annuïteiten",
        "maatschappij": "ASR Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2002386",
        "passeeringangsdatum": "2021-12-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "140450.00",
        "status": "Gepasseerd",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.572.514",
        "passeeringangsdatum": "2017-01-10"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2016-12-12"
      },
      {
        "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.615869",
        "passeeringangsdatum": "2017-01-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "144999",
      "Kahle (F)",
      "Wold 13 19",
      "8225 BV",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Auto",
      "Aansprakelijkheid, Inboedel, Opstal, Personenauto",
      "2002386",
      "ASR Hypotheken",
      "Hypotheek",
      "ASR Annuïteiten, ASR Annuïteiten, ASR Annuïteiten",
      "Annuitair",
      "1.572.514",
      "Lloyds Bank",
      "Lloyds Annuiteitenhypotheek",
      "Eigen kantoor",
      "Hypotheekadvies",
      "GEWI.615869",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "144999",
    "dossiernummer": "144999",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "b8fb12b0-5dfd-4453-b787-4d2d51da21bf",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Verwer, Vincent (V)",
      "adres": "Twente 1",
      "email": "[email]",
      "postcode": "8245 CW",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Twente 1",
      "email": "[email]",
      "postcode": "8245 CW",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "146661175385",
          "passeeringangsdatum": "2016-07-29"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-05-29"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "325406.00",
          "status": "Lopend",
          "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 Aflossingsvrij (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 Aflossingsvrij (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3517137",
          "passeeringangsdatum": "2024-10-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-42",
          "passeeringangsdatum": "2016-08-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-07-01"
        }
      ],
      "crmdossier_id": "126979",
      "dossiernummer": "126979",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "b8fb12b0-5dfd-4453-b787-4d2d51da21bf",
  "key": "base_import",
  "value_json": {
    "adres": "Twente 1",
    "klant": "Verwer, Vincent (V)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 CW",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "146661175385",
        "passeeringangsdatum": "2016-07-29"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-05-29"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "325406.00",
        "status": "Lopend",
        "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 Aflossingsvrij (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 Aflossingsvrij (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3517137",
        "passeeringangsdatum": "2024-10-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-42",
        "passeeringangsdatum": "2016-08-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-07-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "126979",
      "Verwer, Vincent (V)",
      "Twente 1",
      "8245 CW",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "146661175385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
      "Aansprakelijkheid, Inboedel, Opstal",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3517137",
      "Argenta hypotheken",
      "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 Aflossingsvrij (Argenta Special Line Hypotheek)",
      "Aflossingsvrij, Annuitair",
      "[telefoon]-42",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Opstal, Inboedel, Aansprakelijkheid"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "126979",
    "dossiernummer": "126979",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "4e5b560d-ad32-41ae-a8a9-3da30a4a96a8",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bierman (G.N.)",
      "email": "[email]",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Jansen (J.)",
      "email": "[email]",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "369025.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2024-01-30"
        }
      ],
      "crmdossier_id": "259234",
      "dossiernummer": "259234",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "4e5b560d-ad32-41ae-a8a9-3da30a4a96a8",
  "key": "base_import",
  "value_json": {
    "adres": "",
    "klant": "Bierman (G.N.), Jansen (J.)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "369025.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2024-01-30"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "259234",
      "Bierman (G.N.), Jansen (J.)",
      "LELYSTAD",
      "[email]",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "259234",
    "dossiernummer": "259234",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "488705d6-aa60-48c6-8690-93d583c64d4f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Jong, Vincent de (V.C.P.)",
      "adres": "Kamp 33 38",
      "email": "[email]",
      "postcode": "8225 HC",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kamp 33 38",
      "email": "[email]",
      "postcode": "8225 HC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-7D190BBD-CF9D-4677-9979-1400F843788F|1442(1)",
          "passeeringangsdatum": "2024-12-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "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": "HL0252164",
          "passeeringangsdatum": "2024-12-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "375000.00",
          "status": "Lopend",
          "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": "2024-12-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-0B4B112D-84B5-41EF-952A-0DC4DEDC0A19|1442(1)",
          "passeeringangsdatum": "2024-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-07-29"
        }
      ],
      "crmdossier_id": "276964",
      "dossiernummer": "276964",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "488705d6-aa60-48c6-8690-93d583c64d4f",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 33 38",
    "klant": "Jong, Vincent de (V.C.P.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 HC",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-7D190BBD-CF9D-4677-9979-1400F843788F|1442(1)",
        "passeeringangsdatum": "2024-12-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "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": "HL0252164",
        "passeeringangsdatum": "2024-12-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "375000.00",
        "status": "Lopend",
        "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": "2024-12-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-0B4B112D-84B5-41EF-952A-0DC4DEDC0A19|1442(1)",
        "passeeringangsdatum": "2024-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-07-29"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "276964",
      "Jong, Vincent de (V.C.P.)",
      "Kamp 33 38",
      "8225 HC",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "ISW-7D190BBD-CF9D-4677-9979-1400F843788F|1442(1)",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "HL0252164",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "ISW-0B4B112D-84B5-41EF-952A-0DC4DEDC0A19|1442(1)",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "276964",
    "dossiernummer": "276964",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e60b8cb9-3547-479b-ad7c-5d05f2d72420",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Doorenbosch-Oornink (H W)",
      "adres": "Marderhoek 49",
      "email": "[email]",
      "postcode": "8223 XC",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Marderhoek 49",
      "postcode": "8223 XC",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-09-01"
        }
      ],
      "crmdossier_id": "96884",
      "dossiernummer": "96884",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e60b8cb9-3547-479b-ad7c-5d05f2d72420",
  "key": "base_import",
  "value_json": {
    "adres": "Marderhoek 49",
    "klant": "Doorenbosch-Oornink (H W)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8223 XC",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "96884",
      "Doorenbosch-Oornink (H W)",
      "Marderhoek 49",
      "8223 XC",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "96884",
    "dossiernummer": "96884",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3332a158-09c5-4c3a-b838-c42d483cc2ad",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Wegrzyn, Bartosz (BD)",
      "adres": "Horst 11 3",
      "email": "[email]",
      "postcode": "8225 LA",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Horst 11 3",
      "postcode": "8225 LA",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal",
          "tekendatum": "25569",
          "productnaam": "Opstal",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-09-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": "2452558",
          "passeeringangsdatum": "2017-08-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "161377575385",
          "passeeringangsdatum": "2017-09-15"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "181800.00",
          "status": "Gepasseerd",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2017-09-15"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-07-26"
        }
      ],
      "crmdossier_id": "155028",
      "dossiernummer": "155028",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3332a158-09c5-4c3a-b838-c42d483cc2ad",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 11 3",
    "klant": "Wegrzyn, Bartosz (BD)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 LA",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal",
        "tekendatum": "25569",
        "productnaam": "Opstal",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-09-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": "2452558",
        "passeeringangsdatum": "2017-08-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "161377575385",
        "passeeringangsdatum": "2017-09-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "181800.00",
        "status": "Gepasseerd",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2017-09-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-07-26"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "155028",
      "Wegrzyn, Bartosz (BD)",
      "Horst 11 3",
      "8225 LA",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal",
      "2452558",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "161377575385",
      "Voogd & Voogd",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
      "Aansprakelijkheid, Inboedel, Opstal",
      "*********",
      "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": "155028",
    "dossiernummer": "155028",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "766f99fe-8325-46a6-b7c3-155c7d32522b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Canadas Garcia (A.)",
      "adres": "Dukatenburg 7234",
      "email": "[email]",
      "postcode": "3437 AE",
      "woonplaats": "Nieuwegein",
      "telefoon_prive": "0034626679148"
    },
    "a2": {
      "adres": "Dukatenburg 7234",
      "email": "[email]",
      "postcode": "3437 AE",
      "woonplaats": "Nieuwegein"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-575D5660-AF63-4A82-A013-E603FFF6AC49|1402(1)",
          "passeeringangsdatum": "2024-03-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-1B4AD30F-B232-471E-A625-48FB65650742|1402(1)",
          "passeeringangsdatum": "2024-03-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "430000.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2024-03-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag in behandeling",
          "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": "HL0201949",
          "passeeringangsdatum": "2024-03-01"
        }
      ],
      "crmdossier_id": "267847",
      "dossiernummer": "267847",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "766f99fe-8325-46a6-b7c3-155c7d32522b",
  "key": "base_import",
  "value_json": {
    "adres": "Dukatenburg 7234",
    "klant": "Canadas Garcia (A.)",
    "plaats": "Nieuwegein",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "3437 AE",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-575D5660-AF63-4A82-A013-E603FFF6AC49|1402(1)",
        "passeeringangsdatum": "2024-03-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-1B4AD30F-B232-471E-A625-48FB65650742|1402(1)",
        "passeeringangsdatum": "2024-03-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "430000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2024-03-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag in behandeling",
        "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": "HL0201949",
        "passeeringangsdatum": "2024-03-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "267847",
      "Canadas Garcia (A.)",
      "Dukatenburg 7234",
      "3437 AE",
      "Nieuwegein",
      "[email]",
      "[email]",
      "0034626679148",
      "ISW-575D5660-AF63-4A82-A013-E603FFF6AC49|1402(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "ISW-1B4AD30F-B232-471E-A625-48FB65650742|1402(1)",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "HL0201949",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "267847",
    "dossiernummer": "267847",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "0034626679148",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "49de38ee-2d2d-4fae-b549-e34824cce012",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Marques da Silva (J A)",
      "adres": "Hollands Diepstraat 59",
      "email": "[email]",
      "postcode": "8226 EG",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Hollands Diepstraat 59",
      "postcode": "8226 EG",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-11-27"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "166418605385",
          "passeeringangsdatum": "2018-01-05"
        },
        {
          "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": "2496830",
          "passeeringangsdatum": "2017-12-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "142300.00",
          "status": "Gepasseerd",
          "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "maatschappij": "ABN AMRO",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "700.434.762",
          "passeeringangsdatum": "2018-01-05"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "33655.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "240.835.000",
          "passeeringangsdatum": "2018-01-05"
        }
      ],
      "crmdossier_id": "159095",
      "dossiernummer": "159095",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "49de38ee-2d2d-4fae-b549-e34824cce012",
  "key": "base_import",
  "value_json": {
    "adres": "Hollands Diepstraat 59",
    "klant": "Marques da Silva (J A)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 EG",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-11-27"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "166418605385",
        "passeeringangsdatum": "2018-01-05"
      },
      {
        "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": "2496830",
        "passeeringangsdatum": "2017-12-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "142300.00",
        "status": "Gepasseerd",
        "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "maatschappij": "ABN AMRO",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "700.434.762",
        "passeeringangsdatum": "2018-01-05"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "33655.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "240.835.000",
        "passeeringangsdatum": "2018-01-05"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "159095",
      "Marques da Silva (J A)",
      "Hollands Diepstraat 59",
      "8226 EG",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "Eigen kantoor",
      "Hypotheekadvies",
      "166418605385",
      "Voogd & Voogd",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
      "2496830",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "700.434.762",
      "ABN AMRO",
      "Hypotheek",
      "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
      "Annuitair",
      "240.835.000",
      "SVn",
      "Starterslening"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "159095",
    "dossiernummer": "159095",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3da04623-4fbb-42bd-ad37-6805f15997b5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Canadas Garcia (A.)",
      "adres": "Waalstraat 125",
      "email": "[email]",
      "postcode": "1316 EV",
      "woonplaats": "ALMERE",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Waalstraat 125",
      "postcode": "1316 EV",
      "woonplaats": "ALMERE"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2024-01-30"
        }
      ],
      "crmdossier_id": "270340",
      "dossiernummer": "270340",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3da04623-4fbb-42bd-ad37-6805f15997b5",
  "key": "base_import",
  "value_json": {
    "adres": "Waalstraat 125",
    "klant": "Canadas Garcia (A.)",
    "plaats": "ALMERE",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1316 EV",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2024-01-30"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "270340",
      "Canadas Garcia (A.)",
      "Waalstraat 125",
      "1316 EV",
      "ALMERE",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "270340",
    "dossiernummer": "270340",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f38cf1db-9bf2-4338-89cf-56063b24acba",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Rodenburg, Brandon (B.)",
      "adres": "Vuurvlinder 3",
      "email": "[email]",
      "postcode": "3892 GC",
      "woonplaats": "Zeewolde",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Schroen, Lucilla (L.A. .)",
      "adres": "Vuurvlinder 3",
      "postcode": "3892 GC",
      "woonplaats": "Zeewolde"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "345365.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": "2024-09-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-05-14"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-11-06"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2671097",
          "passeeringangsdatum": "2019-02-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-2FA14DB0-6DCE-41D5-B34E-C8BF4D9714D1|856(1)",
          "passeeringangsdatum": "2019-01-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-4C8C21D9-D9A0-4D46-AD15-13F8D28B0F40|856(1)",
          "passeeringangsdatum": "2019-12-01"
        }
      ],
      "crmdossier_id": "178300",
      "dossiernummer": "178300",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f38cf1db-9bf2-4338-89cf-56063b24acba",
  "key": "base_import",
  "value_json": {
    "adres": "Vuurvlinder 3",
    "klant": "Rodenburg, Brandon (B.), Schroen, Lucilla (L.A. .)",
    "plaats": "Zeewolde",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "3892 GC",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "345365.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": "2024-09-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-05-14"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-11-06"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2671097",
        "passeeringangsdatum": "2019-02-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-2FA14DB0-6DCE-41D5-B34E-C8BF4D9714D1|856(1)",
        "passeeringangsdatum": "2019-01-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-4C8C21D9-D9A0-4D46-AD15-13F8D28B0F40|856(1)",
        "passeeringangsdatum": "2019-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "178300",
      "Rodenburg, Brandon (B.), Schroen, Lucilla (L.A. .)",
      "Vuurvlinder 3",
      "3892 GC",
      "Zeewolde",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2671097",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "ISW-2FA14DB0-6DCE-41D5-B34E-C8BF4D9714D1|856(1)",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "ISW-4C8C21D9-D9A0-4D46-AD15-13F8D28B0F40|856(1)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "178300",
    "dossiernummer": "178300",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "8c1ebff2-fe2a-4a79-bf4a-b14b1dddceaa",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Peluso (D.)",
      "adres": "Jan Bernardusstraat 242L",
      "email": "[email]",
      "postcode": "1091 TT",
      "woonplaats": "AMSTERDAM",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Jan Bernardusstraat 242L",
      "postcode": "1091 TT",
      "woonplaats": "AMSTERDAM"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "385000.00",
          "status": "Aanvraag aanvullen (vanuit maatschappij)",
          "artikel": "Annuïteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Annuïteiten Hypotheek",
          "maatschappij": "Robuust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3491756",
          "passeeringangsdatum": "2023-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2023-11-02"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "390000.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2023-12-01"
        }
      ],
      "crmdossier_id": "266670",
      "dossiernummer": "266670",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "8c1ebff2-fe2a-4a79-bf4a-b14b1dddceaa",
  "key": "base_import",
  "value_json": {
    "adres": "Jan Bernardusstraat 242L",
    "klant": "Peluso (D.)",
    "plaats": "AMSTERDAM",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1091 TT",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "385000.00",
        "status": "Aanvraag aanvullen (vanuit maatschappij)",
        "artikel": "Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Annuïteiten Hypotheek",
        "maatschappij": "Robuust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3491756",
        "passeeringangsdatum": "2023-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2023-11-02"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "390000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2023-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "266670",
      "Peluso (D.)",
      "Jan Bernardusstraat 242L",
      "1091 TT",
      "AMSTERDAM",
      "[email]",
      "[telefoon]",
      "3491756",
      "Robuust",
      "Hypotheek",
      "Annuïteiten Hypotheek",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "266670",
    "dossiernummer": "266670",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "28e5f14e-b7e2-4afa-a4c8-926d3e35ffe6",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Heuvel, van den (A.M.P.)",
      "adres": "Teakhout 278",
      "email": "[email]",
      "postcode": "1507 EM",
      "woonplaats": "Zaandam",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kroes (V.)",
      "adres": "Teakhout 278",
      "email": "[email]",
      "postcode": "1507 EM",
      "woonplaats": "Zaandam"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "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": "HL0223067",
          "passeeringangsdatum": "2024-09-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-03-07"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "494000.00",
          "status": "Lopend",
          "artikel": "VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "tekendatum": "25569",
          "productnaam": "VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "maatschappij": "VENN Hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2198420",
          "passeeringangsdatum": "2024-05-01"
        }
      ],
      "crmdossier_id": "271855",
      "dossiernummer": "271855",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f65c2846-5d1e-4205-88d5-d34ad7dc9bbc",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Duis (H.M.D.)",
      "adres": "Ranonkelstraat 23",
      "email": "[email]",
      "postcode": "6942 VX",
      "woonplaats": "Didam",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Santen, van (D.)",
      "adres": "Ranonkelstraat 23",
      "email": "[email]",
      "postcode": "6942 VX",
      "woonplaats": "Didam"
    },
    "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": "2024-08-13"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-15636BCD-1086-4157-8103-A8B28A089C51|1452(1)",
          "passeeringangsdatum": "2024-12-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "370000.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2233012",
          "passeeringangsdatum": "2024-10-11"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-C04982E4-7432-4934-8EA3-3D32C44A85B2|1452(1)",
          "passeeringangsdatum": "2024-12-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag in behandeling",
          "artikel": "TAF Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "3075932",
          "passeeringangsdatum": "2024-11-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2024-10-03"
        }
      ],
      "crmdossier_id": "277407",
      "dossiernummer": "277407",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f65c2846-5d1e-4205-88d5-d34ad7dc9bbc",
  "key": "base_import",
  "value_json": {
    "adres": "Ranonkelstraat 23",
    "klant": "Duis (H.M.D.), Santen, van (D.)",
    "plaats": "Didam",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "6942 VX",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-08-13"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-15636BCD-1086-4157-8103-A8B28A089C51|1452(1)",
        "passeeringangsdatum": "2024-12-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "370000.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2233012",
        "passeeringangsdatum": "2024-10-11"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-C04982E4-7432-4934-8EA3-3D32C44A85B2|1452(1)",
        "passeeringangsdatum": "2024-12-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag in behandeling",
        "artikel": "TAF Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "3075932",
        "passeeringangsdatum": "2024-11-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2024-10-03"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "277407",
      "Duis (H.M.D.), Santen, van (D.)",
      "Ranonkelstraat 23",
      "6942 VX",
      "Didam",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-15636BCD-1086-4157-8103-A8B28A089C51|1452(1)",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "2233012",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "ISW-C04982E4-7432-4934-8EA3-3D32C44A85B2|1452(1)",
      "3075932",
      "Levensverzekering",
      "TAF Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "277407",
    "dossiernummer": "277407",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "dd726af9-3692-40b6-b51e-c5408245b693",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Hoebe, Nils (N.J.M.)",
      "adres": "Baarsstraat 66",
      "email": "[email]",
      "postcode": "1075 RX",
      "woonplaats": "Amsterdam",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kuin, Juliette (J.)",
      "adres": "Baarsstraat 66",
      "email": "[email]",
      "postcode": "1075 RX",
      "woonplaats": "Amsterdam"
    },
    "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": "2025-01-10"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "389600.00",
          "status": "Offerte/renteaanbod ontvangen",
          "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": "2025-08-05"
        }
      ],
      "crmdossier_id": "282816",
      "dossiernummer": "282816",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "dd726af9-3692-40b6-b51e-c5408245b693",
  "key": "base_import",
  "value_json": {
    "adres": "Baarsstraat 66",
    "klant": "Hoebe, Nils (N.J.M.), Kuin, Juliette (J.)",
    "plaats": "Amsterdam",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1075 RX",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2025-01-10"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "389600.00",
        "status": "Offerte/renteaanbod ontvangen",
        "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": "2025-08-05"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "282816",
      "Hoebe, Nils (N.J.M.), Kuin, Juliette (J.)",
      "Baarsstraat 66",
      "1075 RX",
      "Amsterdam",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "282816",
    "dossiernummer": "282816",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f2992a82-652e-4b7b-96d3-143c7af98644",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Schouwenaar (R.F.R.)",
      "adres": "Schoener 47 2",
      "email": "[email]",
      "postcode": "8243 XP",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Schoener 47 2",
      "postcode": "8243 XP",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2024-01-23"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "404000.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2024-01-25"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2023-11-21"
        }
      ],
      "crmdossier_id": "265445",
      "dossiernummer": "265445",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "28e5f14e-b7e2-4afa-a4c8-926d3e35ffe6",
  "key": "base_import",
  "value_json": {
    "adres": "Teakhout 278",
    "klant": "Heuvel, van den (A.M.P.), Kroes (V.)",
    "plaats": "Zaandam",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1507 EM",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "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": "HL0223067",
        "passeeringangsdatum": "2024-09-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-03-07"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "494000.00",
        "status": "Lopend",
        "artikel": "VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "tekendatum": "25569",
        "productnaam": "VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "maatschappij": "VENN Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2198420",
        "passeeringangsdatum": "2024-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "271855",
      "Heuvel, van den (A.M.P.), Kroes (V.)",
      "Teakhout 278",
      "1507 EM",
      "Zaandam",
      "[email]",
      "[email]",
      "[telefoon]",
      "HL0223067",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2198420",
      "VENN Hypotheken",
      "Hypotheek",
      "VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "271855",
    "dossiernummer": "271855",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f2992a82-652e-4b7b-96d3-143c7af98644",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 47 2",
    "klant": "Schouwenaar (R.F.R.)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 XP",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2024-01-23"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "404000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2024-01-25"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2023-11-21"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "265445",
      "Schouwenaar (R.F.R.)",
      "Schoener 47 2",
      "8243 XP",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "*********",
      "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": "265445",
    "dossiernummer": "265445",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "bf41530c-4067-4382-8b6b-cabc003975dc",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Boiten, Bob (WGJ)",
      "adres": "Sneeuwklokjesveld 10",
      "email": "[email]",
      "postcode": "8255 JT",
      "woonplaats": "Swifterbant",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Boiten-de Burger, Ymke (Y.)",
      "adres": "Sneeuwklokjesveld 10",
      "postcode": "8255 JT",
      "woonplaats": "Swifterbant"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "177406.00",
          "status": "Lopend",
          "artikel": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
          "tekendatum": "25569",
          "productnaam": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
          "maatschappij": "Allianz",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3328589-01",
          "passeeringangsdatum": "2022-05-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "278200.00",
          "status": "Lopend",
          "artikel": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
          "tekendatum": "25569",
          "productnaam": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
          "maatschappij": "Allianz",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3514907",
          "passeeringangsdatum": "2024-06-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-08-25"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "GewoonIdee Hypotheek Overlijdensrisicoverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Hypotheek Overlijdensrisicoverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEHYA.118945",
          "passeeringangsdatum": "2024-09-30"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "106500.00",
          "status": "Gepasseerd",
          "artikel": "Hypotrust Annuiteit (Woon Bewust)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Annuiteit (Woon Bewust)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2882743",
          "passeeringangsdatum": "2016-12-15"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.613181",
          "passeeringangsdatum": "2016-10-10"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-74A25E52-2EFC-49F3-B958-D65ED6E113FD|1449(1)",
          "passeeringangsdatum": "2024-11-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-E6F4404C-AA7B-49FD-9901-574BC0F2120A|1449(1)",
          "passeeringangsdatum": "2024-11-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "28514.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "234.712.000",
          "passeeringangsdatum": "2016-12-15"
        }
      ],
      "crmdossier_id": "128491",
      "dossiernummer": "128491",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "bf41530c-4067-4382-8b6b-cabc003975dc",
  "key": "base_import",
  "value_json": {
    "adres": "Sneeuwklokjesveld 10",
    "klant": "Boiten, Bob (WGJ), Boiten-de Burger, Ymke (Y.)",
    "plaats": "Swifterbant",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8255 JT",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "177406.00",
        "status": "Lopend",
        "artikel": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
        "tekendatum": "25569",
        "productnaam": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
        "maatschappij": "Allianz",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3328589-01",
        "passeeringangsdatum": "2022-05-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "278200.00",
        "status": "Lopend",
        "artikel": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
        "tekendatum": "25569",
        "productnaam": "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
        "maatschappij": "Allianz",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3514907",
        "passeeringangsdatum": "2024-06-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-08-25"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "GewoonIdee Hypotheek Overlijdensrisicoverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Hypotheek Overlijdensrisicoverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEHYA.118945",
        "passeeringangsdatum": "2024-09-30"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "106500.00",
        "status": "Gepasseerd",
        "artikel": "Hypotrust Annuiteit (Woon Bewust)",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Annuiteit (Woon Bewust)",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2882743",
        "passeeringangsdatum": "2016-12-15"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.613181",
        "passeeringangsdatum": "2016-10-10"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-74A25E52-2EFC-49F3-B958-D65ED6E113FD|1449(1)",
        "passeeringangsdatum": "2024-11-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-E6F4404C-AA7B-49FD-9901-574BC0F2120A|1449(1)",
        "passeeringangsdatum": "2024-11-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "28514.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "234.712.000",
        "passeeringangsdatum": "2016-12-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 9,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "128491",
      "Boiten, Bob (WGJ), Boiten-de Burger, Ymke (Y.)",
      "Sneeuwklokjesveld 10",
      "8255 JT",
      "Swifterbant",
      "[email]",
      "[telefoon]",
      "3328589-01",
      "Allianz",
      "Hypotheek",
      "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
      "Annuitair",
      "3514907",
      "Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair, Allianz Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "GEHYA.118945",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Hypotheek Overlijdensrisicoverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen",
      "2882743",
      "Hypotrust",
      "Hypotrust Annuiteit (Woon Bewust)",
      "GEWI.613181",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "ISW-74A25E52-2EFC-49F3-B958-D65ED6E113FD|1449(1)", ... [afgekapt: 581 tekens]

{
  "dossier_id": "af92f86c-04ba-49a3-9725-733945bd399b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Goes, Sander (S.)",
      "adres": "Parkhaven 127",
      "email": "[email]",
      "postcode": "8242 PH",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Parkhaven 127",
      "postcode": "8242 PH",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "461000.00",
          "status": "Lopend",
          "artikel": "Woonnu Annuïtair, Woonnu Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Woonnu Annuïtair, Woonnu Annuïtair",
          "maatschappij": "Woonnu",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3530704",
          "passeeringangsdatum": "2024-10-30"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag in behandeling",
          "artikel": "Callas Woonlastenverzekering - AO/WW",
          "tekendatum": "25569",
          "productnaam": "Callas Woonlastenverzekering - AO/WW",
          "maatschappij": "Credit Life",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "5001352976",
          "passeeringangsdatum": "2024-10-30"
        },
        {
          "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": "2024-08-23"
        }
      ],
      "crmdossier_id": "275786",
      "dossiernummer": "275786",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}