How to use Microsoft Excel for small business accounting.
Вставка
- Опубліковано 18 жов 2024
- Just a few basic tips for using Microsoft Excel spreadsheets for your starting accounting with your small business.
Thanks for checking out my channel. Make sure to subscribe!!
For 1 on 1 coaching Pricing & Availability Email me:
Rockstarflipper @Gmail.com
JOIN THE FREE FACEBOOK RESELLER GROUP- (questions answered 24/7 from members)
/ 689595301181796
VIP (paid) Facebook Group- / 263997070772761
*Ebay/Amazon Equipment
Photo Lighting Kit- amzn.to/2mEdSQq
Female Mannequin- amzn.to/2uEnCxS
Male Mannequin- amzn.to/2slaFIw
Photo Background- amzn.to/2xCBnBD
Shipping Tape Gun- amzn.to/2s7rc6f
Poly Mailers - amzn.to/2iVae2t
Bubble Mailers - amzn.to/2iVcUgt
Thermal Printer- amzn.to/2mqkhST
Ebay/Amazon Scale- amzn.to/2hIF2r2
Video Game Cleaner- amzn.to/2jD08Iy
*UA-cam Equipment:
Microphone (Blue Yeti Blackout)- amzn.to/2sAHTaU
Microphone Pop Filter- amzn.to/2tKN6NU
Logitech Webcam - amzn.to/2iZcLc7
Canon G7X II Vlog Camera- amzn.to/2ujOgwH
Memory Card- amzn.to/2xBPDdD
Flexi Tripod- amzn.to/2xBmuiL
Back Up battery canon G7X- amzn.to/2wQ1cPG
MacBook Pro- amzn.to/2xCaUEn
(Disclosure, these are amazon affiliate links & I do get paid a small commission if you purchase using them)
*My EBAY STORE-
rover.ebay.com...
*Our personal Vlog Adventure channel- / @adventuresinparris1498
*FOLLOW ME ON SOCIAL MEDIA:
Facebook.com/Rockstarflipper
Rockstarflipper
Rockstarflipper
Legendary!!! Even 5 years later you’re helping a beginner out , THANKS 🙏🏼
Glad to do it!
Cheers for this, I been tryin to find out about "status report email example project manager" for a while now, and I think this has helped. You ever tried - Peyictorier Imaginative Preeminence - (do a google search ) ? It is a great one of a kind product for getting useful project management and business templates minus the normal expense. Ive heard some decent things about it and my m8 got cool success with it.
Are ya in the future ?
@@azersamaali2016 wyc
This really helped me a lot as a beginner in 2022! Thanks !
I leeeerv how short and precise your vids are. I just needed a refresher in financial statements, etc.
YOURE AWESOME!! TY TY TY!!
Thanks so much for watching and commenting!
Thanks so much for this video. I'm about to launch my business , and math /accounting is NOT my thing , but I do know the importance of it in business, in particular in having as much knowledge of it for myself and my small business. I am a visual learner , so I definitely appreciate the visuals you use to go with the lessons. I am a now officially a subscriber.
Thank you for that I had no Idea thought it was a lot more complicated than that. You made it look more simple than it was already.
THANK YOU! THIS WAS SO USEFUL FOR MY SMALL COMPANY. Appreciate it!
Very Welcome!
Learned so much from this simple yet effective video. Great stuff!
Thank you! I try to keep thing very easy for everyone
Thank you - Just what I need for my Personal Training Business.
Of all the videos i watched, this one was the most helpful and easy to understand. thanx a million!
just went to school for 6 hours and learned more in this 8 minute video
LOL :-) happy it helps
oh..., Finally. I had some simple accounting.
Happy to help thank you!
About to start my business in India and it helped me a lot. Thanks mate.
Love how easy this is. 2 questions for you: 1. If I have the sum for my business services on top, why do I need a Gross cell? and 2. Is there a way to have it calculate 25% of the gross income so I can know what to put aside quarterly for paying taxes? Thanks!
1, im not sure of your question. #2- yes you could create another column and have that block do (Gross*.025) as the formula in it
Very helpfull and simple, just what i was searching for. I dont need all that advanced stuff
You got it !!
Thank you so much! Love this video, very informative!
Great tutorial! Now I can keep books like a pro!
You got it!
hi, I'm from Malaysia! thank you for your explanations!
Very happy to help
Thank you. It was very useful for my small company.
Welcome a bunch. glad to do it
Thank you!
Very simple and easy to understand. Really helped me a lot❤️
You got it!! thanks for watching
@@RockstarFlipper
He i need to make sample excell sheet for my car . Can u plz help me to do that .
I’m 5 years late but bro you made this so easy to understand thank you so much
You got it! I have updated videos on it also
Thanks for helping me.. what about league of legends can you teach us?
LOL im not great. silver/gold only
its really help me. and also gave me practicle knowledge. its really effective.
Very welcome
I like this tutorial thanks for sharing your knowledge
Happy to help thanks so much!
Thank you. Thank you. Just exactly what I was looking for.
hi love how precise your videos are thanks. Love to know about the tee-shirt business i love to start one am good at designing. Will love to hear from you
Thank you!
All in 8min.Thank you very much
Very welcome!! I did an updated one for 2020!! check it out
Very nice and simple exactly what I was looking for Thanks 😁
Glad I can help! thanks for watching
Glad I can help! thanks for watching
Thank you this video was very helpful
Happy to make it!!
Thank you for this reference, I have now the idea and will use this. 😊
No problem at all!! thanks for watching
Thanks for this man !!!
Anytime!
Wow! You have helped me alot!!! Super simple and yet sooooo informative!!!
Easy and very helpful thank you
Thanks soo much!
Hi :) what if it is like a cosmetics business and have to make things on your own and need a capital cause u will buy things in bulk. Can u still use this system? Thanks
Sure. Materials is part of the cost of goods
@@RockstarFlipper thank you!! Appriciate
Thank you so much. So helpful
Very welcome!! thanks for watching
totally loved it...thanks
You made it simple.. Thank you.
GOD bless you bruh you amazin thanks a lot man verry usefull
VERY welcome!! thank you
Thanks Bro For This Video
VERY welcome. theres a 2020 edition and 2021 on my channel
Very simple but very informative...nice one
Thanks. This was very helpful for my start up, small business
nice one.. Can you let us see what is the content of the SHEET NAME TOTAL -- is that consolidation or something?
This really helped me. I couldn't like it enough..
Do you keep receipts after you purchase something to resell? if so for how long?
ALWAYS... keep them or take photos and store the photos. even better if you have them on your debit or credit card statements which you can print. I keep ALL of mine i def have the last 3 years stored in a box
U r so quick.its so impressive. Keep it up help other😊
Thanks man!
anytime!
Many thanks for great starter tips, it's things I never knew. Great
Thank you!
Thanks Tiffany for watching
THANK YOU..!! Great Clear Direction..!
Thanks so much!
Thank you for watching
Amazing video, i learned easily from you. Thanks!
Hey there! The person doing our taxes this year mentioned trying Excel in keeping track of earning and expenses. I was looking at the spreadsheets they already have made up. Most seem to be geared towards merchandise. I offer a service. Which would you recommend?
Making your own spreadsheet. If you don't have experience with excel, find someone who does and have them make you one
@@RockstarFlipper Thanks, will check into it.
Thank you a lot for your video ! I have another question about the purchase items . If I buy something by cash from a garage sale or a swap meet and I don't have any receipts for the items , what can I put in the store column?
Wow
Thanks bro...it is simple and effective...
Thank you so much! this was just what I was looking for! :)
Love learning important skills. Thanks!
Always be learning
i feel like giving you 1000 likes
UA-cam should put a box to type in the amount of likes you wanna give lol
Thanks for this Video, this helps me a lot.
profound gratitude
Thank you for detailed explanation!
Thanks for nice vedio,
Thank you!
If I Alphabetize any column, will the other columns remain corresponding to the row they began in? so lets say. I'm doing inventory and trying to alphabetize items (I've got a comic shop so alphabetical is the best way to organize. If I don't initially put them in alphabetically and mark certain Items as sold in another column, then after adding all inventory decide to alphabetize, would the columns marked sold, remain where I initially put them or remain corresponding to the item next to them? THANKS
So helpful! Thank you!
Thanks Great Video. I found it really helpful.
Thanks! Very important information
Thank you for watching
I love you bro thank you for this
Can u help me make an Excel for the Clients Name and Phone number and Color and Size and Cost and Closeing order date and Drop off notes please!!
Send me an email. Rockstarflipper@gmail.com
What's the version of MS Excel you were using in here?
Its Mac edition
Thank you ❤️
Hi..this video really help my first account..but i having trouble..can someone help me how to close account?
love this!, got something similar
i need some startup ready made excel sheet from general ledger-trail balance-income statement-balancesheet for the days expense income to month end balancesheet.hope you help me.
Great video! Like all the comments below, i wish I could give you 1000 likes for this video. Its very helpful, straightforward and easy.
this was a great start!!!
same for my expectations this video
Huh?
Thank you so much buddy..!!
Very welcome. Anytime!
Great info, Thanks.
Very welcome! thanks for watching David
Thanks very much
Anytime
thank you
Very welcome
very usefull👍👍
Glad to do it!
Thnx i liked it
Hi what excel version is this? Thx
Its like 2017 or 2018 I think. I didnt buy it since then, but now I just use google sheets
you can not calculate the profit margin by deduct sales from all purchases
Love it.
ho can i do one for bounce house rental?
Same way. you need to track the income coming in, and the expenses you spend
Hey there
I need a system in excel that allows me to select a certain group of products individually(using lookup function or sth) and like a mini program, after clicking a button or typing a value, the results of the sale get added to another sheet(log sheet) and clear the calculator for the next use, how the hell can i do this in excel?
Ps: obviously, i need the log sheet to have enough sanity to place each result under the previous one, so they are easily distinguishable from each other and their values don't mix up
Would be great if someone could answer this 3 yo question
Heuer De yeah well you’ll need a professional programmer and it probably won’t be in excel. Highly doubtful that can even be done on excel. If it can and you can find an example then you should ask whoever you see with it
Thank you! Namaste
Very welcome!
Hi! Why is my total cell showing a dash and not the result? Thank you!
You need to email me a screenshot and ill take a look. rockstarflipper@Gmail.com
RockstarFlipper hi its okay it’s already been taken care of. Thank you so much for this easy to understand and useful tutorial! Really helped me a lot as a beginner in excel
I keep getting a positive $350.00 for my gross profit. I tried rearranging the function to get the same result, but to no avail. I double and triple checked that I followed every step correctly. There has to be some small detail you left out.
Concise 👌🏼
thank you
Thank you!!!
Very helpful
Thanks so much!!
very helpful bro
Thank you so much
Thanx for your help.
Also I wanna add that you're cute :P
A tip: you can watch series on kaldroStream. Me and my gf have been using it for watching lots of of movies during the lockdown.
@Terrell Major Yea, I've been using kaldroStream for since december myself :D
great video.
Tim thanks buddy!!
this guy has league on his mac
Sure do
👍👍👍👍👍👍👍
Thanks bud!
how to start business pls infromation pls Thank u ,
please share this created file
tHANK YOU. that was useful for me since im starting to manage my business ..
- momshe ♥ store
Very welcome!!
What's your email?
Rockstarflipper@Gmail.com :-). down below in the description box if you need also
What your email address?
Rockstarflipper@Gmail.com
Dux orh