Tutorial of Basic & Premium Google Sheet - Track Sales Profit & Inventory for your Online Business

[@amyflingos8732]

Hi Jason!! 👋Great tutorial!! Just purchased, finished watching this vid, and have started entering everything back to Jan 1. I cant stop lol. I am so excited to see my figures!! Thank you so much for your hard work on this and all of your content. I appreciate the fact that you priced it extremely fair as well!! 🙌

[@jasonmhayes]

Amy, you're welcome!! So glad you are finding this tool helpful for your biz. Best of luck reselling and Happy 4th!!

[@michaelbrown224]

I Built my own spreadsheet a year ago and have loved it.......UNTIL.......I got my hands on Jason Hayes spreadsheet (PREMIUM). Though i track a lot of the same things in my spreadsheet, what really got me slapping the table and saying " This man is a genius" is, The "BINS"!!!! What an awesome idea and worth the purchase just because of this. Soooooo many times have i gone downstairs to try and find a half emptied bin to put items in, searching and searching. Now, I can look at my spreadsheet and KNOW such and such bin has plenty of room. Thank you for this Jason. Love it.

[@jasonmhayes]

Michael, thanks for the glowing review! :) So glad you love the BINS tab. I debating putting it on the sheet but am glad I decided to do it. Best of luck! Jason

[@HollyPowellmarketer]

Awesome video!!! Love it.

[@xfakesmiles1989x]

Is there a spot that shows the Total Cost of all my Active Inventory?

[@3ativeThrifting]

Hi Jason, Can you explain more about how to use the manual entry columns on the month tab? I understand the premise of entering your total inventory at the beginning of the month, and adding on you your number on the units listed tab as you add to your inventory....but do you subtract from that tab when you make a sale? and when a new month starts does "units listed" start at 0 until you add more inventory for the month?

[@jasonmhayes]

Hey! No need to do any subtracting when you make a sale. Just add when you list items and enter total inventory at beginning of each month and your all set. Btw, this is mainly for you to know whether your inventory is growing or decreasing, by how much, and what your sell thru rate is. Great question! And, yes, units listed for the month will be zero at the start of each new month until you add to it :)

[@donnamatson506]

Hi Jason, still loving this spreadsheet! Quick question that I'm sure you'll have an answer for as I have tried my best to figure this out. The red arrows or triangles you mentioned, appear to be what lines up the format when you copy and paste your sold item? I have a column of 12 items that do not have that red thing. Once the item sells and I copy, and then paste that row is not aligned and the numbers in the sold price and shipping paid are white not green. Is there a quick fix? Thanks, Donna

[@jasonmhayes]

Donna, I'd be happy to help you with this! Can you message me on etsy and I will get back to you. Thanks!

[@kathleenhernjak8999]

Thank you for the tutorial! I am new to spreadsheets altogether. Huge learning curve for me. When I copy and paste a sale from active to sold, the columns do not line up. My spreadsheet also looks different (headings) than yours does. For example in my “2023 sales” my sheet has “platform” after “days to sell”. Yours does not. Help!😵‍💫

[@jasonmhayes]

Kathleen, thanks for reaching out! Are you copying the whole line and pasting it or just the portion that was in the video? You'll need to paste only the columns that are referred to in the tutorial exactly how theyre mentioned. The basic version is highlighted first in the tutorial but if you skip ahead you'll find the premium version tutorial. You can also use the chapters below in the description for quick skips :) Thanks so much for your order ! Jason

[@markv595959]

Hey Jason I am loving the spreadsheet. When a buyer purchases multiple items from me and I combine shipping how do you log that information? Thank you

[@jasonmhayes]

M Val, so glad you're enjoying the spreadsheet!! And great question! I always log each item on its own line in the sales tab. Then I divide the shipping received and paid by the amount of items. So, basically I'm taking the average shipping received/paid and inserting for each item. Does that make sense? If buyer purchases 2 items and pays $10 total for shipping, I will enter $5 received for each item in the shipping received column. Then, when I go to pay for shipping, if the label costs, say $9, I will then enter $4.50 in the shipping cost column for each item. Hope that helps!! Jason

[@markv595959]

@@jasonmhayes Yes, thank you very much

[@ellesorodilup]

Hi I bought the reseller spreadsheet it says 2022. Can I use for 2023? Also with poshmark, sometimes we offer shipping discount and seller pays a portion, where do I place that data?

[@ksmithhealthyliving]

Hi! I bought this today excited to transfer my excel spreadsheet data over to this one. I listed my categories, but they aren't all showing up in the drop down list?? I wanted them in a certain order so, just like in the spreadsheet, I would add a row above, then type in my new category. Those categories aren't showing?? Are we not allowed to add rows in this section?

[@jasonmhayes]

Krista, I'm sorry to hear this. I'd definitely like to take a look at this for you. It may be a simple fix to get this working for you. Can you reach out to me on etsy and we can go from there. Thanks, Jason

[@donnamatson506]

Hi Jason, I just bought your 2023 spreadsheet today and feel silly asking this question but here goes...I watched your wonderful tutorial "very helpful" btw. Then I clicked on copy cause its right there. I saw the question below you answered for tattedmom. Here is the silly question...is my spreadsheet in my computer downloads? I can type into the columns on the copy but from what tattedmom said it doesn't do anything? or should I be putting my info into the copy. Thanks

[@jasonmhayes]

Donna, thanks for your order! After you click "make a copy" your saved sheet will automatically save to your google drive (as opposed to your computer). You can access it by going to your personal google drive (just google "google drive" and it should either prompt you to sign in or automatically pull up your saved files with this sheet in there). Hope that helps! Jason

[@trishasmith506]

Thank you Jason. This is going to be super helpful. Any advice on quick ways to import active listings as a new user? lol

[@jasonmhayes]

Trisha, thanks for your order! Thats a great question. I'm not sure how your current setup looks but are you able to copy and paste from your current sheet into the active tab on the premium spreadsheet?

[@EastCoastBeachbum]

This program is awesome! When entering sold price under your sales, do I put in the sold price or the amount collected from buyer which includes sales tax? Ex. Item sold for $50, but Ebay collected an addition $3 for tax which is what the fees are based upon.

[@jasonmhayes]

Chrissy, So glad you're enjoying it! You can do whatever you would like with that. I typically don't include sales tax since buyer pays that to ebay and then ebay then pays that. I just include the price it sold for and the shipping that i collected. Cheers! Jason

[@susycorcoran2739]

When you enter peice you paid for an item are you including tax as well or the flat rate you paid? if adding tax do you calculate that for each item since a receipt could have several items on it. Hope that makes sense

[@jasonmhayes]

Susy, the way I do it is take the average that I paid for each item at that store. So if my receipt says I bought 10 items totaling $90 including tax, I would just enter a unit cost of $9 for each of those. Or you can just take the tax and divide it by each item and then add to each item if you want a more accurate figure

[@susancorcoran2381]

@@jasonmhayes makes sense. Thank you

[@connieball1]

Hi Jason, I love this spreadsheet! I think I've messed up somewhere, I ran out of category space so I clicked "add 1000 more rows at the bottom". Since then, some categories no longer appear in the category drop-down menu on the Active Listings/Inventory tab. So the items assigned to those categories now have a red triangle in the corner. Please help! Thanks 😊

[@jasonmhayes]

Connie, this should be a simple fix. Please reach out to me on Etsy and I will walk you through this. :)

[@danahickles3197]

Hello, again! It has been a while, but I am having an issue and don't know how to fix it. I have input the sales price. However, it isn't populating the days to sell. Actually, there are quite a few cells that have not populated. How do I correct this since the cells are formulated?

[@jasonmhayes]

Dana, can you share your sheet with me and I will take a look. Please message me on etsy if you're unsure of how to do that and I can give you my contact info. THanks, Jason

[@slgreene]

Hi Jason - Great spreadsheet! I'm currently watching the video (very helpful!) on how to get this setup and I have an odd question. The bulk of my inventory right now is my own personal collectables and items that I collected with my father over the years. Since I have no way of tracking "where" these were purchased, or "how much" was paid for these items, how should I go about entering these items on the spreadsheet? (My thought was $0.00 paid since I have no way of knowing, and then maybe personal collection as the store?)

[@slgreene]

Also, I am working on entering the few stores I have been to so far, and decided I wanted it to be sorted A-Z. After sorting it, the drop downs aren't working correctly. I'm not exactly sure how to fix it either.

[@jasonmhayes]

Slgreene, Yep! If items are coming out of your personal closet, I would suggest a cost of $0 since when it was originally purchased, it wasn't for the business.

[@jasonmhayes]

I would be happy to help you with this! Can you reach out to me on etsy and we can go from there. Thanks, Jason!

[@wyattnangel]

Hi Jason, Where would I put the sales tax that Ebay is collecting? Thank you

[@jasonmhayes]

Great question Angel! You don't need to do anything with sales tax on an ebay sale because ebay collects and then turns around and pays it, so I ignore sales tax

[@katherinealexander9392]

Hi Jason! I just purchased the 2023 premium spreadsheet. How can I sort column E on the sales tab In ascending or descending order? I tried to watch a KZbin video on how to do it, but then my sold dates would randomly change.

[@jasonmhayes]

Katherine, sorry I am just now seeing this. Have you been able to figure this out? If not, please message me on etsy and I will explain. Thanks!

[@donnamatson506]

Hi Jason, I just wanted to say that I am really enjoying this great spreadsheet! Thank you for the tutorial too as I go back every now and then if I get stuck. I have a question. Do you ever use separate sheets to categorize your items? My sales are Home Goods, Access., Shoes, etc. I have over 500 items listed and I do use the search but I have many of the brand so I have to scroll through many listings. Thanks, Donna

[@jasonmhayes]

Donna, thanks for the amazing review of my sheet! I'm so glad you are loving it! One way to quickly find what item you are looking for is by going to the active tab and hitting "Command F" or "Control F" on your computer (depending on what you have PC, Mac, Etc). This will allow you to find an item by keyword. Thanks Donna!!

[@donnamatson506]

@@jasonmhayes thank you so much, that is really helpful! I was using the edit and then search but it would only bring up the first item with that name. The control F key highlights all with the same item name. You sure made this search much more easier for me. Thanks again!

[@malloryf618]

Thank you for this spreadsheet, this is going to help so much! One question, how would you recommend inputting all of my inventory that I have now into this spreadsheet? I don't have a previous spreadsheet, I currently use the eBay Sku system to track all of my items. What would be the fast and easiest way to input my items from eBay to here? I have over 2K items and I know this would be timely to hand write them in, hoping you have a trick!

[@debbiepersaud2169]

I believe there is a way to download your sales from eBay. Give them a call and you may be able to copy and paste it? Not sure if this can be done. Maybe someone else who sells on eBay can help us out.

[@SouthernTreasures]

Wanna start off by saying "thank you" for this very helpful spreadsheet & also a very informative tutorial video. My question is do you think it would be beneficial to enter in all the remaining inventory from last year first & if so would it be able to track the 2022 inputs as well? Thanks again!

[@jasonmhayes]

Mackenzie, Thanks for your order and comment! Glad you love it! Yes, I do this with my inventory. I list my oldest inventory at the top and then work my way down. Then once you make sales, regardless of whether its a 2022 or 2023 inventory item, you can still track that sale.

[@SouthernTreasures]

@@jasonmhayes awesome! Thanks so much again!

[@danahickles3197]

I purchased your spreadsheet. My question is that am I able to use this sheet if I am not selling on platforms?

[@jasonmhayes]

Dana, thanks for you order! You can use this for reselling and other avenues too. How are you selling your items if not on platforms? Just curious...

[@TheQueensClosetDeals]

Jason, I am loving your premium spreadsheet but I think I may have messed up one the programmed formulas. When I am entering a sale into the sale tab, it is not automatically calculating the days to sell. On another note, is there a way that I can format the ACTIVE tab to be separated in 2 different ways. Is it possible to have anything with a listed date to be grouped together and alphabetized and the undated items to also be alphabetized? Or at the very least, the listed date items to be alphabetized. This will help me find items faster. Thank you!

[@jasonmhayes]

QueenShanWow, can you reach out to me on ETSY and I will help you resolve this? Should be a simple fix :)

[@Jtentertains]

Just purchased this however the formula is not there to calculate how many days it took to sell. Not sure what happened. Can you send that to me? Also, is there a way to search your inventory when it sells?

[@jasonmhayes]

Timothy, thanks for your order! I'd love to help you on this. Can you reach out to me through the etsy order and I'll get back with you? Thanks

[@dogs_cats_chickens_etc]

Hello. I purchased this yesterday and it is only letting me do view only. Can you tell me how to fix that. I'm excited to use it but that part is very annoying

[@jasonmhayes]

Tattedmom, are you clicking "make a copy" after you open the link?

[@NewPurposBoutique-if2ls]

Is this sheet capable of having separate tab sheets for product items such as one Tab/sheet dedicated for Jewelry, One tab/sheet dedicated for clothes, etc?

[@jasonmhayes]

New Purpos Boutique, is this something you would want me to build out? or are you just asking if you can add tabs?

[@chasescott6673]

Hey Jason! I just purchased, and I’m loving it so far. My first question.. (I’ll probably have more lol) since I’ve got autoposher, my listings are deleted and re listed. So I don’t think I have access to “listed” dates for all of my listings. Everything within the last 30 days I do, but anything older I don’t. Luckily for me I only have 184 active listings at the moment. Would you just make a random date to add everything I’ve had over a month? I don’t have an exact number but it’s probably 100-125 listings older than 30 days listed. Just curious how you would do it. Thanks!

[@chasescott6673]

Also, when you add the cost for the item do you divide the cost by the number of items? Or just $4.99? Technically I’m at $5.16 for most of my items.

[@jasonmhayes]

Chase, thanks for your purchase! Glad you're loving the spreadsheet :) You don't have to put the listed date in there retroactively. Thats more for you to gage how long you've had certain inventory items. If you'd like, you can just start with the items that you are listing now and carry it forward with new listings. However, just know your days to sell column will be off because a listed date won't be included on the older items that sold. I have been doing the cost exactly as you described. Total amount spent at thrift/etc. divided by # of items. You can also enter the amount that you spent on each item individually if you'd like. The cost field is in there mainly to give you an idea of how much profit you're making per item. Make sense? Thanks for reaching out! Jason

[@chasescott6673]

@@jasonmhayes Thanks for the reply! can I add a tax formula to the spreadsheet? That way I can just put the cost of item, but sheets does that math for me. If so, how do i do that?

[@markv595959]

Yo Jason, so my total listings on eBay compared to my spreadsheet are off by 3. Most likely forgot to remove a line once something sold. Any ideas on how to get these back in line with each other or do you think when I get the spreadsheet going into next year there is an easy way to get them synched? Thank you

[@jasonmhayes]

Hey Mark! The way that I can think of to correct this would be to double check your inventory with what you have on ebay and see if there are any that should be deleted.

[@markv595959]

Understood. Thank you @@jasonmhayes

[@pauln9399]

Hi Jason. I am loving the spreadsheet but am having an issue. When I copy my data from the active tab and move it to sales I am getting an "invalid" message in the store and category columns. It says that input must fall within specified range and it wants me to choose date for sold and listed. If I do the entire entry manually it works. Hoping you can help me figure where I'm going wrong. Thanks

[@jasonmhayes]

Paul, you're actually doing it correctly. That "invalid" message should be there. It doesn't affect anything. It's simply because you are copying a dropdown cell into a nondropdown cell. You'll notice that the data still pulls into the correct tabs and displays correctly. Thanks for your order!

[@pauln9399]

@@jasonmhayes Thanks for clarifying it for me!

[@shovelcharge]

Can you copy and paste a part of this to make more than 7 platforms that one sells on?

[@jasonmhayes]

unfortunately no you cant.

[@shovelcharge]

@@jasonmhayes I sell on 9 different platforms, but some of them I barely use like Craigslist and Nextdoor. I just watched the whole video and I was ready to buy, but I came across this apparent issue. Is there any solution to this? Maybe if I had to, I could have one category as “other” or “sold locally”?

[@reneetee1563]

Is it imperative to add to the tab of active listings? will that affect the spreadsheet with calculations? I feel like that would be really time consuming if I do not have current listings noted somewhere. thanks!

[@jasonmhayes]

You don't have to per se, but you'll then have to manually enter in each sale without the ability to copy and paste. This may add more work with the Store and Category columns.

[@mrghosttrades]

Hi I bought the reseller premium spreadsheet just few days ego. As I’m uk based seller so I deal in British pound Sterling, instead dollars! I have tried to change currency from dollar to pound but unfortunately spreadsheets is locked, due to that I’m unable to change it.. Could you please help me out?? Thanks

[@jasonmhayes]

Hey, thanks for your order! I’m willing to take a look at this for you. Did you see my response on Etsy?

[@donnamatson506]

Before I purchased this spreadsheet I kept everything manually in a notebook so I have everything logged from 2022 - cost, item, sale price, dates, fees, shipping. etc. What if I sell something that I purchased in 2022 and sell in 2023 as it is income. Thanks for your time :)

[@jasonmhayes]

Yep! That is how I do it too. I add all of my active listings into the first tab regardless of when I purchased them. Then I just log all of my 2023 sales into the sales tab

[@donnamatson506]

@@jasonmhayes thank you! Looks like I have a bit of work to do :)

[@jenniferschnabel9788]

I just purchased this spreadsheet and watched the tutorial. I have one question/suggestion. I use a SKU for each of my items and then tag the item and file it in a bin. Is there a place for a SKU and I missed it? I guess I could put the sku in the notes section?

[@jasonmhayes]

Yep! I would do just that :) Thanks for you order Jennifer!

[@jenniferschnabel9788]

@@jasonmhayes another question. My active inventory starts on line 55. I put my first item in on that line. I’m now at line 201 and it says up In the right corner I have 160 total. Yet I’ve only added 147 (counted to be sure). Why are the first 54 lines hidden? Are they supposed to be? And my count is off. Help…. 🧐

[@rickc2222]

interesting. i have not bought yet. but one concern. returns does not seem to subtract from profits. this does not seem right. why not enter the return/refund amound under cost of goods column...as it is a cost of goods AND would then be correctly counted against profits. or am I missing something?

[@jasonmhayes]

Rick, you are correct. Returns won't show up subtracted from profit.. BUT... the monthly tab DOES show you all your total refunds for the month. So calculating profit won't be difficult to see right there on the same tab.

[@laurarobinette2623]

I also track my home office expenses (under an old spreadsheet system I was using a couple years ago) for electric bills, etc. I am thinking I can put this under expenses in your system that I just purchased today (which is very impressive, BTW!). :) Can you think of any reason why it would NOT be good to track this type of expense in your system?

[@jasonmhayes]

Laura, thanks for purchasing my sheet! :) I'm glad you like it so far. I can't think of any reason off the top of my head why you wouldn't want to track those expenses in the spreadsheet. I like having everything in one place.

[@laurarobinette2623]

@@jasonmhayes Thanks! :)

[@classiccontroller8868]

I have a question on the refund. Would it not be better to put in the new date on the item when relisting? Since you copied and pasted the information with the original listing date, would that not effect any data from before? For example you listed it on Jan 3 then sold on Jan 9th then refunded Feb 8th. Wouldn’t it be best to put Feb 8th down on as the date when relisting?I hope you understand what I’m trying to say.

[@jasonmhayes]

CC, I completely understand what you are saying. And sure! You can do whatever you would like with your sheet. I do it this way so that I know how long I have had an item in my inventory. But, the way you are suggesting is great too :) Thanks for reaching out

[@classiccontroller8868]

@@jasonmhayes thank you for the reply. I’m so glad I found your video. I’m going to start reselling again and wanted a good excel spreadsheet but don’t want to pay lol. Anyway after looking through many spreadsheets I saw one that I liked but still lacked some stuff I wanted. So I went on KZbin to see and so glad I found your channel. This spreadsheet has everything I want and it’s for Google sheets!! Great awesome job. Thank you

[@giovannanicassio3554]

hi, I just purchased your product about a week ago. I got the premium 2023 version. on the sales tab, nothing is auto populating. I can't figure out why, i've watched your tutorial and can't identify why it's not auto populating. I've even entered manually instead of copy and pasting and nothing. any idea why?

[@jasonmhayes]

Hi, Thanks for your order! Are you using the 2023 for '23 numbers or '24? The '23 is good for last year.

[@BlaineSword]

Is your program only good for the year? Can it not be used forever? Can I list items and keep track of things I am doing now in 2024? @@jasonmhayes

[@giovannanicassio3554]

Sorry, not sure what happened to your comment. I'm using the 23 version for 24 year. do you need to buy the 2024 version to use it in 2024? I thought I could buy the 2023 version that you had on sale to use as I didn't need all the bells and whistles yet as i'm still pretty new.

[@heatherhall628]

Hi Jason. Thanks for this great resource! The video is very helpful trying to get started using it. Any suggestions on the best way to record a "bundle" purchase from Poshmark? Thanks.

[@jasonmhayes]

Thanks Heather! Whenever I sell a bundle I just list with each item on a different line. I split the seller fee by the amount of items in the bundle and record that way. Make sense?

[@heatherhall628]

@@jasonmhayes Thanks Jason! Makes perfect sense!

[@HollyPowellmarketer]

It'd be awesome to have a custom sku column-

[@HollyPowellmarketer]

never mind I'm going to use the bin column for this

[@jenniferschnabel9788]

@@HollyPowellmarketer thanks for the tip. I was trying to figure out something too. I just listed it in the title first….124 Lucky Brand t shirt. Still trying to figure out how to simplify things.

[@cellphonerepairgeeks7394]

what is the software you use to cross post on different platforms?

[@jasonmhayes]

Vendoo- check the links in the description of my videos :)

[@cellphonerepairgeeks7394]

@@jasonmhayes is there a way to add more platforms on the premium spreadsheet?

[@kathleenhernjak8999]

Thank you for the tutorial! I am new to spreadsheets altogether. Huge learning curve for me. When I copy and paste a sale from active to sold, the columns do not line up. My spreadsheet also looks different (headings) than yours does. For example in my “2023 sales” my sheet has “platform” after “days to sell”. Yours does not. Help!😵‍💫