Side Navigation

Audit City

 USE AUDIT-CITY Release 13 to analyze, test and adjust your financial data and to prepare the
ANNUAL REPORT - GAAP or OCBOA - for Cities, Counties or other Governmental Entity!

BEGIN WITH THE TRIAL BALANCE AND END WITH THE FINANCIAL REPORT.

FULLY UPDATED FOR GASB 68!

In addition to the usual updates for AUDIT-CITY reflecting the change in the fiscal year, AUDIT-CITY now has a new crosswalk system.  We have changed the relationship between the EdMIS codes in the crosswalk and the account codes from the entity's accounting system.  It is still required that there not be duplicate account numbers but we now allow you to assign the same object code to many different account codes.  You only have to assign a fund code,a function code for expenditures, and an object code.  Making this change eliminates the time consuming checking to be sure there are not duplicate EdMIS codes and the possibility that duplicate account codes could be found in the trial balance.  Your usual routines to filter, perform queries, make adjusting entries, create reports operate just as they always have. It is just easier to assign the EdMIS codes and all of these routines now work faster.

AUDIT-CITY has incorporated the changes necessary for the second year of GASB 68.  A revised Excel worksheet is provided and will be installed in the folder where you choose to install AUDIT-CITY Release 13.  We have also provided two PDF files with information from TMRS regarding the necessary adjusting entries and a sample of the reports provided to each city by TMRS. The sample city from TMRS is Abilene and we have also provided an Example of our worksheet using the Abilene numbers so you can easily compare the numbers in that worksheet with the Abilene information provided by TMRS.

AUDIT-CITY continues to be the best software on the market for preparing financial statements for local governments. The imported data from the accounting system can be analyzed, tested, adjusted as necessary and then easily combined for financial reporting. The software is menu driven and provides the ability to export reports and data to Adobe PDF™ files, Microsoft Excel™ files, Microsoft Word™ files and others. The objective is to provide a way to easily obtain and combine data as necessary to prepare financial statements—a CAFR, a GAAP report, and/or OCBOA reports.

In creating AUDIT-CITY for cities and counties, we have incorporated many of the outstanding features of our AUDIT-L.E.A. software — a successful auditing tool and financial report generator used by school districts and their auditors for over 25 years.

The features of Audit-City are described below!!

  • AUDIT-CITY can be used to create files and reports for an unlimited number of governmental entities. It can also be used to prepare interim reports for the city council or board. Simply choose a unique four character code to identify each particular entity or each particular time period. Once you have created the files for an entity, simply choose that city or county from the list of all those previously created in order to work on its reports.
  • AUDIT-CITY includes the VERY BEST fund-to-government-wide Conversion Routine. It is very easy to use AND it provides complete documentation for later review.
  • The Crosswalk Table contains the account numbers and names from the entity’s chart of accounts. The entity’s account numbers and names are related to the appropriate disclosure locations in the financial statements using a Report Control Code established by EdMIS. This Crosswalk Table can be used from the first year forward.
  • Account balance and amended budget data can be easily imported or hand entered into the trial balance file. Use the Materiality Planning Report option in the Report Menu to calculate the planning materiality amount and the tolerable misstatement amounts for total assets and total revenues summed from the trial balance data.
  • In the Trial Balance file, adjusting entries can be entered as necessary. Reports of the adjustments can be printed for review and approval.
  • Query routines and lead sheets allow for analysis of the trial balance content. Prior Year/Current Year and Budget/Actual comparisons can be made and reports printed to document the results.
  • The status of funds (by individual fund or fund type) provides a quick picture of total assets, liabilities, equities, expenditures, revenues and fund balance. It also provides a quick check to see that the trial balance is in balance for each fund.
  • The major fund calculation is done for each fund with a simple menu click.
  • Data can be easily exported into an Microsoft Excel™ file, a Adobe PDF™ file, a text file, a dbase file or other file types for additional analysis. This accomodates easily the requirements for paperless audits.
  • Trial Balance is imported into data files in the Report Generator for preparation of fund financial statements.
  • In the unique Conversion and Consolidation System, the adjustments routine records each adjustment necessary to convert modified accrual data to accrual and consolidate all governmental activities. This creates an excellent audit trail for the preparation of the government wide financial statements.
  • Additional worksheets determine grant revenue by function and user charges by function for the governmental funds and the general revenue for governmental activities and the data is automatically imported into the government wide data files.
  • AUDIT-CITY checks for consistency between all of the exhibits. This dramatically reduces review time!