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!
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?
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.
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
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
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.
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.
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
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
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.
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?
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
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
![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)
![How to keep your accounts in Excel [A guide for small businesses]](http://i.ytimg.com/vi/w9xdAeYSkxg/mqdefault.jpg)
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!
This has been so helpful!!!!! thanks so much
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❤
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 😊
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
And that is truly helpful thanks for taking the time
Thank you so much! This definitely helped
I took many excel course and I must say you did pretty well
lin fu thanks!!!
You can consider doing profit margins as well if you'd like to know the percentile of profits.
Thank you for sharing a simple and effective method
Oh wow this is great!
Thank you so much. I learnt a lot
Hi I was wondering if there was any other app or software to keep track of your sales and orders?
Thank you so very much for this!
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
Great job thanks for sharing
Great video! Super helpful, right to the point. I stink at excel but I was able to do this!! Thanks!!!
Thanks so much this is so helpful
Thank you for sharing. I need to do this.
Bridget Gainous it’s so easy to forget to do it 🙄😔
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.
Very very useful, thanks!
Thank you so much for sharing! I just started a small earring company and this is so 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
You are amazing! Thank you
Thank you for watching!!!
Thank you! Very helpful. Straight to the point.
I'm confused with the shipping cost and did I ship it? Aren't they the same thing? Can you please explain? Thank you
Do you include the Gst (tax included) or do you do before tax???
very clear explanation, 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 ! Very simple and just what I needed.
Thanks for Sharing, very Helpful
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
Thank you for sharing. Just what I needed.
THIS WAS SO HELPFUL, Thank you so so much for sharing
Jennifer Esan you’re so welcome.
Thank you so much it help alot like me i dont have so much skills using computer
Super simple and quick ! thank you!
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
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.
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.
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
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.
hi. what does vinyl cost mean?
U can check on google
Thanks for the info. However, I'm looking for something for a clothing brand. This means I need to add Gender, size, color, etc.
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.
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
Thank you so much for the tutorial very helpful:)
Thank you so much 😊
AMAZING VID keep up the good work!!
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 😍
Thank you so much for sharing GREAT VIDEO
Great Video! Thanks so much!
Too nice. Thank you
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
Great video!
Thanks for this ! 🖤
Kat Lobos you’re so welcome!
This was very very helpful ! Thank you
Thank you!
tnx alot much needed
Thanks ❤
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
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
Thank you so much
Valuable info
🙏🏾🙏🏾🙏🏾🔥
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!