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

  1. 1Identifies the company and its reference currency
  2. 2Retrieves unpaid supplier invoices that are past their due date
  3. 3Sorts them by age: 1-30, 31-60, 61-90 and over 90 days
  4. 4Gives the total for each band in the company's currency
  5. 5Details each invoice: supplier, amount, due date and days overdue
  6. 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

/
  1. 1
    Download the file s25-ap-aging-factures-retard.md using the button above.
  2. 2
    Place 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
  3. 3
    Use 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
95/100ยท๐Ÿ” Ad hocยทExpert

Audit what the MCP covers

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
90/100ยท๐Ÿ“… WeeklyยทBeginner

Card requests via get_requests

Explains how to use get_requests for card requests and why expense reimbursements don't appear there. Avoids a frequent source of confusion between two distinct workflows.

ControllerFinance Analyst
90/100ยท๐Ÿ” Ad hocยทIntermediate

Active vs archived cost centers

Distinguishes active cost centers from archived ones with correct use of get_cost_centers. Avoids the counter-intuitive isArchived vs isActive naming convention pitfall.

ControllerFinance Analyst

Interested in AI Agent services or Custom Integrations?