Download and get started using the NEW Ginger Marvin Reseller Spreadsheet 2.0!

  Рет қаралды 26,802

Ginger Marvin

Ginger Marvin

Күн бұрын

Пікірлер: 309
@MavVision_0
@MavVision_0 2 жыл бұрын
So I've paid 2 months with the reseller genie. And I just started yours 😊. My opinion is you guys can build a spreadsheet I thought the integration they offer would be simpler and worth the monthly fee. You can't sell similar to refresh or if you made mistake because it would duplicate the item and have to find the old listing and delete. As well there integration never matches the shipping so my analystics would be off and sometime the integration would double the sell of an item. I actually enjoy manual adding the information and you can actually see the profit per item and the graphs are so much better. If anyone is in the Market for a true reseller spread sheet. You found it here congratulations guys. Enjoy y'all
@pamelajanak3749
@pamelajanak3749 7 ай бұрын
I've been using this spreadsheet for 2 months now and this weekend I've been going crazy over why I have incorrect numbers on At a Glance and Daily Totals. I remembered you made videos about the spreadsheet, so happy I came back to see you covered this!! You are awesome! THANK YOU!
@KTXThrifts
@KTXThrifts 2 жыл бұрын
This is the most amazing spreadsheet! Thank you so much for all your hard work and making it available to everyone and making videos to help guide us through it!
@GingerMarvin
@GingerMarvin 2 жыл бұрын
Thanks so much!
@mark-ihle
@mark-ihle 11 ай бұрын
@@GingerMarvin Regarding eBay's handling of sales tax collection from buyers, which is then added to the order total and subsequently deducted, should the sales tax be included in the 'Sold Price' column, and then accounted for as a deduction in the 'Fees' column?
@GingerMarvin
@GingerMarvin 11 ай бұрын
@@mark-ihle there’s no need to track sales tax. But if you’d like to you could use one of the spare columns to track it.
@sherrihost3027
@sherrihost3027 2 жыл бұрын
I love the new spreadsheet! I think my favorite column is the Days Active and the different tabs for Active/Sold listings
@brookealexander9723
@brookealexander9723 Жыл бұрын
I downloaded this spreadsheet again for a fresh start for 2023 without even know about the updates and I am pleasantly surprised! Love the updates!!!!
@rebeccaofpollywogflatts8976
@rebeccaofpollywogflatts8976 2 жыл бұрын
Thank you for taking the time and effort to help our community. You are much appreciated.
@ML-ri4kb
@ML-ri4kb 11 ай бұрын
I am at about 11 minutes and I am so GEEEKED!!! This is amazing. Call me a nerd but I am so excited for this speardsheet. Sooo good!! THANK YOU!!!
@marcialuvs2sell494
@marcialuvs2sell494 2 жыл бұрын
Thank you for the Spreadsheet! When we get to Jan 1 2023 should we be starting a New Spreadsheet for 2023 with just Active Listings, or do we just keep going with the current spreadsheet in 2023? If we do need to copy active listings into a New 2023 spreadsheet can you do an instructional video on that? Thanks Chris!
@sunshinegypsea
@sunshinegypsea 2 жыл бұрын
@marcialuvs2sell I’ve got this same question as well!!! Have you found out an answer? Ty
@marcialuvs2sell494
@marcialuvs2sell494 Жыл бұрын
@@sunshinegypsea Chris mentioned in one of the lives that he is going to do a video to demonstrate how to transfer unsold inventory to a new spreadsheet for 2023. Hopefully the video will come out soon.
@sunshinegypsea
@sunshinegypsea Жыл бұрын
@@marcialuvs2sell494 thanks for filling me in! I’ve been too busy with the holidays to catch any lives! I’ll be on the lookout for it. Thank you so much. 😊
@rootsandwingsandthriftythi1594
@rootsandwingsandthriftythi1594 Жыл бұрын
I have the same question…
@TriMinez
@TriMinez Ай бұрын
This is incredible. I have been using this for the past week to help sort out the finances on my eBay store where I sell raw Pokemon singles and WOW. Quick question though, before utilizing this spreadsheet, I already had over a thousand active listings on ebay. Do you have any tips on how to still effectively use this spreadsheet taking into consideration what to do when items sell that I listed before using the spreadsheet? The first idea that comes to mind is only utilizing the spreadsheet for items listed that are over a certain price threshold and just retroactively adding sales into the spreadsheet when they happen, because it doesn't seem efficient going back and adding 1000 $1 listings to the inventory page.
@heideeking9887
@heideeking9887 6 ай бұрын
This is just what I needed! I don’t see a column for taxes. Do you include that in your fees column?
@SandyDesmond
@SandyDesmond 9 ай бұрын
This is EXACTLY what I have been searching for! Thank you! Thank you!
@Wicklady
@Wicklady Жыл бұрын
I just love this spreadsheet. Thank you for offering it to all of us. I feel like I am tracking this correctly now. I would really love a year end video showing how to reset you sheet for a new year. I am kinda dreading and not sure how to do it. Thanks again.
@GingerMarvin
@GingerMarvin Жыл бұрын
You are in luck! kzbin.info/www/bejne/goXVpq2rmZ1qabM
@davidlane9990
@davidlane9990 2 жыл бұрын
Down loaded month or so ago and was totally over my head. Thank you for this video, now I understand it (sort of) 😂😂. Thanks for all you do to help others
@sunshinegypsea
@sunshinegypsea 2 жыл бұрын
Do we continue with the same spreadsheet starting 2023?? How does this work? Ty for any help!
@joannaward7708
@joannaward7708 2 жыл бұрын
Hi! I just downloaded your spreadsheet & so far loving it. Im just a little confused on what amounts to actually put in. Could you do an example video that show an eBay sale? Preferably one that you accepted an discounted offer. I can’t figure out for the life of me what figures I should put lol. Thx ☺️
@WhimsicalAuntToni
@WhimsicalAuntToni Жыл бұрын
Thank you for the updated spreadsheet. I've gotten everything trransferred over for the new year! Prosperity to all in the coming year!
@rayharrell7791
@rayharrell7791 2 жыл бұрын
Great spreadsheet. I added a column at the end to see how many days somethign sat in inventory before it sold. That will help me know what kind of items to look for. I also added a tab that helps me calculate the actual COG including price paid, tax (until I get my reseller cert), and mileage. Your sheet doesn't seem to deduct the COG from the total profit, so I changed one of the columns to enter that info. Otherwise, great sheet.
@ChristinaPatterson-qq1ng
@ChristinaPatterson-qq1ng 6 ай бұрын
Love your spreadsheet! I ran into a problem as I somehow changed Column C on the Inventory sheet and I can't figure out how to get it back! HELP!!
@Webeolabs
@Webeolabs 2 жыл бұрын
This spreadsheet is from Hustlesheets lol. But hey thanks for making it accessible!!
@ronald3752
@ronald3752 Жыл бұрын
Who is hustlesheets?
@treasuresnownthen
@treasuresnownthen 2 жыл бұрын
New Sub came from BOLO Buddies..someone there recommended your inventory system/spreadsheet. How have I never seen your channel? Glad to have found you!
@sarahinhere
@sarahinhere Жыл бұрын
Thank you for the update! Have you said what you do at the end of the year? Do you delete the things that have not sold and move them to a new sheet?
@Wicklady
@Wicklady Жыл бұрын
I have the same question. If you found an answer please let me know. Thank you.
@corinne_momof8
@corinne_momof8 11 ай бұрын
This is awesome!! Thank you!! I was so overwhelmed about how to track everything and this is so helpful!
@Wicklady
@Wicklady Жыл бұрын
This spreadsheet is absolutely amazing! Thank you so much to sharing it. Could you please make a video on how to reset this spreadsheet at year end for a new year? Do you just copy active listings to a new spreadsheet and keep going? Thank you. Thank you.
@nadine2839
@nadine2839 Жыл бұрын
Such a great comprehensive video. As someone who’s not familiar with google sheets I felt confident. Thank you!
@GingerMarvin
@GingerMarvin Жыл бұрын
Glad it was helpful!
@VeronicaHughett
@VeronicaHughett 3 ай бұрын
Do you have a way thst we can see how manys days active that doesnt disappear when it sales?
@lenavanvintage
@lenavanvintage 6 ай бұрын
I was excited to find this spread sheet and that it has an expense tab, but bummed to find out there is no profit/loss view taking the net profit and subtracting to expenses to find actual profit before taxes. Is this something the end user could add in somewhere? Thanks.
@1fashionbliss
@1fashionbliss 6 ай бұрын
That would be awesome! Tag me if so. Thanks
@angelawilloughby6680
@angelawilloughby6680 2 жыл бұрын
Thanks for the spreadsheet! Loved the original and used it all through 2022. Looking forward to this new version. Side note:****Would love to see a sell through rate on a future update of this spreadsheet. I customize your spreadsheet, but I don't really know how to implement that on a spreadsheet. I have a mid-expertise on spreadsheet.
@ChasityNic1
@ChasityNic1 Жыл бұрын
Hello, I am new to ebay and this spreadsheet. Do you include tax when you input Sold Price on the inventory slide or only the actual sold price less tax? Column V. I originally was using the price with tax and changed it to the actual listed price without tax and some of my items have a negative net profit. I assume I am not charging enough for the item. Can you help?
@cherylsantos8791
@cherylsantos8791 Жыл бұрын
@ChasNicole1 Hi I had the same question. Does sold price include tax & shipping since the buyer paid for it. Did you get an answer?
@callenstewart
@callenstewart 8 ай бұрын
This is fantastic. I got WAY too excited about the date picker (it's the little things). The only thing I do that I don't see here, is I have columns with checkmarks showing where I have listed the items. So I can see (presale) where is this item listed for sale?
@flairgrace1184
@flairgrace1184 Жыл бұрын
I waited until the first of the year to check this out. I am working on some other spreadsheet downloaded from another reseller. BUT, this one is stellar! I can't wait to dig in and try it out. Thank you so much for all of your hard work on this!
@GingerMarvin
@GingerMarvin Жыл бұрын
Fantastic! Thanks for trying it out!
@deborahriddle8421
@deborahriddle8421 Жыл бұрын
Thank you so much for this spreadsheet! It is really helpful and comprehensive. It also saved me a lot of time as well as trial and error of trying to build it myself. Really appreciate the video tutorial as well.
@tracystockstill4656
@tracystockstill4656 Жыл бұрын
Thank you for this wonderful spreadsheet! It has been such a great tool in my reselling business! I am trying to locate where you talked about being able to search your spreadsheet to inventory your items. I'm not sure which video you covered this topic. I am trying to find out how to list my SKU/Bin in one column for my end of year inventory. I want to be able to pull my box letter and see items listed on my spreadsheet. Thank you! :-)
@jaclynscott4440
@jaclynscott4440 2 жыл бұрын
Thank you so much for all your hard work!! I can't wait to start using the newer version!! I love how the sold listings are in a new tab! And thank you for the expenses and mile log section! Tried creating one on my own, and it flopped :P
@macbookpro111
@macbookpro111 Жыл бұрын
Thank you so much for adding the promoted listing.fees yay!
@sandradriesen3656
@sandradriesen3656 Жыл бұрын
Thank you for sharing! I've been dreading doing an inventory on my computer but I'm sure your spreadsheet will be so helpful. Shoutout to Nina'sJewels for recommending your page!
@redbarnkreations3334
@redbarnkreations3334 2 жыл бұрын
Thank you so much for the new spreadsheet! I can't wait to start using it. Just wondering, when you enter the shipping weight on your spread sheet - does that include the weight of your packaging as well? I do weight my items while I list, but I use the weight of the item minus packaging. I find myself wasting a lot of time reweighting the items when it's sold so I can get the most accurate rate.
@bicole27
@bicole27 2 жыл бұрын
Hi Chris and Cathy. I would like to thank you very much for sharing this awesome spreadsheet. You two videos on how to use the spreadsheet are wonderful too!
@charlieemery7408
@charlieemery7408 Жыл бұрын
How do I convert file from view only to the version you show on video. Thank you for all you have provided
@Kristinfaber1
@Kristinfaber1 Жыл бұрын
I love using this spreadsheet! I have a question about shipping charges that are paid by the buyer. Should I include this information in the sold price of the item? Or is there somewhere else to put this information? My net profits are not correct with this missing information. How does everyone else handle shipping ? Thanks for any help in this matter.
@SharaMcBride
@SharaMcBride 10 ай бұрын
Thank you for making this spreadsheet and allowing free access to it! I was about to waste so much money on Etsy trying out different sheets. Quick question… what is the purpose of weighing the individual items prior to packing them up? For example, an item might weigh 6 ounces, but after packing the item up (a lot of my items get bubble wrap or extra padding for protection during shipping) the weight of the individual item kinda seems pointless in that scenario. I also have been trying to use consistent size boxes and mailers and whatnot, but I DO recycle a lot of packaging to save money and cut down extra waste.
@madchleo7946
@madchleo7946 9 ай бұрын
Thank you for the spreadsheet and very informative tutorial. 1 question though. How do you handle returns and refunds? Also for future reference it may be worth thinking of adding columns for taxes. In Australia businesses (from a certain turnover point) need to keep track of GST (goods and services tax) both the amounts paid in purchases and collected in sales where applicable and pay the tax office the each quarter. Also a basic profit/ loss view to provide the accountant
@FaradaysFlipper
@FaradaysFlipper 2 жыл бұрын
So I have decided to jump into the reselling business, no inventory to buy, we have got all of my husbands parents stuff from when they passed. I am trying to sell this to move from Kansas to Seattle. So with the end of the year coming, how do you end the year and begin a new year?
@jiaacice
@jiaacice 10 ай бұрын
I would love to see a section on the dashboard or at a glance to show how many new items were listed each month vs how many sold.
@kevinwharton6388
@kevinwharton6388 2 жыл бұрын
Hey Chris & Cathy, My wife and I were watching your videos and we downloaded the spreadsheet and hope to get to selling soon. Thank you for the spreadsheet. Very concise and easy. K and V.
@wastnTIMEwastnTIME
@wastnTIMEwastnTIME 2 жыл бұрын
Just what I was waiting for! Glad u guys came through with this version! You guys are awesome, Thank you!
@pamleonard6967
@pamleonard6967 4 ай бұрын
On the Active Listings Sheet- where is the price I listed on Ebay or platform? I don't' see a column. And how did you get a calendar to pop up on the dates?
@mariek.2290
@mariek.2290 Жыл бұрын
Best spreadsheet by far! thanks so much!
@charmed2284
@charmed2284 10 ай бұрын
Ok so I make gift baskets. Would I be able to use the inventory in the way of keeping inventory on the items that I put inside the baskets in addition to the baskets. Like of course if I'm selling a spa basket, a coffee basket etc that's inventory too meaning how many baskets I have in stock to sell. But, I also what to keep track of the items inside of each basket so I know when to buy more. Would the baskets go on the inventory list, as well as the actually inventory of what goes inside the baskets?
@lbfaith
@lbfaith 2 жыл бұрын
How do you enter a Kidizen Shipping Cost when the buyer pays shipping? Say an item you have listed for $7 + 4.50 shipping. Do you just put down 0.00 in the shipping cost. We know we have to purchase the label but they gave us the money to do it. will this applies to other +shipping items? And might i add a suggestion to bundles? You can always merge the items descriptions together into one row and make them one. Combine costs. That way it doesn''t really take away from the row you're not entering any info for. I was just splitting the cost amongst all items. So I had a bundle shirt and shorts listed separately. I split the fees and shipping cost by 2. IDK if that was doing something but it was my first one. But i think ill combine into one row.
@jdimas2011
@jdimas2011 2 жыл бұрын
Let me ask you as I can't get an answer from Gingermarvin: would this be a good spreadsheet for ebay sales and the cost basis accounting? I want to know b4 I enter my data. Godaddy used to give me a profit loss statement at the end of the year, which was helpful at tax time. I'm not a power seller or anything.
@deroselyn
@deroselyn 5 ай бұрын
Hi, I love your spreadsheet and am using it currently but on my dashboards nothing appears, what can I do ?
@josephchristiansen8737
@josephchristiansen8737 11 ай бұрын
Question? Excellent Spreadsheet. For Tax purposes, we cam write off inventory as it is purchased meaning but the spreadsheet only shows cost of goods for sold items and not total purchases by month? Is there away to look at this that I am not seeing?
@lindaramirez9585
@lindaramirez9585 2 жыл бұрын
I like to see the taxes the platforms take out on my behalf. Where would I place this amount and will it deduct from my Gross Sales column? Thank you so much.
@kathyk8148
@kathyk8148 2 жыл бұрын
So would I. Ebay calculates the taxes in to the total and if we don't have a way to deduct it out, won't it be considered profit?
@sunshinegypsea
@sunshinegypsea 2 жыл бұрын
Yes!!! I’m struggling with this also & I am so confused about it! 🤦‍♀️🤣
@budgetedgoods
@budgetedgoods Жыл бұрын
I just came here to say I'm doing this right now... lol how funny. I'm in putting my mercari stats and the total breakdown compared to the spreadsheet is a couple bucks off. I'm seeing mercari payout one amount then after entering the info into the spreadsheet its under the amount..... @GingerMarvin please help!!!
@danniellepeterson-ts3nb
@danniellepeterson-ts3nb Жыл бұрын
Thank you so much love this spread sheet. One problem my dashboard shows no data.. my inventory is all in there with listings and sold listings. Can’t figure out why it’s not showing on dashboards
@JerryKiesewetter
@JerryKiesewetter 10 ай бұрын
Wow! What a fantastic spreadsheet. Thanks so much for providing such valuable content. Any ideas where I should be recording sales tax collected by eBay? Should that be figured in fees? Or somewhere else? Just not sure how to handle that figure.
@GingerMarvin
@GingerMarvin 10 ай бұрын
In the US, the taxes collected by the platforms like eBay are never paid out to you. They are held by and paid for by eBay, so you don't necessarily need to track them. I'm not sure how things work outside the US, but If you would like to you can use one of the spare columns provided. Hope this helps!
@stefanieeidman1714
@stefanieeidman1714 Жыл бұрын
Thanks for sharing your spreadsheet! Quick question re: eBay sales. When you enter the Sold Price, are you including the buyer paid shipping in this field or JUST the Sold Price of the item? So for instance, I sold an item for $15 and the buyer paid $6 shipping. However, when I purchased the label on eBay, it was $5. How are you accounting for the extra $1? Thanks in advance!
@cherylsantos8791
@cherylsantos8791 Жыл бұрын
I would like to know this also. Thanks
@davienfizer3124
@davienfizer3124 Жыл бұрын
Hello, do you have a video showing your incoming inventory process? Thanks for all the great content!
@RelovedRunway
@RelovedRunway Жыл бұрын
Great video and spreadsheet thank you! I have thought of a potential way to deal with bundles. In spare column Q (after notes) I have added a checkbox to mark that the item was sold as part of a bundle. I then added "Bundle Discount" as an option for "adjustments" then I work out how much each item within the bundle had sold for on average and enter the adjustment. For example, if something is listed for £2.50 individually, I'll put that in the price sold and then add a discount of £0.90 to bring it down the average cost to £1.60 per item in the bundle. Hopefully that makes sense 😅
@meCrystalp
@meCrystalp Жыл бұрын
Great Video!....2 Question's : Can you add a line for "income Taxes" that will be owed per item, so that quarterly we can see at a glance what the total due would be (but have a quick tab added to the bottom, like you have for "active & sold listings) .... I think 11% of the total price it sold for is the amount we should approximate the tax to be... 2. Is there a way to move the numbering system down by one?... because the way it is now the #1 spot is held by "descriptions" like "purchase location, category and sourced by" etc etc .... so the actual numbers sold are technically "off" by 1 ... hopefully I explained that right.... Anyways, any help on this you can provide will be appreciated! ... Thank you again Chris, Marvin, and Ginger
@lindafeldman8587
@lindafeldman8587 2 жыл бұрын
I love this so far! Many thanks to you. I do not use bins so I am using that for adding a picture of the item. Will that mess up anything?
@strawnfam
@strawnfam Жыл бұрын
I do need to have ID numbers in that column, but I would love to have a column at the very beginning for a picture! Great idea!
@MichelleCabrera-v9j
@MichelleCabrera-v9j Жыл бұрын
I love the spreadsheet!! It has been an amazing tool for my business! I do have a question about exporting data from WhatNot. When I export the information for the items that I have purchased from WhatNot the date I purchased the items is missing, there is only a time listed but no date. Do you have any suggestions as to how I can export the dates items were purchased? Thank you in advance for your time.
@thomasschronce3992
@thomasschronce3992 Ай бұрын
Thank you I got it today.
@sandylucas4328
@sandylucas4328 Жыл бұрын
Hi, I think I will love your spreadsheet and have bought it but I can't find it in my Google Cloud or anywhere else on my pc. Do you have any suggestions? Thanks so much and, thank you for creating it and making it available for the rest of us!
@KCNewYork
@KCNewYork 10 ай бұрын
Is there a quick way to add current listings from eBay or is it all to be added manually?
@kimberlydaniels8671
@kimberlydaniels8671 Жыл бұрын
Your sheet is amazing and easy to use. I watched it for a 3rd time to refresh my memory on a few things. I am unclear on how to "unfilter". I filtered the Inventory column Item so it showed a to z order. Now I need it to go back to ascending my numbers in the first column so I can continue to add items base on their inventory number. I guess I also need clarification on how to search for an item to mark it sold. I don't think filtering is the best way
@kimberlydaniels8671
@kimberlydaniels8671 Жыл бұрын
I think I have some items figured out. I caught how you tell us to search for an item by bringing up the search bar. But I still can't get me Inventory list back to listing by Inventory number like I originally entered them. Also since the inventory is in A-Z order (which I did by filtering) i have lost the net profit column values.
@GingerMarvin
@GingerMarvin Жыл бұрын
To unfilter, you have to go back to where you selected what to show on the filter and select all again. You can also make your own filtered views so you can easily go back and fourth (Data > Filter Views > Create new filter view.) Any rearranging the rows should be done within a filtered view, the way the formulas work, if the formula in row 2 is moved, it breaks all the formulas in that column. You may need to reference a fresh copy to see the formula that should be in the cells in row 2. Basically row 2 needs to always be in row 2. I hope this all helps!
@kimberlydaniels8671
@kimberlydaniels8671 Жыл бұрын
@@GingerMarvin Ok thank you! I decided to try to copy paste a few test rows into an empty copy of copy of your sheet. How do I put the first column in sequential order and have it take the rest of the row with it?
@brianp3882
@brianp3882 Жыл бұрын
Great video... but how do you record a return? I just had one and I need to update it on my spreadsheet.
@azcatz-sue
@azcatz-sue 2 жыл бұрын
I'm excited to get started with this. I've been SO bad at tracking, but I'm pretty new with only 58 sales.
@E-TX7791
@E-TX7791 2 жыл бұрын
So amazing. Every time I wondered if you considered something you would show how you did. For 3.0. 1. Can you consider tracking days item is on spreadsheet but not listed? 2. Add a seasonal column to have an idea of what inventory is for future season. 3. Add a who entered on spreadsheet. 4. Add a timesheet page. 5. Add an expense page for home use cost. User enters percentage of house used. Then we can enter utility bills, cell cost etc for income tax. Where would you track sales tax expense?
@lbfaith
@lbfaith 2 жыл бұрын
can you elaborate on 4, timesheet page? Timing for which specific?
@E-TX7791
@E-TX7791 2 жыл бұрын
@@lbfaith time sheets for any employees working to keep track of expenses on employees
@billisherenc
@billisherenc 2 жыл бұрын
I got your spreadsheet and love it. Also, I hope everyone does watch these videos because I thought the weight defaulted to pounds, now I know it is in ounces and then you said pounds, a little confused. Looking forward to more great things from you in the future!
@tammyschindewolf8455
@tammyschindewolf8455 Жыл бұрын
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? I like to have my goods separate with different tracking codes. My purpose is when I'm looking for an item I don't want to have to scan through a mix of items so find something so I like to keep separate categories. I appreciate any help you can offer Thank you
@GingerMarvin
@GingerMarvin Жыл бұрын
One way you can do this is to create filtered views that show your data based on the category you have them under. Then once you have filtered it down you can press Ctrl+F to search the page for the item. Hope this helps!
@tammyschindewolf8455
@tammyschindewolf8455 Жыл бұрын
@@GingerMarvin ok thx I’ll try that. So I shouldn’t create another page tab ? Was just wonder if that would interstate the numbers or not. Sorry not to savvy with this spreadsheet stuff lol thx for the reply
@ChasityNic1
@ChasityNic1 Жыл бұрын
Do you include tax when you input Sold Price on the inventory slide or only the actual sold price less tax? Column V
@cherylsantos8791
@cherylsantos8791 Жыл бұрын
I would like to know the answer to this question. Tks
@marciemadmac6237
@marciemadmac6237 2 жыл бұрын
I'm trying the spreadsheet and was wondering if the taxes that ebay charges is included in the fee column or is it necessary to include taxes. Thank you for what ya'll do, I'm learning alot. Also can I copy from my ebay reports into this spreadsheet.
@mark-ihle
@mark-ihle 11 ай бұрын
Could you please share the resolution you implemented to address the issue of sales tax collection by eBay? I am currently encountering a similar challenge and would greatly appreciate insight.
@cathylacy956
@cathylacy956 Жыл бұрын
Can i download pictures of MY inventory items and also download receipts from your purchases and store them in the spreadsheet on a line item?
@cheryllafountain9255
@cheryllafountain9255 4 ай бұрын
Great spreasheet! Just started using this past week to check it out. My only issue is my totals dont equal to ebays totals. For instance i sold something for 12.79, 2.09 fees and 4.43 shipping, ebay says i made 5.86, but according to the spreadsheet i made 4.71? The difference is double the tax? Not sure what im supposed to put in these columns to equate what ebay states. Any help would be great 😊
@aidalucero8918
@aidalucero8918 Жыл бұрын
Great worksheet! We appreciate you! I do have a question, I added cells to the Shipping Provider dropdown list but what I added doesn't show up when I drop down the cell for the item. Any idea what it could be?
@alenpapic274
@alenpapic274 11 ай бұрын
This is useful for someone that has 15 items for sale. How about an video on how to upload an entire ebay inventory of 170+ listings. Can't find one video on this.
@beady-eye_69
@beady-eye_69 2 жыл бұрын
Great vids, and good job on the improvements! One thing you could have mentioned in the last section (regarding copying current data over) is copying over the data from the Dropdown Menus. I know spreadsheets, so it was simple for me. Once I did that, all the "INVALID" notices on my Inventory tab went away. 😉
@allaboutyouaz6634
@allaboutyouaz6634 2 жыл бұрын
I have a question hope it's not a dumb one. I have a hard time seeing... is there any way to make the slide bar on the bottom darker?
@robincoote7662
@robincoote7662 2 жыл бұрын
Great spreadsheet but I keep getting errors. It seems as though when I customize my dropdown menu it takes away my dropdown ability in the active listings tab
@macvolkful
@macvolkful Жыл бұрын
Hi I just download this and it wow is it great! Would it cause a problem if I added another column for the Custom Label, we use that field for our 2nd identifier. Thanks for everything!
@mattmaring4080
@mattmaring4080 Жыл бұрын
How do you recognize COGS for items picked up at the same yard sale. Say you source 10 items at a yard sale for $120...do you enter your COGS for each item as $12 or are you trying to remember what you actually paid for each item?
@jodipinnell7589
@jodipinnell7589 11 ай бұрын
Wondering the same thing
@robynporteen4983
@robynporteen4983 11 ай бұрын
Is there a good way to transfer spreadsheets from other platforms? Mine is in Numbers (Mac) and I want to start 2024 fresh with your spreadsheeet but need to move all my inventory over
@sofiagreppi7785
@sofiagreppi7785 Жыл бұрын
Hi, thank you for the spreadsheet! How can I change the currency?
@PatrykMagnucki
@PatrykMagnucki 9 ай бұрын
Is there a way to add multiple units of certain items? I often buy i.e. 200 units of same item and need to list every unit in a separate line in order to get the correct unit.
@GingerMarvin
@GingerMarvin 9 ай бұрын
The way this sheet works you would want an individual inventory line for each item, even if they are the exact same thing, as the sold info is tracked per line item. That way when items sell on different days, on different platforms, and/or for different amounts, that sale data can all be recorded correctly.
@cayladanna1981
@cayladanna1981 3 ай бұрын
For an Ebay sale are you adding the shipping charge to the sale price? For example: Say I sold something for $25 and charged $6 for shipping. So I would have to put $31 in the "Sold Price" column? Is there another way I can do this if I want the sale price and what I charged for shipping to be shown separately?
@GingerMarvin
@GingerMarvin 3 ай бұрын
Yes, add what eBay pays out to you, you can see that in the transaction page of eBay. The sheet will calculate the profit when you fill out all the other numbers like shipping. Hope this helps!
@bicole27
@bicole27 11 ай бұрын
Hi Chris, How do you go from this years spreadsheet to the next year? Do you keep the old sales in the spreadsheet or delete them or something else?
@GingerMarvin
@GingerMarvin 11 ай бұрын
We have a video from last year on how to change over to a new sheet. We recommend copying any unsold inventory over to a new fresh sheet, then saving the old sheet so you can have it as a historical reference.
@adlaneproductions2295
@adlaneproductions2295 2 жыл бұрын
Thanks so much for this! Can you start off by just entering inventory that actually sold? I have about 900 items in my Ebay store and it would take quite a while to input everything. Thanks!
@Rock_Bill_Kaa
@Rock_Bill_Kaa 2 жыл бұрын
Can you import your ebay listings to get a head start?
@kellyfalk1790
@kellyfalk1790 2 жыл бұрын
Thanks for providing this. I am getting ready to start from scratch. Is it possible to easily upload or copy and paste inventory from the excel spreadsheet provided by Poshmark?
@LMicheleS
@LMicheleS 2 жыл бұрын
I can't wait to start playing around with this new version of the spreadsheet. Is there any way to import my unsold, but listed items, from the old sheet into this new sheet?
@maroman131
@maroman131 Жыл бұрын
My question after reviewing your video is how do you account for and handle returns (ebay) on the spreadsheet? This seems great. I'm looking to change over. Currently using a SS from another reseller and it is on excel and I have had many issues. Thanks for all your hard work, Chris.
@GingerMarvin
@GingerMarvin Жыл бұрын
We actually don't accept returns on eBay, so we personally handle them by adding the numbers in the "Adjustment" column, then at the end of the year we compare our numbers with the numbers we get from eBay. Hope this helps!
@sunshinegypsea
@sunshinegypsea 2 жыл бұрын
On date listed, if you listed an item on 2 platforms on different days, does it matter which date you enter?
@flightattendantflipper6916
@flightattendantflipper6916 2 жыл бұрын
hello. I've been using the reseller spreadsheet, but every time I try to use the sort option on any of the calculated columns on the right, I end up getting a red triangle on my first listing that says "result was not automatically expanded" . (i am able to sort all columns on the left). I don't understand how to fix this. Thank you so much for this🥰
@GingerMarvin
@GingerMarvin 2 жыл бұрын
You can't re sort the main inventory page as the formulas do get messed up. But you can use a Filtered View to organize it how you prefer. To fix, you may need to revert back to the last working version in your "Version History" Hope that clears it up for you!
@DandyBeingTandi
@DandyBeingTandi Жыл бұрын
Starting this today, I'm a little nervous! But thank you so much!
@AKContreras1
@AKContreras1 Жыл бұрын
Thanks for the info! When I make a copy of the original one it still has all of my info. How do I get a blank one?
@thriftinlindsey
@thriftinlindsey Жыл бұрын
i love love love the spreadsheet and used it for all of 2022 and now this year as well! i can't say enough about it! the problem i've recently started running into the last month or two with the spreadsheet is that it's becoming SUPER laggy when trying to CMD + F for an item, or just loading stuff in general is slow (my guess is because i have 590 line items) i've tried filtering so just the available inventory shows on the inventory tab, thinking that would make it load faster, but it's still going at snail pace lol. is there anyway to curb this??? i thought about copying it over to a different sheet, but figured that wouldn't solve anything. thank you!!
@thriftinlindsey
@thriftinlindsey 11 ай бұрын
literally just figured out that for some reason it added 50k blank rows at the end of my spreadsheet...which is why it made it super laggy! omg! no wonder LOL
@EatPlayLoveCO
@EatPlayLoveCO Жыл бұрын
Do you use average cost of goods from a sourcing trip or actual cost of goods. Bins obviously average, but curious how you track COG. Thanks!
@nickk4010
@nickk4010 Жыл бұрын
So amazing! Thanks so much for this! - Can you help me with a question if you have time, please? - I entered in my sales from January 1st, 2023 through today January 16th 2023. I have an existing inventory and want to keep things as clean as possible. Should I just add my sales into inventory when they sell, instead of all the inventory that I purchased from years past before it sells? Kind of hard to add all 200-300 things of inventory, I'm thinking I can just enter when I sell, I have the record of dates and cost of purchase. And if I should enter in new inventory I purchase this year as I buy it? Do you think that is a good idea? Sorry for the long-winded question, I already owe you a coffee at the very least and will owe you a few more 😂Thanks again!!!
@bakes5745
@bakes5745 2 жыл бұрын
Thanks for the video and the spreadsheet! I am just starting and this will be a great help!
@pennyluck9696
@pennyluck9696 2 жыл бұрын
Great video and spreadsheet! I've been using it since the first of the month but when I click on 'dashboard monthly' or 'dashboard weekly' there's nothing there?! The blocks all say No Data, am I doing something wrong???
@KaylaClayton-u8f
@KaylaClayton-u8f Жыл бұрын
I don't see a spot for taxes. Since we pay fees on taxes and it's included in the total, where would we enter this?
@rickc2222
@rickc2222 8 ай бұрын
If I delete the "sourced by" and "special designation" columns, will it mess up any other data? if not i can just make them black and skinny as possible
Intro to all the NEW Features of the Reseller Spreadsheet 2.0!
15:44
Can I deduct my inventory when I purchase it??
14:47
Not Your Dad's CPA
Рет қаралды 46 М.
How Strong Is Tape?
00:24
Stokes Twins
Рет қаралды 43 МЛН
Simple & free Inventory Tracking Spreadsheet by Not Your Dad's CPA
7:30
Not Your Dad's CPA
Рет қаралды 16 М.
How to get your Spreadsheet ready for 2023! Copy unsold Inventory!
15:43
Everything Resellers Need to Know About Taxes and Bookkeeping
26:32
Daily Refinement
Рет қаралды 31 М.
Webinar - Analyse Portfolio Performance
59:20
UniPhi Software
Рет қаралды 89
The Power of Being a Small eBay Seller
10:02
Daily Refinement
Рет қаралды 115 М.