Use This Free Spreadsheet for Your Independent Contractor Expenses

by
Robby Nelson, CPA
Updated 
September 21, 2022
March 21, 2022
Icon chek
Reviewed by

Looking for a 1099 excel template? You're probably hoping to find something — anything — that can make your taxes less of a buzzkill.

You're not alone. According to the Pew Research Center, 56% of Americans dislike or outright hate doing their taxes. (We won't talk about the 29% who like it — or the 5% who apparently love filling in a fresh 1040.)

If the Pew survey was only for self-employed people, Team “Outright Hate” would probably be even bigger. Freelancing or running your own business, after all, means dealing with a bunch of extra headaches at tax time. 

Luckily, Keeper Tax's free template will make doing your taxes a little less painful — for your soul and for your wallet. It's been updated with all the latest info for you:

Just click on the link above and "Make a copy" in Google Sheets. From there, you can also download it to use as a 1099 Excel template.

Contents

Introducing Keeper Tax's independent contractor expenses spreadsheet

This spreadsheet helps you track everything you buy for work and groups them according to their appropriate tax category. You can use it to lower your self-employed income and, ultimately, save on your taxes.

This free resource is brought to you by Keeper Tax, an app that helps freelancers and small business owners like you stay organized and save money. It automatically scans  your bank and credit card accounts to pick out what you can write off. At the end of the year, it takes care of filing for you. All in all, think "Quickbooks Self-Employed, but better."

{upsell_block}

If you want to learn more about their services, you can read my review showing why they're the best app to track receipts for taxes. But even if you don't want to try out Keeper Tax's services, they provide this tool for free.

It comes with no strings attached: you don't even need a copy of Microsoft Excel. 

Here's how it looks:

Screenshot of a 1099 expenses template on Google Sheets

I know it’s not  exactly the Mona Lisa.

But I would argue It’s actually way better. When was the last time the Mona Lisa saved your wallet and your peace of mind, all from the comfort of your own home?

That’s what I thought. 

And bonus, you don’t have to elbow past sweaty tourists to get the most out of this — there’s plenty of spreadsheets to go around.  

How to use this 1099 spreadsheet

This free 1099 template does two things that are very important for busy freelancers and small business owners.

  1. 🧮 It calculates how much you can deduct from your taxable income, and 
  2. 🧾 It takes everything you buy for work and translates into IRS-speak

It does this using three different tabs, which are color-coded 🟩 green, 🟦 blue, and 🟪 purple.

Screenshot of three color-coded tabs on a 1099 Excel template

 Let's go through them one by one.

{write_off_block}

1. 🟩 Schedule C Expense Categories

This first tab is your bread and butter.  All you need to do here is customize it with your name, and fill in your business-use percentages. (Those boxes are in yellow — hover over the cell for notes!)

Everything else here will show up automatically, based on what you enter in the other two tabs. Just a little bit of tax magic for you. ✨

This green "Schedule C Expense Categories" tab groups your work-related purchases into accountant-friendly categories — the same categories you'll find on a Schedule C.

Screenshot of Part II of a blank Schedule C, showing business write-off categories

Let's go through the sheet, one part at a time.

Total Tax Deduction

This green box at the top shows the total amount you can deduct from your taxable income. 

Screenshot of the top of Keeper Tax's 1099 spreadsheet, showing total tax deduction

It's calculated automatically based on everything you fill out in the template. So add your write-offs, and watch that number go up!

Column B: Schedule C Category

If you've ever been through the process of filing self-employment taxes by hand, everything in this column will look pretty familiar from your Schedule C.

If you'd like a detailed run through of this tax form, I recommend checking out Keeper Tax's guide to filling out your Schedule C. But in a nutshell, your Schedule C is the form you use to tell the IRS what business expenses you're writing off every year.

Schedule C forces you to split up your write-offs into different, somewhat arbitrary categories. 

Do you pay for advertising? You get a deduction. Travel to meet a client? You get a deduction. Visit an office supply store? Have a meal to talk about your business? All of those are tax deductions.

Column C: Line Number

This column shows you how to match up expense categories on this sheet with the lines on a Schedule C. Advertising expenses, for example, are on line 8 of the form.

The column is a great way to double-check your return and avoid the IRS’s attention — something no freelancer wants.

Especially if you're filing online, it's easy to rush through things because you were hungry for that tasty refund. But with taxes, it always pays to give things a once-over before you submit.

This column provides a great way to do that. With the Schedule C line number right there, you can be confident that, if the IRS ever comes knocking, you can provide them with required information that matches up exactly with the form.

Column D: Gross Expense Amount

Here, you'll see how much you spent on each Schedule C category over the course of the tax year.

For example, say you've spent $1,200 between your personal assistant, your marketing freelancer, and your web designer. You'll automatically see that number in row 10 of this column, for contract labor.

Great news: The sheet calculates this automatically by adding up the expenses you enter on the other two tabs of the template. You won't have to enter anything by hand.

Column E: Business-Use Percentage

Here's the only part of this tab where you might have to enter some numbers.

In most cases, the business-use percentage column is blank, meaning the default percentage is 100%. That’s because your business purchases are generally used exclusively for work. Your advertising expenses, for instance, aren't going to help you out in your personal life.

Still, there are some categories with special rules:

  • 🚗 Car and truck expenses (Actual expenses only): There are two ways to deduct car expenses, the standard mileage rate and the actual expense method. If you opt for actual expenses, you'll have to enter the percentage of time you drive your car for business purposes. Put this in row 8 of Column E, which is highlighted in yellow. (Side note: If you use the standard mileage method instead, check out our free template for mileage logs!)
  • 🍲 Deductible meals: Most years, business meals are only 50% deductible, unless you eat them on a business trip. In 2021 and 2022, though, all meals are 100% tax-deductible. This sheet has already been updated to reflect that.
  • 🏠 Business use of your home: Have a home office? You'll have to enter the percentage of your total square footage that makes up your workstation. This is in row 19 of Column E, which is also highlighted in yellow.
  • 🛍️ Other expenses: This cell just says "Mixed," because it really depends on what you're writing off. But don't worry. Your gross expense amount and your tax deduction for these miscellaneous categories will calculate automatically, based on what you enter in the "Other Expense - Grouped" tab.

Column F: Tax Deduction

This column is going to be your meat and potatoes. It shows how much you can shave off your taxable income for each Schedule C category.

If you want to lower your tax liability as much as you possibly can, you’ll want to record every deduction you possibly can. Do it, and watch the numbers in this column rise!

Column G: Notes

Here you'll find a couple of hints and best practices to follow, as well as links to useful resources. Read them if you get stuck!

{email_capture}

2. 🟦 All Business Expenses

The previous tab did most of the work for you, thanks to the magic of spreadsheets. To help feed it, you'll want to enter the details of all your work-related purchases in this blue middle tab.

Screenshot of a tab on a 1099 expenses spreadsheet, showing all of someone's business expenses

All you need to enter is:

  • 🗓️ The date of your purchase in Column B
  • 🛒 The merchant you bought it from in Column C
  • 💲The expense amount in Column E
  • 🖊️ The Schedule C category it belongs to, using a dropdown
  • 💭 Any other details you'd like, to jog your memory when it's time to file

That's all you need to keep great records for your write-offs.

3. 🟪 Other Expenses - Grouped

On this third tab, which is color-coded purple, you can list the expenses that don't fall into any of the other Schedule C categories.

Screenshot of a 1099 template all of someone's "other expenses," grouped by subcategory

For your own records, it’s a good idea to enter these in the previous, “All Business Expenses” tab. But you should separately enter them in this tab as well. This ensures the template will calculate your tax deductions correctly.

For some of these "Other Expenses" — like your cell phone bill — you'll have to enter a business-use percentage in Column D. The sheet will take this and automatically calculate your total tax deduction in Column E. (Leave the business-use percentage column blank for a purchase, and you'll get your gross expense amount counted as your total tax deduction.)

✅ Making sure your deduction amount is correct

To make sure the total tax deduction that pops up is right, be sure to drag the formula for business-use percentage all the way to the bottom of Column E, where your last entered expense is.

Screenshot of someone dragging a formula down column E of a spreadsheet with their cursor

If this seems like too much of a chore, you can always do things the easy way: have Keeper Tax do the work for you. They'll make sure you don't miss a deduction, so you can get your tax bill as low as possible. (To see how much you'll owe without these write-offs, check out their self-employment tax calculator.)

What to do after filling out your 1099 template

Once you have everything filled out, you're ready to file your taxes!

You can use this export sheet to fill out your own Schedule C with any e-file provider you choose. If you use an accountant, you can also hand it over to them — I’m sure they'll be happy they aren’t getting a shoebox full of paper receipts this year.

To make things even easier on you, consider filing with Keeper Tax. They'll take care of filling your Schedule C and wrangling all your forms.

{filing_upsell_block}

Whether you're using this free template or taking advantage of the Keeper Tax app, it's the perfect time to get organized. You might never love doing your taxes, but you can make it fast, cheap, and headache-free.

Robby Nelson, CPA

Robby Nelson, CPA

websitetwitter-link

When not hanging out with his high profile friends like Gandhi or Batman, Robby enjoys spending time with his wife and children. He can sneeze with his eyes open, has won two lifetime achievement awards, and has visited every country; three of which haven't been discovered yet. He is also a Certified Public Accountant and assists clients with a wide variety of accounting and tax issues.

Find write-offs.
File taxes.

Keeper Tax helps independent contractors and freelancers discover tax deductions and file taxes.

Try for free →
Find write-offs. File taxes.

Tax filing for freelancers and side hustlers

Most tax software isn't built for you. Ours is. We know every form you need and every deduction you can take to pay less this year.

Get started→
Yearly

Free Tool

What tax write-offs can I claim?

I am ...
Freelance designer
Freelance designer
Freelance designer
See write-offs
Company Contact Country
Alfreds Futterkiste Maria Anders Germany
Centro comercial Moctezuma Francisco Chang Mexico
Ernst Handel Roland Mendel Austria

At Keeper Tax, we’re on a mission to help freelancers overcome the complexity of their taxes. That sometimes leads us to generalize tax advice. Please email support@keepertax.com if you have questions.