IOUEZ vs notes, chats and spreadsheets: why a signed record wins

Cameron tracked every loan in a beautiful spreadsheet: color-coded, with formulas for balances and a tab per person. Then Reese, who owed $1,800, said they’d already paid $600 that wasn’t in it. Cameron’s spreadsheet was perfectly accurate about what Cameron believed, and it couldn’t settle anything. That’s the heart of the IOU app vs spreadsheet question: not which tool is smarter, but whose agreement each one records. Here’s an honest comparison of notes, chats, spreadsheets and a signed record in IOUEZ.

Four ways people record a loan

Most people already use one of these. None of them is wrong; they just do different jobs.

A notes app (“Reese $1,800, Aug”). Fast, private, always on your phone. A chat thread (“ok so 300 a month starting sept?” “yes!! thank you”). The real conversation, with both voices in it. A spreadsheet, with dates, payments and running balances. Flexible and free. A signed record in an app like IOUEZ: an agreement both people sign, with payments both can see.

We marked the signed record column, but look at the spreadsheet’s analysis row honestly. For totals, budgets and “what if” math, nothing beats a spreadsheet. The trouble is only when it’s asked to be proof.

The IOU app vs spreadsheet question, side by side

The fairest comparison is between the two tools that actually track balances over time. Both can tell you that Reese owes $1,200. Only one of them can tell you that Reese agrees.

What happened with Cameron and Reese

Nobody lied. Cash at a party, two glasses of wine in, is exactly the kind of payment that slips between memories. The spreadsheet couldn’t help, because it only contained what Cameron typed. The chat couldn’t help either, because nobody had texted “got the $600, thanks!” that night.

They settled it the way most friends do: they split the difference and moved on, a little cooler toward each other. With a shared record, the cash would have been recorded by either of them that night, with a note, and the other would have seen it the next morning. If it hadn’t been recorded, the absence would have been obvious in April, when memories were fresh, not in June.

A spreadsheet records what you believe. A signed record shows what you both agreed.

What about chat history?

Chats deserve more credit than they get. A chat thread is the one informal record where both people speak in their own words, with timestamps. “Can I borrow $1,800 till I start the new job?” followed by “yes, 300 a month from Feb works” is a real agreement, and chat history is often the first thing people dig out when a loan goes sideways.

The problems are practical. The key message is buried between birthday plans and memes. Phones get replaced and backups fail. Terms get renegotiated across three different threads and a voice note. And the chat never totals anything: you can prove what was promised in January, but not what’s left in June.

Our advice: let the chat be where the deal happens, then copy the deal into a signed record the same day. Paste the key line into the agreement’s notes (“Agreed by text on Jan 12: $300 monthly from Feb 1”). The conversation stays human, and the record stays findable.

What any good loan record needs

Whichever side of the IOU app vs spreadsheet debate you land on, a record that holds up has the same five parts:

1. Both full names, and which one is the lender.
2. The exact amount and currency, and the date the money moved.
3. The repayment plan: amounts and dates, or a final due date.
4. Evidence that both people agreed: signatures, or at minimum a written “yes” from each.
5. A log of every payment, with dates and a reference you can match to a bank or app statement.

A spreadsheet can hold parts 1, 2, 3 and 5 perfectly well. It’s part 4 it can’t do on its own, and part 4 is the one that matters when memories differ.

Why “signed by both” matters

Three reasons, from the everyday to the formal.

It’s the same number for both of you. In IOUEZ, a shared agreement is one record two people look at. When either records a payment, the other sees it, and the balance is the same on both screens. That alone prevents most disagreements.

It can’t drift. Once both people sign a shared agreement, the amount, currency, interest and due date lock. Nobody can “remember” $1,500 when you both signed $1,800. Notes and spreadsheets can be edited at any time, and there’s usually no trace that anything changed.

It shows intent. In the US, the federal ESIGN Act says a signature or contract can’t be denied legal effect just because it’s electronic. And intent matters beyond court. The IRS says that to deduct a nonbusiness bad debt, you must show that at the time of the transaction you intended to make a loan and not a gift. A signed agreement with dates and amounts says that plainly; a row in your private spreadsheet says much less.

What IOUEZ doesn’t do (yet)

An honest comparison has to include the gaps. If one of these matters to you, a spreadsheet alongside IOUEZ covers it well.

• Signed group balances. IOUEZ groups split shared costs and suggest who pays whom, but nobody signs a group balance. If someone ends a trip owing a larger amount they’ll repay over months, move it into a signed agreement between the two of you, as we show in our playbook for trips, roommates and events.
• Currency conversion. Balances are kept per currency, never converted. That’s deliberate for loans, but a spreadsheet is better for “what’s my total in dollars today”.
• Custom analysis. Charts by category, interest projections, budgets: export a CSV (or, depending on your plan, an Excel workbook) from the web app’s Settings or the Android app, and analyze it in a spreadsheet.
• An iPhone app. There’s a web app and an Android app. On an iPhone, you use the web app in the browser.

The time cost is worth counting too. A spreadsheet costs nothing to start, then a few minutes every time a payment comes in, plus the occasional evening untangling a formula. A signed agreement costs two minutes to create and sign, and then each payment is a few taps by whoever sent it. Reminders run on their own, so the most time-consuming part of informal lending, chasing, mostly disappears.

Our view: the IOU app vs spreadsheet choice isn’t either-or. Use the signed record as the source of truth for each loan, and use a spreadsheet for everything you’d like to calculate about your loans.

Pick this if…

Use these questions to choose for a specific loan.

A quick test for your own records

Here’s a five-minute way to settle the IOU app vs spreadsheet question for yourself. Pick your largest open loan and ask the other person one question: “How much do you think is left?” Don’t share your number first.

If their answer matches yours to the dollar, your current system is working, whatever it is. Keep going. If it’s off by even one payment, you’ve found the disagreement while it’s small and friendly, and you’ve found the reason to move that loan into a record you both sign. Cameron tried this with two other friends after the Reese episode. One matched. The other was off by $150, a forgotten Venmo payment that Cameron had never logged, and it took thirty seconds to fix because both of them were looking for it together.

Moving from a spreadsheet to signed records

You don’t need to migrate everything. Start with open loans only; settled ones can stay in the spreadsheet as history.

For each open loan, have a two-minute conversation first: “I’m moving our loan into an app so we both see the same numbers. My sheet says $1,200 left; does that match yours?” If it doesn’t, sort it out now, before anyone signs. Then create the agreement in IOUEZ for the remaining balance, with a note such as “Balance carried over from original $1,800 loan of Jan 2026; $600 paid before this agreement.” Both sign, and from then on payments go in the app.

Cameron and Reese did exactly that for the remaining $600 in July. The last two payments went into IOUEZ, each recorded the day it was sent, and the agreement closed in September with both of them looking at the same zero. Cameron still has the spreadsheet; it now imports the CSV export once a quarter for the budget tab.

For a step-by-step on the first agreement, see how to create and sign your first agreement online; for the conversation before the money moves, our guide on how to lend money to a friend; and for copies you control, exporting your records.