Shopping

Build next month's grocery list from last month's receipts

Turn last month's receipts or statement lines into a staples list with quantity and price, then subtract what is left in the pantry. Made-up twelve-item example.

Editorial illustration for Build next month's grocery list from last month's receipts

Take last month's grocery receipts, list the staples you actually bought with quantity and price, check what is still in the pantry and subtract it. What is left is next month's list, with a rupee estimate. A made-up twelve-item example below shows how the estimate can come out well below last month's spend simply because the shelves are not empty.

Where does the item list come from?

Supermarket and shop receipts list items, so they are the best source. Statement lines show only the total paid to a merchant, so they tell you how much but not what. If you shop by app, the order history in the app has the item list. Gather these and copy only the staples, meaning things you buy again every month: grains, dals, oil, sugar, tea, detergent.

What does the list look like?

Columns: item, quantity bought, amount paid, quantity left in the pantry, quantity to buy and the estimate. The estimate is amount paid divided by quantity bought, times the quantity to buy. These numbers are invented.

ItemBought last monthPaidLeft nowBuy this monthEstimate
Atta10 kg₹5002 kg8 kg₹400
Rice10 kg₹8005 kg5 kg₹400
Toor dal2 kg₹3000.5 kg1.5 kg₹225
Cooking oil4 L₹6401 L3 L₹480
Sugar3 kg₹1501 kg2 kg₹100
Tea0.5 kg₹2400.25 kg0.25 kg₹120
Onion6 kg₹2401 kg5 kg₹200
Potato6 kg₹1802 kg4 kg₹120
Detergent powder2 kg₹2400.5 kg1.5 kg₹180
Biscuits6 packs₹1201 pack5 packs₹100
Poha1 kg₹700.5 kg0.5 kg₹35
Salt2 kg₹501 kg1 kg₹25

Last month these twelve items cost ₹3,530 in all (500 plus 800 plus 300 plus 640 plus 150 plus 240 plus 240 plus 180 plus 240 plus 120 plus 70 plus 50). The estimate for this month is ₹2,385. The gap is ₹1,145, and it exists because there was stock left to use.

How do I do the pantry check without it taking an hour?

  • Do it just before shopping, with the list in your hand.
  • Estimate by eye for loose grains: a quarter, half or full container is good enough.
  • Count packs for packaged items.
  • Do not buy extra just because it is cheap this week unless you have the storage.

What does this method miss?

It assumes you will use about as much as last month. Visitors, festivals, a fast or a trip can change that, so add or remove a line when you know about it. It also leaves out perishables such as milk, vegetables and fruit, which you will keep buying through the month. Keep those in a separate weekly line.

How do I keep the receipts in one place?

Photograph each receipt on the day and keep the pictures in a folder for the month. In SpendixAI, receipts are kept with their transactions, so the item list sits next to the amount on your statement. That makes the next month's list a ten-minute job.

Once the list is made, sort it by where you buy each item: the kirana for loose grains and dals, the supermarket or an app for packaged goods, and the weekly market for vegetables. Splitting the list this way stops one shop from getting everything by default and makes the rupee estimate easier to check against the bills at the end of the month.

From list to shopping day

  1. Copy the staples from last month's receipts.
  2. Check the pantry and fill the Left now column.
  3. Subtract and write the quantity to buy.
  4. Multiply by last month's unit price for an estimate.
  5. Take the printed list when you shop, and tick items off.
SPENDIXAI JOURNAL

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

Explore your reports