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

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



In stock

GST Included
Oi! You can't buy your own item.

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

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

This listing is for the RED version. The blue version (shown in last 2 photos) is available here:

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. the summary of each expense category and once. 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!)

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 Sheet 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.

I don't accept returns, exchanges or cancellations. But please contact me if you have any problems with your order.



Owner of AllAboutPlannersShop

Message Rachael

This seller usually responds within 24 hours.

2,259 shop reviews

4.5 out of 5 stars

Rebecca Barkley 09 Apr, 2021

5 out of 5 stars

Fantastic spreadsheets! Very easy instructions and keeps all my finances in order. I was able to alter a few things to suit my needs, very pleased with this product.

Purchased item:

robertjstoop 12 Sep, 2021

5 out of 5 stars

This is exactly what I was hoping for. Sure, you can make this yourself, but in all honesty, the cost fir convenience is totally worth it… if not just for a starting point!

Purchased item:

Renee Barton 17 Jun, 2021

2 out of 5 stars

I thought it would be linked more so you update this me page and it updates the summary and other sheets. I could have created this one. If ur looking for super basic it will work

Response from Rachael

The spreadsheets are not ‘super basic’. The spreadsheets for each property have formulas to total each column, each row and the average. These automatically link back to the summary spreadsheet and automatically update the graphs. Unless you have purchased an entire unit block where each unit is the same, then rental income and expenses will vary for each property, so the income and expenses sections are not automatically linked between the individual spreadsheets for each property. Listing photos clearly show what is included, there are descriptions of each spreadsheet and a link to a detailed video tutorial showing how the spreadsheets work. Please check the listing description and contact me with questions before purchasing if you are unsure about something, before leaving unfair negative feedback.

Purchased item:

Jacqui Grimes 12 Feb, 2021

5 out of 5 stars

This is perfect! I love how I can set goals and see my income and expenses at a glance. The spreadsheet is an excellent tool to organize my online business.

Purchased item:

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 contact the seller by sending a Message 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.

Explore related categories & searches