Bookkeepers: Core Principles

This page contains the free eight-week online bookkeeping course which introduces the core principles of bookkeeping and accounting.

Week 1 – Basic Accounting Principles

This video was presented and recorded on 21/01/21.

The exercises below give allow you to practice what was covered in this week’s presentation session.

Despite the exercises seeming simple, they will help create a really solid basis of understanding of how transactions end up in accounts, and how to drill down from accounts to individual transactions.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.
  The exercises are in the “Unprocessed Transactions” tab.

• Spreadsheet used in the presentation

• Presentation PowerPoint

Week 2 – Preparing Accounts – The Profit and Loss Account

This video was presented and recorded on 28/01/21.

The exercises below give allow you to practice what was covered in this week’s presentation session.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.
  The exercises are in the “Categorised Transactions” tab.

• Spreadsheet used in the presentation

• Presentation PowerPoint

Week 3 – Bank Reconciliations

This video was presented and recorded on 04/02/21.

The exercises below give allow you to practice what was covered in this week’s presentation session.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.

• Spreadsheet used in the presentation

• Presentation PowerPoint

Week 4 – Double Entry

This video was presented and recorded on 11/02/21.

The exercises below give allow you to practice what was covered in this week’s presentation session.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.

• Spreadsheet used in the presentation

• Presentation PowerPoint

Week 5 – Practical Examples

This video was presented and recorded on 18/02/21.

The exercises below give allow you to practice what was covered in this week’s presentation session.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.

• Spreadsheets used in the presentation
  * Restaurant (Goods)
  * Musician (Services)
  * Foodbank (Charity)

• Presentation PowerPoint

Week 6 – Preparing Accounts: The Balance Sheet

This video was presented and recorded on 25/02/21.

The exercises below give allow you to practice what was covered in this week’s presentation session.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.

• Spreadsheets used in the presentation

• Presentation PowerPoint

Week 7 – Balance Sheet Principles

This video was recorded on 01/03/21 for presentation on 04/03/21

The exercises below give allow you to practice what was covered in this week’s presentation session.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.

• Spreadsheets used in the presentation

• Presentation PowerPoint

Week 8 – Computer Accounting

This video was recorded on 06/03/21 for presentation on 11/03/21

The exercises below give allow you to practice what was covered in this week’s presentation session.

• Exercises
  Download or copy the exercises spreadsheet to your area of Google Drive to be able to make changes.

• Spreadsheets used in the presentation

• Presentation PowerPoint

Pre-Course Videos

Click on the link below to watch either of the two pre-course videos.

Introduction to the Accounting/Book-keeping Course

Introduction to Spreadsheets and Google Drive