• Course Categories
    • Business
    • Finance
    • Personal Development
    • Productivity
    • Marketing
    • Trading
    • Design
    • Health & Fitness
    • Languages
    • Videography
    • Photography
    • Web Development
  • Cart
  • Gift Bundles
  • Popular courses
  • All Courses
  • All Access Pass
      • Sign UpLogin
    Edplx Online CoursesEdplx Online Courses
    • Course Categories
      • Business
      • Finance
      • Personal Development
      • Productivity
      • Marketing
      • Trading
      • Design
      • Health & Fitness
      • Languages
      • Videography
      • Photography
      • Web Development
    • Cart
    • Gift Bundles
    • Popular courses
    • All Courses
    • All Access Pass
    • Browse
    • Cart
    • All Access Pass
      • Sign UpLogin
      • Build
      • Business
      • Finance
      • Personal Development
      • Productivity
      • Marketing
      • Trading
      • Create
      • Design
      • Health & Fitness
      • Languages
      • Photography
      • Videography
      • Web Development
      • All Courses
      • Gift Bundles
      • Popular Courses
      • Live Courses

      Business

      • Home
      • All courses
      • Business
      • Bookkeeping Made Simple

      Bookkeeping Made Simple

      Admin bar avatar
      admin
      Business, Finance
      £99.00
      Buy Membership
      A311
      • Overview
      • Curriculum

      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 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-

      • 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 bank rec and VAT on excel.
      • If you have already begun a business, and want a simple, effective method to do your bookkeeping.

      Why choose Edplx?

      • Internationally recognised accredited qualification
      • Access to our free career advisors
      • Approved UK Learning Centre
      • 1 year accessibility to the course
      • Attain PDF or hardcopy certificate to show employers
      • Study at your own pace anywhere
      • Employer has access to certificate validation
      • Tutor Support available Monday-Friday
      • Invitation to job fairs

      Course Curriculum

      This Course will cover some of the following topics:-

      Introduction

      • Aims of the course and intro to the tutor
      • Organising your bookkeeping records
      • Computerised systems
      • Downloadable Resource

      The theory and manual bookkeeping

      • History and principles behind the ledgers

      Worked example

      • Intro to Flower Power Ltd
      • Download the template – explanation of the tabs
      • Enter income received
      • Enter expenses incurred

      Bank reconciliation

      • Reconciling items
      • Recap on the bank reconciliation

      VAT Returns

      • General overview of VAT and how it works in the UK
      • Do the VAT return

      Higher-level bookkeeping

      • Adjustments
      • Reporting
      • Simple Profit and Loss – Month 1

      Homework – Month 2

      • Month 2 – enter income
      • Month 2 – enter payments
      • Entering credit card transactions
      • Reconciling items
      • VAT return
      • Reports and results – month 2

      Conclusion

      • Next steps

      Course Features

      • Lectures 23
      • Quizzes 0
      • Duration 2h 22m
      • Skill level All levels
      • Language English
      • Students 303
      • Certificate No
      • Assessments Yes
      CoursesFinanceBookkeeping Made Simple
      • Introduction 4

        • Lecture1.1
          Aims of the course and intro to the tutor 04 min
        • Lecture1.2
          Organising your bookkeeping records 09 min
        • Lecture1.3
          Computerised systems 07 min
        • Lecture1.4
          Downloadable Resource
      • The theory and manual bookkeeping 1

        • Lecture2.1
          History and principles behind the ledgers 14 min
      • Worked example 4

        • Lecture3.1
          Intro to Flower Power Ltd 02 min
        • Lecture3.2
          Download the template – explanation of the tabs 03 min
        • Lecture3.3
          Enter income received 08 min
        • Lecture3.4
          Enter expenses incurred 12 min
      • Bank reconciliation 2

        • Lecture4.1
          Reconciling items 05 min
        • Lecture4.2
          Recap on the bank reconciliation 04 min
      • VAT Returns 2

        • Lecture5.1
          General overview of VAT and how it works in the UK 08 min
        • Lecture5.2
          Do the VAT return 05 min
      • Higher level bookkeeping 3

        • Lecture6.1
          Adjustments 13 min
        • Lecture6.2
          Reporting 04 min
        • Lecture6.3
          Simple Profit and Loss – Month 1 05 min
      • Homework - Month 2 6

        • Lecture7.1
          Month 2 – enter income 08 min
        • Lecture7.2
          Month 2 – enter payments 08 min
        • Lecture7.3
          Entering credit card transactions 07 min
        • Lecture7.4
          Reconciling items 06 min
        • Lecture7.5
          VAT return 04 min
        • Lecture7.6
          Reports and results – month 2 04 min
      • Conclusion 1

        • Lecture8.1
          Next steps 02 min
      • Overview
      • Curriculum
      £99.00
      Buy Membership
      • Share:

      You May Like

      Copywriting Beginner To Advance Read More
      Admin bar avatar
      admin

      Copywriting Beginner To Advance

      497
      £99.00
      Stock Trading & Investing Diploma Read More
      Admin bar avatar
      admin

      Stock Trading & Investing Diploma

      1068
      £99.00
      Introduction to Web development Read More
      Admin bar avatar
      admin

      Introduction to Web development

      877
      £99.00
      Python 3 Programming Complete Course Read More
      Admin bar avatar
      admin

      Python 3 Programming Complete Course

      254
      £99.00
      Pilates For Beginners Read More
      Admin bar avatar
      admin

      Pilates For Beginners

      1358
      £99.00

      Categories

      • Business
      • Design
      • Finance
      • Health
      • Language
      • Marketing
      • Personal Development
      • Photography
      • Productivity
      • Technology
      • Trading
      • Videography

      Edplx is learning community with online courses in design, business, web development, photography, fitness and more. Anyone can join the community to learn cutting-edge skills, network with other creatives and discover new oppotunities.

      Company
      • About
      • Blog
      • Contact
      • FAQ
      Community
      • Become an Instructor
      • Redeem Voucher
      new-logo

      @2022 All rights reserved. Privacy Policy and Terms and condition.

      Facebook-f
      Youtube
      Twitter
      Instagram

      Connect with

      Login with Facebook

      logo

      Login

      Connect with

      Login with Facebook

      logo


      Lost your password?

      Not a member yet? Register now

      Sign up with your Email

      Are you a member? Login now

      • Login
      • Sign Up
      Forgot Password?
      Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.