How to automate Accounting Ledger, Trial Balance, Income Statement, Balance Sheet in Excel | English

I have a conundrum...after following your directions diligently...I find that all though all of my journal entries have a date, in my ledger many entries in my date column are showing (blank) instead of the date. Would love to fix this.

well done sir. Step by step explanation . Clearly understood. Perfect.

Thank you sir
I really love this tutorial
May Allah reward you abundantly

Very useful & thank you so much!

Can you do this in Google Sheet?

Awesome! Many thanks for this video. Perfect for small business, no need to spend money on pricey software.

If i have opening balance then how to represent that in ledger balance?

Hi. Not quiet familiar with excel and I needed to learn how to create an expense format for my accounting output for school. I wasn't able to follow the buttons that you pressed while doing the income statement cause I couldn't find those buttons in my excel.

sir how to freeze F column at chart of account

I would like to show the utmost respect and appreciation for these helpful video , thank you so much bro

Thank you so much!

HOW TO CLICK FREEZE ? I COULD NOT FIND IT

Thank for this lesson brother, i don't know understand how you have arrived at the following steps:
VLOOKUP(B5,'Trial balance"!A4:D13, TO VLOOKUP(B5,'Trial balance"!$A$4:$D$13

SOMETIMES I WONDER I HOW WIDE IS THIS EXCEL,SOME TUITORIALS MAKE YOU LOOK LIKE YOU SKIPPED SOME LESSONS

Thank You Very Much

I like your video. Thank you so much. Can you please show us how to input Trial Balance—beginning balances from the prior year into the current year Trial balance sheet?

Thank you so much!

Hey,can you tell me how to adjust this as per month also?

I love this

How make it according to period

I refresh my accounting knowledge by this video. thanks a lot from my bottom of heart for making such a wonderful, professional Accounting video.

Wow nice cource. When i complete it it automatically converte all journal entries into the trial balance,ledger and into income statement and balance sheet.❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

An amazing work.
Thanks

You are super brilliant. Can I have your WhatsApp No or email address?

good job

Wow incredible work. I am interested

How i Refresh my Ledger and Trial Balance when we add other Gernal entries.

Thank you sir for this vid.
But what happened if one Debit and two credit.

Ledger is not auto updating which new journal entries passing or rectifying existing journal entries

Thank you are a work of art, from heaven. I love you.

❤

Great Job Man!!

After vlookup how do you freeze them

Great Job. Would like to get this to your notice that your work has been copied by other channel PROFESSIONAL'S LEGACY. They shamefully copied point by point... they have more views than your channel...

This is a newly started business for the first year. What about for second year? How could an ongoing business adopt this? Where will be the entry of capital, opening cash balance, opening stocks, opening bank balances, assets, drawings, depreciation, etc., and how those are calculated? Please reply as soon as possible and describe to us elaborately. We anticipate your continued cooperation. Thanks.

Thank you very much for this excellent presentation. I have created the books for my business based on this

edit: I completed the whole setup like you did with data from my own new business and it all balanced! I thank you again for this excellent video. Namaste

In the P&L, shouldnt the credit sales be included as well?

Cant we add a cash flow?

very nicely explained

This video is super informative, I really loved it. I have a doubt, Why do we format the values as "number" instead of "currency" or " Accounting"?

Legend 🙌

Thanks man for the insight
It really worth the data and time spent.
My knowledge have greatly increased 😊❤

Good job bro

Very nicely elaborated begins from the chart of accounts to till balance sheet , Awsm with single excel sheet .If the father of accounting Luca Pacioli alive still he would be really appreciated you .

Thanks sir . helped a lot .This is more than the any accounting software

Very nicely elaborated begins from the chart of accounts to till balance sheet , Awsm with single excel sheet .If the father of accounting Luca Pacioli alive still he would be really appreciated you .

Thanks sir . helped a lot .This is more than the any accounting software

Hello very great videos. Im new to excel and i notived youre very fast when doing data validation. My excel didnt do it like yours. Carr to help

Thanks a lot 🙏