Free Excel Business Expense Tracker Template (And How to Use It)

What the Expense Sheet Looks Like

Here's what your main Expenses data sheet should look like. Each row is one transaction. The table expands automatically as you add new rows at the bottom:

Set Up Your Category Dropdown

Consistent categories are what make a tracker actually useful. Without them, the same expense gets entered as "Marketing", "Mktg", and "marketing spend" — and your summary totals are wrong.

Here's how to add a dropdown to your Category column so entries are always consistent:

• Click the first data cell in your Category column
• Go to Data → Data Validation → Allow: List
• In the Source box, type your categories separated by commas
• Click OK, then copy the cell down the entire column
• Now every cell in that column shows a dropdown with your approved categories

Suggested categories for most small businesses: Rent & Utilities, Software & Tech, Supplies & Materials, Travel & Mileage, Meals & Entertainment, Marketing & Ads, Contractors & Payroll, Professional Services, Insurance, Education & Training, Bank Fees, Shipping.

Build the Summary Sheet Formulas

Add a second sheet called "Summary" and build out your key metrics using formulas that pull directly from your ExpenseData table. These update automatically every time you add a new row — no manual refreshing needed.

Total all expenses:

Total by category — repeat for each one:

Total for the current month:

Total for a specific month (e.g. April = month 4):

Largest single expense this month:

Customize It for Your Business

The columns and categories above work for most small businesses but your situation may be different. Here are the most common customizations worth making before you start entering data:

• Add a Tax Deductible column — a simple Yes/No dropdown. At tax time, filter by Yes and you have your deductible expenses ready instantly.
• Add a Client/Project column — if you track expenses by client or project, this lets you see profitability per client using SUMIF.
• Add a Reimbursable column — flag expenses that a client owes you back for and track which ones have been paid.
• Remove columns you won't use — if you'll never fill in Invoice # or Reference, delete those columns. Fewer columns means faster data entry and more consistent records.
• Rename categories to match your business — a restaurant might use Food & Beverage instead of Supplies. A law firm might use Court Fees instead of Professional Services.

The Weekly Habit That Makes It Actually Work

The best designed tracker in the world fails if it only gets updated once a quarter. The secret to a tracker that stays accurate is a simple weekly routine that takes less than 15 minutes.

• Pick one day and time each week — Friday afternoon or Monday morning work well. Block it in your calendar like any other appointment.
• Open your bank and credit card statements — go through each transaction from the past week and log it in the tracker.
• Check your totals against your statements — your tracker total for the month should match your statement to within a few dollars. If it doesn't, something was missed.
• Glance at your Summary sheet — are any categories running higher than expected? A quick look once a week means no surprises at month end.