Do Your Own Accounts
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
31 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Do Your Own Accounts to your Wishlist.

Add to Wishlist

Do Your Own Accounts

Use an excel spreadsheet to do your own bookkeeping and save yourself time, money and stress
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
31 students enrolled
Created by Lisa Newton
Last updated 2/2015
English
Current price: $10 Original price: $35 Discount: 71% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Do Your Own Accounts using a simple Excel spreadsheet
Understand what the numbers in the accounts mean for the business
View Curriculum
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.
Description

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.

Who is the target audience?
  • This course is for entrepreneurs, business owners (home based businesses) and bookkeepers who want a simple, yet effective spreadsheet system to keep track of and do their own bookkeeping
  • If your business is fairly small, home-based and you don't want to learn Sage or Quickbooks, but you are comfortable using Excel - this course is for you
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 01:39:25
+
The importance of bookkeeping
3 Lectures 17:17

Explanation of what the course is about and what we'll cover.

Preview 04:29

How to get your manual (physical) accounts organised - files, organisation etc.,

Preview 05:23

Explanation of the elements on the excel spreadsheet.

Preview 07:25
+
Worked Example
6 Lectures 46:40

How to input income, on the income side of the spreadsheet

Worked Example - inputting April income
06:39

How to enter expenses, on the expenses side of the spreadsheet

Worked Example - inputting April expenses
12:58

How to read the accounts (once the income and expenses have been entered)

Worked Example - the accounts for Month 1 - April
05:22

Worked Example - inputting May income
04:20

Worked Example - inputting May expenses
13:33

Worked Example - the accounts for Month 2 - May
03:48
+
Analysis
3 Lectures 30:54

What do the figures mean, now that you have them?

What do the figures mean?
02:57

Explanation of accounting concepts, and terminology and ideas to be aware of.

Concepts
07:30

An overview of the various accounting systems available (aside from excel spreadsheets)

Systems
20:27
+
Next steps
1 Lecture 04:34
Concluding lecture
04:34
About the Instructor
Lisa Newton
3.9 Average rating
201 Reviews
3,142 Students
80 Courses
Entrepreneur & Serial Author

Lisa Newton BA MSc FMAAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing. She formed her first company in 2004 with £150 in the same month of graduating from City University, London UK. Lisa has never had a full time 9 to 5 job in her life. She's a serial entrepreneur and author who holds directorships in various industries including telecoms, property management, publishing, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007, in 2008 Enterprising Business Award, in 2016 BE Mogul Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award. In 2015 and 2017 one of her companies won Best Bookkeeping Business London (Accountancy International Awards).

Lisa's books include: How to write a book in two weeks, Constant Cashflow, Make the most of your money, How to start your own bookkeeping business, Cosmic ordering with Vision Boards, How to Franchise Your Business and Quickbooks Online The Handbook. Some of the books are in audio-format on itunes and audible.

Lisa supports the charity The MS Society. A speaker, coach, consultant and an avid networker, Lisa enjoys meeting people and working on projects with like-minded individuals.

In her spare time, Lisa likes traveling, dancing salsa, writing books, learning languages, meditation, yoga and cosmic ordering.