Price:
R3036.00 (VAT Incl.)
Level:
Accounting professionals
Sub-level:
Accounting
Lecturer:
Probeta Training
Duration:
780 Minutes
Additionals:
R3036.00 (VAT Incl.)
Level:
Accounting professionals
Sub-level:
Accounting
Lecturer:
Probeta Training
Duration:
780 Minutes
Additionals:
CPD Assessment
Certificate
Certificate
Lesson Outline
We all know how hard it is to find time to guide a first-year trainee without any accounting background when they start working - that is why we have designed a course specifically to ensure that they will be able to contribute in an effective and efficient way.
This course will provide delegates with practical knowledge of how to prepare basic working papers for the accounting environment on Microsoft Excel, while also providing them with basic competencies for this program to enable them to navigate it efficiently and confidently.
Please note: This session does not cover auditing procedures or all accounting technical matters in detail. It is a basic course covering the compilation of accounting working papers such as a fixed asset register, interest calculations, etc.
Delegates will be provided with a general ledger and a trial balance that is prepared by a client, as well as supporting documents that will help them complete the working papers. They will then need to prepare the following:
- Property, Plant and Equipment:
- Fixed asset register
- Residual values
- Calculating depreciation and profit and loss with the sale of fixed assets.
- Investment property: Revaluation of investment property.
- Investments:
- Investment Listing
- Buying and selling of listed shares and calculating profit and losses on sale of shares.
- Inventories:
- Calculating the expenses that should be allocated to inventory items and calculating the finished goods based on this allocation.
- Calculate the NRV of inventory.
- Accounts receivables:
- Provision for bad debts calculation
- Classification of debtors.
- Cash and cash equivalents: Performing the bank reconciliation
- Financial Liabilities:
- Calculating the split between long term and short term for disclosure purposes.
- Reading amortisation table to calculate interest and disclose the expense.
- Provisions: Assessing possible provisions and calculating the amounts to disclose.
- Reading and understanding contracts e.g. instalment sales agreements.
We will also be covering the basics of Microsoft Excel in the working environment such as:
- Creating workbooks
- Understanding the Ribbon and interface
- Formatting and fonts to be able to create tables and headers for the working papers
- Text formatting
- Number formatting
- Autofill
- Basic formulas and functions
- Using tables and styles
- Using shortcut keys
This course will provide delegates with practical knowledge of how to prepare basic working papers for the accounting environment on Microsoft Excel, while also providing them with basic competencies for this program to enable them to navigate it efficiently and confidently.
Please note: This session does not cover auditing procedures or all accounting technical matters in detail. It is a basic course covering the compilation of accounting working papers such as a fixed asset register, interest calculations, etc.
Delegates will be provided with a general ledger and a trial balance that is prepared by a client, as well as supporting documents that will help them complete the working papers. They will then need to prepare the following:
- Property, Plant and Equipment:
- Fixed asset register
- Residual values
- Calculating depreciation and profit and loss with the sale of fixed assets.
- Investment property: Revaluation of investment property.
- Investments:
- Investment Listing
- Buying and selling of listed shares and calculating profit and losses on sale of shares.
- Inventories:
- Calculating the expenses that should be allocated to inventory items and calculating the finished goods based on this allocation.
- Calculate the NRV of inventory.
- Accounts receivables:
- Provision for bad debts calculation
- Classification of debtors.
- Cash and cash equivalents: Performing the bank reconciliation
- Financial Liabilities:
- Calculating the split between long term and short term for disclosure purposes.
- Reading amortisation table to calculate interest and disclose the expense.
- Provisions: Assessing possible provisions and calculating the amounts to disclose.
- Reading and understanding contracts e.g. instalment sales agreements.
We will also be covering the basics of Microsoft Excel in the working environment such as:
- Creating workbooks
- Understanding the Ribbon and interface
- Formatting and fonts to be able to create tables and headers for the working papers
- Text formatting
- Number formatting
- Autofill
- Basic formulas and functions
- Using tables and styles
- Using shortcut keys