Most small business owners start out tracking expenses in one place and income somewhere else — or not tracking income at all beyond checking the bank account. That works until it doesn't. When tax time arrives or a slow month hits, you realize you have no clear picture of what you actually made and spent, or whether your business is truly profitable.
A combined income and expense tracker in Excel solves this. One file, always up to date, showing you exactly where your money comes from, where it goes, and what's left. Here's how to build one from scratch in a way that's simple to maintain and genuinely useful.
Tracking them separately means you always have to mentally combine two spreadsheets to get the answer you actually need — your profit. When income and expenses live in the same file, your profit and loss picture is always one glance away. You can see at any moment whether you made money this month, which income sources are growing, and which expense categories are eating into your margins.
The cleanest way to build a combined tracker is with three separate sheets in one workbook — one for income, one for expenses, and one summary sheet that pulls everything together automatically.
Every payment received, one row per transaction
Every expense paid, one row per transaction
Totals, profit, and monthly breakdown — all automatic
Right-click any sheet tab and click Insert to add new sheets. Name them exactly — Income, Expenses, and Summary. This naming matters because your Summary formulas will reference these sheet names directly.
Your Income sheet should capture every payment your business receives. Here are the columns you need:
| Column | What to Enter |
|---|---|
| Date | Date the payment was received |
| Client / Source | Who paid you or where the income came from |
| Income Type | Category — Services, Products, Consulting, Retainer, etc. |
| Description | Brief note about what the payment was for |
| Amount | The amount received |
| Payment Method | Check, bank transfer, credit card, PayPal, cash, etc. |
| Invoice # | Optional — useful if you send invoices |
Your Expenses sheet follows the same logic. If you've already read our guide to tracking business expenses in Excel, this will look familiar — the key difference is that this version sits in the same workbook as your income so everything connects automatically.
| Column | What to Enter |
|---|---|
| Date | Date the expense was paid |
| Vendor | Who you paid |
| Category | Expense type — Rent, Software, Marketing, Contractors, etc. |
| Description | Brief note about what it was for |
| Amount | The amount paid — always enter as a positive number |
| Payment Method | Business card, personal card, cash, check, etc. |
| Tax Deductible | Yes or No — helpful for tax time |
This is where the power of having everything in one workbook really shows up. Your Summary sheet pulls totals from both the Income and Expenses sheets automatically using simple formulas.
Total income all time:
Total expenses all time:
Net profit (the number that matters most):
Income for a specific month:
Expenses for a specific month:
Income by type (e.g. Services only):
Expenses by category (e.g. Marketing only):
The most useful thing your Summary sheet can show is a simple month-by-month profit and loss table. Set up one row per month with three columns — Income, Expenses, and Net Profit — and fill them using the monthly SUMPRODUCT formulas above.
Change the month number in each formula (the =4 part) to match each row. January is 1, February is 2, and so on through December at 12.
Your Net Profit column is simply Income minus Expenses for that month. Add conditional formatting to highlight negative months in red automatically — so problem months jump out immediately without you having to scan every row.
The biggest risk with any tracker is falling behind on entries. A week of missed entries turns into a month, and suddenly you're doing the same manual reconciliation you were trying to avoid. Here's what works:
Set a weekly 15-minute block — same day, same time every week — to enter everything from the past seven days. Check your bank account and credit card statement against what you've entered so nothing slips through.
Keep it simple. The more complicated the tracker, the less likely you are to use it. If a column doesn't give you useful information, remove it. The best tracker is the one you actually open every week.
If setting this up feels like more than you want to tackle yourself, or if you already have a messy version of this that needs to be rebuilt properly, that's exactly the kind of thing we handle at HelpMyData. Send us your current setup and tell us what you need it to show, and we'll build it for you.
Tell us how your business works and what you need to track. We'll build a clean, easy-to-use Excel tracker tailored specifically to your needs — starting at just $75.
📧 Get Started Today