Lifetime - Access
Bank Reconciliation & VAT on Excel
Learn how to use Excel spreadsheets to complete bank reconciliations and file UK VAT returns efficiently. Perfect for business owners and finance professionals.
Created By Lisa Newton
Get this course with 2000+ of our top related courses with personal plan.
Try Personal Plan for freeWhat You’ll Learn
- Understand the core principles of bank reconciliation and how to apply them in real-world scenarios.
- Learn the essentials of VAT in the UK, including codes, rates, and compliance regulations.
- Gain confidence using Excel spreadsheets for accurate, streamlined bookkeeping processes.
- Master practical bookkeeping using a downloadable cashbook template to organize records and calculate financial figures.
- Calculate VAT amounts directly in Excel and prepare for UK VAT submissions with ease.
Requirements
- A basic understanding of Excel functions and navigation.
- An interest in accounting or bookkeeping, whether academic or professional.
Description
Struggling with bank reconciliations and VAT returns? Tired of complex accounting software? This course is your fast-track solution to mastering both—using the power of Excel.
“Bank Reconciliation & VAT on Excel” is a focused, practical course created for bookkeepers, small business owners, and finance professionals. In less than two hours, you’ll learn how to accurately reconcile bank statements and calculate UK VAT figures—all inside a user-friendly Excel spreadsheet.
This isn’t just theory—we provide a downloadable cashbook template you’ll use throughout the course. By the end, you’ll know how to use Excel for real bookkeeping tasks like VAT calculations, nominal coding, and bank recs.
Why Take This Course?
- Delivered by an experienced bookkeeping entrepreneur who knows the challenges firsthand.
- Ideal for beginners or those looking to improve their Excel-based bookkeeping skills.
- Short, efficient format—learn everything you need without fluff or filler.
- Perfect for business owners, aspiring accountants, and students alike.
Who This Course Is For
- Small business owners looking to handle their books in Excel.
- Students of accountancy, bookkeeping, or finance seeking practical Excel experience.
- Finance department staff aiming to improve reconciliation and VAT processes.
- Anyone preparing for a role as a management accountant or finance director.
Ready to simplify your accounting tasks? Enroll today and learn how to master bank reconciliation and VAT returns—using just Excel.
Course content
1. Introduction
2. Intro to the fictitious company example - Flower Power
3. Background to VAT in the UK
4.1. Skeleton template explained
4.2. Excelvat - BKPG TEMPLATE-VAT COURSE 1607
4.3. Excelvat - BKPG TEMPLATE-VAT COURSE - COMPLETED FOR 30 JUNE 2015
1. Flower Power - income entered
2. Input opening and closing balances
3. Inputting a payment onto the spreadsheet
4. Flower Power expenses entered
5. Bank Reconciliation
6. VAT return on excel
7. Bank Reconciliation & VAT on Excel
8. Zoho -Reconcile the bank
9.1. Zoho - unrec transactions report
9.2. zoho Unreconciled transactions as at 30 June 2016 - lec 34
1.1. Enter income - month 2
1.2. Excelvat - Flower Power BANK STATEMENT
2. Enter opening and closing bank balances for July
3. Enter expenses - month 2 (July)
4. Continuing to enter expenses
5. How to deal with Credit Cards
6. Month 2 - Bank reconciliation
7.1. Month 2 - VAT Return
7.2. Excelvat - BKPG TEMPLATE-VAT - COMPLETED FOR 31 JULY 2015
1. How to organise your paperwork
2. Next steps
Similar courses
Explore More
Instructor
Lisa Newton, BA MSc AAT, is a dynamic entrepreneur and prolific author with a master’s degree in Investment Management and a first-class honours degree in Accounting with Marketing. In 2004, she launched her first company with just £150, the same month she graduated from City University, London. Remarkably, Lisa has never worked a traditional 9-to-5 job, instead carving a successful path as a serial entrepreneur.
Lisa holds directorships across diverse industries, including telecoms, property management, publishing, hair and beauty, and finance. She has received numerous accolades, such as:
Young Entrepreneur of the Year Award (2007)
Enterprising Business Award (2008)
BE Mogul Award (2016)
Best Accounting Franchisor Awards (2011 & 2012)
Best Bookkeeping Business London (2015 & 2017, Accountancy International Awards)
Books and Publications
Lisa is the author of several influential books, including:
How to Write a Book in Two Weeks
Constant Cashflow
Make the Most of Your Money
How to Start Your Own Bookkeeping Business
Cosmic Ordering with Vision Boards
How to Franchise Your Business
QuickBooks Online: The Handbook
Some of these titles are also available in audiobook format on iTunes and Audible.
Other Ventures
Lisa hosts The Authors Podcast, available on iTunes, where she shares insights and interviews with authors. She actively supports the MS Society and works as a speaker, coach, and consultant, collaborating with like-minded professionals on various projects.
Personal Interests
In her spare time, Lisa enjoys traveling, salsa dancing, writing, learning languages, meditation, yoga, and exploring cosmic ordering. She is passionate about networking and building meaningful connections.
More Courses by Lisa Newton
Recieve the best deals..
