Money basics

Reading a settle-up table: what the positives and negatives mean

A settle-up table lists each person with a number beside their name. Understanding what the numbers mean makes the table a tool rather than a mystery.

Editorial illustration for Reading a settle-up table: what the positives and negatives mean

One number per person

Each person’s balance is what they paid minus their fair share. A positive balance means they paid more than their share and are owed money. A negative balance means they paid less and owe money. A zero means they are square.

The table does not say who is generous or careless; it only reflects who happened to pay what.

The zero-sum check

In any complete table, the positives and negatives cancel. If the total of positive balances is 6,000, the total of negative balances is minus 6,000. If they do not match, an entry is missing, duplicated or recorded against the wrong person.

PersonBalance
Person A+4,200
Person B+1,800
Person C-2,500
Person D-3,500

Positives: 6,000. Negatives: 6,000. The table balances.

Turning balances into payments

Match debtors to creditors. Person D owes 3,500 and Person C owes 2,500. Person A is owed 4,200 and Person B 1,800. One way to settle: D pays A 3,500, C pays A 700 and B 1,800. Total paid: 6,000, in three transfers.

Many other combinations work. The aim is fewest payments, with each person making one or two.

Avoiding extra transfers

When payments follow the table, nobody pays more than they owe and nobody receives more than they are owed. Resist adding side deals, such as repaying an older private loan in the same transfer, because it muddles the record.

Keeping the table honest

Update the table whenever shared payments are recorded, not just at the end of the month. If you correct an entry, the table should change accordingly. A table that always reflects the record can be trusted at any moment.

  • Check the zero-sum rule
  • Note the date of the table
  • Archive the table after settlement

Watch for patterns

If the same person is always positive, they are fronting a lot of costs. Consider rotating who pays, or using a shared pot. If one person is always negative, check whether their share is larger than they realise, or whether they are neglecting to settle.

After settlement

Once payments are made, record them and reset the table to zero. The next period starts clean. Keep the old table in your files, since it is the evidence of what was agreed and paid.

Common errors in the table

The most frequent error is recording a payment against the wrong person, which makes one balance too high and another too low. Another is entering a shared bill twice. A third is forgetting to include a reimbursement already made. Checking the zero-sum rule and scanning for unusual amounts catches most of these quickly.

Showing the table to people

Present the table plainly, with names, balances and a line explaining the period it covers. Add a note on the rule used for shares. People accept a table more readily when they can see how it was produced. If someone questions an entry, check it together, correct it and publish the updated table.

Keeping a history

Save each month’s table in a folder. After a few months, the history shows who tends to pay for what and how balances move. It can also help when a new person joins and wants to understand how the group handles money. A tidy folder makes the next conversation shorter and calmer.

A short example with reasoning

Suppose Person C is negative by 2,500 but also paid a bill that has not yet been entered. Once the bill is recorded, C’s balance changes and so do the others. This is why a table should be read only after all payments are in. Reading it early can lead to payments that must later be reversed.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports