This is great info to share, Laura! I'm needing to learn how to do an easy spreadsheet for income/expense report on an investment property and I think just by watching this, I might be able to develop one! Thanks for the tips and demo!
Omg so helpful. Trying to be better with my loss/profit this year and this is everything. Thank you instantly subscribe and excited to make me one. Eekkk thank you thank you❤
Nice.. I will try this because its nice and simple. I needed to learn how to do a spreadsheet. I need this for my natural health and beauty business. Thanks!
not an excel whiz either lol but instead of clicking each cell and the plus sign, you can do =SUM(__:__) so in the example, it would be =SUM(D3:G3). you can also just click and highlight the cells you want to add up.
Quick question, where you have item shipping cost (that's what the customer pays so that you can ship their item) $5.95, so if you shipped it for $5. Wouldn't your formula be Vinyl cost+Item cost+ Item shipping cost - did I ship it? So $0+$4.26+$5.95-$5=Total?
Very helpful thank you. If you find a better system please make a new video. this is the best system for my needs so far. althought when i am bigger not sure if theres a better way to capture this info. Thanks Laura xoxo
Awesome Resource! Thank you so much. I do have a couple of questions I may answer myself as I bounce off. Here I go: First, say you have to resend and order because it was wrong. You will have new cost for item and shipping. How do you calculate that in the your excel? And most important how are you calculating taxes and would that not be included in this spreadsheet? To get a total of it at end of month as you did the sale price? I thank you for your response. I just don't know how to go about the taxes and how to keep track of what I am accountable to the IRS. Any guidance with that would be much appreciate.
How do you calculate tax sales for people that sells in fair craft when selling on cash. How to do that to avoid complicating the handle the cash change. Example: 1 item price is $20, then it will be 20x7.75(tax sale) in California? So, I want the items price to be $1, $5, $10, $15, $20, $25, $30 to make easier to do the changes. If I add the tax sales, then it will be complicate for the changes. if item is $20
Why is there two shipping charges is one what you paid to have the shirts shipped and also what is the item cost is that what you payed for the shirt or is that what they payed you and also i just bought some vinyl from amazon it was like 20 for so many sheets I would just put the cost of one sheet if that's all i use but how would i figure out the cost of one or two sheets also I am just trying to start a business how do you add taxes to items or do you and how do you put it in excel. Also, I sell knit and crochet items would i would make a separate sheet for that
Sarah Moore you’re welcome!! Oh man, it’s so different for my SIL stuff. Most don’t know but my real job is that I’m a personal trainer. I run my own business and do this little thing as a side hustle 😱😂. So all that I know and have learned is thru my CPA for my Training business. Perhaps I should post some workouts some day and teach you all something a little different 😂😂😂
Little Lights by Laura: Silhouette Tutorials that would be awesome you should definitely do that. your videos are great and so informative very easy to understand and follow
Great video! I am going to start using this! Question, in the “item shipping cost” tab is that how much the items where shipped for if you ordered online? If it was purchased in store it would be a $0 correct?
I must be dead head right now, I can't figure out your "cost for shipping" and your "did i ship". Why are they different cost points? If the cost for shipping g is $5.95 than shouldn't the "did i ship" also be $5.95 is you shipped? What is my dense brain missing? Other than that I am loving the thought of how you did this!😊
I was initially thinking maybe it was what they charge for p&p and what the postage costs them, but then I was confused again when all those columns were added together...Did that mean the postage cost over $10? Very confused.
Tai's I thought I explained it in the video 🤦🏼♀️🙈. One is for if I paid for shipping on the item I purchased and one is if I needed to charge the customer shipping. Sometimes I’ll buy a T-shirt or tumbler locally and not online thus not requiring shipping. Other times I need to order online and customers price may need to reflect that additional cost. Does that make more sense?
@@littlelightsbylaura It may be confusing to others at first glance, what I do is use "shipping" when I purchase it and "delivery fee/self collection" when I sell it.
It’s just as she runs a clothing brand so Vinyl is something she puts on the clothes. It’s just an extra cost such as shipping . It won’t apply to you if you don’t sell vinyl printed clothes
Hi laura nice video. sorry for interrupt ur giys conversation, can i get the file also? thank youu! ur fast respond is highly appreciated. i need your template. ❤️ my email : jurusdoos@yahoo.com
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/tr.png)
I opened a Cafettaria in Bossaso Univrsity in Somalia. You gave me a simple but effective took to tracking my daily sales. Thank you.
👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻
I'm searching for tutorial on using excel, and I found this video! THIS IS GREAT! THANK YOU! Now I can easily track my sales 😘😘
This is great info to share, Laura! I'm needing to learn how to do an easy spreadsheet for income/expense report on an investment property and I think just by watching this, I might be able to develop one! Thanks for the tips and demo!
😍😍😍 it’s so easy to forget to track things, this has helped me a lot!
Thank you, not used excel for ages, and needed to do pretty much exactly this, you have saved me a lot of time!
Aww I’m so glad! Happy tracking 😊
Omg so helpful. Trying to be better with my loss/profit this year and this is everything. Thank you instantly subscribe and excited to make me one. Eekkk thank you thank you❤
This has been so helpful!!!!! thanks so much
Nice.. I will try this because its nice and simple. I needed to learn how to do a spreadsheet. I need this for my natural health and beauty business. Thanks!
Thank you for this! Im doing mine now
Oh wow this is great!
Thank you so much! This definitely helped
And that is truly helpful thanks for taking the time
not an excel whiz either lol but instead of clicking each cell and the plus sign, you can do =SUM(__:__) so in the example, it would be =SUM(D3:G3). you can also just click and highlight the cells you want to add up.
Thank you so much for sharing! I just started a small earring company and this is so helpful!
Thank you for sharing a simple and effective method
Thank you so much. I learnt a lot
You can consider doing profit margins as well if you'd like to know the percentile of profits.
I took many excel course and I must say you did pretty well
lin fu thanks!!!
Thank you so very much for this!
Thanks so much this is so helpful
Thank you! Very helpful. Straight to the point.
Great video! Super helpful, right to the point. I stink at excel but I was able to do this!! Thanks!!!
Great job thanks for sharing
Very very useful, thanks!
You are amazing! Thank you
Thank you for watching!!!
THIS WAS SO HELPFUL, Thank you so so much for sharing
Jennifer Esan you’re so welcome.
Thank you ! Very simple and just what I needed.
Quick question, where you have item shipping cost (that's what the customer pays so that you can ship their item) $5.95, so if you shipped it for $5. Wouldn't your formula be Vinyl cost+Item cost+ Item shipping cost - did I ship it? So $0+$4.26+$5.95-$5=Total?
Maricela Perez honestly it’s mostly my notes that’s help me. But typically it’s my cost + shipping
@@littlelightsbylaura Ohhh okay! I was just a bit confused because my totals were throwing me off and seemed inaccurate. thank you
Very helpful thank you. If you find a better system please make a new video. this is the best system for my needs so far. althought when i am bigger not sure if theres a better way to capture this info. Thanks Laura xoxo
Thank you so much it help alot like me i dont have so much skills using computer
Thank you for sharing. Just what I needed.
Hi I was wondering if there was any other app or software to keep track of your sales and orders?
Super simple and quick ! thank you!
Thank you for sharing. I need to do this.
Bridget Gainous it’s so easy to forget to do it 🙄😔
I'm confused with the shipping cost and did I ship it? Aren't they the same thing? Can you please explain? Thank you
Awesome Resource! Thank you so much. I do have a couple of questions I may answer myself as I bounce off. Here I go: First, say you have to resend and order because it was wrong. You will have new cost for item and shipping. How do you calculate that in the your excel? And most important how are you calculating taxes and would that not be included in this spreadsheet? To get a total of it at end of month as you did the sale price? I thank you for your response. I just don't know how to go about the taxes and how to keep track of what I am accountable to the IRS. Any guidance with that would be much appreciate.
Taxes you definitely want to keep track off. You could always add more columns to track your resent orders, shipping and tax.
How do you calculate tax sales for people that sells in fair craft when selling on cash. How to do that to avoid complicating the handle the cash change. Example: 1 item price is $20, then it will be 20x7.75(tax sale) in California? So, I want the items price to be $1, $5, $10, $15, $20, $25, $30 to make easier to do the changes. If I add the tax sales, then it will be complicate for the changes. if item is $20
AMAZING VID keep up the good work!!
very clear explanation, thank you
Thanks for Sharing, very Helpful
Great video!
Do you include the Gst (tax included) or do you do before tax???
Why is there two shipping charges is one what you paid to have the shirts shipped and also what is the item cost is that what you payed for the shirt or is that what they payed you and also i just bought some vinyl from amazon it was like 20 for so many sheets I would just put the cost of one sheet if that's all i use but how would i figure out the cost of one or two sheets also I am just trying to start a business how do you add taxes to items or do you and how do you put it in excel. Also, I sell knit and crochet items would i would make a separate sheet for that
Thank you so much 😊
Thank you so much for the tutorial very helpful:)
is there a way you can keep of inventory or if people order and dont pick up
I’m sure you could add a column 😉
@@littlelightsbylaura ty
Thanks ❤
great tips trying to start a small business and that helps a lot. any other business tips would be great. thanks laura
Sarah Moore you’re welcome!! Oh man, it’s so different for my SIL stuff. Most don’t know but my real job is that I’m a personal trainer. I run my own business and do this little thing as a side hustle 😱😂. So all that I know and have learned is thru my CPA for my Training business. Perhaps I should post some workouts some day and teach you all something a little different 😂😂😂
Little Lights by Laura: Silhouette Tutorials that would be awesome you should definitely do that. your videos are great and so informative very easy to understand and follow
Sarah Moore awww well thanks, I’m glad you like them. I means so much to me when you all say such sweet things.
@Prince Maglinte Thank you i will definitely check it out.
Thanks for the info. However, I'm looking for something for a clothing brand. This means I need to add Gender, size, color, etc.
Great video! I am going to start using this! Question, in the “item shipping cost” tab is that how much the items where shipped for if you ordered online? If it was purchased in store it would be a $0 correct?
Yep!
@@littlelightsbylaura thank you!! One more thing! For “‘my sales price” do you enter just what you charged for them without shipping cost?
@@joscelynmorgan5953 I do both so I know my expenses
I must be dead head right now, I can't figure out your "cost for shipping" and your "did i ship". Why are they different cost points? If the cost for shipping g is $5.95 than shouldn't the "did i ship" also be $5.95 is you shipped? What is my dense brain missing? Other than that I am loving the thought of how you did this!😊
I'm wondering the same. And now it's charged $10.95 shipping so the profit should be more. Is there a reason for this?
I was initially thinking maybe it was what they charge for p&p and what the postage costs them, but then I was confused again when all those columns were added together...Did that mean the postage cost over $10? Very confused.
is the item shipping box what you paid to have it shipped to you?
Yes!
@@littlelightsbylaura ty I don't have excel and just trying to start a business do you a tutorial on how to use Google spread sheets
Too nice. Thank you
Thank you!
This was very very helpful ! Thank you
Thanks for this ! 🖤
Kat Lobos you’re so welcome!
Thank you so much for sharing GREAT VIDEO
tnx alot much needed
Great Video! Thanks so much!
hi. what does vinyl cost mean?
U can check on google
Thank you so much
you should still put the price for the vinyl in. you are still spending money on the vinyl.
Michael Rios I add them in my personal preset prices 😍
Valuable info
My question base on the total of january, so the total sales could be not the total profit, sales does not truly means profit.
Correct!! You have to factor in expenses
🙏🏾🙏🏾🙏🏾🔥
Why do you have two columns for the shipping?
Tai's I thought I explained it in the video 🤦🏼♀️🙈. One is for if I paid for shipping on the item I purchased and one is if I needed to charge the customer shipping. Sometimes I’ll buy a T-shirt or tumbler locally and not online thus not requiring shipping. Other times I need to order online and customers price may need to reflect that additional cost. Does that make more sense?
@@littlelightsbylaura Thank you and makes a lot of sense. This helps a lot.
@@littlelightsbylaura It may be confusing to others at first glance, what I do is use "shipping" when I purchase it and "delivery fee/self collection" when I sell it.
whats vinyl cost?
It’s just as she runs a clothing brand so Vinyl is something she puts on the clothes. It’s just an extra cost such as shipping . It won’t apply to you if you don’t sell vinyl printed clothes
Hi! Do you know if you have any excel file to download this? Is it too much? I am just so busy to learn this plus i am so so not good in excel
Sent me an email and I’m sure I can email you a copy of the document
Yehey!!! Thank you Laura!!! Here’s my email: arz.fiel17@teachforthephilippines.org
Sent you an email!
Thank you Laura! Will wait for it
Hi laura nice video. sorry for interrupt ur giys conversation, can i get the file also? thank youu! ur fast respond is highly appreciated. i need your template. ❤️ my email : jurusdoos@yahoo.com
Do you have the excel template you could email to me?
How is this help when you have so many more different items ughhh
Very helpful, Thank you!