e-business /
Computerisation /
Internet
----------------------------------
How to use XL for accounts
Workshop Aim :
To show participants how to use XL for good record keeping &
preparing a Profit & Loss Account using MS Excel
Workshop Objectives :
By the end of this Workshop participants will be able to/know how
to:
1. Maintain primary books of account (Sales & Purchase Ledgers and Cash Book) using MS Excel
2. Produce a monthly, or weekly, Profit & Loss Account
3. Understand accounting terminology
4. Do a monthly bank reconciliation, using Cash Books and Bank statements
Location: Assist Training, Barrington Street
Trainer : Bryan O’Donnel
Date: Thursday 25th Nov
Time: 10- 5pm
Cost: €30
Prerequisite Required: Participants must be proficient users of XL
Course Content
1000 1030 Introductions followed by Accounting Terminology Presentation & discussions
1030 1100
1. Why have accounts
2. Books of account (Sales/Purchases/Cash books)
3. Advantages & Disadvantages of XL for accounts
Presentation & discussions
1100 1130
Sales Ledger explained, details to be recorded, VAT analysis,
segmenting sales revenues Use handouts, discussion of same,
work with XL on a template
1130 1145 Tea/coffee
1145 1230
Sales Ledger cont’d Practical exercise using XL, showing
analyses of revenues, VAT & totalling
1230 1300
Purchase Ledger explained, details to be recorded, VAT
analysis, segmenting sales revenues Use handouts, discussion of
same work with XL on a template
1300 1400 Lunch
1400 1445
Purchase Ledger cont’d Practical exercise using XL, showing
analyses of costs/expenses, VAT & totalling
1445 1530
Recording Cash/cheque Receipts, distinguishing between sales
ledger receipts and other receipts (eg grants, VAT refunds) Use
handouts, discussion of same followed by a short practical
exercise using XL
1530 1545 Tea/coffee
1545 1615
Recording Cash/cheque Payments, distinguishing between
purchase ledger payments & other payments(e.g. VAT, PAYE
Use handouts, discussion of same followed by a short practical
exercise with XL
1615 1645
Profit & Loss Account Linking of sheets to demonstrate ease of
producing a Profit & Loss Account. Demonstrate how to prepare
VAT return from the records
1645 1700 Wrap-up & conclusions
-------------------------------------
