Track overdue supplier invoices
Displays overdue supplier invoices grouped by aging buckets. Handles multi-currency and provides a clear view of outstanding liabilities for management.
CFOAP ManagerController๐
WeeklyIntermediateRead-only
Ask it like this
Which supplier invoices are overdue?
When to use it
When a treasurer or CFO wants to track unpaid supplier invoices by how long they have been overdue.
What it produces
AP aging table: 0-30d, 30-60d, 60-90d, 90+d buckets with amounts and invoice counts.
How it works
- 1Identifies the company and its reference currency
- 2Retrieves unpaid supplier invoices that are past their due date
- 3Sorts them by age: 1-30, 31-60, 61-90 and over 90 days
- 4Gives the total for each band in the company's currency
- 5Details each invoice: supplier, amount, due date and days overdue
- 6Flags invoices more than 90 days overdue as the priority
What protects you
- This skill only reads: it changes nothing in Spendesk
- It acts with your permissions and your role, never beyond
- The assistant cannot approve or pay
โธTechnical detail86/100 ยท 1 tools
SuppliersReconciliationspendesk_get_due_invoices
# Instructions โ AP Aging: overdue invoices by bucket
## โ ๏ธ Critical rule on currencies
`spendesk_get_due_invoices` returns each invoice's amount in **its own spending currency** (e.g. GBP for a GBP invoice). **Do not sum these amounts together.**
The `totalAmount` field per bucket is in **functional currency** (EUR for a EUR company) โ this is the one to use for totals.
Example observed on a real account:
- 1-30 day bucket: 500,000 GBP + 7,373,000 EUR โ **INVALID** to sum
- Bucket `totalAmount`: 79,525.29 EUR โ correct value
## Step 1 โ Identify the company
Call `list_companies` for the company ID. The functional currency is then read from `summary.currency` in the step 2 response (`list_companies` does not return it).
## Step 2 โ Retrieve the aging
Call `spendesk_get_due_invoices` with:
```json
{
"companyId": "...",
"asOfDate": "YYYY-MM-DD",
"includeLineItems": true
}
```
Optional: add `"includeUpcoming": true` to also see invoices with a future due date.
## Step 3 โ Present the results
**Use `totalAmount` per bucket** for totals, not the sum of individual amounts.
```
๐ Supplier outstanding balance as of <asOfDate>
Total overdue: summary.totalOverdueAmount EUR
Bucket | Total (functional EUR) | Nb invoices | Max aging
1-30 days | X EUR | N | 30d
31-60 days | X EUR | N | 60d
61-90 days | X EUR | N | 90d
90+ days | X EUR | N | summary.oldestInvoiceDaysOverdue
```
For each invoice listed:
- Display the amount IN ITS OWN CURRENCY (do not convert manually) + indicate the currency
- Indicate: supplier, invoice number, due date, days overdue, cost center
- Flag invoices 90+ days as priority
## Note on scope
Only `invoicePurchase` with `paymentStatus=toPay` are included. Expense reports, card purchases, and credit notes are excluded. For a full view of all payables with a past dueDate, use `get_payables` with a `dueDate before today` filter.
## Example prompt
- "Which supplier invoices are overdue?"
- "Show the AP aging as of today"
โ ๏ธ A past date in `asOfDate` does not rebuild a historical aging: the tool ages the invoices still unpaid today, at today's balances. Do not present it as the aging of a past close.
How to install this skill
/
- 1Download the file
s25-ap-aging-factures-retard.mdusing the button above. - 2Place the file in the
.claude/directory of your project (or~/.claude/for a global install).cp s25-ap-aging-factures-retard.md .claude/s25-ap-aging-factures-retard.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 spendesk_get_due_invoices.Similar skills
โ
Top