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