Aged debtors to action

Excel Has example + expected result Credit control and deadlines

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. 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. 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. 3 In the Copilot pane, open Settings (...), then Manage skills > Custom skills > Create OneDrive folder > Open skills folder.
  4. 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. 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. 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. 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. 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. 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. 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. 5 Start a new Cowork conversation so it picks up the skill.
  6. 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. 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.

aged-debtors-to-action/SKILL.md
---
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?
Yes. Download it, fill in the Your firm block and use it. There is no email form and no charge.
Does it change my numbers?
No. It builds new Ageing, Summary and Chase list sheets and leaves the source untouched. Every calculated cell is a formula, and credit balances and negative amounts are listed as exceptions in the summary, never netted silently. A chaser may net a credit note against what that client owes, but it has to say so.
Does it send anything?
No. It drafts one chaser per client on the chase list, each marked DRAFT: an email at the reminder stages, a call note with a short follow-up email at final notice and a short briefing for the partner at partner review. Each one lists every overdue item for that client and the total owed. The credit controller checks them and sends them.
Will it threaten clients?
No. It never drafts a chaser that mentions legal action, debt collection or interest. A client over 90 days goes to partner review, not a letter about solicitors.
Is there a sample to try?
Yes. The download includes a 15-line debtors export across eight clients in the examples folder, with a spread of ages, one credit note, one invoice with no due date and one balance under the minimum chase amount. The examples folder also has expected.md, which lists the exact figures, flags and fail conditions the skill should produce on the sample, so you can check the result in a minute and re-check it after Copilot updates.

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.

See Firmwide

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)