Suppliers without IBAN

Identifies suppliers missing an IBAN by paginating the entire supplier directory. Critical to unblock payments awaiting complete banking details.

↓ Download skill (.md)
83/100Β·πŸ” Ad hocΒ·BeginnerAP Manager
SuppliersComplianceget_suppliers

🎯 Skill purpose

Identifies suppliers missing an IBAN by paginating the entire supplier directory. Critical to unblock payments awaiting complete banking details.

πŸ“Š What it produces

List of suppliers without IBAN with their status, pending invoiced amount, and contact.

⚑ Benefit

Before

Manual supplier-by-supplier check in the interface β€” tedious and incomplete.

After

Complete list of suppliers to complete, ready for follow-up and reminders.



# Instructions β€” Suppliers without an IBAN

## ⚠️ No hasIban=false filter

Filters available on `get_suppliers`:
- `ids`, `search`, `isArchived`, `iban` (exact match), `bankCountry`, `vatNumber`
- `createdAfter/Before`, `updatedAfter/Before`, `sortBy`, `sort`

**What does NOT exist**: `hasIban=false` or `ibanIsNull=true`

β†’ You must retrieve **all suppliers** and filter client-side.

## Step 1 β€” Paginate through all active suppliers

βœ… **Bug resolved (verified 2026-07-22, PR #3169)**: `get_suppliers` no longer returns an `accountPayable.supplierIds` array β€” tested live with `pageSize=100` on suppliers sharing a consolidated AP account, no response-size overflow. The old risk of exceeding the response limit even at `pageSize=1` (81,179 characters) is no longer reproducible; see [[s22-fournisseurs-actifs-iban]] for details.

```json
{ "companyId": "...", "isArchived": "false", "pageSize": 100, "page": 1 }
```

Repeat with `page=2, 3, ...` until `hasNextPage=false`. **Before starting**: warn the user that this can still take several calls on a large master data set.

⚠️ Do not draw conclusions from the first page only β€” suppliers with an IBAN may be on other pages.

## Step 2 β€” Filter client-side

For each supplier returned, check:
```
if iban == null AND bankAccount == null β†’ no banking data
if iban != null β†’ IBAN available (can wire)
if bankAccount != null β†’ bank account without a standard IBAN
```

Note: `bankAccount` can contain non-IBAN banking data (e.g. UK sort code, US routing number).

## Step 3 β€” Display the report

Display two lists:
1. **Suppliers without an IBAN** (iban=null) β€” name + id β€” you cannot wire money to these
2. **Suppliers with an IBAN** β€” name + truncated IBAN β€” ready for wire transfer

Always disclose the scope: *"Based on X active suppliers. Archived suppliers are not included."*

## Step 4 β€” Use case: supplier follow-up

⚠️ **`get_suppliers` returns no email/contact field at all** (verified live β€” confirmed by PR #3152, which dropped the "contact details" claim from the tool description since no contact field exists on the read path). No direct email follow-up via this tool.
β†’ Extract name + id to prepare the follow-up, and find the email through another channel (Spendesk app, or `get_requests` if the IBAN request is tied to an existing request).

## Live example (real data, first page)

- 20 suppliers returned, `hasNextPage=true` (incomplete list)
- 1/20 with an IBAN: +Simple.fr β€” `FR76151350050008004002...` (truncated for display)
- 19/20 with iban=null β€” including suppliers like 't Hotel, Oracle (id: 5lwylc0am6e0p7)...
- `bankAccount` = null for all 20 on the first page

## Example prompt

- "Which suppliers have no IBAN?" β†’ paginate all + filter iban=null
- "List the suppliers we can wire money to" β†’ filter iban != null
- "How many active suppliers have banking details?" β†’ count iban != null on the full list

How to install this skill

/
  1. 1
    Download the file s23-suppliers-sans-iban.md using the button above.
  2. 2
    Place the file in the .claude/ directory of your project (or ~/.claude/ for a global install).
    cp s23-suppliers-sans-iban.md .claude/s23-suppliers-sans-iban.md
  3. 3
    Use in Claude Code β€” the skill is automatically discovered. Describe your need in natural language and Claude will apply the skill instructions.
πŸ’‘ Make sure the Spendesk MCP is configured in your .claude/settings.json with the tools get_suppliers.

Similar skills

β˜… Top
95/100Β·πŸ” Ad hocΒ·Expert

MCP coverage audit & gap analysis

Probes all available MCP tools, re-evaluates coverage of 50 persona use cases, detects new fields or tools, and regenerates the gap analysis report.

CFOControllerAP Manager
90/100Β·πŸ“… WeeklyΒ·Beginner

Card requests via get_requests

Explains how to use get_requests for card requests and why expense reimbursements don't appear there. Avoids a frequent source of confusion between two distinct workflows.

ControllerFinance Analyst
β˜… Top
89/100Β·πŸ” Ad hocΒ·Intermediate

Skill Builder

Aide un client Γ  transformer un besoin mΓ©tier prΓ©cis (contexte, contraintes, format de sortie souhaitΓ©) en un nouveau skill Claude sur mesure, prΓͺt Γ  l'emploi sur le MCP Spendesk

CFOControllerAP Manager