H|Blog|

How to Track Who Owes Who Without a Spreadsheet

How to Track Who Owes Who Without a Spreadsheet

July 21, 2026

Every friend group has the same problem. Someone calls a game, someone else disagrees, an IOU gets made, and then three weeks later nobody can agree on what actually happened.

"I said Eagles by 10." "No you didn't, you said Eagles win." "Check the texts." The texts are buried under 400 messages about someone's fantasy lineup. Nobody is scrolling back that far.

This is the problem with tracking predictions and IOUs in a friend group, and most groups solve it one of three ways. All of them are bad.

The Group Chat Method

This is where most people start. Someone makes a pick in the group chat. Maybe someone responds with a fire emoji. Maybe someone screenshots it. More likely, it scrolls past and nobody remembers it existed.

The group chat was not built to keep score. It was built for sending memes and arguing about whether the refs blew the call. When you try to use it as a ledger, you end up with:

  • No record of who said what. You said the over? When? Prove it.
  • No way to settle up. Even if you scroll back, good luck calculating who owes whom across a full season.
  • No accountability. The person who went 2-9 in October just stops bringing it up.

The Spreadsheet Method

Some groups level up to a shared Google Sheet. One person volunteers to maintain it, because every group has that one person who actually cares about organization.

This works for about two weeks. Then the maintainer gets tired of updating it. Or someone forgets to submit their pick before kickoff. Or someone disputes a result and the spreadsheet becomes a war zone of highlighted cells and angry comments.

The spreadsheet method fails because it depends on a human doing unpaid administrative work for the group. That person will eventually stop. The spreadsheet will go stale. The group will quietly go back to the group chat method.

The "We'll Remember" Method

This one is self-explanatory. Nobody writes anything down. Everyone trusts their memory. A month later, two friends are having a weirdly heated argument about a Thursday night game that nobody else watched.

Memory is not a record system. Memory is a story you tell yourself, and that story tends to skew in favor of the person telling it.

What a Good IOU Tracker Actually Needs

If you want to keep score without killing the fun, you need a few things:

A place where picks are timestamped and locked

No editing after kickoff. No "I was going to say that." You lock it in or you do not. The record exists and it is final.

Automatic results

Nobody should have to manually mark who won and who lost. That should just happen. If the game ended, the results should be there.

A running tally

Who is up? Who is down? Who has been on a heater? Who has been quietly terrible for six weeks? A good tracker shows you this without anyone having to do math.

Settlement tracking

When there is money involved, even small amounts, you need a way to see who owes whom. Not a Venmo request after every game. A net balance that settles at the end of a stretch. "You owe me $12, I owe you $8, send me $4 and we are even."

How to Start Tracking Without Making It Weird

The biggest barrier to tracking predictions and IOUs is not the logistics. It is the social friction. If you suddenly show up with a spreadsheet and announce that you are now the official scorekeeper, your friends are going to look at you like you just proposed a group budget.

The way to introduce tracking is to make it feel like part of the game, not a system layered on top of it.

Start with one game. Do not try to retroactively track everything from last season. Pick a game this week. Have everyone lock in a prediction. See who was right. That is it.

Keep the stakes small. Five bucks. A beer. Bragging rights. The amount does not matter. What matters is that the prediction is on the record and the result is clear.

Let the app do the work. The reason spreadsheets fail is because they require a human to maintain them. The reason group chats fail is because nobody scrolls back. A tracker that timestamps picks, scores results automatically, and shows the running balance removes the maintenance problem entirely.

Once your group sees the ledger after two or three weeks, the tracking stops feeling like overhead. It starts feeling like the scoreboard. And once the scoreboard exists, people start caring about their record, which makes every game more fun to watch.

Why Most Apps Miss the Point

Most sports prediction apps are built for strangers. Leaderboards full of people you do not know. Global competitions. Points systems that feel disconnected from your actual friend group.

That is not what makes predictions fun. What makes predictions fun is that you made a terrible call and your friend will never let you forget it. The context is the friend group. Without that, it is just a spreadsheet with a nicer UI.

HOMER was built specifically for friend groups who want to keep score of predictions and Actions without any of the overhead. You create a room, invite your friends, and lock in picks before games start. HOMER tracks results, keeps a running record, and handles the math on who owes whom.

No spreadsheets. No scrolling through old texts. No arguments about what you actually said.

The Part Nobody Talks About

The best thing about tracking predictions is not the money. It is the receipts.

When your friend goes on a five-game losing streak, you have proof. When you call an upset that nobody believed, it is in the record. When someone tries to claim they "knew it all along," the timestamps say otherwise.

That is what makes keeping score worth it. Not the tracking. The accountability.

Start a room with your friends.