Etsy Seller Spreadsheets, shop management Tool, financial, tax reporting, profit and loss, income, expenses, spreadsheet, excel, google docs


GST Included

  • Digital download
  • Digital file type(s): 2 PDF, 2 other files

Having trouble keeping track of your shop's income and expenses? Do you dread tax time because you have no records of where the money has been spent? Do you have any idea when seasonal periods are? How much profit you've made?

These simple and easy to use business spreadsheets will help solve those problems :)

These spreadsheets were created by an Etsy seller, for fellow Etsy sellers that want a simple and easy way to keep track of your business' income and expenses without is being unnecessarily complicated and a huge hassle come tax time.

Video walk-through of how to use these spreadsheets

Light Blue:
Dark Blue:
- Instant download - start using it straight away!
- Excel file format (can also be used in Google Docs)
- Can be used by ANY Etsy seller or online business owner - regardless or whether you sell digital or physical products
- Purchase once and these can be re-used again and again each year
- The top row/column titles will not move when you scroll down the excel file, so you don't need to scroll back up to the top of the worksheet, to remember what to enter in each column

I created these spreadsheets and tested them in my own business for over a year (and am still using them now!), making tweaks along the way so that they're the perfect tool for non-financial people who'd rather spend more time on their business, than the not-so-fun task of accounting.
- Simple, clean, non-gender specific design
- Formulas automatically calculate
- Tips and examples are in the spreadsheets to help guide you/recommended use (hover your mouse over cells that have a red triangle in the corner)
- Also included is an 8 page guide with instructions & tips on how to use Microsoft Excel

There are 5 spreadsheets included in this bundle.

Breakdown of all your expenses so your accountant can classify them correctly. There's also a column for you to keep track of when you've filed receipts for each expense to make sure you have all the necessary records for tax time. You can use the filters in this spreadsheet to see all of the transactions for each expense category.

Keep track of how much you've spent (or earned) for each income and expense category. You can compare which income sources are providing you with the most income, look at patterns through the year. E.g. if your sales increased in July your products may be seasonal towards the summer months, or the marketing campaign you undertook was successful.

Automatically transfers the totals from the income and expenses tab. You can record your goal income and expenses at the start of the year and compare these to how your shop actually performed. A graph will automatically show whether you met your goals, fell short or exceed them, so you can track your business' performance over time.

Formulas will automatically calculate the total income and expenses for each month, as well as the average each month for the year (a big help for budgeting!)

If you have a blog for your shop, earn affiliate income, offer consulting or virtual assistant services etc. This spreadsheet was designed for payments that often have a delayed period from when the income is earned and when it actually appears in your account. Use this spreadsheet to record a breakdown of any other income, including the date the income appeared in your bank account so you can make sure yo get paid.

Keep track of all the craft shows you went to throughout the year, how much you spent, how much you revenue you earned etc. so you can see which shows were worthwhile and which you don't need to go back to next year.
- You need to keep track of income and expenses, otherwise how will you know whether your business is actually viable and making a profit?

- The data in the spreadsheets tells you important information about you business including: the busiest months of the year (e.g. so you know to order supplies in advance), whether marketing campaigns were successful (i.e. results in an increase in sales),

- Make tax time a breeze - by keeping your records up to date as the year progresses, all the information's already there come tax time.

- Saves you money, by recording all of your expenses as you go, you won't forget any tax deductions you can claim come tax time

- Helps you track your income and expense goals so you can see what's working and what isn't working and make changes to your business accordingly

These spreadsheets can be used if you're an Etsy seller and/or if you have an online business outside of Etsy.

Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for the link to the download page.
- 54 Mistakes Etsy Sellers Make eBook:
- Order form template in chevron pattern or polka dot:
- Catalogue template:
- Shop Inventory spreadsheets:
- Pricing spreadsheet template to work out how much you should be charging:
- How to write product descriptions mini ecourse
- Blog planner:
- Business planner (no chevrons)
- Business planner (with chevrons)
- Finance binder (no chevrons)
- Budget binder EDITABLE
- Get it all printable planners:
- Tax planner (EDITABLE)
- Direct Sales Planner (EDITABLE)
- How to make labels in Photoshop ecourse (can be used to make product labels, address labels or any type of label for your business)

- GET IT ALL Ultimate Etsypreneur Success Bundle (ebook, ecourse, spreadsheets & planners!)
- Etsy shop critique:

I am unfortunately unable to provide after sales advice/troubleshooting on how to use Microsoft Excel or Google Docs. Basic excel skills are required. If you convo me requesting assistance I unfortunately will not be able to answer due to time constraints. There are NO REFUNDS under any circumstances, including if you do not have basic excel skills.

I accept no responsibility for errors that may be made in this spreadsheet. I am not accountant – I have created these spreadsheets based on my years of experience running an Etsy shop and online business. You are responsible for ensuring values (such as PayPal fees and tax rates relevant to your country) and formulas are correct - I recommend that you carefully check you have entered the correct vales and have not over-ridden formulas prior to using the information for taxes and financial reporting, and consultant an accountant if required.

These templates are strictly for YOUR BUSINESS USE ONLY. They are © AllAboutTheHouse Printables – you may not modify, reproduce or alter the templates, share with others or sell in original and/or modified format. I will not hesitate to proceed with legal action for violation of these terms of use.

By purchasing you accept and agree to the above terms of use.

>>>> Software requirements

- These spreadsheets were made in Excel 2016
- They should also work with earlier and later versions of Excel although I cannot guarantee this
- They should also work with earlier version of Excel although I cannot guarantee this
- They will work in numbers on a MAC
- They will work in Google Sheets which is free online:

I am not responsible if you are using a different software program and the files do not work. There are no refunds if these files will not work with your PC/laptop, or if you do not have basic excel skills and have problems formatting and/or using the spreadsheets.

The spreadsheets are intending for using on your computer or laptop (digital files to be used digitally), but if you wish to print the spreadsheet and file paper copies at the end of the year, this spreadsheet can be printed.

Most instant download items (and all sets) come in zipped folders. Please ensure your computer can open zipped folders.

The watermarks will NOT appear on your copy.

Colours may vary depending on your monitor and printer.

There are no refunds on digital items.
Please note that this is a digital product and no physical product will be sent.

Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for an automatic email containing the link to the download page. If you have changed email addresses or cannot locate the email which may go to your spam/junk folder, instructions for accessing the download page are included in the 'notes from seller' on your order receipt.
(c) All About Planners


>>> Subscribe to the blog to access the free printables library!

YouTube Channel:
Graphic Design Resources Shop:
Online store:

'Awesome setup thank you so much now I can be organised!!!! Xxx

'5 stars'

'Very easy to use and helpful! Thanks!'

'Great spreadsheet for my handmade business. Very handy. Thank you'

'Fantastic set up made plugging in all of my costs and expenses really easy. Lots of room to add your own personalization and makes keeping track of my business really fast! It's very straight forward to use even without training with Excel I believe it would be very easy for a beginner to use.'

'Great business documents to help me with the financials of my business. Thanks so much!!!'

'Very helpful'

'I love just how easy this template is to use. Really helping me to keep track of my Etsy Shop'

Instant Download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection: Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see programme terms



Owner of AllAboutPlannersShop

Message Rachael

This seller usually responds within 24 hours.

2,516 reviews

4.5 out of 5 stars
5 out of 5 stars

Awesome setup thank you so much now I can be organised!!!! Xxx

Nay 16 Oct, 2017

5 out of 5 stars

Absolutely love knowing my pricing is spot on, and I'm not leaving my numbers to an educated guess.

Denise and Abriana 20 Mar, 2020

5 out of 5 stars

So much easier than I expected. I love being about to see all of the revenue and expenses all in one place. This is a worthwhile purchase for anyone that wants their business to be more financially organised.

Jo Sparrow 21 Nov, 2019

5 out of 5 stars

Fantastic set up made plugging in all of my costs and expenses really easy. Lots of room to add your own personalization and makes keeping track of my business really fast! It's very straight forward to use even without training with Excel I believe it would be very easy for a beginner to use.

Katie 21 Nov, 2018

More from this shop

See more

Disclaimer: Etsy assumes no responsibility for the accuracy, labelling, or content of sellers' listings and products. Electrical or electronic products may pose a risk of fire or electrocution. Vintage, handmade, refurbished, or modified electrical or electronic products may not meet current safety standards and may not be in safe working order. Inspect carefully before use and message the seller if you have concerns relating to the product. Do not use a vintage electrical or electronic item if its safety can't be verified. To reduce the risk of fire, never leave vintage electrical or electronic products plugged in unattended. See Etsy's Terms of Use for more information.