Small Business Income and Expense Tracker | Excel Spreadsheet Template

Know if your business made money this month - without accounting software.

This small business income and expense tracker is an Excel spreadsheet template: log every sale and every cost in one list and get monthly profit, a running bank balance and category totals automatically.

WHAT'S INCLUDED

• Transactions log (500 rows): date, Income/Expense, category, description, payment method, amount, tax-deductible Y/N• Monthly Summary: income, expenses, net profit, profit margin, closing balance and deductible expenses for each month• Category Summary: totals and % share for up to 12 income and 12 expense categories• Dashboard: total income, total expenses, net profit, margin, bank balance, deductible expenses, best month, biggest expense category, monthly bar chart and expense pie chart• Settings: business name, tax year, opening balance and your own category names

BEST FOR

Freelancers, sole proprietors, side hustlers, Etsy and online sellers, and small service businesses that want a simple profit and loss view.

HOW IT WORKS

1. Enter your business name, tax year and opening balance in Settings2. Add one row per sale or cost (sample rows show the format)3. Check the Dashboard for profit, margin and where the money goes

IMPORTANT

A record-keeping tool, not accounting or tax advice. Ask a tax professional which expenses are deductible for you.

FORMAT / DELIVERY

• Microsoft Excel (.xlsx) - also opens in Google Sheets and LibreOffice• Sample data included so you can see how it works• Instant digital download - no physical item is shipped

FAQ

What exactly do I get?

Small business income and expense tracker for Excel: transaction log, monthly profit, bank balance, category totals and deductible expenses.

What do I need to use it?

Microsoft Excel on Windows or Mac (Excel 2016 or newer, or Microsoft 365). It also opens in free Google Sheets, though Excel is recommended.

How do I get it?

It is an instant digital download: right after payment you get the file on the page and by email. No physical item is shipped.

What if it is not right for me?

Contact me through my Payhip store within 30 days and I will refund you - no hard feelings.

I have a question

Use the contact link on my Payhip store page and I will help.