Aged debtors to action
Builds the ageing from a debtors export with formulas, checks the totals against the source and turns the result into a chase list by stage.
Runs best in: Copilot in Excel, on the open workbook. Use Cowork when you want it run across several files or chained with other skills.
- Works in:
- Copilot in Excel, Copilot Cowork
- Chains with:
- Tidy this export cleans the ledger first; Reconcile two lists tells you what has already been paid. Chase emails use House style.
- Version:
- 1.2 (October 2026)
Who it's for
Credit controllers, practice managers and partners who look after the firm's own debtors or a client's sales ledger. It suits anyone whose Monday morning starts with working out who owes what and who to chase.
The problem it solves
The debtors list is only useful once someone has worked out who owes what for how long and what to do about each one. Doing the ageing by hand takes time, the totals rarely get checked against the source and the chasing ends up being whoever comes to mind first rather than whoever is most overdue.
What it does
What the skill does
Give it a debtors or sales ledger export and an as-at date. It takes control totals from the source, then builds an Ageing sheet with formulas, a summary by client with a column per bucket and a check that the buckets add back to the source total. It turns the result into a chase list where each client's oldest bucket decides the stage and action, drafts one chaser per client on the chase list, listing everything they owe, for the credit controller to check and send, and summarises the total overdue, the largest balances over 60 days and anything odd, such as credit balances or invoices with no date.
Use cases
- Monday morning credit control on the firm's own fees
- Ageing a client's sales ledger as part of their management accounts
- Building a chase list that sends over 90 day balances to partner review
- Holding back chasers for clients who need partner sign-off first
- Spotting credit balances, duplicates and invoices with no date in a debtors export
How to use it
Install it, then use it
Install House style first. It's the one file every skill reads for your firm name, sign-off, voice and format. Fill it in once and this skill's Your firm block only needs the settings for this job. Skip it and the skill asks for your firm name and sign-off once.
In Excel
- 1 Download the zip file from this page and unzip it. You'll have a folder called aged-debtors-to-action with SKILL.md, README.md and an examples folder inside.
- 2 Open SKILL.md in any text editor and fill in the Your firm block at the top, such as your ageing buckets, chase stages, minimum balance and any clients who need partner sign-off before chasing.
- 3 In the Copilot pane, open Settings (...), then Manage skills > Custom skills > Create OneDrive folder > Open skills folder.
- 4 Put the aged-debtors-to-action folder there, then select Refresh. The folder name must match the skill name, so don't rename it.
- 5 Point it at the debtors export, give it the as-at date and ask it to age the debtors and give you the chase list.
- 6 Check the control total check, then work through the chase list and read each client's chaser before anything is sent.
In Cowork
- 1 Download the zip file from this page and unzip it. You'll have a folder called aged-debtors-to-action with SKILL.md, README.md and an examples folder inside.
- 2 Open SKILL.md in any text editor and fill in the Your firm block at the top, such as your ageing buckets, chase stages, minimum balance and any clients who need partner sign-off before chasing.
- 3 Open Customize > Skills, select the arrow next to Add, then Upload skill, and choose the zip (recommended) or the SKILL.md on its own. If you changed SKILL.md, upload that, or zip the folder's contents again first so SKILL.md stays at the top level.
- 4 Or skip the upload and put the aged-debtors-to-action folder in your OneDrive at Documents/Cowork/skills/. Keep the folder name as it is.
- 5 Start a new Cowork conversation so it picks up the skill.
- 6 Point it at the debtors export, give it the as-at date and ask it to age the debtors and give you the chase list.
- 7 Check the control total check, then work through the chase list and read each client's chaser before anything is sent.
The skill itself
Read the full SKILL.md
This is the whole skill. Your firm name, sign-off and voice come from House style. Change the settings under Your firm for anything specific to this job. Everything else follows them.
---
name: aged-debtors-to-action
description: Use when a debtors list or sales ledger export needs turning into an ageing analysis and a chase plan. Builds the ageing buckets with formulas, shows control totals, flags who to chase at each stage and drafts the chase list.
---
# Aged debtors to action
The debtors list is only useful once someone has worked out who owes what for how long, and what to do about each one. This skill does the ageing with formulas, checks the totals against the source, and turns the result into a chase list the credit controller can work through on Monday morning.
## Your firm
Shared settings (firm name, sign-off, voice, how dates and money are written) come from the `house-style` skill in this pack. Fill that in once and every skill uses it. If it is not loaded, ask for the firm name and sign-off once at the start and carry on.
Settings specific to this skill. Edit before first use. If a setting is blank but has a default, use the default and say so in one line. If a blank setting has no default and the job cannot be done without it, ask for all such settings together in one message at the start. If the job can be done without it, leave it out and say so. Never make up a value for a firm setting.
- Ageing buckets (default): Current, 1 to 30 days, 31 to 60, 61 to 90, Over 90
- Age from: due date if present, otherwise invoice date plus standard terms (default 30 days)
- Chase stages: 1 to 30 = friendly reminder; 31 to 60 = second reminder; 61 to 90 = final notice and phone call; over 90 = partner review, possible hold on work
- Minimum balance to chase: (default £50)
- Clients never to chase without partner sign-off: (list, or leave blank)
## What you need from the user
A debtors or sales ledger export with at least: client or customer name, invoice reference, invoice date, amount outstanding. Due date and client type are helpful but optional. The "as at" date for the ageing, default today.
If the file has no invoice date or due date, stop and say so.
## Method
Aged reports from Xero, Sage and QuickBooks arrive with title blocks, one block per customer and subtotal rows. Run Tidy this export first; its known export quirks table says what to remove and what to fill down. This skill expects one row per invoice with the customer name on every row.
1. **Describe the file**: rows, columns, which you will use for name, reference, date and amount, and the as-at date.
2. **Control totals from the source, before anything else**: count of invoices, sum of outstanding, both as formulas. Write them down.
3. **Build the Ageing sheet** (never overwrite the source). Columns: Client | Invoice | Invoice date | Due date | Days overdue | Bucket | Outstanding. Days overdue and Bucket are formulas (days = as-at minus due date; bucket by the firm's bands). Format as a table.
4. **Summary by client**: one row per client with a column per bucket and a total, all SUMIFS formulas. Sort by total outstanding, largest first.
5. **Check**: sum of all buckets equals the source total; count matches. Show Before | After | Difference.
6. **Chase list**: for every client over the minimum balance, their oldest bucket decides the stage. Columns: Client | Total outstanding | Oldest bucket | Stage | Action | Notes. Action comes from the chase stages in Your firm. Clients on the never-chase list get "Partner sign-off needed" instead.
7. **Draft one chaser per client** on the chase list, never one per invoice. Friendly and second reminder stages get an email; final notice gets a call note (what to say, what to ask, what to offer) with a short email to follow the call; partner review gets a one-paragraph briefing for the partner, not a message to the client. Each chaser lists every overdue item for that client (invoice number, date, amount), nets any credit note and states the total owed, in the house style, under 150 words, marked DRAFT. Where a client has items at more than one stage, write one chaser at the most serious stage and mention the rest. Clients under the minimum balance or on the never-chase list get no chaser.
8. **Summary for the user**: total overdue, number of clients at each stage, the three largest balances over 60 days, and anything odd (credit balances, invoices with no date, duplicates).
## Output
1. **The Excel file**: source untouched, Ageing sheet, Summary sheet, Chase list sheet, check block, all formulas.
2. **Chasers**, one per client on the chase list, each marked DRAFT.
3. **Summary** for the user.
## Guardrails
- Never promise a response time, reminder, call, service or outcome that is not in the input, the house style or Your firm.
- Formulas only. No typed results in any calculated cell.
- If the check does not reconcile, say so first and do not produce the chase list.
- Never draft a chaser that mentions legal action, debt collection or interest. If a client is over 90 days, the action is "partner review", not a threat.
- Credit balances and negative amounts are listed as exceptions in the summary, never netted silently. They may be netted in the chase for that client, but the chaser must mention the credit. Questions
Questions about this skill
Is the skill free?
Does it change my numbers?
Does it send anything?
Will it threaten clients?
Is there a sample to try?
Firmwide
Want your own firm's procedures built in and kept working? That's a Firmwide install.
A fixed-price install, typically six to eight weeks: Copilot made safe and useful in your Microsoft 365, an agent and a skills pack for every department, handed over with training. Then Run keeps it working.
Next step
Want this tailored to your firm?
A free 30-minute Copilot Readiness Check with James, online. You leave knowing where Copilot can and cannot see your data, the two jobs to automate first and a rough install price. Your own skills, built from your procedures and handed over to each department on its own work.
Related skills
All skills- Excel Has example + expected result Works for any team
Reconcile two lists
Give it two lists that should agree. It matches them and builds a reconciliation sheet with formulas, with control totals proving the difference is fully explained.
- Job
- Getting data in shape
- Works in
- Copilot in Excel, Copilot Cowork
- Chains with
- Tidy this export cleans the inputs first. Unmatched invoices go to Aged debtors to action for chasing.
Version 1.2 Download Reconcile two lists - Excel Has example + expected result
Bank statement summary
Looks through the bank statement before the bookkeeping starts. It finds what repeats, what is large and what is odd, then writes the question list for the client.
- Job
- Getting data in shape
- Works in
- Copilot in Excel, Copilot Cowork
- Chains with
- Tidy this export cleans a raw bank export first. The question list it produces is written in your House style.
Version 1.2 Download Bank statement summary - Cowork
Quarter chaser (MTD)
Before each MTD for Income Tax quarterly deadline, it drafts a personalised chaser for every client still owing records and builds a chase log in Excel.
- Job
- Credit control and deadlines
- Works in
- Copilot Cowork
- Chains with
- Where clients send records comes from New client onboarding and House style. Chaser emails use House style.
Version 1.2 Download Quarter chaser (MTD)