Shopping

Tag every purchase as online, in-store or cash: what the split shows

Tag each purchase as online, in-store or cash and use a monthly pivot to see the share of spending by channel. A made-up month shows how to read it.

Editorial illustration for Tag every purchase as online, in-store or cash: what the split shows

Add one column called Channel to your expense list, give it three values (Online, Store and Cash), and fill it as you go. At month end a pivot table adds up each channel and shows its share of the total. Small, frequent online orders are easy to overlook, and the split puts them next to the bigger shop purchases.

How do I decide the channel for each purchase?

Use where you were when you paid, not how the money moved. A UPI payment at the shop counter is Store, even though the bank statement says UPI. A card payment on a shopping app is Online. Paying the vegetable seller with notes is Cash. A bank statement alone cannot tell you the channel, so you add the tag yourself or from a note.

  • Online: any purchase made through an app or website, including delivery apps.
  • Store: you were physically at the shop or counter, whatever the payment method.
  • Cash: notes and coins handed over, including at a shop.
  • ATM withdrawals are not spending. Log the cash when you spend it, not when you take it out.

What does a made-up month show?

Say a month's spending is ₹46,000 and the tags add up as follows.

ChannelTotalShare of the month
Online₹18,40040 percent
Store₹21,60047 percent
Cash₹6,00013 percent
All channels₹46,000100 percent

The shares are rounded: 18,400 divided by 46,000 is exactly 40 percent, 21,600 divided by 46,000 is about 46.96 percent and 6,000 divided by 46,000 is about 13.04 percent. In this made-up month, a little under half the spending is in shops, and two-fifths goes through apps.

How do I build the monthly pivot?

  1. Make sure each row has date, amount, category and channel.
  2. Select the whole table and insert a pivot table.
  3. Put Channel in the rows and Amount in the values, summed.
  4. In Excel, set Show Values As to percentage of grand total. In Google Sheets, use Show as and choose the percentage of the grand total.
  5. Add Category as a second row field to see which categories live in each channel.

Without a pivot, one formula per channel works too: =SUMIFS($C$2:$C$500,$D$2:$D$500,"Online") with the amounts in column C and the channel tags in column D. Divide by =SUM($C$2:$C$500) for the share.

What can I learn from the split?

Do not read it as good or bad. Look for the categories that sit mostly in one channel, and for any channel that grew over the last three months. If Online rose from ₹14,000 to ₹18,400 while the grocery total stayed flat, the extra went somewhere else. The category view inside the Online channel will tell you where.

Three months of tags let you ask better questions. Does Cash fall as UPI at shops rises? Does Online grow in months with sales? Keep the monthly shares in a small table with one row per month and look for a direction rather than a single number. If a channel's share doubled, open the largest transactions inside it before changing any habit, since one big order can explain it.

Can a tracker help with the tagging?

Partly. In SpendixAI you can add cash expenses by hand, one or several at once, and pick the account for each, so a cash wallet account keeps those lines apart from your bank and card lines. Statement imports then bring in the card and bank side. The Online or Store split is still your own tag, which you can keep in a note or sub-category.

At the month end

Fill any missing tags before the pivot, check that the total matches your statement totals plus cash, and write one sentence about what you noticed. That sentence is what you will compare against next month.

SPENDIXAI JOURNAL

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

Explore your reports