Build Your Own Bill Splitting Spreadsheet Template

You came looking for a bill splitting spreadsheet template — a way to scan a receipt, add the tip, and figure out who owes what without doing mental math at the table. Here’s how to build one that fits your group instead of forcing your group into someone else’s grid.

Why build your own instead of downloading a template

There are plenty of options out there: a google sheets bill splitter template you copy to your Drive, an excel bill splitter template you tweak by hand, or a splitwise excel template someone shared in a forum. They work — until your situation doesn’t match theirs. Maybe you split rent unevenly, always cover one friend’s share, or want tax and tip divided proportionally rather than flat.

That’s the case for building your own in Auto. You describe what you want, snap a photo of a receipt, and Auto builds you a personal mini-app — a “Frame” — around it. It takes minutes, and it fits exactly how your people actually split.

Build it in Auto: the walkthrough

1. Open Auto and describe the app in plain language: a receipt scanner that reads the merchant, date, line items, tax, tip, and total from a photo.
2. Point your camera at a real receipt. Auto uses vision to pull out the structured data so you’re not typing prices by hand.
3. Ask for the splitting logic you want — even split, or assign items to specific people — and tell it to fold tax and tip in.
4. Adjust the layout, name, and details until it matches your taste. Because it’s yours, there’s no wrong version.

How someone built theirs

One Auto user built exactly this, and their prompts show how it came together step by step.

They started broad: a Frame called “Receipt Scanner” that extracts structured data from receipt photos — merchant, date, itemized lines, subtotal, tax, tip, and total — and stores each scan as history. The main screen showed a scrollable list of past receipts by date, with a detail screen for the full breakdown and a banner tallying the month’s spend.

Then came the part that mattered most: on each receipt’s detail page, they asked for an easy way to calculate tip and split the check — either evenly or by assigning items to individual people. A follow-up made sure the split accounted for tax and tip too, not just the raw item prices.

They also refined the naming as the app’s purpose sharpened, and — like anyone building — hit a build error along the way and simply asked Auto to fix it before moving on. This exact concept already exists as a real Frame people have built, called “Bill Splitter,” which is proof the pattern works.

FAQ

Do I need to know how to code? No. You describe what you want in everyday language and snap photos. Auto handles the building.

Can it handle tax and tip, not just the subtotal? Yes — you can ask for tax and tip to be split across everyone, either evenly or in proportion to what each person ordered.

How is this better than a spreadsheet template? A template is fixed; your Frame is yours. You can tweak the splitting rules, layout, and features anytime to match your group in 2026 and beyond.