AAT Bookkeeping Controls: Control Account Reconciliation and reasons for differences, made easy
HTML-код
- Опубликовано: 9 мар 2019
- PRIVATE TUITION - NOW AVAILABLE
We now provide private tuition to help you master the knowledge and skills to pass your AAT exams the first time, every time.
We have a saying here at YOUvolution Learning; LUCK FAVOURS THE PREPARED!
We can help you prepare for success. Click the link below to find out more 😀
youvolutionlearning.com/priva...
In this Bookkeeping and Accounting Tutorial video, I demonstrate the key principles for tackling AAT Bookkeeping Controls general ledger Control Account Reconciliations along with a method to successfully select the correct reasons for the differences.
If you are revising for the AAT Level 2 Foundation In Accounting Synoptic you will also find useful revision tips.
I have a blog relating to this video, which you can find here:
I have added a spreadsheet to use when working through the reasons for the differences, which you can find here:
Control Account Reasons Spreadsheet
docs.google.com/spreadsheets/...
Here is the doc to explain the relationship between Control Accounts and Sales Ledger and Purchase Ledger Accounts:
drive.google.com/file/d/1TlmK...
A place for your AAT revision. Let's make you masters of the AAT content, one video at a time.
This is the third video in the AAT Bookkeeping Controls revision series:
/ @momentumpgc
You can visit my channel here:
/ @momentumpgc
www.youvolutionlearning.com
~-~~-~~~-~~-~
Please watch: "Advanced Synoptic Examiner's Report"
• Advanced Synoptic Exam...
~-~~-~~~-~~-~
Thanks Steve, this task has been driving me nuts for ages & your the 1st person to explain it in a way that makes sense. Cheers again
Omg why can't all tutors be like this. Your explanations are amazing. Thank you so much for your help!!
WOW 😮 Clare, amazing feedback, thank you. Really pleased the video has helped you. 👍
Your video's make this section much easier to understand. Very grateful!
Glad to help RainbowEllie08. 😁👍
This is so clearly explained! Really helpful for my revision for BKCL, thank you :)
I can't tell you how useful this video has been! Thank you for uploading!
You are very welcome Laura, I always find showing how something can be done really helps with grasping difficult areas.
It's been really helpful the way you explained not only in this video but others! I am so glad I've found your channel. Thank you so much!!
Thank you, this is an excellent video to understand the principles
I’ve been trying to understand this for many months and you’ve just helped me in one short video - amazing! Thank you very much!
Hey S Ali, this is definitely a tough area to grasp. Glad your struggles with this area are over. Keep practicing the techniques in the video and you will smash this in the exam.
Thank you kindly for these videos, very clear, concise thus better able to piece things together, you're a gem buddy.
Thanks for the kind comments. I am really pleased you have found them to be clear and concise and they have helped you piece the topic together 👍 best wishes for your studies 😊
Wonderful clear explanation. Thanks 🙏🏻
So helpful, thank you for taking the time to do these videos, much appreciated
Hey Miss Fantastible, I'm glad you like the videos . I enjoy making them and will be releasing some more for level 2 and 3 bookkeeping in the next few weeks.
Great explanation!Thank you very much!
You are very welcome, glad you liked the video Kujtim AJAZI 👍
Wow this is very helpful! I can't thank you enough. The explanation is easy to understand. Thank you!
Excellent, really pleased the video has helped you @izzharfiJEP. All the best for your AAT journey 😁
Really good thanks !
Cheers for the help mate I appreciate it big time. I thought me not understanding was me being stupid but after this short video it was just a couple mistakes when revising and you really did help iron them out.
Never think you are being "stupid" if you don't understand something, sometimes you just need a different angle or perspective. Glad the video has helped you. Best wishes for the rest of your studies.
I would like to thank you so much for providing us with these videos . I have exam on bookkeeping control and these playlists have actually helped me in my revision . Hopefully you will have topics for AAT Level 3 as I will be starting in September . Thank you sooo much
Hi Yasmina, thank you for your wonderful feedback, this means a lot. Level 3 videos are coming soon(ish) , hopefully they will be ready to help you.
I can't thank you enough. Thank you so so much.
No thanks needed. I am pleased the video has helped you with your studies. Best wishes for your future exams 👍
Thankyou so much for your tutorial, you made it so much easier for me, it was mind boggling to work out what will increase or decrease the balance. This spreadsheet is like magic wand. thank you once again
You are very welcome Gagan, glad the video has helped you with your studies 👍
Thank you very much for this video. I am only days away from my Bookkeeping controls exam and this has helped me a lot. Thx. :)
No problem. 👍 I am very pleased that my videos have helped you. Best wishes for you exam. Be sure to let me know how you got on 😀
I got 98%. 😊 Thank you again. Your videos are amazing.
@@moriaglundi52 wow, that is incredible. Well done and congratulations. 😄
@@moriaglundi52 you need to help me now. Congrats
Thankyou so much for making these tutorials....They are really helping me a lot with my Level 2 revision!!😊
You are very welcome Judi. I am really pleased they are assisting you with your revision. Best wishes for the exam. Let me know how you get on 👍
Thanks...is only on the 27 Jan so I have a few weeks to revise so I think I will do okay!! I will let you know!!
Brilliant video! My exam is two weeks away and this really helped 😌
Glad to help Jade. How did the exam go?
Very helpful. Doing my A level accounting this Oct
Hey Esther, best wishes for your A-levels 👍
Nice one. Thanks.
No worries Gordon, glad it has helped you.
thanks again. just to clarify, the sales ledger isn't the same as sales account which is an income account? the sales ledger is just a non-double entry system of recording SLCA values?
Hi Peter, yes that is correct. the sales and purchases ledgers are also referred to as 'memorandum' accounts, meaning 'for information'.
Thanks for this....makes a bit more sense now lol!
Glad this area makes more sense now Sarah,👍
Brillia
Thank you for this video. It’s really helped with some things I was struggling to grasp. I’m unable to retrieve the control accounts task spreadsheets via the link as it won’t load. Is there another way I can obtain them as I think it would help for practising? Thanks.
Hi Demi,
Sorry for the day in getting back to you. Do you still need access to the spreadsheet?
Hi, thanks for the video, it’s been very helpful 👍🏻 Have you got another way of accessing the spreadsheet, every One Drive link goes to a ‘Sorry something went wrong’ page 🤦🏼♀️? Thanks
Hi Colette, apologies for the delay, here is the new link docs.google.com/spreadsheets/d/1aAMJyZkAUmI310rOLegnyCm8Fj_HvJqw/edit?usp=sharing&ouid=109527458202517721447&rtpof=true&sd=true
Good afternoon and thank you for your video. Like others who have commented I would love to access the reasons spreadsheet but the link in the info and the comments, does not work. Are you able to provide an updated link? I would be really grateful. Thank you again for your content, your videos are really helping my studies. Take care
Hi Abi,
Thanks for bringing this to my attention. I have updated the link. docs.google.com/spreadsheets/d/1aAMJyZkAUmI310rOLegnyCm8Fj_HvJqw/edit?usp=sharing&ouid=109527458202517721447&rtpof=true&sd=true
I'm really pleased you have found my videos to be really useful and they are helping you with your studies. I hope your studies continue to go well and all the best for the exam. Luck favours the prepared 😁
This is a great video, please can you tell me how to download the spreadsheet.
Hi Mark,
I'm glad you like the video and it has helped you with your revision.
The link for the video is in the video's description but I have added here for you too:
ruclips.net/user/redirect?event=video_description&redir_token=QUFFLUhqa3pXRmlQVG1LcU5pai1kRmhoR2xLdm5RZjV1d3xBQ3Jtc0trMU1EaE1ERWRMSEVKWnNZQUxZSnpCcFUtUXNqbTlIS0I4dFpRdjU3YWYzZURVMk5XeEE2LUgzTUZZYkFqREtvTEV5YWNkMTBXWUNzT05nWFM5QzJvdHlSRmk5cUI1Vk14RnZzU1BETWdXRjVsS1hrRQ&q=https%3A%2F%2F1drv.ms%2Fx%2Fs%21AuXSTSnjV9Qkketss5wHY08oNjMs1A
Steve
In the video you said you would give access to the 'reason's spreadsheet, please can you let me know where i can find this spreadsheet? Your video's are so easy to understand, Thank you.
I am really pleased that my videos are helping you 👍. You can find the link in the videos description 😁
@@MomentumPGC Hi, I don't seem to be able to find the link
@@allisondavis5401 In the video description you should see something that says "SHOW MORE". Below is what you can find in there. This has the link. I have added a copy of what it looks like below for you.
"I have added a spreadsheet to use when working through the reasons for the differences, which you can find here:
Control Account Reasons Spreadsheet
1drv.ms/x/s!AuXSTSnjV9Qkketss...
Here is the doc to explain the relationship between Control Accounts and Sales Ledger and Purchase Ledger Accounts:
1drv.ms/b/s!AuXSTSnjV9QkketSB..."
Here is the link to the spreadsheet:
onedrive.live.com/view.aspx?resid=24D457E3294DD2E5!292332&ithint=file%2cxlsx&authkey=!ALOcB2NPKDYzLNQ
@@MomentumPGC Thank you for the link to the spreadsheet! Have my Bookkeeping Controls exam next Thursday 19th Dec, thank you for the videos!!
@@allisondavis5401 you are welcome. Best wishes for your exam. Be sure to let me know how you got on 👍
Hello. Thank you for the video, it really help with my understanding. Is it possible to email me the spreadsheet to help with practicing? It would be greatly appreciated.
Hi Lisa, you are welcome, I'm really pleased you like the video and it has helped with your understanding. Here is the link to the spreadsheet onedrive.live.com/view.aspx?resid=24D457E3294DD2E5!292332&ithint=file%2cxlsx&authkey=!ALOcB2NPKDYzLNQ
how can i excess this exercise ?
The link to the resource is within the video description, let me know if you can't get to it and I will send it separately.
Are you sure £41141 the total sales should entered in debit side of sales account ?
costumers as an income on their account when owes us is credit So our sales account should be on credit side. Or maybe I'm completely confused.
Hi. This question is covering how to reconcile the Sales Ledger (customer's individual accounts) with the Sales Ledger Controls Account, not the double entry for a credit sale within the General Ledger. The £41,141 DR is to the Customer Accounts within the Sales Ledger, not to the Sales income account in the General Ledger. There is no double entry relationship with the customer accounts within the Sales Ledger and that of the Sales Ledger Control account in the General Ledger. Double entry only happens within the General Ledger. The Sales Ledger is what is known as a memorandum account and is for information only, being the details of what is owed by each customer, which is not known within the Sales Ledger Control account within the General Ledger. I hope this helps?
You could've recorded a bit louder though.