Overdue Suppliers Ranking
- Last updated
- Nov 2026
- Built by
- Moss Finance
Lists suppliers with overdue invoices, ranked by days overdue and by amount.
Ranked by overdue amount (2 suppliers, £729.80)
| Supplier | Invoices | Due | Overdue | Amount | Invoice | ID |
|---|---|---|---|---|---|---|
| Adobe | 1 | 31 Oct | 11 days | £455.30 | INV-6130 | 1d69e9f3-4973-4513-a8b6-2ba1fb837ac5 |
| Uber | 1 | 28 Oct | 14 days | £274.50 | INV-5521 | eb2aa142-1d06-451f-80e7-d8bf08445429 |
Credit notes, listed apart
Google: 2 credit notes, -£1,007.60, oldest due 13 Mar (243 days). CN-0128, ID 27f6fbcb-2d30-4cc3-82ec-e36a6ff8f102. CN-0164, ID 51b0a2ad-8e1f-40ec-951a-deafe99173da
What it does
Instead of sorting the invoice list by hand to see whom you owe the most or the longest, this prompt ranks every supplier with overdue invoices, so you know whom to pay first to cover big amounts.
Use it weekly and before a payment run.
Prompt
Copy the prompt, then replace the highlighted placeholders in your AI assistant.
Overdue Suppliers Ranking: Use Moss MCP Use AskUserQuestion (clickable multiple choice) to collect [inputs] first. Offer my real entities from Moss as options. Ask me to type names, dates and numbers in chat. If I pick Other, ask again for the exact value. INPUTS • Entity: [choose an entity or All entities] • Ranking: [days overdue or amount] • Top: [number] • Delivery: [overview in chat, or Excel overview] RULES • Find all overdue invoices in Moss (unpaid, due date before today) and rank the suppliers you owe the most. Exclude drafts and rejected invoices. • Rank in the entity currency and show each original currency next to it. List credit notes (negative amounts) apart. OUTPUT • The top suppliers: number of overdue invoices, oldest due date, days overdue and total overdue amount. • Under each supplier, its overdue invoices with transaction ID, number, due date and gross amount. • Total overdue per currency, and the credit notes listed apart.
Set it up
Connect Moss once, then copy the prompt or save it as a skill. Each takes about two minutes.
Connect Moss to your AI assistant
Once · about 2 minutesAdd the Moss connector and sign in with your Moss account.
On a team or enterprise plan, a workspace admin may need to allow custom connectors before you can add Moss.
Choose how you use it
Pick oneCopy the prompt for a quick run, or save it as a skill so Claude runs it the same way every time.
- Copy the prompt from this page.
- Paste it into a new chat with Moss MCP switched on.
- Replace the highlighted placeholders and send.
Check a few transactions through the Moss links before you send any reminders.
How MCP works
MCP is an open standard that lets your LLM look things up in other tools. The Moss MCP gives it read access to your Moss data, so it answers from your real numbers.
Link Moss to your LLM once
You sign in with your Moss account. After that, your LLM can reach Moss whenever you ask.
Use a prompt in plain English
Your LLM asks the Moss MCP for what it needs, such as expenses, budgets, bank transactions or receipt files.
An answer from your own data
Lists, summaries and drafts based on what is in Moss. Nothing in Moss is changed.
What MCP can see
You stay in control. The Moss MCP only reads data. It can't change or pay anything.
| It can | It can't |
|---|---|
| Read card transactions and their receipt status | Change, approve or delete anything |
| Read cardholders, teams and entities | Make payments or move money |
FAQ
Yes, for the data. The connector reads your own Moss data, so you need a Moss account.
Goes well with
Quick Past Coding Lookup
Shows how a supplier or invoice was coded in the past, over all time or a period you choose.
Invoices Due and Overdue
Lists unpaid invoices due soon, shows overdue ones separately and compares the total with your balance.