Struggling with bookkeeping and not sure where to start? In this course, I show you how to manage your books simply and effectively using nothing more than an Excel spreadsheet - no expensive accounting software required.This is a practical, no-jargon course built for UK small business owners, sole traders, and anyone who wants to understand their numbers without handing everything over to an accountant. In just over two hours, I walk you through a complete bookkeeping system from scratch.What you will learn:How to set up and use a simple cashbook spreadsheet to record all your income and expensesHow to reconcile your bank statements accurately and efficiently using ExcelHow to run a VAT return using your spreadsheet — correctly, every timeHow to prepare a simple profit and loss account from your bookkeeping recordsHow to use nominal codes to categorise transactions correctly in financial statementsHow to understand and apply common accounting terminology with confidenceWhat is included:A downloadable cashbook Excel template is included — the same one I use to walk you through every example in the course. You can use it in your own business from day one.This course is ideal if you prefer to keep control of your own books without committing to monthly software subscriptions. It is a practical, proven system that works - and once you have learned it, you will never feel confused by your finances again.
What you'll learn
how to set up and use a cashbook spreadsheet
how to reconcile bank statements using Excel
how to run VAT returns
how to prepare profit and loss accounts
how to categorize transactions using nominal codes