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` โ note that `null` does not prove there are no bank details: account number, routing number and sort code (non-IBAN suppliers) are never returned
- `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