Claude for Small Business: Two Jobs You Can Stop Doing

Most of the small business owners I teach are not short of ideas about AI. They are short of a spare hour. You are the owner, the salesperson, the one who chases the unpaid invoice, and the one who finally sits down at nine at night to work out why last quarter felt busier than it paid. So when somebody asks me about Claude for small business, the real question underneath it is always the same: what does this take off my plate this week?

The honest answer is that the wins are not the flashy ones. Nobody in a ten-person company is transformed by a chatbot writing a blog post. What changes your week is the repeat work — the same quote, the same customer question answered slightly differently by three different people, the same month-end export you open, stare at, and close again.

Here are two of those, with the exact steps. Neither one needs a consultant, a second subscription, or anybody on your team learning to code.

Claude for Small Business Starts With a Project, Not a Prompt

The mistake I see most often is treating Claude like a search box — a fresh question every time, typed into a blank chat that knows nothing about your company. You get generic answers because you handed it generic input.

Do this instead. In the left sidebar click Projects, then New project, and name it something like Customer Answers. Open it and add files to Project knowledge: your current price list, your standard terms, the warranty or return policy, your service area, and one document holding the twenty questions customers actually ask. PDFs, Word files and spreadsheets all work.

Then set the project’s custom instructions. The wording matters here, so type something close to this:

• “You answer on behalf of our office. Use only the files in project knowledge for prices, policies, lead times and coverage. If the answer is not in those files, say ‘that is not in our documents’ instead of guessing. Plain English, five sentences or fewer, no greeting and no sign-off — I paste your text into my own email.”

Now paste in a customer email and type Draft a reply. What comes back quotes your prices, your policy and your lead times, in your words, in about ten seconds. The reason this beats doing it by hand is not speed — it is consistency. There is now one place where the current price lives, the answer you give on Thursday matches the one you gave in March, and you can hand the job to a part-timer without them inventing policy on the spot.

The gotcha: it answers from exactly what you uploaded. A price list from March will quote March prices, confidently. Put the date in the file name, and when prices change replace the file rather than adding a second copy — two price lists sitting in one project is where wrong quotes come from. And leave anything carrying card numbers or Social Security numbers out of there entirely.

Turn Your Sales Export Into Answers, Not a Pivot Table

Second job: the export. Your accounting system or point of sale will hand you a CSV of everything you sold this year. Most owners I meet either never open it, or rebuild the same pivot table from scratch every quarter.

Start a new chat, attach the CSV with the paperclip, and type a prompt built like this one:

• “Attached is my sales export for this year. The columns are Date, Customer, Item, Quantity and Amount. Before you calculate anything, list the distinct customer names and flag any that look like the same customer spelled different ways. Then give me three tables: revenue by month; my top ten customers by total spend; and every customer who bought in the first half of the year but has not bought since. Tell me any assumption you made and any row you had to skip.”

That third table — the customers who quietly stopped buying — is usually the most valuable page of paper a small business produces all year, and almost nobody ever produces it.

The clause doing the heavy lifting is “before you calculate anything.” That is what catches Acme Inc, Acme, Inc. and ACME being counted as three separate customers, which quietly wrecks every top-customer list anyone has ever built out of an export. Fix the names once, then ask for the tables again.

When the numbers look right, follow up with Put those three tables into one spreadsheet, a separate tab for each, and you get a file back you can save and reuse next quarter.

The gotcha here is refunds. If your system writes them as negative amounts, you are fine. If it flags them in a separate status column instead, say so in the prompt — otherwise your revenue is overstated and every number downstream of it is wrong.

Plenty more on the calendar

If you want to see both of these built live, I am running Claude for Small & Medium Businesses on Tuesday, September 29. We go through setting up a project with your own documents, writing instructions that stop the guessing, working with exports and spreadsheets, drafting the customer emails and quote templates you retype every week, and the places where I would not trust it yet.

The full current schedule is on the front page of PCWebinars.com, with new dates going up as they are confirmed. Register for this one if you run both the business and the admin, or browse the others and pick whichever fits the software you are actually stuck in.

About your trainer

I’m Tom Fragale. I’ve been a computer trainer and consultant for more than 30 years, and I’ve taught well over 30,000 people how to get more out of the software they already own — Excel, Access, Power BI, Word, Outlook, and now the AI tools that sit on top of all of it: Claude, ChatGPT, and Microsoft Copilot. My background is applied, not theoretical. Alongside teaching, I build real databases and reporting systems for clients in Excel, Access, and Power BI, so the examples I use in class are the problems I ran into last week, not textbook exercises. I also publish free tutorials on YouTube and longer courses online.

The full schedule, the recordings and the free material are all at PCWebinars.com.