If you run a small business, you probably know the ritual. On the 1st of every month, you open your expenses spreadsheet, spend an hour (or three) building pivot tables, copy the numbers into a Google Doc, and send a summary to yourself or your bookkeeper.
It works. It also steals time you should be spending on the business itself.
Here is a better approach that took me about ten minutes to set up and cost me $0 in consultant fees: let Claude Cowork build you a beautiful, interactive expenses dashboard from the same spreadsheet you already maintain. Drop the file in, paste a prompt, open the HTML it produces.
What you end up with
A single HTML file you can open in any browser that shows:
- KPI cards for total income, total spend, balance, credit card spend, and budget utilization
- A monthly spend bar chart and a stacked breakdown of your top categories
- Donut charts for categories and for one-time vs. ongoing expenses
- Top vendor rankings
- A scrollable transaction log, color-coded by status
- A filter bar at the top so you can slice everything by year, month, or expense type in a single click
No login. No SaaS subscription. No vendor lock-in. Just a file on your computer that you rebuild in seconds whenever you want an update.
Why this beats doing it by hand
You get your time back. What used to take an hour of pivot tables and formatting now takes seconds. Change the Month filter from “March” to “April” and the whole dashboard updates — KPIs, charts, transaction log, all of it.
You actually see the story. A well-designed dashboard surfaces patterns you miss in rows of numbers — the category quietly eating your budget, the vendor you forgot you were paying, the month your spend crept above income. A spreadsheet shows you data. A dashboard shows you decisions.
You stop paying for one-off help. A freelance BI consultant will charge you $500–$2,000 to build a single Looker Studio or Power BI dashboard, and then another $100–$300 every time you want a change. A Claude Pro plan with Cowork costs $20/month and builds the dashboard for you on demand — and rebuilds it next month when your data changes.
How to build it
This assumes you are on the Claude Pro plan with Cowork mode enabled. (If not, you can turn it on in your Claude desktop app.)
- Create a Cowork project and point it at a folder on your computer. That folder becomes the home for your dashboard.
- Drop your expenses spreadsheet into the folder. Claude expects these columns: Date, Description, Type, Freq, Vendor, Category, Amount, Status, Payment Method. If your sheet uses different names, tell Claude the mapping once — it will remember.
- Paste the prompt (download link at the bottom of this post). Claude reads your data, writes the HTML, saves it to the same folder. You open the file in your browser.
- Next month, update once. Drop the refreshed spreadsheet into the folder and say “rebuild the dashboard with the latest data.” That is the entire recurring workflow.
A note on trust
Claude is fast, but treat the first draft the way you would treat any consultant’s first draft. Skim the KPIs. Open the transaction log. Make sure the totals tie to your bank statement. If anything looks off, tell Claude what is wrong and it will fix the file in place — no back-and-forth emails, no hourly rate.
The real value
The dashboard I built for my own business tracks eight months of transactions, calculates net spend, and lets me filter by year, month, or expense type in one click. If I had paid a consultant to build the same thing, I would have spent $800–$1,500 and waited a week. With Cowork, I spent less than the price of a coffee and had it running before the coffee got cold.
For a small business owner, that math is hard to beat.
Download the prompt
Here is the exact prompt I used. Download it, paste it into Claude Cowork, and you will have the same dashboard I built — customized to your own expense data.
If you build one for your business, I would love to see it. Send a screenshot to info@rockstoneai.com and I will feature the best ones in a follow-up post.