UTL Updates

AuditWare Utilities Updates

UPDATE 10/22/11
A new command to "Go to AuditWare's Web Site" has been added to the Access Menu. This change requires an update of the AuditWare Engine as well.

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

UPDATE 6/1/11
The help files and user manual exhibits were revised extensively within AuditWare.

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.

UPDATE 7/21/10
A new exhibit has been added to the AuditWare User Manual entitled "Installing Under Windows Vista and Beyond" which deals both with Windows Vista and Windows Version 7.

UPDATE 5/25/10
Chapter 9 of the user manual, "AuditWare Changes," has been updated for 2010.

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.

UPDATE 10/17/09
This is a change in date only in connection with a general mailing of all products on CDs to all AuditWare users.

UPDATE 8/30/09
This is a change in date only in connection with a general mailing of all products on CDs to all AuditWare users.

UPDATE 4/1/09
An annual review of the user manual has been completed and appropriate revisions made preparatory to a general AuditWare mailing on CDs in the near future.

UPDATE 4/1/09
User manual chapter 9, AuditWare Changes, has been updated to reflect the AuditWare changes made since August of 2008.

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

UPDATE 6/18/08
Several chapters and exhibits of the user manual were revised as a part of an annual review of such files.

UPDATE 5/29/08
Chapter 9 of the user manual and on help screens within AuditWare titled "AuditWare Changes" has been updated to included the changes since August, 2007.

UPDATE 2/12/08
This changes the AW.BAT file from loading the ACCESS file (with no file extension specified) to loading the ACCESS.WK3 file. This prevents the inadvertent loading of an ACCESS.WK4 file when loading AuditWare and when that file exists.

UPDATE 8/12/07
This is a change in several help files only.

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

UPDATE 6/1/07
Several chapters and exhibits of the user manual were revised as a part of an annual review of such files prior to shipping printed user manuals.

UPDATE 11/14/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.

UPDATE 11/2/06
Exhibit 15 of the user manual, "Reconciliation Lists," has been updated to add the new items added to the lists recently. Thanks to Roy Salinas of Oscar Gonzales, CPA in Pharr, Texas for catching the need for this update.

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.

UPDATE 6/4/06
Chapter 6 of the user manual, "AuditWare Changes," has been updated to include the changes made to AuditWare since August of 2005.

UPDATE 11/8/05
The IMPORT.BAT batch file has been changed to create a done.flg signal file. This file extracts documents from the archive files of other clients in connection with the "import paragraph" command.

UPDATE 8/9/05
Several chapters and exhibits of the user manual were revised as a part of an annual review of such files prior to shipping printed user manuals.

UPDATE 7/9/05
Chapter 8 us the user manual, "AuditWare Changes," has been updated to add additional CSD changes.

UPDATE 5/3/05
Chapter 8 us the user manual, "AuditWare Changes," has been updated to show the changes for all products since August of 2004.

UPDATE 7/8/04
Chapter 8 of the user manual, "Setting Up The Chart of Accounts." has been moved from AuditWare Utilities to being a part of each AuditWare product so that it can be more detailed in the AuditWare for Local Governments product than in other products.

UPDATE 6/6/04
Chapter 10 of the user manual, previously titled "Implementing the new reporting model," has been split into two chapter, the first dealing with initial implementation (the first year) and the second dealing with the input and adjustments needed every year. Also, Chapter 9, which lists AuditWare changes, has been updated for 2004.

UPDATE 1/15/04
The batch file for making an installation disk for a USB drive has been revised to report the correct drive letter.

UPDATE 12/27/03
Two new batch files were added and several others edited in connection with today's update of the AuditWare Engine allowing saving of client data to storage drives other than diskette drives.

UPDATE 11/10/03
This was only a change in the version date in connection with a general mailing on CDs.

UPDATE 10/11/03
1) Chapter 10 of help was updated regarding dealing with transfers in the internal service fund lookback adjustment; 2) The file for the optimum fund balance schedule in the TSD product is now installed even when the existing file is newer than the one being installed.

UPDATE 10/02/03
Help files were changed to discuss the new Pentamation file type in the TSD product.

UPDATE 10/02/03
An installation batch file associated with a proprietary product was changed.

UPDATE 9/16/03
Help files regarding the FieldWork module were updated to include the new utility. See Engine Changes for this date for more information.

UPDATE 8/10/03
The installation procedure now removes from memory the macro file which runs the access menu before starting the installation when an installation is run from within AuditWare. Not to do so was causing that file not to be updated on some computers and possibly removing it entirely on others.

UPDATE 6/5/03
The batch file which runs when switching products now deletes the FOOT file (new model notes to the financial statements) before loading the new product. If the product being loaded does not contain such a file, the notes will then be set for "Placeholder Only" automatically in the new model.

UPDATE 6/5/03
1) The "Program Revenue Matrix" has been made a part of AuditWare products. Also, the batch files which run when switching products, creating installation disks and installing have been revised to accommodate this change.
2) When installing AuditWare products you are now prompted for your state when installing a CD which includes products associated with more than one state. This change is primarily associated with the CDs distributed at AuditWare workshops and seminars, allowing us to include all products (Texas and California) on all CDs while preventing the cluttering up of your hard disk with products you will never have occasion to use.

UPDATE 6/4/03
The "Notes to Prior Users" chapter of the user manual has been updated for 2003.

UPDATE 5/22/03
Several chapters and exhibits of the user manual have been updated to add a reference to the new setting regarding whether to place default entries in the AW column of the trial balance automatically.

UPDATE 11/22/02
The audit data feed file, when present, is now automatically placed in the C:\Aw\Datafeed folder and this update creates that folder on your computer.

UPDATE 11/11/02
When updating the archive file, the batch file which creates the EDS file no longer attempts to do so if the EDS.LST file is not present.

UPDATE 11/4/02
The necessary batch file was added to accommodate saving the audit report files into a zip file.

UPDATE 11/3/02
The necessary batch and list files were added to accommodate the new process of creating an "archive" file of current period data only which was implemented in the AuditWare Engine today.

UPDATE 10/8/02
This was a change in version date only in association with a general mailing by CD.

UPDATE 10/3/02
1) Chapter 10 of the user manual, "Implementing the New Reporting Model," has been revised to expand the "Implementation Steps in Brief" section.
2) Exhibit 5 of the user manual, "AuditWare Chart of Accounts" has been revised to state that if the revenue function is left blank for revenue identified as program revenue (1, 2 or 3 in the AW column of the trial balance), that revenue is allocated to all expenditure functions in the trial balance.

UPDATE 9/27/02
A message was added to the message database.

UPDATE 9/27/02
User manual exhibit 5, "AuditWare Chart of Accounts" has been revised to add AW account 125, "Restricted for Scholarships" to the list of "restricted for" accounts.

UPDATE 9/22/02
Chapter 10 of the user manual, "Implementing the New Reporting Model," has been revised to add information about the automatic allocation of program revenue when the RFN column is left blank.

UPDATE 9/17/02
Chapter 10 of the user manual, "Implementing the New Reporting Model," has been revised to expand the discussion of Other Resources and Other Uses accounts in relation to the statement of activities, particularly in regard to special and extraordinary items and contributed capital accounts.

UPDATE 9/14/02
1) Chapter 10 of the user manual, "Implementing the New Reporting Model," has been revised to add a discussion of the new menu command for automatically allocating program revenue among revenue functions based on percentages of functional expense. Guidance regarding the use of equity codes was also added to the section on using the government-wide adjustment journal.
2) The menu tree for the Codes menu was revised to add the "Allocate Revenue" command.

UPDATE 9/10/02
Chapter 10 of the user manual, "Implementing the New Reporting Model," has been revised to add a discussion of the new setting for automatically making internal service fund "look back" adjustments. See the Engine Changes dated 9/10/02 for more information.

UPDATE 8/25/02
Chapter 10 of the user manual, "Implementing the New Reporting Model," has been revised to remove the instruction that equity amounts be adjusted out of internal service funds when making the "look back" adjustments. Only the original revenue and expense need be removed.

UPDATE 7/30/02
Chapter 1 of the user manual,"Getting Started," been revised to advise of a special step when performing an initial installation using Windows XP.

UPDATE 7/14/02
This was a only a change in the version date to make it consistent with that of the AuditWare Engine for purposes of the CD distributed at the seminars.

UPDATE 7/11/02
The install file has been changed to properly establish the initial settings for the two new settings associated with justifying text. Minor cosmetic changes were also made in a few of the batch files.

UPDATE 6/30/02
Chapter 10 of the user manual, "Implementing the New Reporting Model," has been expanded to comment on the need to close out "clearing account" agency funds, since they no longer qualify as agency funds under GASB 34.

UPDATE 6/29/02
Chapter 8 of the user manual, "Setting Up The Chart of Accounts," has been expanded to provide information on setting up the financial statements for the new reporting model.

UPDATE 6/7/02
The user manual exhibit which lists the reconciliations for the new reporting model has been revised to match the changes made in the AuditWare Engine today.

UPDATE 6/1/02
Client files (archive files) may now be loaded from a CD-ROM disc without having to include them in an \AWBARN folder on the disc. To do so, you must include an CDROM.FLG file on the disk, since AuditWare uses its existence to know that it is running from a CD. It doesn't matter what's in the file, if anything; only its existence is tested by AuditWare. This change was primarily so that sample clients could be included on CDs used at the summer seminars.

UPDATE 5/|25/02
The following changes have been made to Chapter 10 of the User Manual, "Implementing the New Reporting Model" under the section "Implementation Steps in Brief":
1) Instructions were added to adjust out "Investment in Fixed Assets" and "Amounts to be Provided" when present.
2) In the section regarding checking out your work a remark was added that by selecting "custom" from the lead schedule menu in Report Master reports can be generated based on the "AW" column of the trial balance (program revenue, capital assets, related debt, etc.).

UPDATE 5/15/02
1) Chapter 10 of the user manual has been revised to add the suggestion that the TEA's program revenue matrix is helpful when determining the category (program or general) of revenue for the new reporting model.
2) The TEA's program revenue matrix has been added as Exhibit 14 of the user manual and can no be accessed using AuditWare's help menu.

UPDATE 5/4/02
Chapter 10 of the user manual has been revised to expanded the section on making "look back" adjustments for internal service funds and to provide an example.

UPDATE 4/25/02
Chapter 10 of the user manual has been expanded further to include a section on "Dealing with the Reconciliations." Also, the explanation of the "look back" adjustments for internal service funds has been revised in that chapter.

UPDATE 4/21/02
1) Chapter 10 of the user manual and help, "Implementing the New Reporting Model," has been expanded.
2) The "Significant Changes in Audit Guidance" exhibit of the user manual has been updated from providing 2000-2001 guidance to providing 2001-2002 guidance.

UPDATE 4/15/02
1) Conforming changes were made in connection with major Engine Changes.
2) The "Equity Closing Codes" exhibit of help has been removed and replaced with "AuditWare Chart of Accounts," a list of the arbitrary accounts which must be entered in the new RFN (revenue function) and AW (AuditWare) fields of the trial balance to produce the government-wide financial statements under the new reporting model.

UPDATE 2/1/02
1) A new batch file (ZAPDATA.BAT) has been provided which in most cases will only be used under Windows XP. When deleting files from the \AWDATA folder in connection with switching clients, it provides a series of commands which delete files which have file extensions that start with each letter of the alphabet or numbers 0 through 9.

2) When using "Load a Different Client", additional help about how to proceed now appears on the screen in the rare case where not all files of of the previous client are deleted from the \AWDATA folder. This and other refinements were provided in files ARC.BAT, LOADHARD.BAT and LOADFLOP.BAT.

UPDATE 1/11/01
While minor changes were made, this is primarily a maintenance update to bring the version date consistent with that of the AuditWare Engine.

UPDATE 12/9/01
A minor change was made in the installation procedure to assure that the AuditWare version year is set for the current year when you start a new client, making it unnecessary to use the AuditWare Tools menu to change it.

UPDATE 11/13/01
A minor change was made in the process of creating an install disk useful only to those who want to use a CD-RW drive to do so. Most users will not need this update.

UPDATE 9/30/01
The installation procedure has been changed. Each time you install either a diskette or CD-ROM disc which installs the AuditWare Utilities a menu appears which gives you the opportunity of placing AuditWare on your desktop Programs menu. This change is primarily for initial installations. If you are using a shortcut or if AuditWare is already on your "Start, Programs" menu you will not need this update.

UPDATE 9/26/01
When loading a client from a floppy disk and that client is already on the hard disk, a backup copy of the client's archive file is now copied to the \AW\TEMP folder in case the loading process is unsuccessful, such as when the diskette has a bad sector. See Engine Changes for more details.

UPDATE 9/17/01
A minor change was made affecting only one user. Others will not need this update, assuming the 9/4/01 or 9/15/01 update has been installed.

UPDATE 9/15/01
A minor change has been made in the process of creating an installation disk for the AuditWare Engine when selecting "Create an AuditWare installation disk" from the "Tools which are seldomly used" menu. Most users will not need this update (assuming the 9/4/01 update has been installed).

UPDATE 9/4/01
1) All installation files have been updated to allow up to 3 products or up to 2 products and the AuditWare Utilities to be placed on the same diskette when selecting "Create an install disk from a file downloaded from the internet (TheAudit.com). You can also install an AuditWare CD-ROM installation disk when available. To place multiple products or AuditWare Utilities on the same diskette, simply process one of them, then for each of the succeeding ones answer No ("N") when asked if you want to delete the existing files from the diskette. Incidentally, you will be asked "Do you want to update this computer?" after each one. You will save time if you answer No on each one until you get to the last one, then everything on the diskette will be installed at once.

2) There is a new tool for those who have a CD-RW drive. It is listed under "Tools Seldom Used" and allows you to prepare files for creating an CD installation disk . You must first have created a folder called "CDCopy" on your C: drive before you can use it. The command is called "Prepare files for a CD-ROM disk" and will prompt you as to which products you want to include on the disk. The command uses the latest versions of the Engine, Utilities or products you have installed on that computer, so you must first have updated that computer with the latest versions (not just downloaded them from the internet) before the process is meaningful. This allows users who have a number of computers on which AuditWare is installed to update only one of them from the internet and then to burn one CD from that computer and update all products, the engine and utilities with that CD on all other computers. The resulting CD is used just like multiple diskettes are. Select "Install and AuditWare Update Disk" from the AuditWare Tools menu, then select "CD-ROM" and enter the drive letter.

UPDATE 8/15/01 (Initial Update)
1) The AuditWare Access Menu file has been removed from AuditWare Utilities and placed in the AuditWare Engine. Within Utilities this required changes in the installation procedure. The AW.BAT file, which is recreated with each installation or update and placed in the \aw\utl folder, now loads the access menu file from the \aw folder, rather than from the \aw\utl folder. This should make changes to AuditWare Utilities less frequent.

2) When a new installation disk is created on a diskette for a product, the product password for changing the year to the new year is now included. This involved changes to one of the batch files in Utilities.

3) A version date of AuditWare Utilities has been added and now appears at the bottom of the AuditWare Access Menu screen.