Money tips

One marketplace, many categories: categorising online orders

How to categorise Amazon and Flipkart purchases by what you bought, not the marketplace: label orders by purpose, split mixed bills and keep reports true.

Editorial illustration for One marketplace, many categories: categorising online orders

A marketplace is a shop, not a category. Categorise each online order by what it was for: groceries, a gadget, a gift, home supplies. Where one payment covers several things, split it or choose the biggest purpose, and use the order details to decide rather than the name on the bank statement.

Why does the statement name not help?

Your bank statement says the name of the marketplace and an amount, and nothing else. A payment of ₹3,150 could be a pair of shoes, a phone case and a month of pantry stock. If you label every such row "Shopping", your Shopping total balloons and hides your real habits: a quarter of it might be groceries, and some of it might be a gift.

The marketplace is also where cashback, refunds and returns create their own confusion, since money flows back months later. A system based on purpose handles all this more calmly than one based on the shop.

How do you find out what each order was?

  1. Open your order history in the marketplace app or the confirmation email for each payment.
  2. Match the amount and date with the bank or card entry.
  3. Note each item and its price.
  4. Assign a category to each item, or to the order if it is mostly one thing.

Do this in a batch once a week rather than item by item as they arrive. Ten minutes on Sunday keeps it manageable.

How do you split a mixed order?

Say a single ₹3,150 payment covers items from three purposes. Here is how a split could look, with made-up prices.

ItemPrice in ₹Category
Running shoes1,799Clothing and fitness
Cooking oil and pulses850Groceries
Phone case for a gift501Gifts
Order total3,150All three combined

Checking the arithmetic: 1,799 plus 850 plus 501 is 3,150, which matches the payment. When you enter the order in your tracker, record the three lines separately so the statement total and your records agree. If a delivery fee or discount is spread across items, add it to the largest item or keep it as its own small line.

What if splitting every order is too much work?

Use a simple threshold. Split only when the secondary part is large enough to matter, perhaps a fifth of the order or ₹500, whichever you find sensible. Below that, put the whole order under the biggest purpose. A small, consistent error is better than skipping the habit altogether.

Can a tracker help with orders?

Partly. SpendixAI imports a bank or card statement, and marketplace rows will show up with the shop name, which you then categorise. You can enter several expenses by hand at once, which suits splitting an order into its parts, and receipts can be kept with their transactions. It does not read your marketplace account, so the item-level detail has to come from you.

Once you set a rule, the tool can send payments to a default category, but because a marketplace sells everything, a single rule is only a guess. Treat it as a starting point, and review the rows.

A short habit to adopt

  • Review marketplace payments once a week with your order history open.
  • Pick a default category for the shop, such as Shopping, and change it per order.
  • Split only when a part is large enough to matter.
  • Keep invoices for anything you might return, claim under warranty or show your CA.
  • At month end, check the Shopping total against what you think you bought.

Festive sale periods deserve extra care. During a big sale you may place five or six orders in a week, some for yourself and some as gifts for others. Keep a note of who each gift was for, because three months later a payment of ₹1,299 under a marketplace name will tell you nothing. A few words in the transaction note are enough.

SPENDIXAI JOURNAL

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

Explore your reports