AuditWare Engine Updates

ENGINE UPDATE 10/26/11
1) A change was made in the process for determining the wording of portions of the last paragraph of the opinion on the financial statements to prevent occasionall repetitions.
2) AuditWare now ignores versions of the client and client2 files which carry a .wk4 file extension. Such files are occasionally inadvertently created.

ENGINE UPDATE 10/22/11
1)
A new command to "Go to AuditWare's Web Site" has been added to the Access Menu and the command "Change the Reporting Model" has been moved from the Access Menu to the AuditWare Tools menu, since it is rarely used. This change requires an update of the AuditWare Engine as well.
2) The AuditWare Tools menu has been expanded to add the command "Go to Windows Explorer to view files or folders." 

ENGINE UPDATE 10/21/11
The Auditor's Opinion on the Financial Statements has been revised to include or exclude the disclaimer phrase "except that portion marked unaudited on which we express no opinion" based solely on the answer in the "questionnaire for the letters" as to whether to include it. Previously it was being excluded for users of Audit I.S.D. for Texas School Districts (TSD) when the optimum fund balance had been deactivated. The default answer to that question on the questionnaire has been changed to 2 (No) for all users, so users of TSD will need to remember to set that answer to Yes if they are presenting the optimum fund balance schedule. This update also prevents the words "This information" from sometimes appearing twice in succession in the disclaimer sentence. Thanks to Peggy Lantz, CPA of Karen A. Jacks and Associates, PC, Longview, TX for letting us know about this.

ENGINE UPDATE 10/17/11
The setting for using the old (2009, pre-SASs 118-120) version of the auditor's opinion on financial statements has been reactivated at customer request. It is part of the "Exhibit Creation Settings" category of settings.

ENGINE UPDATE 10/14/11
The "Object" lead schedule in Report Master was revised for users of AuditWare for California School Districts to add the general revenue categories of the statement of activities used in the California Unaudited Actuals SACS report. This enhancement was suggested by Nicole Centofanti, CPA of M Green and Company, Visalia, CA.

ENGINE UPDATE 10/6/11
Changes were made in connection with the changes to the California School District product changes this date.

ENGINE UPDATE 9/26/11
The Auditor's opinion on the financial statements has been revised to correct overlapping wording (using both "is" and "are") and to leave out the phrase "except for that portion marked unaudited on which we express no opinion" for Texas school districts when the Optimum Fund Balance Schedule is inactive.

ENGINE UPDATE 8/29/11
The Auditor's opinion on the financial statements has been revised to accommodate leaving up to 12 blank rows at the top to make room for the firm's letterhead, as opposed to the default setting of 7. This setting is in the "Questionnaire for the Letters" in the FieldWork module.

ENGINE UPDATE 8/19/11
There is a new "LAST-YEAR" command for importing the prior year reconciliation "names" and descriptions for use in the current year. It is located on the FieldWork module Reconciliations menu.This can be used when you edited the reconciliations screen last year and you don't want to retype the changes this year.

ENGINE UPDATE 8/17/11
The auditor's opinion report on the financial statements has been revised in the following ways:
1) A report worded for non-Yellow Book audits may now be produced. A new setting, "Is this a Yellow Book audit", is now included in the Client Settings category of settings (not in the questionnaire). When set for No, the G.A.S. auditor's report is also automatically deactivated.
2) The additional wording in the report which appears when a Yes answer is given in the questionnaire as to whether you have been engaged to audit at a more detailed level than the opinion unit level has been corrected to be consistent with the current examples in PPC's ALG guide.
3) The disclaiming of "part of additional information" is now active again for all products. However, for TSD users that wording is now automatically omitted when the non-audited Optimum Fund Balance schedule has been deactivated, since the TEA has announced that it is now an optional schedule, at least for 2011.
4) For users of TSD, the "other supplementary information" section of the audit report is now referenced in the final paragraph, along with other information which is not a required part of the financial statements.

ENGINE UPDATE 8/12/11
Changes were made in connection with a new setting for the California School District product. 

ENGINE UPDATE 7/26/11
There is now a "Last-Year" command on the government-wide adjustment journal menu which allows you to import last year's government-wide journal and save it as this year's journal. Thanks to Frank Steele of Anderson, Marx and Bohl, PC in Corsicana, TX for suggesting this change.

ENGINE UPDATE 7/26/11
The setting for optionally using the 2009 version of the Auditor's Report on the Financial Statements has been removed, since it is no longer needed.

ENGINE UPDATE 6/9/11
A change was made to accommodate the changes made to the Audit I.S.D. product today.

ENGINE UPDATE 6/1/11
This is a change in date only in connection with a general mailing of all products on CDs to all AuditWare users.

ENGINE UPDATE 5/15/11
All three auditor's reports have been reviewed against PPC's "Guide to Audits of Local Governments" and the auditor's reports within AuditWare have been revised accordingly. Also, a new question has been added to the questionnaire for the auditor's opinion on the financial statements as to whether the client is a component unit of another government.

ENGINE UPDATE 4/27/11
A typo in the new auditor's opinion on the financial statements whereby an extra "is" is present in the final paragraph in certain circumstances has been corrected. Thanks to Dianne Sollock of Kenneth C. Davis & Co., PC in Huntsville, TX for catching and reporting this error.

ENGINE UPDATE 2/4/11
The general fund budget comparison is now placed in the "basic" section of the table of contents when the setting for doing so is set and the title is changed from that of a schedule to that of a financial statement ("Statement of Revenues, Expenditures, etc.).

ENGINE UPDATE 12/3/10
The new version (see Engine Update of 10/25/10 below) of the auditor's opinion on the financial statements has been revised for users of AuditWare for California School Districts (CSD) to add the following sentence as a part of the final paragraph: "The accompanying other supplementary information is presented for purposes of additional analysis as required by the State's audit guide, Standards and Procedures for Audits of California K-12 Local Education Agencies 2009-10, published by the Education Audit Appeals Panel, and is also not a required part of the financial statements." This change was provided by a representative of the State Controller's Office to Aubrey King, CPA of Wilkinson Hadley King and Co., LLP of El Cajon, CA, who passed the information on to us today. Those using the old version of that letter will not need to add this disclosure.

ENGINE UPDATE 11/19/10
The Report Master process of producing lead schedules for the Indirect Cost Schedule (see yesterday's update below) has been corrected and is now fully functional. The selection list of funds to include also now includes a selection for "Funds used to create the Indirect cost schedule" (general and special revenue funds) at the bottom of the list.

ENGINE UPDATE 11/18/10
"Indirect Cost Schedule" has been added as a selection on the Report Master menu for lead schedules for users of Audit I.S.D. for Texas School Districts. It's purpose is to allow those users to see what makes up the various dollar amounts on that schedule.

ENGINE UPDATE 11/8/10
A problem with the auditor's opinion on the financial statements (new version) has been corrected. In the last paragraph, the sentence describing the material presented for additional analysis previously was partially repeating itself when combining statements are active. Thanks to Dianne Sollock of Kenneth C. Davis and Company, P.C. in Huntsville, Texas for reporting this.

ENGINE UPDATE 11/1/10
The file name associated with the new setting for using the previous auditor's opinion (see 10/25/10 and 10/28/10 updates below) has been changed from OLDLTR1N to LTR1NOLD to prevent it's deletion when changing AuditWare products.

ENGINE UPDATE 10/28/10
The new setting for using the previous auditor's opinion (see 10/25/10 update below) is now fully functional. Some users were getting a "file does not exist" error when using the setting.

ENGINE UPDATE 10/27/10
The new setting for automatically allocating TRS on-behalf by function on the statement of activities may now be successfully "turned off." The setting, which is only available to users of Audit i.S.D. for Texas School Districts, appears in the "Government-Wide Settings" category of settings. Thanks to Gary Davis, CPA of West, Davis and Company, LLP in Austin, Texas for reporting this problem.

ENGINE UPDATE 10/25/10
There is a new setting which allows you to create the auditor's opinion on the financial statements in either last year's version (pre-SAS Nos. 118-120) or this year's version (with early implentation of SAS Nos. 118-120 as shown in PPC's Guide to Audits of Local Governments of February, 2010). To change the setting as to which opinion version to use, go to Settings, select Category, then the FieldWork and Miscellaneous category. It is the last setting on the list. It is worded "Use the 2009 (pre-SAS Nos. 118-120) auditor's opinion on fin. statements?".

ENGINE UPDATE 10/15/10
This was a change in version date only in connection with a general AuditWare update mailed to all users on CDs.

ENGINE UPDATE 10/7/10
1) The auditor's opinion on the financial statements has been revised to comply with SAS Nos 118-120. The new report is based on PPC's example in Volume 2 of Guide to Audits of Local Governments, Appendix 11-E.
2) The list of CFDA numbers which are involved in federal clusters has been updated from the OMB's 2010 Compliance Supplement, Part 5. These are used to asterisk the federal programs on your SEFA schedule if they are included in a cluster. You should update your product(s) as well.

ENGINE UPDATE 9/24/10
1) The G.A.S. auditor's report has been updated to reflect the internal control terminology and definitions of SAS 115. The new report is based on Appendix 11F1 and 11F2 of PPC's Guide to Audits of Local Governments when no material weaknesses are found and on Example 4-7 on the AICPA's web site for reports identifying material weaknesses. Thanks to Michael Edgin, CPA of Edgin, Parkman, Fleming and Fleming, P.C. of Wichita Falls, Texas for pointing out the need for this change and supplying the link to AICPA's web site.
2) The "questionnaire to the letters" in the FieldWork module has been revised to be consistent with the above change.

ENGINE UPDATE 9/22/10
1) The SEFA schedule now automatically identifies ARRA stimulus funds with the leading prefix "ARRA -" rather with a trailing suffix of "- ARRA" at the end of the fund name as in the past. Using a prefix to identify such funds is specified in the OMB's 2010 A-133 Compliance Supplement. Thanks to Cheryl Wakefield of Hereford, Lynch, Sellars & Kirkham, P.C. of Cleveland, Texas for suggesting this change and providing the documentation from the compliance supplement.
2) The command to delete an entire fund-level adjustment journal in the FieldWork module is now functional.

ENGINE UPDATE 9/21/10
Changes were made to several areas in connection with the fact that the Texas Education Agency has done away with the use of special federal program codes (so-called "k-codes") in the "data feed" submission for the SEFA schedule, replacing them with CFDA numbers. Revisions were made to the SEFA, to the special input for the SEFA in the FieldWork module and to the Individual Fund category of settings. The TSD product must also be downloaded and installed to get the full change.

ENGINE UPDATE 9/15/10
References to the Statement of Net Assets and to the Statement of Activities in both of the government-wide reconciliations are now capitalized as proper nouns. Thanks to Derek Anderson of Belt Harris Pechacek, LLP, Bellville, Texas for this suggestion.

ENGINE UPDATE 8/14/10
A new "Restore-Default" selection was added to the menu which appears in FieldWork when viewing manually entered schedules which allows you to restore AuditWare's default version of that schedule if desired.

ENGINE UPDATE 7/21/10
OfficeWork settings were updated to accommodate activation of template versions of the Statement of Net Assets and the Statement of Activities. See today's changes for the CSD product.

ENGINE UPDATE 7/8/10
1) The auditor's report on major program compliance and internal control in accordance with Circular A-133 has been changed to reflect the revised wording required by SAS 115.
2) The Control J quick key used for justifying paragraphs has been changed as well as the process of deleting particular periods of client data. Both changes are to make these processes compatible with Windows 7.

ENGINE UPDATE 5/25/10
This was a change in version date only in connection with a general AuditWare update mailed to all users on CDs.

ENGINE UPDATE 3/24/10
A change was made to the process of viewing reports in Report Master (the RPTGO routine) to accommodate larger computer monitors.

ENGINE UPDATE 3/10/10
The criteria for creating the governmental operating statements has been changed for the ALG product to include lines which have offsetting amounts in multiple columns which total to zero.

ENGINE UPDATE 12/13/09
The criteria for custom lead sheets in Report Master has been changed to allow alpha characters in the Organization Code field of trial balances.

ENGINE UPDATE 11/20/09
1) An occasional problem has been corrected in which the fund level adjustment journals appear to be lost even though the associated journal entries remain posted to the trial balance. The routine changed was GETJOUR.
2) The routine which makes a backup copy of a client's fund list has been changed to only do so when there are 10 or more funds in the list. This prevents backing up a "problem" fund list with one or two funds.

ENGINE UPDATE 11/2/09
The official version date for fund lists (the TBLISTDATE) has been changed so that all fund lists are updated, including those previously omitted prior to the 10/27/09 Engine update.

ENGINE UPDATE 10/27/09
A technical change was made to the routine which updates fund lists when a column has been added by AuditWare (CVTBLISTS). The new routine insures that all fund lists from all data periods are included.

ENGINE UPDATE 10/25/09
A problem for users of AuditWare for California School Districts in creating the statement of fiduciary net assets when only one fiduciary fund exists has been corrected. This problem resulted from the 10/7/09 update (see below).

ENGINE UPDATE 10/17/09
This is a change in version date only in connection with a general AuditWare update mailed to all users on CDs.

ENGINE UPDATE 10/7/09
The method of removing inactive (zero balance) rows for the basic financial statements has been revised for users of the AuditWare for California School Districts product to cause rows which have the same amount in two columns but with reverse signs to be retained, even though they total across to zero. See the CBROWZAP routine in the BAMAKE file.

ENGINE UPDATE 9/29/09
1) The process of FieldWork input for the SEFA schedule (under GoTo, Input, Other_Input) has been revised to identify non-cash assistance with the word ""(Non-cash)" following the title of the federal program. For users of the Audit I.S.D. for Texas School Districts (TSD) product, the TEA federal program codes (so called K-codes) is also set automatically based on whether it is cash assistance or non-cash assistance. Users of the TSD product should download an upload of the product as well.
2) Associated with the above change, there is a new setting in the Individual Fund category of settings called "Omit this fund from the SEFA?". This will be used only by users of the TSD product to prevent duplication of amounts in the SEFA schedule when that fund's amounts have been entered in FieldWork input (GoTo, Input, Other Input.

ENGINE UPDATE 9/18/09
A problem with placing the dollar amounts from the questionnaire into the new OPEB note for Medicare Part D in the Audit I.S.D. product has been corrected.

ENGINE UPDATE 9/2/09
The routines have been revised for creating the indirect cost schedule for the Texas School District product to properly capture the amount of function 99 reported in Note A. Previously that amount was reported as the amount reported on the schedule for object 6213, assuming that all such amounts would be function 99. An update of the TSD product dated today or later is also required. It may also be necessary to resave the fund(s) which include function 99 amounts for this update to be effective.

ENGINE UPDATE 8/31/09
The method of displaying the message when verifying as to whether an adjustment journal is in balance has been changed to be compatible with the Vista operating system.

ENGINE UPDATE 8/30/09
This was a change in version date only in connection with a general AuditWare update mailed to all users on CDs.

ENGINE UPDATE 8/28/09
A federal program was added to a list of CFDA numbers associated with creation of the SEFA schedule (the CFDAS rnage in the AW file was changed).

ENGINE UPDATE 8/14/09
The automatic government-wide lookback adjustment now runs only for internal service funds even when the fund type is blank.

ENGINE UPDATE 7/27/09
1)Three typos in the wording of the government-wide reconciliation items were corrected (missing periods, etc.).
2) The Standard Trial Balance report in report master now omits the SAG1 and SAG2 columns when running the TSD or CSD products.

ENGINE UPDATE 7/25/09
When determining whether a line in a trial balance is "inactive," entries in the "Budget Basis Adjustments" column are now considered, in addition to those in other columns. Thanks to Chris Rutledge of Rutledge & Crain, Arlington, TX for catching the need for this change.

ENGINE UPDATE 6/27/09
1) A new "Last-Year" selection has been added to the menu for "manual" files accessed from the FieldWork module like the one available from the OfficeWork menu.
2) In the notes to the SEFA schedule, italics is now used instead of all caps when referring to publications.
3) The method of generating italics in the auditor reports has been changed to prevent problems when printing on some printers.
4) The "Schedule of Excess Sick Leave" previously active for the AuditWare for California School Districts product has been made inactive by default.
5) All of the above changes were suggested by Wilkenson, Hadley and King, CPAs of El Cajon, CA.

ENGINE UPDATE 5/27/09
1) The list of clustered federal programs used in creation of the Federal SEFA schedule has been updated per the March, 2009 version of the OMB's A-133 Compliance Supplement. Two new programs were added and nineteen removed. Also, this updating procedure has been moved to the AuditWare Engine from the three products.
2) The process of creating a state compliance letter for California school audits has been revised to accommodate the use of brackets within the text.

ENGINE UPDATE 4/8/09
Another technical change was made to the FWLOADSAGS routine to load the object code definition file using a cell address range, rather than the entire file, to handle files which have become corrupted and will otherwise generate a "worksheet full" error message.

ENGINE UPDATE 3/30/09
A technical change was made to the FWLOADSAGS routine to prevent an error when using the Control I quick key with a large number of SAG names.

ENGINE UPDATE 3/5/09
A technical change was made to the FWLOAD routine to prevent a reference to 1997 in the name of a fund in the fund list from being automatically changed to 2007.

ENGINE UPDATE 2/16/09
A new setting has been added to Report Master which allows a footer when printing trial balances and other reports which states that it is a draft only and gives the date and time similar to the "draft" footer used with audit report printing. While in Report Master, this setting is accessed by selecting # 3, "Change the report settings," then DEFAULT, then DRAFT_FOOTER. Thanks to Chris Rutledge of Rutledge Crain & Company, Arlington, TX for suggesting this change.

ENGINE UPDATE 2/7/09
The current client is no longer automatically deactivated when exiting AuditWare when the drive for archiving client data is set for a drive other than C. The setting under the "FieldWork and Miscellaneous" category of settings called "Deactivate the current client when exiting AuditWare?" is now functional for drives other than C (such as when using a network drive). The three possible settings are Yes, No and Ask Me.

ENGINE UPDATE 2/6/09
1) The process of posting the reconciliation "names" to the trial balance of the "governmental activities" fund type (those containing capital assets and long-term debt) when posting the G-W adjustment journal has been improved to post the name even when the account appears multiple times in either the G-W journal or the trial balance. However, if the same account is used with more than one reconciliation name in the journal, AuditWare will use only the first name that occurs in the journal when posting. Therefore, it is better to vary the account slightly for the other reconciliation names, such as by adding a decimal position to the object code or using the organization code or program code if those are not otherwise in use. Keep in mind that this discussion applies only to "governmental activities" funds. For Texas school districts, those would be funds 901 and 901 and for California schools, fund 105 or other fund number choice.
2) A new setting has been added under the "Government-Wide Settings" category of settings called "Post reconciliation names when posting the G-W journal?". The default setting is yes. This setting has been added to allow the user to "turn off" such posting when they have manually edited the names in the trial balance and do not want them overwritten.

ENGINE UPDATE 2/4/09
1) For the benefit of AuditWare for Local Governments (ALG) users who place their SAG (Specified Account Group) names directly in the trial balance, those SAG names are now automatically captured from the prior year trial balance when present in the prior year but none have been entered in the current year.
2) A new setting has been added under the "FieldWork and Miscellaneous" category of settings called "Capture trial balance SAG names from the prior year?". The default setting is Yes.

ENGINE UPDATE 1/29/09
1) A new selection has been added under "Use AuditWare Tools" (Tools Seldom Used) on the Access Menu which allows the user to reload any individual client data file from any of the client's archive files. This will typically be used under the direction of AuditWare support personnel to replace one of the client's files which has become corrupted with a fresh copy of the file
2) When OfficeWork settings are deleted by the user due to a corrupted file, the "creation date" portion of those settings are now automatically restored using the current date. 

ENGINE UPDATE 1/27/09
The new Report Master feature introduced on 11/7/09 which allowed per books amounts to be used in variance reports (see below) has not been working properly when using threshold amounts or percents. That problem has now been corrected. Thanks to Chris Rutledge of Rutledge, Crain & Co., Arlington, Texas for pointing out the need for this change.

ENGINE UPDATE 1/7/09
A new setting has been added to lead schedules created in Report Master which allows you to include post-closing equity in your reports and thereby tie out with the financial statements. It is worded "Include net income in equity?" and displays 'N/A" when running a report type other than a lead schedule. When viewing the main Report Master screen the new setting is near the bottom in the center column of settings. When set for Yes, lead schedules will include a separate line for the net income portion of equity with the letters "NI" in the function column of the report.

ENGINE UPDATE 12/4/08
The column width of the column which displays the date exhibits have been created in the OfficeWork module has been widened from 10 to 11 to prevent the display of asterisks as dates on some computers.

ENGINE UPDATE 12/3/08
The process of assigning exhibit letters (A, B, etc.) as part of the exhibit identification label (Exhibit A-1, etc) has been changed to accommodate the unusual situation in which the government-wide statement of net assets has been de-activated by the user.

ENGINE UPDATE 11/7/08
Yesterday's change has been extended to include the subtotals when they are used in the report.

ENGINE UPDATE 11/7/08
When running a Year To Year Variance Report in Report Master, you are now given a choice of using either adjusted or per books amounts. This feature was suggested by Derek Anderson of John C. Pechacek, CPA in Bellville, Texas.

ENGINE UPDATE 11/7/08
A routine associated with the notes to the financial statements was changed to accommodate the implementation of GASB 45 in the Audit I.S.D. for Texas School Districts product updated today.

ENGINE UPDATE 11/4/08
A minor change was made in the routine which checks whether the fund numbers present in the fund level adjustment journal match those in the associated trial balance (the JOURWRONG criteria was changed).

ENGINE UPDATE 10/12/08
In Report Master, a selection for private purpose trust funds has been added to the list of available fund types when producing lead schedules. This change was suggested by Robert Lake of Rutherford, Taylor & Company, PC of Greenville, Texas.

ENGINE UPDATE 9/29/08
The auditor's report on major programs (for single audits) has been revised to automate the inclusion of sole proprietor pronouns when appropriate in the final sentence of the next to last paragraph.

ENGINE UPDATE 9/9/08
The expression of the year in yesterday's update has been changed from "08" to "2008."

ENGINE UPDATE 9/8/08
AuditWare no longer checks network drives when it is initially loaded. That process caused some computers to slow down.

ENGINE UPDATE 7/2/08
A fifth line has been added to the internally generated letterhead optionally used on auditor reports. The change was suggested by Bob Wilkinson of Wilkinson & Hadley, El Cahon, California.

ENGINE UPDATE 5/29/08
The auditor reports within AuditWare have been reviewed against those provided in the latest edition of PPC's "Guide to Audits of Local Governments" and appropriate revisions made to all three letters to bring them into compliance.

ENGINE UPDATE 4/15/08
It is now possible to print a Major Fund Determination Report for all eligible funds with one command. From the FieldWork main menu, select Print, then Major Fund Determination Reports.

ENGINE UPDATE 3/22/08
The SEFA federal schedule has been changed to use a simpler method of printing, making it easier for the user to make manual changes to the schedule when necessary. It now uses the same method as employed for individual fund budget comparison schedules, with a visible print range and use of a "Pages" setting. The schedule will now accommodate an almost limitless number of pages, rather than being limited to four as in the past. Also, Three lines of help regarding the new format now appear at the top (outside of the print range). Schedules created prior to this change will be automatically changed into the new format when they are either printed or re-created.

ENGINE UPDATE 2/25/08
A problem with creation of the table of contents has been corrected in which combining statements of permanent funds were being omitted.

ENGINE UPDATE 2/12/08
When the access menu is loaded from the FieldWork, OfficeWork or Settings modules, steps are now taken to assure that the file ACCESS2.WK3  is loaded, rather than the file ACCESS2.WK4 when the WK4 file has been inadvertently created. Two AuditWare clients have had a problem lately with this issue.

ENGINE UPDATE 1/9/08
1) A change was made to attempt to assure that a client is updated and all files erased from the AWDATA folder when a client is deactivated.
2) A remote error was corrected which sometimes occurred when changing a fund's fund type to be an internal service fund using individual fund settings.

Click Here for 2006-2007 Engine Changes
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