Quick Answer
Export your Profit & Loss and Balance Sheet from Xero as Excel files. Open Claude Cowork (Pro plan, roughly £16 per month). Drop the files in, paste the trades-specific prompt template from this guide, and Claude will generate a full management accounts pack with P&L summary, cash flow commentary, KPI dashboard, and written narrative. The whole process takes 20 to 30 minutes once you have done it twice. It replaces a task that costs £200 to £400 a month outsourced, or 4 to 6 hours doing it yourself in spreadsheets.
Table of Contents
- Why monthly management accounts matter for trades businesses
- What Claude Cowork actually is (and what it is not)
- What you need before you start
- Step 1: Export your Xero reports
- Step 2: The trades management accounts prompt template
- Step 3: Review, adjust, and save your pack
- Trades-specific KPIs to track monthly
- Cost comparison: accountant vs DIY vs Claude
- What Claude gets wrong (and how to catch it)
- What tradespeople and accountants are saying
- Recommended videos
- Frequently asked questions
- My verdict
Claude
Xero
SageWhy monthly management accounts matter for trades businesses
Most trades business owners I speak to know their bank balance and not much else. They check the account on a Monday morning and feel either relieved or sick. That is not financial management. That is hope.
Management accounts are internal financial reports you produce for yourself, not for HMRC, not for your accountant. They show you what actually happened last month: where the money came in, where it went, which job types made money, and which quietly bled cash.
For a plumbing and heating firm running five engineers, the difference between a 12% net margin and a 7% net margin on boiler installations is the difference between growing and standing still. But you will never see that number unless someone puts it in front of you every month.
According to UK government data, 60% of small construction businesses that fail cite poor financial visibility as a contributing factor. Monthly management accounts are the single most effective tool for spotting problems before they become terminal. An outsourced bookkeeper charges £200 to £400 per month for this work. Claude Cowork does it for £16.
The typical management accounts pack for a trades business includes a Profit & Loss statement (compared to the prior month and to budget), a balance sheet summary, a cash flow statement, aged debtors and creditors, and a written commentary explaining what the numbers mean. For businesses operating under CIS, you also need a deduction summary.
The problem has never been "should I do this?" The problem is time. When you are running jobs, managing staff, quoting, and chasing payments, sitting down with a spreadsheet for half a day is not realistic. That is where AI changes the equation.
What Claude Cowork actually is (and what it is not)
Claude Cowork is Anthropic's desktop AI tool. It runs inside the Claude desktop app on macOS or Windows. Unlike a chatbot that just answers questions, Cowork can actually see your screen, read files on your computer, and create new documents. It is the difference between asking someone for directions and having them drive the car.
For management accounts, the key capabilities are:
- File reading: Cowork opens and analyses Excel (.xlsx), CSV, and PDF files directly from your local folders. No uploading required.
- Multi-tab navigation: It can work across multiple tabs in an Excel workbook and reference specific cells.
- File creation: It generates formatted Excel files with working formulas, plus Word documents and PDFs.
- Financial analysis: It can run variance analysis, calculate ratios, draft management commentary, and compare periods.
Cowork is available on the Pro plan at roughly $20 per month (approximately £16 to £18 depending on exchange rate). The Pro plan gives you three to five serious Cowork tasks per day, which is plenty for monthly management accounts. If you need more, the Max plan at $100 per month (roughly £80) gives unlimited use.
Cowork is not an accountant. It does not replace professional advice for tax returns, statutory accounts, or regulatory filings. It does not recalculate Excel formulas (it reads stored values). It can sometimes present wrong numbers with confidence. Always review the output. Think of it as a very fast, very cheap first draft, not the final word.
One more thing. Cowork operates on your local files. That means your financial data stays on your machine. It is not uploaded to a cloud service for processing in the same way that pasting data into a web-based chatbot would be. Anthropic's privacy policy still applies, so read the terms, but the architecture is meaningfully different from copy-pasting sensitive figures into a browser window.
What you need before you start
This is a short list. You probably have everything already.
- Xero account on any paid plan (Ignite at £16 per month works fine, Grow at £37 per month if you need unlimited invoicing). If you have not set up Xero yet, our MTD Phase 2 setup walkthrough covers the full process. If you use Sage or QuickBooks instead, the same approach works; you just export different reports. See our accounting software comparison for details.
- Claude Pro subscription ($20 per month, roughly £16 to £18). Sign up at claude.ai.
- Claude desktop app installed on macOS or Windows. Download from claude.ai/download.
- A dedicated folder on your computer for management accounts. Something like
Documents/Management-Accounts/2026/with subfolders for each month.
Create a CLAUDE.md file in your management accounts folder with standing instructions. Cowork reads this file automatically every time it opens the folder. Put your business name, financial year end, chart of accounts structure, and any recurring notes (e.g. "CIS contractor, 20% deduction rate"). This saves you repeating context every month.
Total monthly cost: roughly £32 to £55 depending on your Xero plan. Compare that to £200 to £400 for a bookkeeper to produce the same pack.
Step 1: Export your Xero reports
Log into Xero. Navigate to Accounting > Reports. You need five exports, all for the same month:
- Profit & Loss: Set the date range to the calendar month. Click Export > Excel. This is your primary income and expenditure statement.
- Balance Sheet: Set the date to the last day of the month. Export as Excel.
- Aged Receivables: Shows who owes you money and how overdue it is. Export as Excel.
- Aged Payables: Shows what you owe suppliers. Export as Excel.
- Cash Summary (optional but recommended): Shows bank account movements. Export as Excel.
Save all five files into your monthly subfolder: Documents/Management-Accounts/2026/May/
If you want to compare against budget, also export a Budget Summary report or create a simple budget spreadsheet. Claude can compare actuals to budget if you give it both files.
Also export your CIS Deductions report from the Payroll section. Claude will include CIS deductions as a separate line in your management accounts, which is critical for accurate CIS reporting.
The whole export process takes five minutes once you have done it once. If you want to automate this step entirely, our n8n integration guide shows how to schedule automatic Xero exports.
Step 2: The trades management accounts prompt template
This is the core of the process. Open the Claude desktop app, navigate to your monthly folder in Cowork, and paste this prompt. I have tested this across plumbing, electrical, and general building businesses.
Read all the Excel files in this folder. These are Xero exports for [MONTH] [YEAR] for [YOUR BUSINESS NAME], a [YOUR TRADE] business based in [LOCATION].
Produce a monthly management accounts pack containing:
1. PROFIT & LOSS SUMMARY: Revenue by category, direct costs (materials, subcontractor labour, CIS deductions if applicable), gross profit and margin %, overheads itemised, net profit and margin %. Compare to prior month if data available.
2. CASH POSITION: Opening balance, cash received, cash paid out, closing balance, net movement.
3. DEBTORS & CREDITORS: Total owed to us, aged breakdown (current, 30 days, 60 days, 90+ days). Total we owe, same breakdown. Flag anything over 60 days.
4. KEY KPIs: Gross margin %, net margin %, debtor days, creditor days, cash runway in months, revenue per employee (if staff costs visible).
5. MANAGEMENT COMMENTARY: A plain-English narrative (300 words max) explaining what happened this month, what is going well, what needs attention, and one recommended action.
Format as a clean Excel workbook with separate tabs for each section. Use bold headers, consistent number formatting (£ with commas, 1 decimal for percentages), and conditional formatting to highlight negative variances in red.
Hit enter and let Cowork process the files. On a Pro plan, this typically takes two to four minutes. Cowork will read through each Excel file, cross-reference the figures, calculate the ratios, and produce the output.
For businesses running under CIS, add this line to the prompt: "Include a CIS deductions summary showing gross payments, deductions at 20% and 30%, and net payments to subcontractors this month."
For businesses tracking job profitability, add: "If project or tracking category data is available, break down gross profit by job type or project."
Step 3: Review, adjust, and save your pack
Claude will produce an Excel workbook. Open it. Check these things first:
- Does the total revenue match your Xero P&L? If it does not, tell Claude. It will re-read the source file and correct itself.
- Do the balance sheet figures match? Cowork reads stored cell values, not formulas, so occasionally it picks up a subtotal instead of a total.
- Is the management commentary accurate? Claude writes plausible-sounding narrative. Make sure the "what went well" section actually reflects something that went well, not a generic statement.
- Are the KPIs calculated correctly? Check gross margin manually on one line. If it is right, the rest almost certainly is too.
If something needs changing, just tell Cowork in plain English: "The materials figure on the P&L tab should be £14,200, not £12,400. Please correct and recalculate all dependent figures." It will update the file in place.
Save the final version in your monthly folder. Print a copy if you like paper. Email it to your business partner, your accountant, or your bank manager. Having a clean management accounts pack ready at the start of each month changes how people perceive your business.
Send the Claude-generated pack to your accountant as a starting point. They can review and refine it in 30 minutes instead of building it from scratch in 3 hours. Some accountants will reduce your monthly fee if you provide well-prepared management accounts. Ask the question.
Trades-specific KPIs to track monthly
Generic KPI dashboards miss the things that actually matter in a trades business. These are the numbers I would look at every month:
| KPI | What it tells you | Target range |
|---|---|---|
| Gross margin % | Profitability before overheads | 30-45% for most trades |
| Net margin % | What you actually keep | 8-15% |
| Debtor days | How fast customers pay | Under 30 days |
| Materials as % of revenue | Whether you are buying efficiently | 25-35% |
| Labour cost per engineer | Payroll efficiency | Track trend, not absolute |
| Revenue per engineer | Productivity and utilisation | £8,000-£15,000 per month |
| Cash runway | Months of operating expenses covered | 3+ months minimum |
| WIP value | Work completed but not yet invoiced | Monitor for build-up |
Add these to your Claude prompt if you want them calculated automatically. The prompt template above already includes the core ones. For MTD Phase 2 compliance, having clean monthly figures also makes quarterly digital submissions straightforward.
Cost comparison: accountant vs DIY vs Claude
Here is the honest breakdown. No sugar-coating.
| Method | Monthly cost | Your time | Accuracy | Best for |
|---|---|---|---|---|
| Outsource to bookkeeper | £200-£400 | 10 minutes | High | Businesses over £500k turnover |
| DIY in spreadsheets | £0 | 4-6 hours | Variable | Sole traders with simple books |
| Claude Cowork + Xero | £16-£55 | 20-30 minutes | Good (needs review) | Growing businesses, 2-15 staff |
The sweet spot for Claude is a trades business turning over £150,000 to £1 million with two to fifteen people. You are big enough that management accounts matter, but not so big that you have a finance director or full-time bookkeeper. The AI-first approach can cut your operating costs meaningfully at this stage.
If you are a sole trader doing under £85,000, the DIY spreadsheet approach might be enough. If you are north of £1 million with complex job costing and multiple cost centres, keep your accountant but use Claude to prepare the first draft and cut their hours.
What Claude gets wrong (and how to catch it)
I have used Cowork for financial work for several months. Here is what trips it up:
- Subtotals vs totals. When reading Xero exports with nested categories, Cowork occasionally picks up a subtotal row and adds it to the category total, double-counting. Check your revenue and cost totals against the Xero source.
- Confident wrong numbers. Claude does not say "I think" or "approximately" when it should. It states £42,300 when the real figure is £43,200 as if both are equally valid. Cross-reference the big numbers.
- Generic commentary. The management narrative can sound plausible but hollow. "Revenue increased due to seasonal demand" is not useful. Push back: "Be more specific. What category of revenue increased? By how much? Why?"
- Excel formula limitations. Cowork creates Excel files with formulas, but it reads source files using stored values only. If your Xero export has a formula that has not been recalculated, Claude sees the old value.
- Token consumption. Complex spreadsheets with many tabs consume Claude's usage limit quickly. On a Pro plan, two to three management accounts sessions per day is realistic. If you are processing multiple businesses, consider the Max plan.
Cowork can modify and delete files on your computer. There was a widely reported incident where a user asked Cowork to "clean up" a folder and it deleted 11GB of files. Create your exports in a dedicated folder. Do not point Cowork at your main Documents directory. Better yet, work from copies of your Xero exports, not the originals.
None of these are dealbreakers. They are the same kinds of errors a junior bookkeeper might make. The difference is Claude makes them in three minutes instead of three hours, and corrects them in seconds when you point them out.
What tradespeople and accountants are saying
Recommended videos
I Built a Full Accounting Team with Claude Code & Skills
Free workflow for accounting automation
How to Use Claude Cowork For Finance Like a PRO
Finance-specific Cowork tutorial
AI Auto-Categorises 12 Months of Expenses in Under 3 Minutes
Claude expense categorisation in Excel
Master Claude for Excel in 10 Minutes: Financial Modelling
Excel add-in for financial work
My New AI Accounting Assistant: 1,000+ PDFs Automated with Claude
Real accounting automation with Claude
How to Run a Profit and Loss Report in Xero (2026)
Xero P&L export tutorial
What Are Management Accounts in the UK? (2025-26 Guide)
UK-specific management accounts explainer
FULL Claude Cowork Tutorial For Beginners in 2026
Complete beginner's guide to Cowork
Frequently asked questions
No. Claude produces management accounts for your internal use. It cannot file tax returns, produce statutory accounts, or give tax advice. Keep your accountant for compliance work. Use Claude to do the heavy lifting on monthly reporting so your accountant can focus on the stuff that actually requires professional judgement.
Yes. Export your P&L, Balance Sheet, and Aged Debtors/Creditors as Excel files from whichever platform you use. The prompt template works the same way. Xero just happens to have the cleanest Excel exports, which is why I use it as the example here.
Cowork runs locally and reads files from your computer rather than requiring uploads to a cloud service. That said, Anthropic's privacy terms still apply. Do not use Cowork for client data if you are a practice. For your own business accounts, the risk profile is similar to using any desktop software. Read the terms yourself and make your own call.
It will, occasionally. Check the revenue total and one or two expense categories against your Xero source file. If the headline numbers match, the detail is almost always correct. If something is off, just tell Claude and it fixes it in seconds. Think of it as a fast first draft from a junior, not a polished document from a partner.
Pro gives you three to five serious Cowork tasks per day. Monthly management accounts is one task. You have plenty of capacity. If you also use Cowork for quoting, email drafting, or other business tasks, you might hit the daily limit on busy days. The Max plan removes that cap entirely.
Yes, if you export the CIS report from Xero and include it with the other files. Add a line to the prompt asking for a CIS deductions summary. Claude will separate gross payments, deductions at 20% and 30%, and net payments to subcontractors.
My verdict
The trades gave me everything. The discipline, the work ethic, the problem-solving mindset. Technology just gives us new ways to apply it. Claude Cowork is not going to replace your accountant or make financial management optional. What it does is take a task that most growing trades businesses know they should do but never find time for, and make it achievable. Twenty minutes a month. That is all it takes to go from checking your bank balance and hoping for the best to actually understanding your numbers. For £16 a month, I think that is a no-brainer for any trades business turning over more than £150,000. Start with the prompt template in this guide. Run it once. You will see the value immediately.
