Excel template · Instant download

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.

Get the tracker $12.99

✓ One-off payment   ✓ Instant download   ✓ Excel for Windows & Mac

Lee from Sheet Leveller
Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.
Small-Business-Income-and-Expense-Tracker.xlsx
Profit$21,519Margin75%Set aside$5,380
JanFebMarYear
Design projects$6,308$6,137$5,929$18,374
Retainers$2,300$2,300$2,300$6,900
Total income$9,816$9,590$9,261$28,668
Total expenses$2,430$2,722$1,997$7,149
Net profit$7,387$6,868$7,264$21,519
DashboardIncomeExpensesProfit & LossTaxSettings
Sound familiar?

Bookkeeping always gets left until tax time

🧾

Receipts in a shoebox

Months of income and expenses to sort out in April, all at once.

❓

“Am I actually making money?”

Money comes in and goes out, but you never see the real profit.

😬

The tax bill surprise

No money put aside, and a big bill due on 15 April.

How it works

Log it as it happens. The tracker adds it all up.

  1. Set up your categories

    Your income types and expense categories. 20 are ready to go, close to a US Schedule C.

  2. Log income and expenses

    Date, who, what for, category and amount. It takes a few seconds a day.

  3. See your profit

    Profit & Loss by month, a tax set-aside for each quarter, and a dashboard.

Income and expenses

Two simple lists. Everything else adds itself up.

Log every payment in and every cost out, with a category from a drop-down. SUMIFS puts each one in the right month and category, and a Check column flags anything missing a category.

  • 1,000 income and 1,500 expense rows
  • Category and payment method drop-downs
  • Filter and sort any way you like
Expenses
DatePaid toCategoryAmount
Fri 1 JanShared studioRent$450.00
Sat 2 JanAdobeSoftware & subscriptions$59.99
Tue 5 JanVerizonPhone & internet$95.00
Sat 9 JanMetaAdvertising & marketing$124.20
Fri 15 JanJamie RiveraContractors$689.00
Dashboard

Your year at a glance

Income, expenses, profit and margin so far this year, month by month with a chart, plus your biggest expenses and where your income comes from.

  • Year-to-date tiles
  • Biggest expenses, sorted
  • Income and expenses chart
Dashboard
INCOME$28.7k
EXPENSES$7.1k
PROFIT$21.5k
TAX$5.4k
Biggest expensesThis yearShare
Contractors$1,88026%
Rent$1,35019%
Equipment$1,29918%
Insurance$5408%
Software & subscriptions$4837%
Tax set-aside

No more tax-bill surprises

Pick a % of profit to put aside, and the Tax tab works out how much for each quarter, with the usual US estimated tax dates. Log what you’ve paid and it turns green.

  • Set-aside for each quarter
  • Due dates with Due soon and Overdue
  • Paid amounts tracked
Tax
PeriodProfitSet asideDueStatus
Q1 Jan–Mar$21,519$5,38015 Apr 2027Due soon
Q2 Apr–May––15 Jun 2027Upcoming
Q3 Jun–Aug––15 Sep 2027Upcoming
Q4 Sep–Dec––15 Jan 2028Upcoming
Who it’s for

For small businesses and the self-employed

Freelancers

Designers, writers, developers and consultants who invoice clients.

Side hustles

Etsy shops, reselling, tutoring or anything that earns on the side.

Small businesses

Shops, trades and services that want simple books without software fees.

Everything you get

  • Income log with 1,000 rows and expense log with 1,500 rows
  • Your own income and expense categories
  • Profit & Loss by month and category
  • Net profit and profit margin
  • Quarterly tax set-aside with due 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
Small Business Income & Expense Tracker
$12.99

One-off payment. Yours to keep.

Get instant access $12.99

Secure checkout by Payhip · Card or PayPal
Download link emailed straight away

Lee from Sheet Leveller

Hi, I’m Lee

I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.

This tracker is built on the SUMIFS and date formulas from my tutorials, so your books add themselves up.

6.3Mtutorial views
11,900+YouTube subscribers
500tutorials

Questions

Is this accounting software?

No. It’s a simple Excel tracker for income, expenses and profit. It doesn’t do invoices, payroll or sales tax.

Will it work outside the US?

Yes. Rename the categories and ignore the US tax dates, or use the set-aside with your own dates.

How much should I set aside for tax?

That depends on you. 25% to 30% is a common starting point, but ask an accountant for your number. This isn’t tax advice.

Can I use it for 2028?

Yes. Change the year on the Settings tab and start a fresh copy.

Does it use macros?

No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.

Which versions of Excel does it work with?

Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.

Is this a subscription?

No. You pay once and the file is yours to keep.

Know your numbers.

Income, expenses, profit and your tax set-aside, all adding themselves up.

Get the tracker $12.99

Not ready yet? Try the free Monthly Profit & Loss.

Small Business Income & Expense TrackerInstant Excel download
Buy · $12.99
Scroll to Top