To track sales for a small business, log every order the day it comes in (date, order number, customer, product, quantity, amount, paid and sent), total the month, and work out three numbers: revenue, profit per product and average order value. Then spend 30 minutes each month on what sold, which channel brought the orders and what to change. It works the same whether you sell on Instagram, WhatsApp, a marketplace or at weekend markets.
1. The daily order log
| Column | Why |
|---|---|
| Date & order # | Find any order quickly when a customer messages |
| Customer | Spot repeat buyers |
| Product & quantity | Know what actually sells |
| Amount ₹ | Revenue for the day and month |
| Paid ✓ | Catch unpaid COD or pending UPI transfers |
| Sent ✓ | Make sure nothing is left unshipped |
2. Three numbers that matter
- Revenue = total of all paid orders in the month.
- Average order value (AOV) = revenue ÷ number of orders. Bundles and "add-on" suggestions raise it.
- Profit per product = (selling price − cost to make or buy, including packaging) × units sold.
Worked example: a handmade candle seller
| Product | Price ₹ | Cost ₹ | Units | Revenue ₹ | Profit ₹ |
|---|---|---|---|---|---|
| Jar candle | 450 | 180 | 40 | 18,000 | 10,800 |
| Gift set of 3 | 1,200 | 520 | 12 | 14,400 | 8,160 |
| Tea lights (pack of 12) | 250 | 150 | 30 | 7,500 | 3,000 |
| Total | 82 | 39,900 | 21,960 |
With 60 orders that month, the average order value is ₹39,900 ÷ 60 = ₹665. The gift set earns the most profit per order (₹680), so it deserves more promotion than the tea lights, even though they sell more units. Figures are illustrative; delivery charges, platform fees and ads also need to come out of profit.
3. The monthly review (30 minutes)
- Total orders, revenue, refunds and average order value; compare with your goal.
- List your top 5 products by profit, not only by units.
- Note which channel brought the orders (Instagram, WhatsApp, marketplace, referrals, markets).
- Write one thing that worked and one thing to change next month.
- Set next month's revenue and order goals, and plan one promotion or launch.
4. Keep a customer list and a returns log
A simple customer list (name, contact, city, number of orders) lets you thank repeat buyers and tell them about new launches. A returns and refunds log shows patterns: if one product keeps coming back, fix the product or the description.
Tax and GST basics
Keep your monthly totals, because you'll need them for your income tax return. Businesses selling goods generally need GST registration once turnover crosses ₹40 lakh a year (₹20 lakh or less in some states), and online sellers on marketplaces may need it earlier. Confirm your case with a chartered accountant. See our GST invoice guide and how to track freelance income.
Printable tracker
The Sales Tracker has this whole system on 15 A4 pages: an annual sales overview, sales goals, 6 daily sales logs with paid and sent columns, 2 monthly summaries with top products and channels, a product performance table (price, cost, units, revenue and profit), a customer list and a returns log. ₹349. Posting on social media too? See the business & social media planners.
Frequently asked questions
How do I track sales for a small business?
Log every order with its date, order number, customer, product, quantity, amount and paid and sent status, total the month, and review revenue, profit per product and average order value each month.
How do I calculate profit per product?
Subtract the cost to make or buy the product, including packaging, from the selling price, then multiply by the units sold. Delivery charges, platform fees and ads also reduce profit.
What is average order value?
Total revenue divided by the number of orders. For example, ₹39,900 from 60 orders is an average order value of ₹665.
What should I review every month?
Total orders and revenue against your goal, top products by profit, which sales channels brought orders, one thing that worked, one thing to change and next month's goals.
When does a small business need GST registration in India?
Businesses selling goods generally need it once turnover crosses ₹40 lakh a year (lower in some states), and some online sellers need it earlier. Confirm with a chartered accountant.
General information, not tax advice. GST thresholds and rules vary by state and business type; confirm with a qualified chartered accountant.