 |
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 easilty 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! |