تفاصيل الدورة

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, ) 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.
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
Benefits

Edplx has connections and great business relationships with respectable companies within the job industry. This plays an important role in assisting all our students searching for internships, apprenticeships and part/full time jobs. We also provide all our students with the opportunities to speak to our talented career advisors and experts. You will also be invited to career fairs to give you the chance to present yourself to potential employers, once you sign up for it.

Certification

Upon completion of the course, internationally recognised certificates that can be traced by employers are available upon completion.

Who is this Course for
  • Bookkeepers, self-employed and small business owners looking for a simple effective bookkeeping method using an excel spreadsheet
  • It's 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 Sage, Quickbooks, Xero, Kashflow etc.,
تحديث بتاريخ 31 January, 2023

المتطلبات

This course is open to all with no formal entry requirements.

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

وظائف مناسبة لهذه الدورة

Lead Bookkeeper , Accountant , Chief Accountant , Financial Analyst , Analyst Financial Control

نبذة عن معهد Edplx

Edplx is a UK based talent driven company and global leader in online courses. We are proud of helping learners in attaining real qualifications and leading them to success. We offer award body accredited online courses recognised by respected companies and organisations giving you the career and network opportunity. We are proud to work alongside with world class Instructors and Professors providing the best of education. We are on a mission to help students have access to education from all parts of the world. We believe everyone should have the opportunity to study, learn and attain a career. We offer a variety of online courses that will help focus on the subjects our learners are interested in. We ensure our students are exposed to knowledge shared  by highly professional instructors around the globe which cannot be learned in books.

Why choose us?

  • Respectable London based company 
  • Internationally recognised accredited qualifications
  • Affordable courses for everyone
  • Access to our free career advisors
  • Monthly Prize draw entry for anyone who purchases a course
  • Over 95% pass rate
  • 1 year accessibility to the course
  • PDF or hardcopy certificate available to show employers 
  • Study at your own pace anywhere 
  • Employer has access to certificate validation 
  • Tutor Support available
  • Invitation to future job fairs
عرض الجميع دورات Edplx
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Finance ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

لم تجد ما كنت تبحث عنه؟

أو