Brief Introduction
Use An Excel Spreadsheet To Do Your Own Bookkeeping And Save Yourself Time, Costs And StressDescription
This course is for the self-employed, busy, business owner/manager who is looking for a simple, easy way to do their bookkeeping using an excel spreadsheet. Likewise, it is ideal for the bookkeeper who is looking for a simple way to do their clients accounts.
With the course you get a reusable template excel spreadsheet which acts as a cashbook, as well as prepares a profit and loss for you – which will help you to submit your self assessment tax return (UK filing) – and its also (due to complying with international accounting standards) suitable globally, for providing a profit and loss account.
The course looks at a fictitious company and it takes two months worth of bank statements. We use this information and enter it into the cashbook, which then provides the basis for the accounts. The accounts are populated automatically on the spreadsheet, based on the figures typed into the cashbook.
The template excel cashbook is included, and you download the fictitious company bank statements. In real life, you’d simply use your own bank statements to fill in the cashbook.
The course will take approx 90 minutes to complete. With the course tutor, you enter month 1 together, then you have a go at month 2 by yourself, and then watch the lecture to see if you got month 2 correct. We then go a step further by looking at some accounting concepts, and the physical aspects of keeping accounting records.
It’s an ideal course if you just want a simple, but very effective many to manage your small business bookkeeping using an excel spreadsheet. No accounting knowledge is needed or presumed. You can use this template to do your own accounts, and then send it to your accountant. With the accounts now in a much better shape, you should ask for a reduction in accountancy fees, so their course should save you time and money.
Requirements
- Requirements
- You will need to be able to open up an excel 2003 document on your computer. BASIC excel skills are needed. There are no formula's etc., because the template has everything, but you need to be able to navigate through a spreadsheet.
Lisa Newton
4.4 Raiting
Build a Social Network from Scratch: JavaScript PHP + MySQL
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn JavaScript, PHP and MySQL by building the ultimate social network website from scratch! The complete guide! Join over 5,000 students and be a part of this Udemy rated BEST SELLING course!...
Digital Marketing Tips For Online Course Creators
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Simple and effective online marketing strategies to market your online courses and build your email list from scratch. "A must-have course for online marketing....
Draw a Realistic Pencil Portrait from a Photograph
- 2.7
-
![]()
![]()
![]()
![]()
![]()
Improve Your Drawing Skills with These Tips from a Portrait Artist Today might be your lucky day! Because today, we're going to learn about portrait drawing with pencils....
Content Strategy for Professionals: Capstone Project
- 4.7
-
![]()
![]()
![]()
![]()
![]()
The Capstone Project will let you demonstrate all that you have learned throughout the Content Strategy Specialization. Capstone Overview and Directions...
