Claude Sheets: See Who Hasn't Paid at a Glance
Today's Highlights: Claude Sheets Is Here, and One Sentence Builds a Tracker
On November 10, Anthropic launched Claude Sheets (beta). The idea is simple: describe the spreadsheet you want in one sentence in the chat, and Claude generates a sheet with tabs, formulas, formatting, and drop-down menus. You and your colleagues can then keep working on the same file.
For small businesses, the point isn't that there's yet another tool. It's that the kind of tracker you once had to ask your accountant or a contractor to design, an owner can now build in half an hour as a small project. Drawing on Anthropic's announcement and TechCrunch's coverage, here are the five key points:
Built from one sentence: Anthropic's own examples are a marketing campaign tracker and a hiring budget sheet. Claude sets up the structure first, then the team takes over and keeps updating the same file.
You can see what changed: When Claude edits cells directly, it lists every change it made so you can check them.
Shareable and exportable: You can share a sheet with colleagues and work on it together with Claude. When you need full Excel functionality, export it as .xlsx or CSV, or switch to Claude for Excel.
Plans and devices: It's available on all paid plans and works on web, desktop, and mobile. It's on by default for Team plans and off by default for Enterprise plans, where an admin has to turn it on in the organization settings.
Even Anthropic says it's still basic: The features are fairly simple for now, with more to come. On the same day, Anthropic also launched Whiteboards, upgraded the existing dashboards into Claude Data, and previewed an upcoming meetings feature.
Why do I suggest making an accounts receivable tracker your first sheet? QuickBooks' survey on late payments among US small businesses this year found that 59% of businesses have invoices more than 30 days overdue, up sharply from 47% the year before, and businesses that are owed money are owed about $17,700 on average. More importantly, 39% of respondents said a single late payment nearly left them unable to cover payroll or bills, and 74% of businesses have yet to fully automate their accounts management.
The survey covers US businesses, so the numbers don't map directly onto Taiwan, but the direction is clear: whether money comes in on time often matters more than how much you make on paper in deciding whether a small business owner can sleep at night. And accounts receivable, with its fixed fields, weekly updates, and need for reminders, is exactly the kind of problem Claude Sheets handles best.
Jesse's Take: Build One Sheet and Keep an Eye on the Money That Hasn't Come In
A common scenario: at an equipment repair company of a dozen or so people, delivery photos live in a LINE group (LINE is Taiwan's go-to messaging app), invoices are issued in the bookkeeping software, and "the client said they'll wire it by the end of the month" lives only in the owner's head. Every month-end, the simple question "how much money is still outstanding?" costs the accountant an entire afternoon of digging. Many industries in Taiwan run on monthly billing, and the longer the payment terms, the more common this gets. I have three suggestions:
1. Start the sheet with one sentence, but decide the columns yourself
Don't just say "make me an accounts receivable sheet." Spell out your rules. For example: "Build an accounts receivable tracker with columns for customer, invoice number, issue date, amount, payment terms (30 or 60 days after month-end), expected payment date, and actual payment date. Add a status drop-down with Not yet due, Overdue, and Paid. Calculate the expected payment date automatically with a formula, and add a separate tab that totals overdue amounts by customer." The more specific your rules, the more closely Claude's sheet will match how you actually work.
2. Once a week, feed in the scattered data
Paste in the CSV exported from your bookkeeping software along with the payment updates from LINE, ask Claude to update the sheet, and have it list which cells it changed. Let me be blunt: Claude will list the changes, but you have to actually read them. For numbers like amounts and dates, spot-check at least a few entries every time, and don't trust the whole thing just because the sheet looks nice.
3. Let the sheet drive the next action
Once the sheet is in order, ask Claude to draft two versions of payment reminders based on how many days each invoice is overdue, a polite one and a formal one, and have you or your sales rep review them before sending. A tracker's value isn't in how completely it records things; it's in making sure the call you need to make no longer gets put off.
Two final reminders. First, Anthropic's demo scenarios are hand-picked, and the beta features are still basic. If your formulas are complex or you need a live connection to your accounting system, I still recommend exporting to Excel or sticking with your existing bookkeeping software. Second, customer names and amounts are sensitive data, so before putting them in, check your company's plan and data settings.
A first step you can take today: Open Claude, paste in the prompt above, and start by entering 20 invoices from the last three months. Once you see that "overdue amounts by customer" tab, you'll know whether this half hour was worth it.
Further Reading
Related posts on JCXO
Original sources
Comments