SMALL BUSINESS ACCOUNTS Using Excel

Tutor: Sarah McGuinness BA(Hons) ACCA T/a SM Accounting Solutions

Programme Duration: 18^th & 25^th October  9.30a.m. to 5p.m.

Venue: County Buildings, Mullingar

This course is delivered by a chartered certified accountant and tax advisor Sarah McGuinness, who has nearly twenty years experience working with sole traders and limited companies. This course is designed as a workshop with opportunities to participant and contribute. The aim of the course is to give the participants confidence in working with their business’s books and records, and the knowledge needed to keep proper books of account and to deal with Revenue obligations. It will also give participants an understanding of small business accounts, especially the Profit and Loss Account and its impact on the business, it’s future and the business’s income taxes.

Day 2 of this course will introduce participants to setting up a simple, straight-forward, user-friendly bookkeeping system for their business using Microsoft Excel. It will teach participants how to keep proper accounting Books on their computer and demonstrate and practice setting up bookkeeping spread-sheets and using basic Excel formula for greater efficiency. Participants will also be shown how to compile a VAT return and Profit and Loss account by linking to the bookkeeping spreadsheets.

Sarah seeks to remove the ‘fear-factor’ associated with working with accounts and to

break down the jargon into its most straight-forward form!

Programme Objectives

1. To explain and demonstrate the books and records that must be kept by business owners and in what format
2. To teach and explain which expenses are allowed to be claimed by businesses and those that are disallowed
3. To demonstrate and practice how to reconcile the bank account
4. To explain the Profit and Loss account and Balance Sheet and how the Books update these
5. To teach participants how to calculate and complete a VAT Return
6. To practice setting up bookkeeping spread-sheets and using basic Excel formula for greater efficiency. Participants will also be shown how to compile a VAT return and Profit and Loss account by linking to the bookkeeping spreadsheets.

Course Content

• Keeping and recording financial records – ‘The Books’
• Allowable expenses
• Assets, Liabilities, Income, Cost of Sales and Expenses
• Bank Reconciliation
• Debtors & Creditors
• The Profit and Loss Account and Balance Sheet
• VAT calculation and Return
• Using Excel Spread Sheets to record business transactions - ‘The Books’

PLEASE NOTE: 

In the event that you book a place and subsequently do not cancel your booking at least ten working days prior to the commencement of the course and do not take up the place no refund or fee transfer will be offered. 

We may take pictures and/or make video and audio recordings at this event, in which you may be featured.  By attending the event, you give the organisers the right to use such material for non-commercial purposes, including the posting of photos and/or videos on our website(s).