A Reddit user has a straightforward problem: she is selling clothes with a friend, all customer payments go into her personal bank account, and she needs a clean way to separate her own money from the shared profit. She is looking to Excel for answers. Our take is simple: she is asking the wrong question. The spreadsheet can do what she describes, but that is not the real issue here.
The real issue is trust and transparency. When one person holds all the money in a joint venture, a static spreadsheet is not enough. She can absolutely create columns for personal funds and business profit, and Excel functions like SUM and basic arithmetic will give her running totals. But a manual spreadsheet is a record of what she *says* happened, not an independent audit of what *did* happen. Her friend has no way to verify that every deposit was logged correctly, that no personal spending was accidentally categorized as business expense, or that the split is accurate. The tool she is describing solves her math problem but does nothing for the relationship problem.
What she actually needs is a system that separates the money at the source. A dedicated business bank account or a payment platform like Venmo or PayPal with a business profile would automatically keep her personal and shared funds distinct. Then the spreadsheet becomes a simple tracker for splits, not a fragile ledger that mixes everything together. If she insists on using a spreadsheet, she should add a shared log that both partners can view or edit, so the numbers are not just in her hands. Even a simple shared Google Sheet with version history is more trustworthy than a local Excel file on her machine.
Our advice: stop trying to make a personal spreadsheet do the work of a shared financial system. Build the separation into how money flows in, not how you track it after. That is the smarter, more sustainable path, and it will save her from a much harder conversation down the road.