Who owes whom? Settling shared expenses without a spreadsheet

Over a month, sharing a life means paying for things in a scattered, uneven way. You grab the groceries; your partner covers the electric bill; you pay rent from your account; they catch dinner. By the end of the month nobody's quite sure who's ahead. The question is always the same: who owes whom, and how much?

The honest answer is a small calculation. The trap is thinking you need a spreadsheet to do it.

The spreadsheet trap

Plenty of couples start with a shared Google Sheet. It works — for about two months. Then someone forgets to log a receipt, a formula gets dragged into the wrong cell, and one of you becomes the unofficial household accountant. The sheet stops being a tool and starts being a chore that quietly falls on one person. The math was never the hard part; keeping the ledger honest and current is.

You don't need the spreadsheet. You need the idea behind it, which is simpler than the grid makes it look.

Netting, in one idea

Settling up is just comparing two numbers for each person:

• What you paid — the shared expenses that came out of your pocket.
• Your fair share — what you should have paid, based on how you split (50/50, or by income).

what you paid − your fair share = your balance

If you paid more than your share, you're owed money. If you paid less, you owe. And because every euro one person overpaid is a euro the other underpaid, the two balances are always mirror images. That's the whole trick — the rest is just adding up.

A worked example

Take Alex and Jordan. They split shared costs by income — 58.8% Alex, 41.2% Jordan. Here's a month of shared spending and who happened to pay each one:

Now apply the two numbers. Their fair shares of the €2,400 total are €1,411.76 (Alex) and €988.24 (Jordan). And they each actually paid:

• Alex paid rent + electricity + dinner = €1,820.00
• Jordan paid groceries + internet = €580.00

Alex overpaid by €408.24; Jordan underpaid by exactly the same. So the month collapses to a single sentence:

No line-by-line reimbursements, no "you get me back for the groceries and I'll get you for the rent." Everything nets down to one payment in one direction.

The messy bits

Reimbursements and personal spend

Only shared expenses belong in the settle. If one of you covered something personal for the other — a birthday gift they'll pay you back for — that's a straight reimbursement, not part of the shared split. Keep it out of the pot, or it muddies the fair-share math.

Partial payments

Sometimes a bill is split at the source — you each Venmo half the plumber directly. Just record what each of you actually paid; the netting handles the rest automatically. You never have to reason about halves in your head.

Carrying a balance

You don't have to settle to zero every month. Some couples let a small balance ride and square up quarterly, or roll it into next month. That's fine — as long as you both can see the running number, so it never becomes a surprise.

Let the ledger keep itself

The reason the spreadsheet fails isn't the formula — it's the upkeep. The fix is to log each shared expense once, the moment it happens, and let the numbers recompute themselves. When both partners can open the same screen and see the settle figure without anyone rebuilding the month from receipts, settling stops being an event and becomes a glance.

That's what Monio does. You add each shared expense once; Monio totals the month, splits it by your rule, and shows each partner's fair share side by side — plus the one difference to transfer. Each of you then marks your share paid, and the month closes.