How to Track Small Business Income and Expenses in Excel

When business payments are scattered across bank statements, cash receipts and messages, even a simple question can take time to answer: how much came in this month, and where did it go?

An Excel tracker gives those records a consistent place. You enter each transaction, assign a category and review the totals. For a business with a manageable number of transactions, that can be a useful starting point before moving to dedicated accounting software.

This guide explains how to track small business income and expenses in Excel, what to record and how to check your monthly numbers. You can build your own workbook or start with the Fenulo Small Business Income & Expense Tracker.

Quick Start

To set up a basic tracking routine:

1. Choose the year and currency you will use.
2. Create separate income and expense records.
3. Use a short, consistent list of categories.
4. Record transactions from receipts, invoices and payment records.
5. Check the totals against bank, cash and payment-account records each month.

For the simple example in this guide, income means money received and expenses mean money paid. If you need to track unpaid invoices, bills, inventory or formal financial statements, those need additional records.

1. Decide What Your Workbook Will Track

Start with one business, one reporting year and one reporting currency. Write these choices in a Setup sheet so you do not mix transactions accidentally.

For a basic cash-based tracker, use the date money was received or paid. For example, an invoice issued in September and paid in October belongs in October’s receipts. Keep the invoice date and unpaid balance in a separate invoice register.

Keep business activity separate from personal spending. A separate business bank account makes this easier. If you use a shared account, identify which transactions belong to the business before adding them to your workbook.

Also distinguish trading activity from financing. Owner contributions and loan proceeds increase cash, but they are not sales. Owner withdrawals and loan principal repayments should not be treated as ordinary operating expenses. Track them separately so they do not distort your income and expense summary.

2. Create a Small Set of Categories

Categories help you see where income comes from and which costs take the most money. A small list that you use consistently is more useful than a long list with overlapping labels.

Income categories	Expense categories
Product sales	Rent
Service payments	Utilities
Consulting fees	Software subscriptions
Commission income	Advertising
Other business income	Office supplies

Adapt the list to your business. An online seller might add packaging and delivery costs. A consultant might need travel and professional subscriptions.

Use the same category name every time. Recording the same subscription under “Software,” “Apps” and “Online Tools” splits one type of expense across several totals. A dropdown list can help prevent this.

3. Record Your Income

An income sheet should show enough information to explain each entry later. Include the receipt date, customer or source, description, category, amount, payment method and reference.

Here is a fictional example using BDT:

Date	Customer/source	Description	Category	Amount (BDT)	Method	Reference
2026-10-02	Customer A	Website setup payment	Service payments	8,000	Bank	INV-001
2026-10-04	Customer B	Product order	Product sales	3,500	Cash	RCPT-002
2026-10-06	Partner C	Commission received	Commission income	2,000	Bank	COM-003

Record payments promptly. If a customer makes two partial payments, record each receipt once and use the same invoice reference to connect them.

Do not add the full invoice value to receipts and then add the payment again. That counts the same income twice. Use an invoice tracker for amounts billed and still outstanding; use your income sheet for the receipts covered by your chosen method.

4. Record Your Expenses

For each expense, record the payment date, supplier, description, category, amount, payment method and receipt reference.

Date	Supplier	Description	Category	Amount (BDT)	Method	Reference
2026-10-03	Software provider	Monthly subscription	Software subscriptions	1,200	Bank	EXP-001
2026-10-05	Office store	Paper and stationery	Office supplies	650	Cash	EXP-002
2026-10-07	Advertising platform	Campaign payment	Advertising	2,500	Bank	EXP-003

Keep the supporting receipt or invoice. A reference in Excel helps you locate the document, but it does not replace it. You could use a folder such as “2026-10 Receipts” and filenames that start with your expense reference.

Be consistent about payment fees. If a customer pays 5,000 and a payment provider deducts 100, one useful approach is to record the gross receipt of 5,000 and a separate fee expense of 100. Recording only 4,900 while also recording the fee would understate the result.

5. Build a Monthly Summary

Your summary should show monthly income, monthly expenses and the difference between them. These totals help you notice changes and investigate unusual spending.

In your own workbook, convert the entry ranges into Excel Tables and name them Income and Expenses. Suppose each table has columns named Date and Amount, and cell A2 on your summary sheet contains the first day of the month as a real Excel date.

Monthly income can be calculated with:

=SUMIFS(Income[Amount],Income[Date],">="&A2,Income[Date],"<"&EDATE(A2,1))

Monthly expenses can be calculated with:

=SUMIFS(Expenses[Amount],Expenses[Date],">="&A2,Expenses[Date],"<"&EDATE(A2,1))

If monthly income is in B2 and expenses are in C2, the difference is:

=B2-C2

These formulas are for the example table structure above. Column names must match, dates must be stored as dates and amounts must be numeric. Some regional Excel settings use semicolons instead of commas between formula arguments.

For example, receipts of 50,000 and recorded expenses of 32,000 produce a difference of 18,000. In a basic tracker, this is a useful cash-based indicator. It is not necessarily formal accounting profit: unpaid amounts, inventory, asset purchases and other adjustments can change that figure. If you sell goods, also account for the cost of goods sold before judging profitability.

For more details on adding amounts that meet multiple conditions, see Microsoft’s guide to the SUMIFS function in Excel.

6. Check Your Records at Month-End

A dashboard only summarizes what you entered. Before relying on it, compare your workbook with the underlying records.

For each bank or payment account, review opening balance, receipts, payments and closing balance. Look for missing entries, duplicates, bank fees, refunds and timing differences. Count cash separately if you handle cash payments.

Transfers between your own business accounts are another common source of errors. Moving 10,000 from the business bank account to business cash does not create sales or an operating expense. Keep a separate transfer record so both balances can be explained.

When reviewing the month, ask:

• Have all receipts and payments been recorded?
• Does each entry have the correct date and category?
• Are any personal expenses mixed into business costs?
• Have refunds, fees and transfers been handled consistently?
• Can I find the supporting documents?

Correct the entries first, then review the summary again.

7. Keep the Routine Manageable

Choose a regular time to update the workbook. Daily entries suit businesses with frequent payments; a weekly session may be enough for a business with fewer transactions.

Protect formula cells where practical, keep a backup and save a dated copy after the monthly review. Avoid typing over calculated totals to make them match an expected number. Find and fix the underlying transaction instead.

If several people need to edit records, transaction volume grows or you need permissions, audit history and connected invoicing, consider dedicated software. Excel is easier to maintain when the workbook and workflow remain simple.

Start with Fenulo’s Free Excel Template

If you prefer a prepared workbook, the Fenulo Small Business Income & Expense Tracker provides income and expense sheets, customizable categories, a 12-month summary and a dashboard, as described on its download page.

Download the file, review the sample entries and set up your categories before entering your own records. Keep an untouched copy of the original workbook as a backup.

For unpaid customer balances, use the separate Small Business Invoice Tracker. For a sales-focused view that includes costs and profit, explore the Sales & Profit Tracker.

Frequently Asked Questions

Put Your First Week of Transactions in Order

Start with a small task: collect this week’s payment records, enter the transactions and check them against your bank and cash records. Once that works, repeat the routine and review the monthly summary.

Download the free Fenulo Small Business Income & Expense Tracker.