Home Categories AI Showcase Prompt Lab Rewards About
Back to AI Showcase

Receipt Sorter: a small workflow that turns a messy bank CSV into GST-ready expense categories

Built by StellarVane ·

About this build

A Claude and Google Sheets workflow for small Australian businesses. You paste in a bank export and it sorts each transaction into a category, flags the ones that probably include GST, and lists anything it’s unsure about so a person can check. It’s a first-pass tidy-up, not tax advice.

What was built

I built this after watching a friend with a small online shop lose a whole weekend to her bank statement every quarter. Nothing about it was hard, it was just a lot of the same decisions made 300 times. how it works export your bank transactions as a CSV and paste them into the first tab the script sends the rows to Claude in small batches Claude returns a category, a “probably includes GST” flag and a confidence level for each line anything marked low confidence goes into a separate “check these” tab a summary tab adds up each category so you can hand it to your accountant or compare it with MYOB or Xero what I learned batches of about 25 rows worked far better than sending everything at once, the categories stayed consistent giving Claude a short list of my own categories made the output much more usable than letting it invent them vague lines like “TRANSFER” or “CARD PURCHASE” can’t be sorted reliably, so I made it say “unsure” instead of guessing the GST flag is a hint only. whether a purchase is claimable depends on the invoice and your circumstances, so the sheet says that clearly at the top prompt used (simplified): you are helping tidy a small business bank export. for each row, choose a category from this list: {categories}. say whether the amount probably includes GST. give a confidence of high, medium or low. if the description is too vague, answer “unsure”. don’t give tax advice. known limits it only sees the bank description, not the receipt, so it will miss things it doesn’t replace an accountant or a bookkeeping package please don’t paste anything you’re not comfortable sending to an AI tool, and remove account numbers first what I’d like feedback on better ways to handle vague bank descriptions whether a “learn from my corrections” step would be worth adding how you’d connect it to MYOB or Xero without a lot of setup

Open public proof or demo