Balance Sheet Explained in Simple Terms - Accounting Balance Sheet Tutorial in Excel

Рет қаралды 258,019

Күн бұрын

Sorry, to be clear, the balance sheet is part of the paid program. But, you can easily set this up while watching this video!
In this video I break down the Balance Sheet and explain how this report represents a small business. If you are a small business owner, you should be looking at your business reports and you should understand how the Income Statement works with the Balance Sheet - all explained in this video!
Download my free business spreadsheet template here: www.amandarussell.mba/gettheb...
Other videos you may like here:
What is a Holding Company? • What is a Holding Comp...
Does the LLC save taxes? • Tax Benefits of LLC vs...
Sole Proprietor vs. LLC vs. S-corp: • Sole Proprietor vs. LL...
How Businesses are Taxed: • How To Choose Your Bus...
9 Short Steps to Create Your LLC: • 9 Steps to Create Your...
In summary, this video explains the balance sheet in simple terms and shows you how to make a balance sheet in excel or google sheets. This is an entire balance sheet tutorial that shows the balance sheet explained as simple as possible. Balance sheet accounting is the summary of everything that happens in your business. The Income Statement and the Balance sheet work together to represent a business' accounting.

Пікірлер: 120

@laurel1865 4 жыл бұрын

That was literally the best example I've ever heard. So easy to digest.

@superdman0911 4 жыл бұрын

This was very concise and helpful, thank you for making things so clear for someone like myself who does not have a strong business background

@yolandagonzalez2169 4 жыл бұрын

Thank you for this video and making it understandable. It has been years since I have taken an accounting class in Junior College and you have helped me recall with clarity.

@maheshwarbanuk4389 4 жыл бұрын

This was the best tutorial for novice like me! Thanks!!

@rickyvu5766 4 жыл бұрын

Your explanations are awesome!!! Really easy to understand and I am loving it. Thank you

@kaseylightle4633 3 жыл бұрын

By far the best example I’ve seen. I actually understand now! Thank you.

@nildairiscotto2268 4 жыл бұрын

Excellent video. Very well explained. Simple and relevant. Thank you!

@khard3r 4 жыл бұрын

Thank you. This breaks down a lot and defines a few terms I was unsure of

@rivankansakar 3 жыл бұрын

I swear to god this made me understand everything. Thank you so much!!

@promastermindgamer8589 3 жыл бұрын

My teacher has a harsh accent and I didn’t understand anything she said. Right when I clicked on this video it helped a lot. Excellent job (:

@Middlenamejane 3 жыл бұрын

This made more sense than the last 200 pages of my textbook. I truly think I will get a better grade on this exam and future exams since I've subscribed. No where in those chapters did it underline that profits will come from the income statement...That's obvious now *but* I got confused when told to "record transactions in spreadsheet" in perpetuation for/to transfer to the balance sheet. That had me thinking that every item/service sold was listed in the balance sheet. Now I understand how this will always be balanced with cash and retained earnings. Thank you! Two steps back, who is the balance sheet for? Is it's main purpose to double check the income statement?

@davidnielson5252 5 жыл бұрын

Fantastic explanation for such a difficult subject as this. I have never been the accounting type. This was simple and clean with a great example and step by step explanation of it all. Great job!!

@businessfinancecoach 4 жыл бұрын

thank you David!!! And thanks for commenting :)

@Spenserifically 3 жыл бұрын

Thank you so much for this video. Your explanations are very clear and succinct. I stumbled across the video (looking for something else), but I will be actively searching for more of your tutorials!

@jenniferobrien8603 4 жыл бұрын

Amazing simple video! Thanks!

@bendeck8918 4 жыл бұрын

Wow thank you. A free balance sheet download does not exist besides this one.

@thirdojohnson4325 4 жыл бұрын

WOW! Amazing Explanation!!!

@robertf6409 4 жыл бұрын

Great video. So clear and to the point! 👏

@anniestoutpalmer4611 4 жыл бұрын

This was very helpful, thank you!

@KevanJeffrey 4 жыл бұрын

Great video, simply explained.

@kyawtkyawtsoe7639 4 жыл бұрын

Thanks. Very clear explain to the listener.🙏

@anamorais4663 4 жыл бұрын

Many thanks 🙏🏼 finally I understand 😁 you explained very well 👍

@gonzalobaron766 3 жыл бұрын

Great and easy way to follow. Thank you.

@chrysanthiusspann2353 3 жыл бұрын

Thank you for this clear explanation~

@lesthanzero 3 жыл бұрын

Awesome job with your explanations.

@matchasource 4 жыл бұрын

This was a helpful into. Thank you.

@barcabrothers9098 4 жыл бұрын

Great information very good material,save the video and watch it multiple times to understand.

@ginacortes1120 3 жыл бұрын

this is the best explanation ever

@suraweeraalagalla8987 4 жыл бұрын

Good explanation skill, thank.

@FRANCISCO62775 3 жыл бұрын

excellent instructor!

@catherinepiriri313 3 жыл бұрын

Awesome description! thanks

@deadcarnivora8648 4 жыл бұрын

I dont know why i was hired for days entry I have no experience but its 20phr job so I'm trying to learn everything I might need to know Youre video was supremely helpful I dont think I'm the smartest but i was able to mostly understand you GREAT VIDEO IM SUBSCRIBING,😍

@anthonydsam 4 жыл бұрын

Well explained. Thank you a lot. I wish to receive from you videos such as tax management, finance, the International Accounting Standard, the IFRS, etc. I’ve learned them in French, now I would like to learn them in English. Anthony

@excel-businessinexcel5181 4 жыл бұрын

do you want to try it in Russian? kzfaq.info/get/bejne/r6uon5N_t6vFe6M.html

@JiraiyaHermitMode 4 жыл бұрын

Nice and simple explantations, thanks

@thandymonteiro8285 4 жыл бұрын

Thank you You have helped me

@goldenboy0712 4 жыл бұрын

Hey that was pretty good!

@eyelessclowned 3 жыл бұрын

You just earned a subscriber:)

@charlesmutuyi8614 3 жыл бұрын

I like how you explain the balance sheet simple Lecture .

@jervahnmorgan 4 жыл бұрын

Good and simple explanation...

@giovanniborsarelli9599 4 жыл бұрын

Simple and clear explanation! thank you.. how I get the excel sheet ?

@kingkong8974 4 жыл бұрын

Ty, easier to read balance sheets for companies with stocks now

@anfobi 4 жыл бұрын

Very nice work.

@veroguyly 3 жыл бұрын

Very clear. Thanks

@SamuelJKime-nopsave 4 жыл бұрын

Very helpful for me as a non-accountant and small business owner. Would love to have the templates.

@davidchudyk1878 3 жыл бұрын

Great video!

@alexis5204 4 жыл бұрын

Thank you so much ♡

@TheFinancialController 4 жыл бұрын

Bravo!

@davidd3800 3 жыл бұрын

please be my accounting professor

@-smallbizman 3 жыл бұрын

Interesting in taking your course, how do I get more information.

@rajdipak6171 4 жыл бұрын

Hi, Thank a lot for your explanation. It is really helpful. I do have a question on it that the weakness and strength of a balance sheet is that it can shows only the value, isn't it? Please advice.

@BEBLESSED04 4 жыл бұрын

outstanding!

@LegendSidhu-es8mr 4 жыл бұрын

Good video 📹 thanks alot 🙏

@stteresadispensary859 4 жыл бұрын

THANK YOU VERY MUCH

@Shuntastreet 4 жыл бұрын

you clarified what i was looking for. in order to bring my net income/loss to the balance sheet. I need to add a retained earned account. For some reason this was not in my quickbooks and I was exactly off by the net loss from the prior months business activity in my balance sheet. Thank you.

@businessfinancecoach 4 жыл бұрын

Awesome - Thanks for telling me!!!!!

@erikp8079 3 жыл бұрын

You're awesome!

@rickeyhughes7380 5 жыл бұрын

Dear Miss Amanda, This is Rickey. I have just watched your video about the Income Statement and the Balance Sheet. I think you explained it well, and I believe it can be helpful in my Bookkeeping and Accounting business. I may still need your advice about getting more clients and growing my business, because my business still has not been too successful. Thank you so much. If possible, I would like to hear from you concerning this. Otherwise, I look forward to seeing more of your upcoming videos. Thank you again, and keep up the good work.

@businessfinancecoach 5 жыл бұрын

Hi Rickey - super cool! Thanks for your comment! Yes, I have business coaching program to help you get clients and grow your business - send me an email at contact@amandarussell.mba and we'll send you a link to schedule a call with me to talk about how my program could help you. I look forward to hearing from you Rickey!

@rickeyhughes7380 4 жыл бұрын

Hello, Miss Amanda. This is Rickey again. I am sorry I took so long to respond back to you. I have been sort of busy. However, I still would like your advice on how to operate my Bookkeeping and Accounting business well. I would be more than glad to communicate with you about this. Hopefully, I will send you an email concerning what I am doing, and I think I may need your help. Please let me hear from you again at the earliest convenience possible. I look forward to it. Thank you again, and keep up the good work. @@businessfinancecoach

@elizabethgonzalez1803 4 жыл бұрын

you should be a teacher, learned a lot. thank you

@qqqcalls 5 жыл бұрын

There is a lot to digest here. Will have to watch the video again.

@businessfinancecoach 5 жыл бұрын

Yes - this is a big topic!

@curtis-thebicentennialist1776 4 жыл бұрын

Great explanation.

@curtis-thebicentennialist1776 4 жыл бұрын

How would you record this scenario on the income/balance sheet? Look forward to your take as I've gotten different opinions from Accountants. A land restoration company receives a prepaid amount for a project that is estimated to take 3-4 years or longer. While The company is confident that it will complete the project for far less than the client's prepaid estimate, there is no certainty of profit amount until project completion. Shouldnt the company be able to defer paying income tax until project completion? Of course any draws by owner will be taxable as personal income.

@ichiulucero4396 3 жыл бұрын

Wow. Thank you. As a new little business owner accounting dies very overwhelm. I am doing Amazon FBA. Is your course fit my business model?

@caroltrimble2738 4 жыл бұрын

Good explanation in the simplest form. Thank you

@kalinamay309 4 жыл бұрын

Thank you

@hydrainarms3135 4 жыл бұрын

Explained it dwn to the T . Tyvm

@mmieducations 3 жыл бұрын

Very Good Teaching and How can get the form Ballad Sheet, Income Statement, Profits and Loss. I want to know more about you.

@mendezmobiledetailing 3 жыл бұрын

Subbed!

@liyatilahun5410 3 жыл бұрын

easy tnx

@johannacabael5092 3 жыл бұрын

what is the other term cash in bdo (to be used in expansion in 2017) buy you're doin balance sheet on year 2015

@karonhebron1304 3 жыл бұрын

I enjoyed your video. Please send me the download so I can use it for my small business

@bigceenc4612 4 жыл бұрын

Subscribed

@jennyhamilton6941 4 жыл бұрын

This video is so helpful, but I can’t find the balance sheet template on your website. Can you clarify where to find it?

@businessfinancecoach 4 жыл бұрын

As I said in the video and typed first thing in the description below, the balance sheet is part of my paid program. The free spreadsheet includes 3 worksheets - basic income statement/accounting worksheet, quarterly tax estimates and end of year tax totals (sums up accounting accounts into the tax categories). That is all I offer for free, plus the e-course of course. My paid program helps people get their accounting and taxes setup in a spreadsheet, which includes office hours with me for a year and all sorts of templates (and we are constantly creating more!). Aloha

@davidpollack6260 4 жыл бұрын

Will you make a video on how to reconcile an unbalanced balance sheet? I am working on a project, and I put in everything in the right place but it doesn't come out equal. For example, what if your mortgage was 350K? How would your balance sheet balance then? Thank you.

@businessfinancecoach 4 жыл бұрын

Well you're never going to balance if you aren't keep complete and accurate accounting records (really double entry, but in my Small Business School I've created a work around so it is possible). I explain at the end of the video: plug the balance under Owner's Equity A mortgage is a liability, it's decreased by principle parts of payments made, while interest expense reduces net income which effects retained earnings

@excel-businessinexcel5181 4 жыл бұрын

To avoid an imbalance, you must simultaneously post amounts to accounts of a double entry, for example: kzfaq.info/get/bejne/r6uon5N_t6vFe6M.html

@amadou3075 3 жыл бұрын

where can i download that

@shaggyandsnoopy 5 жыл бұрын

The link isn't showing up in the description. After the word "here:" it is blank. Just spotted it for you

@businessfinancecoach 4 жыл бұрын

Thanks - unfortunately, I've watched it 3 times and I cannot find it!!! We are going to have to write these down when we edit! :) thanks for your comment

@muhammedsinyang5907 3 жыл бұрын

How do we treat bad debts if they are decreasing in the balance sheet ?.....

@grantreber5379 3 жыл бұрын

Under fixed assets - how would you determine how much an asset has depreciated? Say I purchased a desk for $100, when I update my balance sheet am I saying it's depreciated since I bought it?

@businessfinancecoach 3 жыл бұрын

you don't need to worry about accounting depreciation because it's a non-cash expense and small businesses 99.9% of the time use cash method (WAY more work to use accrual). Therefore, the depreciation is based on TAXES. What did you deduct on the tax return? Probably the full amount.

@grantreber5379 3 жыл бұрын

@@businessfinancecoach I was just curious - what would be an example of when I would need to list something in the asset depreciation column?

@kareenagoyal986 3 жыл бұрын

vid actually starts at 2:30

@macortez35 4 жыл бұрын

Interested in the templates but don't see too many responses....??

@businessfinancecoach 4 жыл бұрын

what do you mean responses? templates free www.amandarussell.mba/getthebusinessspreadsheet

@pelitoloco666 4 жыл бұрын

There is no link

@neeruarya03 4 жыл бұрын

Can you tell me RRSP is asset or liability??

@businessfinancecoach 4 жыл бұрын

No, you'd need to say more details. Plus, analyze it - asset is something you own. Liability is something you owe. 2nd is the plan owned by the business or personally?

@neeruarya03 4 жыл бұрын

In the balancesheet where we show RRSP ,it's from personal account

@SoItsRen 5 жыл бұрын

Are you still offering the free template?♥️

@businessfinancecoach 4 жыл бұрын

Hi Lauren! Yes, here --thanks for commenting! www.amandarussell.mba/getthebusinessspreadsheet

@ahmadnoorani7093 3 жыл бұрын

It is really good please send me the Spreadsheet Template.

@ahmadnoorani7093 3 жыл бұрын

Ahmadnoorani1000@gmail.com

@glenmorse4123 4 жыл бұрын

i found the income sheet, but not the balance sheet?

@businessfinancecoach 4 жыл бұрын

Correct, as I said in the video the Balance Sheet is part of my Small Business MBA program and I help people get it setup for their situation.

@lukestuart8039 3 жыл бұрын

This balance sheet looks nothing like any of the ones on Yahoo Finance, and there's about 50 extra lines and numbers on others?

@noobantimonitor1014 3 жыл бұрын

My god that smile

@arvindtiwari7696 4 жыл бұрын

Can u please explain in more detail

@mariagamarro8210 5 жыл бұрын

Where is the free template? TIA!

@businessfinancecoach 4 жыл бұрын

Hi Maria! sorry I missed you! it's here: www.amandarussell.mba/getthebusinessspreadsheet

@islandkingthecommander 3 жыл бұрын

When doing videos hunny,, dont take to long to get into what is most important.. after you deliver value you can sell us any thing after that.. lil advice for you

@mohergenrader2113 3 жыл бұрын

Hunny???

@MrGuitarguru95 4 жыл бұрын

Giant eye 'art' piece on the wall has me wondering "illuminate?" like 🤔🧐🤨

@crystalhosang3267 4 жыл бұрын

First thing I saw and I was like I gotta go cause I don't know you'll be doing BEHIND CLOSED DOORS and with that sign in your room and be comfortable, I literally thought I was the only one.

@thaisonvu2736 4 жыл бұрын

She has a concise and friendly approach that turns me on

@amberavery1810 3 жыл бұрын

Liked _/

@wcharles7754 4 жыл бұрын

"in accounting there are no negative numbers" as her head floats above negative Accum. Depr lol

@businessfinancecoach 4 жыл бұрын

it would normally be positive but the nature of a contra asset account (accumulated depreciation) will decrease the asset value they are netted with. I made it negative for the sake of those using the report and needing to understand it since I try to simplify accounting for non accountants (and accountants) alike.

@JLrock 4 жыл бұрын

Came here because I'm learning the accounts in English. Fucken teacher :(

@glen-draketoolworks7186 4 жыл бұрын

You started out by saying you would explain the balance sheet. Then you spent a third of the time explaining why reports are important. Duh. Then you stated the accounting formula, i.e. Assets = Liabilities + Equity. Then you spent the rest of the time explaining what an asset is, what a liability, is, and what equity is........that's another Duh. What you did not do was explain why Assets = Liabilities + Equity, which is what you said you were going to do, in simple terms. Does explaining a motor, a transmission, and a drive-train explain what a car is. No. It doesn't. You need to drill down on the problem which is why Assets=Liabilities+Equity. You did not do that.

@accountingcaddy9210 4 жыл бұрын

Maybe this example would help: -Let’s say you started a business and contributed cash of $100k into the business. Your business would have Assets of Cash of $100k and your equity is $100k. Therefore Assets ($100k) = Equity ($100k) -Now say you purchased a vehicle for your business with a purchase price of $60k. You paid $20k as a down payment and financed the remaining $40k. For this specific transaction and to help visualize equity: Assets (Truck - $60k) = Liabilities (Auto Loan - $40k) + Equity (Down pmt - $20k). You can look at equity as the owner’s claim or "equity" in the assets. -In total you now have: Assets: Cash - $80k ($100k - $20k down payment) Truck - 60k Total - $140k Liabilities: $40k (Auto Loan) Equity: $100k ($80k cash + $20k downpayment) So, of course Assets of 140k = Liabilities of $40k + Equity of $100k. And to further breakdown the $100k of equity in this example, it represents your $80k in cash left, along with your $20k equity in the truck purchase. Hope this helps. If you have more questions, feel free to ask.

@Middlenamejane 3 жыл бұрын

"Everything I own =everything I owe" she said that. Its simple. If more time could have been spent on it, cool, but don't bite her head off about it.