Video

Good One....If there is an category column it will be much helpful to find expense on specific category

Thanks 🙏

Sir, 01/7/24 sy excel pr is format pr Kam start ho jai ga . Mgr previous year Ka closing balance is year k opening ma kysa Lena ha

Working fine

Love love loved it I have to print 1,345 cheques you make it easy Thank you

Sir i Wish you can make automated account receivable and payment showing invoice date, due date, over due date, aging date, payment, balance, Maybe payment will has it own sheet, each time payment is made it will reflect on automatically reduce the account receivable balance due to payment received and show current balance. While in payment sheet show payment date, invoice No,amount paid, and outsadning balance. Payment date: 😂 Invoice No : Invoice 02 Account name: ABC comply Principal amount :😂 Payment 😂 Balance😢 Next payment the balance become principal amount if and if payment is made they will be automatical update using vlookup or IF-functions Please can't you put of such great work ?

How no make malt pal sheet pdf

maza aagya bro

Thanku sir.. The video is so helpful.. It saves my 2 hours for every day..

can you make a video of how you created this format? thanks

Please help us explain how to prepare a schedule of debt installments, interest and late interest in case there is a grace period in the agreement.

You're a legend mate. Simply and easy instructions to solve my problems. Thanks!

Sir yea chezay mujhay bhe seikhni hay

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

Request to you For availability of these lectures in urdu for pakistani fellows Pakistanis need it all really Mayn ALLAH kreem shower his Blessing on Pakistan ALLAH pak Pakistan ko izzet de Abaad rkhy Salamet rkhy Ameen

Thank you very much for this high purity level

Very much honestly teaching , sharing knowledge

Great job

Hello, thanks for videos . is it possible for you to publish an Excel lesson video for data reporting in the sales field?

Very useful & thank you so much!

Can you do this in Google Sheet?

wow

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?

May ny is sey kafi chizy learn ki hay sir sirf Sub Totals or Totals ni arhay office old hay i think kindly suggest kejiyega

Hello sir I have followed all your instructions but I am unable to generate pdf or this button is not working.kindly help me to sort out this blocker Thanks

Nice bro! Thanks for the help 💪

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

Thx

Very helpful. TY

I want this sheet but I want one more object. Size.

Thank you so much!

38:31 How to do that? while selecting column C to E??? how to freeze them? "=VLOOKUP(F4,'Chart of Accounts'!$C:$E,3,0)", Don't know how to put $ inbetween (F4,'Chart of Accounts'!C:E,3,0).

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

Hey! 1st comment 🙌🏼

Helloo can you do an update or follow up part 3 Video to the accounting cycle video?

slam sir ...do you have any course in which you teach how can we make such softwares ?

thank you alot. but iam still wiating like 3 months to waiting for thr video. how to close the year and begin with a new year. plz help

So nice of you Great effort Thank You Brother

Nice video

sir what we going to do for the next month after the cycle? how can we calculate the last month balance with the transaction current month?

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

Thank You Very Much

Thanks man. Very helpful video.

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?