Get in Touch

Map Location

LEO Nenagh 0818 06 5000

LEO Clonmel 052 616 6200

Newsletter sign up here

Bookkeeping Using Excel

Venue:
Virtual - an Zoom link will be emailed to you
 
Date:
22/09/2022
 
Note:
Thursday evenings 2 x 3 hr sessions
 
Time:
6.30pm - 9.30pm
 
Category:
Workshop
 

Introduction to bookkeeping terms and principles and the knowledge and skill to operate a fully integrated bookkeeping system that goes from source document to final set of accounts.

This event is no longer available
 

The course will cover all the working elements of setting up a simple bookkeeping system using Microsoft Excel.

The system will include all daybooks;

  • Receivables Ledgers
  • Payables Ledgers
  • Nominal Ledger.

All parts of the system will be linked by means of posting journals and will lead to a final Trial Balance, Income statement and statement of financial position.

Session 1: 22 September 

  •   Introduction to Bookkeeping
  •   Introduction to daybooks on Excel
  •  Sales invoices and credit notes,
  •  Sales daybooks on Excel
  •  Purchase invoice and credit notes
  •  Purchases daybooks
  •  Posting Journals

                                   
                 
Session 2:  29 September 

  •   Cash Daybooks on Excel. Payments and Receipts
  •   Petty cash systems
  •   Posting Journals
  •   Double Entry. Debit/Credit
  •   Receivable/Payable/Nominal Ledgers
  •   Trial Balance, Final Accounts