Thank you so much! As a hobby seller of less than $1k monthly, i haven't been tracking my numbers on 3 platforms, so now I'm scrambling to go back to January! What a pain!
Thank you so much for these resources. This is my first year as a reseller and I have been using the spreadsheet to keep track of my inventory. I am wondering how to account for my existing inventory, purchased in 2023, when I start my 2024 spreadsheet? Do I have to copy it over line by line?
Wow, I've downloaded a couple of Excel spreadsheets now to help me track my numbers before they get out of control. I feed your spreadsheet has the most detail.
I love this spreadsheet and have been using it for years. I have a question though. My version is an older one and doesn't have the refund page or tab. Can I add it to my existing spreadsheet?
Hey have both of your programs. I had a quick question what happens if you put down starting and ending inventory balance but you use the cash method. I put down a little amount but Id like to correct it for the next year
Some people said when they use cash accting, they’ve been putting 0 on both, but idk how it works if you’ve already put numbers down the first yr, cuz I always wondered the same
Is it possible to add multiple units of certain items? I am often buying i.e. 200 units of same item which makes me create a new line for each item to get the correct data
Thx for the videos. Do you have COGS videos for food entrepreneurs like caterers and how they can track inventory in Excel? How do these small businesses calculated and answer questions 33-42 on Part III of IRS form 1040?
So, is it true as a Sole Proprietor, I can add my cost of goods in the Materials & Supplies section of a Schedule C (Calif.) And if so, how do I buy past the Inventory beginning/ending of year on the online Schedule C or is that even possible? Thank you for your informative videos. 😺👍
thank you for your informative videos. do i need to prove my COGS with receipts? some times garage sales do not provide receipts. what should be done in this instance?
I have a question if anyone has an answer: I have updated the "year" in my sreadsheet to 2025. I see where my beginning inventor on the inventory summary page was the last amount from 2024 and also I see the 2 sales I made so far in 2025 appear on the "summary" page; however, on the "summary" page it is still showing 2024's expenses. Is there anyway to have those not appear so only 2025 expenses show up? I love this spreadsheet! It's been a game changer for me. Thank you for providing it!
Thank you SOOO much! And for the spreadsheets. It can feel so overwhelming and I will probably use your services down the line when I grow bigger! Lord willing! haha.
Hi. I start using your spreadsheet and I love it. I was just wandering if I may be able to add a Tab to it (ex. to record Miles). Also I have a second question, I recorded several item I pickup from my personal stuff. I do not have receipts so I kind of put a purchase price to the item. I have heard other people saying to put zero ($0.00) for the item because I do not have the receipt to prove the purchase of the item. It is correct to make up a purchase price? Thank you very much.
You can definitely add a tab or customize it! As far as adding personal items, I recommend adding the original cost, or at least your best estimate of it. I wouldn't let not having the receipt stop you from taking the deduction. Check out my video on personal items for more detail.
Love the looks of this spreadsheet! But how best to handle if 50% of your purchases are bulk purchases- such as bluebox jewlery boxes, jewlery jars, etc. Which can have hundreds of items, and the rest of your inventory purchases are smaller quantities of different items such as clothing or hard goods? I'd love to do individual but hundreds of different postcards or jewlery pieces? I'm not sure what to do?
In that case I would recommend an average cost tracking system rather than individual. I have a spreadsheet for that you can get using the same link, and that I will put up a walk through for soon!
@@notyourdadscpaI’m watching your old videos and it’s legendary. Did you ever made a video on the average cost method spreadsheet? Tryna look through them right now.
Is there any way that this spreadsheet could support multiple quantities of an item? Also, I can not sort the Item Description alphabetically on the Inventory Detail worksheet. I keep getting an error message: "To do this, all the merged cells need to be the same size."
Nice sheet, but have one question. Let's say I am using it for 2023, then when adding expenses for 2023 it works fine. But when I move over to 2024, the 2023 expenses are shown in 2024, why is 2023 shown in 2024?
I really like the spreadsheet! One question I have is if a buyer pays shipping what column would you list that in, or should I create a column to track that?
It really depends how you want to be able to see it. From a pure accounting standpoint buyer shipping is recorded as part of the overall income, or sometimes people break it out separately as shipping income. The key is to be consistent.
Doubt if you will see this question, but thought I would try. How do you handle returns being relisted? Do you keep all the sales info from the original line, then add a new line for the item to sell, but note it as a $0 COG? Do you just readjust the original line for the item. Can you explain exactly how you would go about this? Thanks
Is it required to keep track of transaction fees and shipping costs in a spreadsheet? Since eBay and Pirate Ship already tracks that. I’m trying to keep my bookkeepng as minimal as possible since I get a lot of sales and I feel like it’s a lot of work to individually keep track of all of that for each item. I keep track of COGS, date sold, item description, when and where I purchased item. Thank you!
Any thoughts on how to go about dealing with damaged inventory? Let’s say I purchased an item for $10 and didn’t inspect it well. Once I determine the item is not sellable, couldn’t I write it off as a loss? If so, would it count as an expense? I have a very similar spreadsheet but have not found a good way to track items in this scenario. Thank you!
Absolutely, in this case you would just treat it as if you sold it for $0. So you would still put it on the spreadsheet and record the same costs for the cost of goods sold, and the sales price would be zero.
one question on your spreadsheet. When you calculate COGS (averaging) from feb on are you using a cumulative number or calculating it based on that months inventory purchased COGS?
Just an FYI I downloaded the spreadsheet but when you go to the summary tab by default it's rounding up your total. In my example, the first item I input under "item profit" was $24.50 on the inventory detail tab but was showing $25 in the summary tab. You might want to update the spreadsheet as this would definitely give you false numbers once multiple items are added.
Hi, I used this in 2023 and am hoping to use it again in 2024. With my existing inventory do I need to copy it over line by line in my 2024 spreadsheet?
Any sales tax you pay as part of the purchase of the inventory or shipping you pay to purchase the inventory would typically be included as part of the overall cost of goods sold.
Good morning, I am enjoying all your courses and can't wait to dig into this new spreadsheet! My question is related to reporting LLC income, I would like to retire from my W2 corporate position and I am 63. Understanding that there is a threshold of approx 20k that I can earn without losing part of my SS payments. If I have an LLC am I required to report all income from my business, or only the owner draws? I know I need to do more research, but would like your insights please. Thank you for all you do!
So say you purchase an item (raw stock), which you then cut to customer specified lengths then sell. This means there are multiple sales per single purchase.. right? (The best way I've determined to keep track is with an additional step or steps. Which converts to item cost to item cost per inch. The sale price is based on the length of the item (this accumulates each sale). The total length sold gets compared to total length purchased and outputs the difference. It's a little more involved than that. Would it be realistic to add that functionality? I'm no accountant, but I practice the art of keeping track stuff. Your spreadsheet is very compelling. Great work, Thanks for sharing!
Manufactured goods is a whole different animal, and you are on the right track. There are entire accounting classes about how to allocate production costs to a unit of inventory 🤢 But I wouldn't over think it. It sounds like you are thinking about it the right way, so then the key is consistency.
if you use inventory, you have assets until you sell. Do you have to pay any taxes on assets if it carries over to the next year? is there any disadvantage to doing the inventory method (besides the burden of keeping track of everything)? Ps thanks for your channel and the spreadsheet..i am going to look at it now.
You don't pay taxes directly for inventory that carries over, it just means you don't deduct it in the current year and will deduct it in the future year when it sells. No real disadvantages other than tracking in my view, if you have a good system for tracking I think it yields better insights to do it that way.
Really like the spreadsheet but I noticed that my expenses for all years show up on the summery page regardless of what date you set on the inventory details page. Is this intentional for some reason?
What a great spreadsheet! Is there a different way to record personal collection items you have had for a long time and decide to sell, but you don't have any idea what to put for cost of goods? I have heard some people say the cost of those items is what they're worth today (does that mean the price I sold them at?)
This video may be helpful: ua-cam.com/video/nho3sK-pY0I/v-deo.html You'll either use the original cost OR your best estimate of the wholesale market value if it's lower.
It's mainly just for the inventory piece, so you can use it in conjunction with a program like QuickBooks or maybe a simpler bookkeeping program as well. However if you are using the profit and loss tab then it could be most of what is needed for the business portion of your tax return.
What do you do for cost of goods sold when you sell something like personal clothing or collectables you purchased years ago and downsizing personal items? How do you determine a cost?
Thanks for providing these spreadsheets. I use them every year and they are great. I'm also a part of your Reseller Tax Academy. How long does it take for the spreadsheet link email to arrive after signing up? It says the link to the spreadsheets are coming my way, but I haven't seen anything since I signed up several days ago. I've tried several times. Checked my spam and trash folders too. Thanks so much!
You can deduct the business portion if you have a business that's reported on Schedule C. If your accountant doesn't break it up separately you may have to just estimate what percentage it makes up of the total return and deduct that percent.
As I understand it small businesses with less than $26 million in average gross receipts for the 3 prior tax years can treat the inventory as non-incidental materials and supplies and use the cash method of accounting. This is preferable from a tax perspective as it pulls forward expenses. This is also way simpler since it doesn't require inventorying every single item you purchase for resale. Obviously, you need to have some managerial accounting around the profitability of the items you are selling but why would you ever choose the headache of accrual accounting? If you are reselling a collection of stuff that you have acquired over a period of many years you would be better off treating this as a capital gain, because tax rates on capital are lower than those on labor (gee isn't capitalism great), and subtracting your cost as your basis. Is there something that I am missing?
If the stuff you've been holding was personal then I think that it becomes business inventory at the point at which you listed for sale. Check out my video on personal items, and also check out this video for all the detail on the inventory method: ua-cam.com/video/DqAy_0eb1Wk/v-deo.html
That was my side point. My main point was that if you are picking up items to resell you would never opt for accrual accounting until you were forced to at $26 million in revenue per year. Are you a reseller?@@notyourdadscpa
I'm just about to complete my first year of reselling, I didn't do a good job tracking inventory this last year, How will the inventory that I had left at the end of the year factor into this years taxes? @notyourdad'scpa
Thank you so much! As a hobby seller of less than $1k monthly, i haven't been tracking my numbers on 3 platforms, so now I'm scrambling to go back to January! What a pain!
Thank you so much for these resources. This is my first year as a reseller and I have been using the spreadsheet to keep track of my inventory. I am wondering how to account for my existing inventory, purchased in 2023, when I start my 2024 spreadsheet? Do I have to copy it over line by line?
Going to use this sheet for 2024 and beyond!! Thank you!!
I’m so glad I found your channel, so much important information. Thank you so much!!
Wow, I've downloaded a couple of Excel spreadsheets now to help me track my numbers before they get out of control. I feed your spreadsheet has the most detail.
I love this spreadsheet and have been using it for years. I have a question though. My version is an older one and doesn't have the refund page or tab. Can I add it to my existing spreadsheet?
Hey have both of your programs. I had a quick question what happens if you put down starting and ending inventory balance but you use the cash method. I put down a little amount but Id like to correct it for the next year
Ive seen this question else where unanswered aswell
Some people said when they use cash accting, they’ve been putting 0 on both, but idk how it works if you’ve already put numbers down the first yr, cuz I always wondered the same
Following @@lilubelle3455
Is it possible to add multiple units of certain items? I am often buying i.e. 200 units of same item which makes me create a new line for each item to get the correct data
Thx for the videos. Do you have COGS videos for food entrepreneurs like caterers and how they can track inventory in Excel? How do these small businesses calculated and answer questions 33-42 on Part III of IRS form 1040?
Is there an acceptable method in the eyes of the IRS to estimate your ending inventory every year?
So, is it true as a Sole Proprietor, I can add my cost of goods in the Materials & Supplies section of a Schedule C (Calif.) And if so, how do I buy past the Inventory beginning/ending of year on the online Schedule C or is that even possible? Thank you for your informative videos. 😺👍
thank you for your informative videos. do i need to prove my COGS with receipts? some times garage sales do not provide receipts. what should be done in this instance?
What about tracking the taxes you pd on your items you intend to sell? I know there is some type of refund you get or something for “tax pd @ source”
Thank you! Can I put zero for purchase price and add inventory as an expense? The purchase price for my skus changes regularly.
I have a question if anyone has an answer: I have updated the "year" in my sreadsheet to 2025. I see where my beginning inventor on the inventory summary page was the last amount from 2024 and also I see the 2 sales I made so far in 2025 appear on the "summary" page; however, on the "summary" page it is still showing 2024's expenses. Is there anyway to have those not appear so only 2025 expenses show up? I love this spreadsheet! It's been a game changer for me. Thank you for providing it!
I verified my email address, how long will it take for the spreadsheet link to be sent?
You are a king! And great intro music 😝
I'm working with your spreadsheet. You have it set up so that shipping is deducted from the profit. What if you charge shipping?
What if you sell multiples of the same item? How would I add that into the spreadsheet?
Thank you SOOO much! And for the spreadsheets. It can feel so overwhelming and I will probably use your services down the line when I grow bigger! Lord willing! haha.
Hi. I start using your spreadsheet and I love it. I was just wandering if I may be able to add a Tab to it (ex. to record Miles). Also I have a second question, I recorded several item I pickup from my personal stuff. I do not have receipts so I kind of put a purchase price to the item. I have heard other people saying to put zero ($0.00) for the item because I do not have the receipt to prove the purchase of the item. It is correct to make up a purchase price? Thank you very much.
I have this exact same question!
You can definitely add a tab or customize it! As far as adding personal items, I recommend adding the original cost, or at least your best estimate of it. I wouldn't let not having the receipt stop you from taking the deduction. Check out my video on personal items for more detail.
Love the looks of this spreadsheet! But how best to handle if 50% of your purchases are bulk purchases- such as bluebox jewlery boxes, jewlery jars, etc. Which can have hundreds of items, and the rest of your inventory purchases are smaller quantities of different items such as clothing or hard goods? I'd love to do individual but hundreds of different postcards or jewlery pieces? I'm not sure what to do?
In that case I would recommend an average cost tracking system rather than individual. I have a spreadsheet for that you can get using the same link, and that I will put up a walk through for soon!
@@notyourdadscpa Awesome! Can't wait to watch. 😀
@@notyourdadscpaI’m watching your old videos and it’s legendary.
Did you ever made a video on the average cost method spreadsheet? Tryna look through them right now.
Is there any way that this spreadsheet could support multiple quantities of an item? Also, I can not sort the Item Description alphabetically on the Inventory Detail worksheet. I keep getting an error message: "To do this, all the merged cells need to be the same size."
Nice sheet, but have one question. Let's say I am using it for 2023, then when adding expenses for 2023 it works fine. But when I move over to 2024, the 2023 expenses are shown in 2024, why is 2023 shown in 2024?
I really like the spreadsheet! One question I have is if a buyer pays shipping what column would you list that in, or should I create a column to track that?
It really depends how you want to be able to see it. From a pure accounting standpoint buyer shipping is recorded as part of the overall income, or sometimes people break it out separately as shipping income. The key is to be consistent.
Doubt if you will see this question, but thought I would try. How do you handle returns being relisted? Do you keep all the sales info from the original line, then add a new line for the item to sell, but note it as a $0 COG? Do you just readjust the original line for the item. Can you explain exactly how you would go about this? Thanks
I haven't had a chance to look at it yet but can I also add a small picture of the item to the line as well?
Google sheets does have that functionality yes 👍🏼
Is it required to keep track of transaction fees and shipping costs in a spreadsheet? Since eBay and Pirate Ship already tracks that. I’m trying to keep my bookkeepng as minimal as possible since I get a lot of sales and I feel like it’s a lot of work to individually keep track of all of that for each item.
I keep track of COGS, date sold, item description, when and where I purchased item.
Thank you!
Thanks, your awesome! Hope to use this starting next year!
Is the beginning inventory a total of everything I have listed? Also, what about fees from the platform for selling or is that under expenses? Thanks.
Any thoughts on how to go about dealing with damaged inventory? Let’s say I purchased an item for $10 and didn’t inspect it well. Once I determine the item is not sellable, couldn’t I write it off as a loss? If so, would it count as an expense? I have a very similar spreadsheet but have not found a good way to track items in this scenario. Thank you!
Absolutely, in this case you would just treat it as if you sold it for $0. So you would still put it on the spreadsheet and record the same costs for the cost of goods sold, and the sales price would be zero.
one question on your spreadsheet. When you calculate COGS (averaging) from feb on are you using a cumulative number or calculating it based on that months inventory purchased COGS?
Just an FYI I downloaded the spreadsheet but when you go to the summary tab by default it's rounding up your total. In my example, the first item I input under "item profit" was $24.50 on the inventory detail tab but was showing $25 in the summary tab. You might want to update the spreadsheet as this would definitely give you false numbers once multiple items are added.
i think thats meant to be that way. thats standard accounting. I just did my taxes and they round up any $ amount if its .50 or more I believe.
Hi, I used this in 2023 and am hoping to use it again in 2024. With my existing inventory do I need to copy it over line by line in my 2024 spreadsheet?
You don't need to copy it over line by line, all you have to do is change the date on the main tab.
@@notyourdadscpahow do I do this for the multiple selling platforms spreadsheet?
Hi Mark - thanks for making these! Is your multi platform spreadsheet also updated like his one?
Thanks for this! When tracking the cogs, should we include tax and shipping in the total purchase price?
Any sales tax you pay as part of the purchase of the inventory or shipping you pay to purchase the inventory would typically be included as part of the overall cost of goods sold.
@@notyourdadscpa thanks again!
I sell on multiple platforms. Would i need to annotate which platform something sold on or does that not matter?
Good morning, I am enjoying all your courses and can't wait to dig into this new spreadsheet! My question is related to reporting LLC income, I would like to retire from my W2 corporate position and I am 63. Understanding that there is a threshold of approx 20k that I can earn without losing part of my SS payments. If I have an LLC am I required to report all income from my business, or only the owner draws? I know I need to do more research, but would like your insights please. Thank you for all you do!
Where is spreadsheet link i didn't get it on my email
It may have landed in your Spam box. Please email us at support@notyourdadscpa.com if you still haven't received it.
I've put in my email a few different times using different emails but I am still not receiving the link.
Please email us at support@notyourdadscpa.com
I subscribed and confirmed my email but did not get the link for the spreadsheet download. Any help would be appreciated
This may have landed in your Spam box. Please email us at support@notyourdadscpa.com if you still haven't received it.
So say you purchase an item (raw stock), which you then cut to customer specified lengths then sell. This means there are multiple sales per single purchase.. right? (The best way I've determined to keep track is with an additional step or steps. Which converts to item cost to item cost per inch. The sale price is based on the length of the item (this accumulates each sale). The total length sold gets compared to total length purchased and outputs the difference. It's a little more involved than that.
Would it be realistic to add that functionality?
I'm no accountant, but I practice the art of keeping track stuff. Your spreadsheet is very compelling. Great work, Thanks for sharing!
Manufactured goods is a whole different animal, and you are on the right track. There are entire accounting classes about how to allocate production costs to a unit of inventory 🤢 But I wouldn't over think it. It sounds like you are thinking about it the right way, so then the key is consistency.
if you use inventory, you have assets until you sell. Do you have to pay any taxes on assets if it carries over to the next year? is there any disadvantage to doing the inventory method (besides the burden of keeping track of everything)? Ps thanks for your channel and the spreadsheet..i am going to look at it now.
You don't pay taxes directly for inventory that carries over, it just means you don't deduct it in the current year and will deduct it in the future year when it sells. No real disadvantages other than tracking in my view, if you have a good system for tracking I think it yields better insights to do it that way.
Really like the spreadsheet but I noticed that my expenses for all years show up on the summery page regardless of what date you set on the inventory details page. Is this intentional for some reason?
Yes, if you use the expenses tab those only apply to the current year.
Hey I tried for a couple days to get the spreadsheet but I have not got an email to download it yet
Ty much. Hoping for multiple items for same sku.
How would track cog if there isn't a cost. I have a bottle collection left to the wife and trying to get it listed.
Zero
ok if i had inventory from years past but dont know cost or even my starting cost of inventory how do i calculate?
Youd just have to make your best estimate in that case.
What a great spreadsheet! Is there a different way to record personal collection items you have had for a long time and decide to sell, but you don't have any idea what to put for cost of goods? I have heard some people say the cost of those items is what they're worth today (does that mean the price I sold them at?)
This is my problem. I'm mainly selling items gifted to me for resell from my family members attic (items from 1960!). Not sure what to put.
This video may be helpful: ua-cam.com/video/nho3sK-pY0I/v-deo.html
You'll either use the original cost OR your best estimate of the wholesale market value if it's lower.
@@notyourdadscpaWould you adjust the original cost from the 1960s to 2023 dollars?
If I use this spreadsheet, do I need quickbooks? Could I just print out theSummary and hand it to a CPA come tax time?
It's mainly just for the inventory piece, so you can use it in conjunction with a program like QuickBooks or maybe a simpler bookkeeping program as well. However if you are using the profit and loss tab then it could be most of what is needed for the business portion of your tax return.
Would inventory lab track the same information accurately?
Yes for Amazon activity 👍🏻
What do you do for cost of goods sold when you sell something like personal clothing or collectables you purchased years ago and downsizing personal items? How do you determine a cost?
I think this video will help answer that: ua-cam.com/video/nho3sK-pY0I/v-deo.html
Can you change the date format and currency?
Definitely
Do I need to keep receipts for all purchases?
Sometimes it's not their feasible but in theory you should have some type of substantiation for each transaction
Even if you are purchasing from yard sales? I've never been given a receipt
Thanks for providing these spreadsheets. I use them every year and they are great. I'm also a part of your Reseller Tax Academy. How long does it take for the spreadsheet link email to arrive after signing up? It says the link to the spreadsheets are coming my way, but I haven't seen anything since I signed up several days ago. I've tried several times. Checked my spam and trash folders too. Thanks so much!
Sometimes it goes to spam, but shoot me an email if you haven't received it!
if I hire a CPA to do my taxes - how much can I write off ?
You can deduct the business portion if you have a business that's reported on Schedule C. If your accountant doesn't break it up separately you may have to just estimate what percentage it makes up of the total return and deduct that percent.
Thank you so much!
As I understand it small businesses with less than $26 million in average gross receipts for the 3 prior tax years can treat the inventory as non-incidental materials and supplies and use the cash method of accounting. This is preferable from a tax perspective as it pulls forward expenses. This is also way simpler since it doesn't require inventorying every single item you purchase for resale. Obviously, you need to have some managerial accounting around the profitability of the items you are selling but why would you ever choose the headache of accrual accounting? If you are reselling a collection of stuff that you have acquired over a period of many years you would be better off treating this as a capital gain, because tax rates on capital are lower than those on labor (gee isn't capitalism great), and subtracting your cost as your basis. Is there something that I am missing?
If the stuff you've been holding was personal then I think that it becomes business inventory at the point at which you listed for sale. Check out my video on personal items, and also check out this video for all the detail on the inventory method: ua-cam.com/video/DqAy_0eb1Wk/v-deo.html
That was my side point. My main point was that if you are picking up items to resell you would never opt for accrual accounting until you were forced to at $26 million in revenue per year. Are you a reseller?@@notyourdadscpa
Hello!! 😁
Having the same issue with the link…
UPDATE - Links just received via email. Thanks!
I'm just about to complete my first year of reselling, I didn't do a good job tracking inventory this last year, How will the inventory that I had left at the end of the year factor into this years taxes? @notyourdad'scpa
Same. I just figured that had to report the total of what I spent and the total of what I earned and I would be taxed on the difference.
Thank you so much!