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.
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 a raw bank export first. The question list it produces is written in your House style.
- Version:
- 1.2 (October 2026)
Who it's for
Bookkeepers, accounts seniors and managers who look through a client's bank statement before keying it. It's the first look, not the bookkeeping itself.
The problem it solves
Before anyone keys a bank statement into the books, someone looks through it and asks what each item is. Spotting the recurring payments, the large items and the oddities by scrolling through months of transactions is slow, and the questions for the client get written one at a time as they come up.
What it does
What the skill does
Give it the bank export and the period. It takes control totals and checks the closing balance equals the opening balance plus money in minus money out. If the export has no opening balance row it works one out from the first transaction and says so. Then it builds a Summary sheet with formulas: recurring payees (the same payee at least three times in the period or once a month, with how often and the typical amount or range), the largest items in and out, unusual items such as round-sum transfers, duplicates on the same day and items with no description, each with why it was flagged. It also totals money in and out by month. It writes a question list for the client, one question per unusual or unexplained item. It never categorises a transaction; the bookkeeper does that.
Use cases
- Looking through a new client's bank statements before the first bookkeeping
- Finding the recurring payments and receipts in three months of transactions
- Writing the questions for the client about large items with no description
- Spotting round-sum transfers and duplicate payments before they are keyed
- Checking the opening and closing balances agree with the movements
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 bank-statement-summary 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 what counts as large and as recurring, your question style and any payees to ignore.
- 3 In the Copilot pane, open Settings (...), then Manage skills > Custom skills > Create OneDrive folder > Open skills folder.
- 4 Put the bank-statement-summary folder there, then select Refresh. The folder name must match the skill name, so don't rename it.
- 5 Point it at the bank export, give it the period and ask it to summarise the statement and give you the questions for the client.
- 6 Check the control totals, then review the summary and the question list before it goes to the client.
In Cowork
- 1 Download the zip file from this page and unzip it. You'll have a folder called bank-statement-summary 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 what counts as large and as recurring, your question style and any payees to ignore.
- 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 bank-statement-summary 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 bank export, give it the period and ask it to summarise the statement and give you the questions for the client.
- 7 Check the control totals, then review the summary and the question list before it goes to the client.
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: bank-statement-summary
description: "Use when a bank statement export arrives and someone needs the picture before the bookkeeping starts: recurring payments and receipts, the largest items, anything unusual, and a question list for the client. Works from the export with formulas and never categorises transactions on its own."
---
# Bank statement summary
Before anyone keys a bank statement into the books, someone looks through it and asks "what is this?". This skill does the looking: it finds what repeats, what is large, what is odd, and writes the questions for the client. It does not decide what anything is. That is the bookkeeper's job.
## 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.
- "Large" means more than: (default £1,000 or the top 5% of transactions by value, whichever gives more items)
- Recurring means: the same payee (after stripping reference suffixes and card terminal numbers from the description) at least 3 times in the period, or once a month on about the same day. Amounts need not match; show the typical amount as a range where it varies
- Question style: short, one per item, written for the client to answer by email
- Known payees to ignore (the firm's own fees, HMRC PAYE, wages): (list, or leave blank)
## What you need from the user
The bank export (Excel or CSV) and the period. If the export is messy (merged headers, subtotals in the data), say so and suggest running Tidy this export first, or do the minimum cleaning needed and say what you did.
## Method
If the file came straight from Xero, Sage, QuickBooks, FreeAgent or a bank's own CSV, run Tidy this export first; its known export quirks table covers the layouts those produce (separate Spent and Received columns, title blocks, signed single amount columns, repeated headers). This skill expects one header row, real dates and numeric amounts.
1. **Describe the file**: period, number of transactions, columns used for date, description, money in, money out, balance.
2. **Control totals**: count, sum of money in, sum of money out, opening and closing balance, all formulas. If there is no opening balance row, derive it from the first transaction (its balance plus its money out less its money in) and say you did. Check closing equals opening plus in minus out, within £0.01.
3. **Build the Summary sheet** (never overwrite the source):
- **Recurring**: a table of payees that repeat: Payee | Times | Typical amount | Dates | Likely type (left blank for the bookkeeper to fill). Built with COUNTIFS and AVERAGEIFS on a cleaned payee key.
- **Largest**: the top items in and out by value: Date | Description | Amount.
- **Unusual**: round-sum transfers, transfers to or from accounts that look personal, duplicate amounts on the same day, items with no description, weekend transactions over the large threshold, anything paid to the same payee twice in a week. Each with why it was flagged.
- **Totals by month** if the period covers more than one month: money in, money out, net, as SUMIFS.
4. **Question list for the client**: one question per unusual item and per large item that has no obvious description. Written so the client can reply in a line. Grouped by date.
5. **Summary for the user**: five lines on what the account looks like (how many recurring payees, net movement, the three largest items, how many questions).
## Output
1. **The Excel file**: source untouched, Summary sheet with the four blocks, check block, all formulas.
2. **Question list** as text, ready to paste into an email, marked DRAFT.
3. **Summary** for the user.
## Guardrails
- Formulas only.
- Never categorise a transaction (never write "office costs" or "drawings" against anything). The "Likely type" column is left blank for the bookkeeper. If the user asks for categorisation, say that is a different job and the bookkeeper's judgement.
- Never state that a transaction is personal or suspicious. Say "transfer to an account not in the business name, worth confirming".
- If the control totals do not reconcile, say so first. Questions
Questions about this skill
Is the skill free?
Does it change my numbers?
Will it categorise the transactions?
Will it call a transaction suspicious?
What if the export is messy?
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
Tidy this export
Turns a messy bank or practice software export into a clean Excel table on a new sheet, then proves nothing was lost with row counts and totals before and after.
Includes a known export quirks table for Xero, Sage, QuickBooks Online, FreeAgent, bank CSVs and practice software.
- Job
- Getting data in shape
- Works in
- Copilot in Excel, Copilot Cowork
- Chains with
- Run it first on any export, then hand the clean sheet to Bank statement summary, Reconcile two lists, Aged debtors to action, Variance hunter or Year-on-year comparison.
Version 1.2 Download Tidy this export - 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
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.
- Job
- Credit control and deadlines
- 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 Download Aged debtors to action