Suppliers without IBAN
Identifies suppliers missing an IBAN by paginating the entire supplier directory. Critical to unblock payments awaiting complete banking details.
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
/
- 1Download the file
s23-suppliers-sans-iban.mdusing the button above. - 2Place 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 - 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