How to track daily sales, expenses and profit in Excel
Whether you run a shop, sell online or work as a freelancer, knowing how much you sold is only half the story. Tracking costs and expenses helps you understand what you actually earned.
1. Record each sale
Create columns for date, item or service, quantity, unit price and sales amount. Calculate each sale with Quantity × Unit Price. For example, selling two items at ₹500 each gives ₹1,000 in sales.
2. Record the cost of goods
Cost of goods is what you spent to provide the products sold. If those two items cost ₹600 in total, your gross profit is ₹400 before other expenses.
3. Track other business expenses
Record expenses such as packaging, delivery, rent, utilities and advertising separately. Avoid mixing personal expenses with business spending.
4. Calculate your net profit
| Example | Amount |
|---|---|
| Sales | ₹1,000 |
| Cost of goods | ₹600 |
| Other expenses | ₹100 |
| Net profit | ₹300 |
Profit margin = Net Profit ÷ Sales × 100 = 30%.
5. Review your numbers every month
Group transactions by month and compare sales, expenses and profit. A monthly dashboard can help you spot whether rising sales are also improving profit.
Common mistakes to avoid
- Counting revenue as profit without deducting costs
- Forgetting small cash or delivery expenses
- Recording sales in different date formats
- Mixing personal spending with business transactions
- Failing to review totals at the end of each month
Prefer a ready-to-use Excel template?
The COSTIN Small Business Sales & Profit Tracker includes editable Sales and Expenses worksheets and a monthly dashboard.
US$5.99 · One-time digital download
Explore the Excel tracker →