AuditWare Engine 2000 Updates
AUDITWARE ENGINE UPDATE 12/30/00
1) When printing lead sheets in Report Master, you are now prompted as to whether you want to include all funds in the same report or print a separate report for each individual fund within the fund type you have selected.
2) "Notes to Prior Users" has been removed from chapter 1 of the user manual (and online help) and placed in a separate chapter. The 1999 changes have been removed but the 2000 changes have not yet been added.
AUDITWARE ENGINE UPDATE 12/27/00
1) In the rare case that a fund name begins with a year, the year is now retained in the fund name for all products except Audit I.S.D. for Texas School Districts (where the year is used to designate the project year). This affects Report Master, individual fund financial statements and combining financial statements.
2) GO_TO has been added to the menu which appears in the Individual Function Code Definitions setup or the Individual Object Code Definitions setup. This allows you to "go to" the first occurrence of a particular fund number, function/department code or object code which you specify, instead of having to "page down" endlessly to look for an account. It is particularly helpful in the object code definitions when fully detailed accounts have been entered or imported and hundreds if not thousands of accounts are involved.
AUDITWARE ENGINE UPDATE 12/21/00
1) A problem has been corrected introduced in the 12/19/00 version associated with loading the FieldWork module while running Audit I.S.D. for Texas School Districts. The TSD product must be downloaded and installed as well.
2) For the benefit of ALG users, you may now limit a "MIN/MAX" to a specific fund number. See Chapter 8 of on-line help "Setting up the Chart of Accounts" for details.
3) For the benefit of ALG users, the row number of financial statement setups are displayed and printed automatically. This assists in verifying the accuracy of the "Keep this row always" column when it is used to relate the active status of one row with that of another (see 10/30/00 Update, item 2 below).
4) The Exhibit/Table column of the table of contents has been adjusted to accommodate exhibit numbers greater than 99 (Exhibit B-100, etc.).
AUDITWARE ENGINE UPDATE 12/20/00
This corrects a problem introduced in the 12/19/00 version associated with creating the table of contents.
AUDITWARE ENGINE UPDATE 12/19/00
1) The fund type is now displayed on the fund list when you select GO_TO, INPUT, TRIAL_BALANCE from the FieldWork menu.
2) The "actual" column is now shaded on combining budget comparison statements for up to 81 funds, rather than for just the first 27 funds of a fund type.
3) Individual fund statements are now included on the table of contents even when no combining statements are active for their fund type.
AUDITWARE ENGINE UPDATE 12/15/00
1) When loading the Schedule of Instructional Time (California school districts) from the FieldWork module, the format is now set to round pennies and to automatically calculate formulas.
2) The engine date has been added to the opening screen of the FieldWork and OfficeWork modules.
3) When saving a trial balance and data columns are being updated: A. The name of the setup is displayed instead of its file name (i.e. General Purpose Operating Statement instead of S-GPOS); and B. Individual fund setups are only updated for those funds for which an individual fund financial statement has been activated by the user. While this saves significant time in saving trial balances or running the "Refresh the current client's data files" command, it means that you will need to re-save the trial balance if you activate an individual fund statement for that fund.
4) You are now provided an appropriate message instead of an error message when the setting "Include inactive balance sheets on combining statements?" is set for NO and you have multiple funds for a fund type but all of them are inactive.
The following changes are important primarily to users of AuditWare for Local Governments:
5) A "SAGS2" column is now provided in the setups for individual function code and object code definitions so that you may re-use the same account codes in SAGs on two different levels. In the function code setup, for instance, you could place SAGs for broad functions (General Government, Public Safety, etc.) in one column and SAGs for departments (Police Department, Fire Department, etc.) in the other column. This allows you to see their relationship easily and prevents having to use the stand-alone list of SAGs for this situation.
6) When in using the Ctrl C or Ctrl I quick keys from a trial balance to change account definitions or to revise SAGs, all changes are immediately loaded into the FieldWork module. While this provides an easy way to change SAGs "on the fly" and debug them, remember that if you make changes affecting funds other than the one which is currently loaded you must select "Refresh the current client's data files" from the FieldWork Utilities menu to update those funds as well, before creating financial statements in the OfficeWork module.
7) The first set of MIN/MAXs from the Chart of Accounts financial exhibit setup now appear on FieldWork "Statement" reports (GO_TO, REPORTS, STATEMENT), including SAG names. This is to aid in finalizing your work while setting up the chart of accounts.
8) When you inadvertently place a SAG name in the MIN column of an exhibit setup instead of the MAX column, the message which appears while updating data columns now specifies the SAG name which is involved.
9) A new SUM "formula" is now available for use in the MIN column of financial exhibit setups for summing up a column of numbers when use of a MIN/MAX or SAG is difficult. Using SUM 7, for instance, will add up the seven rows immediately above, including blank rows, SUM 12 would add 12 rows, etc. It should be used sparingly, since if you subsequently insert more rows in the range being added up you have to remember to change the number on the SUM formula (i.e. SUM 8 instead of SUM 7, etc.).
10) In the rare instance that a client is started with the wrong AuditWare product, the product associated with that client may now be successfully changed to another product by calling the support line (it is not necessary to start over), even when changing from a product with a variable chart of accounts (ALG or CSN) to one with a fixed chart of accounts (CSD or TSD) . This relates primarily to California users, some of whom are using three AuditWare products (CSN, CSD and ALG).
11) Chapter 8 of the user manual (and on-line help), "Setting Up the Chart of Accounts," has been revised to include these changes and to give examples of their use.
AUDITWARE ENGINE UPDATE 12/12/00
1) When in the multiclient notes, selecting "Restore Default" from the Utilities menu now restores the AuditWare default notes.
2) Balance sheets at all levels (General Purpose, Combining and Individual Fund) now appear on the "Statement" report menu in the FieldWork module (GO_TO, REPORTS, STATEMENT).
3) A number of other engine changes which relate primarily to the ALG product are explained on the ALG Updates page. For ALG users, the product must be downloaded and installed as well as the engine.
AUDITWARE ENGINE UPDATE 12/6/00
In a technical change, the process of relating the active status of one line of a financial statement setup to that of another no longer causes the omission of the first line of the setup.
AUDITWARE ENGINE UPDATE 12/3/00
1) It is no longer necessary to use a 3-digit fund number when changing the "combine to" fund number in individual fund settings; 2) As a convenience, "Set up the chart of accounts" has been added to the AuditWare Tools and FieldWork Utilities menus; 3) The final message which appears when backing up a client to diskette has been clarified to say that the 10,000 byte minimum applies only if only one diskette was required for the backup; 4) For users of AuditWare for California School Districts (both products) the final paragraph of the auditor's opinion letter now refers to OMB Circular A-133 and the SEFA schedule even when not a single audit. While this wording is not technically required, the State auditor's desk review checklist requires it to be present in all cases.
AUDITWARE ENGINE UPDATE 12/2/00
1) There is now a new setting which allows you to include the word DRAFT and the date & time at the bottom right corner of all audit report pages when they are printed. It is in the "Printing, Page Numbers and Pennies" category of settings and also appears under FREQUENT (frequently used) settings.
The following only affect users of AuditWare for California School Districts: 2) Classes are no longer reset each time trial balances are loaded or saved. 3) The default number of pages for the Schedule of Financial Trends has been changed from 2 pages to 1 page.
AUDITWARE ENGINE UPDATE 11/30/00
Minor changes have been made as follows: 1) At a user's request, adjustment numbers in the adjustment journal can now be entered as alphanumeric (JE1, JE2, etc.) if desired. Also, journal entries having no dollar amount in either the debit or credit columns are now automatically removed; 2) Cells left blank in any account code column of the trial balance are now automatically filled with zeros when the trial balance is saved; 3) The method of setting offset numbers in OfficeWork settings has been changed to prevent a rare technical problem.
AUDITWARE ENGINE UPDATE 11/22/00
1) In a major enhancement for users of AuditWare for Local Governments (ALG), "To/From" accounts can now be used in financial statement setups. Previously, separate "Due To" and "Due From" accounts had either to exist in the client's chart of accounts or be added arbitrarily. "Due To/From Debt Service Fund" is an example. Say the client had several such accounts carried as assets in a fund with a mixture of positive and negative amounts. This new feature will separate these amounts in "Due From""s and "Due To"s and adjust the amount for Total Assets and Total Liabilities automatically. A new column has been added to the setup screen titled, "Treat as To/From Account?".See chapter 8 of the user manual, "Setting Up the Chart of Accounts," or on-line help for more information about use of this feature.
2) When in a trial balance (go_to, input, trial balance), Quick Key Help no longer shows by default at the top of the screen, allowing for more of the trial balance to be seen. Execute the Q quick key (Ctrl Q or Alt Q) to display the Quick Key Help.
3) When ALG users select financial statement categories involving SAGS to produce lead schedules in Report Master, all categories except "total" rows now are available for selection. Previously, the first and last category were sometimes not appearing on the selection list.
4) For Users of AuditWare for California School Districts, Ctrl J now justifies paragraphs to the proper column in the "Organization" exhibit.
AUDITWARE ENGINE UPDATE 11/18/00
A problem has been corrected in numbering the exhibits when more than one individual fund financial statement is active, such as in a CAFR.
AUDITWARE ENGINE UPDATE 11/15/00
1) On Exhibits A-1, A-2 and A-3, the word "fund" which appears in the column headings describing fund types is now expressed either singular or plural depending on whether there are multiple funds of that type. The general fund continues to be expressed as singular.
2) The dates which appear in the column headings of the Schedule of Bonds now appear correctly when more than one set of facing pages is involved.
3) The exhibit label is now bolded on combining statements when more than 7 facing pages are involved.
AUDITWARE ENGINE UPDATE 11/13/00
In a major improvement to Report Master, lead schedules may now be generated for SAGs (Specified Account Groups) by users of AuditWare for Local Governments (ALG). Previously, selecting "Financial Statement" from the lead schedule menu only listed the financial statement lines which used a minimum and maximum in the setup as available.
Also, lead schedules now read all three sets of minimums and maximums when active in a financial statement setup. Previously only the first set was used. Since lead schedules are now created in exactly the same manner as the financial statements are created, the need to use "Custom" lead schedules should be much less frequent for users of ALG.
In a related change, the title bar of lead schedules now reports all categories and ranges of accounts included in the schedule, including SAG names.
AUDITWARE ENGINE UPDATE 11/09/00
1) The combining statements now carry "B" exhibit letters (B-1, B-2, etc.) even when the general fund budget comparison statement is inactive. This primarily affects users of AuditWare for California School Districts, since that statement is not typically active in their reports.
2) For users of AuditWare for Local Governments, improvements have been made to the process of using a number other than 1 or 0 in the "Keep this row always" column of financial statement setups to relate the active status of one row with another.
AUDITWARE ENGINE UPDATE 11/06/00
1) A new question has been added to the "Questionnaire to the Letters" which allows you to qualify the opinion on the financial statements for lack of controls over student body funds. If the questionnaire has already been established, select RESTORE_DEFAULT from the questionnaire menu to get the new question.
2) When setting up the chart of accounts in AuditWare for Local Governments (ALG) there is a new selection on the UTILITIES menu, "Capture individual object code definitions from an ASCII file." You must also download the ALG product.
3) Custom lead schedules in Report Master now show in the report's header the categories of account codes selected.
AUDITWARE ENGINE UPDATE 10/31/00
In a major enhancement for users of AuditWare for Local Governments, it is now possible to use multiple minimums and maximums for the same account code type when setting up the financial statements. While there are three sets of minimums and maximums which may be used on each line, previously each set used had to specify a different code type since they were treated together with "and" instead of "or." Now there is total freedom to mix and match account code types. The first set can refer to object codes, for instance, the second set could also refer to object codes and a third set could refer to function (department) codes. When creating the financial statements, AuditWare would treat the first two sets as "or" and the third set as "and."
Having the ability to use multiple minimums and maximums for the same account code type greatly enhances the ease of setting up the client when it has an inconsistent chart of accounts or uses account codes out of sequence and should make the necessity of using Specified Account Groups (SAGs) much less frequent. The line for "Cash," for instance, could refer to object codes 1110-1115, 1120-29 and 1131-1132, leaving out 1116-1119 and 1130.
AUDITWARE ENGINE UPDATE 10/30/00
1) For Audit I.S.D. users, the Indirect Cost Schedule now reports in column 6, "Miscellaneous", all expenditures coded in the trial balances to the 6500 and 6600 lines of this schedule (all expenditures which would otherwise appear in any of the first 5 columns is moved to the Miscellaneous column). See also today's update of the Audit I.S.D. product which shades out columns 4 and 6 on the 6211 row. These changes were precipitated by a telephone conversation with Betty Richardson of the T.E.A. staff today. She stated that it is not necessarily wrong to code 6500 and 6600 expenditures to the organization codes which make up the first 5 columns of this schedule, but, for purposes of this schedule only, they should be reported as Miscellaneous.
2) For ALG users, you may now use numbers other than 1 in the "Always keep this row" column of exhibit setups to relate the active status of one row with that of another. Placing a 5 in this column, for instance, means that this row will be active only if the 5th row of your setup is also active. Using a negative number (-5) reverses the relationship, meaning that it would be active if the 5th row is inactive and will be inactive if the 5th row is active. An example of its use would be if you had a "Fund balance as restated" row following a "Prior Period Adjustment" row but you want the "restated" row to be omitted if the prior period adjustment row is inactive. Previously, there were only two factors which controlled whether a row in the setup was active in the financial statements, whether it had a dollar balance and whether there was a 1 in the "Always Keep" column to force it active. Incidentally, a 1 still has the same meaning, so the first row of the setup cannot be referred to that way.
3) When you have more than 80 funds of any one fund type and therefore exceed AuditWare's capacity for a combining statement, a combining statement of the first 80 funds is now produced with a message on it that it does not include all funds.
4) There is now a setting as to whether the column widths in combining statements are automatically reset when they are printed. This is for special situations and should normally be set for YES. A NO setting is temporary (for the immediate session only). This means it will revert to YES if you don't go immediately from Settings to the OfficeWork module and print.
AUDITWARE ENGINE UPDATE 10/23/00
Several relatively minor changes were made to the table of contents: 1) "Expendable Trust Funds" is expressed in the singular when only one exists; 2) The word "Summary" has been added to "Schedule of Prior Audit Findings" to be consistent with the wording on the schedule itself; 3) in AuditWare for California School Districts when the questionnaire is set for using the word Auditors' instead of Auditor's in "Independent Auditor's Report," all instances of that word are now changed. Also, reference to the auditor report on state compliance now omits the word "Auditor's."
AUDITWARE ENGINE UPDATE 10/19/00
1) When changing print margins with the Settings menu, it is now possible to restore the default margins. 2) For users of AuditWare for California School Districts, the letter to management, when active, has been moved to be prior to the schedule of prior audit findings in the audit report. It also now correctly uses FieldWork input when it is created in the OfficeWork module.
AUDITWARE ENGINE UPDATE 10/18/00
This version was not posed to the web site. It was, however, mailed to all clients on October 19th. All changes are included in the 10/19/00 and later versions.
1) There is a new password for the CAFR add-in. It has been provided to those firms which have purchased the add-in.
2) Chapter 2 of the user manual in online help and future printed versions has been revised to include information about the command "Make an install disk from a file downloaded from the internet" on the AuditWare Tools menu.
3) In the rare case that all general purpose statements are de-activated by the user, Exhibit B-1 now becomes Exhibit A-1, B-2 becomes A-2, etc.
AUDITWARE ENGINE UPDATE 10/17/00
A problem in connection with changing print margins with the settings menu has been corrected.
AUDITWARE ENGINE UPDATE 10/14/00
1) For users of Audit I.S.D., on the indirect cost schedule the amount for "Total Expenditures for General and Special Revenue Funds (Exhibit A-2)" is now computed correctly.
2) A problem with using the Lotus for Windows "Style" menu to edit Exhibit A-5 has been corrected for new data periods.
AUDITWARE ENGINE UPDATE 10/10/00
1) The process of creating the opinion letter has been improved to assure that the wording for a single audit is always added when the setting for single audit is set for YES.
2) You are now prompted to answer whether the audit is a single audit at least once for each client, not just for clients which were in process when the setting was moved from the letter questionnaire to the "Client" category of settings. Since this feature is new, you may be asked again even though you have answered it previously.
3) Questions have been added to the "Questionnaire for the Letters" as to whether to include the line "Independent Auditor's Report" at the top of the G.A.S. and single audit letters. For reports in progress, you must select RESTORE_DEFAULT while in the questionnaire to have these questions available (which will lose any input you have made in the questionnaire) if you want to use this feature. The default answer for AuditWare for California School Districts is NO. For all other products it is YES (no change from the past).
AUDITWARE ENGINE UPDATE 10/8/00
1) For all users there is a new setting under the "Exhibit Creation" category of settings entitled "Place all combining statements in the same section of the audit report?". Selecting YES returns the audit report to basically the same segmentation used last year (all combining statements are B-1, B-2, B-3, etc., the "Combining Statements" divider sheet is activated and all divider sheets for fund types are de-activated. Selecting NO or activating the CAFR add-in reverses that process. For reports in progress you will be prompted with a YES/NO menu. If you select YES you will need to re-create the table of contents. The default setting for future periods or reports is YES, except when the CAFR add-in is active.
For users of Audit I.S.D. for Texas School Districts, we contacted T.E.A. about our new report segmentation by fund type and they have no objection, but several users asked us to allow this option. We were also influenced by the fact that segmenting the report the same as the T.E.A.'s sample report saves the T.E.A. (and possibly some of your reviewers) some processing time. For users of AuditWare for California School Districts, this allows you to segment your audit report with the same sections as those of the sample report in the Controller's K-12 audit guide.
2) When new trial balances are created (FieldWork utility number 1), the data columns used by the OfficeWork module are now created automatically when you return to the main FieldWork menu. This prevents the OfficeWork module prompt "All trial balances must be re-saved" from occurring in this circumstance.
3) Combining cash flow statements for nonexpendable trust funds are now a part of the audit report when multiple such funds exist.
AUDITWARE ENGINE UPDATE 10/6/00
1) When creating financial statements and the setting "Include prior year memorandum totals?" is set for NO, prior year amounts are now ignored for determining whether a line is active.
2) The word "changes" has been added to the title of Exhibit A-3.
3) On combining general fund budget comparison statements, when active, the "Total Expenditures" line now uses single underlines instead of double underlines.
4) For users of AuditWare for California School Districts, a problem related to the automatic adding of class codes to the trial balances and associated with the last update has been corrected.
AUDITWARE ENGINE UPDATE 10/4/00
For users of AuditWare for California School Districts (CSD and CSN), the classes for object codes 9790 and 9791 are now automatically set for EA (retained earnings) when they are used in a proprietary fund trial balance or adjustment journal. They will be set for FB (fund balance) initially in adjustment journals but will change to EA when the journal is posted and saved. This change allows retained earnings to be properly computed for the equity section of the general purpose and combining balance sheets. For clients in progress you will need to re-save your proprietary fund trial balances for the change to be effective.
AUDITWARE ENGINE UPDATE 10/2/00
1) "Account Groups" is now expressed as "Account Group" in the table of contents when only one account group is active.
2) For users of AuditWare for California School Districts (CSD and CSN): a) The multiclient notes feature is now active for the CSN product in addition to CSD; b) The CTRL J (justify) quick key will now justify up to 12 columns in the Schedule of Financial Trends and Analysis instead of 10; c) A zero object code is now honored when the program automatically sets classes in trial balances and the adjustment journal.
3) When entering new entries in the adjustment journal, you are now prompted as to whether you want to use the last working paper reference you entered for the current entry. Also, if neither a debit nor credit amount is entered, the entire entry is erased and you are returned to the menu.
4) For users of Audit I.S.D., the column heading for fund 413, Telecommunications Infrastructure Fund, in the combining financial statements is now abbreviated as "TIF Grant" to ensure that part of the heading does not print on the facing page.
AUDITWARE ENGINE UPDATE 9/26/00
Corrects a problem for users of Audit I.S.D. of the T.E.A. data control codes column being omitted from the general purpose exhibits when running under Windows.
AUDITWARE ENGINE UPDATE 9/20/00
1) When changing CFDA numbers in Audit I.S.D. you may now use alpha characters if desired (i.e., 84.340A).
2) An optional letter to management has been added to the audit report for users of AuditWare for California School Districts. See product changes page for more detail.
AUDITWARE ENGINE UPDATE 9/15/00
1) The command for entering prior year memorandum totals manually has been returned to the FieldWork module menu which appears when you select GO_TO, INPUT, OTHER_INPUT.
2) For users of Audit I.S.D. for Texas school districts, there is a new ALLOCATE command on the menu when in the FieldWork input file for the delinquent tax schedule. It allows you to enter the total collections for a year and have that amount allocated between maintenance and debt service collections (two new columns in that schedule this year), based on the respective tax rates that year. You must enter the tax rates in their respective columns first.
AUDITWARE ENGINE UPDATE 9/14/00
1) The default setting as to whether capital projects funds are considered budgeted funds is now NO for users of Audit I.S.D. for Texas school districts. For all other products the default setting remains YES. To change the default setting for any fund, go to Settings, select CATEGORY, then "Individual Fund Settings." Arrow to the desired fund and change the setting which says "Is this a budgeted fund?" to your desired answer. A NO setting excludes a fund or fund type from budget comparison statements such as Exhibit A-3.
2) The default setting for representing zero amounts in exhibits has been changed from right aligned double dashes to centered double dashes for the TSD and ALG products.
3) When switching the drive letter for archiving client data and the client does not exist on the new drive, the name of the client now appears beside the file name when you select "Load a different client," HARD_DISK from the new drive.
4) The total number of prior year funds which may be used for creating prior year memorandum totals for combining statements is now unlimited.
AUDITWARE ENGINE UPDATE 9/13/00
A problem has been corrected whereby the SEFA schedule sometimes appears twice in the audit report. While installing almost any subsequent update will correct the problem, this update prevents its occurrence in the first place.
AUDITWARE ENGINE UPDATE 9/11/00
1) A problem in Report Master trial balance reports has been corrected whereby certain accounts or adjustments were sometimes printing twice when using Audit I.S.D. for Texas School Districts.
2) When printing the Schedule of Findings and Questioned Costs, it now repeats the schedule title on subsequent pages when the print range exceeds one page.
AUDITWARE ENGINE UPDATE 9/7/00
1) Corrects an occasional problem on the general purpose balance sheet where the "Account Groups" column heading appears with a leading "rooftop" symbol (i.e., "^Account Groups") rather than as centered text.
AUDITWARE ENGINE UPDATE 9/6/00
1) The title of the audit report in the table of contents has been changed to vary by product. In Audit I.S.D. and AuditWare for Local Governments the title is "Annual Financial Report," and in AuditWare for California School Districts the title is "Audit Report." In all cases the title changes to "Comprehensive Annual Financial Report" when the CAFR add-in is activated.
2) The sequence of the report and the divider sheets used has been changed to be consistent with State sample audit reports. For Audit I.S.D. for Texas School Districts and AuditWare for Local Governments this is relatively minor, removing the "Federal Awards" section divider and merging that section with the one preceding it. For AuditWare for California School Districts this is a major change, establishing several new sections ("Supplementary Information," etc.) and resequencing the report as a whole. In all cases for reports in progress, check any manually set page numbers, since they may no longer be appropriate.
3) The List of Principal Officials document is now inactive by default and must be activated with the Settings Menu when you want to use it. Similarly, the Individual Fund Statement for the General Fund is now inactive by default in the California products.
4) The following new questions have been added to the questionnaire for letters: Include the governing body's address and zip code?; Include the audit firm's name at the bottom?; Use a short title for the opinion letter?; Qualify the opinion for omitting the general fixed assets account group?; and Express an opinion on the combining financial statements?. For reports which are in progress, answer YES when asked if you want to restore the default questionnaire. You will note that some of the answers in the new questionnaire are formulas to make the default answers vary by product. However, you may overwrite these formulas by entering your desired answers.
5) The question as to whether this is a single audit has been removed from the questionnaire. It is now in the "Client" category of the Settings Menu and will now carry forward for future periods of the client unless changed. The first time you "create" in the OfficeWork module you will be asked if the current client is a single audit.
6) 9/7/00 To correct a problem in Report Master for the California products, reports now use generic rather than more detailed object code categories when providing subtotals and grand totals on Report Master reports. Lead schedules continue to have a menu option for the more detailed object code categories.
AUDITWARE ENGINE UPDATE 8/19/00
1) The process of creating the Schedule of Expenditures of Federal Awards (SEFA) has been revised for Audit I.S.D. for Texas School Districts to insure that all federal programs are included; 2) The SEFA has been revised for all other products to omit the subtotaling of multiple programs of the same CFDA number, since this is rare. This has the effect of revising the underlining process for more appropriate presentation; and 3) In the notes to the financial statements, the "Preview" feature has been changed to prevent an occasional error in the process introduced in Version 8/15/00.
AUDITWARE ENGINE UPDATE 8/15/00
1) The manual deletion and insertion of columns in the FieldWork notes to the financial statements is now supported. This will aid in editing certain notes which contain column headings of fund types, not all of which are active for the client. Be aware that the column widths must still match those of the preview screen; 2) Zero amounts are now expressed as blanks, rather than as dashes, by default in the California products; and 3) Links to other files are now refreshed when loading the FieldWork footnotes to assure that all links are current.
AUDITWARE ENGINE UPDATE 8/13/00
A setting has been added to Report Master which allows you to exclude the subobject code from reports, if desired. This code is represented by decimals on object codes (1110.15).
AUDITWARE ENGINE UPDATE 8/12/00
1) The object code column of trial balances in the FieldWork module is now widened automatically when these codes have more than 4 digits; 2) The print ranges for documents in the OfficeWork module now are set for at least 30 lines, even when they contain no data.
AUDITWARE ENGINE UPDATE 8/10/00
The notes to the financial statements are now active for the California school products. Also, the "Early Retirement Incentive Program" table has been renamed "Notes to Supplementary Information" in the table of contents for those products. The product files should also be downloaded and installed.
AUDITWARE ENGINE UPDATE 8/04/00
1) The titles of individual fund budget comparison statements in the table of contents have been revised to remove the word "comparative"; 2) The process of automatically detecting that a network drive is no longer active and switching to drive C has been improved.
AUDITWARE ENGINE UPDATE 7/28/00
The process of creating combining budget comparison statements for more than 26 funds has been adjusted to make room for the memorandum total columns. Also, the maximum number of funds which these statements will handle is now 80 instead of 81 for the same reason.
AUDITWARE ENGINE UPDATE 7/27/00
1) Total columns for budget, actual and variance are now provided on combining budget comparison statements; 2) Several of the statistical tables used in a CAFR have been revised to improve their presentation. Some have been revised to print as two pages; 3) When saving a trial balance, the process of updating data columns has been changed to ignore entries which start with a space in the MIN column of financial statement setups. This is to accommodate ALG users who use the space bar to erase entries instead of using the delete key.
AUDITWARE ENGINE UPDATE 7/26/00
1) The 3 schedules required for the general fixed assets account group in a CAFR are now active when the CAFR add-in is in use. Also, the question regarding these schedules has been removed from the questionnaire for the letters; 2) The title of the auditor's report on the financial statements has been changed to omit reference to individual fund statements when none are active. This affects both the table of contents and the report itself; 3) A new section (A.4) has been added to Chapter 8 of the user manual, "Setting up the Chart of Accounts." It is entitled "In what sequence should I set up the chart of accounts? What should I do first?"
AUDITWARE ENGINE UPDATE 7/24/00
1) To accommodate those using extra large monitors, AuditWare now loads in a normal window rather than in a maximized one when running under Windows 95/98. To maximize the window, click on the double boxes at the upper right corner of the screen; 2) A problem in the creation of combining statements associated with the last update has been corrected.
AUDITWARE ENGINE UPDATE (7/20/00)
1) Memorandum totals are now always provided on the combined budget comparison statement (A-3). Previously they only printed if needed to fill out a page; 2) The combined operating statement (A-2) is now placed on one page for a more attractive presentation when there are three fund types active and prior year memorandum totals are not active; 3) Exhibit A-3 has been corrected for situations where the client has only one fund and one account group.
AUDITWARE ENGINE UPDATE (7/17/00)
1) On the general purpose balance sheet, "Account Groups" is now expressed in the singular when only one account group is active. This affects the exhibit’s title as well as the column heading; 2) There is now a new setting under "Exhibit Creation Settings" which allows you to change the line which refers to the footnotes ("The accompanying notes . . .") to read however you would like; 3) The column headings on the Summary Schedule of Prior Audit Findings have been changed to be Finding/Recommendation; Current Status; and Management's Explanation If Not Implement.
AUDITWARE ENGINE UPDATE (7/11/00)
1) A new selection, "Make a free trial install disk for ALG," has been added temporarily to the AuditWare Tools menu. This is in connection with the free trial offer of AuditWare for Local Governments (ALG) to all AuditWare clients which is currently underway (see the "AuditWare News" page for more information). 2) A new setting, "Check network drives when loading AuditWare or client data?" has been added to the "Fieldwork and Miscellaneous" category of settings. The default setting is YES. This setting allows you to "turn off" this feature when you are not on a network and thereby speed up the loading process somewhat. You may still use the AuditWare tool "List the active clients on all network drives" even when this setting is set for NO.
AUDITWARE ENGINE UPDATE (7/4/00)
This update revises the OfficeWork "CREATE" menu for users of AuditWare for California Schools (Non-SACS). It activates the special exhibits required by the Controller's K-12 Audit Guide on this menu.
AUDITWARE ENGINE UPDATE (7/2/00)
1) A new LIST_ALL selection is now on the OfficeWork menu under GO_TO and PRINT, allowing you to select from a list of all active documents. 2) A new setting has been added under the "Exhibit Creation" category of settings for activating a new add-in which will be announced soon (see the "AuditWare News" page). A password is required for activation. 3) The cover sheet and the list of officials no longer appear on the OfficeWork menus as separate selections. They are now considered part of the introductory section of the report and are accessed by selecting INTRO.
AUDITWARE ENGINE UPDATE (6/29/00)
1) The column widths between data columns of the combining financial statements are now set to make a more attractive display when there is no prior year memorandum total column. Existing statements must be re-created to get this new feature. This will be helpful for users of AuditWare for Local Governments and AuditWare for California School Districts where use of the prior year is less common. 2) the optional schedules of loans, leases and bonds now do not appear on the FieldWork menu unless those schedules have been activated. 3) An occasional problem loading the FieldWork menu from the OfficeWork menu has been corrected.
AUDITWARE ENGINE UPDATE (6/27/00)
This is primarily a maintenance update associated with the two new products for California school districts. Several minor behind-the-scenes enhancements affect all products. The most major is that when changing the drive for archiving client data (AuditWare Tools), you are now prompted as to whether you want to update the new drive with current client's data. Previously this happened automatically.
AUDITWARE ENGINE UPDATE (6/15/00) - 2000 Product Year
1) This update has the AuditWare product year set for 2000 and requires you to have already installed the 2000 program diskettes mailed to you by AuditWare before these downloaded files will be usable. 2000 program diskettes have been mailed to all users who have paid their 2000 annual update fee.
2) The program now checks all network drives (C through Z) to attempt to prevent the same client from being loaded on two different computers at the same time. The drives it checks are those which are "mapped" on the computer doing the checking. There is also a new AuditWare Tool under "Tools Seldom Used" for viewing a list of the clients which are currently active on all mapped network drives.
3) For the benefit of networked laptop users, there is a new AuditWare Tool under "Perform Activities with Archive files" which allows you to change the drive used for archiving client data. If your primary archive files are on a network drive, for instance, you may change to drive C: when you take your laptop to the field and change back to the network drive when you return. If you have a current client, the archive files on both drives are updated when you switch. Also, if you disconnect from the network and forget to change the archive drive to drive C: you are no longer prevented from running AuditWare. Instead, you will be asked whether you want to switch to the C: drive. In this case only the archive file on drive C: is updated.
Associated with this change, the installation procedure now creates an AWBARN folder on drive C: in addition to any other drive you may specify for storing archive files. If you decide to create an AWBARN folder manually on a drive, be sure to copy the file AWBARN.PRN into the folder. You will find it in any AWBARN folder which has been created automatically by AuditWare.
4) The ASCII file conversion process has been corrected to add the "Budgeted" column to the fund list, which is required by the Fieldwork module. Without this change, a "file not found" error will occur.
5) Primarily for the benefit of ALG users, the capacity of chart of accounts setups for individual fund financial statements has been increased from 400 to 600 lines.
AUDITWARE ENGINE UPDATE (5/06/00)
1) Changed the combining trust and agency exhibit to use the general purpose chart of accounts setup when the combining chart of accounts setup is inactive. 2) All trust and agency exhibits now use the same exhibit alpha letter (E-1, E-2, E-3, etc.).
AUDITWARE ENGINE UPDATE (4/20/00)
1) Corrects the print ranges for individual fund statements associated with the last update, when the setting "Include prior year on individual fund budget comparison statements?" was added. 2) The FieldWork utility "Refresh the current client's data files" has been revised to be more memory efficient and run faster.
AUDITWARE ENGINE UPDATE (4/13/00)
1) A new setting now gives you the option of including a prior year "actual" column on individual fund budget comparison exhibits. It may be found under the "Exhibit Creation Settings" category of settings or by selecting FREQUENT (frequently used settings). When this setting is set for YES, you may find the comparative operating statement unnecessary and wish to deactivate it. 2) The setting "Create combining exhibits when only one fund is involved?" has been removed from the Settings menu. It is no longer needed now that individual fund statements are available for all fund types. 3) A new "LEAD-REF" column has been added to the trial balance for entering lead schedule references, if desired. These references, which may be expressed as either numbers or words, may be used when creating lead schedules in Report Master to capture those categories of data. 4) Combining and individual fund budget comparison exhibits are now referred to as "schedules," rather than "statements," in the exhibit's title when the presentation is on a budgetary basis of accounting. See 1994 GAAFR (blue book), page 261, 3rd paragraph.
AUDITWARE ENGINE UPDATE (4/4/00)
1) New Individual Fund Statements
In a major change and rewrite of the AuditWare engine, individual fund statements are now available in all products for every fund of all fund types. This includes comparative balance sheets, comparative operating statements, budget comparison statements, and when appropriate, comparative cash flow statements. However, only the general fund statements are active by default. To activate others, go to Settings, select FREQUENT, then "Activate or De-Activate an Exhibit or Document."
Be aware that if you change the fund type of a fund for which there are active individual fund statements, those statements will become inactive and must be re-activated and re-created. Also, if you created enterprise fund individual fund statements using a previous AuditWare version which allowed only one enterprise fund, these statements must also be re-activated and re-created.
Even though the data for individual fund cash flow statements is entered manually, they are not on the FieldWork menu (GO_TO, INPUT, OTHER_INPUT) as are general purpose and combining cash flow statements. They must be created using the OfficeWork module, then accessed by using the GO_TO command of the OfficeWork module to enter the data. Also, cash flow statements of all types are now created by the OfficeWork module if they don't exist, even if there is no FieldWork input. Cash flow statements of any type need not be "frozen" after creation.
When viewing individual fund statements in the OfficeWork module you will see a number at the top of the screen which indicates the number of pages which will be printed. This number controls the multi-page indicator "Page 1 of x," "Page 2 of x," etc., during printing. 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.
2) Segmentation of the Audit Report Changed
Instead of all combining statements being "B" exhibits, exhibit labels now differ by fund type (Exhibit B-1, C-1, etc.) as well as by sections of the audit report. If combining or individual fund statements for the general fund are active, for instance, they would be labeled B-1, B-2, B-3, etc. Active combining special revenue fund statements would be C-1, C-2, etc., debt service statements would be D-1, D-2, and so forth. Also, all exhibit labels now carry a number. Several of the OfficeWork menus have been revised to reflect this change.
The "Combining Statements" divider sheet is now inactive by default. In its place are active divider sheets for each active fund type (general fund, special revenue funds, etc.). The "Introductory Section" divider sheet is now active by default. This section of the report includes the table of contents, a new "List of Principal Officials" document and, for Audit I.S.D. users, the Certificate of the Board.
The table of contents has also been changed to reflect this new segmentation. It is now patterned after the sample report in the 1994 GAAFR (blue book).
3) Other Important Changes
This is a major change and it is important that this update be installed on all computers upon which AuditWare is currently installed. This prevents the likely corruption of client data which is run on an updated computer and subsequently run on a computer containing an older AuditWare version.
Installing this update of the AuditWare Engine returns all user-set page numbers, print margins and the active status of OfficeWork exhibits and documents to their default values for existing clients. With this update you must also download and install the AuditWare product(s) you are using.
For Users of Audit I.S.D. Texas School Districts, the supplemental exhibits listing loans, leases and bonds (previously "C" exhibits) are now inactive by default. These exhibits have not been a part of the Texas Education Agency's sample audit report for several years and they duplicate information already carried in the notes to the financial statements. If you want to use one of them, you must go to Settings and activate it.
The audit report title has been changed from "Annual Financial Report" to "Comprehensive Annual Financial Report" on the cover sheet and the table of contents.
Page numbers are now omitted from all divider sheets by default.
AUDITWARE ENGINE UPDATE (2/21/00)
At user request, a combining agency fund balance sheet may now be included in the audit report. Since it is inactive by default, you must go to Settings and activate it for it to be available.
AUDITWARE ENGINE UPDATE (2/14/00)
1) The major change is a new "budgeted fund" setting which allows you to specify at the individual fund level which funds are to be considered budgeted or not. Whether a budget has actually been entered in the trial balance doesn't matter. Only those funds marked as budgeted now appear on combined and combining budget comparison financial statements. When expendable trust funds are marked as budgeted they are now included on Exhibit A-3. Go to Settings and select CATEGORY, then "Individual Fund Settings" to access this setting. Since the process of creating the title of Exhibit A-3 has not yet been changed, it may require manual editing in some cases when this setting is used. That automation will be provided in a future update; 2) Amendment No. 2 to the 1994 Yellow Book has been implemented. This adds a sentence to the auditor's report on the financial statements. See the News for Auditors page for more information; 3) When running AuditWare for Local Governments, it is no longer necessary to include all fund numbers in the "Individual Object Code Definitions" setup when any one fund number is included. You may enter one or more fund numbers, then a definition which has no fund number, meaning "use this definition for all fund numbers not listed;" 4) This update requires that a product dated 2/14/00 or later be also downloaded and installed.
AUDITWARE ENGINE UPDATE (1/13/00)
Up to 81 funds may now be included on the combining special revenue budget comparison financial statement. The product(s) you are using must also be dated 1/13/00 or later.
AUDITWARE ENGINE UPDATE (1/12/00)
1) Discretely presented component units have been added to the combined fund list in Report Master for use with lead schedules, and the default width of "money" columns has been changed from 11 to 10; 2) Memorandum totals no longer are printed for the Exhibit A-3 combined budget comparison when only the general fund appears on the statement; 3) the Alt/Ctrl Q quick key for hiding or displaying quick help in a trial balance is now active when running AuditWare in Windows.
AUDITWARE ENGINE UPDATE (1/6/00)
1) The print ranges of exhibits A-1, A-2 and A-3 are automatically increased if these exhibits exceed one page in length vertically. This change is useful only to users of AuditWare for Local Governments; 2) Column widths have been widened in several areas of the program to accommodate the year 2000 expressed as four digits. This prevents these dates from being displayed as asterisks; 3) A minor correction was also made in the memorandum totals column of the combining trust and agency exhibit; 4) This update includes the important changes included in the 12/31/99 version and requires a product dated 12/31/99 or later.