Business

Expense tracker for a gift shop owner in India: what to record

An expense tracker for a gift shop owner in India: festival-season cost lines, customised orders, personal versus shop money and a monthly routine.

Editorial illustration for Expense tracker for a gift shop owner in India: what to record

A gift shop owner should track expenses with separate lines for festival stock, personalisation work and wrapping material, because the year bunches into a few peaks. Rakhi, Diwali, weddings and Valentine's week do most of the work, and the costs before each peak decide how the month ends.

What does a gift shop really spend on?

  • Ready gifts: soft toys, mugs, frames, showpieces, hampers and decor items from wholesalers
  • Personalisation: printing on mugs and cushions, photo frames, engraving and name plates
  • Wrapping: paper, ribbons, boxes, tags and carry bags
  • Rent, electricity and the display lighting that makes gifts look good
  • Seasonal helpers for the rush week
  • Window displays and festival decoration
  • Courier or local delivery for out-of-town orders

Which ten categories keep it simple?

CategoryWhat goes in it
Ready stockWholesaler bills
Personalisation suppliesBlank mugs, printing ink, frames, engraving work
Wrapping and packingPaper, boxes, ribbons, bags
Rent and powerRent, electricity
StaffSalary, seasonal helpers
Display and decorWindow set-up, lights, props
DeliveryCourier, local rider
MarketingFestival ads, social media boosts
Fees and interestCard charges, borrowing cost
Owner drawingsPersonal withdrawals

What is a shop expense and what is a gift to yourself?

A gift shop makes personal blur easy: items bought for your own family's birthdays, flowers and hampers for friends, wedding gifts for relatives. Each of these is personal. Write them as drawings with a one-line reason. Items given to a regular customer or to a vendor to keep goodwill are a business cost. Mark those as marketing or gifts given, and tell your CA about them.

Which small items do owners usually miss?

  • Ribbon and tape bought by the roll in the middle of a rush
  • Printing mistakes that waste a blank mug or a frame
  • Cash paid to a helper who stays late on Rakhi eve
  • Courier charges collected from the customer and the amount you actually paid
  • Advance taken for a customised order that is delivered next month

Wastage deserves a line of its own. If three printed mugs come out wrong and each blank cost ₹60, that is ₹180 gone. Seen once, it is nothing. Seen forty times in a season, it is real money.

How might a festival month look?

Say a Diwali month's sales are ₹3,60,000. Ready stock bought is ₹1,70,000, personalisation supplies ₹25,000, wrapping ₹18,000, rent and power ₹32,000, staff and helpers ₹44,000, display ₹12,000, delivery ₹9,000, marketing ₹15,000 and fees ₹8,000. Total outgoings are ₹3,33,000, leaving ₹27,000.

A quieter month, say sales of ₹1,20,000 with ₹55,000 of stock and ₹75,000 of other costs, leaves ₹1,20,000 less ₹1,30,000, a shortfall of ₹10,000. The festival month covers it, but only just, so it helps to save a portion of each festival's surplus.

What is the monthly routine?

  1. Enter bank and UPI lines from the statement.
  2. Add the cash notebook and wrapping or helper vouchers.
  3. List advances held and the orders they belong to.
  4. Count wastage and write the value beside it.
  5. Note unsold festival stock and decide what to discount.

SpendixAI can import a bank or card statement as PDF, CSV or Excel, let you review the rows before saving, and file each one in categories you have set up. Cash items can be typed in by hand, singly or several at once.

Pricing deserves a short check too. Take your five best sellers, add the cost of the gift, the wrapping and the card, then compare the total with the price on the tag. A gift that costs ₹320 to buy and ₹40 to wrap, and sells for ₹450, leaves ₹90 before rent, staff and power. That is thin for a product that needs space and time to display.

Next step

Before your next festival, write down every cost that appeared last time and what you paid. Set a spending limit for each category, and check it halfway through the season.

SPENDIXAI JOURNAL

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

Explore your reports