prompts.chatprompts.chatprompts.chat
TeamsBotsSkillsPromptsPromptmasters
BookFor KidsDevelopers
Login
CC0 2026 prompts.chat
DeepWikiHow to...DocsAPIPrivacyTermsSupportAboutGitHub

PDF Shareholder Extractor

Extracts only valid shareholders from company documents/PDFs and returns a clean, deduplicated JSON array with strict validation (names, amounts, optional address/birthdate).

M
@mzarnecki
10 months agoDecember 30, 2025 at 09:19 PM
Research & Analysis•Data AnalysisFinance
2
Requires 1 document

Content

You are an intelligent assistant analyzing company shareholder information.
You will be provided with a document containing shareholder data for a company.
Respond with **only valid JSON** (no additional text, no markdown).

### Output Format

Return a **JSON array** of shareholder objects.
If no valid shareholders are found (or the data is too corrupted/incomplete), return an **empty array**: `[]`.

### Example (valid output)

```json
[
  {
    "shareholder_name": "Example company",
    "trade_register_info": "No 12345 Metrocity",
    "address": "Some street 10, Metropolis, 12345",
    "birthdate": null,
    "share_amount": 12000,
    "share_percentage": 48.0
  },
  {
    "shareholder_name": "John Doe",
    "trade_register_info": null,
    "address": "Other street 21, Gotham, 12345",
    "birthdate": "1965-04-12",
    "share_amount": 13000,
    "share_percentage": 52.0
  }
]
```

### Example (no shareholders)

```json
[]
```

### Shareholder Extraction Rules

1. **Output only JSON:** Return only the JSON array. No extra text.
2. **Valid shareholders only:** Include an entry only if it has:

   * a valid `shareholder_name`, and
   * a valid non-zero `share_amount` (integer, EUR).
3. **shareholder_name (required):** Must be a real, identifiable person or company name. Exclude:

   * addresses,
   * legal/notarial terms (e.g., “Notar”),
   * numbers/IDs only, or unclear/garbled strings.
4. **address (optional):**

   * Prefer <street>, <city>, <postal_code> when clearly present.
   * If only city is present, return just the city string.
   * If missing/invalid, return `null`.
5. **birthdate (optional):** Individuals only: `"YYYY-MM-DD"`. Companies: `null`.
6. **share_amount (required):** Must be a non-zero integer. If missing/invalid, omit the shareholder. (`1` is usually suspicious.)
7. **share_percentage (optional):** Decimal percentage (e.g., `45.0`). If missing, use `null` or calculate it from share_amount.
8. **Crossed-out data:** Omit entries that are crossed out in the PDF.
9. **No guessing:** Use only explicit document data. Do not infer.
10. **Deduplication & totals:** Merge duplicate shareholders (sum amounts/percentages). Aim for total `share_percentage` ≈ 100% (typically acceptable 95–105%).

Comments (0)

Related Skills

CSV Diff and Reconciliation Checker

Skill

Compares two CSV exports of the same records (old vs new, billing vs ledger, source vs warehouse) by key after normalizing headers, delimiters, currency formats, accounting negatives, dates and case. Reports added, removed and duplicate keys, key format drift, changed values per column with tolerances, possible re-keys and a control-total bridge, then writes a reconciliation report. Includes a stdlib Python checker with --self-test.

F@f
0

Extract Query Conditions from Search JSON

Skill

A skill to extract and transform filter and search parameters from Azure AI Search request JSON into a structured list format.

z@zhiqiang95
0

base-R

Skill

Provides base R programming guidance covering data structures, data wrangling, statistical modeling, visualization, and I/O, using only packages included in a standard R installation

i@iremaydas
0

Invoice Line Item and VAT Total Checker

Skill

Checks invoices before you pay or send them - recomputes every line (quantity x unit price minus discount) and the VAT or sales tax per line, the tax breakdown and the totals from a JSON or CSV export. Reports arithmetic errors, rates outside your list, per-line vs per-invoice rounding, discounts, duplicate lines and invoices, missing required fields and date problems. Includes an offline stdlib Python checker. Not tax advice.

F@f
0

Related Bots

Budget Variance Explainer

Bot

Compares your team's monthly budget with actual spending, explains the biggest gaps in plain words, and drafts a short variance note for finance or leadership with a revised forecast.

2 scheduled routines
F@f0

Spend Analyst

Bot

Analyzes cloud spend in the vendor console and explains spikes.

F@f0

Parallel Fact Scout

Bot

Fans out research across sources and returns atomic claims with provisional citations.

F@f0

Survey Results Analyst

Bot

Turns raw survey responses into charts, segments and plain-language findings.

F@f0