AUDIT-City Updates

These updates do not upgrade previous versions to a newer release. The release number of your software can be found in the About  tab under Help tab in the software toolbar.


Updates for RELEASE 18

Release 18

Update Notes

11/22/2021 : This update corrects the column heading dates on the second page of the RSI schedule for Contributions to the plan.
11/18/2021 : This update corrects an error running the CHECK routine when editing the fund list.
11/14/2021 : This update corrects an error in printing the Adjusting Entries in the Trial Balance. The revised 2021 worksheets for TMRS GASB 68 and 75 and for TCDRS GASB 68 and 75 will be saved in your installation folder.

Updates for RELEASE 17

Release 17

Update Notes

09/27/2021 : This update corrects the print routine for one version of the Cash Flow Statement for Proprietary Funds.
09/07/2021 : This update revises the print all and make total PDF file routines in the Report Generator to include the new print routines for combining statements H9 and H10 for custodial funds.
09/01/2021 : This update adds additional columns to print up to 17 custodial funds in the combining statements.
08/22/2021 : This update corrects an error printing Exhibit E2. There is also a correction to printing the combining statement Exhibit H-10 for multiple custodial funds.
06/29/2021 : This update makes corrections to the print routine for the D1 exhibit when it has more than 4 columns of data including the total and has enough rows of data to split the report on both pages showing assets and Deferred Outflows on the one page and Liabilities, Deferred Inflows and Net Position on another page.
06/28/2021 : This update makes corrections to the print routines for the RSI Exhibits for TMRS if the pension plan year started in 2015 (FY 2016) rather than 2014 (FY 2015) and the OPEB plan year started in 2018 (FY 2019) rather than plan year 2017 (FY 2018).
05/12/2021 : This update makes a correction to the print routine for Exhibit C-1 when there is a second page. The first page and the second page now line up correctly.
05/06/2021 : This update makes a correction to the routine increasing the size of the Work Paper Reference field in the Trial Balance File. You will now be prompted to close AUDIT-CITY when this change is made so the work session will end and the change will be saved. The change will be made the next time you open the trial balance program for each city.
04/19/2021 : This update corrects an error when creaating the PDF file in the Report Generator. There was an error in looking for Year3 for the TCDRS Exhibit.
03/22/2021 : This update corrects an error printing the TCDRS Statement of Changes in the Total OPEB Liability. Year 2018 was not being included in the report.
03/21/2021 : This update corrects another error printing Exhibit H12 in the Report Generator and corrects the print all and creation of total PDF file for the changes in Exhibits H11 and H12.
03/20/2021 : This update corrects an error printing Exhibit H-12 - The Combining Statement of Additions and Deductions for Trust Funds.
03/03/2021 : This update revises the format of Exhibit D-1 when there are three or four columns of data to allow more rows on the page.
03/01/2021 : This update corrects a formula for the Cash Flow Statements when there is a temporary investment not included in the cash and cash equivalents. This only applies to the last column on the print routine where there are four columns including the total column.
02/26/2021 : This update revises the print format for Exhibit D-1 when there is only one column to allow more lines to print on the page. There is also a correction to the worksheet for the TCDRS Worksheet for GASB 68.
01/23/2021 : This update corrects the print routine for the individual fund statement comparing balance sheet items for governmental funds for current and prior year. A revision was also made in the print routine for Exhibit D-1 allowing for more lines for the one page report.
12/21/2020 : This update corrects the creation of the fund to government wide worksheet in certain situations to include the GASB 75 column. There is a small correction in the GASB AJD menu choices to be certain the memo file for the GASB Adjustments is created and recreated when the GASB Adjustments file is created or recreated.
11/19/2020 : This update rounds the data exported from the Government Wide column in the Fund to Government Wide Worksheet that are imported into the two GW data files and into the General Revenue Worksheet. The user should not enter adjusting entries in the fund to government wide worksheet with pennies. All entries should be rounded to the nearest dollar. This change has been made in case pennies were entered. Please note that rounding errors may have to be manually corrected in the data files for the Government Wide Statement of Net Position and/or for the GW Statement of Activities. The example auditor opinions in the Documents Section of the Report Generator have also been undated.
11/09/2020 : This update for Release 17 corrects an error occurring when importing data from an ASCII file into the prior year data file. There is also a change in the formatting for the TMRS Schedule of Net Pension Liability. We now print three columns on the first page to match the Schedule of Contributions.

Updates for RELEASE 16

Release 16

Update Notes

09/09/2020 : This update allows the creation of the data file for proprietary funds to use the four character object code as described in the crosswalk file rather than combining object and function codes for the report. It is required that there be NO function code in the function code list beginning with a zero. No function codes should be used for expenses in proprietary funds. Also, do not use the general 6500 if there are detailed object codes 6510, 6520, etc.
09/03/2020 : This update changes the routine for importing data into the proprietary funds if you wish to print the data by the full object code. There must be no function numbers on the function list beginning with a 0 as this indicates the data should be displayed by object and segregated activity in the Statement of Revenues, Expense and Changes in Net Position for the proprietary funds.
09/01/2020 : This update corrects an error which occurred when importing an ASCII file in the crosswalk file if the file is a comma delimited file. Please be certain there are no commas in the account name if using this routine.
07/08/2020 : This update allows for one less column to be displayed in the RSI schedules for TMRS for entities that implemented GASB 68 for measurement year 2015 and GASB 75 for measurement year 2018.
04/06/2020 : This update corrects the print all routine in the Report Generator if you are printing the RSI schedules for TCDRS. There was an error when printing Exhibit G-6 in the query command.
03/26/2020 : This update corrects the printing of one version of the Exhibit B-1 report so that the dollar signs are printed correctly.
03/16/2020 : This update adds a routine to save the edits made to control codes in the Report Generator to that description in the code tables for the crosswalk. These are the tables imported from the prior year for the new release of AUDIT-CITY. Hopefully the edits you have made this year will not have to be done next year if they are saved in the crosswalk code descriptions.
02/24/2020 : This update corrects an error when editing the first line of the title for Exhibit E-1. This change correctly saves your edit in the Exhibits file.
02/19/2020 : This update corrects the import routine from the proprietary fund statement printing into the EF and Internal Service Fund Consolidation Worksheet to move the items coded to 2240 and 2230 to be added to Non current Liabilities Due Within One Year for Exhibit A-1. Remember to import the data from trial balance into the EF Grant Worksheet to allocate Contributed Capital to either a capital or operating grant or include it in interfund transfers.
02/05/2020 : This update replaces the example worksheets in the AUDIT-CITY manual. All previous updates are included with this update.
01/30/2020 : This update corrects an error in selecting the major funds from the fund list so that they are now selected in the same in order as they are numbered on the fund list and presented in that order when printing the D Exhibits.
01/29/2020 : This update makes some formatting changes for Exhibits D1 and D3 when there is only one column of data. There is also a change in the formatting for the combining statements affecting the lines on the second page of the exhibit.
01/11/2020 : This update adds the option when printing the budget comparison for a proprietary fund as an individual statement to print the object codes by detail as defined in the data file for that fund type.
12/23/2019 : This update corrects an error when printing Exhibit D-2 if you have internal service funds. The worksheet automatically created when printing this exhibit produced an error stating that "duplicate fields 'ALL' were found in the DBISAM table". This prevented the print routine from completing.
11/20/2019 : This update contains another correction for the Planning Materiality Report. The amounts for the NM Governmental funds and the NM Enterprise funds were not correctly imported from the trial balance file. We have also added a print routine to print in landscape mode if the report has more than 5 columns or account information.
11/08/2019 : This update contains a critical update for AUDIT-CITY Release 16. The Check routine on the Fund List screen was not working correctly. That has now been corrected.

Updates for RELEASE 15

Release 15

Update Notes

08/20/2019 : This update corrects some formatting issues for Exhibits C-1, the Schedule of Changes in Net Pension Liability, and the Individual Fund Budget Comparison for Governmental Funds.
07/23/2019 : This update corrects an error in calculating the assigned fund balance for the permanent fund balance sheet data files when importing data from the trial balance. Only permanent funds were affected with this error.
06/24/2019 : This update makes some formatting changes in some of the exhibits. We have also included a revised worksheet for the TMRS GASB 68 worksheet.
05/02/2019 : This update adds a routine to allow you to change a client account code in the crosswalk file, the trial balance and in the prior year trial balance you have imported from the prior year. This is to be used when the client changes their account number for the same fund and account. For example, if they used a 12- to indicate a particular fund but this year they wish to use a 10- for the same fund as in the prior year. The routine is in the EDIT menu in the crosswalk file. The routine is called "Edit Specified Characters in the Client Account Code".
04/09/2019 : This update adds a table to reconcile the calculated deferred inflows and outflows related to the TMRS pension in the TMRS worksheets - both the Abilene Example worksheet and the TMRS Worksheet for GASB 68 for FY2018. These worksheets are installed in your application folder. The default location is C:AUDCITY18.
03/27/2019 : This update makes some formatting changes to Exhibits A-1, C-1 and D-1.
03/23/2019 : This update makes some formatting changes to the D Exhibits. There is a change in the left alignment of the descriptions for Exhibit D-1 and a change splitting the description for Business Activities - Enterprise Funds across the top of the split page format.
03/19/2019 : This update changes the description on Exhibit E-2 - The Statement of Changes in Fiduciary Net Position so that the Net Change in Net Position NOW reads the Net Change in Fiduciary Net Position.
03/15/2019 : This update makes some additional corrections to the print all routine and the PDF file creation routine in the GASB 34 Exhibits menu in the Report Generator.
03/14/2019 : This update corrects the routines for making a PDF file of the entire report and the one for printing the entire report. This error occurred on one form of the report for Exhibit A1 for the PDF file creation and for the report for the RSI Schedule of Contributions for the Pension Contributions in the print all routine.
03/08/2019 : This update corrects some formatting issues on Exhibit B-1 - The Government Wide Statement of Activities.
03/07/2019 : This update corrects the dashes in the Beginning Net Position and Ending Net Position items on Exhibits D-2 and E-2. There are also some changes in the use of capital letters in some of the items on the TMRS and TCDRS base data files for the Schedule of Changes in Net Pension Liability schedules and one in the base file for the Schedule of Changes in the Total OPEB Liability. If you have already created these files, you may edit these row items as you see fit.
03/05/2019 : This update makes several adjustments to the print routines for Exhibit C-3, G-1, D-1 and D-2.
02/27/2019 : This update corrects the print routine for one form of Exhibit B-1. If there are no capital grants but there are both enterprise funds and a component unit, the titles for the component unit section were not printing correctly.
02/25/2019 : This update adjusts the titles for items on the RSI Schedules for both TMRS and TCDRS for the Changes in Net Pension Liability when there is at least one column of data where there is a Net Pension Asset. The changes are C - Net Pension Liability (Asset) and F - Net Pension Liability (Asset) as a Percentage of Covered Payroll. We have also added a routine to calculate the subtotals, totals and percentages in these two data files. We corrected the page number on Exhibit G9 for the form with only 4 years of data.
02/06/2019 : This update adds an option to choose to print the Fund To Government Wide Worksheet showing only the rows where amounts have been entered. All rows with nothing in them are left off of the report.
02/05/2019 : This update corrects the print routine for the budget comparison report for a proprietary fund as printed through the Individual Fund Statements option in the Report Generator.
01/30/2019 : This update corrects the print routine when printing the trial balance content reports in the trial balance. The correct fund name was not being retrieved.
01/23/2019 : This update corrects the print routine for Exhibit C-1 for the form for one fund only when there are no liabilities but there is a deferred resource inflow. The inflow was not adding to the equities for the total at the bottom of the statement.
01/18/2019 : This update corrects the formula for adjusting entry #4 and #5 in the Excel worksheet for the GASB 75 adjustments for TMRS.
01/09/2019 : This update corrects an error from the last update which occurred when printing the TCDRS Exhibit For Pension Contributions when there is more than four years of data. There is also a new feature which allows you to print Exhibits D2, H4 and H7 listing the expenses by the details as listed in your underlying data files. The Description is printed for each control code where there are amounts in these Exhibits. The other options - printing with items rolled up and by object and function remain. Remember when changing these options in the Report Data Screen, you must close that screen and click on the GASB 34 Exhibits menu option and select the report again so that the report data file can be reformed to be consistent with the option you have chosen.
01/04/2019 : This update corrects an error in the Create Entire PDF file routine and also an error in the Print All routine. The format for the TCDRS Schedule of Contributions for the Pension Plan has been revised to print only four years of data on one page only. There is also a correction in the Current Year/Prior Year queries so that items with negative variances and negative amounts in balance and prior year will be picked up correctly. Remember all previous changes are included in this update.
12/26/2018 : This update corrects the print routines for the RSI schedules for the Changes in Net Pension Liability for both TMRS and TCDRS schedules. There is also a correction in the Exhibit Information file changing the name for TCDRS to Texas County & District Retirement System.
12/17/2018 : This update corrects the print routines for Exhibit D-1. The headings for Restricted Assets - Current and for Payable from Restricted Assets were not printing correctly.
10/24/2018 : This update corrects the routine which Checks the Fund List against the funds in the trial balance file. Funds found in the trial balance file but NOT listed in in the fund list are added and fund on the fund list which are NOT found in the trial balance are removed from the fund list.
10/23/2018 : This update adds the print routine for the TMRS and TCDRS Changes in Total OPEB Liability which are required RSI schedules if the entity participates in one of these programs. Excel worksheets for the Fund to Government Wide entries for these two programs are also provided in the installation folder. There are also some minor corrections to the software.