SMALL BUSINESS · EXCEL GUIDE

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

Net Profit = Sales − Cost of Goods − Other Expenses
ExampleAmount
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

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 →