Income and work

Reselling as a side hustle: a stock-bought vs stock-sold log

A two-sided log for reselling: record stock bought and stock sold, see unsold stock value at month end and profit per item. Includes sheet formulas.

Editorial illustration for Reselling as a side hustle: a stock-bought vs stock-sold log

To track a reselling side hustle, keep two lists: one for every purchase of stock and one for every sale. Profit on what you have sold is sale value minus the cost of those same units, and the cost of units not yet sold is your stock value at month end. This stops you treating money tied up in stock as if it were lost, or as if it were profit.

What goes in the Bought and Sold lists?

Make two tabs in Excel or Google Sheets. In Bought, use these columns: A Date, B Item, C Quantity, D Cost per unit, E Total cost. In Sold, use the same shape: A Date, B Item, C Quantity, D Price per unit, E Total sale. In both, E2 is =C2*D2.

Use a consistent item name. "Phone stand" and "phone-stand" will be treated as different items, and your totals will quietly go wrong. Pick one spelling and stick to it, or use a drop-down list. If you sell variants such as colours or sizes, add the variant to the item name so that each one has its own stock count.

What does a small example look like?

Say someone buys 10 phone stands at ₹120 each, so total cost is ₹1,200. By month end, 6 are sold at ₹250 each, so total sale is ₹1,500.

MeasureWorkingResult
Cost of units sold6 × ₹120₹720
Profit on sold units₹1,500 - ₹720₹780
Unsold units10 - 64
Stock value at cost4 × ₹120₹480

Cash is down by ₹1,200 and up by ₹1,500, so you have ₹300 more cash than you started with. Profit is ₹780. The difference of ₹480 is stock still on the shelf. All three numbers are true and each answers a different question.

How do I get unsold stock per item?

Add a third tab called Stock. Put each item name once in column A. Then:

  • B2, quantity bought: =SUMIFS(Bought!$C$2:$C$500,Bought!$B$2:$B$500,$A2)
  • C2, quantity sold: =SUMIFS(Sold!$C$2:$C$500,Sold!$B$2:$B$500,$A2)
  • D2, unsold quantity: =B2-C2
  • E2, average cost per unit: =SUMIFS(Bought!$E$2:$E$500,Bought!$B$2:$B$500,$A2)/B2
  • F2, stock value at cost: =D2*E2
  • G2, profit on sold units: =SUMIFS(Sold!$E$2:$E$500,Sold!$B$2:$B$500,$A2)-C2*E2

Drag the row down for each item. Add up column F for total stock value at month end and column G for total profit. Average cost smooths out price changes when you buy the same item at different prices.

What should I do with items that are not moving?

Sort the Stock tab by unsold quantity and look at the items that have sat for more than a couple of months. Money in slow stock is money you cannot use for fast sellers. You can mark them down, bundle them with a popular item, or stop restocking. Do not hide a stuck item by averaging it with a good one; keep a column for the last sold date. A festival season can change what moves, so before a long slow period, look at how much cash is sitting in stock you may not clear.

Where does an app fit in?

The Bought and Sold tabs track quantities, which an expense tracker does not do. What SpendixAI can do is take the payments you make to suppliers and the credits you receive from your statements, with rows reviewed before they are saved, and give you category totals for stock purchases and postage. You can compare those against your sheet at month end.

Month-end routine

  1. Enter all purchases and sales for the month.
  2. Check the Stock tab for negative unsold quantities. That means a sale was entered without a purchase.
  3. Do a quick physical count of your top five items and match it to the sheet.
  4. Note total stock value and total profit.
  5. Decide which items to restock and which to stop.
SPENDIXAI JOURNAL

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

Explore your reports