How to Track Business Income and Expenses in Excel

Reliable totals start with consistent records. A straightforward transaction log can help a small business see what it earned, what it spent and how results changed month to month. It is a management aid and does not replace professional accounting advice or required records. This guide explains how to track business income and expenses in Excel without complicated bookkeeping software.

1. Set up one row per transaction

Use columns for Date, Description, Type, Category, Amount, Payment Method and Reference. Keep the amount numeric and use a separate Type field for Income or Expense. Record refunds and corrections consistently so they do not distort the month.

2. Choose categories you can maintain

Start with a short category list that reflects the way you review the business, such as Sales, Services, Rent, Software, Travel and Supplies. Avoid creating a new category for every vendor. Use dropdown validation to make entries consistent.

Sample log

Date	Description	Type	Category	Amount
3 Feb	Client project	Income	Services	18000
5 Feb	Internet bill	Expense	Utilities	1200

3. Calculate monthly totals

Create a monthly summary with income and expenses for each month. SUMIFS can total amounts by type and date range. Calculate net profit as income minus expenses. If you calculate a margin, handle months with zero income to avoid a divide-by-zero error.

4. Reconcile and review

Compare the log with bank or payment records regularly. Check missing dates, duplicate entries and unusually large amounts. Review category totals and month-to-month changes, then investigate the records behind any unexpected movement.

Practical habits that prevent errors

Use real dates, protect formula cells, keep a backup and note the source for unusual transactions. Do not overwrite prior months’ data without retaining a trace of corrections.

FAQs

How do I separate personal and business expenses?

Record business transactions in the business log and avoid mixing personal purchases into business totals. Ask an accountant about classification and tax treatment.

Is a spreadsheet enough for bookkeeping?

It may suit a simple tracking workflow, but compliance needs depend on the business and jurisdiction. Confirm recordkeeping requirements with a qualified professional.

How often should I enter transactions?

Frequent entry reduces forgotten details. A daily or weekly routine is often easier to maintain than reconstructing a month later.

Get the template

Prefer a prepared transaction log and monthly summary? Review the ReadySheets Income & Expense Tracker.

It works well alongside the Monthly Budget Planner.