Bookkeeping Made Simple

Learn how to account for VAT (UK) and do your bookkeeping using a simple excel spreadsheet method
5.0 (3 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.
18 students enrolled
Instructed by Lisa Newton Business / Finance
$20
Take This Course
  • Lectures 22
  • Contents Video: 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course 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). Plus we'll look at how to take these figures to prepare a simple profit and loss account.

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.

What are the requirements?

  • You will need to have excel 2003 (spreadsheets) or later e.g. 2007, 2010 version - as you'll be given a template to download and you need to be able to open it

What am I going to get from this course?

  • Complete a bank reconciliation on excel
  • Run a VAT Return using excel
  • Do their bookkeeping using a simple spreadsheet
  • Understand common accounting terminology

What is the target audience?

  • Bookkeepers, self-employed and small business owners looking for a simple effective bookkeeping method using an excel spreadsheet
  • Its not for you if your business is growing and you need a 'proper' accounting software - take a look at one of our courses for actual bookkeeping software e.g. Sage, Quickbooks, Xero, Kashflow etc.,

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Aims of the course and intro to the tutor
Preview
04:18
Organising your bookkeeping records
Preview
08:41
Computerised systems
07:02
Section 2: The theory and manual bookkeeping
History and principles behind the ledgers
13:55
Section 3: Worked example
Intro to Flower Power Ltd
01:42
Download the template - explanation of the tabs
02:24
Enter income received
07:26
Enter expenses incurred
12:17
Section 4: Bank reconciliation
Reconciling items
05:08
Recap on the bank reconciliation
03:37
Section 5: VAT Returns
General overview of VAT and how it works in the UK
07:53
Do the VAT return
04:24
Section 6: Higher level bookkeeping
Adjustments
12:36
Reporting
03:38
Simple Profit and Loss - Month 1
05:09
Section 7: Homework - Month 2
Month 2 - enter income
07:53
Month 2 - enter payments
07:29
Entering credit card transactions
06:29
Reconciling items
06:01
VAT return
04:02
Reports and results - month 2
03:26
Section 8: Conclusion
Next steps
Preview
01:40

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Lisa Newton, Entrepreneur & Serial Author

Lisa Newton BA MSc FMAAT 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, software, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007 and in 2008 Enterprising Business Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award.

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

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 and cosmic ordering.

Ready to start learning?
Take This Course