Reference no: EM132324536
Introduction
Welcome to the learner's guide for this unit of competency for the qualification FNS60217 Advanced Diploma of Accounting. This guide provides you with essential information on competency standards, delivery plan and schedule, assessment plan, assessment tasks and learning resources for this unit of competency.
The purpose of this learner's guide is to:
• Provide you with information on delivery schedule and plan of this unit
• Ensure the you understand how students will be assessed in this unit
• Provide information on assessment methods, strategies, and evidence requirements
• Provide information on learning activities and assessment tasks
• List resources which may assist in student learning and assessment tasks
This unit also incorporates Foundation Skills that are embedded within the competency elements.
Learning Outcomes
On successful completion of this unit, the learner/trainee will be able to;
• Evaluate information systems
• Develop implementation plans
• Review resource use
• Monitor plans
As well as demonstrating the performance criteria, to be assessed as competent, the learner must demonstrate their ability to apply the required knowledge and skills in a range of situations. These are summarised in the Competency Standards section below.
Unit and assessment information Key terms and definitions
Harvard Referencing System: Guide
Key financial legislations: Taxable transactions, Reporting requirements
Principles of internal control: Policies, procedures, quality reviews, statutory reporting, record-keeping, recording and storing financial data
1
System specifications;
Changing needs Client compatibilities
Financial analysis functions
Logical data models such as database design Networking capacities
Processing capacities (size, speed) Software (upgrades, legacies)
2-3
Accounting Information Systems: Overview
The concept of Enterprise Resource Planning (ERP)
Overview: ERP packages: E.g. Sage Pro, SAP BusinessOne, Oracle, Microsoft Dynamics, Epicor 9, Infor (Baan)
Distinction between enterprise ERP and accounting ERP: Overview: QuickBooks Enterprise, PeachTree (Sage), Microsoft Dynamics NAV, Uniware
Advantages and disadvantages for companies in implementing ERP systems Integration of accounting systems with ERP
Planning for introducing a new system:
Identifying and determining organisational needs and requirements Determining budgetary and other resources requirements: Cost benefit analysis Identifying and engaging key stakeholders in the process
Determining the impact on the organisation Identifying and selecting an appropriate system Evaluating and comparing system features
Example and discussion: Cost-benefit analysis
4-5 Developing an implementation plan: Developing goals and objectives
Identifying and negotiating organisational and user requirements
Planning a change process: System or organisation adaptation? Determining regulatory, legal, organisational, security, and record keeping requirements
Testing the system: Developing an implementation plan Obtaining the feedback and evaluation system suitability
Deciding on and preparing final implementation schedule and contingency plans
6-7
Implementation: Obtaining and maintaining system documentation: User manuals, online help, technical helpdesk,
Organising and facilitating training sessions
Preparing a data transition strategy and plan: Documenting the process and identifying potential problems
Testing and evaluating the new system: Quality and continuous improvement principles
Reviewing transactions and ensuring compliance with accounting, regulatory and legal requirements
Risk management strategies: Comparative analysis Decision making authorities Forecasting
Periodic reporting Policy statements Quantification of risks
8-9
Monitoring and evaluating system performance: Feedback, benchmarking, performance outcomes
Generating reports and ensuring standards and compliance with reporting requirements: Formats, style, contents, accounting methods
Ensuring privacy, confidentiality, and security: User access levels, backups, data security
Establish reporting procedures: Standardising input data
Modifying system and reporting features to meet changes in the reporting requirements
Maintaining compliance records: Manual and paper records, electronic records
Assessment Task 1:
Assessment Task Compare and Analyse Accounting ERP Systems
Description:
An Enterprise Resource Planning (ERP) system is a fully integrated business management system covering functional areas of an enterprise such finance and accounting, HR, production, sales and logistics. It organises and integrates operation processes and information flows to make optimum use of an enterprise's resources (erssource, 2012).
Most ERP systems contain modules, including an accounting module, within them and organisations have the option of deploying the full system or select modules depending on their specific requirements. An accounting module will handle only individual business functions of accounts whereas a complete Enterprise Resource Planning (ERP) package will handle the entire range of business functions of the organisation.
In this assessment task, you are required to research and compile information on five different ERP systems that incorporate finance and/or accounting modules. Present your research information in a tabular format with comparative functions listed side by side. You comparison will be based on;
1. System type and platform
2. Core functions and modules (or applications)
3. Accounting functions (Detailed and itemised)
4. Database type and flexibility
5. System (installation) requirements
6. Approx. cost (if available)
7. Customisation and flexibility
8. Training and support documentation
9. Market differentiation (unique selling point of each system)
10. Local support (Australia)
Once you have collected and compared the information, write a brief report summarising your understanding of ERP systems and their functionality; especially the finance and accounting applications (modules). In addition, cover the following information in your report. You may have to further research these topics.
• Basic structure of an ERP system
• Five key advantages and disadvantages of using an ERP system
• ERP implementation life cycle
• Security issues and measures
• Impact of ERP on business performance
• Key principles of internal control, including statutory requirements and how an ERP system can impact on these processes
• Costs: Implementing and running
• Problems and issues with implementation
The report should be written as a formal business document with appropriate structure and style.
All external sources must be cited using the Harvard referencing system. The report should be written in your own words. Extensive and straight copy-paste from the external sources without an appropriate analysis will not be accepted.
Assessment Criteria
The following assessment criteria will be used for marking this assessment task. Ensure that you have addressed all of the criteria in your work.
• Researched and selected appropriate ERP systems for comparison
• Systems incorporate accounting and/or finance module or applications
• Adequate data is collected and used for comparison
• Citations reflect a variety of sources used to gather information
• Used the comparison criteria as provided to compare the systems
• Comparison shows distinct features of each system
• ERP system structure and functions/applications are identified and compared
• Features and components of finance and/or accounting applications/modules are identified and listed in detail for each system
• Cost, customisation, documentation and support features are identified and compared
• Comparison data is presented in a structured (tabular) format with appropriate headings and highlights
• Analysis reflects an understanding of distinct ERP systems and their features
• Advantages and disadvantages of using an ERP system are articulated based on the research
• ERP implementation life cycle includes steps from selection of a package to post-implementation process
• Prevalent and perceived security issues associated with EPR systems are discussed with supporting examples or references
• Explained if use of an ERP system has any implication, positive or negative, on business performance
• Issues of cost and time of implementation are discussed in detail
• The report is appropriately structured and developed in own style and language
• Cited all external sources using an appropriate referencing system
Assessment Task 2:
Identify Organisational and ERP Implementation
Requirements
Description:
Rapid advances in Information Technology within the last decade have been catalyst for organisational change, especially in implementation of enterprise resource planning (ERP) systems. ERP implementation means implementation of new software package and business processes that substantially alter workflow and jobs.
Organisations that successfully implement ERP systems, including new software and business processes, have reported enormous benefits, such as greater efficiency and effectiveness at both individual employee and organisational levels (erssource, 2012). However, ERP systems also fail and one of the reasons for the failure is organisation's inability to effectively manage the chance process.
In this assessment task, you will be provided with a case scenario of an organisation in need of an ERP system; especially in the area of financial/accounting management. From the given scenario, you will be required to identify and analyse the specific ERP needs. This assessment task will serve as the first part of the major task, provided in Assessment Task 3: Develop and Present an ERP Project Plan. You will be using information developed in this task as an input into your major project. You must retain a copy of your work in this task.
Case scenarios:
Cockatoo Ridge Wines has grown to be one of the most recognized wine labels in Australia. Listed on the Australia Stock Exchange in February 2002, the company continues to expand distribution of its wines in Australia, as well as increase sales and distribution to international markets. It has just started to export to Britain after a strong year in the US.
Situated in the heart of the Barossa Valley in Australia's largest wine producing region, Cockatoo Ridge Wines includes white and red table wines made from a single variety of grape, as well as white and red sparkling wines. Using the latest viticultural practices, their products are designed as modern, low-cost wines.
Cockatoo Ridge Wines currently exports 2,000 cases per year. Two of its business objectives are to increase its exports from 25% of distributions to over 50% within the next 12 months and occupy a larger proportion of the domestic market. However, the company realized its current reporting software would not allow it to reach these goals.
As a condition of being a publicly listed company, Cockatoo Ridge must provide complete financial and data analysis reports to all shareholders on a monthly, quarterly, and annual basis.
Such reports meant that fields within the company's database needed to be populated by hand from a number of different sources. The process of manually entering data each month was time-consuming and prone to errors. As a result, the reports were often delayed by up to two weeks.
Cockatoo Ridge needed a solution that provided specific software functionality relevant to the wine industry that could also be tailored to its needs. In particular, Cockatoo Ridge wanted a package that would handle sales and distribution at the same time it allowed the company to report on any area within its operations, using a simple interface.
Damien Lister, Financial Controller for Cockatoo Ridge Wines, says the main challenge was the amount of time it took to analyze and report on the business.
"We were always on the back foot because our knowledge of our position was limited," he says.
"It also created a processing backlog because the system needed to stop collecting data until month-end reporting was complete. Once this month-end reporting was finalized, all the data for the current month then needed to be manually re-entered once the system was back online."
Cockatoo Ridge wanted a faster system that allowed all reporting to be done while the next month's data was being collected. To achieve its goal of taking a lead position in the wine industry, the company needed to employ a market-specific solution.
"The collection of data needed to address our financial and sales areas, including our budget forecasting, as well as our cellar-door and point of sales process management," says Lister.
Based on the above case study;
• Identify and explain organisational requirements
• Describe the specific accounting solutions that the company requires
• Describe basic requirements of the accounting application/module based on principles and practices of budgetary control
• Identify and list legislative requirements (e.g. taxation, reporting) that the company must maintain in any solution
• Establish expected outcomes - what the solution will entail
• Research and suggest an appropriate system that fits the requirements
• Describe system features and processes in detail based on your research in Assessment Task 1
• Describe minimum system requirements for implementation
• Describe employee training requirements for implementation
• Develop an implementation checklist that list all the critical steps required in implementation of a new system, including data security measures
• Describe a procedure for testing the system prior to implementation
• Provide an approximate cost estimate based on your research on the system
• List expected benefits against the cost incurred and justify the costs
• Suggest an implementation timeline
This document should be prepared in a needs analysis format with a basic cost-benefit analysis included for review by the management. The document should be word processed and written in a formal style appropriate for business presentation. All external sources must be cited using the Harvard referencing system.
Assessment Criteria
The following assessment criteria will be used for marking this assessment task. Ensure that you have addressed all of the criteria in your work;
• Developed an organisational context from the given case study and summarised organisational needs and requirements
• Explained how specific needs and requirements justify why company needs an ERP system
• Explained the type/extent of an ERP system in part or full that may provide an effective solution
• Described the basic requirements of the accounting application/module such as double-entry bookkeeping and accrual accounting
• Provided a detailed explanation of how a new ERP system needs to meet the organisational, legal and regulatory requirements, including statutory reporting
• The solution envisioned for the company provides a balance and a match between accounting principles and likely benefits/outcomes for the company by using an ERP system or module
• Researched ERP systems that closely meet organisational requirements
• Suggested an appropriate ERP system with a detailed description of features and applications
• Identified and outlined system and technical requirements for implementing the new system
• Identified and outlined support and documentary requirements for implementing the new system
• Identified and outlined staff training needs and requirements for implementing the new system
• Developed a checklist that contains necessary steps/tasks needed to effectively implement the new system and data security measures
• Implementation checklist includes provisions for staff training, system testing, data migration, approvals and verification processes
• System testing procedures are outlined with appropriate measures and criteria for approval
• System cost estimates are provided based on the ERP lifecycle and balanced against likely benefits to the organisation
• An implementation timeline is suggested with a stepped/phased approach for implementation
• Report is written in a formal style with appropriate structure aimed at senior management audiences
Assessment Task 3:
Assessment Task Team Project: Develop and Present an ERP Project
Plan
Description:
This assessment task is continuation of Assessment Task 2. Considering the complexity of the task, this project is given as a team project to be undertaken by a team of two (2) students. In this task, your team will be required to develop and present an ERP Project Plan for the case organisation. Team members will need to choose one of the project implementation solutions and time lines developed in Assessment Task 2.
A project plan will encompass project details, background to the problem, goals and objectives, key strategies and a comprehensive implementation schedule. Particular focus of this project is to implement a new ERP system within the organisation based on the needs analysis conducted in Assessment Task2. Most importantly, you and your team member will need to download and install a trial/evaluation copy of the ERP solution recommended and process a few mock transactions as samples.
This task has three parts; 1) Written project plan; 2) System installation; and 3) Presentation.
Part A:
Your team project plan will include (but not limited to;
Executive summary Background (Case study) Project goals and objectives
Key stakeholders and consultation process
The solution (including input and output of data and reporting features) Compliance Features (how it meets transaction, record and reporting requirements) Key implementation strategies (including change management)
Implementation schedule
Internal control processes and likely impact of ERP Data migration process
Cost-benefit analysis
Staff training requirements
Support documentation requirements (download a copy of the system manual and attach with the plan) IT support requirements
Perceived risks and a contingency plan
The above can be used as suggested headings in the plan. However, the teams may develop their own structure incorporating above areas/topics.
The plan must be written in your own language and reflect both originality and inventiveness of the solutions proposed. The report must be written a formal business document for presentation to the senior management. There is no word limit. However, it is expected that you will contain your report within ten (10) single-sided A4 sheets with single spacing. All external sources must be cited using the Harvard referencing system.
Internal controls assist an organisation's policies and procedures to safeguard its assets, check accuracy and reliability of data, promote operational efficiency, and encourage adherence to sound management practices. In your plan, outline if implementation of ERP will have any impact on internal control processes.
Part B:
Assuming that you have obtained the necessary approvals and permissions from the management for your implementation plan, download and install a trial version of the system/package on your computer. You must also obtain necessary permissions from your trainer, assessor or college's IT department. If your suggested vendor does not allow for a trail copy, you may install any other package as an example and present to the class.
Assume that the company has three fundamental internal control requirements;
1. Effectiveness and efficiency of operations;
2. Reliability of financial reporting; and,
3. Compliance with applicable laws and regulations
Once installed, enter and process some different types of transactions (invoice, payment, sales order, purchases, expenses etc.); in line with the organisational requirements as established in Assessment Task 2. Save and backup the system file. Print the transaction records and reports relevant to transactions based on system/application features.
Write a brief report on how the intended solution/product will align with the internal control processes.
Part C:
Present a summary of your project plan and the recommended ERP system to the class, assuming the class audience as senior management audience.
Your presentation should be well structured, aesthetically appealing and prepared using Microsoft PowerPoint or a similar application.
Attachment:- Conduct Internal Audit.rar