1/2025 Simple Book Keeping System Using Excel

Venue:
In-Person Venue TBC
 
Date:
06/02/2025
 
Note:
Thursday 6th February
 
Time:
10am - 4pm
 
Category:
Workshop
 

Gain a thorough understanding of how accounts are constructed and how to record transactions using Excel.

€10
Attendees
 
 

Course Outline:

  • 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 Management – Simple forecasts and complex Excel sheets
  • Useful ratio’s, what they mean and how to calculate

Participants will be challenged during the course of the day to complete exercises, both individually and as part of groups around activities 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 – as part of a group they will be asked to input data  for different headings of their business (ie Sales, Cost of Sales, Overheads, Assets etc).