Accounts Security Report: Revenue Cycle, System Development Life Cycle

This report offers a comprehensive analysis of accounts security, addressing critical aspects of financial management. It begins by examining the revenue cycle of an organization, identifying potential internal control weaknesses in areas like sales orders, shipping, billing, and cash collection, and assessing their impacts on the business. The report then proposes specific internal controls, such as payroll management, accounts payable procedures, and bank reconciliation processes, to mitigate these risks. Furthermore, the report delves into the System Development Life Cycle (SDLC), specifically focusing on the Queensland Health Payroll System. It identifies five key deficiencies within the system, including issues with historical payroll submissions, overpayments, time delays, financial problems, and system upgrades. Finally, the report provides actionable recommendations to address these deficiencies, such as accelerating changes to pay dates, reducing retrospective data entry, and planning for system upgrades. The report emphasizes the importance of robust internal controls and efficient system development for maintaining financial stability and operational effectiveness.

Running head: ACCOUNTS SECURITY
Accounts Security
Name of the Student:
Name of the University:

1
ACCOUNTS SECURITY
Table of Contents
Question 1: Risks and controls........................................................................................................2
1. Internal control weaknesses in Strings Revenue Cycle...........................................................2
2. Potential impacts of these weaknesses on the organization.....................................................2
3. Specific internal controls could be implemented by Strings...................................................3
Question 2: System development life cycle.....................................................................................4
1. Five deficiencies in the Queensland Health Payroll System project.......................................4
2. Recommendations on deficiencies..........................................................................................5
References........................................................................................................................................7

2
ACCOUNTS SECURITY
Question 1: Risks and controls
1. 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.
2. 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

3
ACCOUNTS SECURITY
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.
3. 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:

4
ACCOUNTS SECURITY
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.
Question 2: System development life cycle
1. 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.

5
ACCOUNTS SECURITY
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.

6
ACCOUNTS SECURITY
2. 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:
1. QH should accelerate approval for implementation of changes in pay date along
with commences the business processes to implement of changes in pay date.
2. 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.
3. 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.
4. 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.

7
ACCOUNTS SECURITY
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.

8
ACCOUNTS SECURITY
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.