Five spreadsheets for a small online shop
Etsy profit and tax, Shopify profit and fees, handmade pricing, inventory and stock control, and the order and postage log, in one download. Excel and Google Sheets.
What you get
- 5 Excel workbooks, 41 tabs and 31 chartsEtsy seller profit and tax spreadsheet, Shopify profit and fees spreadsheet, handmade pricing calculator, inventory and stock control spreadsheet, order and postage log
- Google Sheets versionsA make-a-copy link for each spreadsheet on the bundle Open me first page
- 5 PDF guidesEvery tab explained, with the sums checked by hand
- Two zips and an Open me first pageOne folder per spreadsheet inside the zips, each with its workbook, its guide and its own Open me first page
Why this one
- Real profit on every Etsy saleThe Etsy seller profit and tax spreadsheet takes every Etsy fee off each sale and shows the tax to set aside.
- The same for a Shopify storeThe Shopify profit and fees spreadsheet handles apps, ads and VAT.
- A price that covers your timeThe handmade pricing calculator prices each product from materials, your hours and the platform fees.
- Know when to reorderThe inventory and stock control spreadsheet shows what is on the shelf and when to buy more.
- A dispatch list for todayThe order and postage log tracks every order with Royal Mail and Evri prices.
How it works
- Unzip on a computerTwo zips, one folder per spreadsheet, each with its workbook, its guide and its own Open me first page
- Start with one fileThe handmade pricing calculator: your hourly rate on Settings, then one product
- Add the others as orders come inThe Etsy or Shopify profit sheet for your sales, the order log for dispatch, the inventory sheet for stock
Who it is for
Anyone in the UK running a small shop online, on Etsy, Shopify or both, selling handmade or bought-in products. It suits a first shop in the evenings as well as a shop that is already taking orders every day. Sole trader means selling in your own name rather than through a limited company. Only switch VAT on if you are VAT registered.
Questions
Do I need Microsoft Excel?
No. Each spreadsheet has a Google Sheets version, which is free with a Google account. The Excel files also open in the free web version of Excel.
How do I get it?
Straight after payment it is in your library on this site: two zip files and the bundle Open me first page with the Google Sheets button for each spreadsheet.
I only sell on Etsy. Do I need the Shopify file?
No. Use the Etsy seller spreadsheet, the pricing calculator, the inventory sheet and the order log. The Shopify file is there when you open a second channel.
Are the fees up to date?
Every fee sits on a Settings tab in each workbook, so you can check it against your own statement and change it in one cell.
Is this tax advice?
No. The tax to set aside is an estimate to help you plan. Your accountant and HMRC have the final say.
Made by Izhar Shah. I built a brand in the evenings alongside a full-time engineering job, and in its first twelve months it passed £500,000 in sales. I make the sheets I wish I had when I started.
Works in
Instant access in your library after payment. Your own figures, not tax or financial advice.