Accounting Information System
The following plan details the business areas and services to be provided for a growing homeowners' association by a certified accounting firm. The large growth in size of the association is cited as a need for this contracting with the accounting firm, and the specific business areas in need of servicing are identified as billing, collections, payments, reporting, taxes, and miscellaneous advisory duties. Input, output, and control requirements are listed in brief for each business area, with reference to current scholarly and regulatory/advisory information to ensure consistency and conformity with accounting standards. Automation of accounting processes is a major focus of the service provision, and levels of automation are fully discussed, with the decision to build an in-house automation system and certain automation challenges discussed.
The homeowner's association is facing a problem of a major increase in the amount of accounting work it will need to take on. Though currently only comprised of one-hundred and fifty homeowners, this individual homeowners' association is still growing and is also involved in a merger with four other homeowners' associations over the next six months, adding five hundred homeowners for a total of at least six-hundred and fifty homes and homeowners. As the central surviving homeowners' association following the merger, this association will be responsible for the accounting and financial needs of the association as a whole, and accomplishing these tasks on such a large scale is not something that can be handled in-house.
It is the desire of the homeowners' association that the accounting firm will provide services in the following business areas: billing of homeowners on a quarterly basis with included penalties for late payment, collection of payments from homeowners via U.S. mail, payments to various vendors (e.g. lawn maintenance and refuse collection) and of other monies owed y the homeowners' association (taxes, etc.), reporting all financial activity handled in the above business areas, tax preparation and filing, and providing advice as needed in areas of budgeting, purchasing, investing, and others. It is expected that the accounting firm will automate the billing and collection processes, and automation will also likely be achieved in the payment and reporting areas. Tax preparation will be semi-automated for efficiency as well as for accuracy, and the advisory function will be performed manually.
Proposed System Requirements
The billing processes put in place by the accounting firm shall be completely automated, other than the physical mailing of bills to be completed on a quarterly basis (and monthly thereafter for any payees that have failed to pay on time). Input requirements for this business area will consist of individual homeowners' names and addresses, individual account numbers, and, following the issue of the bills in the first billing cycle, payment status. Output requirements are the physical bills, including properly calculated amounts for late fees, as well as reports for use in the later financial documentation of the association (AICPA 2011). Calculation and issuance controls are easily achieved through basic accounting software (Romney & Steinbart 2011).
Collection of payments from homeowners will also be fully automated, save for the physical process of retrieving checks from the specifically-purposed post office box to which checks will be mailed. Input requirements will consist of homeowner account numbers, payment amount (if full and on-time, this should equal $150 every billing cycle), and date of payment (which can be adjusted to the payment due date for all payments made early). Output requirements match typical outputs for this business area, including payment records and automated communication with the billing processes to either mark each account as paid or issue a new bill with calculated late fees each month a bill due goes unpaid...
Control on this system will include physical and software security measures that protect homeowner account numbers and other information, occasional manual audits to ensure accuracy, and the regular reporting of collection activity, all of which is in keeping with standard recommendations (Romney & Steinbart 2011; AICPA 2011).
The payment process will also be fully automated, issuing checks to payees on a monthly basis as agreed per contract or calculated via established parameters for taxes and other variable payments. Input requirements for the payment system include all relevant payee information and the amount or calculation method for each payment. Output requirements include the physical checks to be mailed to payees, when automated payment is not possible, and regular reporting of payment activity. Manual audits as well as automated checking of balance sheets will form highly important controls in this business area (COSO 2009; AICPA 2011).
The automation of reporting is still somewhat controversial, but it is believed that the relative simplicity of the accounting tasks for the homeowners' association and the increased efficiency (and therefore cost-effectiveness) of automation will lead to a net benefit for the association (Romney & Steinbart 2011; AICPA 2011). Input requirements in an automated reporting system will be achieved quite easily from the other automated accounting tasks that produce relevant information for reporting (i.e. billing, collection, and payments) through an integrated software system (Turner & Weickgenannt 2009; Kruck 2011). Output requirements will consists of financial statements with all areas identified by law and/or standard practice as relevant to the overall financial health of the association (COSO 2009). Manual checking of reports on a quarterly basis and proper security procedures and software should provide appropriate controls.
Tax preparation has been an automated r semi-automated process in for many businesses and individuals for some time (Kruck 2011). A mix of automated and manual processes is recommended to ensure accuracy, however; the number of specific inputs is not the same year to year or even quarter to quarter, necessarily, and constant reviewing of updated or altered tax code is necessary to achieve the most effective results (Turner & Weickgenannt 2009). Output requirements in the tax area are relatively straightforward, consisting simply of the necessary documents required by local, state, and federal agencies and with the means of production and controls built into software already utilized by the accounting firm (Romney & Steinbart 2011).
Other accounting needs might be identified as necessary as the homeowners' association continues to grow and as the economic environment changes, and the accounting firm shall provide advisory functions to the homeowners' association in determining and fulfilling these needs as they arise and are identified in accordance with standard practice (AICPA 2011; Romney & Steinbart 2011). Input requirements in this area will vary widely, and will be brought to the accounting firm's attention by the client as well as from the firm's ongoing awareness of environmental shifts that could affect the association's financial position. Output requirements will also be highly varied, ranging from the identification and recommendation of investment opportunities to the potential reorganization of budgeting frameworks and reporting, as recommended via updates from a variety of professional organizations and advisory entities (COSO 2009; AICPA 2011). Controls are difficult to determine in this area, and will be developed and implemented on a case-by-case basis.
Proposed Manual Functions
The only business area where substantial manual functions are desired are in tax preparation and certain advisory functions. Though the tax preparation software utilized by the accounting firm is both efficient and comprehensive, with regular updates based on changes to tax law, manual audits of records and of filings is recommended to ensure no specific details of the business or of tax code are overlooked. The advisory function will be almost entirely manual simply due to the variety and largely qualitative and subjective factors of such tasks.
Make or Buy
The requirements of the homeowners' association are not especially complex, and while a standard software package such as Quicken or Peachtree could certainly provide the necessary functions it would not be difficult to construct a system that…
Application Development and Interface Customization for Accounting & Finance The core aspects of this area of analysis are supported for embedded SQL, support for standard and embedded interfaces, support for XML and Web integration technologies. Many enterprises program their own native SQL applications for analyzing and reporting their financial results. The use of embedded SQL in financial accounting and analysis has become commonplace as mobile-based platforms have become more commonplace throughout
Components of an Accounting Information System Accounting Information Systems An accounting information system is a vital tool for any organization. The system will support the organization in making critical strategic and business decisions. Having a system that captures, records, processes, and records financial data for an organization will also reduce errors in billing and shipping. This paper analyzes the six main components of an accounting information system. An accounting information system is a
Accounting Information System Improving Transactional Processing in Accounting Information System (AIS) Propose two (2) innovative technology changes that would be appropriate for a firm's: Revenue (sales to cash collection) cycle Revenue cycle represents the description of the financial progression of a business entity in relation to the accounts receivable from the point of acquisition of products to the stage when the company or business organization receives full payment for the products (Romney, 2012). One
Computerized Accounting Information Systems In a global contemporary business environment, the computerized accounting information systems have become an integral part of organizational accounting systems. The development Information and Communication Technology (ICT) has assisted organizations to migrate from the traditional accounting method to a computerized accounting systems. The integration of ICT with accounting methods has given rise to Accounting Information System (AIS) that assist organizations to deliver timely and accurate financial information which
Abstract This particular report is an evaluation on AIS through case analysis and presentation involving AIS failure, possible alternatives the firm may have had and just how the management should have strategized to avert the failure. In the end, the paper reveals best practices for migration from another system to AIS. To change the Accounting Information System (AIS) best practices Accounting info systems (AIS) has transformed business processes on a worldwide scale. When
Control and the AIS Control and the Accounting Information System This paper discusses the process of integrating controls into the accounting information system (AIS) using enterprise risk management (ERM) components. ERM is defined as "a process, effected by an entity's board of directors, management and other personnel, applied in strategy setting and across the enterprise, designed to identify potential events that may affect the entity, and manage risk to be within its