- 108
- 511 830
Will Boardman
Приєднався 21 жов 2011
www.willboardman.co.uk
willboardman_
Any enquiries: Will-aat@outlook.com
Full video list: tinyurl.com/2ye4xunx
willboardman_
Any enquiries: Will-aat@outlook.com
Full video list: tinyurl.com/2ye4xunx
How to Create a Pivot Table and Pivot Chart in Excel (SIMPLE SOLUTIONS with EXAMPLES)
Within this video I'll walk you through how to create a pivot table and a pviot chart!
Thank you for watching the video and supporting the channel! Links below:
willboardman_
www.linkedin.com/in/will-boardman
will-aat@outlook.com
📚 Looking for the best AAT study material?
accountext.co.uk/
Use code: "will20" for 20% off your order.
☕ Looking for the best coffee to help you focus?
londonnootropics.com/
Use code: "Willboardman" for 15% off.
#accounting #accountingexam #accountingeduction #exampreparation #accountingtips #finance
Thank you for watching the video and supporting the channel! Links below:
willboardman_
www.linkedin.com/in/will-boardman
will-aat@outlook.com
📚 Looking for the best AAT study material?
accountext.co.uk/
Use code: "will20" for 20% off your order.
☕ Looking for the best coffee to help you focus?
londonnootropics.com/
Use code: "Willboardman" for 15% off.
#accounting #accountingexam #accountingeduction #exampreparation #accountingtips #finance
Переглядів: 400
Відео
How to do an IF Statement, Countif and Sumif in Excel (SIMPLE SOLUTIONS with EXAMPLES)
Переглядів 34114 днів тому
Within this video I'll walk you through how to do an If statements, Countif and Sumif in Microsoft Excel. Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" for 20% off your order. ☕ Looking for the best coffee...
How to do a Vlookup and Hlookup in Excel (SIMPLE SOLUTION with EXAMPLES)
Переглядів 70021 день тому
Within this video I'll walk you through how to do vlookup and hlookup in Microsoft Excel. Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" for 20% off your order. ☕ Looking for the best coffee to help you foc...
How to do a Bank Reconciliation with Examples (SIMPLE METHOD!)
Переглядів 898Місяць тому
Within this video I'll walk you through how to do a bank reconciliation in accounting. Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" for 20% off your order. ☕ Looking for the best coffee to help you focus?...
AAT Level 4 - INAC Examiners Report Review
Переглядів 551Місяць тому
Within this video I'll be taking you through the internal accounting systems and control (INAC) examiners report and adding my thoughts! Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" for 20% off your order...
Prepaid Income Explained (SIMPLE METHOD WITH ACCOUNTING ENTRIES)
Переглядів 668Місяць тому
Within this video I'll walk you through how to account for prepaid income within your accounts. This video forms part of the accruals concept of accounting which states goods or services are to matched with the period that they took place. It's also known as the matching concept. Thank you for watching the video and supporting the channel! Links below: willboardman_ www.linkedin....
How to Balance off Accounts in Accounting (Balancing T Accounts with Examples)
Переглядів 1,4 тис.Місяць тому
Within this video I'll be taking you through how to balance off accounts within accounting. I'll also be explaining what the purpose is and why it's useful for the business with a couple of examples. Thank you for watching the video and supporting the channel! Links below: Trial Balance Tutorial: ua-cam.com/video/6N1JRYSQ2Hw/v-deo.html willboardman_ www.linkedin.com/in/will-board...
Which AAT Level Should I Start on?
Переглядів 5072 місяці тому
Within this video I'll be trying to answer the question Which level AAT should I start on? Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full library of videos: tinyurl.com/2ye4xunx 📚 Looking for the best AAT study material? accountext.co.uk/ Use code...
AAT Level 2 - Qualification Overview (and Considerations!)
Переглядів 1,7 тис.2 місяці тому
Within this video I'll be looking at the AAT level 2 Qualification, its structure and whether you should be looking at the bookkeeping or accounting route. Thank you for watching the video and supporting the channel! Links below: Self-employed licence information: www.aat.org.uk/membership/licensed-membership-be-your-own-boss Find an AAT assessment venue: www.aat.org.uk/assessment-venues/search...
6 Reasons you SHOULD become an Accountant
Переглядів 1 тис.2 місяці тому
Within this video be going through 6 reasons you should become an accountant. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full library of videos: tinyurl.com/2ye4xunx 📚 Looking for the best AAT study material? accountext.co.uk/ Use code: "will20" fo...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 4
Переглядів 1,1 тис.3 місяці тому
Within this video I'll be walking you through Task 7 and 8 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 3
Переглядів 1 тис.3 місяці тому
Within this video I'll be walking you through Task 5 and 6 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 2
Переглядів 1,5 тис.3 місяці тому
Within this video I'll be walking you through Task 3 and 4 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
AAT Level 4 - Applied Management Accounting (AMAC) - Mock Exam Walkthrough - Part 1
Переглядів 2,7 тис.3 місяці тому
Within this video I'll be walking you through Task 1 and 2 of Applied Management Accounting. This is covering mock two from the AAT website. Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? willboardman_ www.linkedin.com/in/will-boardman will-aat@outlook.com Link to my full libra...
Going from AAT Level 3 to AAT Level 4 - BE PREPARED!
Переглядів 2 тис.4 місяці тому
Within this video I'll be walking you through some key points you should know going from AAT level 3 to level 4. AAT results calendar: www.aat.org.uk/prod/s3fs-public/assets/AAT-Q2022-EPA-result-release-dates-synoptic-calendar-2023-2024.pdf Thank you for watching the video and supporting the channel! Links below: www.willboardman.co.uk - Looking for AAT revision and additional mock exams? insta...
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 4
Переглядів 1,4 тис.4 місяці тому
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 4
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 3
Переглядів 1,8 тис.4 місяці тому
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 3
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 2
Переглядів 1,8 тис.4 місяці тому
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 2
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 1
Переглядів 3,4 тис.5 місяців тому
AAT Level 4 - Drafting and Interpreting Financial Statements (DAIF) - Mock Exam Walkthrough - Part 1
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 2
Переглядів 3 тис.5 місяців тому
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 2
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 1
Переглядів 4,9 тис.5 місяців тому
AAT Level 2 - Business Environment (BENV) - Mock Exam Walkthrough - Part 1
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 2
Переглядів 4,4 тис.6 місяців тому
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 2
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 1
Переглядів 6 тис.6 місяців тому
AAT Level 3 - Tax Processes for Business (TPFB) FA23 Mock Exam Walkthrough - Part 1
6 Ways to Study AAT (Cheapest to Most Expensive!)
Переглядів 1,7 тис.6 місяців тому
6 Ways to Study AAT (Cheapest to Most Expensive!)
5 Benefits of Completing the AAT Qualification
Переглядів 2,9 тис.7 місяців тому
5 Benefits of Completing the AAT Qualification
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 2
Переглядів 4,7 тис.7 місяців тому
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 2
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 1
Переглядів 9 тис.7 місяців тому
AAT Level 2 - Principles of Bookkeeping Controls (POBC) - Mock Exam Walkthrough - Part 1
The Statement of Financial Position Explained - Sole Trader (FULL EXAMPLE)
Переглядів 1,5 тис.7 місяців тому
The Statement of Financial Position Explained - Sole Trader (FULL EXAMPLE)
Hi Will, I purchased your TPFB mock exam and I really liked that it wasn't a carbon copy of the AAT mocks, but still tested the relevant knowledge! The only thing I don't really understand is how to interpret leaving the flat rate scheme in the reference material, as I've not had it covered in any of the revision material I've done. What does it mean by "On the anniversary of joining"? Will they need to tell you the date of joining in the question so you can work out the anniversary date? And if there is a similar question to Task 1d 13:19 where, instead of the annual accounting scheme, they are asking about when the business must leave the flat rate scheme, what answer do they want - the month the business exceeds £230,000 VAT inclusive total turnover, or on the anniversary of joining the scheme? Thanks!
Clearly explained as always. Thank you.
Hi, Thanks Will this is great. Q= Task 3 (ii) doesn't purchase of inventory increase assets?
Thank you! Explanation and workings were easy to understand and follow.
At 5:54, I’m having trouble understanding why the Employers NI is an expense rather than a liability?
7:29 Hi Will, thank you for this note about only ever increasing boxes 1 and 4 when correcting errors on previous VAT returns. I think I finally understand what they want from these net difference questions. Previously, I didn't understand why my answers were marked wrong in practice questions when I entered it the opposite way around e.g. decrease output VAT instead of increase input VAT (so it has the same net effect on VAT payable/reclaimable) . I just wanted to ask what you mean by 'it is different if it is from the current period"? Are you referring to the fact that VAT on purchase credit notes is a deduction from box 4 and VAT on sales credit notes is a deduction from box 1? Thank you in advance!
Thank you sir you earned a sub ❤
Your video helped a lot, however I didn’t do well in my first mock and I know I should go over and review the answers. My exam is in just over 10 days? What’s the best way to get through this. I study l3 MATS
Have you watched the mock walkthrough?
Will you be doing any videos on Cash and Financial Management?
Bless you! I’ve got all the answers I need for starting AAT! Thanks 🙏 Just a quick question , do I need to have GCSE results done before taking Level 2 courses ? Or it’s not necessary?
No you can make a start whenever you’re ready :)!
Thanks Will!
Would absolutely love a video on what the lvl 4 optional units contain. Especially what the recommendations might be if you are planning to go onto CIMA vs ACCA/ management vs financial. But again, another really helpful video here Will! Thank for everything you do!
Hi Will Q5 'State why they should not speak to the client about it before taking an action to report the behaviour' I wrote, this would be seen as 'tipping off' and for this offence you could receive 5 years imprisonment and an unlimited fine - would I not need to put this as additional information as its not specifically ask what is the punishment but rather, state why they shouldn't? Would I lose marks if I included this also?!
No you wouldn’t lose marks for adding that on too, it’s a good point to include!
Hi will can u please do the practice assessment 2 for level 2
I don't get it at all. I passed my text book and all the questions but in here I lost 50% . Any advise how to get on proper track ?
what happened if i fill out year 4 and 5?
You’d be absolutely fine :)! You wouldn’t lose marks for that
Thank you
Are you going to do a video on the other Business awareness mock on AAT?
At some point yes but I’m not sure when!
A bit confused of the wastage. It says the wastege is excluded from 2kg usage/unit, so my understanding is additional 10% wastage on the top of 2kg which is 0.2kg/unit, 17100units*0.2kg =3420
So effectively your good units equate to 90% of what goes through production with 10% being wasted. So you don’t want to add 10% on top because what you’re calculating there is 10% of the 90%. You need to work back to 1% then multiply by 100 to get back to the total amount required including wastage.
Similar problem,got my level 3 now doing level 4 but no luck with job.i was raising my kids and 38 now .its soo hard to get job.
It is challenging! But keep applying because it will happen. Try use skills you’ve picked up from other work and show how that would be useful in an accounting role.
Im a beginner with no experience with bookeeping. I only know the basics about it and my exam is coming soon. I wanted to ask on minute 25:20 Why is the cash sales, VAT and receivable ledger account goes on Credit? I thought receivables goes on Debit. I just wanted a more informative explanation about it. Thank you very much 😊
Ah so this is referring to the payment of those receivables. So when recording the credit sale we’d debit the receivables to show the amount owed. But once it was paid by the customer this needs to be reduced down by debiting the cashbook and crediting the receivables.
Sorry to sound stupid - but if the company buys £180.00 worth of stationary, I can understand that the stationaly account has a debit - but why would the bank have a credit? Am I getting confused with the bank 'account' and the bank 'balance' as the bank balance would surely be debited by £180 after spending that amount on stationary as a purchase?
The bank on an accounting system is the opposite of your personal account :)! So a debit is an increase to the balance and a credit is a decrease.
Great job. Is there a video on prepaid expenses?
There is :) if you click on my channel and then search it should come up
Hi Will, thank you for these videos, i've been using them for Level 2 and Level 3 and they've been awesome! Just a question regarding Task 2 - Question b We use a learning provider called Mindful and their questions on prepaid expenses include debiting the account with the full amount of the transaction and then crediting the prepaid amount so for example it would be DR 4500 (Bank) and CR 2625 (Prepaid Expenses) Is there a reason why this wasn't included in your answer or why Mindful includes it within theirs? Thanks again!
Hi Ben - that does seem a little strange to me because if you were to do it like that the double entry wouldn't match up because (in the example you've given there) your debits are higher than your credits. Is there another entry they've provided?
@@Willboardman thank you for your reply, i've dropped you a message on instagram as i may be able to send you a snippet of the question im on about if thats ok?
That’s how I’ve been trained too. Debit the expense with the full amount as been paid out of the bank in that year, but credit the expense with the amount prepaid for the following period.
Ahhhhh just seen, the cash book figure includes the paid insurance invoice
Thank you Will, you are the best at explaining
Please keep all your vids going, Will. Second career person here. Level 2 & 3 passed, struggling with motivation for Level 4 as I'm now in a non accounting role but determined to finish AAT!
VLOOKUP and HLOOKUP have been superseded by XLOOKUP in MS 365. If you don't have MS 365 then INDEX & MATCH is a far better lookup formula, for large datasets it uses less processing power, and also looks up left to right and right to left, VLOOKUP only looks up left to right.
Amazing as always, thanks Will! Just wondering does the F4 to lock cell values work in an aat exam?
Fab thanks Will, i know your busy but hoping you will do a walk through on a few other excel questions in MATs I.e IF, conditional formatting, charts 😁
Hopefully so, that’s the plan :)
Can you do AAT Level 2 in accounting and once completed apply for the AATQB license as you’ve done the 2 units of bookkeeping as well?
Hi, you’ll need to do the level 3 bookkeeping units (FAPS, and TPFB) in order to apply for AATQB
Could you please explain the debit and credits for 5c
So the debits here are expenses to the business, the credits are all liabilities because they are not paid immediately :)
Are you able to do another AAT mock exam, your explanations are good.
Very helpful, thank you!
Will, i could kiss you. Keep on the good work. AAT till i die
Thank you for such useful videos. I just watched your video on ways of studying aat. I'm thinking to study the book keeping cpurse. For self study which books would your recommend? And could you kindly recommend any providers for the 'Organised self study'? And finally, if I want to enter the work market ASAP,, is it better to study the accounting course or just the bookkeeping course? Thank you
Hi, I would recommend the accountext books, if you use code will20 you’ll also get 20%. In my opinion these are the best to self study with. In terms of the provider have a look at Training Link!
Thank you Will its really very useful.
Amac links are not in the library links
Thank you so much for another fantastic video. Such a big help!
do you have any recommendation in which order the standards should be studied?
my unicorn loves, big red mangos, and then add another 'm' (sounds insane but im using it :D) = M=UxL, B=R-M, M=B+M
Hi Will, in the last question (task 4 f), you explain that a sales return will decrease assets as our trade receivables have decreased, but on the other hand, our stock (inventory) would increase, which is an asset. I am so confused.
So it’s referring to the entires for the sales return, this would be to debit sales returns, debit vat and credit trade receivables. So the entries for the return itself would not increase the inventory. The inventory would be picked up when doing the valuation in a separate journal
Do you have video regarding trial balance adjustments?
this was so helpful tysm😊 but i’m confused as to why receipts are recorded on the credit side could u explain pls!
No problem, they’re recorded on the credit side because it reduces the asset (the amount owed to the business). So a debit to receivables increases the total amount owed to the business. A credit to the receivables reduces the total amount owed. So when the customer pays this reduces the amount owed to the business. We’d therefore credit the receivables and debit the bank.
Great video! Hopefully the Mock 1 practice assessment will be released before my exam🤞 as I find it very helpful !
If you did level 4 via Distance learning would you recommend waiting for results before starting next module (incase you fail exam) or carry on to next module once you've sat your exam? Also which optional choices would you select as the best ones?
I’d make a start on the next unit and then if you were to unfortunately fail then I’d leave off the new unit and go back to the old unit!
What abou if we don’t have enough money ro cover the “issues”
It says in the scenario that our major competitor stopped trading in November, which would account for the significant difference between budgeted and actual sales in December and the trend continuing into January. Would this be OK to mention in my answer? Something like "Following the market exit of one of the competitors, sales increased overtaking budgeted sales numbers by a significant amount. It may be usuful to monitor for similar market changes in the future to react quickly and adjust stock levels when necessary in order to take advantage of the gap in the market. This should also be a factor in budgeting for incoming months, to ensure enough cards are produced, especially around card-centered holidays." Or would this be incorrect as I refer back to the scenario and not the graph only?
When you advise mentioning resigning if the issue is not addressed, can further whistle blowing or reporting the firm/s to external controllers be mentioned as well, or would that we seen as an 'overkill' by the examinator? My instinct would be to resign and tell someone that one company is faking their accounts and another let's them do it, but maybe that's not the escalation process included in the syllabus?
I only just started on this unit and I know it's only one mock (half of one actually) but I found this really easy. I genuinely was able to answer all the questions with the knowledge I have now and common sense... I don't know if it's good or bad, because I am now motivated to book my exam for this year, but I also understand that it can't be that easy, and I am bound to encounter stumbling blocks in the syllabus. Need to rain in the wild horses :) Off to see part 2!
Definitely doable before the end of the year! Not a huge unit by any means.