How to Track Business Expenses in Excel for a Small Business

If your business spends money on software, marketing, supplies, or shipping, tracking each expense is essential. A business expense tracker in Excel can help you spot spending patterns, prepare records for your accountant, and make better decisions about what your business can afford.

What should a business expense spreadsheet include?

Start with one row per transaction. Use these columns:

  • Date: when the expense occurred.
  • Vendor: who you paid.
  • Category: advertising, software, supplies, professional services, shipping, and more.
  • Description: what the purchase was for.
  • Amount: the amount spent.
  • Payment method: card, bank transfer, or another method.
  • Receipt reference: a filename or link to your saved evidence.

Keep your categories consistent. A campaign charge labeled “Marketing” in January and “Advertising” in February is harder to compare over time.

Which expense categories are useful?

Online sellers often track advertising, payment fees, product costs, shipping, packaging, marketplace fees, software, and contractor fees. Service providers might instead track tools, subscriptions, education, professional services, travel, and insurance.

Choose categories that describe your activities. Tax deductibility depends on your jurisdiction and circumstances; an Excel category does not establish that an expense qualifies for a tax deduction.

How to calculate monthly expenses in Excel

Make the amount column numeric, and ensure your dates are actual Excel dates. You can use a PivotTable to summarize spending by month and category. For simpler spreadsheets, the SUMIFS function can total entries between two dates and within a selected category.

For example, if your expenses are in column D, dates in A, and categories in C, a formula could look like:

=SUMIFS(D:D,A:A,">="&DATE(2026,11,1),A:A,"<"&DATE(2026,12,1),C:C,"Advertising")

Adjust the column references and dates to match your workbook. Depending on Excel's regional settings, formula separators may differ.

Separate order-level costs from overhead

Some expenses are directly related to an order, while others keep the business running. Product costs and a per-order payment fee are often best recorded against individual sales. Monthly software subscriptions and general marketing costs can be tracked separately. Whatever method you use, avoid double-counting when calculating profit.

Build a 15-minute weekly routine

  1. Download recent card, bank, and platform transaction records.
  2. Enter missing expenses, including small recurring charges.
  3. Attach or reference receipts securely.
  4. Check for duplicates, refunds, and chargebacks.
  5. Review total spending and large changes.

Three mistakes to avoid

1. Mixing personal and business purchases

Clearly identify personal purchases rather than classifying them as business expenses.

2. Forgetting subscriptions

Small recurring software charges can add up over a year.

3. Looking at expenses without sales

Spending is most useful when compared with revenue and estimated profit, not viewed in isolation.

Turn your expense log into a clearer profit picture

Our Business Profit Tracker Excel Dashboard brings sales, expenses, advertising costs, and estimated profit into one editable workbook. You enter your data manually and receive the Excel file plus a quick-start PDF as a digital download.

Next, read how to calculate profit after advertising costs to understand whether ad spending is leaving enough margin.

Back to blog