A hardware shop owner should track expenses with ten categories, and keep credit given to contractors in a separate list. A hardware shop often sells on credit, so the cash in the bank can look healthy while a lot of money is still sitting with customers.
What are the real costs of a hardware shop?
- Cement, pipes, paint, tools, electrical and fittings bought from wholesalers or dealers
- Loading, unloading and tempo or truck charges on heavy goods
- Godown rent, shop rent and electricity
- Labour for hamals and counter staff
- Weighing scales, cutting machines and their servicing
- Fuel for the delivery vehicle
- Interest on money borrowed to hold stock through the season
Which categories make sense?
| Category | What goes in it |
|---|---|
| Stock purchase | Dealer and wholesaler bills |
| Freight and loading | Truck, tempo, hamali |
| Rent and power | Shop, godown, electricity |
| Staff and labour | Salary, hamals, daily wages |
| Delivery vehicle | Fuel, repairs, driver |
| Equipment | Cutters, scales, shelving |
| Breakage and loss | Damaged, cut, wasted stock |
| Fees and interest | Bank fees, loan interest |
| Marketing | Boards, calendars, contractor gifts |
| Owner drawings | Personal withdrawals |
How do I deal with credit sales?
Contractors and regular customers often buy now and pay later. Each credit sale is income earned but not yet received. Keep a simple khata page for every customer: date, bill, amount, payment received, balance.
Say a contractor takes goods worth ₹26,000, pays ₹10,000 in cash and ₹6,000 by UPI, and the rest stays pending. The balance is ₹10,000. If you only record the ₹16,000 you received, the shop looks as if it sold less than it did, and the dues are forgotten. Review the balances list on the first of every month.
What counts as personal?
Pipes, paint and electrical items taken for your own house, a helper sent to your home, or fuel for the family scooter are personal. Note each as a drawing with the item and its cost. A renovation at home is a good example of a large item that tends to vanish into stock.
What is often missed?
- Hamali paid in cash on the day a truck unloads
- Cut-to-length items where wastage is not recorded
- Small free gifts and samples to a regular contractor
- Advance paid to a dealer for a bulk order
- Breakage during storage in the rainy season
How might a month look?
Say takings are ₹6,80,000, of which ₹1,10,000 is still pending from customers. Cash received is therefore ₹5,70,000. Stock purchase is ₹4,50,000, freight and loading ₹18,000, rent and power ₹40,000, staff ₹52,000, vehicle ₹14,000, breakage ₹6,000 and fees and interest ₹16,000. Outgoings total ₹5,96,000. The bank view is a shortfall of ₹26,000. The sales view, counting the ₹1,10,000 pending, is a surplus of ₹84,000. Both are true, and that gap is the credit you are carrying.
What should the monthly routine be?
- Enter every bank and UPI line from the statement.
- Add the cash notebook, including hamali and tempo payments.
- Update each customer's khata and list the balances.
- Match dealer bills to payments.
- Note stock on hand for the main fast-moving items.
SpendixAI can import the shop's bank statement as PDF, CSV or Excel, let you review each row before saving, and keep each transaction with its account. Keep customer credit balances in your own khata, as described above.
Weight and quantity checks help too. If a dealer's bill says 50 bags of cement and the truck delivers 48, write the shortfall on the delivery slip and ask for a credit note at once. For cut pipes and rods, log what was sold by length and what was left as offcuts, so wastage shows as a number and not a feeling.
Next step
Open last month's khata, add up every balance still pending, and write the total at the top of this month's page. Compare it next month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
