Excel Tutorial: How to Make a Balance Sheet

As promised:

Excel Tutorial: How to Create an Income Statement

The balance sheet describes the assets, liabilities, and equity of a firm at a specific point in time. Assets are the (tangible or intangible) things that a firm owns. Liabilities are the firm's debts. Equity is the difference between what the firm owns and what it owes to others. Because the balance sheet is specific to a point in time, it is much like a photograph. What it shows was true when the snapshot was taken, but is not necessarily true when it is viewed.

[LohanX]

You’re awesome! Thank you for literally explaining everything! This really helped. 👍🏼

[vmystery]

I am taking a accounting class and this was very helpful. Do you have a video on calculating financial ratios?

[bigmacdaddy]

You need to show journal entries and then build the balance sheet of them.

[edlopez]

Great set up but I agree that you need show how it connects to the journal entries. Create the journal entry then have it automatically go to the balance sheet. I'm sure advanced math majors get it though. Otherwise it is a good template to follow.

[AdityaChaturvedy]

I initially thought this was gonna be tough, but your tutorial made my work super easy🙏🏽

[coreywalker]

THANK YOU SO MUCH!. THIS HELPED ME WITH MY ASSIGNMENT 💕

[xucaen]

why did you make your balance sheet vertical instead of horizontal?

[bensonwu]

Today, I got an assignment that I need to write a balance sheet using Google Sheets, which is similar to Excel, so this might be helpful.

[gwenjack]

Camera is too far away and the font size is too small.

[Kiwisaurus]

Oh my god you sound just like Donnie from You Suck at PhotoShop. I want to learn, but I can't stop laughing.

[sorcererstone]

Newbie question: In this video, all entries are entered once aka a single entry format. Is this approach a common practice in the business world? Do we need the more tedious double entry format when doing a business balance sheet?

[MACCNIPH]

This doesn't show you how to do any of the Balance Sheet and it doesn't show you how to do the equations or how to set up the spread sheet. It shows what it should look like when your ready to use but not how to actually make it.

[passthepipe]

Helpful video but Jesus please stop saying GO AHEAD in every other sentence.

[boom-shun]

Me trying to prove embezzlement of government funds in a Discord rp server of "New United States of America"