Accounting Using Excel

Programme Aim

Day 1

• Processing Purchase Invoices and Credits for Resale and Non-Resale
• Processing of Sales Invoices and Credit Notes
• Processing Supplier, Non-Supplier, Direct Debits and Standing Orders.
• Processing Customer, Cash Receipts and Other Income.
• Processing Lodgements and Cash Payments.
• Entering Purchase Invoices, Credit Notes and Payments to Supplier Ledger Accounts  and extracting   month end balances.
• Entering Customer Invoices, Credit Notes and Receipts to Customer Ledger Accounts  and extracting month end balances.
• Preparation of Bi-monthly Vat Return on both a Cash Receipts Basis and Invoice  Basis.
• Preparation of Annual VAT Trading Details.
• Processing of Wages and Salaries Information.
• Processing of Bank Reconciliation.

Day 2

• Extracting of Information from Purchases Book and posting to the Nominal Ledger.
• Extracting of Information from Sales Book and posting to the Nominal Ledger.
• Extracting of Information from Cheques Journal  and posting to the Nominal Ledger.
• Extracting of Information from Cash Book and posting to the Nominal Ledger
• Posting of Wages Journal to the Nominal Ledger.
• Posting of Opening and Closing Stock Journals to the Nominal Ledger.
• Extracting of Information from Nominal Ledger to the Trial Balance.
• Extracting of Information from the Trial Balance to the Profit & Loss Account.
• Extracting of Information from the Trial Balance to the Balance Sheet.
• Explanation of Trial Balance, Profit & Loss Account and Balance Sheet.