HOW TO TRACK YOUR SALES USING EXCEL

[@guledsm]

I opened a Cafettaria in Bossaso Univrsity in Somalia. You gave me a simple but effective took to tracking my daily sales. Thank you.

[@littlelightsbylaura]

👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻

[@Natalie-fx8do]

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 😘😘

[@suzntx]

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!

[@littlelightsbylaura]

😍😍😍 it’s so easy to forget to track things, this has helped me a lot!

[@jB_15]

You can consider doing profit margins as well if you'd like to know the percentile of profits.

[@chikiaqueennatural678]

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!

[@CliffsShed]

Thank you, not used excel for ages, and needed to do pretty much exactly this, you have saved me a lot of time!

[@littlelightsbylaura]

Aww I’m so glad! Happy tracking 😊

[@britnxypham]

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.

[@maricelaperez7236]

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?

[@littlelightsbylaura]

Maricela Perez honestly it’s mostly my notes that’s help me. But typically it’s my cost + shipping

[@maricelaperez7236]

@@littlelightsbylaura Ohhh okay! I was just a bit confused because my totals were throwing me off and seemed inaccurate. thank you

[@lindawee5187]

I took many excel course and I must say you did pretty well

[@littlelightsbylaura]

lin fu thanks!!!

[@motizilfood]

Hi I was wondering if there was any other app or software to keep track of your sales and orders?

[@tisafigueroa6909]

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❤

[@dollyG1968]

This has been so helpful!!!!! thanks so much

[@Babzhtx713]

Thank you for this! Im doing mine now

[@watsonj.r3447]

Thank you for sharing a simple and effective method

[@gkmc2440]

I'm confused with the shipping cost and did I ship it? Aren't they the same thing? Can you please explain? Thank you

[@azizanabail655]

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

[@delightsounds6529]

And that is truly helpful thanks for taking the time

[@bridgetgainous5487]

Thank you for sharing. I need to do this.

[@littlelightsbylaura]

Bridget Gainous it’s so easy to forget to do it 🙄😔

[@butterfly090965]

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.

[@littlelightsbylaura]

Taxes you definitely want to keep track off. You could always add more columns to track your resent orders, shipping and tax.

[@JelscreationsNmore]

is there a way you can keep of inventory or if people order and dont pick up

[@littlelightsbylaura]

I’m sure you could add a column 😉

[@JelscreationsNmore]

@@littlelightsbylaura ty

[@JelscreationsNmore]

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

[@christianroberson1630]

Thank you so much! This definitely helped

[@improveeverydayzachary]

Oh wow this is great!

[@delightsounds6529]

Do you include the Gst (tax included) or do you do before tax???

[@delaneymays6645]

Great video! Super helpful, right to the point. I stink at excel but I was able to do this!! Thanks!!!

[@tutsecret499]

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

[@sheryl3462]

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!😊

[@hdjaime76]

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?

[@naomirowan7557]

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.

[@hermanoamericano]

very clear explanation, thank you

[@jorgecavero3452]

Thanks for the info. However, I'm looking for something for a clothing brand. This means I need to add Gender, size, color, etc.

[@sydneycollins-wallace2963]

Thank you so much for sharing! I just started a small earring company and this is so helpful!

[@janeedeh176]

Thank you so much. I learnt a lot

[@JelscreationsNmore]

is the item shipping box what you paid to have it shipped to you?

[@littlelightsbylaura]

Yes!

[@JelscreationsNmore]

@@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

[@DeaneGoodie]

Thank you! Very helpful. Straight to the point.

[@IamClaudiaJohnson]

Thank you for sharing. Just what I needed.

[@joscelynmorgan5953]

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?

[@littlelightsbylaura]

Yep!

[@joscelynmorgan5953]

@@littlelightsbylaura thank you!! One more thing! For “‘my sales price” do you enter just what you charged for them without shipping cost?

[@littlelightsbylaura]

@@joscelynmorgan5953 I do both so I know my expenses

[@josephineclayton3304]

Great job thanks for sharing

[@Isaiah_mariatv10]

Thanks so much this is so helpful

[@killerjms21]

you should still put the price for the vinyl in. you are still spending money on the vinyl.

[@littlelightsbylaura]

Michael Rios I add them in my personal preset prices 😍

[@kendrawood4698]

Thank you so very much for this!

[@mycaptivethoughtswithatosh5737]

Thank you ! Very simple and just what I needed.

[@jessicaallego5980]

Thank you so much it help alot like me i dont have so much skills using computer

[@msfamaen]

hi. what does vinyl cost mean?

[@kimjongun2524]

U can check on google

[@anikeologe4573]

THIS WAS SO HELPFUL, Thank you so so much for sharing

[@littlelightsbylaura]

Jennifer Esan you’re so welcome.

[@victoriareyes761]

Super simple and quick ! thank you!

[@joannevanzyl4391]

Very very useful, thanks!

[@psychocarlos21]

You are amazing! Thank you

[@littlelightsbylaura]

Thank you for watching!!!

[@charmainwalkin3666]

Thanks for Sharing, very Helpful

[@sarahmoore1275]

great tips trying to start a small business and that helps a lot. any other business tips would be great. thanks laura

[@littlelightsbylaura]

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 😂😂😂

[@sarahmoore1275]

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

[@littlelightsbylaura]

Sarah Moore awww well thanks, I’m glad you like them. I means so much to me when you all say such sweet things.

[@sarahmoore1275]

@Prince Maglinte Thank you i will definitely check it out.

[@tais3]

Why do you have two columns for the shipping?

[@littlelightsbylaura]

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?

[@tais3]

@@littlelightsbylaura Thank you and makes a lot of sense. This helps a lot.

[@jB_15]

@@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.

[@bongalanga1753]

Too nice. Thank you

[@chibelde4925]

Thank you so much for the tutorial very helpful:)

[@arzleleijoycefiel8936]

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

[@littlelightsbylaura]

Sent me an email and I’m sure I can email you a copy of the document

[@arzleleijoycefiel8936]

Yehey!!! Thank you Laura!!! Here’s my email: [e-mail]

[@arzleleijoycefiel8936]

Sent you an email!

[@arzleleijoycefiel8936]

Thank you Laura! Will wait for it

[@khadijah1062]

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 : [e-mail]

[@zandrosia]

Thank you so much for sharing GREAT VIDEO

[@yusufahmed603]

AMAZING VID keep up the good work!!

[@papmcirfd8969]

My question base on the total of january, so the total sales could be not the total profit, sales does not truly means profit.

[@littlelightsbylaura]

Correct!! You have to factor in expenses

[@ymir1312]

whats vinyl cost?

[@liam77877]

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

[@marilynkemper5310]

Great Video! Thanks so much!

[@MykeltheEntrepreneur]

Great video!

[@Kat-oh6yz]

Thanks for this ! 🖤

[@littlelightsbylaura]

Kat Lobos you’re so welcome!

[@Olosengbuan]

Thank you so much 😊

[@karengay4084]

Thank you!

[@KATIERKT]

tnx alot much needed

[@pursuitofhappinesswakeupwa1398]

Thanks ❤

[@MsCinnamon39]

This was very very helpful ! Thank you

[@officialpeeshady]

🙏🏾🙏🏾🙏🏾🔥

[@lg3689]

Thank you so much

[@videodiaries7998]

Valuable info

[@angelafelderman4158]

Do you have the excel template you could email to me?

[@MomBoss_4Life]

How is this help when you have so many more different items ughhh

[@amyscott9435]

Very helpful, Thank you!