Spreadsheets

When a shared expense sheet causes conflicts between spouses

Why a shared Google Sheet causes conflicts between spouses, how protected ranges, version history and agreed categories help, and when to separate records.

Editorial illustration for When a shared expense sheet causes conflicts between spouses

A shared sheet causes arguments when formulas get overwritten, each person categorises differently, and nobody can tell who changed what. You can reduce all three with protected cells, version history and one agreed category list. If it still causes friction, giving each person their own record is simpler than policing one file.

What goes wrong in a shared sheet?

  • Overwritten formulas: someone types over a total, and every number after it is wrong without a visible error.
  • Different habits: one person logs a food delivery order as Food, the other as Entertainment, and category totals stop meaning anything.
  • Silent changes: an amount edited yesterday and no one remembers who did it or why.
  • Two versions: one of you downloads a copy, edits it, and now there are two files.
  • Timing: one person logs in the evening and the other in the morning, so the same payment is entered twice.

How do you protect the formulas?

Lock everything except the cells where people type.

  1. In Google Sheets: select the formula cells or the whole summary tab, then choose Data, Protect sheets and ranges. Set it so that only you can edit, or show a warning when others try.
  2. In Excel: select the input columns, open Format Cells, Protection, and untick Locked. Then choose Review, Protect Sheet. Everything still locked is now safe from accidental typing.
  3. Keep the summary on its own tab and have people add rows only on the Entries tab.

How do you see who changed what?

In Google Sheets, File, Version history, See version history shows saved versions with the name of the editor, and right-click on a cell and choose Show edit history to see changes to that cell. Excel files kept in a cloud folder have their own version history; its name and location depend on your version, so look in the File menu. These tools tell you what happened, but they do not stop it. Use them to settle questions like 'when did this number change?' calmly, not to assign blame.

Give each person their own Entries tab, named after them, and have the summary tab add them together. Then a mistake on one tab cannot wreck the other, and the edit history is easier to read because each tab has one author.

How do you agree on categories?

  • Create one Lists tab with the category names, and use data validation (Data, Data validation, dropdown from a range) so people can only choose from it.
  • Add a column called Paid by, with the two names as options.
  • Decide the borderline cases once: restaurant orders, fuel, gifts, medicines.
  • Use an 'Other' choice with a note when someone is unsure, and review those items together once a week.

When are separate logins simpler?

When the weekly review has become an argument, a different structure can help more than more rules. Each person can keep their own record and only the shared costs, such as rent and groceries, are put on a common sheet. An app can also take over the typing: SpendixAI uses Google sign-in only, has no passwords, and keeps each record in a workspace with role-based access. Be aware that Pro covers one personal workspace and is not a team or approvals tool, so check that it fits how you share money before moving a joint budget.

How often should you review together?

A weekly fifteen-minute check works better than a monthly argument. Open the sheet, look at last week's entries and the 'Other' items, and agree on categories right then. Keep it about the numbers, not about who spent what. If you find the review is skipped, shrink it: five minutes with the Other list is still worth doing.

A short agreement to write down

  • Who owns the formulas.
  • Which categories we use, and who decides new ones.
  • How often we review, and for how long.
  • What happens to a mistake: a correcting row, with a note.
SPENDIXAI JOURNAL

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

Explore your reports