This one day workshop will be delivered online and has been designed for beginners or those with little Bookkeeping experience who want to learn how to build a basic excel based bookkeping system.
Outline of the course:
- Basic Financial Statements and understanding
- Profit and Loss Account explained and demonstrated
- Cost of Sales, Margin & Mark Up
- Cash Flow – managing cash, debtors, creditors, stock, bank etc
- Difference between Profit and Cashflow
- Limited Company v’s Sole Trader
- Balance Sheet
- Budgeting – Principles of and how to use
- Cashflow Mgmt – Simple forecasts and complex
Building a simple P&L accounting system on Excel from scratch – learn how to construct the sheets, use formula’s, link pages together etc. This will give you a thorough understanding of how accounts are constructed and how to record transactions.
Participants will be challenged during the course of the day to complete exercises such as;
1. Financial Accounts Model – will be asked to build their own book-keeping system using Excel from beginning to end.
2. How to record and update the accounts – learn how to input data for different headings of their business (ie Sales, Cost of Sales, Overheads, Assets etc).
