Bank Reconciliation & VAT on Excel
4.5 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
32 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Bank Reconciliation & VAT on Excel to your Wishlist.

Add to Wishlist

Bank Reconciliation & VAT on Excel

How to use excel spreadsheets to do a bank reconciliation and complete a UK VAT Return
4.5 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
32 students enrolled
Created by Lisa Newton
Last updated 5/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of the course you will be able to do a bank rec on excel
  • You'll be able to run a VAT return on excel
View Curriculum
Requirements
  • An interest in accounting - whether you've studied it before or want to know more
  • Be familiar (basic level knowledge) of excel
Description

The course is about how to do a bank reconciliation on excel and how to complete a UK VAT return on excel.

We'll cover terminology such as bank rec, nominal codes, VAT (codes and rates).

The course will take approx 1 hour to complete.

The course is structured in such a way to show you how to do bookkeeping using an excel template. This template is included to download so that you can have a go at using this yourself.

The template is a cashbook, and the bookkeeping is done on a cash basis. The template is in the form of a Microsoft Excel spreadsheet, version 2003, thus you will need Excel 2003 or a newer edition (2007, 2010...) in order to open the spreadsheet.

Once the bookkeeping is done, these figures can then be used to complete the VAT return. The VAT return is based on the UK laws and rules. The course shows you how to use the figures to do the VAT return.

The template has codes embedded which are the nominal codes. The course covers what nominal codes are and how they work with the template.

There is a worked example of a bank reconciliation.

It's an ideal course if you are working in the accounts / finance department and/or if you are thinking of embarking on a career in accountancy or bookkeeping and part of your requirement is to run the VAT return or do the bank rec and report back to the owners of the firm.

If you are thinking of starting your own business and want to understand how to do a bank rec and VAT on excel, then this course is for you.

If you have already began a business, and want a simple, effective method to do your bookkeeping - then this course is for you.

You need to know how to navigate around excel - a basic level of competence is needed. The template is sufficient for you to use in your own business. If you're comfortable with excel and prefer to do your books on this system, and not a specific accounting software, then you'll find this course useful.

Who is the target audience?
  • Business owners, students of accountancy / finance / bookkeeping, budding finance directors and management accountants
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
01:40:31
+
Introduction to the course
4 Lectures 19:46



Excel bookkeeping template - how to fill it in.

Skeleton template explained
07:51
+
Bank Reconciliation
6 Lectures 34:54
Flower Power - income entered
11:37

Input opening and closing balances
01:16


Flower Power expenses entered
12:51

Bank reconciliation for Flower Power.

Bank Reconciliation
02:31

Completing a VAT return using excel.

VAT return on excel
02:18
+
Month 2 (July)
7 Lectures 35:30
Enter income - month 2
06:29


Enter expenses - month 2 (July)
04:18

Continuing to enter expenses
06:10

How to deal with Credit Cards
13:03

Month 2 - Bank reconciliation
01:17

Month 2 - VAT Return
02:44
+
Concluding lecture
2 Lectures 10:21
How to organise your paperwork
08:41

Well done for completing the course.

Other units in this series include: bookkeeping systems, breakeven analysis and pricing, cashflow management and forecasting, numbers for the business plan and how to read a profit and loss account and balance sheet.

Next steps
01:40
About the Instructor
Lisa Newton
4.0 Average rating
339 Reviews
4,233 Students
100 Courses
Entrepreneur, Infopreneur & Serial Author

Lisa Newton BA MSc AAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing. She formed her first company in 2004 with £150 in the same month of graduating from City University, London UK. Lisa has never had a full time 9 to 5 job in her life. She's a serial entrepreneur and author who holds directorships in various industries including telecoms, property management, publishing, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007, in 2008 Enterprising Business Award, in 2016 BE Mogul Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award. In 2015 and 2017 one of her companies won Best Bookkeeping Business London (Accountancy International Awards).

Lisa's books include: 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 and Quickbooks Online The Handbook. Some of the books are in audio-format on itunes and audible.

Lisa hosts her own show The Authors Podcast which can be found on the iTunes channel.

Lisa supports the charity The MS Society. A speaker, coach, consultant and an avid networker, Lisa enjoys meeting people and working on projects with like-minded individuals.

In her spare time, Lisa likes traveling, dancing salsa, writing books, learning languages, meditation, yoga and cosmic ordering.