ACC200 Accounting Systems: Case Study of Strings Pty Ltd

1: Risks and controls

Internal control weaknesses in Strings Revenue Cycle

Following are the potential weaknesses into the revenue cycle of Strings such as:

In sales order: There are incomplete and inaccurate customer’s orders, and there are poor credit sales to the customers. This in sales order weakness is controlled by data entry edit checks along with accurate records of the account balance of customers. Digital signature is used for the e-business (Kreimer, 2015).

In shipping and delivery: There are errors into the shipping process due to wrong merchandise and theft into inventory. It is controlled by reconciliation of the sales order with the picking tickets, data entry application controls with proper documentation of internal transfer of inventory (Fernandez, Miller, & Carp, 2015)

In-billing and accounts receivable: There is failure to bill the customers along with billing errors. It is controlled by shipping as well as billing functions.

In cash collection: There are thefts of cash by any third party person who are present into the company (Wright, 2017). It is controlled by minimization of handling of cash by others rather than the access user, deposit of receipts as well as periodic settlement of the bank statements.

Potential impacts of these weaknesses on the organization

Due to weakness of in sales order and large volume of sales orders result into errors where the customers are sent wrong items. It impacts the reputation of the Strings Pty Ltd into the manufacturing business of musical instruments and parts. Due to weakness into the revenue cycle, there is delay into shipping when items are not in stock and it is not found into warehouse. There is also no physical counting of inventory over two years (Singh, Mindel, & Mathiassen, 2016). At the time when items are missing, the warehouse staffs note down the information into the log book. There is potential impact on performance of revenue cycle. Quality as well as accuracy of the sales order may have impact on the organization’s operations and business. Weaknesses of revenue cycle impacts the business along with the customers of Strings Pty Ltd is time delay among the customer those receive the product and service when the customers can remit the payments (Colwell, 2105). Limitations into the business revenue cycle do not ensure to receive of expected payments and reasonable as well as predictable schedules. Revenue cycle impacts the organization by not allowing the third parties to involve into the payment processes.

Specific internal controls could be implemented by Strings

Internal controls are required in Strings Pty Ltd. as it helps to measure into place for protecting the assets, enhances the reliability into the accounting records along with increase into efficiency of business operations (Fielding, 2015). The organization is required to implement of system of internal controls over the financial reporting. Internal control system helps to prevent as well as detect the financial frauds in the organization. Documentation of entity procedures will help to sustain internal control system and help to train the employees on new job roles (Islam et al., 2017). Outside training of the board members, management as well as personnel helps to make sure that the internal control system stays with up-to-date with change into technology. The suggested internal controls which could be implemented by Strings are as follows:

Payroll: It ensures that the organization has delayed payroll calendar. It incorporates of review and authorization of the timesheets. Outsourcing of payroll processing is helped to mitigate the delay in delivery of services.

Accounts payable: It requires of pre-approval for the purchases on behalf of Strings. It also reviews the list of checks signers periodically. Accounts payable are kept into secured location with limited access. There are proper access to the accounts so that no others can access to it.

Bank reconciliations: There is preparation of bank reconciliations in proper manner. It ensures that the bank reconciliations are being prepared by someone rather than individuals those make the deposits and process accounts payable (Coyne, Coyne, & Walker, 2016). When it is not possible, identifying other employee for reviewing the competed bank reconciliations.

2: System development life cycle

Five deficiencies in the Queensland Health Payroll System project

Following are the five deficiencies into Queensland Health (QH) Payroll System:

Historical payroll forms submission: The current degree of the QH payroll system is accommodated where as the staffs can submit the forms for completion of work completed within six years ago to create the payroll system performance issues (Karunarathna, 2015).

Overpayment and entitlements: As in the year 2012, QH overpaid $112.3 which is $16.5m has been paid as well as $3.3m waived, leaved $91m outstanding. Under the financial accountability act 2009, QH has obligations to recover the amounts. QH is required to fund the liabilities which are associated with overpayments as well as additional cost burden towards QH. There is overpayment of amount which is increased by approximately $1.7m per fortnight (Laudon & Laudon, 2016).

Time between close of roaster and pay date: QH paid run commences before closure of roaster. There is requirement of decision making related to current pay date allowed for the pay run based on actual hours worked rather than the forecasted hours worked (Singh,, Mindel, & Mathiassen, 2016). Change into pay date improves accuracy of the employment payment by allowing time to process roaster changes. It reduces number of underpayments as well as overpayments needed.

Financial issues: The system is not performing well with consequences of the employees of Queensland health and there are serious consequences for the state (Islam et al., 2017). Due to making of further implementation into the QH system, there are requirement of extra funds and cost which will be more than the estimated costs of the Queensland Health Payroll System Project.

 Upgrade and reimplementation of payroll: Into the QH environment, there are implementation of Workbrain and SAP system which are heavily customized along with not operating well into the business environment of Queensland Health. Customization of the system is considered as costly to manage, increase the issues as well as bad impact on the performance of system. QH has identified that there are expire of Workbrain and SAP system in the year 2014 as well as 2015 respectively (Singh, Mindel, & Mathiassen, 2016). There is required to make further investment into the system due to upgrade as well as reimplementation of the system before 2014.

Recommendations on deficiencies 

After identifying the key issues which are addressed above, following are the recommendations which are suggested to prevent from the issues such as:

QH should accelerate approval for implementation of changes in pay date along with commences the business processes to implement of changes in pay date.

QH should take of measures to reduce degree of retrospectively built into current QH payroll processes by implementation of the change programs to reduce window for lodging the historical payroll forms.

 QH should commence work into SAP as well as award interpretation engine upgradation planning which includes of move of standard of SAP functionality which is currently within Workbrain into SAP. Into the planning activities, there are use of approach to target external market for explore the system as well as payroll operating systems which is available to QH includes of associated cost and benefits.

QH should accelerate approval for lifting QH recovery of the overpayments as well a commencement of processes for recovering the overpayments. There are changes into pay date improves accurateness of the service payment by allowing time to procedure roaster changes.

References

Colwell, J. (2015). Tech tools to aid with revenue cycle management. Medical economics, 92(23), 54-54.

Coyne, J. G., Coyne, E. M., & Walker, K. B. (2016). A model to update accounting curricula for emerging technologies. Journal of Emerging Technologies in Accounting, 13(1), 161-169.

Fernandez, P. M., Miller, J., & Carp, R. (2015). U.S. Patent No. 9,082,087. Washington, DC: U.S. Patent and Trademark Office.

Fielding, D. (2015). Integrate and automate RCM. How revenue cycle best practices helped one health system improve its financial performance. Health management technology, 36(6), 17.

Islam, K., CH, A. R., Bilal, A. R., & Ilyas, M. U. H. A. M. M. A. D. (2017). Accounting Information Systems: Traditions and Future Directions (By Using AIS in Traditional Organizations). The Journal of Internet Banking and Commerce, 22(2), 1-13.

Karunarathna, A. G. P. (2015). Payroll Management System(Doctoral dissertation).

Kreimer, S. (2015). The revenue cycle decision. Medical economics, 92(5), 45-6.

Laudon, K. C., & Laudon, J. P. (2016). Management information system. Pearson Education India.

Singh, R., Mindel, V., & Mathiassen, L. (2016, January). IT-Based Revenue Cycle Management: An Action Research into Relational Coordination. In System Sciences (HICSS), 2016 49th Hawaii International Conference on (pp. 3152-3161). IEEE.

Wright, K. (2017). Revenue Cycle and Reimbursement. Health Information Management: Principles and Organization for Health Information Services.