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.
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
/
- 1Download the file
s22-fournisseurs-actifs-iban.mdusing the button above. - 2Place 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 - 3Use 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
★ Top