AuditWare Development Co.




			AuditWare Engine 1999 Updates AUDITWARE ENGINE UPDATE (12/31/99) 1) The product(s) you are using (ALG or Audit I.S.D.) must also be downloaded and installed with this update; 2) Individual fund statements may now be created for the general and enterprise fund types. This interim change is a part of a larger project underway which will eventually provide such statements for all funds. For users of AuditWare for Local Governments (ALG), this allows you to detail out departmental expenditures in statements which flow over several pages in length. Active by default for ALG users are the budget comparison statement for the general fund and a comparative operating statement for the enterprise fund. In this interim release, only the first enterprise fund on your fund list is utilized. Call support if you want to use a different enterprise fund. Also, you will need to edit both the exhibit itself and the table of contents to change the generic title "Enterprise Fund" to the specific fund name, such as "Water and Sewer Fund." The following schedules are available for activation with the settings menu: comparative balance sheets for both fund types and a comparative operating statement for the general fund. For Audit I.S.D. users, only the general fund budget comparison exhibit is active by default. "Comparative" statements are those which provide columns for both the current and prior years. When active, these statements require you either to have a prior year trial balance for that fund or to key in the prior year column directly in the statement (there is no entry screen in the FieldWork module for these statements like there is for prior year memorandum totals); 3) The combining general fund budget comparison statement is automatically deactivated and the individual fund general fund budget comparison activated with this update. If you have edited this statement manually and want to retain it, you will need to go to Settings and reactivate it. However, do not re-create it if you have multiple general funds, since the combining statement will now place each fund in a separate column. Associated with this, the setting, "Include individual funds on combining general fund budget comparison exhibit?" has been removed from the Settings menu. For users of Audit I.S.D., this statement changes from being a "Schedule of Expenditures by Function" to being a complete statement with revenues, changes in fund balance, etc.; 4) There is a new utility on the "Chart of Accounts" menu for copying another exhibit setup to replace the one currently loaded. A setup for combining statements, for instance, could be copied to an individual fund statement setup; 5) When viewing individual fund statements in the OfficeWork module there is a number at the top of the screen which indicates the number of pages which will be printed and controls the multi-page indicator "Page 1 of x," "Page 2 of x," etc. If you increase the number of pages by changing the page breaks, this number should be changed accordingly. It may also be used to force a two-page exhibit to print as one page by changing this number from 2 to 1; 6) The Alt/CTRL C "Codes" menu will now add new account codes on the first row of the trial balance or below the final row; 7) Adjustment journals may now be printed directly from the FieldWork module menu (select PRINT, JOURNAL, PLAIN) as well as from Report Master. Account descriptions are not included; 8) The FieldWork "Statement" report (GO_TO, REPORTS, STATEMENT) will now display and print the new individual fund statements for the general and enterprise fund types; 9) For ALG users, the maximum number of federal programs carried on the SEFA schedule has been increased from 34 to 200; 10) For Audit I.S.D. users, the ASCII file conversion process will now handle files with no "end of file" marker; 11) In Report Master, the new year-to-year variance reports for assets and liabilities now correctly display the report type; 12) Column widths in Report Master and the Access Menu have been widened to display all 4 digits of the year 2000. AUDITWARE ENGINE UPDATE (12/15/99) 1) There is now a setting for changing exhibit numbers manually (B-3 to B-4, etc.) which may be used for inserting user-prepared financial statements or schedules in the audit report; 2) An occasional problem regarding manually entered prior year memorandum totals for liabilities on Exhibit A-1 has been corrected; 3) A product version (Audit I.S.D. and ALG) dated 12/14/99 or later is required. AUDITWARE ENGINE UPDATE (12/14/99) 1) A new FB (fund balance) class has been established and the old EQ (equity) class has been redefined as "Other Equity." This overcomes the problem of fund balance not being reported on Exhibit A-4 for nonexpendable trust funds and other funds with fund balance. For users of Audit I.S.D.: This change will force a re-saving of all trial balances when you select "create" from the OfficeWork menu, during which all classes in trial balances and adjustment journals will be reset. Since this can be a lengthy process, you can do it at your own convenience by selecting "Refresh the current client's data files" from the FieldWork Utilities menu. The activity should be performed before generating reports in Report Master. Also, since it was necessary to change the "Equity Closing Codes" classes, this update will overwrite any changes you may have made to these codes previously and you will need to make your changes again. The Audit I.S.D. product dated 12/14/99 or later must also be downloaded and installed. For users of AuditWare for Local Governments (ALG): This change will not overwrite your existing chart of accounts setups or change any classes in trial balances or adjustment journals. The EQ class will continue to work as before. However, you may wish to change your financial statement setups and trial balance account codes to take advantage of the new FB class. Using it in a "formula," such as EA+FB, excludes contributed capital from the "Retained earnings or fund balance" lines of the proprietary operating statements (A-4 and combining). Chapter 8 of the on-line user manual, "Setting Up the Chart of Accounts," has been changed to reflect the above change and to give examples of the use of the new FB class when setting up the financial statements, (see "Using Formulas in Exhibit Setups"). Once you start using the FB class, you must add the appropriate classes to your "Equity Closing Codes" setup. You must also download and install the ALG product dated 12/14/99 or later; 2) Year to year variance reports in Report Master now allow variance reports of assets, liabilities and equity, in addition to revenues and expenditures; 3) For users of Audit I.S.D., data columns for the indirect cost schedule are no longer captured when saving trial balances which do not include functions 41 or 53, speeding up the saving of these trial balances; 4) For users of AuditWare for Local Governments, it is no longer necessary to have a stand-alone list of SAGs (specified account groups) when the SAGs are placed in the individual object code definition setup. AUDITWARE ENGINE UPDATE (12/8/99) Report Master trial balance reports have been revised to include the new EA (retained earnings) class for Audit I.S.D. users. AUDITWARE ENGINE UPDATE (12/7/99) 1) Combining statements are now active for discretely presented component units when multiple such funds exist; 2) Chapter 8 of help has been revised to provide examples of using the EA, ETI and ETO classes (retained earnings and residual equity transfers in and out) in the chart of accounts setups for users of AuditWare for Local Governments. AUDITWARE ENGINE UPDATE (12/3/99) 1) At the suggestion of several users, we have added a setting which "turns off" the prompt which appears when making new adjustment journal entries as to whether you want to copy the accounts from the trial balance. It is under the "FieldWork and Miscellaneous" category of settings; 2) For users of AuditWare for Local Governments, a problem has been corrected in Report Master where the "Adjustment Journal" report type in certain circumstances was failing to provide the account definitions; 3) Users of Audit I.S.D. must use Version 10.5A or later with this version of the AuditWare Engine. AUDITWARE ENGINE UPDATE (12/1/99) 1) Various changes have been made to accommodate the changes in Version 10.5A of Audit I.S.D., dated today, associated primarily with residual equity transfers. Users of Audit I.S.D. should also download and install the Audit I.S.D. product when this version of the Engine is installed; 2) The following changes to Report Master are primarily useful to users of AuditWare for Local Governments: a. The column used for function codes is now automatically widened when function codes are greater than 3 digits; b. An occasional problem of the first account description being omitted in each section of reports has been corrected; c. Up to 6 columns may now be included in individual object code definition setups. AUDITWARE ENGINE UPDATE (11/24/99) The only change in this update is in the FieldWork "Statement" report (GO_TO, REPORTS, STATEMENT). Combining governmental operating statements may now be viewed or printed, in addition to the other statement types. Users of AuditWare for Local Governments with an unusually tall setup for this statement may find it necessary to re-save the trial balance before all of the statement is displayed or printed. Since this change was made for the benefit of a single user, general notification to our client base by e-mail or fax will not be made. AUDITWARE ENGINE UPDATE (11/21/99) 1) On some computers, the page breaks in the notes which are displayed on the screen immediately after creating them are different than the page breaks displayed after they are printed once. This has been corrected; 2) When the adjustment journal is posted to the trial balance, the user is now always immediately asked whether to save the posted trial balance; 3) In combining budget comparison financial statements: a. The space available for descriptors has been widened to accommodate longer descriptions; b. An unnecessary space has been removed from the second line of the exhibit title. The following two changes in the Engine are primarily useful to users of AuditWare for Local Governments: 4) Regarding the chart of accounts setups for individual object code definitions: a. It may now contain an additional user specified column (manually inserted), if desired, if it is not one of the first two columns and a column heading (such as "REMARKS") is supplied; b. A descriptive footer may now be added when printing this setup, such as one describing the columns by which it is sorted; 5) The ALT/CTRL Q quick key for showing or hiding Quick Help is now active on the "Specified Account Groups" setup screen as well as the exhibit setup screen. AUDITWARE ENGINE UPDATE (11/12/99) In support of the recently established new classes for residual equity transfers, ending fund balances or retained earnings now includes net residual equity transfers on operating statements and residual equity transfers are now "closed" into equity on balance sheet statements, along with net income. Also, a new "short cut" of NIF (Net Inflows) may now be used in "formulas" in chart of accounts setups for the financial statements. It has the meaning of net income plus net residual equity transfers. We are not changing the default chart of accounts setups for the operating statements to reflect this change. If you have a client with residual equity transfers you will need to change the setups yourself. To get to this area of the program, go to settings, select CATEGORY, then "Set up the Chart of Accounts." The two changes necessary are as follows: 1) Change the "formula" for the beginning fund balance line from "EQ-NI-PPA" to "EQ-NIF-PPA" on both the governmental and proprietary operating statement setups; 2) Insert a row below beginning fund balance captioned "Residual Equity Transfers" (or whatever you want to call it) with ETI-ETO in the "Min" column. When finished with these changes, go to the FieldWork module, select UTILITIES, then "Refresh the current client's data files". AUDITWARE ENGINE UPDATE (11/10/99) 1) The exhibit creation process for Exhibit A-1 has been enhanced to assure that all inactive rows are removed; 2) "Equity Closing Codes" are no longer limited to object codes, a change useful to users of AuditWare for Local Governments. The last row of this setup now allows you to specify whether these account codes are function, object, organization or program codes; 3) When copying adjustment journal account codes from the trial balance, your cursor now returns to the position of the previous accounts copied; 4) When the optional schedules of loans and leases are used, they are now activated by the OfficeWork module even when no amounts were outstanding at the beginning of the period and none were retired during the period. AUDITWARE ENGINE UPDATE (11/8/99) When creating combining balance sheet statements and the setting for omitting inactive balance sheets is set for YES, the blank columns are now removed automatically. AUDITWARE ENGINE UPDATE (11/7/99) 1) For users of ALG, changed the Working Trial Balance report in Report Master to recognize the class when defining an account code when classes are included in the "Individual object code definitions" setup for a client; 2) Changed the Working Trial Balance report in Report Master to prevent an occasional cosmetic problem of the adjustments appearing twice in the debit and credit columns of an adjustment even though the totals are correct. AUDITWARE ENGINE UPDATE (11/3/99) 1) All chart of accounts setups may now be printed automatically and the setups for individual object code definitions, individual function code definitions and default account codes for new trial balances may now be sorted in various user-specified ways. These enhancements will primarily be useful to users of ALG; 2) When posting the adjustment journal, account codes may now be added to the trial balance in the unusual situation when there is only one row in the trial balance. AUDITWARE ENGINE UPDATE (10/31/99) Changes: 1) When making new entries in the adjustment journal, the account codes may now be copied automatically from the trial balance. 2) In the setup for individual object code definitions, object codes may now optionally be defined at the fund and function level by users of ALG. Also, SAGs (specified account groups) may now optionally be entered in the setups for individual object code and function code definitions. 3) Ranges for creating the combining Trust and Agency balance sheet have been expanded to handle an unusually tall setup in the Chart of Accounts for users of ALG. 4) A problem associated with re-saving all trial balances from the OfficeWork module which was caused by the 10/29/99 Update has been corrected. AUDITWARE ENGINE UPDATE (10/29/99) Changes: 1) The dollar sign position has been adjusted when the general purpose balance sheet (Exhibit A-1) is created as four facing pages. 2) There are two new settings as to whether to automatically place function code definitions and object code definitions in the scratchpad area of the trial balance when you select GO_TO, INPUT, Trial Balance. The default settings for both are YES, so you will need to turn one or both off if you are using a slower computer and don't want to take the time for it to generate those definitions. You may also press Escape to stop the defining in progress. When either of these settings are set for YES, the scratchpad is erased when the trial balance is saved. These new settings may also be controlled by selecting ALT/CTRL I, then "Trial_Balance," "Autoload." 3) Class codes are now utilized in Report Master in providing alpha definitions of account codes when using AuditWare for Local Governments and the setups for individual account definitions include class codes. AUDITWARE ENGINE UPDATED (10/25/99 Changes: 1) "Go to Report Master" has been added to the AuditWare Tools menu as a convenience. 2) Several other minor enhancements were made. AUDITWARE ENGINE UPDATED (10/22/99) Changes: 1) When the adjustment journal is posted to the trial balance: a) the "class" code is now automatically placed on all entries in the journal as well as the trial balance if any are blank (Audit I.S.D. users only); b) you are prompted if posting to an account which appears in the trial balance more than once; c) the "save trial balance?" menu which appears after posting has been changed to "save posted trial balance?" and no longer asks if you want to post again; 2) On the ALT/CTRL C "Codes" menu, the "Find_Duplicate" command for listing duplicate account codes in a trial balance has been enhanced; 3) A reference to drive C: has been removed from formulas associated with the variance column of budget comparison statements, allowing these statements to be created properly when running AuditWare on a drive other than C:; 4) The budget variance report in Report Master now "filters" correctly when using subtotals only and thresholds have been set for both amount and percent variance. AUDITWARE ENGINE UPDATED (10/16/99) A minor change was made applicable only to running client data with more than 27 special revenue funds. AUDITWARE ENGINE UPDATED (10/15/99) Changes: 1) There is a new setting under the "FieldWork and Miscellaneous" category of settings as to whether to de-activate the current client when exiting from AuditWare. Those who have configured AuditWare with the archive files on a network server drive should set this setting for either YES or ASK ME to prevent two users from accidentally running the same client at the same time; 2) When using the FieldWork Utility "Copy all data from another trial balance to the current one," the adjustment journal is copied as well; 3) On combining balance sheet financial statements, dollar signs are now being placed on the "Total Assets" line and on the first line of liabilities; 4) There is a new FREQUENT command on the Settings menu which allows you to select from the frequently used settings of all categories; 5) When using AuditWare Tools to "Create an install disk from a file downloaded from the internet," the program now pauses after copying the files to the diskette with "Press a key to continue" so you will see a "disk full" message if it occurs (this can happen if you don't start with a blank diskette); 6) The Opening Entries report in Report Master now reports a zero in the fiscal year field instead of a 10; and 7) The process of setting the print range for Report Master reports has been improved to assure that all columns of the report are always included in the range; 8) The "Quick" standard trial balance report in Report Master now includes all account descriptions. AUDITWARE ENGINE UPDATED (10/7/99) This change corrects an error for some users in which only the first 15 funds (projects) of the prior year were being included in the prior year memorandum totals of the combining special revenue fund balance sheets and operating statements. AUDITWARE ENGINE UPDATED (10/4/99) Changes: 1) When you go to any exhibit or document in the OfficeWork module, you may now print it while viewing it, without having to return to the OfficeWork main menu; 2) Report Master has been enhanced in dealing with trial balances which have no data; 3) When a user inadvertently creates a blank section of the notes to the financial statements (manually), the OfficeWork module now deletes that section before creating the notes; 4)The important change for ALG users made in the 10/3/99 update (see below) is included. AUDITWARE ENGINE UPDATED (10/3/99) This change, primarily for AuditWare for Local Governments users, prevents the accidental erasure of their Specified Account Groups (SAGs) when saving an exhibit setup while setting up the chart of accounts. Users of Audit I.S.D. would only need it if they have saved an exhibit setup with the Chart of Accounts Setup Menu, which should be rare. AUDITWARE ENGINE UPDATED (9/30/99) Change: Expanded the capacity of Exhibit A-4 for users of ALG with an unusually large number of rows in their chart of accounts setup for this exhibit. AUDITWARE ENGINE UPDATED (9/29/99) The changes include: 1) Added a setting which allows you to add the sentence "The accompanying notes are an integral part of this statement" to the combining financial statements, if desired; 2) The "Sort" command in the adjustment journal menu is now active. AUDITWARE ENGINE UPDATED (9/28/99) Changes include: 1) The Enterprise Food Service fund, if any, is now included in Report Master reports when "all funds and account groups" is selected; 2) In Report Master when subtotals don't include function codes, the report now is generated in function order; 3) When an adjustment journal is posted you are now prompted as to whether you want to save the trial balance; 4) The number of funds which can be combined into one fund on the combining exhibits has been expanded from 15 funds to unlimited; 5) When converting a school district ASCII file, prior year trial balances are now updated to add the "Class" account code, making it unnecessary to run the FieldWork utility, "Refresh the current client's data files" to get prior year data to show up in Report Master; 6) The on-line Help has been expanded and updated. AUDITWARE ENGINE UPDATED 9/16/99 ALG Changes: A fund number or fund type may now be included in a specified account group when setting up the chart of accounts in ALG (see next article). Audit I.S.D. Changes: When making entries in the adjustment journal, the class is now entered automatically (thanks to Tray Moses of Sauls & Pechacek for this suggestion). Changes for both products: Deleting an entire adjustment journal now unposts those entries from the trial balance; the default AuditWare program year is now set for 1999; in Report Master, custom lead schedules now include items created with an adjustment; the "Lock" and "Unlock" quick keys (ALT/CTRL L and U) available last year in trial balances have been reactivated by popular request (ALT/CTRL L "locks" away the left portion of the screen, keeping it visible when scrolling to the right). AUDITWARE ENGINE UPDATED (9/9/99) The update of the Engine dated 9/8/99 includes the following: prior period adjustments are no longer posted to budget data, only to actual; saving the trial balance (updating data columns) has been speeded up by about 25%; the combining budget comparison exhibit is now active by default for ALG; in Audit I.S.D. you are now prompted when saving a trial balance which includes function codes which are not in the TEA Resource Guide; the "class" has been added to the "plain" trial balance report; the FieldWork utility "Create or recreate combined funds" has been removed from the menu since it is no longer needed; Report Master now sorts user-specified object codes (ALG feature); the setting "Change the equity codes to which net income is closed" has been removed from the "FieldWork and Miscellaneous" category of settings and now appears only under "Set up the chart of accounts." AUDITWARE ENGINE UPDATED (8/31/99) This version includes the following changes: 1) Budgeted net revenue is now removed from fund balance when RSCCC ASCII files are converted (Audit I.S.D. only), 2) in trial balance reports, all balance sheet accounts are now included even when the "Include Items" setting is set for NO, 3) the Working Trial Balance report can now "Collapse projects into funds," and 4) the Year to Year Variance report and the budget variance report now include subtotals. Several of these changes were requested by attendees at recent seminars. Thanks also to Darrell Roberts (Beason & Jacks, Longview) for his suggestions. AUDIT I.S.D. AND AUDITWARE ENGINE UPDATED (8/30/99) This version of Audit I.S.D. and the AuditWare Engine uses the new "data column" approach to creating the indirect cost schedule. Both the engine and Audit I.S.D. product files must be downloaded. AUDITWARE ENGINE UPDATED (8/19/99) This update adds fund 753 (Internal Service Fund for Insurance) to the list of funds when Audit I.S.D. users are generating reports for "all fund types and account groups" in Report Master. It also activates the setting "Collapse projects into funds" in Report Master for such users. AUDITWARE ENGINE UPDATED (8/17/99) This update ignores spaces placed in the "min" or "max" columns by ALG users who use the space bar to erase a cell. It also now properly displays prior year amounts in Report Master when there was no unadjusted amount and only a credit as an adjustment. Finally, it increases the default memory available to Lotus 1-2-3 from 4 megabytes to 5 megabytes. AUDITWARE ENGINE UPDATED (8/13/99) This update corrects an occasional problem in creating the general purpose balance sheet (A-1) when there is no prior year data, prior year memorandum totals have not been entered manually and the exhibit will not fit on one page. AUDITWARE ENGINE UPDATED (8/11/99) An update of the AuditWare Engine dated 8/11/99 was posted on the web site today. It provides several enhancements to users of AuditWare for Local Governments (ALG). Among the changes: 1) There is now a new setting ("Client Settings" category) for saving the current client's data with a new archive file name. This allows setting up one client then saving that setup for a new client which has a similar chart of accounts. 2) A problem is fixed for certain earlier versions of ALG where it sometimes lost track of which setups were active. 3) The PR (program) account code type may now be used with ALG in the unlikely event it is needed. 4) The ALT/CTRL Q quick key has been improved for hiding the help screen when setting up a financial exhibit. AISD, ALG AND ENGINE UPDATED (7/27/99) Updates of Audit I.S.D., AuditWare for Local Governments and the AuditWare Engine were posted on the web site today (see Downloads under Software). This Audit I.S.D. version (10.1) is being mailed by diskette along with a printed user manual to all users who have paid their 1999 renewal fee. it is compatible to run on the same computers with the ALG product and also allows downloads of future updates from this web site. The ALG update (Version 2.1A) involves relatively minor changes (placing dates on each section of the FieldWork notes file and including expenditure object codes in GFOA default setup files). The AuditWare Engine update perfects the use of specified account groups in the chart of accounts setups for ALG users and provides a number of other changes for both products. AUDITWARE FOR LOCAL GOVERNMENTS AND ENGINE UPDATED (7/15/99) Version 2.1 of AuditWare for Local Governments was posted on the web site today, along with an update of the AuditWare Engine. The major new features include the ability to use "Specified Account Groups," not just minimum and maximum account codes, when setting up the chart of accounts and a new automated Required Supplementary Information (RSI) section of the audit report, including Year 2000 disclosures as RSI. Both the AuditWare Engine and ALG product file must be downloaded.. AUDITWARE ENGINE UPDATED (5/25/99) An update of the AuditWare Engine was posted on the web site today. The primary change is that it will accommodate an operating statement setup which is unusually tall (has more lines) when creating the general purpose operating statement. It also changes some of the column widths for that statement when a discretely presented component unit is being presented to make a more attractive presentation.