Active suppliers with banking details (IBAN, BIC)

Lists active suppliers with their complete banking details (IBAN, BIC, country). Essential for payment verifications and banking data audits.

↓ Download skill (.md)
85/100·📅 Weekly·BeginnerAP Manager
Suppliersget_suppliers

🎯 Skill purpose

Lists active suppliers with their complete banking details (IBAN, BIC, country). Essential for payment verifications and banking data audits.

📊 What it produces

Active supplier directory with IBAN, BIC, and bank country for each supplier.

Benefit

Before

Manual supplier reference export, sorting and filtering in Excel for banking data.

After

Complete, instantly filterable supplier banking directory in seconds.



# Instructions

## Use case

List active suppliers with their banking details (IBAN, BIC, country) to prepare payments or check that the details are complete.

## Pitfall 1 — isArchived is a STRING, not a boolean

The `isArchived` parameter of `get_suppliers` is a **string enum**, not a boolean:
- Correct: `isArchived: "false"` (string)
- Incorrect: `isArchived: false` (boolean — ignored or error)

```json
{
  "companyId": "<COMPANY_ID>",
  "isArchived": "false",
  "sortBy": "name",
  "pageSize": 1
}
```

✅ **Bug resolved (verified 2026-07-22, PR #3169)**: the `accountPayable.supplierIds` array (see below) that could push the response past the size limit even at `pageSize=1` (81,179 characters observed) no longer exists in the response — tested live with `pageSize=100` on suppliers sharing a consolidated AP account, no overflow. Normal pagination (`pageSize` 50-100) is reliable again on this type of account.

## Available banking fields

Each supplier returns:

```json
{
  "iban": "FR7617518000010052347500017",
  "bic": "SPDKFRP2XXX",
  "bankCountry": "FR",
  "bankDetailsUpdatedAt": "2026-07-02T06:20:54.000Z",
  "bankDetailsUpdatedBy": "<userId>"
}
```

- `iban`: full IBAN, or `null` if not provided
- `bic`: BIC/SWIFT code, or `null`
- `bankCountry`: bank country (ISO code), can be `null` **or** `""` (empty string) — both mean "not provided"
- `bankDetailsUpdatedAt`: date of the last banking details update
- `bankDetailsUpdatedBy`: userId of the person who updated it (not the name — join with `get_users` if needed)

## Pitfall 2 — No "has an IBAN" / "has no IBAN" filter

There is no `hasIban=true` filter in `get_suppliers`. To get only suppliers **with** an IBAN:
→ Retrieve the full list and filter client-side:
```
suppliers with IBAN = data.filter(s => s.iban && s.iban !== "")
suppliers without IBAN = data.filter(s => !s.iban)
```

The existing `iban` filter is an **exact match** on the IBAN value, not a "not null" filter. It's used to find a supplier by a known IBAN.

## Pitfall 3 — bankCountry inconsistency: null vs empty string

Some suppliers have `bankCountry: ""` (empty string), others have `bankCountry: null`. Both mean "not provided". Always test for both:
```
!s.bankCountry  // covers null AND ""
```

## Pagination — page-based (not cursor)

`get_suppliers` uses **page number** pagination (unlike `get_payables` which uses a cursor):
```json
{ "page": 1, "pageSize": 50 }
```
Check `meta.pagination.hasNextPage` to know whether to continue.

## accountPayable — consolidation object

Some suppliers share an `accountPayable` (same `id`, `generalAccountCode`) — several distinct supplier records point to the same accounting entry (e.g. several Stripe sub-suppliers consolidated under one account). The `supplierIds` array that used to accompany this object and caused the response-size risk above has been removed from the MCP response (PR #3169, verified 2026-07-22) — it's no longer a source of risk. This pattern is explained in [[s14-factures-fournisseur-par-nom]].

## Example user prompts

- "List all active suppliers with their IBAN to prepare July's payments"
- "Which suppliers haven't provided their IBAN yet?"
- "What is the IBAN of the supplier Getsafe GmbH?"

How to install this skill

/
  1. 1
    Download the file s22-fournisseurs-actifs-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 s22-fournisseurs-actifs-iban.md .claude/s22-fournisseurs-actifs-iban.md
  3. 3
    Use in Claude Codethe 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
★ 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
★ Top
88/100·🔍 Ad hoc·Beginner

MCP Product Tour

Visite guidée conversationnelle du MCP Spendesk — appels réels sur les données de l'utilisateur, adaptée à sa persona, puis recommandation des prochains skills à installer

CFOControllerAP Manager