AI Service Audit Viewer

[]

You are a data normalization expert. Your task is to analyze a list of sender names from documents and create a mapping to consolidate variations of the same entity into a single standardized name.

Rules for consolidation:
1. When multiple variations of a company name exist:
   - Consolidate all subsidiaries and variations under the main parent company name
   - Use the most commonly appearing or highest-level legal entity name as the consolidated name
   - Ignore distinctions between subsidiaries, departments, or specific legal entities of the same parent company
   - Example: "HanseMerkur Krankenversicherung AG", "HanseMerkur Versicherungsgruppe", and "HanseMerkur" should all map to "HanseMerkur Versicherungsgruppe"

2. For names and formatting:
   - Remove addresses and location details unless part of the official company name
   - Maintain consistent capitalization and spacing
   - Keep special characters (umlauts, hyphens) as they appear in official names

3. For government institutions and public bodies:
   - Keep the complete official name
   - Preserve regional/location information if part of the official name

4. For individual persons:
   - Remove addresses and location information
   - Keep the full name as it appears in official capacity, including titles and honorifics.

5. For mixed sender information (when both person and institution names appear):
   - Prioritize the institutional/company name over individual names
   - Example: "Frau Roßbach von Ihrer Presse-Versorgung" should consolidate to "Presse-Versorgung"
   - Exception: Only fall back to the individual name if no institutional name can be identified

Please analyze the provided list of sender names and return a JSON object with this structure:
{
  "mappings": [
    {
      "original": "original sender name",
      "consolidated": "standardized sender name"
    },
    ...
  ]
}

Input sender names to analyze:


Existing canonical sender names (choose from this list whenever possible):
1&1 Versatel Deutschland GmbH
1&1 Versatel Deutschland GmbH, Prenzlauer Allee 96, 10409 Berlin
ALBA Berlin GmbH
Allianz Esa GmbH
AvisBudget Autoverm. GmbH&Co. KG
Berliner Wasserbetriebe
BG ETEM Energie Textil Elektro Medienerzeugnisse
Bundesanzeiger Verlag GmbH, Amsterdamer Straße 192, 50735 Köln
C. Bechstein Centrum Berlin GmbH
CarPartner Nord GmbH
Christoph
Christoph Drieschner
Christoph Drieschner, Graefestr. 71, 10967 Berlin
DAK-Gesundheit
Deutsche Rentenversicherung Berlin-Brandenburg
Dipl.-Ing. Andre' Felsmann IMMOBILIENVERWALTUNG
Drieschner Media GmbH
Drieschner Media GmbH; Domino Recording Company Limited
DTG dynamic trade GmbH - Saalestr. 8-24539 Neumünster
Finanzamt für Körperschaften II
Finanzamt für Körperschaften II, Magdalenenstr. 25, 10365 Berlin
Finow Vermietungs-Service GmbH
FINOW Vermietungs-Service GmbH
G7 Tontechnik GmbH, Nerthusweg 21, 13125 Berlin
gebe e.V.
GEMA
GEMA KundenCenter
GEMA KundenCenter, 11506 Berlin
HONIGMOND Hotel & Serviced Apartments
HORNBACH
in stereo Knauft & Schaar Steuerberater GbR
ista Deutschland GmbH
Just Music GmbH
Kube Lichteffekte GmbH, Esslinger Str. 83, 73207 Plochingen
LLS Luttenberger & Lucius-Strauch PartGmbB Steuerberatungsgesellschaft, Wiltbergstraße 48 Haus 104, 13125 Berlin
LTT Group GmbH, UnderCover Media, Rock Shop GmbH, Berlin Recycling GmbH, Postbank Card Service Hamburg
Lufthansa
Lufthansa / Spafax
Medias Reiseservice GmbH
MEDIAS Reiseservice GmbH
Mehr-BB Theater GmbH
Mehr-BB Theater GmbH, Drieschner Media GmbH
Minijob-Zentrale
Oetinger Media GmbH
office discount GmbH, Ludwig-Erhard-Str. 12, 85374 Neufahrn/München
Postbank
Postbank Card Service Hamburg
Postbank Hamburg Geschäftskundenbetreuung
Reinhard Knauft Steuerberater
Schönwitz Filmservice Helmut Schönwitz Filmservice
Spafax / Lufthansa
Steffen Scheunemann, Dorfstr.8a, D-17129 Daberkow
Superbude Hotel Hostel Hamburg
Techniker Krankenkasse
Tex Drieschner
Thomann GmbH
Ticketmaster GmbH
WeWatch Security Service GmbH
Finanzamt für Körperschaften II
Investitionsbank Berlin

```json
{
  "mappings": [
    {
      "original": "1&1 Versatel Deutschland GmbH",
      "consolidated": "1&1 Versatel Deutschland GmbH"
    },
    {
      "original": "1&1 Versatel Deutschland GmbH, Prenzlauer Allee 96, 10409 Berlin",
      "consolidated": "1&1 Versatel Deutschland GmbH"
    },
    {
      "original": "ALBA Berlin GmbH",
      "consolidated": "ALBA Berlin GmbH"
    },
    {
      "original": "Allianz Esa GmbH",
      "consolidated": "Allianz Esa GmbH"
    },
    {
      "original": "AvisBudget Autoverm. GmbH&Co. KG",
      "consolidated": "AvisBudget Autoverm. GmbH&Co. KG"
    },
    {
      "original": "Berliner Wasserbetriebe",
      "consolidated": "Berliner Wasserbetriebe"
    },
    {
      "original": "BG ETEM Energie Textil Elektro Medienerzeugnisse",
      "consolidated": "BG ETEM Energie Textil Elektro Medienerzeugnisse"
    },
    {
      "original": "Bundesanzeiger Verlag GmbH, Amsterdamer Straße 192, 50735 Köln",
      "consolidated": "Bundesanzeiger Verlag GmbH"
    },
    {
      "original": "C. Bechstein Centrum Berlin GmbH",
      "consolidated": "C. Bechstein Centrum Berlin GmbH"
    },
    {
      "original": "CarPartner Nord GmbH",
      "consolidated": "CarPartner Nord GmbH"
    },
    {
      "original": "Christoph",
      "consolidated": "Christoph Drieschner"
    },
    {
      "original": "Christoph Drieschner",
      "consolidated": "Christoph Drieschner"
    },
    {
      "original": "Christoph Drieschner, Graefestr. 71, 10967 Berlin",
      "consolidated": "Christoph Drieschner"
    },
    {
      "original": "DAK-Gesundheit",
      "consolidated": "DAK-Gesundheit"
    },
    {
      "original": "Deutsche Rentenversicherung Berlin-Brandenburg",
      "consolidated": "Deutsche Rentenversicherung Berlin-Brandenburg"
    },
    {
      "original": "Dipl.-Ing. Andre' Felsmann IMMOBILIENVERWALTUNG",
      "consolidated": "Dipl.-Ing. Andre' Felsmann IMMOBILIENVERWALTUNG"
    },
    {
      "original": "Drieschner Media GmbH",
      "consolidated": "Drieschner Media GmbH"
    },
    {
      "original": "Drieschner Media GmbH; Domino Recording Company Limited",
      "consolidated": "Drieschner Media GmbH"
    },
    {
      "original": "DTG dynamic trade GmbH - Saalestr. 8-24539 Neumünster",
      "consolidated": "DTG dynamic trade GmbH"
    },
    {
      "original": "Finanzamt für Körperschaften II",
      "consolidated": "Finanzamt für Körperschaften II"
    },
    {
      "original": "Finanzamt für Körperschaften II, Magdalenenstr. 25, 10365 Berlin",
      "consolidated": "Finanzamt für Körperschaften II"
    },
    {
      "original": "Finow Vermietungs-Service GmbH",
      "consolidated": "Finow Vermietungs-Service GmbH"
    },
    {
      "original": "FINOW Vermietungs-Service GmbH",
      "consolidated": "Finow Vermietungs-Service GmbH"
    },
    {
      "original": "G7 Tontechnik GmbH, Nerthusweg 21, 13125 Berlin",
      "consolidated": "G7 Tontechnik GmbH"
    },
    {
      "original": "gebe e.V.",
      "consolidated": "gebe e.V."
    },
    {
      "original": "GEMA",
      "consolidated": "GEMA"
    },
    {
      "original": "GEMA KundenCenter",
      "consolidated": "GEMA"
    },
    {
      "original": "GEMA KundenCenter, 11506 Berlin",
      "consolidated": "GEMA"
    },
    {
      "original": "HONIGMOND Hotel & Serviced Apartments",
      "consolidated": "HONIGMOND Hotel & Serviced Apartments"
    },
    {
      "original": "HORNBACH",
      "consolidated": "HORNBACH"
    },
    {
      "original": "in stereo Knauft & Schaar Steuerberater GbR",
      "consolidated": "in stereo Knauft & Schaar Steuerberater GbR"
    },
    {
      "original": "ista Deutschland GmbH",
      "consolidated": "ista Deutschland GmbH"
    },
    {
      "original": "Just Music GmbH",
      "consolidated": "Just Music GmbH"
    },
    {
      "original": "Kube Lichteffekte GmbH, Esslinger Str. 83, 73207 Plochingen",
      "consolidated": "Kube Lichteffekte GmbH"
    },
    {
      "original": "LLS Luttenberger & Lucius-Strauch PartGmbB Steuerberatungsgesellschaft, Wiltbergstraße 48 Haus 104, 13125 Berlin",
      "consolidated": "LLS Luttenberger & Lucius-Strauch PartGmbB Steuerberatungsgesellschaft"
    },
    {
      "original": "LTT Group GmbH, UnderCover Media, Rock Shop GmbH, Berlin Recycling GmbH, Postbank Card Service Hamburg",
      "consolidated": "LTT Group GmbH"
    },
    {
      "original": "Lufthansa",
      "consolidated": "Lufthansa"
    },
    {
      "original": "Lufthansa / Spafax",
      "consolidated": "Lufthansa"
    },
    {
      "original": "Medias Reiseservice GmbH",
      "consolidated": "Medias Reiseservice GmbH"
    },
    {
      "original": "MEDIAS Reiseservice GmbH",
      "consolidated": "Medias Reiseservice GmbH"
    },
    {
      "original": "Mehr-BB Theater GmbH",
      "consolidated": "Mehr-BB Theater GmbH"
    },
    {
      "original": "Mehr-BB Theater GmbH, Drieschner Media GmbH",
      "consolidated": "Mehr-BB Theater GmbH"
    },
    {
      "original": "Minijob-Zentrale",
      "consolidated": "Minijob-Zentrale"
    },
    {
      "original": "Oetinger Media GmbH",
      "consolidated": "Oetinger Media GmbH"
    },
    {
      "original": "office discount GmbH, Ludwig-Erhard-Str. 12, 85374 Neufahrn/München",
      "consolidated": "office discount GmbH"
    },
    {
      "original": "Postbank",
      "consolidated": "Postbank"
    },
    {
      "original": "Postbank Card Service Hamburg",
      "consolidated": "Postbank"
    },
    {
      "original": "Postbank Hamburg Geschäftskundenbetreuung",
      "consolidated": "Postbank"
    },
    {
      "original": "Reinhard Knauft Steuerberater",
      "consolidated": "in stereo Knauft & Schaar Steuerberater GbR"
    },
    {
      "original": "Schönwitz Filmservice Helmut Schönwitz Filmservice",
      "consolidated": "Schönwitz Filmservice"
    },
    {
      "original": "Spafax / Lufthansa",
      "consolidated": "Lufthansa"
    },
    {
      "original": "Steffen Scheunemann, Dorfstr.8a, D-17129 Daberkow",
      "consolidated": "Steffen Scheunemann"
    },
    {
      "original": "Superbude Hotel Hostel Hamburg",
      "consolidated": "Superbude Hotel Hostel Hamburg"
    },
    {
      "original": "Techniker Krankenkasse",
      "consolidated": "Techniker Krankenkasse"
    },
    {
      "original": "Tex Drieschner",
      "consolidated": "Tex Drieschner"
    },
    {
      "original": "Thomann GmbH",
      "consolidated": "Thomann GmbH"
    },
    {
      "original": "Ticketmaster GmbH",
      "consolidated": "Ticketmaster GmbH"
    },
    {
      "original": "WeWatch Security Service GmbH",
      "consolidated": "WeWatch Security Service GmbH"
    },
    {
      "original": "Investitionsbank Berlin",
      "consolidated": "Investitionsbank Berlin"
    }
  ]
}
```

-