Are you an Etsy Seller looking for a quick way to generate your profit and loss statement? Or generate analytics from your shop data with a few mouse clicks? Check this Excel Template built specifically for the Etsy sellers in the US/UK/Canada but may work for other regions also if the data extract is in the same format. This excel template will help you to generate:
● A profit and loss statement for current and all past years in one sheet
● See the total deposits made by Etsy in yearly/monthly basis
● See the total income and expenses based on the categories.
● Identify your top 10 selling countries your orders are shipped.
● Filter data base on the year on year.
● Have capabilities to generate your own report using pivot table feature.
● Data model is already defined and data is extracted from the CSV files extracted from Etsy.
● Use your own additional revenue/expenses outside Etsy and add it to the folder.
● No need to copy and paste data into multiple sheets.
Steps to use the template:
1. Download the main template named ETSYBOOKINGTEMPLATE
2. Download the additional template for Template for Additional Income/Expense.
3. Download the Orders, Payments, Deposits, Monthly Statements from Etsy website as mentioned in the main template.
4. Create the folder structure as mentioned and add the files on the respective folders.
5. Open the file and go to Data --> Refresh All to refresh your data in the template.
Please send a message if you get any error so that I can setup time to go through the issue and address it.
____WHAT YOU GET_____
● Instant Download Editable Excel File **NO PHYSICAL PRODUCT WILL BE SHIPPED TO YOU**
● This is for your personal use only and not permitted for sharing and mass broadcasting.
_____DOWNLOADING_____
● Your file will be ready to download immediately after purchase
● You will get an email with a link to download the spreadsheet
● You can also find your purchase later in Etsy under "You" then "Purchases and Reviews"
● Download your Excel file and save it to your computer
_____EDITING_____
● You can edit the information that are input fields.
● It will work with Microsoft Excel or excel 365. GOOGLE SHEET is not supported.
Disclaimer: This basic bookkeeping spreadsheet template and is not set up for a specific country, it is set up in a way that no matter what country you are from you are able to track your revenue and expenses and additionally your sales taxes. It is important to check with an accountant or financial advisor on which revenue streams you should collect sales tax and also on which expenses you could possibly get sales tax returned to you.