Money tips

Sale-day shopping list template: item, max price, stop time

A sale day shopping list template with columns for item, current price, maximum price and stop time, plus tips to avoid impulse buys during a big sale.

Editorial illustration for Sale-day shopping list template: item, max price, stop time

A sale-day shopping list is one page with a row for every item you planned to buy: the item, its current price, the most you will pay and a stop time. When the sale opens, you buy only what is on the list at or below your maximum, and you stop at the time you wrote. The page does the saying no for you.

What columns does the template need?

ItemCurrent priceMaximum priceStop timeBought?
Laptop bag₹1,299₹9999:00 pmNo
Earphones₹1,799₹1,2999:00 pmNo
Bedsheet set₹1,100₹8509:00 pmNo
Kitchen mixer₹3,200₹2,5009:00 pmNo

The prices are examples. The structure is what matters. Current price is what you saw a week before the sale, noted down. Maximum price is what you decided at home, calmly, not what the sale page shows. Stop time is when you close the apps.

How do you set a maximum price?

Decide it before the sale starts, and decide it from your own need, not from the discount percentage. Ask what you would pay for the item on an ordinary day if you really needed it. Write that number. If the sale price is above it, the item stays unbought, however large the discount banner looks.

What are the rules of the list?

  • Only items on the list may be bought. Anything else goes on a separate page called Later.
  • An item is bought only if the final price, including delivery and any fees, is at or below the maximum.
  • Stop at the stop time, even if some items are not found.
  • If you want something new, write it on the Later page and look again in two days.

How do you add a total and a cap?

Add a row at the bottom with your overall cap, such as ₹5,000. In a sheet, with maximum prices in column C rows 2 to 20, the sum of everything you could buy is =SUM($C$2:$C$20). To compare with a cap in cell F1, use =IF(SUM($C$2:$C$20)>$F$1, "Over cap", "Within cap"). With the four example items, the maximums add up to 999 plus 1,299 plus 850 plus 2,500, which is ₹5,648. Against a ₹5,000 cap, that is ₹648 over, so one item must wait or the cap must be revised. You can also add a column for the gap, =B2-C2, to see how far each price has to fall.

What should you do after the sale?

Fill the Bought column and note the final price paid. A few days later, check your bank or card statement to confirm what was charged. If you track spending in SpendixAI, importing the statement lets you see the sale purchases in one report, and you can add a receipt to each transaction for later returns. It helps to see the sale month as a whole instead of as separate orders.

A sale also tests the way you pay. Decide beforehand which payment method you will use, because pay-later and instalment options make a price look smaller than it is. Write the full price, not the monthly figure, in the Current price column. If you do use an instalment plan, note every due date straight away so the sale does not become a surprise later in the month.

What if the price drops after you buy?

Prices change, and it is normal to feel annoyed. Decide in advance that a price you paid at or below your maximum is a good decision, whatever happens next. Check the seller's return and price-adjustment terms before you pay, since they differ from seller to seller, and keep the invoice somewhere you can find it. Then close the page and move on.

A short checklist

  1. Write the list a week before the sale, with prices as they are today.
  2. Set a maximum for each item and an overall cap.
  3. Choose a stop time and put it in your phone alarm.
  4. Keep a Later page for anything new.
  5. After the sale, note the final prices and compare with the maximums.
SPENDIXAI JOURNAL

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

Explore your reports