Course Content: 

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 and all parts of the system will be linked by means of posting journals leading to a final Trial Balance, Income statement and statement of financial position.

Session 1: 

• 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:  

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