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

Поделиться
HTML-код
  • Опубликовано: 5 сен 2024

Комментарии • 120

  • @laurel1865
    @laurel1865 4 года назад +49

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

  • @superdman0911
    @superdman0911 4 года назад +10

    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

  • @Middlenamejane
    @Middlenamejane 4 года назад +21

    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?

  • @rivankansakar
    @rivankansakar 3 года назад +2

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

  • @davidnielson5252
    @davidnielson5252 5 лет назад +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!!

  • @yolandagonzalez2169
    @yolandagonzalez2169 4 года назад +2

    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.

  • @promastermindgamer8589
    @promastermindgamer8589 3 года назад +1

    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 (:

  • @bendeck8918
    @bendeck8918 4 года назад +1

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

  • @maheshwarbanuk4389
    @maheshwarbanuk4389 4 года назад +3

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

  • @anthonydsam
    @anthonydsam 4 года назад +2

    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

  • @rickyvu5766
    @rickyvu5766 4 года назад +3

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

  • @deadcarnivora8648
    @deadcarnivora8648 4 года назад +2

    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,😍

  • @Shuntastreet
    @Shuntastreet 4 года назад +1

    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.

  • @barcabrothers9098
    @barcabrothers9098 4 года назад +1

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

  • @nildairiscotto2268
    @nildairiscotto2268 5 лет назад +2

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

  • @kyawtkyawtsoe7639
    @kyawtkyawtsoe7639 4 года назад +1

    Thanks. Very clear explain to the listener.🙏

  • @khard3r
    @khard3r 4 года назад +1

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

  • @FRANCISCO62775
    @FRANCISCO62775 4 года назад +1

    excellent instructor!

  • @qqqcalls
    @qqqcalls 5 лет назад +8

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

  • @kaseylightle4633
    @kaseylightle4633 4 года назад

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

  • @Spenserifically
    @Spenserifically 4 года назад

    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!

  • @anamorais4663
    @anamorais4663 4 года назад +1

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

  • @KevanJeffrey
    @KevanJeffrey 4 года назад +1

    Great video, simply explained.

  • @ginacortes1120
    @ginacortes1120 3 года назад

    this is the best explanation ever

  • @chrysanthiusspann2353
    @chrysanthiusspann2353 3 года назад +1

    Thank you for this clear explanation~

  • @thandymonteiro8285
    @thandymonteiro8285 4 года назад +2

    Thank you
    You have helped me

  • @jenniferobrien8603
    @jenniferobrien8603 4 года назад +1

    Amazing simple video! Thanks!

  • @lesthanzero
    @lesthanzero 3 года назад

    Awesome job with your explanations.

  • @eyelessclowned
    @eyelessclowned 4 года назад +2

    You just earned a subscriber:)

  • @gonzalobaron766
    @gonzalobaron766 4 года назад

    Great and easy way to follow. Thank you.

  • @charlesmutuyi8614
    @charlesmutuyi8614 3 года назад

    I like how you explain the balance sheet simple Lecture .

  • @suraweeraalagalla8987
    @suraweeraalagalla8987 4 года назад +3

    Good explanation skill, thank.

  • @kingkong8974
    @kingkong8974 4 года назад +1

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

  • @anfobi
    @anfobi 4 года назад +1

    Very nice work.

  • @jervahnmorgan
    @jervahnmorgan 4 года назад

    Good and simple explanation...

  • @thirdojohnson4325
    @thirdojohnson4325 4 года назад +2

    WOW! Amazing Explanation!!!

  • @TheFinancialController
    @TheFinancialController 4 года назад +1

    Bravo!

  • @rickeyhughes7380
    @rickeyhughes7380 5 лет назад +1

    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
      @businessfinancecoach  5 лет назад +1

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

  • @caroltrimble2738
    @caroltrimble2738 4 года назад +1

    Good explanation in the simplest form. Thank you

  • @davidd3800
    @davidd3800 4 года назад +18

    please be my accounting professor

  • @anniestoutpalmer4611
    @anniestoutpalmer4611 4 года назад +1

    This was very helpful, thank you!

  • @JiraiyaHermitMode
    @JiraiyaHermitMode 4 года назад

    Nice and simple explantations, thanks

  • @veroguyly
    @veroguyly 4 года назад

    Very clear. Thanks

  • @catherinepiriri313
    @catherinepiriri313 3 года назад

    Awesome description! thanks

  • @SamuelJKime-nopsave
    @SamuelJKime-nopsave 4 года назад +1

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

  • @matchasource
    @matchasource 4 года назад +4

    This was a helpful into. Thank you.

  • @-smallbizman
    @-smallbizman 3 года назад +5

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

  • @robertf6409
    @robertf6409 4 года назад

    Great video. So clear and to the point! 👏

  • @curtis-thebicentennialist1776
    @curtis-thebicentennialist1776 4 года назад

    Great explanation.

    • @curtis-thebicentennialist1776
      @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.

  • @davidchudyk1878
    @davidchudyk1878 4 года назад

    Great video!

  • @elizabethgonzalez1803
    @elizabethgonzalez1803 4 года назад

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

  • @LegendSidhu-es8mr
    @LegendSidhu-es8mr 4 года назад

    Good video 📹 thanks alot 🙏

  • @giovanniborsarelli9599
    @giovanniborsarelli9599 4 года назад +1

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

  • @goldenboy0712
    @goldenboy0712 4 года назад +2

    Hey that was pretty good!

  • @alexis5204
    @alexis5204 4 года назад +1

    Thank you so much ♡

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

  • @stteresadispensary859
    @stteresadispensary859 4 года назад

    THANK YOU VERY MUCH

  • @karonhebron1304
    @karonhebron1304 3 года назад

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

  • @bigceenc4612
    @bigceenc4612 4 года назад +1

    Subscribed

  • @kalinamay309
    @kalinamay309 4 года назад

    Thank you

  • @BEBLESSED04
    @BEBLESSED04 4 года назад

    outstanding!

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

  • @ichiulucero4396
    @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?

  • @erikp8079
    @erikp8079 3 года назад

    You're awesome!

  • @liyatilahun5410
    @liyatilahun5410 3 года назад

    easy tnx

  • @davidpollack6260
    @davidpollack6260 4 года назад +1

    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
      @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
      @excel-businessinexcel5181 4 года назад

      To avoid an imbalance, you must simultaneously post amounts to accounts of a double entry, for example: ruclips.net/video/yExl0NREaKo/видео.html

  • @hydrainarms3135
    @hydrainarms3135 4 года назад

    Explained it dwn to the T .
    Tyvm

  • @kareenagoyal986
    @kareenagoyal986 4 года назад +1

    vid actually starts at 2:30

  • @neeruarya03
    @neeruarya03 4 года назад +1

    Can you tell me RRSP is asset or liability??

    • @businessfinancecoach
      @businessfinancecoach  4 года назад +1

      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
      @neeruarya03 4 года назад

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

  • @macortez35
    @macortez35 5 лет назад +2

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

    • @businessfinancecoach
      @businessfinancecoach  5 лет назад

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

  • @pelitoloco666
    @pelitoloco666 4 года назад +1

    There is no link

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

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

  • @mendezmobiledetailing
    @mendezmobiledetailing 3 года назад

    Subbed!

  • @muhammedsinyang5907
    @muhammedsinyang5907 3 года назад

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

  • @grantreber5379
    @grantreber5379 4 года назад

    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
      @businessfinancecoach  4 года назад

      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
      @grantreber5379 4 года назад

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

  • @ahmadnoorani7093
    @ahmadnoorani7093 3 года назад

    It is really good please send me the Spreadsheet Template.

  • @amadou3075
    @amadou3075 3 года назад

    where can i download that

  • @islandkingthecommander
    @islandkingthecommander 4 года назад

    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

  • @shaggyandsnoopy
    @shaggyandsnoopy 5 лет назад +4

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

    • @businessfinancecoach
      @businessfinancecoach  5 лет назад

      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

  • @arvindtiwari7696
    @arvindtiwari7696 4 года назад +1

    Can u please explain in more detail

  • @lukestuart8039
    @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
    @noobantimonitor1014 4 года назад

    My god that smile

  • @glenmorse4123
    @glenmorse4123 5 лет назад

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

    • @businessfinancecoach
      @businessfinancecoach  4 года назад +1

      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.

  • @mariagamarro8210
    @mariagamarro8210 5 лет назад +1

    Where is the free template? TIA!

    • @businessfinancecoach
      @businessfinancecoach  5 лет назад

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

  • @SoItsRen
    @SoItsRen 5 лет назад

    Are you still offering the free template?♥️

    • @businessfinancecoach
      @businessfinancecoach  5 лет назад

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

  • @thaisonvu2736
    @thaisonvu2736 4 года назад +1

    She has a concise and friendly approach that turns me on

  • @MrGuitarguru95
    @MrGuitarguru95 4 года назад +1

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

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

  • @amberavery1810
    @amberavery1810 4 года назад

    Liked _/

  • @JLrock
    @JLrock 5 лет назад +1

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

  • @wcharles7754
    @wcharles7754 4 года назад

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

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

  • @glen-draketoolworks7186
    @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
      @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
      @Middlenamejane 4 года назад

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