Database Explorer

{
  "dossier_id": "ec3369d9-6e59-43e1-8613-f07beb5e81cb",
  "key": "base_import",
  "value_json": {
    "adres": "Lange Omgang 38",
    "klant": "Graver, Nicole (N.D.)",
    "plaats": "Bant",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8314 AL",
    "products": [
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "PL 120 mnd",
        "tekendatum": "25569",
        "productnaam": "PL 120 mnd",
        "maatschappij": "DEFAM B.V.",
        "productsoort": "Persoonlijke lening",
        "factuurbedrag": "",
        "offertenummer": "60951540",
        "passeeringangsdatum": "2018-08-16"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-06-08"
      },
      {
        "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": "2642614",
        "passeeringangsdatum": "2018-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "125000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2018-08-06"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "131071",
      "Graver, Nicole (N.D.)",
      "Lange Omgang 38",
      "8314 AL",
      "Bant",
      "[email]",
      "[telefoon]",
      "60951540",
      "DEFAM B.V.",
      "Consumptief krediet",
      "PL 120 mnd",
      "Persoonlijke lening",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2642614",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "131071",
    "dossiernummer": "131071",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "990eb55d-957d-418f-9c1a-b0624b5115c1",
  "key": "base_import",
  "value_json": {
    "adres": "Barbaragaarde 48",
    "klant": "Wijs, Yvonne de (Y)",
    "plaats": "Bussum",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1403 JM",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "149500.00",
        "status": "Gepasseerd",
        "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2862559",
        "passeeringangsdatum": "2016-04-08"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-90",
        "passeeringangsdatum": "2016-04-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Woonlastenverzekering",
        "tekendatum": "25569",
        "productnaam": "Credit Life Woonlastenverzekering",
        "maatschappij": "Credit Life",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "5001088139",
        "passeeringangsdatum": "2016-06-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "121657",
      "Wijs, Yvonne de (Y)",
      "Barbaragaarde 48",
      "1403 JM",
      "Bussum",
      "[email]",
      "[telefoon]",
      "2862559",
      "Argenta (via Adaxio)",
      "Hypotheek",
      "Annuïteitenhypotheek (Argenta Hypotheek)",
      "Annuitair",
      "[telefoon]-90",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "5001088139",
      "Credit Life",
      "Inkomensverzekering",
      "Credit Life Woonlastenverzekering",
      "Woonlastenverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "121657",
    "dossiernummer": "121657",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "69804b7c-bbf9-444c-b25d-81a5d0c9dff3",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Teunissen, Robin (R)",
      "adres": "De Stelling 10 25",
      "email": "[email]",
      "postcode": "8232 EA",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Stelling 10 25",
      "postcode": "8232 EA",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "ISW-6FA453DE-DBFF-495B-BD7B-245A4D296E1E(2)",
          "passeeringangsdatum": "2016-02-01"
        }
      ],
      "crmdossier_id": "119921",
      "dossiernummer": "119921",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "69804b7c-bbf9-444c-b25d-81a5d0c9dff3",
  "key": "base_import",
  "value_json": {
    "adres": "De Stelling 10 25",
    "klant": "Teunissen, Robin (R)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 EA",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "ISW-6FA453DE-DBFF-495B-BD7B-245A4D296E1E(2)",
        "passeeringangsdatum": "2016-02-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "119921",
      "Teunissen, Robin (R)",
      "De Stelling 10 25",
      "8232 EA",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "ISW-6FA453DE-DBFF-495B-BD7B-245A4D296E1E(2)",
      "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": "119921",
    "dossiernummer": "119921",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "cfa15bdf-aa1a-4a70-b525-191cff418e38",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Maluj (A.K.)",
      "adres": "Kamp 16 58",
      "postcode": "8225 DK",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 16 62 80 11"
    },
    "a2": {
      "naam": "Ostep (K.)",
      "adres": "Kamp 16 58",
      "postcode": "8225 DK",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "150478.00",
          "status": "Lopend",
          "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente)), ING Aflossingsvrije Hypotheek (Reguliere hypotheek (met Voordeelrente))",
          "tekendatum": "25569",
          "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente)), ING Aflossingsvrije Hypotheek (Reguliere hypotheek (met Voordeelrente))",
          "maatschappij": "ING Bank",
          "productsoort": "Aflossingsvrij, Bankspaar",
          "factuurbedrag": "",
          "offertenummer": "M 090-930025",
          "passeeringangsdatum": "2012-01-11"
        }
      ],
      "crmdossier_id": "99878",
      "dossiernummer": "99878",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "cfa15bdf-aa1a-4a70-b525-191cff418e38",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 16 58",
    "klant": "Maluj (A.K.), Ostep (K.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 DK",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "150478.00",
        "status": "Lopend",
        "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente)), ING Aflossingsvrije Hypotheek (Reguliere hypotheek (met Voordeelrente))",
        "tekendatum": "25569",
        "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente)), ING Aflossingsvrije Hypotheek (Reguliere hypotheek (met Voordeelrente))",
        "maatschappij": "ING Bank",
        "productsoort": "Aflossingsvrij, Bankspaar",
        "factuurbedrag": "",
        "offertenummer": "M 090-930025",
        "passeeringangsdatum": "2012-01-11"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99878",
      "Maluj (A.K.), Ostep (K.)",
      "Kamp 16 58",
      "8225 DK",
      "Lelystad",
      "06 - 16 62 80 11",
      "M 090-930025",
      "ING Bank",
      "Hypotheek",
      "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek (met Voordeelrente)), ING Aflossingsvrije Hypotheek (Reguliere hypotheek (met Voordeelrente))",
      "Aflossingsvrij, Bankspaar"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99878",
    "dossiernummer": "99878",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06 - 16 62 80 11",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "cd573434-6f64-4bf3-98a8-945f3c7c7d24",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Pietersma (J.R.)",
      "adres": "De Grutto 63",
      "email": "[email]",
      "postcode": "8251 XR",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Grutto 63",
      "postcode": "8251 XR",
      "woonplaats": "Dronten"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2678454",
          "passeeringangsdatum": "2019-03-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "200000.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "2250.00",
          "offertenummer": "1734385",
          "passeeringangsdatum": "2019-04-29"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "32631.00",
          "status": "Rente-aanbod getekend ontvangen",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1734385",
          "passeeringangsdatum": "2022-12-01"
        },
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "2458.67",
          "offertenummer": "",
          "passeeringangsdatum": "2019-01-18"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "18360.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1734385",
          "passeeringangsdatum": "2023-03-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-12-11"
        }
      ],
      "crmdossier_id": "99644",
      "dossiernummer": "99644",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "cd573434-6f64-4bf3-98a8-945f3c7c7d24",
  "key": "base_import",
  "value_json": {
    "adres": "De Grutto 63",
    "klant": "Pietersma (J.R.)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8251 XR",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2678454",
        "passeeringangsdatum": "2019-03-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "200000.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "2250.00",
        "offertenummer": "1734385",
        "passeeringangsdatum": "2019-04-29"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "32631.00",
        "status": "Rente-aanbod getekend ontvangen",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1734385",
        "passeeringangsdatum": "2022-12-01"
      },
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen makelaardij",
        "productsoort": "",
        "factuurbedrag": "2458.67",
        "offertenummer": "",
        "passeeringangsdatum": "2019-01-18"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "18360.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1734385",
        "passeeringangsdatum": "2023-03-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-12-11"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99644",
      "Pietersma (J.R.)",
      "De Grutto 63",
      "8251 XR",
      "Dronten",
      "[email]",
      "[telefoon]",
      "2678454",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "1734385",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "Lloyds Annuiteitenhypotheek",
      "Eigen makelaardij",
      "Verkoopdienst",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99644",
    "dossiernummer": "99644",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5bae549f-4dc5-43d4-8413-4cedd86c583a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ven, van de (M.E.)",
      "adres": "Kamp 33 32",
      "email": "[email]",
      "postcode": "8225 HC",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kamp 33 32",
      "postcode": "8225 HC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-06-01"
        }
      ],
      "crmdossier_id": "119341",
      "dossiernummer": "119341",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "5bae549f-4dc5-43d4-8413-4cedd86c583a",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 33 32",
    "klant": "Ven, van de (M.E.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 HC",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-06-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "119341",
      "Ven, van de (M.E.)",
      "Kamp 33 32",
      "8225 HC",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "119341",
    "dossiernummer": "119341",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "adba15fd-a93b-4146-903b-e10b97c46d05",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Elk, Anouk van (A)",
      "adres": "Groenhoven 171",
      "postcode": "1103 LC",
      "woonplaats": "Amsterdam",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Groenhoven 171",
      "postcode": "1103 LC",
      "woonplaats": "Amsterdam"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "121000.00",
          "status": "Gepasseerd",
          "artikel": "NIBC Annuiteit",
          "tekendatum": "25569",
          "productnaam": "NIBC Annuiteit",
          "maatschappij": "NIBC",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1,392,545",
          "passeeringangsdatum": "2015-11-17"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Brand New Day",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "540.098.80",
          "passeeringangsdatum": "2015-10-01"
        }
      ],
      "crmdossier_id": "113532",
      "dossiernummer": "113532",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "adba15fd-a93b-4146-903b-e10b97c46d05",
  "key": "base_import",
  "value_json": {
    "adres": "Groenhoven 171",
    "klant": "Elk, Anouk van (A)",
    "plaats": "Amsterdam",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1103 LC",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "121000.00",
        "status": "Gepasseerd",
        "artikel": "NIBC Annuiteit",
        "tekendatum": "25569",
        "productnaam": "NIBC Annuiteit",
        "maatschappij": "NIBC",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1,392,545",
        "passeeringangsdatum": "2015-11-17"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Brand New Day",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "540.098.80",
        "passeeringangsdatum": "2015-10-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "113532",
      "Elk, Anouk van (A)",
      "Groenhoven 171",
      "1103 LC",
      "Amsterdam",
      "[telefoon]",
      "1,392,545",
      "NIBC",
      "Hypotheek",
      "NIBC Annuiteit",
      "Annuitair",
      "540.098.80",
      "Brand New Day",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "113532",
    "dossiernummer": "113532",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "951205a9-6e58-4142-8c28-f70270f8a37b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Dijk, van (J.A.)",
      "adres": "Flakkee 39",
      "postcode": "8245 GD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Farenhorst, Cindy (C.M.)",
      "adres": "Flakkee 39",
      "postcode": "8245 GD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Interbank Doorlopend Krediet",
          "tekendatum": "25569",
          "productnaam": "Interbank Doorlopend Krediet",
          "maatschappij": "InterBank NV",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2015-08-25"
        }
      ],
      "crmdossier_id": "106798",
      "dossiernummer": "106798",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "951205a9-6e58-4142-8c28-f70270f8a37b",
  "key": "base_import",
  "value_json": {
    "adres": "Flakkee 39",
    "klant": "Dijk, van (J.A.), Farenhorst, Cindy (C.M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 GD",
    "products": [
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Interbank Doorlopend Krediet",
        "tekendatum": "25569",
        "productnaam": "Interbank Doorlopend Krediet",
        "maatschappij": "InterBank NV",
        "productsoort": "Doorlopend krediet",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2015-08-25"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "106798",
      "Dijk, van (J.A.), Farenhorst, Cindy (C.M.)",
      "Flakkee 39",
      "8245 GD",
      "Lelystad",
      "[telefoon]",
      "*********",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Doorlopend Krediet",
      "Doorlopend krediet"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "106798",
    "dossiernummer": "106798",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e50f2dc0-fe63-41d3-bb22-fc2fda611980",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 20 55",
    "klant": "Krol, Mateusz (M), Marciniak, Dominika (D.M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 LX",
    "products": [
      {
        "norm": "",
        "type": "Bankgarantie",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Nationale Waarborg",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "15.06.0921",
        "passeeringangsdatum": "2015-07-10"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "101486",
      "Krol, Mateusz (M), Marciniak, Dominika (D.M.)",
      "Horst 20 55",
      "8225 LX",
      "Lelystad",
      "[email]",
      "06 - 44 43 85 09",
      "15.06.0921",
      "Nationale Waarborg",
      "Bankgarantie"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "101486",
    "dossiernummer": "101486",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "06 - 44 43 85 09",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3e0d485e-a840-4414-b736-62f30612473f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Taydas (H.)",
      "adres": "Baai 147",
      "email": "[email]",
      "postcode": "8224 DV",
      "woonplaats": "Lelystad",
      "telefoon_prive": "0320 - 23 53 60"
    },
    "a2": {
      "naam": "Taydas (M.)",
      "adres": "Baai 147",
      "postcode": "8224 DV",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]",
          "passeeringangsdatum": "2013-10-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "142732.00",
          "status": "Gepasseerd",
          "artikel": "Argenta Annuiteit (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2013-10-24"
        }
      ],
      "crmdossier_id": "99809",
      "dossiernummer": "99809",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3e0d485e-a840-4414-b736-62f30612473f",
  "key": "base_import",
  "value_json": {
    "adres": "Baai 147",
    "klant": "Taydas (H.), Taydas (M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 DV",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]",
        "passeeringangsdatum": "2013-10-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "142732.00",
        "status": "Gepasseerd",
        "artikel": "Argenta Annuiteit (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2013-10-24"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99809",
      "Taydas (H.), Taydas (M.)",
      "Baai 147",
      "8224 DV",
      "Lelystad",
      "[email]",
      "0320 - 23 53 60",
      "[telefoon]",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99809",
    "dossiernummer": "99809",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "0320 - 23 53 60",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f4622487-f701-48f2-8e38-97e175990f15",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Suchorska (Z.)",
      "adres": "Bastion 44",
      "email": "[email]",
      "postcode": "8223 GA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 44 45 57 15"
    },
    "a2": {
      "naam": "Wegiel (M.)",
      "adres": "Bastion 44",
      "postcode": "8223 GA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Cardif",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "O63650",
          "passeeringangsdatum": "2013-01-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "106400.00",
          "status": "Gepasseerd",
          "artikel": "Argenta Annuiteit (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2439968",
          "passeeringangsdatum": "2013-03-19"
        }
      ],
      "crmdossier_id": "95178",
      "dossiernummer": "95178",
      "dossierstatus": "Geroyeerd",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3babdb7e-aab9-4333-9b41-7b2dbfdb2957",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Breukelaar (E.C.)",
      "adres": "Zevenwouden 68",
      "email": "[email]",
      "postcode": "8245 CC",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 49 74 43 16"
    },
    "a2": {
      "naam": "Theelen (J.H.)",
      "adres": "Zevenwouden 68",
      "postcode": "8245 CC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "40000.00",
          "status": "Gepasseerd",
          "artikel": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Aflossingsvrij",
          "factuurbedrag": "",
          "offertenummer": "M 090-908996",
          "passeeringangsdatum": "2011-06-28"
        }
      ],
      "crmdossier_id": "100232",
      "dossiernummer": "100232",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3babdb7e-aab9-4333-9b41-7b2dbfdb2957",
  "key": "base_import",
  "value_json": {
    "adres": "Zevenwouden 68",
    "klant": "Breukelaar (E.C.), Theelen (J.H.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 CC",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "40000.00",
        "status": "Gepasseerd",
        "artikel": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Aflossingsvrij",
        "factuurbedrag": "",
        "offertenummer": "M 090-908996",
        "passeeringangsdatum": "2011-06-28"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "100232",
      "Breukelaar (E.C.), Theelen (J.H.)",
      "Zevenwouden 68",
      "8245 CC",
      "Lelystad",
      "[email]",
      "06 - 49 74 43 16",
      "M 090-908996",
      "ING Bank",
      "Hypotheek",
      "ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
      "Aflossingsvrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "100232",
    "dossiernummer": "100232",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06 - 49 74 43 16",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "847b99f3-aa55-49c0-9111-8dc78d008831",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Smit sr, Ron (R)",
      "adres": "Karveel 0763",
      "email": "[email]",
      "postcode": "8231 AJ",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Karveel 0763",
      "postcode": "8231 AJ",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "ASR Verzekeringen",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-01-01"
        }
      ],
      "crmdossier_id": "95218",
      "dossiernummer": "95218",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "847b99f3-aa55-49c0-9111-8dc78d008831",
  "key": "base_import",
  "value_json": {
    "adres": "Karveel 0763",
    "klant": "Smit sr, Ron (R)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 AJ",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "ASR Verzekeringen",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-01-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95218",
      "Smit sr, Ron (R)",
      "Karveel 0763",
      "8231 AJ",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "ASR Verzekeringen",
      "Levensverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95218",
    "dossiernummer": "95218",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "49139ef8-05ce-4442-ae17-5ed59758a8ee",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Baalen, Joris van (J.)",
      "adres": "Kogge 10 20",
      "email": "[email]",
      "postcode": "8243 AA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 81 82 53 22"
    },
    "a2": {
      "naam": "Hulst, Britt van (B.)",
      "adres": "Kogge 10 20",
      "email": "[email]",
      "postcode": "8243 AA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV.407541",
          "passeeringangsdatum": "2012-10-15"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV407540",
          "passeeringangsdatum": "2012-10-15"
        }
      ],
      "crmdossier_id": "99976",
      "dossiernummer": "99976",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "49139ef8-05ce-4442-ae17-5ed59758a8ee",
  "key": "base_import",
  "value_json": {
    "adres": "Kogge 10 20",
    "klant": "Baalen, Joris van (J.), Hulst, Britt van (B.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 AA",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV.407541",
        "passeeringangsdatum": "2012-10-15"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV407540",
        "passeeringangsdatum": "2012-10-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99976",
      "Baalen, Joris van (J.), Hulst, Britt van (B.)",
      "Kogge 10 20",
      "8243 AA",
      "Lelystad",
      "[email]",
      "[email]",
      "06 - 81 82 53 22",
      "GINV.407541",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen",
      "GINV407540"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99976",
    "dossiernummer": "99976",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "06 - 81 82 53 22",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "e50f2dc0-fe63-41d3-bb22-fc2fda611980",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Krol, Mateusz (M)",
      "adres": "Horst 20 55",
      "email": "[email]",
      "postcode": "8225 LX",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 44 43 85 09"
    },
    "a2": {
      "naam": "Marciniak, Dominika (D.M.)",
      "adres": "Horst 20 55",
      "postcode": "8225 LX",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Bankgarantie",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Nationale Waarborg",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "15.06.0921",
          "passeeringangsdatum": "2015-07-10"
        }
      ],
      "crmdossier_id": "101486",
      "dossiernummer": "101486",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ae7117c8-1ba9-465a-b8d0-b59f6c3c9039",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Carolan, Suzanne (S.M.)",
      "adres": "Rijnland 115",
      "email": "[email]",
      "postcode": "8245 CT",
      "woonplaats": "Lelystad",
      "telefoon_prive": "+447966745132"
    },
    "a2": {
      "adres": "Rijnland 115",
      "postcode": "8245 CT",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "226950.00",
          "status": "Gepasseerd",
          "artikel": "Lineaire Hypotheek (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Lineaire Hypotheek (Argenta Hypotheek)",
          "maatschappij": "Argenta (via Adaxio)",
          "productsoort": "Lineaire",
          "factuurbedrag": "",
          "offertenummer": "2861892",
          "passeeringangsdatum": "2016-04-28"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "zie hypotheekofferte",
          "passeeringangsdatum": "2016-04-01"
        }
      ],
      "crmdossier_id": "121493",
      "dossiernummer": "121493",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ae7117c8-1ba9-465a-b8d0-b59f6c3c9039",
  "key": "base_import",
  "value_json": {
    "adres": "Rijnland 115",
    "klant": "Carolan, Suzanne (S.M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 CT",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "226950.00",
        "status": "Gepasseerd",
        "artikel": "Lineaire Hypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Lineaire Hypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Lineaire",
        "factuurbedrag": "",
        "offertenummer": "2861892",
        "passeeringangsdatum": "2016-04-28"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "zie hypotheekofferte",
        "passeeringangsdatum": "2016-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "121493",
      "Carolan, Suzanne (S.M.)",
      "Rijnland 115",
      "8245 CT",
      "Lelystad",
      "[email]",
      "+447966745132",
      "2861892",
      "Argenta (via Adaxio)",
      "Hypotheek",
      "Lineaire Hypotheek (Argenta Hypotheek)",
      "Lineaire",
      "zie hypotheekofferte",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "121493",
    "dossiernummer": "121493",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "+447966745132",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "00cb8ea0-d204-45c3-a8a8-39acc24f93e3",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Broertjes, Marina (M)",
      "adres": "Jacques Tatilaan 49",
      "email": "[email]",
      "postcode": "1325 RD",
      "woonplaats": "Almere",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Jacques Tatilaan 49",
      "postcode": "1325 RD",
      "woonplaats": "Almere"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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]-23",
          "passeeringangsdatum": "2016-06-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "131070.00",
          "status": "Gepasseerd",
          "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
          "maatschappij": "Argenta (via Adaxio)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2870155",
          "passeeringangsdatum": "2016-06-16"
        }
      ],
      "crmdossier_id": "124766",
      "dossiernummer": "124766",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "00cb8ea0-d204-45c3-a8a8-39acc24f93e3",
  "key": "base_import",
  "value_json": {
    "adres": "Jacques Tatilaan 49",
    "klant": "Broertjes, Marina (M)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1325 RD",
    "products": [
      {
        "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]-23",
        "passeeringangsdatum": "2016-06-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "131070.00",
        "status": "Gepasseerd",
        "artikel": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteitenhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2870155",
        "passeeringangsdatum": "2016-06-16"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "124766",
      "Broertjes, Marina (M)",
      "Jacques Tatilaan 49",
      "1325 RD",
      "Almere",
      "[email]",
      "[telefoon]",
      "[telefoon]-23",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "2870155",
      "Argenta (via Adaxio)",
      "Hypotheek",
      "Annuïteitenhypotheek (Argenta Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "124766",
    "dossiernummer": "124766",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "8c296270-c415-4911-a9b0-a2808baf7fea",
  "key": "base_import",
  "value_json": {
    "adres": "Tjalk 22 11",
    "klant": "Heemskerk (F.E.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 MA",
    "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-10-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "115114",
      "Heemskerk (F.E.)",
      "Tjalk 22 11",
      "8232 MA",
      "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": "115114",
    "dossiernummer": "115114",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "88a34661-154f-4dad-9b66-4f0a9de22a04",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ruwaard, Kilian (KCM)",
      "adres": "Jol 13 51",
      "email": "[email]",
      "postcode": "8243 EK",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Jol 13 51",
      "postcode": "8243 EK",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "Cardif Aflos Verzekering",
          "tekendatum": "25569",
          "productnaam": "Cardif Aflos Verzekering",
          "maatschappij": "Cardif",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "HAV00028022",
          "passeeringangsdatum": "2019-06-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]-21",
          "passeeringangsdatum": "2015-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-04-08"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "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": "ISW-7E299DBA-7F74-4888-B61A-18AED2794909(1)",
          "passeeringangsdatum": "2019-06-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "Cardif Aflos Verzekering",
          "tekendatum": "25569",
          "productnaam": "Cardif Aflos Verzekering",
          "maatschappij": "Cardif",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "HAV00028023",
          "passeeringangsdatum": "2019-06-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "143859.00",
          "status": "Lopend",
          "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "603803",
          "passeeringangsdatum": "2019-05-31"
        }
      ],
      "crmdossier_id": "189613",
      "dossiernummer": "189613",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "88a34661-154f-4dad-9b66-4f0a9de22a04",
  "key": "base_import",
  "value_json": {
    "adres": "Jol 13 51",
    "klant": "Ruwaard, Kilian (KCM)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 EK",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "Cardif Aflos Verzekering",
        "tekendatum": "25569",
        "productnaam": "Cardif Aflos Verzekering",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "HAV00028022",
        "passeeringangsdatum": "2019-06-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]-21",
        "passeeringangsdatum": "2015-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-04-08"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "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": "ISW-7E299DBA-7F74-4888-B61A-18AED2794909(1)",
        "passeeringangsdatum": "2019-06-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "Cardif Aflos Verzekering",
        "tekendatum": "25569",
        "productnaam": "Cardif Aflos Verzekering",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "HAV00028023",
        "passeeringangsdatum": "2019-06-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "143859.00",
        "status": "Lopend",
        "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "603803",
        "passeeringangsdatum": "2019-05-31"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "189613",
      "Ruwaard, Kilian (KCM)",
      "Jol 13 51",
      "8243 EK",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "HAV00028022",
      "Cardif",
      "Inkomensverzekering",
      "Cardif Aflos Verzekering",
      "Woonlastenverzekering",
      "[telefoon]-21",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-7E299DBA-7F74-4888-B61A-18AED2794909(1)",
      "Hera Life",
      "Scherp & Slim ORV annuïtair dalend",
      "HAV00028023",
      "603803",
      "Obvion",
      "Hypotheek",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "189613",
    "dossiernummer": "189613",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "4488cb49-95d3-4ffa-929a-fd7ee954c1e4",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Peelen, Yvonne (Y)",
      "adres": "Kamp 27 20",
      "email": "[email]",
      "postcode": "8225 EL",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kamp 27 20",
      "postcode": "8225 EL",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.618424",
          "passeeringangsdatum": "2017-06-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "130500.00",
          "status": "Gepasseerd",
          "artikel": "Merius annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Merius annuiteitenhypotheek",
          "maatschappij": "Merius Hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3001697",
          "passeeringangsdatum": "2017-06-01"
        }
      ],
      "crmdossier_id": "151035",
      "dossiernummer": "151035",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "4488cb49-95d3-4ffa-929a-fd7ee954c1e4",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 27 20",
    "klant": "Peelen, Yvonne (Y)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 EL",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.618424",
        "passeeringangsdatum": "2017-06-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "130500.00",
        "status": "Gepasseerd",
        "artikel": "Merius annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Merius annuiteitenhypotheek",
        "maatschappij": "Merius Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3001697",
        "passeeringangsdatum": "2017-06-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "151035",
      "Peelen, Yvonne (Y)",
      "Kamp 27 20",
      "8225 EL",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "GEWI.618424",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "3001697",
      "Merius Hypotheken",
      "Hypotheek",
      "Merius annuiteitenhypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "151035",
    "dossiernummer": "151035",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f4622487-f701-48f2-8e38-97e175990f15",
  "key": "base_import",
  "value_json": {
    "adres": "Bastion 44",
    "klant": "Suchorska (Z.), Wegiel (M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8223 GA",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Cardif",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "O63650",
        "passeeringangsdatum": "2013-01-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "106400.00",
        "status": "Gepasseerd",
        "artikel": "Argenta Annuiteit (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2439968",
        "passeeringangsdatum": "2013-03-19"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95178",
      "Suchorska (Z.), Wegiel (M.)",
      "Bastion 44",
      "8223 GA",
      "Lelystad",
      "[email]",
      "06 - 44 45 57 15",
      "O63650",
      "Cardif",
      "Levensverzekering",
      "2439968",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95178",
    "dossiernummer": "95178",
    "dossierstatus": "Geroyeerd",
    "email_partner": "",
    "telefoonnummer": "06 - 44 45 57 15",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "29118b32-5463-463c-9a68-3ccb884c8729",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Platje, Petra (P.)",
      "adres": "Zoom 15 20",
      "email": "[email]",
      "postcode": "8225 KJ",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 188 877 75"
    },
    "a2": {
      "adres": "Zoom 15 20",
      "email": "[email]",
      "postcode": "8225 KJ",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GIEN.700405",
          "passeeringangsdatum": "2016-05-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GIEN.700404",
          "passeeringangsdatum": "2016-04-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "168000.00",
          "status": "Gepasseerd",
          "artikel": "Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Leven (Hypotrust Profijt)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Annuïteit (Hypotrust Profijt), Hypotrust Comfort Leven (Hypotrust Profijt)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair, Leven",
          "factuurbedrag": "",
          "offertenummer": "2131420",
          "passeeringangsdatum": "2016-07-15"
        }
      ],
      "crmdossier_id": "119890",
      "dossiernummer": "119890",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "2647afe0-81a2-41f6-b344-b34ed7b859f6",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Davidson, Richard (R)",
      "adres": "Vloedstraat 46",
      "email": "[email]",
      "postcode": "8226 DJ",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Vloedstraat 46",
      "postcode": "8226 DJ",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Brand New Day",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "538.457.51",
          "passeeringangsdatum": "2015-05-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "84312.00",
          "status": "Gepasseerd",
          "artikel": "NIBC Annuiteit",
          "tekendatum": "25569",
          "productnaam": "NIBC Annuiteit",
          "maatschappij": "NIBC",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.379.476",
          "passeeringangsdatum": "2015-07-23"
        }
      ],
      "crmdossier_id": "105659",
      "dossiernummer": "105659",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "2647afe0-81a2-41f6-b344-b34ed7b859f6",
  "key": "base_import",
  "value_json": {
    "adres": "Vloedstraat 46",
    "klant": "Davidson, Richard (R)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 DJ",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Brand New Day",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "538.457.51",
        "passeeringangsdatum": "2015-05-16"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "84312.00",
        "status": "Gepasseerd",
        "artikel": "NIBC Annuiteit",
        "tekendatum": "25569",
        "productnaam": "NIBC Annuiteit",
        "maatschappij": "NIBC",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.379.476",
        "passeeringangsdatum": "2015-07-23"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "105659",
      "Davidson, Richard (R)",
      "Vloedstraat 46",
      "8226 DJ",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "538.457.51",
      "Brand New Day",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "1.379.476",
      "NIBC",
      "Hypotheek",
      "NIBC Annuiteit",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "105659",
    "dossiernummer": "105659",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "8b924bdb-dd90-45f5-8973-974dc8bc270a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Loenen (M)",
      "adres": "Sikkelstraat 10",
      "email": "[email]",
      "postcode": "1445 HE",
      "woonplaats": "PURMEREND",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Wijthoef, Kevin (K.T.)",
      "adres": "Sikkelstraat 10",
      "email": "[email]",
      "postcode": "1445 HE",
      "woonplaats": "PURMEREND"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-09-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "139037.00",
          "status": "Lopend",
          "artikel": "ASR WelThuis Annuiteitenhypotheek, ASR WelThuis Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "ASR WelThuis Annuiteitenhypotheek, ASR WelThuis Annuiteitenhypotheek",
          "maatschappij": "ASR Hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2018882",
          "passeeringangsdatum": "2021-12-29"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "154500.00",
          "status": "Gepasseerd",
          "artikel": "Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank via Adaxio",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.380.198",
          "passeeringangsdatum": "2015-09-08"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.607658",
          "passeeringangsdatum": "2015-08-01"
        }
      ],
      "crmdossier_id": "105456",
      "dossiernummer": "105456",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "8b924bdb-dd90-45f5-8973-974dc8bc270a",
  "key": "base_import",
  "value_json": {
    "adres": "Sikkelstraat 10",
    "klant": "Loenen (M), Wijthoef, Kevin (K.T.)",
    "plaats": "PURMEREND",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1445 HE",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-09-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "139037.00",
        "status": "Lopend",
        "artikel": "ASR WelThuis Annuiteitenhypotheek, ASR WelThuis Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "ASR WelThuis Annuiteitenhypotheek, ASR WelThuis Annuiteitenhypotheek",
        "maatschappij": "ASR Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2018882",
        "passeeringangsdatum": "2021-12-29"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "154500.00",
        "status": "Gepasseerd",
        "artikel": "Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank via Adaxio",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.380.198",
        "passeeringangsdatum": "2015-09-08"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.607658",
        "passeeringangsdatum": "2015-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "105456",
      "Loenen (M), Wijthoef, Kevin (K.T.)",
      "Sikkelstraat 10",
      "1445 HE",
      "PURMEREND",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2018882",
      "ASR Hypotheken",
      "Hypotheek",
      "ASR WelThuis Annuiteitenhypotheek, ASR WelThuis Annuiteitenhypotheek",
      "Annuitair",
      "1.380.198",
      "Lloyds Bank via Adaxio",
      "Annuiteitenhypotheek",
      "GEWI.607658",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "105456",
    "dossiernummer": "105456",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3065e250-2361-4bd6-9a23-045928b31dbd",
  "key": "base_import",
  "value_json": {
    "adres": "Spechtstraat 19",
    "klant": "Altinay (K.), Ozcan (I.)",
    "plaats": "Goor",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "7471 HK",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "159978.00",
        "status": "Gepasseerd",
        "artikel": "BOS Aflossingsvrije hypotheek (Bank of Scotland Budget Hypotheek), BOS Spaarvast hypotheek (Bank of Scotland Budget Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "BOS Aflossingsvrije hypotheek (Bank of Scotland Budget Hypotheek), BOS Spaarvast hypotheek (Bank of Scotland Budget Hypotheek)",
        "maatschappij": "Bank of Scotland",
        "productsoort": "Aflossingsvrij, Spaar",
        "factuurbedrag": "",
        "offertenummer": "1.254.368.108",
        "passeeringangsdatum": "2011-03-10"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Risicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Risicoverzekering",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "1.254.368.116",
        "passeeringangsdatum": "2011-03-10"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "100009",
      "Altinay (K.), Ozcan (I.)",
      "Spechtstraat 19",
      "7471 HK",
      "Goor",
      "[email]",
      "06 - 14 68 31 09",
      "1.254.368.108",
      "Bank of Scotland",
      "Hypotheek",
      "BOS Aflossingsvrije hypotheek (Bank of Scotland Budget Hypotheek), BOS Spaarvast hypotheek (Bank of Scotland Budget Hypotheek)",
      "Aflossingsvrij, Spaar",
      "1.254.368.116",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "Risicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "100009",
    "dossiernummer": "100009",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06 - 14 68 31 09",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f8f829f3-feb4-42cd-828e-9e4929ce31d5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bakker (S.)",
      "adres": "Ossenven 23",
      "email": "[email]",
      "postcode": "1567 BB",
      "woonplaats": "Assendelft",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Ossenven 23",
      "email": "[email]",
      "postcode": "1567 BB",
      "woonplaats": "Assendelft"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "164695215385",
          "passeeringangsdatum": "2017-11-21"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-08-04"
        },
        {
          "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": "2451664",
          "passeeringangsdatum": "2017-09-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-11-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "307005.00",
          "status": "Gepasseerd",
          "artikel": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "tekendatum": "25569",
          "productnaam": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
          "maatschappij": "VENN Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.613.880",
          "passeeringangsdatum": "2017-11-21"
        }
      ],
      "crmdossier_id": "154782",
      "dossiernummer": "154782",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "f8f829f3-feb4-42cd-828e-9e4929ce31d5",
  "key": "base_import",
  "value_json": {
    "adres": "Ossenven 23",
    "klant": "Bakker (S.)",
    "plaats": "Assendelft",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1567 BB",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "164695215385",
        "passeeringangsdatum": "2017-11-21"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-08-04"
      },
      {
        "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": "2451664",
        "passeeringangsdatum": "2017-09-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-11-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "307005.00",
        "status": "Gepasseerd",
        "artikel": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "tekendatum": "25569",
        "productnaam": "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
        "maatschappij": "VENN Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.613.880",
        "passeeringangsdatum": "2017-11-21"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "154782",
      "Bakker (S.)",
      "Ossenven 23",
      "1567 BB",
      "Assendelft",
      "[email]",
      "[email]",
      "[telefoon]",
      "164695215385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2451664",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "1.613.880",
      "VENN Hypotheken",
      "Hypotheek",
      "VENN Hypotheken Aflossingsvrije hypotheek, VENN Hypotheken Annuïteiten hypotheek, VENN Hypotheken Annuïteiten hypotheek",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "154782",
    "dossiernummer": "154782",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "c31ced70-7e96-40f9-861e-0a2a3b94b225",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Unverricht (S.J.)",
      "adres": "Rhonestraat 48",
      "email": "[email]",
      "postcode": "8226 MC",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 86 29 54 07"
    },
    "a2": {
      "adres": "Rhonestraat 48",
      "postcode": "8226 MC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "140980.00",
          "status": "Lopend",
          "artikel": "Argenta Annuiteit (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2437154/1",
          "passeeringangsdatum": "2013-01-15"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "maatschappij": "Dazure",
          "productsoort": "Gelijkblijvende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV.407754",
          "passeeringangsdatum": "2012-12-01"
        }
      ],
      "crmdossier_id": "99319",
      "dossiernummer": "99319",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "c31ced70-7e96-40f9-861e-0a2a3b94b225",
  "key": "base_import",
  "value_json": {
    "adres": "Rhonestraat 48",
    "klant": "Unverricht (S.J.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 MC",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "140980.00",
        "status": "Lopend",
        "artikel": "Argenta Annuiteit (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2437154/1",
        "passeeringangsdatum": "2013-01-15"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "maatschappij": "Dazure",
        "productsoort": "Gelijkblijvende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV.407754",
        "passeeringangsdatum": "2012-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99319",
      "Unverricht (S.J.)",
      "Rhonestraat 48",
      "8226 MC",
      "Lelystad",
      "[email]",
      "06 - 86 29 54 07",
      "2437154/1",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Hypotheek)",
      "Annuitair",
      "GINV.407754",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Gelijkblijvend",
      "Gelijkblijvende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99319",
    "dossiernummer": "99319",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06 - 86 29 54 07",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "3065e250-2361-4bd6-9a23-045928b31dbd",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Altinay (K.)",
      "adres": "Spechtstraat 19",
      "email": "[email]",
      "postcode": "7471 HK",
      "woonplaats": "Goor",
      "telefoon_prive": "06 - 14 68 31 09"
    },
    "a2": {
      "naam": "Ozcan (I.)",
      "adres": "Spechtstraat 19",
      "postcode": "7471 HK",
      "woonplaats": "Goor"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "159978.00",
          "status": "Gepasseerd",
          "artikel": "BOS Aflossingsvrije hypotheek (Bank of Scotland Budget Hypotheek), BOS Spaarvast hypotheek (Bank of Scotland Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "BOS Aflossingsvrije hypotheek (Bank of Scotland Budget Hypotheek), BOS Spaarvast hypotheek (Bank of Scotland Budget Hypotheek)",
          "maatschappij": "Bank of Scotland",
          "productsoort": "Aflossingsvrij, Spaar",
          "factuurbedrag": "",
          "offertenummer": "1.254.368.108",
          "passeeringangsdatum": "2011-03-10"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Risicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Risicoverzekering",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "1.254.368.116",
          "passeeringangsdatum": "2011-03-10"
        }
      ],
      "crmdossier_id": "100009",
      "dossiernummer": "100009",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "452d4812-844f-4bc2-913d-8a4526424ccb",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Krupa, Pawel (P.D.)",
      "adres": "Kempenaar 12 31",
      "email": "[email]",
      "postcode": "8231 VN",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06 - 33 66 43 21"
    },
    "a2": {
      "adres": "Kempenaar 12 31",
      "postcode": "8231 VN",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Interbank Doorlopend Krediet",
          "tekendatum": "25569",
          "productnaam": "Interbank Doorlopend Krediet",
          "maatschappij": "InterBank NV",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2014-08-14"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV.407673",
          "passeeringangsdatum": "2012-11-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "142040.00",
          "status": "Lopend",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2012-12-27"
        }
      ],
      "crmdossier_id": "95224",
      "dossiernummer": "95224",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "452d4812-844f-4bc2-913d-8a4526424ccb",
  "key": "base_import",
  "value_json": {
    "adres": "Kempenaar 12 31",
    "klant": "Krupa, Pawel (P.D.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 VN",
    "products": [
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Interbank Doorlopend Krediet",
        "tekendatum": "25569",
        "productnaam": "Interbank Doorlopend Krediet",
        "maatschappij": "InterBank NV",
        "productsoort": "Doorlopend krediet",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2014-08-14"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV.407673",
        "passeeringangsdatum": "2012-11-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "142040.00",
        "status": "Lopend",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2012-12-27"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95224",
      "Krupa, Pawel (P.D.)",
      "Kempenaar 12 31",
      "8231 VN",
      "Lelystad",
      "[email]",
      "06 - 33 66 43 21",
      "*********",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Doorlopend Krediet",
      "Doorlopend krediet",
      "GINV.407673",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Annuïtair",
      "Annuitair Dalende Risicoverzekeringen",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95224",
    "dossiernummer": "95224",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06 - 33 66 43 21",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ef859ef4-033b-48fd-af45-599123620969",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bogerd, van den (C.)",
      "adres": "Heeskesacker 1213",
      "email": "[email]",
      "postcode": "6546 JD",
      "woonplaats": "Nijmegen",
      "telefoon_prive": "06 - 31 68 09 41"
    },
    "a2": {
      "naam": "Gram, de (R.B.)",
      "adres": "Heeskesacker 1213",
      "postcode": "6546 JD",
      "woonplaats": "Nijmegen"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "maatschappij": "Dazure",
          "productsoort": "Gelijkblijvende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV.408018",
          "passeeringangsdatum": "2013-04-24"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "29400.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "326.729",
          "passeeringangsdatum": "2013-06-07"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
          "maatschappij": "Dazure",
          "productsoort": "Gelijkblijvende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GINV.408019",
          "passeeringangsdatum": "2013-04-24"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "119000.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2013-06-07"
        }
      ],
      "crmdossier_id": "99706",
      "dossiernummer": "99706",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

{
  "dossier_id": "ef859ef4-033b-48fd-af45-599123620969",
  "key": "base_import",
  "value_json": {
    "adres": "Heeskesacker 1213",
    "klant": "Bogerd, van den (C.), Gram, de (R.B.)",
    "plaats": "Nijmegen",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "6546 JD",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "maatschappij": "Dazure",
        "productsoort": "Gelijkblijvende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV.408018",
        "passeeringangsdatum": "2013-04-24"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "29400.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "326.729",
        "passeeringangsdatum": "2013-06-07"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Gelijkblijvend",
        "maatschappij": "Dazure",
        "productsoort": "Gelijkblijvende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GINV.408019",
        "passeeringangsdatum": "2013-04-24"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "119000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2013-06-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99706",
      "Bogerd, van den (C.), Gram, de (R.B.)",
      "Heeskesacker 1213",
      "6546 JD",
      "Nijmegen",
      "[email]",
      "06 - 31 68 09 41",
      "GINV.408018",
      "Dazure",
      "Levensverzekering",
      "GoedIdee Nabestaandenverzekering Gelijkblijvend",
      "Gelijkblijvende Risicoverzekeringen",
      "326.729",
      "SVn",
      "Hypotheek",
      "Starterslening",
      "Annuitair",
      "GINV.408019",
      "*********",
      "ING Bank",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99706",
    "dossiernummer": "99706",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06 - 31 68 09 41",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}