Course Information:

This programme will be delivered online over 2 three hours sessions.

The course will deliver an introduction to bookkeeping terms, principles, the knowledge and skill to operate a fully integrated bookkeeping system that goes from source document to final set of accounts.

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 and 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.

Content covered includes:

• 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
• Cash Daybooks on Excel. Payments and Receipts
• Petty cash systems
• Posting Journals
• Double Entry. Debit/Credit
• Receivable/Payable/Nominal Ledgers
• Trial Balance, Final Accounts