Laserfiche WebLink
SPECIFIC AUDIT APPROACH (continued) <br />In the planning stage, analytical proced�u��used��ndi�����.���audit risk, and <br />to <br />determine the nature, timing, and extentof planned substantive testing. Material revenues, expenditures,andbelanoeaheeta000unts are compared to the current years budget and/or prior year actual amounts to <br />identify accounts that vary significantly from expectations. In this phase of the audit, analytical review is <br />typically done at an aggregated level, unless specific variances are considered to warrant further <br />investigation. <br />In the planning stage of the audit, we use data mining software to provide advanced data analytics. This <br />software is used to query, oummehze, and categorize data. MMKR uses this tool in agovemme�e| audit to Iocate duplicate or missing items, journalentriesthat are not balance, journal entries made to unusua <br />accounts or categories, transactions posted on odd dates, and variety of other tasks. <br />Analytical procedures are a key tool used in the substantive testing phase of all significant audit areas. In <br />this phase of the auditanalytical procedures are apphedtoindividually o\gn�oantaccounts. Some ofthe <br />most common types of analytical tests employed include: comparison to current year budget and/or prior <br />year actual amounts; analysis of significantratios; comparison to available industry -wide data; and <br />reasonableness tests <br />where actual results are compared toexpected results that are based on other known <br />financial or nonfinancial variables related to the account being analyzed. <br />In the final review state of the audit, these same types of analytical procedures are applied to the final trial <br />balance and the draft financial statements. The purpose of applying analytical procedures at this stage is <br />to assist in assessing the conclusions reached during the audit and the adequacy of the audit evidence <br />gathered. They are also used to evaluate the overall financial statement presentation. <br />At MMKR�ee|aoinoorpnteanalytical comparisons inour management repo�.VVebelieve that providing <br />historical trend <br />�renddata and comparisons tostate-wide averages enhances the perspective ofthe reader for <br />interpreting their own financial results. <br />E. Approach to be Taken to Gain and Document an Understanding of the City's Internal Control <br />MMKR first gains an understanding of the internal control through interviews with the specific employees <br />of the City that work in each funotion, including a review and analysis of written accounting policies and <br />procedures ofthe City The understanding for each function is documented through the use of question and <br />answer checklists and <br />in written narrative form. This understanding is then confirmed through transaction <br />testing, walkthrough observations, inquiry, observation, or other audit procedures. <br />F. Approach to be Taken in Determining Laws and Regulations That Will be Subject to Audit <br />Test Work <br />All federal programs used in the City will be identified through inquiries of program and finance personnel <br />and reviewing the state aid confirmation (for federal programs for which the state of Minnesota serves as a <br />pass-through agency). Federal Program Compliance Supplement requirements will be identified as <br />necessary. <br />The Minnesota Legal Compliance Audit Manual will also be used to determine laws and regulations that <br />will be subject to audit test workBeyond that, MMKR utilizes numerous other resources such as regular <br />withoommunioetion applicable federal and state oversight agencies and regulatory bodies, professional <br />education, active participation in relevant professional orgonizationo, an extensive and up-to-date |ibrery, <br />and our experience inworking with Minnesota cities toensure that all applicable laws and regulations are <br />addressed by our audit procedures. <br />