Free Small Business Tax Spreadsheet

Organize your finances for your small business with this free small business tax spreadsheet in Excel. Learn how to do your taxes for your small business.

If you are new to having a blog (or any self-employed business), you may not feel the need to have an accountant.  Even if you are more established but have a simple small business, you may be able to do your own taxes.

Hey y’all, Phillip here.

Tiffany and I have always done our own personal taxes with Turbotax, so it was natural for us to attempt our own self-employment taxes as well.

Disclaimer: this post is opinion only, and it should not be mistaken for professional tax advice.

Taxes for self-employment are generally the same, whether you have a blog or a physical business that you are running (such as selling LuLaRoe or essential oils).

This post is not going to teach you how to do bookkeeping for your business (that’s for another time by someone more experienced than me!).  Instead, we are going to show you how we organize our self-employment expenses so that filing our own taxes goes a lot smoother.

Also: if you have a chronic health issue like Tiffany does, here’s how we organize our finances to make medical deductibles easier.

Note: any dollar amounts in the spreadsheet are fictional and do not accurately represent costs.

Click the link to download this free small business tax spreadsheet.

What You Need to Know For This Free Small Business Tax Spreadsheet

When you file your taxes for your business, there are a few things that you’re going to need to know:

1. Your income, divided by each source
2. Your expenses, divided into lump sums by categories such as home office, communications, advertising, and more.

Each of the above categories has its own tab in the spreadsheet.  Let’s go over each of the 10 tabs together in this free small business tax spreadsheet.

Sheet #1 – Recurring Expenses

Before we start actually categorizing expenses, we also like to have an idea of what my regular expenses are for budgeting purposes.  For example, every year we pay a renewal fee for our blog’s hosting services.  

2026 update: we no longer use GoDaddy, but do our hosting through BigScoots. We can’t say enough about how impressed we have been by them. Their customer service is top-notch with incredible response time.

We also pay a yearly fee for our social media hosting through CoSchedule and our Pinterest/Instagram posting through Tailwind.  Our former email service, Feedblitz, is paid monthly.

2026 update: we no longer use Feedblitz, but do our newsletter with Kit. It is much more user-friendly, and it’s landing pages are great to use.

Sometimes these yearly fees can cost a few hundred dollars each.  In order to save up for that, we like to put a little bit of money aside each month.  This first sheet tells me how much money I need to be setting aside for my regular expenses.  As you can see, we put in yearly amounts for GoDaddy, CoSchedule, and Tailwind, and divided them by 12.

We put in Feedblitz monthly cost and multiplied it by 12 so that I can see how much it costs me each year.  We like to have both the monthly and yearly totals.  The monthly total tells me that we need to be setting aside $95.67 for regular expenses.  The yearly total will help us at the end of the year see the difference between how much we actually spent in the year and how much we spend with irregular costs.

Sheet #2 – Earnings

One reason we keep track of my earnings in this same spreadsheet is so that we can calculate how much we should take out each month for taxes.

Each source of income has two lines: how much was earned that month, and how much was actually paid to us that month.  Unless the source is direct sales to us, it typically gets paid out a month or two after the month it was actually earned.  For example, anything we earned from Amazon gets paid two months later.  Anything we earned from Feedblitz (ad revenue from our emails) or Monumetric (ads on our website) get paid about a month later.

2026 update: we now use Mediavine for our ad service.

Your taxes will be based on how much you have been paid, not how much you have earned.  Hence the need for two lines per source.

Each state has radically different tax rates.  We personally keep out 25% because Phillip has a full-time job.  However, some people keep out as much as 50% and pay quarterly.  This is not something we are going to explain here since it varies so much for each person.  This spreadsheet is set for 30% taxes.

As you can see from the example in my spreadsheet, we earned $385 in January but was only paid $356.  This means we should set aside $106.80 to pay towards taxes.

Sheets #3-10 – Categorized Expenses

Now we’re getting into the important parts!  When you submit your taxes, you will not submit one lump sum of all of your expenses for the year.  Instead, you will be asked sums for different categories.  The first year we did this, we had no idea we would be asked to divide it up.  It took us hours to go through our budget software (we use Actual) and manually divide them.

Now, every time we put an entry into Actual that is a business expense, we also enter it into the correct category tab.  This makes it so easy when we do our taxes at the end of the year!  We just look at the total for the top of each category and enter that.

Side note: if you also itemize medical expenses, those need to be divided up into categories as well.  We have a free spreadsheet on our website for categorizing those expenses that you can get here.

There are seven categories that we personally use.  Not everything single thing you do for your self-employment is tax-deductible, however.  Quickbooks has this great explanation on what should and should not go into each category.

As a blogger, most of our expenses are in the Advertising and Other categories.  We do not sell anything physical, so we do not have any inventory expenses.  You may have additional expenses for categories that we have not listed here.  If you do, it’s simple to make a copy of an existing tag and rename it to the category you want.

2026 update: with Tiffany’s books, we now use more categories than we did before, like inventory.

A Word of Caution

As you use this spreadsheet, please remember that it is just a tool!  It cannot substitute research and education on tax law (especially since taxes can change from year to year!). It is your responsibility to file taxes correctly.  If this is a struggle for you, then you may want to look into getting a certified tax specialist to help you.

Another version of this post was written by Tiffany and published on My Daydream Bookkeeping which is no longer live.

Pin This Free Small Business Tax Spreadsheet

Was this free small business tax spreadsheet helpful for you? Share it on Pinterest!