Life events

The one-in-one-out rule: a purchase tracker for clothes and gadgets

Use the one-in-one-out rule to cut clothes and gadget shopping. Build a simple purchase tracker with the replaced item and monthly counts in a sheet.

Editorial illustration for The one-in-one-out rule: a purchase tracker for clothes and gadgets

The one-in-one-out rule says that every new clothing or gadget purchase must be matched by one item leaving your home. A tracker makes it work: log each purchase with the item it replaces, then count monthly how many came in, how many went out and how much you spent. Hard numbers keep the rule honest.

What are the rules?

  1. Same category: a shirt replaces a shirt, a charger replaces a charger.
  2. The old item must leave within a set time, say seven days after the new one arrives. Leaving means sold, donated, recycled or given to someone who will use it.
  3. Gifts count as purchases. You can say thanks and still apply the rule.
  4. Festival sale buys count too. They are the main reason the rule exists.
  5. Decide what is exempt in advance: innerwear, school uniforms, anything that has worn out or broken.

What does the tracker sheet look like?

Set up columns A to F starting at row 2, with headings in row 1.

ColumnHeadingExample
ADate bought12-Oct-2026
BNew itemRunning shoes
CCategoryClothes
DCost₹2,999
EItem replacedOld trainers
FStatusPending or Gone

Put the first day of the month you want to review in H1, for example 1-Oct-2026. Then these formulas work in Excel and Google Sheets.

  • Items bought that month: =COUNTIFS($A$2:$A$300,">="&$H$1,$A$2:$A$300,"<"&EDATE($H$1,1))
  • Money spent that month: =SUMIFS($D$2:$D$300,$A$2:$A$300,">="&$H$1,$A$2:$A$300,"<"&EDATE($H$1,1))
  • Replacements still pending: =COUNTIF($F$2:$F$300,"Pending")
  • Pending clothes only: =COUNTIFS($F$2:$F$300,"Pending",$C$2:$C$300,"Clothes")

The date test takes everything on or after the first of the month and before the first of the next month. EDATE moves a date forward by whole months.

What should I watch in the monthly count?

Say October shows five items bought for ₹11,400, but only three marked Gone. Two are pending, so the rule is being bent. Not a disaster; it is a prompt. Either the old things are still in the wardrobe, or the purchase was an addition, not a replacement. Both are worth knowing.

How do I stop the rule becoming a loophole?

  • The old item must truly leave. Moving it to a box under the bed does not count.
  • A set counts item by item. Three shirts bought together are three entries and need three replacements.
  • A buy-one-get-one offer is two items in, and two must go out.
  • Hand-me-downs from relatives count as items in, so the wardrobe does not creep up quietly.

Start with a quick count of what you own in each category, so the rule begins from a known number. Re-count after three months and see whether it has gone down, held steady or grown.

What about gadgets?

Gadgets add a wrinkle: an old phone or laptop may have resale value, and may hold personal data. Reset it before it leaves the house. An exchange offer from a shop counts as leaving, but note the exchange value so the real net cost of the new gadget is visible. Cables, chargers and cases pile up quietly, so give them a category of their own.

When does a sheet stop being enough?

If you also want the money side across every shop and card, SpendixAI can import your statements and sort the spending into clothes and gadgets with your own sub-categories, and its reports show the totals by month. The replaced-item column still belongs in your sheet; that detail comes from you.

Ready to start

  • Set up the sheet and the exempt list today.
  • Add everything you bought in the last month so the first count is real.
  • Do a pending review every Sunday for four weeks, then reassess.
SPENDIXAI JOURNAL

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

Explore your reports