Preparing a 14-Columnar Worksheet | Comprehensive Illustration

  Рет қаралды 12,333

Sir A's Accounting Iksimplified

Sir A's Accounting Iksimplified

Күн бұрын

Пікірлер: 112
@joshuaearltumamak3173
@joshuaearltumamak3173 2 жыл бұрын
Thank you, Sir! After watching the video, I learned how to prepare a 14-column sheet step by step, which helped me learn how to make a worksheet with 14 columns.
@Critical_Investors
@Critical_Investors 3 жыл бұрын
Salamat po. Sobrang linaw ng explanations and marami akong natutunan. Thanks and God bless po! Wish you the best!
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Salamat!
@marielatejada4417
@marielatejada4417 2 жыл бұрын
Thank you, sir, for this comprehensive illustration. It helped me enhance my knowledge from the previous video lectures because it was explained thoroughly. I also learned how to prepare a 14-columnar worksheet properly.
@justinelintao5329
@justinelintao5329 2 жыл бұрын
Done watching, Sir. Thank you for giving another example with precise explanation. I'll comeback to this video soon to review!
@lukeabel3373
@lukeabel3373 2 жыл бұрын
Done watching po, sir! While watching this vide, I made a quick review of my past 14-columnar worksheet and saw some few problems of which I was able to fix! Now that I've learned how to do closing better, this video has further improved me.
@levjeremetalavera2642
@levjeremetalavera2642 2 жыл бұрын
Done watching Sir A! This video lecture both refresh my memory of previous lectures and helps in my understanding of how to create a worksheet with 14 columns.
@eliannadc6184
@eliannadc6184 2 жыл бұрын
done watching, This video gave me a quick review of our past discussions, and it gave me a review of how to prepare a 14-columnar worksheet. The discussion was very smooth and I understood it clearly. Thank you so much sir!
@Heartyyyyyyyy
@Heartyyyyyyyy 2 жыл бұрын
Done watching po sir. Following your instructions, I was able to replicate the worksheet with excel and I was able to test my knowledge and asses my skills. Thank you po sir A!
@nicolettegertrudechavez5982
@nicolettegertrudechavez5982 2 жыл бұрын
I have to watch it two times because it is really hard for me to understand it at first, but as I rewatched it, I finally understand how to prepare the 14 columnar worksheet. Thank you sir A
@charlotteannesaguid8587
@charlotteannesaguid8587 2 жыл бұрын
Thank you for the detailed explanation on how to create a 14-columnar worksheet. It was really helpful because I never would have known what to put in a 14-columnar worksheet. This has broaden my knowledge about closing entries and how they are plotted in a columnar, or in this case, an excel worksheet.
@lawrencemayores5746
@lawrencemayores5746 2 жыл бұрын
Thank you very much, sir; thanks to this video, I can apply what I've learned in previous lessons, such as the rules. I didn't get it at first because I expected the 14-column table to be difficult, but with your help, I gradually understood what you were saying. Finally, I understood the examples and had takeaways.
@joygolez7118
@joygolez7118 2 жыл бұрын
I had a better understanding of how to prepare the 14 columnar worksheet thanks to this video instruction.
@dianecadisal1848
@dianecadisal1848 2 жыл бұрын
Sir A, I'm done watching! I appreciate the information and this kind of conversation. I'm done with watching these videos. Because it contains all the processes in an accounting cycle, creating a 14-column worksheet is really complicated for me. My understanding of the subject increased as a result of the clear and concise discussion that was provided. I appreciate your thorough explanation and the example, sir.
@ariannejoycemoreno5570
@ariannejoycemoreno5570 2 жыл бұрын
Done watching, sir. Thank you, sir. This video gave me a quick review of our past discussions, and it gave me a review of how to prepare a 14-columnar worksheet. The discussion was very smooth and I understood it clearly.
@johnpaulgaut9042
@johnpaulgaut9042 2 жыл бұрын
Done watching sir A! Very clear explanation about the 14 column worksheet
@polvincentgarcia8755
@polvincentgarcia8755 2 жыл бұрын
Done Watching Sir, the video lecture is preparing the 14 columnar. I learned how to prepare a 14 columnar worksheet by the sample exercise, also it was related to the previous discussion where it helps me more my knowledge from closing entries. Thank you!
@andreatagle8196
@andreatagle8196 2 жыл бұрын
Sir, I'm done rewatching. I'm grateful, sir. I quickly reviewed our previous discussions in this video, and I also reviewed how to create a worksheet with 14 columns. The conversation flowed extremely easily, and I could understand it all.
@nicolemargarettiponodonado2176
@nicolemargarettiponodonado2176 2 жыл бұрын
This video lecture helped me to widen my knowledge about the 14-columnar worksheet. I was kinda confused at the start but as the video goes on I kinda start to understand it a little bit more, but the lesson is very easy to understand because it is very detailed. Thank you, sir.
@jemimahocampo8808
@jemimahocampo8808 2 жыл бұрын
Done rewatching! It was actually so confusing at first, but as I rewatch it and understand every explanation. I understand now how to do the 14 columnar worksheet. Thank you for this video lesson.
@gabrielleatienza9396
@gabrielleatienza9396 2 жыл бұрын
I've already watched it, sir. I just forgot to comment on this video. Thank you for explaining it, sir, it helps me to do my activity last time. It is really a big for me sir!
@maimailipat_
@maimailipat_ 2 жыл бұрын
Done watching sir! This video lecture helped me to understand more about how to prepare the 14 columnar worksheet
@christinetrishiabunol7856
@christinetrishiabunol7856 2 жыл бұрын
Done watching, sir. This video lecture provides information about the closing entries. I'm just confused in some parts but able to understand at the end of the video. Thank you sir!
@airongarrido6571
@airongarrido6571 2 жыл бұрын
Thanks in this video because this video helps me what are the things that are included in the 14-column worksheet. I also become comprehend on making the worksheet and this video helps me a lot to master the accounting cycle until the post closing trial balance.
@eduardoaragon4299
@eduardoaragon4299 2 жыл бұрын
done watching sir. thank you for this video lecture it clearly discuss how to make a 14 columnar worksheet and how to work back from adjusted trial balance.
@kennethvonallawi6276
@kennethvonallawi6276 2 жыл бұрын
Thank you Sir for this detailed explanation. I learn about 14 columnar which includes the closing entries
@ashvylljamaicapattung4465
@ashvylljamaicapattung4465 2 жыл бұрын
Thank you sir! This video lecture both recalls my knowledge of previous lectures and aids in my understanding of how to create a worksheet with 14 columns. The accounts and numbers involved make it just a little bit tricky, but overall, the instruction is clear and the examples of transactions and entries are carefully explained.
@joshuajaeredrino4013
@joshuajaeredrino4013 2 жыл бұрын
Done Watching Sir, the video lecture is quite long but discussed it properly. I learned how to prepare a 14 columnar worksheet by the sample exercise, also it was related to the previous discussion where it helps me more to deepen my knowledge from closing entries. Thank you!
@davefermaran5389
@davefermaran5389 2 жыл бұрын
Thank you so much, sir; because of this video, I can apply what I've learned from past lessons, like the rules. I didn't get it at first because I expected it to be difficult because of the 14-column table, but with your help, I gradually understood what you were saying. In the end, I really understood the examples and had takeaways.
@princezharlvillar6196
@princezharlvillar6196 2 жыл бұрын
Although the closing entries are a little confusing, this video course discusses the topic so clearly that I was able to understand the 14-column worksheet. Thank you, Sir
@julianapauyo8247
@julianapauyo8247 2 жыл бұрын
Done watching! This video lecture helps me to understand more about how to prepare a 14-columnar Worksheet and also refreshes me from previous lectures. It is just a bit overwhelming because of the accounts and numbers involved but all in all, the lesson is understandable and the examples of transactions and entries are well introduced and explained. Thank you.
@irishlacaba9699
@irishlacaba9699 2 жыл бұрын
Regards, sir. This video lesson helps me comprehend how to make a worksheet with 14 columns and reminds my memory of prior lectures. Although the accounts and numbers involved make it slightly challenging, the training is generally clear and the explanations of the instances of transactions and entries are thorough.
@aishhtkm
@aishhtkm 3 жыл бұрын
Done watching the video above, thank you sir. I can now compare and contrast my actual work and errors made.
@cayumbahm9961
@cayumbahm9961 2 жыл бұрын
Done watching po sir, its really hard to understand po but you explained well to us thank you sir.
@juliemaedeano6099
@juliemaedeano6099 2 жыл бұрын
I thought it's going to be hard but it's actually easy if you follow the steps in completing the 14 columnar sheets. Thank you sir!
@katherineabesamis4163
@katherineabesamis4163 2 жыл бұрын
Done watching. Honestly, I'm a bit confused about closing entries, but the video lecture provides precise explanation that helps me understand it better and I will re-watched it again to recall it so that I cannot forget it.
@sashenkadignum2471
@sashenkadignum2471 2 жыл бұрын
Done watching, Sir! I have learned that following the 10-columnar sheet is now the 14-columnar which includes the closing entries.
@janabanana32
@janabanana32 2 жыл бұрын
I easily understood how to continue the 10-columnar worksheet by adding the closing entries column and post-trial balance column. Although it was long, it is not that hard if you listened carefully on how the steps are done. Thank you sir!
@keithflores2771
@keithflores2771 3 жыл бұрын
Done watching sir thankyouu po Godbless po
@lukesebastianhipolito7337
@lukesebastianhipolito7337 2 жыл бұрын
thank you po sir ang galing niyo po magturo ❤😊
@tiffanyjersi3163
@tiffanyjersi3163 2 жыл бұрын
Done rewatching! Due to my expectation that it would be challenging given the 14-column table, I initially needed help understanding what you were saying, but with the examples given, I eventually did. After all, was said and done, I learned a lot from this comprehensive illustration. - 201X3, Villalobos, Tiffany Jersi E.
@mylenemaravillas8557
@mylenemaravillas8557 2 жыл бұрын
Done watching! I am still a bit confused about some but this lecture explains and illustrate that helps me understand the lecture.
@dorithyleonado
@dorithyleonado 3 жыл бұрын
Thank you po sir. Will watch it tom.
@gemariecanela4598
@gemariecanela4598 3 жыл бұрын
Done watching Sir. Thank you and God bless po❣️
@gemariecanela4598
@gemariecanela4598 3 жыл бұрын
Sir paano po pag net loss ang closing entries??
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Debit Capital account and credit Income Summary.
@gemariecanela4598
@gemariecanela4598 3 жыл бұрын
@@SirATheCPAProf noted Sir. Thank you po
@lyzeltorregosa5956
@lyzeltorregosa5956 2 жыл бұрын
Done watching sir. A, in this video lecture for me it easy to understand but there is some part that I need to pause and rewind to understand very well. I learned how to do and prepare the 14 columnar worksheet and arranged them all, I learned that if the amount is located in debit-debit just add them and if debit-credit minus them.
@roangraciebautista702
@roangraciebautista702 2 жыл бұрын
Done watching! Preparing a 14-columnar worksheet is really confusing for me because it includes all the steps in an accounting cycle. Through the clear and precise discussion given, my knowledge regarding the topic improved. Thank you po!
@clarabanagale2507
@clarabanagale2507 2 жыл бұрын
Done watching! Honestly, I'm a bit confused about closing entries, but the video lecture provides precise explanation that helps me understand it better.
@christinesamson5420
@christinesamson5420 3 жыл бұрын
Done watching Sir, thank you po!
@tiffanyreyes6725
@tiffanyreyes6725 3 жыл бұрын
Done watching po sir, thankyou po.
@rubeneusebio7163
@rubeneusebio7163 2 жыл бұрын
Thank you sir. I'm a bit confused about closing entries, but the video lecture provides precise explanation
@anjadettejao2762
@anjadettejao2762 2 жыл бұрын
Done watching sir, l am bit confused but this discussion helps me to understand more😊
@jiajuncheng585
@jiajuncheng585 3 жыл бұрын
Done watching,thank you sir
@jhamelacebo1347
@jhamelacebo1347 3 жыл бұрын
Done watching thank you sir!!
@anamariebatic-batic7304
@anamariebatic-batic7304 2 жыл бұрын
Thanks, Sir! After watching the video I gained knowledge in preparing a 14-Columnar sheet step by step. It’s still a bit hard and confusing for me, but I know I can recall this.
@windelmatthewfelix9050
@windelmatthewfelix9050 2 жыл бұрын
Good Morning sir, I already watch this video last week but I forgot to leave a comment, The video course clarifies how and where to create a 14-column spreadsheet and reinforces my recollection from earlier sessions. The banks and numbers involved are a little intimidating, but overall, the course is intelligible, and the examples of trades and entries are properly established and discussed.
@shariguanezo7230
@shariguanezo7230 3 жыл бұрын
thank you sir done watching!!
@jasperjamespalo878
@jasperjamespalo878 2 жыл бұрын
It is a bit confusing in the closing entries but in this video lecture, it is discussed very well that I was be able to understand the 14-columnar worksheet. Thank you, Sir A!
@iannejoy9247
@iannejoy9247 3 жыл бұрын
Thank you sir, done watching ✨
@rovicfernando6038
@rovicfernando6038 3 жыл бұрын
Done watching po sir, thank you po!
@jasmincosare
@jasmincosare 3 жыл бұрын
Thank you, Sir! Ang galing n'yo po mag turo ❤️
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Thank you
@rainapuyan3202
@rainapuyan3202 2 жыл бұрын
I forgot to comment on this video but I have learned more about the 14-columnar and recall some past topics discussed.
@clarisseluna9064
@clarisseluna9064 3 жыл бұрын
done na po sir!! thank you for this po :))
@lovelyanncasi5876
@lovelyanncasi5876 2 жыл бұрын
I have some confusion watching the whole video but later on, I was able to understand some process after re watching it.
@reinzehljoie4439
@reinzehljoie4439 3 жыл бұрын
done na po sir, thankyou po!!
@miccafeabilaro2244
@miccafeabilaro2244 3 жыл бұрын
Done sir. Thank you po.
@cutiepie-gx4wk
@cutiepie-gx4wk 3 жыл бұрын
Done na po sir, thank you po!
@chrisjohn7761
@chrisjohn7761 3 жыл бұрын
Done watching po sir!
@kevinatendido9138
@kevinatendido9138 3 жыл бұрын
Done po Sir. Thank you po!
@raymondperdigon4901
@raymondperdigon4901 3 жыл бұрын
thank you po sir, Done na po.
@peterbwalya5523
@peterbwalya5523 Жыл бұрын
This is a wonderful piece of tutorial except for one item which was done in reverse. This is to do with the adjustment on unearned income, the journal entry was supposed to reduce the service income and increase the unearned income figure.
@isaiahdayola9450
@isaiahdayola9450 3 жыл бұрын
Done watching po sir
@paulinequevedo626
@paulinequevedo626 2 жыл бұрын
The worksheet with 14 columns is quite lengthy, however it helps me to comprehend how to make it properly.
@cedelrosemontano9615
@cedelrosemontano9615 3 жыл бұрын
Done na po sir, mas nagets ko na po hehe
@ivanjamesparojinog9411
@ivanjamesparojinog9411 3 жыл бұрын
Thank you for this sir
@eryelmarcelino5502
@eryelmarcelino5502 3 жыл бұрын
thank you po sir!
@janlomtong3797
@janlomtong3797 3 жыл бұрын
Done watching.
@gracemasujer4177
@gracemasujer4177 3 жыл бұрын
Sir done na po huhu thankyou po 🤞🤞
@kingsilasbiso2051
@kingsilasbiso2051 3 жыл бұрын
Done na po sir!
@rachelgoopio9359
@rachelgoopio9359 Жыл бұрын
Done watching sir , can i get the link of the worksheet?
@biancadawnlicopit5717
@biancadawnlicopit5717 3 жыл бұрын
Done po sir, thank u
@erikaparajas6542
@erikaparajas6542 3 жыл бұрын
Done na po sir.
@aliahmulto1124
@aliahmulto1124 3 жыл бұрын
thank you po sir
@ashiesblog9148
@ashiesblog9148 Жыл бұрын
Sir pg dollar currency po ba ginamit sa transaction problem, dollar sign din po ba ggamitin sa pg entries
@alessandrarestauro7452
@alessandrarestauro7452 3 жыл бұрын
done sir
@luvcharls_
@luvcharls_ Жыл бұрын
San niya po kinuha ang 606,200 Closing entry Capital?
@celinemoreno5743
@celinemoreno5743 3 жыл бұрын
Done po sir, thank you po! - Panuelos, Celine
@irenezdomingo6097
@irenezdomingo6097 3 жыл бұрын
Sir I have a question po how did you get po yung … “debit” ng supplies sa unadjusted entry pati po yung “credit” ng unearned service revenue sa unadjusted entry rin po, Salamat sir
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Tignan mo yung adjusting journal entry sa baba. Winork ba natin sya. May excel file akong binigay sainyo sa Canvas.
@timothylim6528
@timothylim6528 3 жыл бұрын
Sir pag 16 columnar naman po ba si 15 and 16 column po ba ay pang reversing entry na po?
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Yes pwede
@biancaecalnir
@biancaecalnir 3 жыл бұрын
done po sir
@kingsilasbiso2051
@kingsilasbiso2051 3 жыл бұрын
Sir paano po ang closing entry kapag net loss?
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Dr capital acct, cr income summary
@kingsilasbiso2051
@kingsilasbiso2051 3 жыл бұрын
Thank you po sir!❣️
@spencerlewisalcala2786
@spencerlewisalcala2786 3 жыл бұрын
Thank you sir A. Question lang po. May possibility po ba na ang ibibigay saaming problem is unadjusted trial balance? If yes, then ang hahanapin namin is adjusted trial balance?
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Yes. Anything is possible basta solvable.
@chrystalvenusfonseca8008
@chrystalvenusfonseca8008 3 жыл бұрын
sir ask lng po pano po nag karoon ng 154,000 sa service revenue credit
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
Transaction G po.
@ryubin5176
@ryubin5176 3 жыл бұрын
Done po sir. Barrogo
@ericjovillano8852
@ericjovillano8852 4 ай бұрын
Good eve po. Can I have a copy po of the files?
@kesian-wd6wv
@kesian-wd6wv Жыл бұрын
Good day sir! Is it possible po to request the excel file that you used in your video for study purposes po? I usually forget the cycle po kasi and it will be a great help for it to be my basis. Thank u so much!!
@darayubhel6636
@darayubhel6636 3 жыл бұрын
done na po sir kahit late po. sir ask ko na lang din po kung hihingi po ba ko ng pattern(?) or format(?) ng 14 columnal sheet, okay po ba sainyo po na magbigay po or send po ng file? by the way po, still nahihirapan parin po ako mag analyze ng problem + paggamit po ng excel. thank you po sir
@SirATheCPAProf
@SirATheCPAProf 3 жыл бұрын
May copy kayo ng file sa Canvas, yung pinost ko sa Announcement
@edparaiso9218
@edparaiso9218 2 жыл бұрын
Sir hinge lang po copy ng excel kung ok lang salamat po
@johnarvhiemacaraig6221
@johnarvhiemacaraig6221 3 жыл бұрын
Done watching sir, thank you po!
@kaysiebunoan4897
@kaysiebunoan4897 3 жыл бұрын
done na po sir, thank you po!
@alyssamarcelo9093
@alyssamarcelo9093 3 жыл бұрын
thank you po sir.
@roderjeran3177
@roderjeran3177 3 жыл бұрын
Done na po sir, thank you po!!
Preparing the Worksheet & the Financial Statement Exercises MCQ Type
10:06
Sir A's Accounting Iksimplified
Рет қаралды 1,6 М.
Closing Entries and Post Closing Trial Balance
14:27
TLC Tutoring
Рет қаралды 254 М.
She made herself an ear of corn from his marmalade candies🌽🌽🌽
00:38
Valja & Maxim Family
Рет қаралды 18 МЛН
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН
CLOSING ENTRIES: Everything You Need To Know
13:59
Accounting Stuff
Рет қаралды 301 М.
How To Do A Bank Reconciliation (EASY WAY)
17:02
Accounting Stuff
Рет қаралды 1,2 МЛН
Preparing the Closing Entries | Case Analysis Illustration
16:15
Sir A's Accounting Iksimplified
Рет қаралды 5 М.
Basic Accounting | Accounting Cycle Step 5. Preparation of Worksheet (Part 2)
12:58
Filipino Accounting Tutorial
Рет қаралды 115 М.
Comprehensive Case Analysis for Adjusting Entries
24:07
Sir A's Accounting Iksimplified
Рет қаралды 6 М.
Basic Journal Entries by Saheb Academy - Class 11 / B.COM / CA Foundation
18:31
Basic Accounting | Accounting Cycle Step 5. Preparation of Worksheet (Part 1)
27:15
Filipino Accounting Tutorial
Рет қаралды 348 М.
Consumer and national debt weigh on bullish 2025 outlook
7:08
Yahoo Finance
Рет қаралды 8 М.