Small Business Income & Expense Tracker (Excel)

Know if your business is making money.

Log what comes in and what goes out. The tracker adds up every category by month, works out your profit, and tells you how much to set aside for tax. No macros.

WHAT IT DOES

• Income log (1,000 rows) and expense log (1,500 rows)

• Your own income and expense categories, 20 ready to go

• Profit & Loss by month and category (SUMIFS)

• Net profit and profit margin

• Quarterly tax set-aside with the usual US estimated tax dates

• Dashboard: year-to-date tiles, chart, biggest expenses

• Check column for missing categories

• Payment methods drop-down

• Works for any year: change it on the Settings tab

WHO IT'S FOR

Freelancers, side hustles and small businesses. Not accounting software, and not tax advice.

GOOD TO KNOW

• Works in Microsoft Excel: Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac

• Normal .xlsx file: no macros to enable

• One-off payment, instant download

Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.