Bank Reconciliation & VAT on Excel
How to use excel spreadsheets to do a bank reconciliation and complete a UK VAT Return
What you'll learn
- Learn the fundamentals of bank reconciliation and VAT codes, rates, and regulations
- Develop proficiency in using Excel spreadsheets for bookkeeping
- Gain practical experience in using a downloadable cashbook template to simplify record-keeping and financial reporting
- Calculate the VAT figures using an excel cashbook
Course content
4 sections • 22 lectures • 1h 49m total length
- 1. Flower Power - income entered (11:37)
- 2. Input opening and closing balances (1:16)
- 3. Inputting a payment onto the spreadsheet (4:22)
- 4. Flower Power expenses entered (12:51)
- 5. Bank Reconciliation (2:31)
- 6. VAT return on excel (2:18)
- 7. Bank Reconciliation & VAT on Excel (1:12)
- 8. Zoho -Reconcile the bank (7:26)
- 9. Zoho - unrec transactions report (4:26)
Requirements
- An interest in accounting - whether you've studied it before or want to know more
- Be familiar (basic level knowledge) of excel
Description
Are you tired of struggling with bank reconciliations and VAT returns? Do you want to learn how to do them quickly and efficiently using Excel? Then our Bank Reconciliation & VAT on Excel course is just what you need!
This practical course is designed for bookkeepers and small business owners who want to streamline their bookkeeping process. In just under 2 hours, you'll learn how to use Excel spreadsheets to do a bank reconciliation and have the figures to complete a UK VAT return. We'll cover everything from bank rec and nominal codes to VAT codes and rates.
What sets our course apart is that it's delivered by a bookkeeping service entrepreneur with years of experience in the field. You'll get a hands-on learning experience with a downloadable cashbook template that you can use to practice your skills.
Whether you're new to bookkeeping or looking to improve your existing knowledge, this course is perfect for you. It's ideal for those working in the accounts/finance department, starting their own business, or pursuing a career in accountancy or bookkeeping.
All you need is a basic level of competence in Excel and a desire to simplify your bookkeeping process. If you're comfortable with Excel and want to do your books on this system, then this course is for you. So why wait?Sign up now and start mastering bank reconciliations and VAT returns in no time!
Who this course is for:
- Business owners, students of accountancy / finance / bookkeeping, budding finance directors and management accountants