This online course will be of most benefit to people who have an understanding of manual book-keeping systems and have experience writing up books manually.

The Excel model created will substantially speed up the process of writing up the books, as well as improving credit control in the business, leaving a clear view of the amounts owed by customers and owing to suppliers.

Ideally attendees will have access to a computer and Excel, with the ability to create a spreadsheet that can work for their own systems.

Webinar 1:

• Introduction to Book-keeping
• Setting up Sales and Purchases Daybooks using Excel
• Setting up Receipts, Payments and Petty cash books using Excel
• Setting up Receivables Ledgers and Payables Ledgers on Excel
• Linking the Receivables Ledgers to the Sales Daybooks and Receipts books on Excel
• Linking the Payables Ledgers to the Purchases Daybooks and Payments books on Excel

Webinar 2:

• Setting up Nominal Ledger Accounts on Excel
• Creating Posting Journals on each of the daybooks
• Linking the posting Journals to the Nominal Ledger Accounts

Webinar 3:

• Extracting a Trial Balance from the Nominal Ledger accounts on Excel
• Using Excel to create an Income Statement and Statement of Financial Position from the TB
• Using Excel to deliver the information required for the VAT 3 FORM