Google spreadsheet
In the fast-paced world of the sneaker business, effective management of inventory, sales, and financial data is crucial for success. This is where spreadsheets come into play as indispensable tools. Spreadsheets provide a structured and organized way to store, analyze, and manipulate data, making them highly valuable for businesses operating in the sneaker industry. Whether you're a sneaker retailer, Brickflipper or Sneaker-botter harnessing the power of spreadsheets can streamline operations and ultimately contribute to the growth and profitability of your sneaker business.
How does it work?
So let's start, firstly you can use the spreadsheet that I've made for you guys: Click Here. When selling a shoe in your Inventory make sure to copy everything from "Purchase date" till "Store", this way you have all the data copied to past it in the month when you sold the shoe in this case we delete in from the Inventory and paste it in the month June!
On the picture below you can see some of the shoes that we pasted in this spreadsheet!
Then on the right side of this sheet you can see the data that gets automatically created when you put in all the information on the left side on the picture above. Let's zoom in on the right side on the photo down below. When putting in Data on the left side of the sheet make sure to type the words of the platform correctly otheriwise the formula on the right won't be correct, so make sure to type Alias, StockX and Restocks with a capital letter!
Also when adding a new shoe from your inventory into the month of sale, make sure to drag down the columns: "Price VAT Incl", "Price VAT excl" and "Profit" like the photo down below!
Another thing that I wanted to add is, that you should change the formula of the calculation of VAT. The spreadsheet is now based on 21% VAT, we can change this by double clicking on the column and change the number of 1,21 to 1,19. This way when copying the data from your inventory it will be also changed in the month of sale, so you should only change it at your inventory!
And Lastly if you enter a new month you can duplicate the sheet and remove all the old data, do this by right clicking on the month and click on "Duplicate".
Last updated