"With the new year in full swing, it might be hard to find time to guide your first-year trainees, some of whom might be starting out with little to no accounting background yet. We have designed a practical, interactive course to enable them to contribute to your operations and perform their duties in an effective and efficient way.
This course is intended to 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. Should you require an auditing course for your trainees, please refer to the Junior audit simulation course on our booking site."
By the end of this course, delegates will be able to work in Excel and to compile basic working papers for the accounting environment.
Delegates are provided with a general ledger and trial balance prepared by a client, as well as the 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:
- Determining the costs 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 portions for disclosure purposes
- Compiling and interpreting the 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 session will be presented on a basic level and all first-year trainees, especially those in a five-year contract without a degree, working in the accounting environment, will benefit.
The hosting organisation is responsible for the following:
- Own computers (PC or laptop) with Excel loaded onto the machine
- Internet Connection (Wi-Fi or 3G) with sufficient data for the day
- USB headset (microphone, speakers) for each delegate
- Webcam (external or built-in) for each delegate
For engagement activities and online tools, other devices such as the iPad and iPhone are not recommended.
Please ensure that the above pre-course preparation has been completed prior to attending the course.
Please ensure that you are logged in 15 minutes prior to the start of the session.
