How to Track Debts You Owe (and Are Owed) Without an Awkward Spreadsheet

Personal debts — money you owe a friend, money someone owes you, an informal loan without a bank involved — tend to end up tracked in one of two places: a mental note that gets fuzzier over time, or an awkward spreadsheet row that has to be manually updated every time a partial payment happens. Neither is reliable once more than one or two debts are involved.

Step 1: log the debt with its real direction and original amount

The first decision that matters is direction: are you owed this, or do you owe it. Getting this explicit and separate from the start avoids the confusion that builds up in a spreadsheet where "positive" and "negative" get inconsistently applied across rows added months apart. SooKOOBE's Debts module makes direction an explicit field on every debt — I Owe or Owed to Me — set once, clearly, at creation.

Step 2: log payments as they happen, not as a running mental tally

Rather than trying to remember the current remaining balance and updating a single number by hand, log each payment as a real, dated event. This matters for two reasons: it gives you an actual record if a dispute ever comes up about what's been paid, and it means the remaining balance can be computed rather than remembered — original amount minus every logged payment, accurate at any point in time without you having done the subtraction yourself.

Step 3: let status update itself from the remaining balance

A debt's status — open, partially paid, fully paid — should follow directly from the computed remaining balance, not be a separate field you also have to remember to update. This avoids the specific, common spreadsheet failure where the "status" column and the "amount remaining" column quietly disagree because one was updated and the other forgotten.

Step 4: set a due date if there is one, and let the reminder be automatic

If a debt has an actual deadline — a loan due back by a certain date — set it once and let the system handle the reminder rather than maintaining a separate calendar entry for it. This is a small thing that matters specifically for informal debts, which are exactly the kind most likely to be quietly forgotten because there's no bank statement generating a monthly reminder on its own.

Step 5: keep the debt visible until it's actually resolved

Don't remove a debt from view just because it feels awkward to keep looking at — an open debt, even a small or informal one, should stay visible until the balance actually reaches zero. This is less about the money and more about the relationship: a debt tracked accurately and settled cleanly tends to matter less socially than one that got vague and was resolved (or not) through fuzzy memory on both sides.

Step 6: review open debts periodically, not just when someone asks

Set a habit of glancing at your open debts occasionally — not because you've forgotten, but because a periodic honest look tends to prompt the small action (a partial payment, a check-in with the other person) that an occasional glance at a spreadsheet rarely does, because the spreadsheet requires you to remember to open it in the first place.

Why this is worth doing properly

Personal debts are exactly the category of financial tracking most likely to be handled informally, and exactly the category where informal handling causes the most quiet relational friction when memories don't match. A real, dated, computed record removes the ambiguity — not because anyone's being accused of anything, but because "here's the actual log" is a much easier conversation than "I think I remember paying you back most of it."