This template will save you time in determining the profit (or loss) of your Etsy business! This template could also be used by non etsy sellers. An upgrade option is also available for an Amazon handmade improter. The best part about this template is the ability to easily import your etsy, paypal and amazon handmade sales and fees, rather than having to enter them in individually.
There are several pages within 1 file of this template, that are all linked together to save you time on data entry. The main running totals/summary page is a 1 page summary that will include the annual or running total summary of all your sales and expenses, and show your total profit/loss overall, and a profit or loss related to shipping income and shipping purchased.
The summary totals will include-
-Etsy Sales (whether direct checkout or paypal)
-Paypal Sales (totals are for all venues that use paypal, not per venue)
-Other Sales (there will be a place to enter other sales, that don’t utilize etsy or paypal)
-A variety of expenses, including shipping label purchases, etsy listing & transaction fees, credit card processing fees and you have the option to enter your expenses for several other categories:
- Packaging Materials
- Education / training
- Other expenses
- Other fees
A version with a few more extra expense categories is available upon request, or you can upgrade to the monthly sales & expenses version which includes more expense categories and taxes collected information.
Depending on which version you order, you will need to download a csv from etsy, paypal or amazon handmade, however directions are included on how to download them and copy and paste them into the template. The summary page will then add up all the totals from the csv’s and any other information you enter.
-Annual/running total version (original) – has 1 summary page showing the annual or running total for everything. Can be used with etsy and/or paypal.
-12 monthly summaries – includes 1 page for the annual and 12 more summary pages for each month and has 2 extra expense categories. Also includes a summary of tax collected.
– Amazon Handmade option – both options are available with new Amazon handmade categories (see last picture for the highlighted changes). The template will total your Amazon Sales, Shipping income, Shipping labels purchased and transaction fees, from your Amazon handmade csv. Directions are included for downloading your Amazon csv.
Customer Reviews of this Template~
“Wonderful spreadsheet for keeping up with your sales and expenses. Love the fact that I can just copy and past my Etsy and Paypal CSV’s into the spreadsheets, then everything is all totaled on the first sheet. Quick and easy. Erin is great to work with, she answered all my questions and quickly to. Thanks so much! ” – Robin
“I wish I had bought this spreadsheet sooner! It truly is time saving and very easy to understand. Plus, Erin is very communicative and will be there for you if you have any questions. Purchase this template already and make your life easier!” – Valerie
You will receive via email, an Excel Spreadsheet and a PDF with directions. Will work with all version MS Excel. Templates come personalized with your name and/or shop name.
*This file is not meant to provide tax advice. This template is just a way to summarize data from your CSV reports.
*You do not have permission to distribute or re-sell the template, so please don’t do it.
If you have any questions, please feel free to contact me.
See more handmade seller templates here.
See more general business templates here.