Our WorkAll ServicesAI VisibilitySEO AutomationProduct ManagementClaude AI ServicesZatrovo BookingStart a Project
revenue · 8 min read · 2 November 2026

Profit Margin Analysis with Claude AI: Find Your Best Jobs

A practical guide to profit margin analysis for UK small businesses using Claude AI: export job data, rank jobs by true margin and spot which work to chase.

Jacob Horgan, Founder, Irvale Studio
Jacob Horgan
Founder, Irvale Studio
UK tradesperson reviewing job costs and profit margins on a laptop in a small workshop office.

Most small business owners know their turnover to the pound and their bank balance to the penny. Far fewer can say which of their jobs, products or customers actually make money. Profit margin analysis answers that question, and a general AI assistant like Claude has made it practical for owners who do not have a finance team or the patience for pivot tables.

This guide covers how to run a profit margin analysis for a small business with Claude, step by step: the data you need, the prompts that work, the mistakes to avoid and the limits you should respect.

What is profit margin analysis for a small business?

Profit margin analysis for a small business means working out how much profit each job, product, service or customer leaves behind after the costs of delivering it, then comparing them so you can see which work is worth chasing and which is quietly costing you.

At business level, your accountant already gives you a margin figure once a year. That number is useful for tax and lending, but it hides everything that matters for day-to-day decisions. A plumbing firm might have a healthy overall margin while profitable emergency call-outs carry boiler installs that barely cover their costs. A café might find its lunch trade pays for a breakfast service that runs at a loss once staff hours are counted.

The useful version works at job or line level. For each piece of work you record the price charged, the direct costs (materials, subcontractors, the labour hours spent on it, travel) and the resulting gross margin. Once that exists for a full year of work, patterns appear quickly.

Why should UK small businesses check margins now?

UK businesses should review margins now because input costs have risen faster than many selling prices, and quotes set a year or more ago may no longer cover the true cost of delivering the work.

The official figures show the pressure clearly.

7.3%Rise in UK producer input prices, year to June 2026
Source: ONS
3.5%Rise in UK factory gate output prices, year to June 2026
Source: ONS
4.3%Rise in UK services producer prices, year to Q2 2026
Source: ONS

According to the ONS producer price inflation bulletin for June 2026, producer input prices rose 7.3% in the year to June 2026, down from a revised 9.3% in May, while output prices rose 3.5%. The ONS also reports that services producer prices rose 4.3% in the year to the second quarter. When the cost of inputs climbs faster than the price of outputs, someone's margin is being squeezed. For a small firm buying materials from those producers, the squeeze often lands on job types that were priced from memory and never revisited.

What data do you need before asking Claude?

You need a single export listing each job or sale with its date, type, price charged and direct costs, ideally covering a full year so seasonal swings do not distort the picture.

Pull this from wherever it already lives. Xero, QuickBooks, FreeAgent and most job management tools (ServiceM8, Tradify, Jobber) will export invoices to CSV or Excel. Costs are usually the harder part. Supplier bills may be coded to jobs, or they may sit in a general materials account. If your bookkeeping does not tag costs to jobs yet, that is the first thing to fix, and our guide to AI bookkeeping for UK small businesses covers how to get coding consistent.

The minimum useful columns are:

  • Job reference (not the customer's name)
  • Date completed
  • Job type or product category
  • Price charged, excluding VAT
  • Materials and subcontractor costs
  • Labour hours, plus the hourly cost of the person who did them
  • Travel or call-out costs, if significant

Labour is the column owners most often skip, and it is usually the one that changes the answer. A job that looks profitable on materials alone can turn negative once the hours are priced in.

How do you run the analysis in Claude step by step?

Upload your cleaned export to Claude with file creation and analysis switched on, tell Claude exactly how to calculate margin, ask it to group results by job type, then check its working against jobs you already know.

Anthropic's file creation announcement says Claude can take raw data and return cleaned data, statistical analysis, charts and written explanations, and can build spreadsheets with working formulas across multiple sheets. The feature was announced on 9 September 2025 and made generally available for paid plans on 21 October 2025. If it is not already on, look for "Upgraded file creation and analysis" in Claude's settings.

A prompt that works well:

Here is a year of completed jobs. For each row, calculate gross profit as price minus materials, subcontractors, labour (hours multiplied by hourly cost) and travel. Then calculate gross margin as gross profit divided by price. Group by job type and show total revenue, total gross profit, average margin and number of jobs. Rank job types by total gross profit, not by margin. Return an Excel file with formulas visible, and list any rows with missing or odd values.

Three details in that prompt do a lot of the work. Defining the formula stops Claude guessing. Ranking by total profit as well as margin keeps a high-margin job you do rarely from looking more important than a moderate-margin job you do every week. Asking for odd values flags the data entry errors that would otherwise skew everything.

How do you check that Claude's numbers are right?

Pick a handful of jobs you remember clearly, work out their margin by hand, and compare them with Claude's spreadsheet before trusting any ranking it produces.

Claude writes the formulas, so open the file and read them. Check that VAT has been stripped, that labour uses the cost rate rather than the charge-out rate, and that refunds or credit notes have not been counted as fresh jobs. If a job type has very few rows, treat its average as a hint, not a finding.

What should you look for in the results?

Look for job types with high volume and thin margin, customers whose work is consistently less profitable than average, and any category where margin has fallen over the year as costs rose.

Useful follow-up questions to ask Claude in the same chat:

  • Which job types have the lowest margin but the highest number of jobs?
  • How has margin on each job type changed by quarter?
  • Which repeat customers are below the business average?
  • If I raised prices on the weakest job type by enough to reach the average margin, what would that price be?

The quarterly view matters this year. If margin on a job type started to slide in the spring, that lines up with a period when the ONS recorded input prices rising sharply. It tells you which quotes need repricing first. Pair this with a forward view of cash, covered in our guide to AI cash flow forecasting, so a pricing change and its cash effect are planned together.

Is it safe to upload business data to Claude?

It is reasonably safe if you remove personal data first, because margin analysis needs figures and job types, not customer names, addresses or contact details.

Anthropic is direct about the risk. Its file creation post states that the feature "gives Claude internet access to create and analyze files, which may put your data at risk" and advises users to monitor chats closely. Take that seriously. Replace names with job references before uploading, delete columns you do not need, and keep the original file on your own system. Under UK GDPR you remain responsible for customer data you share with any tool, and our AI data protection checklist walks through the checks worth making first.

How much does it cost to do this with Claude?

A single owner can run margin reviews on Claude's Pro plan, which Claude's pricing page lists at $20 a month billed monthly or $17 a month billed annually, with the final charge in pounds shown at checkout.

The Claude pricing page lists prices in US dollars, so check the sterling amount when you subscribe. The free plan includes file creation, so you can test the approach on a small export first, but its usage limits make a full year of data and several rounds of follow-up questions hard to finish in one sitting. For most small firms, a monthly or quarterly review fits comfortably within the Pro plan. Teams that want several people analysing data may want Team seats instead. For a wider view of what AI tools cost a UK business, see our breakdown of AI costs for small businesses in 2026.

When is Claude the wrong tool for margin analysis?

Claude is the wrong tool when your underlying cost data is missing or unreliable, when you need audited figures for lenders or HMRC, or when the analysis needs to run automatically every day.

No assistant can rescue costs that were never recorded. If materials are bought in bulk and never allocated to jobs, Claude will give you confident numbers built on guesses. Fix the recording first, even if only for the next quarter, and analyse that.

It is also not a replacement for your accountant. Use Claude for the operating question (which work pays) and your accountant for the statutory one. And if you find yourself uploading the same export every week, the analysis has outgrown a chat window. At that point, a direct connection between your accounting software and a reporting sheet will save time and reduce errors.

What should you do after the first analysis?

Reprice or drop your weakest job types, set a minimum margin for new quotes, and repeat the analysis each quarter so cost rises are caught before they eat a full year of profit.

The first review is usually the most revealing. After that, the value comes from repetition. Save your prompt, keep your export format consistent, and run the same analysis every quarter. Over a year you build a clear record of which work earns its place, which customers are worth keeping, and where your quotes need to move as costs change.

Next stepGet Claude set up for your business figuresPrompts, data prep and margin reports built around your own jobs.
Common Questions

Profit Margin Analysis with Claude AI — FAQ

Can Claude do profit margin analysis on my own spreadsheet?

Yes. Anthropic's file creation announcement says Claude can take raw data you upload and return cleaned data, statistical analysis, charts and written explanations of the key findings. It can also build spreadsheets with working formulas across multiple sheets. Anthropic made the upgraded feature generally available for paid plans on 21 October 2025. In practice, you export your invoices and job costs from your accounting or job management software, upload the file, and ask Claude to work out the margin on each job and rank them. Check the formulas it writes against a few jobs you know well before you trust the full ranking.

What is the difference between gross margin and markup?

Markup is profit as a share of your cost. Gross margin is profit as a share of the selling price. They use the same pounds but a different base, so a job's margin figure is always lower than its markup figure. Mixing them up is a common pricing error in small firms, because an owner who thinks they are adding a healthy margin may really be adding a markup, and quietly earning less on every job than they planned. When you ask Claude for analysis, say which one you want, and ask it to show both columns so you can see the gap.

Is it safe to upload my business figures to Claude?

It depends on what is in the file. Anthropic's own file creation post warns that the feature gives Claude internet access to create and analyse files, which may put your data at risk, and advises you to monitor chats closely. The sensible approach is to strip personal data before uploading. Replace customer names with job references, remove addresses and phone numbers, and keep only the figures you need for the analysis: job type, revenue, materials, labour hours and dates. That gives Claude everything it needs for margin work without exposing customer details.

How much does Claude cost for this kind of analysis?

Claude's pricing page lists the Pro plan at $20 a month billed monthly, or $17 a month with annual billing. Prices on that page are shown in US dollars, so check the amount you are charged in pounds at checkout. The free plan does include file creation, but its usage limits are tighter, and a year of job data plus several rounds of follow-up questions can use them up quickly. For an owner running a margin review once a month or once a quarter, the Pro plan is usually enough. Heavier daily use across a team may suit Team seats instead.

Why does margin analysis matter more in 2026?

Because costs have moved faster than many prices. ONS figures show producer input prices rose 7.3% in the year to June 2026, while factory gate output prices rose 3.5% and services producer prices rose 4.3% in the year to the second quarter of 2026. If your material and supplier costs are rising and your quotes have not been reviewed, some job types may have slipped from profitable to break even without anyone noticing. A margin review by job type is the quickest way to find out which ones need repricing first.

Next stepGet this run for youWe run Claude AI, websites, booking and SEO for UK small businesses. From £495 a month.
Start a Project