Bank statements

Shared household sheet shows different months on two laptops: the fix

When one partner sees the right month and the other sees a swapped one in a shared household sheet, the cause is date settings. Here is how to make both match.

Editorial illustration for Shared household sheet shows different months on two laptops: the fix

Different months for the same transaction on two partners' computers mean the shared household sheet stores dates in a way that each computer reads differently. Convert the dates to one unambiguous format such as year-month-day text or a real date, and the disagreement disappears.

How can one sheet show two answers?

A spreadsheet stores a real date as a number, and it is displayed in the format of the computer opening it. That part is safe. The trouble is that imported dates are often text such as 06/07/2026. Each computer then guesses: one reads it as 6 July, the other as 7 June. If one of you imported and one of you edits, the sheet quietly contains both interpretations.

How do you find out which rows are affected?

  • Look for dates left-aligned in a column where most are right-aligned.
  • Sort by date and watch for rows that jump out of sequence.
  • Compare a month total on both laptops; if they differ, text dates are involved.
  • Check any row whose day is 12 or less, since those are the ones that can swap.

What is the cleanest repair?

  1. Agree on one person to fix the sheet. Two people editing at once will undo each other.
  2. In a helper column, build a real date from the text with =DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)).
  3. Make a second helper that prints it unambiguously: =TEXT(B2,"yyyy-mm-dd"). A date written this way reads the same on any computer.
  4. Use that text column for filters and month totals. Hide the original.
  5. Write a note at the top of the sheet saying the date column is year-month-day.

A worked example for a household

Say the sheet holds the rent of ₹24,000 on 05/07/2026, a school fee of ₹9,500 on 06/07/2026 and groceries of ₹3,800 on 21/07/2026. On one laptop all three sit in July: ₹24,000 plus ₹9,500 plus ₹3,800 is ₹37,300. On the other, the first two read as 7 May and 7 June, and only the grocery row stays in July, so July shows ₹3,800. Two people look at the same file and one says July cost ₹37,300 while the other says ₹3,800.

RowAmountLaptop oneLaptop two
Rent 05/07/2026₹24,000July7 May
School fee 06/07/2026₹9,500July7 June
Groceries 21/07/2026₹3,800Julytext, July
July total₹37,300₹37,300₹3,800

Can SpendixAI keep both of you consistent?

SpendixAI keeps one workspace that opens the same on any device, so dates do not get re-read by each computer's settings. Statements come in as PDF, CSV or Excel files, you pick the account first, and the review screen shows the parsed rows before they are saved. Pro covers one personal workspace; it is not a team tool, so decide which of you holds the login. Sign-in is through Google, with no passwords stored.

What if only one of you has the problem?

If one laptop shows correct months and the other does not, check the date setting on the one that is wrong rather than the file. On a Windows machine, the region setting controls the short date order. On a phone, the language and region setting does the same job. You can leave the setting alone if you convert the file as described, but it is worth knowing which device is the odd one out.

Send each other a single date, such as the rent day, and read it aloud. If you both say the same day and month, the file is consistent. It takes ten seconds and settles the argument.

A habit to stop it returning

  • One person imports; the other reviews.
  • Dates are always checked against the statement's first and last day.
  • The original download stays in a folder, never edited.
  • Totals are compared at month end before anyone makes a decision from them.
SPENDIXAI JOURNAL

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

Explore your reports