Microsoft Excel: The Basics Of Bookkeeping With Excel
Skill Success
Summary
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
This course includes lifetime access so you can complete it at your own speed.
This Bookkeeping Made Simple course is about how to do a bank reconciliation and how to complete a UK VAT return on excel. This course covers terminologies such as bank rec, nominal codes, VAT (codes and rates) and how to take these figures to prepare a simple profit and loss account. This course will show you how to do bookkeeping as an excel template. The template available for download is a cashbook, so the bookkeeping will be on a cash basis. By taking this course today, you'll be able to learn a simple, effective method to do your bookkeeping!
Benefits of taking this course include:
- Unlimited and lifetime access to the course
- Learn the course at your own pace
- Course can be accessed on any platform
- 24/7 Customer support
Certificates
Certificate of completion
Digital certificate - Included
Course media
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 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.
Microsoft Excel: The Basics Of Bookkeeping With Excel will cover the following topics:
Topic 1 - Introduction
- Aims Of The Course And Intro To The Tutor
- Organizing Your Bookkeeping Records
- Computerized Systems
Topic 2 - The Theory And Manual Bookkeeping
- History And Principles Behind The Ledgers
Topic 3 - Worked Example
- Intro To Flower Power Ltd
- Enter Income Received
- Enter Expenses Incurred
Topic 4 - Bank Reconciliation
- Reconciling Items
- Recap On The Bank Reconciliation
Topic 5 - VAT Returns
- General Overview Of VAT And How It Works In The UK
- Do The VAT Return
Topic 6 - Higher Level Bookkeeping
- Adjustments
- Reporting
- Simple Profit And Loss: Month 1
Topic 7 - Homework: Month 2
- Month 2: Enter Income
- Month 2: Enter Payments
- Entering Credit Card Transaction
- Reconciling Items
- VAT Return
- Reports And Results: Month 2
Who is this course for?
This course is designed for those interested in learning about how to do bookkeeping.
Requirements
No prior knowledge is required to take this course.
Career path
Students can pursue a career of being a Bookkeeper.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.