How to Track Business Expenses in Excel: A Simple Small Business Guide

Keeping track of business expenses helps you understand where your money goes, price your services more accurately, prepare records for tax time, and spot unnecessary costs. You do not need expensive accounting software to get started: a well-organized Excel or Google Sheets workbook can work for a very small business.

This guide explains how to build a simple expense tracker, which columns to include, useful formulas, and common mistakes to avoid. It is general record-keeping information, not tax or accounting advice.

What Is a Business Expense Tracker?

A business expense tracker is a spreadsheet where you record purchases and payments connected to running your business. Examples include inventory, packaging, software, internet, advertising, delivery, travel, and professional services. Keep personal spending separate from business spending.

1. Create These Columns in Excel

Open a blank workbook and add these headings in Row 1:

Date	Expense ID	Category	Description	Supplier	Payment Method	Subtotal	Tax	Total	Receipt Saved?
01-Oct-2026	EXP-001	Software	Monthly design tool	Vendor name	Card	20.00	0.00	20.00	Yes
03-Oct-2026	EXP-002	Packaging	Shipping boxes	Supplier name	Bank transfer	35.00	2.80	37.80	Yes

The figures above are examples only. Use your own currency and the tax fields that apply in your location. In India, keep GST details where relevant; in other countries, use the sales-tax or VAT records applicable to your business.

2. Add a Total Formula

If Subtotal is in column G, Tax is in column H, and Total is in column I, enter this formula in cell I2:

=G2+H2

Copy the formula down the column. Format the amount columns as currency and format the Date column as a date.

3. Calculate Total Expenses

If your expense totals are in cells I2 through I500, use:

=SUM(I2:I500)

This gives you the total recorded expenses in that range. Update the range if your spreadsheet has more rows.

4. Find Spending by Category

To calculate how much you spent on software, for example, use SUMIF. If Category is column C and Total is column I:

=SUMIF(C2:C500,"Software",I2:I500)

Replace “Software” with another category, such as Marketing, Inventory, Travel, or Delivery. You can also create a PivotTable to compare monthly spending by category.

5. Make the Tracker Easier to Use

• Turn the data into a table: Select the data and choose Insert → Table so filters and formulas are easier to manage.
• Use consistent categories: Avoid recording the same type of expense under several different names.
• Save receipts: Store digital receipts in a secure folder and use a consistent file name, such as 2026-10-03_packaging_EXP-002.pdf.
• Review weekly: Match entries against bank or payment statements and correct missing or duplicate entries.
• Back up the file: Keep a secure cloud or external backup and limit access to people who need it.
• Separate business and personal transactions: This makes records easier to review and reduces confusion.

6. Business Expenses Are Not the Same as Profit

An expense tracker records money spent. To estimate profit, you also need to track revenue and consider other items that apply to your business. A simple starting calculation is:

Estimated profit = Revenue - Expenses

This is a basic management estimate, not necessarily taxable profit. Tax treatment can depend on your location, business structure, and the type of expense. Ask a qualified accountant or tax professional for advice specific to your circumstances.

Common Mistakes to Avoid

• Entering expenses weeks or months after they happen.
• Forgetting small recurring subscriptions or payment-processing fees.
• Keeping no receipt or supporting record for a transaction.
• Mixing personal purchases with business expenses without clearly identifying them.
• Assuming every purchase is tax-deductible without checking local rules.
• Overwriting formulas or using inconsistent date and currency formats.

Excel or Google Sheets: Which Should You Use?

Excel is useful if you already use Microsoft Office and want desktop spreadsheet features. Google Sheets is convenient when you need browser access or collaboration. For a very small business, either can work; choose the one you will update consistently and protect it with appropriate account security.

Quick Checklist

• Record the date, category, description, supplier, and amount.
• Include tax separately when relevant.
• Save receipts and link them to the transaction where practical.
• Review the sheet at least once a week.
• Back up the file and keep business records private.

Frequently Asked Questions

Can I track business expenses in Excel for free?

Yes. If you already have access to Excel or use a free spreadsheet option such as Google Sheets, you can create a basic tracker yourself using the columns and formulas in this guide.

How often should I update my expense tracker?

Ideally, record each expense as it happens or set a regular weekly time to enter and reconcile transactions.

Should I use one sheet for every month?

You can use one continuous table with a Date column and filter it by month. This often makes yearly totals and category comparisons easier than maintaining twelve separate tables.

Can this spreadsheet replace accounting software?

It may be enough for simple internal tracking, but it may not handle invoicing, bank reconciliation, inventory, payroll, or tax reporting needs. Choose tools based on your business complexity and local requirements.

Disclosure: This article is for general educational purposes only. Confirm accounting and tax requirements with a qualified professional in your jurisdiction.