What you'll 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
An interest in accounting – whether you’ve studied it before or want to know more
Be familiar (basic level knowledge) of excel
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 this course is for :
Business owners, students of accountancy / finance / bookkeeping, budding finance directors and management accountants
Course Size Details :
1.5 hours on-demand video
7 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of completion
People also Search on Google
- free course download
- download udemy courses on pc
- udemy courses free download google drive
- udemy courses free download
- udemy online courses
- online course download
- udemy course download
- udemy paid course for free
- download udemy paid courses for free