Bookkeeping in Excel
Basic Bookkeeping Using the WYCAS Cashbook Tutorial
In this tutorial video you will learn how to use Excel for accounts, including how to record transactions on to an Excel spread sheet for beginners. You can download a free WYCAS Cashbook on our website here.
Please note: Clicking the time links below will take you to the relevant section of the same video in YouTube.
Timestamps:
- 0:00 Introduction
- 1:05 What the spreadsheet can and can’t do
- 3:20 Accessing the template
- 4:40 Overview of the spreadsheet
- 12:38 Example – setting up the Details tab
- 15:33 Example – setting up and recording bank transactions
- 42:19 Example – Reconciling
- 49:50 Example – Petty cash recording
- 51:10 Overview of the reports
- 53:38 Problems and opportunities
- 1:00:25 Contact details
Our Basic Bookkeeping in Excel course takes place online over Zoom every month. The course is free and for Accountancy groups and organisations only. To find out more please visit our ‘current training’ page here.