Basic Book-Keeping Using Excel

Online via Zoom
7pm to 10pm
Business Training

This course will demonstrate to participants how to record basic book-keeping information using excel.

Booked Out

This course will be delivered by Patricia Feeney from Accounting & Management Functions Ltd.

Patricia Feeney

The course will be delivered over 4 Thursday evenings - 5th November, 12th November, 19th November and 26th November

There is also an option for two one to one sessions at the end of the four evenings.

Course Content:

  • Recording of Supplier Invoices/Credit Notes
  • Recording of Customer Invoices/Credit Notes
  • Recording of Supplier and Non-Supplier Payments
  • Recording of Customer and Non-Customer Receipts
  • Recording of Till Receipts, Cash Payments and Lodgments (applicable for Retail Business)
  • Preparation of VAT Return on both an Invoice and Receipts Basis
  • Maintaining Supplier Ledgers
  • Maintaining Customer Ledger
  • Preparation of Bank Reconciliation

Training Method:

An Excel template together with class exercises will be emailed to each participant.
The participants are required to complete class exercises on each topic in order
to prepare the Purchases, Sales, Bank and Cash Day Books.
From the Day Books, the VAT 3 Return will be prepared on both an Invoice Basis and a Cash Receipts Basis. A Bank Reconciliation will be prepared from the Day Books. Also the participants will take the information from the Day Books and prepare a Customer and Supplier Ledger System.
The trainer will assist the participants in the completion of each task correctly.

Participant Profile:

  • Individuals wishing to start in business.
  • Owner-managers or key staff members of businesses.