Do a small business's quarterly BAS books from bank, Stripe, PayPal and Wise statements with Claude Cowork
- Posted
- by Sridhar Katakam (@srikat)
- Last checked
- Method:
- How we verify
Evidence: Described by posterThe person describes what happened in words, without screenshots or video.
Outcome
Sridhar Katakam used Claude Cowork to go through the statements and transactions from several bank accounts, Stripe, PayPal and Wise and prepare business expense and income spreadsheets. Their accountant reviewed them and said they were good enough that Katakam no longer needed the accountant's services for BAS and could file it themselves, a saving of about $530 AUD per quarter. The accountant also suggested having Claude do the same for the whole year, and said the fee for filing the income tax return would come down.
Agent
Prompt Recreated prompt
The source didn't share its exact prompt, so we wrote this from what it describes.
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn my business statements into clean income and expense spreadsheets for my quarterly tax return. Fill in before running: - Statements or exports for each account (bank, payment apps): [ATTACH] - The quarter's start and end dates: [DATES] - My usual expense categories, if I have them: [DETAILS] You're not my accountant or financial adviser. Show your working, label estimates as estimates, and tell me which points a professional or the official source should confirm. Rules: - Put every transaction in one sheet with date, source, description, amount and category. - Separate business income, business expenses and personal or transfer items. - Flag anything you can't categorise instead of guessing. - Remove duplicates where the same payment appears in two accounts. - Add a summary tab with totals per category. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. Output: An income sheet, an expense sheet and a summary my accountant can review. You'll know it worked when: my accountant signs off on the figures with few or no changes.
Customize this prompt
Answer the questions below and we'll put your answers into the prompt for you. You can leave any of them empty.
Statements or exports for each account (bank, payment apps)
You'll attach this in the chat tool, not here. Add the file in the chat before you send the prompt.
Your prompt
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn my business statements into clean income and expense spreadsheets for my quarterly tax return. Fill in before running: - Statements or exports for each account (bank, payment apps): [ATTACH] - The quarter's start and end dates: [DATES] - My usual expense categories, if I have them: [DETAILS] You're not my accountant or financial adviser. Show your working, label estimates as estimates, and tell me which points a professional or the official source should confirm. Rules: - Put every transaction in one sheet with date, source, description, amount and category. - Separate business income, business expenses and personal or transfer items. - Flag anything you can't categorise instead of guessing. - Remove duplicates where the same payment appears in two accounts. - Add a summary tab with totals per category. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. Output: An income sheet, an expense sheet and a summary my accountant can review. You'll know it worked when: my accountant signs off on the figures with few or no changes.
Scroll to see the whole prompt. Your answers show in green.
2 blanks are still empty: The quarter's start and end dates; My usual expense categories, if I have them. They'll stay in brackets in your prompt, so the chat tool may ask you about them.
What you type stays in this browser tab. We don't send it or save it, and it's gone when you leave the page. If you use a "Try this in" button, your answers go to that tool as part of the prompt.
Try this in:
This prompt has blanks to fill in, like [ATTACH]. We'll copy it instead of filling it in, so you can edit it before you send.
The source used Claude Cowork, which can take actions in a browser or app. These are general chat tools, so results may differ, and a normal chat may only give you a plan.
Opens in a new tab. We don't see what you send.
These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.
Optional stronger version
Our rewrite with extra checks. The poster didn't test it.
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn my business statements into clean income and expense spreadsheets for my quarterly tax return. Fill in before running: - Statements or exports for each account (bank, payment apps): [ATTACH] - The quarter's start and end dates: [DATES] - My usual expense categories, if I have them: [DETAILS] You're not my accountant or financial adviser. Show your working, label estimates as estimates, and tell me which points a professional or the official source should confirm. Rules: - Put every transaction in one sheet with date, source, description, amount and category. - Separate business income, business expenses and personal or transfer items. - Flag anything you can't categorise instead of guessing. - Remove duplicates where the same payment appears in two accounts. - Add a summary tab with totals per category. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. - List any receipts I should keep for the larger expenses. Output: An income sheet, an expense sheet and a summary my accountant can review. You'll know it worked when: my accountant signs off on the figures with few or no changes. Before you finish: re-read my goal and constraints, check your answer against each one, and list anything you assumed or couldn't confirm.
Source
https://x.com/srikat/status/2086643189776253312
Related cases
- Prepare an Indian income tax return (ITR-3) with Claude CodeRecreated promptEvidence: Described by poster
Given tax documents and a year of bank statements, Claude Code reconciled the figures against the poster's AIS (annual information statement), caught 2 mistakes that could have triggered notices, and computed the tax; the poster then filed.
Poster says:2 mistakes caught
Claude Code · Ops · Source date:
- Sort a year of mixed Amazon business purchases into QuickBooks categories with Claude, including the fiddly split transactionsRecreated promptEvidence: Described by poster
badlibrarian runs a business and sometimes buys things on Amazon. At tax time they used to search for the big business items and categorise them in QuickBooks Online until they gave up, using a janky browser plugin and two monitors full of Excel windows. Now Claude does it and doesn't give up, despite QuickBooks being slow. It will even click 19 times to split a transaction because they'd put a router and shampoo in the same Amazon cart one night in February 2025.
Claude · Ops · Source date:
- Turn a year of bank statements into a business expense spreadsheet with Claude CoworkRecreated promptEvidence: Described by poster
Claude Cowork extracted and categorized business expenses from a year of statements across several accounts into a well-organized spreadsheet; after some back-and-forth the poster fixed a handful of items by hand.
Claude Cowork · Data · Source date: