AuditWare Development Co.




			AuditWare Engine Updates ENGINE UPDATE 12/29/07 Yesterday's new feature (see below) now includes the ability to define the codes in the trial balance, placing the definitions in the scratch pad. ENGINE UPDATE 12/28/07 The menu for the Control I (Interpret Codes) Quick Key used in a trial balance now includes an option for viewing a complete definition list of the account codes in the ORG column of the trial balance except when running the AuditWare for Local Governments product. When running Audit I.S.D. for Texas School Districts, this is the Organization code. For AuditWare for California School Districts this is the Resource code. Only the "View-All" option is currently available. Later the ability to define the codes in the trial balance (scratch pad) will be available. A version of the school district product dated today or later should be installed to have an up-to-date list of these code definitions. ENGINE UPDATE 12/27/07 The process of creating the statement of activities has been revised to properly handle formatting when the top section is considerably shorter than the bottom (general revenue) section. This change will only affect users of AuditWare for Local Governments. ENGINE UPDATE 12/20/07 1) The same change made on 11/28/07 (see below) for the basic financial statements has now been made for the combining financial statements. This prevents superfluous lines such as "Beginning fund balance, as restated" from appearing when there is no prior period adjustment. 2) The setup which provides object code definitions is now more "forgiving" to users of AuditWare for Local Governments. It will now accept at least one blank definition in the list. As in the past, it remains advisable to provide definitions for all object codes on the list. ENGINE UPDATE 12/14/07 A new setting has been added in the "Exhibit Creation Settings" category worded "Use combining statement of changes for agency funds?' with a default setting of No. When presenting a full CAFR this statement is automatically active but we believe it is not required when only presenting combining statements. This new setting forces that statement to be active even when the CAFR setting is set for No. This setting was requested by a user. ENGINE UPDATE 12/13/07 A problem in the creation of the Schedule of Expenditures of Federal Awards has been corrected in which the asterisk identifying clustered programs was sometimes omitted from certain federal programs. Thanks to Cheryl Wakefield of Hereford, Lynch Sellars & Kirkham, Cleveland, TX for sending us the data which helped us identify the solution to this problem. ENGINE UPDATE 12/2/07 A major new feature has been added in support of storing and accessing AuditWare client "archive" files on a remote computer in a computer network environment. Actually, it is an improved version of a feature which was a part of AuditWare prior to 1997, so some long-term AuditWare users may remember it. It prevents multiple users from opening a client which another network user already has open. Following are the aspects of this change: 1) A client is "locked" when it is opened by a user and it is "unlocked" when the user either switches to another client or de-activates the client. How this works behind the scenes is that a file named the same as the archive file's name but with a .LCK file extension is placed in the AWBARN folder of the computer being accessed when a client is opened. That file is deleted when it is "unlocked" (the client is closed). 2) The command "De-activate the current client" has been moved to the main "AuditWare Tools" (# 6) menu of the Access Menu from the "Tools seldom used" menu. 3) A new command "Unlock a locked archive file" has been added to the "Perform activities with archive files" menu for situations where the computer which opened the client is no longer connected to the network and for other special situations. 4) A new setting called "Change this computer's identification phrase" has been added to the "FieldWork and Miscellaneous Settings" category of settings. An initial installation of AuditWare has asked for such a phrase (i.e. Paul's laptop, the front office computer, etc.) for several years but now that it will be in use, you may wish to change it to something more appropriate. The phrase is used by the message board when you attempt to open a client already open by another user by identifying which computer already has the client open. 5) The setting "Check network drives when loading AuditWare or client data" has been de-activated since it is no longer needed and it's use slowed down some computers. 6) If you don't have a network or aren't using it with AuditWare, there will be no change in how you load and save data. However, since this change may encourage some who have a network to experiment with using it with AuditWare, here's how to get started: a) Create an AWBARN folder on the network drive (AuditWare need not be installed there); b) Copy the small "awbarn.prn" file from your C:\AWBARN folder to the new folder on the network drive; c) With a client loaded select "Use AuditWare Tools" from the Access Menu, then "Perform activities with archive files," then "Change the drive for archiving client data" and enter the appropriate drive letter. You will be asked if you want to update the new drive with this client's data, to which you normally will answer Yes. You may switch back and forth between the C: drive and the network drive at will. If you are certain all of the archive files on the C: drive are up to date, you may use Windows explorer or My Computer to copy all of the files from the C:\AWBARN folder to the AWBARN folder on the network instead of doing it one client at a time through the AuditWare menu. 7) We are leaving in place for now the practice of AuditWare's automatically de-activating the current client upon exit from AuditWare when the drive for archiving client data is set for a drive other than C:, but will consider removing that feature when this new process has been in use for a few weeks. ENGINE UPDATE 11/29/07 The datafeed file created by AuditWare for submission by Texas school districts to the Texas Education Agency has been revised, based on an e-mail received today from Paul Moreno of the TEA's audit division. The change adds line 9000, column 31 of the Delinquent Tax Schedule (Exhibit J-1) to the submission file. That line of Exhibit J-1 reports the portion of line 1000 paid into Tax Increment Zone under Chapter 311 tax code. ENGINE UPDATE 11/28/07 Technical changes were made to the exhibit creation process to prevent superfluous lines from being included on certain financial statements. Such lines include the line "Beginning fund balance, as restated" on the governmental operating statement when no prior period adjustment is present, and the line "Changes in net assets" appearing twice on the proprietary fund operating statement. ENGINE UPDATE 11/27/07 Changes were made to the process of copying a file for use with the ASCII file conversion process associated with the Audit I.S.D. product used in Texas. Users of the Audit I.S.D. product will also need to install a product version dated today or later to use this engine version. ENGINE UPDATE 11/15/07 The auditor's report on internal control and compliance in accordance with G.A.S. has been revised to correct the spelling of the word "adversely" in the paragraph which defines a significant deficiency. Thanks to John Arndt of M. Green & Co., Visalia, CA for catching and reporting this. ENGINE UPDATE 11/15/07 The auditor's report on internal control and compliance in accordance with G.A.S. and the questionnaire associated with that letter have been revised. The paragraph referring to the client's responses to the findings listed in the schedule of findings and questioned costs previously was activated when the user answered "Yes" to the question "Were there instances of noncompliance which are required to be reported...etc.?." With this change a new question has been added specifically addressing whether the client's responses were reported in the schedule of findings and questioned costs. If you have already accessed the questionnaire for a client for this year but want to have this change, you will need to go to the questionnaire in the FieldWork module, return to the menu and select "Restore Default." Any current year input in the questionnaire, if any, will be lost. Thanks to Caron Ketchie of M. Green and Company, Visalia, CA for catching the need for this change. ENGINE UPDATE 10/13/07 The auditor's opinion on the financial statements was revised to provide minor changes in wording to be consistent with the 02/07 version of PPC's "Guide to Audits of Local Governments." Thanks to David Parkman of Edgin, Parkman, Fleming and Fleming in Wichita Falls, TX for catching the need for this change. ENGINE UPDATE 8/12/07 Several suggestions made by attendees at our recent seminar have been made as follows: 1) You may now print the Individual Fund settings for all of your funds by selecting that command from the Settings menu. 2) Control N (Negative) has been renamed Control R (Reverse). This quick key reverses the sign of a dollar amount in the trial balance. 3) SAG1 and SAG2 columns have been added to lead schedules in Report Master when running the AuditWare for Local Governments product. ENGINE UPDATE 8/7/07 In the last (8/2/07) Engine update, a phrase within the definition of a material weakness in the second and third auditor reports was changed to read "or a combination of control deficiencies" instead of "or a combination of significant deficiencies" to be consistent with the wording in the AICPA's summary of SAS 112 on it's web site. However, since the latest version of these auditor reports on both the AICPA and PPC web sites use the word "significant", we have changed both of those reports back to the original wording ENGINE UPDATE 8/2/07 1) Changes were made to the second and third auditor reports to correct typos. 2) The government-wide statement of net assets will now handle financial statement setups in AuditWare for Local Governments which exceed the previous 63 row limit. Also, the statement now "shrinks to fit" on one page when printed. ENGINE UPDATE 7/6/07 Changes were made to accommodate the addition of the Schedule of Excess Sick Leave in the AuditWare for California School District product. ENGINE UPDATE 6/12/07 Changes were made to the second auditor's report to correct typos. ENGINE UPDATE 6/10/07 When accessing an outdated Questionnaire for the Letters in the FieldWork module, it is now automatically changed out for the current version. The current version deals with SAS No.112. Most input in the questionnaire is lost when the change out occurs. ENGINE UPDATE 6/9/07 1) The second and third letters (auditor reports) have been substantially revised to implement SAS No. 112 per the examples provided by PPC and the AICPA. If you are still working on an audit report for a period prior to 12/31/06 and have not finalized those reports, do NOT install this version yet. The term "reportable condition" becomes "significant deficiency" and is redefined and "material weakness" is redefined. See AuditWare News for more important information about this change. 2) A newly required schedule called "LEA Organization Structure" has been activated both in the FieldWork and OfficeWork modules for California school district audits. ENGINE UPDATE 6/1/07 The Questionnaire for the Letters has been changed replace the words "reportable conditions" with "significant deficiencies" in preparation for the implementation of SAS No. 112. ENGINE UPDATE 5/20/07 The procedure for creating the Statement of Activities when running AuditWare for Local Governments has been revised to allow for an unusually tall financial statement setup (more than the standard 64 rows). When this is the case AuditWare now shrinks the statement to fit on one page vertically, so if you have a second, facing page active you may wish to use the setting for printing both sides on one page. ENGINE UPDATE 3/20/07 In the unusual situation where one of the basic, fund-level financial statements exceed 68 rows in length, the process of resetting the print range and placing the reference to the footnotes at the bottom of the page has been improved. The routine changed is in the BAMAKE file. ENGINE UPDATE 3/14/07 1) The process of closing government-wide net income to a "restricted-for" category has been changed to omit the process when there is no government-wide net income, rather than when there is no fund-level net income (see formula in "netline" in the "field" file). 2) The creation of the TEA datafeed submission file for the Schedule of Delinquent Taxes when using the Audit I.S.D. product has been changed to allow tax rates to be entered as values, if desired, rather than as text. ENGINE UPDATE 2/12/07 A technical change was made to the process of creating the basic financial statements to attempt to prevent a line from being omitted when it has offsetting amounts in the columns of the statement (the line totals zero). ENGINE UPDATE 12/12/06 In Report Master, a change was made to the criteria for producing the year to year variance report for expenditures to include Other Uses as a part of expenditures instead of Other Resources. Thanks to Karen Milligan of Stephen G. Gilland, P.C. of bowie, Texas for catching the need for this change and reporting it to us. ENGINE UPDATE 11/27/06 1) A technical change was made to the process of creating combining statements. 2) Also, executing the Control N (Negative) quick key now generates a Yes/No menu before reversing the sign of the dollar amount where the curser is sitting when that dollar amount is on row 11 of a trial balance in the FieldWork Module (when the likely intention of the user is Control M, the letter just to the right of N). ENGINE UPDATE 11/26/06 The maximum number of funds which can be processed in connection with any single combining statement has been increased from 100 to 189. ENGINE UPDATE 11/23/06 The width of several columns in the FieldWork module, mostly those used for viewing trial balance data, were widened to accommodate amounts of 100 million or more. ENGINE UPDATE 11/14/06 This is a change in version date only in connection with a general mailing of AuditWare on CDs to all users. ENGINE UPDATE 11/1/06 1) An improvement was made in the process of changing the setting "Is this a budgeted fund?" to insure that data columns are created for the budget comparison schedule for that fund. 2) For users of Audit I.S.D., any references to "1997" in the names of funds on the fund list are now corrected to read "2007". ENGINE UPDATE 11/1/06 The 10/12/06 Engine update (see below) resulted in a conflict with the setting which removes italics from the financial exhibits when printing, making it nonfunctional. This update restores the functionality of that setting. ENGINE UPDATE 10/18/06 When converting old fund lists into the current year format, AuditWare now ignores old fund lists which have one or more numbers as column headings. ENGINE UPDATE 10/16/06 When running AuditWare for California School Districts and establishing a new fund, fund numbers 96 and 97 may now be used for a governmental activities fund. ENGINE UPDATE 10/12/06 All of the letters (auditor reports) now use italics instead of all caps when referring to publications. Users of AuditWare for California School Districts will have to download an update to that product to get the Auditor's Report of State Compliance in the new format. ENGINE UPDATE 9/29/06 1) When multiple prior period adjustments are made to governmental funds and these adjustments total to zero, the prior period adjustment line of the governmental operating statement is no longer omitted. Thanks to Ray Bailey of Richard P. Loughlin, CPA of Henderson, Texas for bringing up the need for this change. 2) When a prior period adjustment is made, the associated trial balance is now automatically saved. ENGINE UPDATE 9/25/06 The process of creating combining statements for discrete component units has been revised to add a total column. ENGINE UPDATE 9/24/06 The ASCII file conversion process has been changed. When converting a delimited to a non-delimited file, the inclusion of the original budget as a 3rd dollar amount is now honored when present. This primarily relates to Pentamation files used for Texas school districts. ENGINE UPDATE 9/14/06 The print margins were changed for several of the new statistical tables and an additional alternative table was added to the menu. Also, the new divider sheet for the statistical section has been moved from being a part of the engine to being a part of each AuditWare product. ENGINE UPDATE 9/11/06 A change was made in the process of creating the table of contents which will affect only one AuditWare user firm. ENGINE UPDATE 9/5/06 The engine has been updated to accommodate GASB Statement No. 44, which makes wholesale changes in the statistical section of a CAFR. See today's change of the AuditWare for Local Governments (ALG) product for more information. ENGINE UPDATE 8/12/06 Some ranges have been expanded in the columns to accommodate the new reconciliation lines added to the "lists" in the FieldWork module with the 8/3/06 Engine update. ENGINE UPDATE 8/4/06 For users of Audit I.S.D. for Texas School Districts, the amount of accreted interest on capital appreciation bonds required for Exhibit L-1. Schedule of School First Indicators, is now captured automatically from the government-wide totals of the trial balance. ENGINE UPDATE 8/3/06 1) The reconciliation "lists" in the FieldWork module have been expanded to add 18 new reconciling items, many of which are appropriate for users of AuditWare for Local Governments. Thanks to Chris Rutledge and Lewis Crain of Rutledge Crain and Company, P.C., Arlington, TX for suggesting these additions. 2) The printing of a "blank" page, the one that reads "This page left blank intentionally," now prompts for a page number and will include that page number when that page is printed by itself (as opposed to with a group of documents). If the new setting is active to follow various exhibits with a blank page, this feature is not active. 3) In Report Master when going to the "custom" screen to make entries for producing a "Custom" lead schedule, the previous entries in the Class column, if any, are now removed automatically. Thanks to Robert Lake of Rutherford Taylor & Co., PC, Greenville, TX for this suggestion. ENGINE UPDATE 8/2/06 This update implements several changes suggested by attendees at our workshops the week of July 24th. They are as follows: 1) When producing a full CAFR, three schedules reporting general fixed assets under the old reporting model are now available to report capital assets used in governmental funds under the new reporting model. These exhibits are inactive by default, since they are no longer required by the GFOA, so they will need to activated if they are to be used. 2) In a major change, there is a new setting which allows you to automatically print a blank page following the exhibit or document of your choosing anywhere in the audit report.. A "blank" page is one which contains the text "This page is left blank intentionally." When this setting is used, the old method of printing this page is de-activated. Select the "Printing, Page Numbers and Pennies" category of settings to find this new feature. 3) When using the command "Back up a client to another drive" on the Access Menu and selecting "USB Drive," you are now asked if you want to use the drive letter currently set or to change it. Thanks to Robert Lake of Rutherford Taylor & Co., PC, Greenville, TX for this suggestion. ENGINE UPDATE 7/15/06 This is a change in date only in connection with a general mailing of all products on CDs to all AuditWare users on this date. ENGINE UPDATE 7/11/06 A selection for March 31st has been added to the menu for selecting the fiscal month-ending when importing a paragraph of the notes. ENGINE UPDATE 6/1/06 Technical changes were made to the utility for deleting data periods to assure that the fiscal year digit 6 is associated with the year 2006. A related reminder message was added to the utility for changing a product's "notion" format. ENGINE UPDATE 4/13/06 When running AuditWare for Local Governments, you may now import paragraphs of the footnotes from clients which have a different fiscal month-ending than the client you are importing to. ENGINE UPDATE 2/28/06 A problem regarding the "freezing" of certain documents has been corrected. Previously, when the final active document was "frozen," the AuditWare user would get a "File does not exist" error when attempting to create all documents as a group or when using the Turnkey comand. ENGINE UPDATE 1/25/06 The wording of the default cash flow statement has been revised to change "Operating Transfers" to "Transfers" and "Deferred Revenue" to "Unearned Revenue." These are now the preferred wording of these items by the GFOA for a CAFR presented for an award. Thanks to Charles Fankhauser of Long Chilton LLP of Harlingen, Texas for passing this along. The wording of these items within each AuditWare product (the default financial statement setups) will be changed soon. ENGINE UPDATE 1/15/06 The maximum number of lines on which formatting numbers may be placed in financial statement setups for individual funds (budget comparisons) has been increased from 1000 to 2000 lines. Formatting numbers are those which result in underlines, double underlines, shading, etc. when the statement is created. Click Here for 2005 Engine Changes Click Here for 2004 Engine Changes Click Here for 2003 Engine Changes Click Here for 2002 Engine Changes Click Here for 2001 Engine Changes Click Here for 2000 Engine Changes Click Here for 1999 Engine Changes