AUDIT-L.E.A. 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 25

Release 25A

Update Notes

11/19/2021 : This update modifies the print routine for Exhibit D-3 (Cash Flow Statement) so that a single line will print after an amount when there is only one item in a category. There is also a modification of the indention of the total amounts printed on Exhibit D-1 on some forms.
 
11/16/2021 : This update corrects an error in the MOE IDEA B test which occurred when the only test that passes was test 4. The result was showing the district to be non-compliant when that was the only test passed.
 
11/15/2021 : This update corrects an alignment problem on one form of Exhibit B-1 in the Expenses column and removes the underline on Exhibit D-3 (Cash Flow Statement) when there is only one item in a particular category such as Cash Flows from Investment Activities, etc.
 
11/08/2021 : This update allows for more lines on the page for the four-column version of Exhibit A-1. This is the one with the three columns for the primary government and for one discretely presented component unit.
 
11/05/2021 : This update corrects an for a missing underline in the third column on the RSI Schedule for the District's Proportionate Share of the Net OPEB Liability.
 
11/02/2021 : This update changes the print routine for the Combining Statement of Fiduciary Net Position for both Custodial funds and Private Purpose Trust funds so that five columns will print on one page when there are only four funds plus the total column.
 
11/01/2021 : This update corrects an error in creating and printing the Individual Fund Statements.
 
10/29/2021 : This update makes some changes to the SEFA print routine to allow the total for all 84.425 programs with different last letters while NOT totaling other programs with the same ALN with different last letters. There is also a correction to the titles on the second page of the RSI Schedule of District Contributions. The file name for the AUDIT-DATA FEED has been corrected to show the current FY.
 
10/27/2021 : This update now calls the new J4 schedule into the Report Data Screen when printing or previewing so the user can change the Exhibit Number and assign a page number if desired. There is also a correction to the printing of Exhibit H-3 and D-1 showing a line after the items and before the total for Liabilities when there are no non-current liabilities in the file. A correction has also been made in the YEAR column headings on the second page of the District's Contributions report for OPEBs.
 
10/19/2021 : This update puts the icon for setting up a new school back on the main screen.
 
10/18/2021 : This update corrects an error made with the last few updates causing the beginning and ending net position amounts to not print on Exhibit B-1 on the second page.
 
10/15/2021 : This update adds Exhibit E-2 to the Print All and the MAKE PDF file option in the Report Generator. This error occurred only if the district has only custodial funds as fiduciary funds. There is also a correction to the routine importing data from the Grant Revenue Worksheet into the data file for Exhibit B-1. The data for FN 99 was not importing into the Grants and Contributions column.
 
10/15/2021 : This update corrects an issue when importing data from the User Charges worksheet which occurred from changes made in the previous update.
 
10/14/2021 : This update makes a correction to the print routine for Exhibit B-1 when there are no enterprise funds but there is a non-fiduciary component unit. The change has not yet been made in the print all routine but will be made shortly.
 
09/27/2021 : This update makes several corrections to the Pension Note and the OPEB Note and these sections in the Notes. There is an editorial change in the RSI note as well. There is also a correction in the file providing the FY on the Exhibit Titles. If you have already created the files in the Report Generator, you can change the FY from 2020 to 2021 by going to the HEADINGS menu option when printing a statement and click the button to change the FY. This will change the FY on all Exhibits. There is also a change in the foot note to Exhibit G-2.
 
09/22/2021 : This update adds the updated compliance programs for Food and Nutrition, Title I Part A, and the Generic Compliance Program. There is also a correction made when printing multiple custodial funds requiring a second page for the combining statement for Additions, Deductions, and changes in Fiduciary Net Position.
 
09/20/2021 : This update adds the revised OPEB and Pension note and includes these with other revisions in the sample Notes to the Financial Statements. We have also made changes in the data file and print routine for the SEFA to show the change to Assistance Listing Number rather than CFDA. All ESSER funds will be totaled as required by OMB. Please note that CRF funds (277) may be passed through both TEA and the local governmental entity.
 
08/31/2021 : This update adds more years to select when running the query in trial balance.
 
08/26/2021 : This update corrects an error in the print routine for one version of Exhibit A-1. The updated audit programs for the ESSER fund, the CRF fund and for State Mandated Programs are also included.
 
08/08/2021 : This update corrects the PEIMS Edit Checks and the EdMIS Code Checks for the new fund numbers provided by TEA. There is also a correction to the print routine for the combining statement for the Additions and Deductions and Changes in Net Position for multiple custodial funds. There is also a correction to the print routine for the Fund to Government Wide Worksheet.
 
07/24/2021 : This update corrects an error in the new J-4 Schedule and in the print routine for J-4. The user should recreate the Schedule for State Compensatory Education and Bilingual Education Expenditures.
 
07/12/2021 : This update adds the new Schedule J-4 to be included in the AFR. There are also additional audit requirements for the State Comp Ed and Bilingual Programs included in the Mandated Programs compliance supplement. The new Exhibit numbers for Budget Comparisons for Food Service and Debt Service are now J-2 and J-3.
 
06/13/2021 : This update edits the routine for testing state spending requirements for mandated programs to include data from funds 199, 266, 281 and 282. There are some revisions in several of the Compliance Programs in the Audit Program Generator and new programs have been added for the CRF and ESSER funds.
 
04/29/2021 : This update corrects an error running the application when installed on a terminal server or remote server. The error required a change in the icon for opening the trial balance on the main screen. There were also some revisions resulting in a smaller file size. There is a new icon for the entire program which will appear in the application. You do not need to reinstall the software. To get the new icon on your desktop shortcut, go to the AUDLEA21 folder and create a new shortcut.
 
Release 25B

Update Notes

11/19/2021 : This update modifies the print routine for Exhibit D-3 (Cash Flow Statement) so that a single line will print after an amount when there is only one item in a category. There is also a modification of the indention of the total amounts printed on Exhibit D-1 on some forms.
 
11/16/2021 : This update corrects an error in the MOE IDEA B test which occurred when the only test that passes was test 4. The result was showing the district to be non-compliant when that was the only test passed.
 
11/15/2021 : This update corrects an alignment problem on one form of Exhibit B-1 in the Expenses column and removes the underline on Exhibit D-3 (Cash Flow Statement) when there is only one item in a particular category such as Cash Flows from Investment Activities, etc.
 
11/08/2021 : This update allows for more lines on the page for the four-column version of Exhibit A-1. This is the one with the three columns for the primary government and for one discretely presented component unit.
 
11/05/2021 : This update corrects an for a missing underline in the third column on the RSI Schedule for the District's Proportionate Share of the Net OPEB Liability.
 
11/02/2021 : This update changes the print routine for the Combining Statement of Fiduciary Net Position for both Custodial funds and Private Purpose Trust funds so that five columns will print on one page when there are only four funds plus the total column.
 
11/01/2021 : This update corrects an error in creating and printing the Individual Fund Statements.
 
10/29/2021 : This update makes some changes to the SEFA print routine to allow the total for all 84.425 programs with different last letters while NOT totaling other programs with the same ALN with different last letters. There is also a correction to the titles on the second page of the RSI Schedule of District Contributions. The file name for the AUDIT-DATA FEED has been corrected to show the current FY.
 
10/27/2021 : This update now calls the new J4 schedule into the Report Data Screen when printing or previewing so the user can change the Exhibit Number and assign a page number if desired. There is also a correction to the printing of Exhibit H-3 and D-1 showing a line after the items and before the total for Liabilities when there are no non-current liabilities in the file. A correction has also been made in the YEAR column headings on the second page of the District's Contributions report for OPEBs.
 
10/19/2021 : This update puts the icon for setting up a new school back on the main screen.
 
10/18/2021 : This update corrects an error made with the last few updates causing the beginning and ending net position amounts to not print on Exhibit B-1 on the second page.
 
10/15/2021 : This update adds Exhibit E-2 to the Print All and the MAKE PDF file option in the Report Generator. This error occurred only if the district has only custodial funds as fiduciary funds. There is also a correction to the routine importing data from the Grant Revenue Worksheet into the data file for Exhibit B-1. The data for FN 99 was not importing into the Grants and Contributions column.
 
10/15/2021 : This update corrects an issue when importing data from the User Charges worksheet which occurred from changes made in the previous update.
 
10/14/2021 : This update makes a correction to the print routine for Exhibit B-1 when there are no enterprise funds but there is a non-fiduciary component unit. The change has not yet been made in the print all routine but will be made shortly.
 
09/27/2021 : This update makes several corrections to the Pension Note and the OPEB Note and these sections in the Notes. There is an editorial change in the RSI note as well. There is also a correction in the file providing the FY on the Exhibit Titles. If you have already created the files in the Report Generator, you can change the FY from 2020 to 2021 by going to the HEADINGS menu option when printing a statement and click the button to change the FY. This will change the FY on all Exhibits. There is also a change in the foot note to Exhibit G-2.
 
09/22/2021 : This update adds the updated compliance programs for Food and Nutrition, Title I Part A, and the Generic Compliance Program. There is also a correction made when printing multiple custodial funds requiring a second page for the combining statement for Additions, Deductions, and changes in Fiduciary Net Position.
 
09/20/2021 : This update adds the revised OPEB and Pension note and includes these with other revisions in the sample Notes to the Financial Statements. We have also made changes in the data file and print routine for the SEFA to show the change to Assistance Listing Number rather than CFDA. All ESSER funds will be totaled as required by OMB. Please note that CRF funds (277) may be passed through both TEA and the local governmental entity.
 
08/31/2021 : This update adds more years to select when running the query in trial balance.
 
08/26/2021 : This update corrects an error in the print routine for one version of Exhibit A-1. The updated audit programs for the ESSER fund, the CRF fund and for State Mandated Programs are also included.
 
08/08/2021 : This update corrects the PEIMS Edit Checks and the EdMIS Code Checks for the new fund numbers provided by TEA. There is also a correction to the print routine for the combining statement for the Additions and Deductions and Changes in Net Position for multiple custodial funds. There is also a correction to the print routine for the Fund to Government Wide Worksheet.
 
07/24/2021 : This update corrects an error in the new J-4 Schedule and in the print routine for J-4. The user should recreate the Schedule for State Compensatory Education and Bilingual Education Expenditures.
 
07/12/2021 : This update adds the new Schedule J-4 to be included in the AFR. There are also additional audit requirements for the State Comp Ed and Bilingual Programs included in the Mandated Programs compliance supplement. The new Exhibit numbers for Budget Comparisons for Food Service and Debt Service are now J-2 and J-3.
 
06/13/2021 : This update edits the routine for testing state spending requirements for mandated programs to include data from funds 199, 266, 281 and 282. There are some revisions in several of the Compliance Programs in the Audit Program Generator and new programs have been added for the CRF and ESSER funds.
 
04/29/2021 : This update corrects an error running the application when installed on a terminal server or remote server. The error required a change in the icon for opening the trial balance on the main screen. There were also some revisions resulting in a smaller file size. There is a new icon for the entire program which will appear in the application. You do not need to reinstall the software. To get the new icon on your desktop shortcut, go to the AUDLEA21 folder and create a new shortcut.
 
Release 25P

Update Notes

09/22/2021 : This update adds the updated compliance programs for Food and Nutrition, Title I Part A, and the Generic Compliance Program. There is also a correction made when printing multiple custodial funds requiring a second page for the combining statement for Additions, Deductions, and changes in Fiduciary Net Position.
 
08/26/2021 : This update corrects an error in the print routine for one version of Exhibit A-1. The updated audit programs for the ESSER fund, the CRF fund and for State Mandated Programs are also included.
 
07/12/2021 : This update adds the new Schedule J-4 to be included in the AFR. There are also additional audit requirements for the State Comp Ed and Bilingual Programs included in the Mandated Programs compliance supplement. The new Exhibit numbers for Budget Comparisons for Food Service and Debt Service are now J-2 and J-3.
 
06/13/2021 : This update edits the routine for testing state spending requirements for mandated programs to include data from funds 199, 266, 281 and 282. There are some revisions in several of the Compliance Programs in the Audit Program Generator and new programs have been added for the CRF and ESSER funds.
 
04/29/2021 : This update corrects an error running the application when installed on a terminal server or remote server. The error required a change in the icon for opening the trial balance on the main screen. There were also some revisions resulting in a smaller file size. There is a new icon for the entire program which will appear in the application. You do not need to reinstall the software. To get the new icon on your desktop shortcut, go to the AUDLEA21 folder and create a new shortcut.
 
Release 25R

Update Notes

11/19/2021 : This update modifies the print routine for Exhibit D-3 (Cash Flow Statement) so that a single line will print after an amount when there is only one item in a category. There is also a modification of the indention of the total amounts printed on Exhibit D-1 on some forms.
 
11/16/2021 : This update corrects an error in the MOE IDEA B test which occurred when the only test that passes was test 4. The result was showing the district to be non-compliant when that was the only test passed.
 
11/15/2021 : This update corrects an alignment problem on one form of Exhibit B-1 in the Expenses column and removes the underline on Exhibit D-3 (Cash Flow Statement) when there is only one item in a particular category such as Cash Flows from Investment Activities, etc.
 
11/08/2021 : This update allows for more lines on the page for the four-column version of Exhibit A-1. This is the one with the three columns for the primary government and for one discretely presented component unit.
 
11/05/2021 : This update corrects an for a missing underline in the third column on the RSI Schedule for the District's Proportionate Share of the Net OPEB Liability.
 
11/02/2021 : This update changes the print routine for the Combining Statement of Fiduciary Net Position for both Custodial funds and Private Purpose Trust funds so that five columns will print on one page when there are only four funds plus the total column.
 
11/01/2021 : This update corrects an error in creating and printing the Individual Fund Statements.
 
10/29/2021 : This update makes some changes to the SEFA print routine to allow the total for all 84.425 programs with different last letters while NOT totaling other programs with the same ALN with different last letters. There is also a correction to the titles on the second page of the RSI Schedule of District Contributions. The file name for the AUDIT-DATA FEED has been corrected to show the current FY.
 
10/27/2021 : This update now calls the new J4 schedule into the Report Data Screen when printing or previewing so the user can change the Exhibit Number and assign a page number if desired. There is also a correction to the printing of Exhibit H-3 and D-1 showing a line after the items and before the total for Liabilities when there are no non-current liabilities in the file. A correction has also been made in the YEAR column headings on the second page of the District's Contributions report for OPEBs.
 
10/19/2021 : This update puts the icon for setting up a new school back on the main screen.
 
10/18/2021 : This update corrects an error made with the last few updates causing the beginning and ending net position amounts to not print on Exhibit B-1 on the second page.
 
10/15/2021 : This update adds Exhibit E-2 to the Print All and the MAKE PDF file option in the Report Generator. This error occurred only if the district has only custodial funds as fiduciary funds. There is also a correction to the routine importing data from the Grant Revenue Worksheet into the data file for Exhibit B-1. The data for FN 99 was not importing into the Grants and Contributions column.
 
09/27/2021 : This update makes several corrections to the Pension Note and the OPEB Note and these sections in the Notes. There is an editorial change in the RSI note as well. There is also a correction in the file providing the FY on the Exhibit Titles. If you have already created the files in the Report Generator, you can change the FY from 2020 to 2021 by going to the HEADINGS menu option when printing a statement and click the button to change the FY. This will change the FY on all Exhibits. There is also a change in the foot note to Exhibit G-2.
 
09/22/2021 : This update adds the updated compliance programs for Food and Nutrition, Title I Part A, and the Generic Compliance Program. There is also a correction made when printing multiple custodial funds requiring a second page for the combining statement for Additions, Deductions, and changes in Fiduciary Net Position.
 
09/20/2021 : This update adds the revised OPEB and Pension note and includes these with other revisions in the sample Notes to the Financial Statements. We have also made changes in the data file and print routine for the SEFA to show the change to Assistance Listing Number rather than CFDA. All ESSER funds will be totaled as required by OMB. Please note that CRF funds (277) may be passed through both TEA and the local governmental entity.
 
08/26/2021 : This update corrects an error in the print routine for one version of Exhibit A-1. The updated audit programs for the ESSER fund, the CRF fund and for State Mandated Programs are also included.
 
08/08/2021 : This update corrects the PEIMS Edit Checks and the EdMIS Code Checks for the new fund numbers provided by TEA. There is also a correction to the print routine for the combining statement for the Additions and Deductions and Changes in Net Position for multiple custodial funds. There is also a correction to the print routine for the Fund to Government Wide Worksheet.
 
07/24/2021 : This update corrects an error in the new J-4 Schedule and in the print routine for J-4. The user should recreate the Schedule for State Compensatory Education and Bilingual Education Expenditures.
 
07/12/2021 : This update adds the new Schedule J-4 to be included in the AFR. There are also additional audit requirements for the State Comp Ed and Bilingual Programs included in the Mandated Programs compliance supplement. The new Exhibit numbers for Budget Comparisons for Food Service and Debt Service are now J-2 and J-3.
 
06/13/2021 : This update edits the routine for testing state spending requirements for mandated programs to include data from funds 199, 266, 281 and 282. There are some revisions in several of the Compliance Programs in the Audit Program Generator and new programs have been added for the CRF and ESSER funds.
 
Release 25S

Update Notes

11/16/2021 : This update corrects an error in the MOE IDEA B test which occurred when the only test that passes was test 4. The result was showing the district to be non-compliant when that was the only test passed.
 
08/31/2021 : This update adds more years to select when running the query in trial balance.
 
08/08/2021 : This update corrects the PEIMS Edit Checks and the EdMIS Code Checks for the new fund numbers provided by TEA. There is also a correction to the print routine for the combining statement for the Additions and Deductions and Changes in Net Position for multiple custodial funds. There is also a correction to the print routine for the Fund to Government Wide Worksheet.
 
07/12/2021 : This update adds the new Schedule J-4 to be included in the AFR. There are also additional audit requirements for the State Comp Ed and Bilingual Programs included in the Mandated Programs compliance supplement. The new Exhibit numbers for Budget Comparisons for Food Service and Debt Service are now J-2 and J-3.
 
06/13/2021 : This update edits the routine for testing state spending requirements for mandated programs to include data from funds 199, 266, 281 and 282. There are some revisions in several of the Compliance Programs in the Audit Program Generator and new programs have been added for the CRF and ESSER funds.
 


Updates for RELEASE 24

Release 24A

Update Notes

02/11/2021 : This update corrects an error in printing the Combining Statement for Trust Funds when there are only two funds and a total column.
 
01/11/2021 : This update changes the routine to create the PEIMS file for submission so that negative numbers are displayed with leading minus signs rather than the old codes placed in the last character of the number. This does NOT create an XML file. An ASCII file is created which can then be used to create the required XML file.
 
12/13/2020 : This update corrects an another error occurring when printing Exhibits E1 and E2 when you have a Private Purpose Trust fund, an Agency fund (Not Custodial Fund) and a Fiduciary Component Unit. Remember the Agency Fund information is NOT included on Exhibit E2. Also, on Exhibit E1, there should be nothing in the equity section of the column.
 
12/08/2020 : This update corrects an error when printing Exhibit E2 if you have a fiduciary component unit. There is also a correction to the calculation of the ending net position in the data file for the Expenses and Revenues for the Fiduciary Component Unit.
 
12/03/2020 : This update corrects an error in printing and creating the PDF file for the entire report in the Report Generator. The error corrected caused Exhibit E-1 to not be included if the district has only agency funds.
 
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/10/2020 : This update makes more room on the split page report for Exhibit C-1 so that one more line of data can be printed allowing Assets, Liabilities and Fund Balance items to be printed on one page.
 
11/09/2020 : This update allows for a little more space on one version of Exhibit B1 so that the last few rows do not print on an additional page.
 
11/08/2020 : This update corrects some formatting issue on Exhibit H-12 - the Combining Statement of Additions, Deductions and Fund Net Position for Private Purpose Trust Funds. There is also a change is the positioning of the line items on Exhibit E-2. There is a revised Pension Note for the Documents Section correcting the Contributions Rate for Employers for FY 2020. It should be 7.5% rather than 7.7%.
 
11/05/2020 : This update corrects the import routine for Private Purpose Trust funds so that items coded to 5744 will import. There is also a correction in the date for the extra two months of tax collections when the district has changed their fiscal year from August to June.
 
11/03/2020 : This update corrects an error in creating the data files for agency funds when GASB 84 has NOT been implemented. There is also a correct to the compliance test for the CCMR Outcomes Bonus Allotment. The correct name of this program now appears on the data entry screen. There is also a correction to the routine making the PDF file for Exhibit H-12 from the Report Data screen.
 
10/30/2020 : This update corrects an error which occurred if adding an Agency Fund Type for Exhibit H-9 for Agency Funds. There is also a correction to Exhibit H-12 if you have more than 5 Private Purpose Trust Funds.
 
10/29/2020 : This update allows for as many as nine different agency types for Exhibit H-9.
 
10/28/2020 : This update allows for as many as seven different agency types for Exhibit H-9.
 
10/22/2020 : This update corrects an error printing the Combining Statement H12 for Trust Funds.
 
10/19/2020 : This update corrects an error printing Exhibit E-1 when there are only private purpose trust funds.
 
10/07/2020 : This update corrects an error importing prior year data into the data files for trust funds and an error printing Exhibit H-12 in the Report Generator. For Release 24 A and Release 24 P, the remaining compliance programs have been revised using the 2020 Compliance Supplement.
 
09/18/2020 : This update corrects an error received when running the EdMIS Checks routine in Trial Balance. The updated compliance program for the Special Ed Cluster is also included. An error in importing the prior year depreciation schedule has been repaired. You should be sure to add the subtotal row at the bottom of the file in the 2019 program - for example 153XXX for the Total for Furniture and Equipment. There is a revision in the Excel worksheets for GASB 68 and 75 found in the AUDLEA20 folder.
 
09/10/2020 : This update adds codes 5755, 5757, 5758 and 5759 for the data files for Additions and Deductions to Net Position for both the trust fund file and the custodial fund file for Exhibit E2. These will be imported from fund 865. This assumes GASB 84 has been implemented and fund 865 is now a custodial fund rather than an agency fund.
 
09/08/2020 : This update adds a query option in Trial Balance to query by Fund and Local Options (Other) 3,4 and 5. There are changes related to fund 266 in the Report Generator and in Trial Balance. Compliance programs for the Generic, Crosswalk, Title 1 and Child Nutrition have been revised with the new compliance supplement and are included for the Audit Program Generator.
 
08/11/2020 : This update corrects an error in printing Exhibit E2 when you have only custodial funds. The spell check routines have also been repaired in the Documents in the Report Generator and in the Audit Program Generator. We have also added a spell check routine to the data entry screen for the reconciliation statements C2 and C4.
 
08/06/2020 : This update contains the newly revised Pension Note, OPEB Note and Notes to the Financial Statement. There is a revision in the RSI note adding some additional information on the Pension schedules. There is also a corrected Audit Program for the State Mandated Programs for the Early Education Allotment.
 
07/23/2020 : This update modifies the tests for Special Allotments (Mandated Programs) in the Trial Balance to allow data from Fund 266 (ESSER grant) to be used in meeting the spending requirements for the PIC codes related to each program. There is also a critical change in the Report Generator correcting the print routine for the Tax Schedule so the footnote entered in the data file will print at the bottom of the schedule.
 
06/17/2020 : This update makes the revisions necessary with the TRS information for the Pension and OPEB plans. There is also a revised manual showing the new information for the GASB 68 and GASB 75 input screens in the Example Worksheets. Revised Excel Worksheets and Example worksheets for GASB 68 and 75 will be placed in your application folder. A new revision to Schedule L is included and the new note to RSI is in the Report Generator. There is a revised Compliance Program for the State Mandated Programs for the Audit Program Generator. There is also a revised District Check List for the Audit Program Generator.
 
05/19/2020 : This update adds routines to automatically print fiduciary fund statements with new requirements for GASB 84 OR with the old format if GASB 84 has not been implemented. There is also a new Schedule L provided by T.E.A. A correction has been made to print routines in the Trial Balance to ensure full four characters of the object code are displayed.
 
Release 24B

Update Notes

02/11/2021 : This update corrects an error in printing the Combining Statement for Trust Funds when there are only two funds and a total column.
 
01/11/2021 : This update changes the routine to create the PEIMS file for submission so that negative numbers are displayed with leading minus signs rather than the old codes placed in the last character of the number. This does NOT create an XML file. An ASCII file is created which can then be used to create the required XML file.
 
12/13/2020 : This update corrects an another error occurring when printing Exhibits E1 and E2 when you have a Private Purpose Trust fund, an Agency fund (Not Custodial Fund) and a Fiduciary Component Unit. Remember the Agency Fund information is NOT included on Exhibit E2. Also, on Exhibit E1, there should be nothing in the equity section of the column.
 
12/08/2020 : This update corrects an error when printing Exhibit E2 if you have a fiduciary component unit. There is also a correction to the calculation of the ending net position in the data file for the Expenses and Revenues for the Fiduciary Component Unit.
 
12/03/2020 : This update corrects an error in printing and creating the PDF file for the entire report in the Report Generator. The error corrected caused Exhibit E-1 to not be included if the district has only agency funds.
 
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/10/2020 : This update makes more room on the split page report for Exhibit C-1 so that one more line of data can be printed allowing Assets, Liabilities and Fund Balance items to be printed on one page.
 
11/09/2020 : This update allows for a little more space on one version of Exhibit B1 so that the last few rows do not print on an additional page.
 
11/08/2020 : This update corrects some formatting issue on Exhibit H-12 - the Combining Statement of Additions, Deductions and Fund Net Position for Private Purpose Trust Funds. There is also a change is the positioning of the line items on Exhibit E-2. There is a revised Pension Note for the Documents Section correcting the Contributions Rate for Employers for FY 2020. It should be 7.5% rather than 7.7%.
 
11/05/2020 : This update corrects the import routine for Private Purpose Trust funds so that items coded to 5744 will import. There is also a correction in the date for the extra two months of tax collections when the district has changed their fiscal year from August to June.
 
11/03/2020 : This update corrects an error in creating the data files for agency funds when GASB 84 has NOT been implemented. There is also a correct to the compliance test for the CCMR Outcomes Bonus Allotment. The correct name of this program now appears on the data entry screen. There is also a correction to the routine making the PDF file for Exhibit H-12 from the Report Data screen.
 
10/30/2020 : This update corrects an error which occurred if adding an Agency Fund Type for Exhibit H-9 for Agency Funds. There is also a correction to Exhibit H-12 if you have more than 5 Private Purpose Trust Funds.
 
10/29/2020 : This update allows for as many as nine different agency types for Exhibit H-9.
 
10/28/2020 : This update allows for as many as seven different agency types for Exhibit H-9.
 
10/22/2020 : This update corrects an error printing the Combining Statement H12 for Trust Funds.
 
10/19/2020 : This update corrects an error printing Exhibit E-1 when there are only private purpose trust funds.
 
10/07/2020 : This update corrects an error importing prior year data into the data files for trust funds and an error printing Exhibit H-12 in the Report Generator. For Release 24 A and Release 24 P, the remaining compliance programs have been revised using the 2020 Compliance Supplement.
 
09/18/2020 : This update corrects an error received when running the EdMIS Checks routine in Trial Balance. The updated compliance program for the Special Ed Cluster is also included. An error in importing the prior year depreciation schedule has been repaired. You should be sure to add the subtotal row at the bottom of the file in the 2019 program - for example 153XXX for the Total for Furniture and Equipment. There is a revision in the Excel worksheets for GASB 68 and 75 found in the AUDLEA20 folder.
 
09/10/2020 : This update adds codes 5755, 5757, 5758 and 5759 for the data files for Additions and Deductions to Net Position for both the trust fund file and the custodial fund file for Exhibit E2. These will be imported from fund 865. This assumes GASB 84 has been implemented and fund 865 is now a custodial fund rather than an agency fund.
 
09/08/2020 : This update adds a query option in Trial Balance to query by Fund and Local Options (Other) 3,4 and 5. There are changes related to fund 266 in the Report Generator and in Trial Balance. Compliance programs for the Generic, Crosswalk, Title 1 and Child Nutrition have been revised with the new compliance supplement and are included for the Audit Program Generator.
 
08/11/2020 : This update corrects an error in printing Exhibit E2 when you have only custodial funds. The spell check routines have also been repaired in the Documents in the Report Generator and in the Audit Program Generator. We have also added a spell check routine to the data entry screen for the reconciliation statements C2 and C4.
 
08/06/2020 : This update contains the newly revised Pension Note, OPEB Note and Notes to the Financial Statement. There is a revision in the RSI note adding some additional information on the Pension schedules. There is also a corrected Audit Program for the State Mandated Programs for the Early Education Allotment.
 
07/23/2020 : This update modifies the tests for Special Allotments (Mandated Programs) in the Trial Balance to allow data from Fund 266 (ESSER grant) to be used in meeting the spending requirements for the PIC codes related to each program. There is also a critical change in the Report Generator correcting the print routine for the Tax Schedule so the footnote entered in the data file will print at the bottom of the schedule.
 
06/17/2020 : This update makes the revisions necessary with the TRS information for the Pension and OPEB plans. There is also a revised manual showing the new information for the GASB 68 and GASB 75 input screens in the Example Worksheets. Revised Excel Worksheets and Example worksheets for GASB 68 and 75 will be placed in your application folder. A new revision to Schedule L is included and the new note to RSI is in the Report Generator. There is a revised Compliance Program for the State Mandated Programs for the Audit Program Generator. There is also a revised District Check List for the Audit Program Generator.
 
05/19/2020 : This update adds routines to automatically print fiduciary fund statements with new requirements for GASB 84 OR with the old format if GASB 84 has not been implemented. There is also a new Schedule L provided by T.E.A. A correction has been made to print routines in the Trial Balance to ensure full four characters of the object code are displayed.
 
Release 24P

Update Notes

10/07/2020 : This update corrects an error importing prior year data into the data files for trust funds and an error printing Exhibit H-12 in the Report Generator. For Release 24 A and Release 24 P, the remaining compliance programs have been revised using the 2020 Compliance Supplement.
 
09/18/2020 : This update corrects an error received when running the EdMIS Checks routine in Trial Balance. The updated compliance program for the Special Ed Cluster is also included. An error in importing the prior year depreciation schedule has been repaired. You should be sure to add the subtotal row at the bottom of the file in the 2019 program - for example 153XXX for the Total for Furniture and Equipment. There is a revision in the Excel worksheets for GASB 68 and 75 found in the AUDLEA20 folder.
 
09/08/2020 : This update adds a query option in Trial Balance to query by Fund and Local Options (Other) 3,4 and 5. There are changes related to fund 266 in the Report Generator and in Trial Balance. Compliance programs for the Generic, Crosswalk, Title 1 and Child Nutrition have been revised with the new compliance supplement and are included for the Audit Program Generator.
 
08/11/2020 : This update corrects an error in printing Exhibit E2 when you have only custodial funds. The spell check routines have also been repaired in the Documents in the Report Generator and in the Audit Program Generator. We have also added a spell check routine to the data entry screen for the reconciliation statements C2 and C4.
 
08/06/2020 : This update contains the newly revised Pension Note, OPEB Note and Notes to the Financial Statement. There is a revision in the RSI note adding some additional information on the Pension schedules. There is also a corrected Audit Program for the State Mandated Programs for the Early Education Allotment.
 
06/17/2020 : This update makes the revisions necessary with the TRS information for the Pension and OPEB plans. There is also a revised manual showing the new information for the GASB 68 and GASB 75 input screens in the Example Worksheets. Revised Excel Worksheets and Example worksheets for GASB 68 and 75 will be placed in your application folder. A new revision to Schedule L is included and the new note to RSI is in the Report Generator. There is a revised Compliance Program for the State Mandated Programs for the Audit Program Generator. There is also a revised District Check List for the Audit Program Generator.
 
Release 24R

Update Notes

02/11/2021 : This update corrects an error in printing the Combining Statement for Trust Funds when there are only two funds and a total column.
 
12/13/2020 : This update corrects an another error occurring when printing Exhibits E1 and E2 when you have a Private Purpose Trust fund, an Agency fund (Not Custodial Fund) and a Fiduciary Component Unit. Remember the Agency Fund information is NOT included on Exhibit E2. Also, on Exhibit E1, there should be nothing in the equity section of the column.
 
12/08/2020 : This update corrects an error when printing Exhibit E2 if you have a fiduciary component unit. There is also a correction to the calculation of the ending net position in the data file for the Expenses and Revenues for the Fiduciary Component Unit.
 
12/03/2020 : This update corrects an error in printing and creating the PDF file for the entire report in the Report Generator. The error corrected caused Exhibit E-1 to not be included if the district has only agency funds.
 
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/10/2020 : This update makes more room on the split page report for Exhibit C-1 so that one more line of data can be printed allowing Assets, Liabilities and Fund Balance items to be printed on one page.
 
11/09/2020 : This update allows for a little more space on one version of Exhibit B1 so that the last few rows do not print on an additional page.
 
11/08/2020 : This update corrects some formatting issue on Exhibit H-12 - the Combining Statement of Additions, Deductions and Fund Net Position for Private Purpose Trust Funds. There is also a change is the positioning of the line items on Exhibit E-2. There is a revised Pension Note for the Documents Section correcting the Contributions Rate for Employers for FY 2020. It should be 7.5% rather than 7.7%.
 
11/05/2020 : This update corrects the import routine for Private Purpose Trust funds so that items coded to 5744 will import. There is also a correction in the date for the extra two months of tax collections when the district has changed their fiscal year from August to June.
 
11/03/2020 : This update corrects an error in creating the data files for agency funds when GASB 84 has NOT been implemented. There is also a correct to the compliance test for the CCMR Outcomes Bonus Allotment. The correct name of this program now appears on the data entry screen. There is also a correction to the routine making the PDF file for Exhibit H-12 from the Report Data screen.
 
10/30/2020 : This update corrects an error which occurred if adding an Agency Fund Type for Exhibit H-9 for Agency Funds. There is also a correction to Exhibit H-12 if you have more than 5 Private Purpose Trust Funds.
 
10/29/2020 : This update allows for as many as nine different agency types for Exhibit H-9.
 
10/28/2020 : This update allows for as many as seven different agency types for Exhibit H-9.
 
10/22/2020 : This update corrects an error printing the Combining Statement H12 for Trust Funds.
 
10/19/2020 : This update corrects an error printing Exhibit E-1 when there are only private purpose trust funds.
 
10/07/2020 : This update corrects an error importing prior year data into the data files for trust funds and an error printing Exhibit H-12 in the Report Generator. For Release 24 A and Release 24 P, the remaining compliance programs have been revised using the 2020 Compliance Supplement.
 
09/18/2020 : This update corrects an error received when running the EdMIS Checks routine in Trial Balance. The updated compliance program for the Special Ed Cluster is also included. An error in importing the prior year depreciation schedule has been repaired. You should be sure to add the subtotal row at the bottom of the file in the 2019 program - for example 153XXX for the Total for Furniture and Equipment. There is a revision in the Excel worksheets for GASB 68 and 75 found in the AUDLEA20 folder.
 
09/10/2020 : This update adds codes 5755, 5757, 5758 and 5759 for the data files for Additions and Deductions to Net Position for both the trust fund file and the custodial fund file for Exhibit E2. These will be imported from fund 865. This assumes GASB 84 has been implemented and fund 865 is now a custodial fund rather than an agency fund.
 
09/08/2020 : This update adds a query option in Trial Balance to query by Fund and Local Options (Other) 3,4 and 5. There are changes related to fund 266 in the Report Generator and in Trial Balance. Compliance programs for the Generic, Crosswalk, Title 1 and Child Nutrition have been revised with the new compliance supplement and are included for the Audit Program Generator.
 
08/11/2020 : This update corrects an error in printing Exhibit E2 when you have only custodial funds. The spell check routines have also been repaired in the Documents in the Report Generator and in the Audit Program Generator. We have also added a spell check routine to the data entry screen for the reconciliation statements C2 and C4.
 
08/06/2020 : This update contains the newly revised Pension Note, OPEB Note and Notes to the Financial Statement. There is a revision in the RSI note adding some additional information on the Pension schedules. There is also a corrected Audit Program for the State Mandated Programs for the Early Education Allotment.
 
07/23/2020 : This update modifies the tests for Special Allotments (Mandated Programs) in the Trial Balance to allow data from Fund 266 (ESSER grant) to be used in meeting the spending requirements for the PIC codes related to each program. There is also a critical change in the Report Generator correcting the print routine for the Tax Schedule so the footnote entered in the data file will print at the bottom of the schedule.
 
06/17/2020 : This update makes the revisions necessary with the TRS information for the Pension and OPEB plans. There is also a revised manual showing the new information for the GASB 68 and GASB 75 input screens in the Example Worksheets. Revised Excel Worksheets and Example worksheets for GASB 68 and 75 will be placed in your application folder. A new revision to Schedule L is included and the new note to RSI is in the Report Generator. There is a revised Compliance Program for the State Mandated Programs for the Audit Program Generator. There is also a revised District Check List for the Audit Program Generator.
 
05/19/2020 : This update adds routines to automatically print fiduciary fund statements with new requirements for GASB 84 OR with the old format if GASB 84 has not been implemented. There is also a new Schedule L provided by T.E.A. A correction has been made to print routines in the Trial Balance to ensure full four characters of the object code are displayed.
 
Release 24S

Update Notes

01/11/2021 : This update changes the routine to create the PEIMS file for submission so that negative numbers are displayed with leading minus signs rather than the old codes placed in the last character of the number. This does NOT create an XML file. An ASCII file is created which can then be used to create the required XML file.
 
11/03/2020 : This update corrects an error in creating the data files for agency funds when GASB 84 has NOT been implemented. There is also a correct to the compliance test for the CCMR Outcomes Bonus Allotment. The correct name of this program now appears on the data entry screen. There is also a correction to the routine making the PDF file for Exhibit H-12 from the Report Data screen.
 
10/07/2020 : This update corrects an error importing prior year data into the data files for trust funds and an error printing Exhibit H-12 in the Report Generator. For Release 24 A and Release 24 P, the remaining compliance programs have been revised using the 2020 Compliance Supplement.
 
09/18/2020 : This update corrects an error received when running the EdMIS Checks routine in Trial Balance. The updated compliance program for the Special Ed Cluster is also included. An error in importing the prior year depreciation schedule has been repaired. You should be sure to add the subtotal row at the bottom of the file in the 2019 program - for example 153XXX for the Total for Furniture and Equipment. There is a revision in the Excel worksheets for GASB 68 and 75 found in the AUDLEA20 folder.
 
09/08/2020 : This update adds a query option in Trial Balance to query by Fund and Local Options (Other) 3,4 and 5. There are changes related to fund 266 in the Report Generator and in Trial Balance. Compliance programs for the Generic, Crosswalk, Title 1 and Child Nutrition have been revised with the new compliance supplement and are included for the Audit Program Generator.
 
08/11/2020 : This update corrects an error in printing Exhibit E2 when you have only custodial funds. The spell check routines have also been repaired in the Documents in the Report Generator and in the Audit Program Generator. We have also added a spell check routine to the data entry screen for the reconciliation statements C2 and C4.
 
08/06/2020 : This update contains the newly revised Pension Note, OPEB Note and Notes to the Financial Statement. There is a revision in the RSI note adding some additional information on the Pension schedules. There is also a corrected Audit Program for the State Mandated Programs for the Early Education Allotment.
 
07/23/2020 : This update modifies the tests for Special Allotments (Mandated Programs) in the Trial Balance to allow data from Fund 266 (ESSER grant) to be used in meeting the spending requirements for the PIC codes related to each program. There is also a critical change in the Report Generator correcting the print routine for the Tax Schedule so the footnote entered in the data file will print at the bottom of the schedule.
 
06/17/2020 : This update makes the revisions necessary with the TRS information for the Pension and OPEB plans. There is also a revised manual showing the new information for the GASB 68 and GASB 75 input screens in the Example Worksheets. Revised Excel Worksheets and Example worksheets for GASB 68 and 75 will be placed in your application folder. A new revision to Schedule L is included and the new note to RSI is in the Report Generator. There is a revised Compliance Program for the State Mandated Programs for the Audit Program Generator. There is also a revised District Check List for the Audit Program Generator.
 
05/19/2020 : This update adds routines to automatically print fiduciary fund statements with new requirements for GASB 84 OR with the old format if GASB 84 has not been implemented. There is also a new Schedule L provided by T.E.A. A correction has been made to print routines in the Trial Balance to ensure full four characters of the object code are displayed.
 


Updates for RELEASE 23

Release 23A

Update Notes

01/15/2020 : This update confirms that the pdf file created for the annual report is set to be an Accessible PDF file. The complete report printed for the AFR must be converted to add the requirements for T.E.A. by using the Accessibility tools with Adobe Acrobat DC programs. The PDF file created in AUDIT-L.E.A. can be converted using the various software packages from Adobe that allow this conversion.
 
01/11/2020 : This update adds an option to print Exhibit A-1 on two pages with Assets and Deferred Resource Outflows on the first page and Liabilities, Deferred Resource Inflows and Net Position items on the second.
 
12/16/2019 : This update corrects an error which occurred when importing the adopted budget data from the trial balance file into the adopted budget data files in the Report Generator. The program was not checking to be sure the fund type selected to import was on the fund list.
 
12/12/2019 : This update corrects an error resulting from the update put on 12/11. The formatting command on the Statement of District Contributions for the OPEB Plan presented in RSI was including a decimal and a % mark on all lines in the report. This has now been corrected.
 
12/11/2019 : This update makes several formatting corrections for line lengths and heights. Changes are on Exhibits C1, H2, J1, and the RSI Schedule of Contributions for the OPEB plan. There is also a correction in the description on Exhibit A-1 for code 3880. The spelling for Scholarships was corrected. This change will only occur if you create or recreate the data file for Exhibit A-1.
 
12/06/2019 : This update changes the notes to the RSI schedules for the TRS pension to refer to the GASB Codification rather than the original GASB 68 pronouncement.
 
12/01/2019 : This update corrects the underline for the cash flow statement for enterprise funds under the total amount for the Net Cash Provided by Operating Activities. This is the form with no major enterprise funds and both enterprise and internal service funds.
 
11/22/2019 : This update now allows for the line to be printed after only one line item and before the total passed through amount in the SEFA. There are some minor formatting changes in Exhibits B-1, C-1 and the footnote to Exhibit G-6.
 
11/08/2019 : This update adjusts the formatting on some of the forms of the reports where the lines appeared to be too close, cutting of the bottoms of the 'y' and 'g', etc.
 
10/27/2019 : This update adds the ability to add a reconciliation row and new overall total on the tax schedules for Districts which have changed their FY this reporting period. Users should add row with 3010 in the YEARS column and enter their information on that row. Remember you can add notes to the Tax Schedule by going to row 9000 and entering the text in the NOTE box at the bottom of the screen.
 
10/19/2019 : This update allows the description for function 93 on the budget comparison print routine to expand as necessary to include the full description of the function.
 
10/07/2019 : This update adds the cut and paste icons to the tool bar for the editing of the reconciliation statements C2 and C4.
 
09/23/2019 : This update corrects the text for the Reconciliation Statements C2 and C4 and adds the revised Pension and OPEB note to the file for the Notes to the Financial Statements in the Documents Section of the Report Generator.
 
08/11/2019 : This update adds a routine to change the ending date on the tax schedule for districts who changed from 8/31 to 6/30 this year. All schedules except the tax schedules are reported on the 10 month basis - beginning September 1, 2018 and ending June 30, 2019. The tax schedule, however, must contain 12 months of data and should be reported for September 1, 2018 through August 31, 2019. When editing the FY in the Report Data/Headings menu option be sure to enter June 30 and September 1 dates for the ending and beginning of the FY.
 
08/08/2019 : This update contains a few small corrections for alignment of items in Exhibit A-1 and Exhibit C-1. The footnotes to the Schedule of the District's Proportionate Share of the Net Pension Liability and of the Not OPEB liability have also been corrected.
 
07/16/2019 : This update contains all of the revisions in the Audit Program Compliance Programs as per the June, 2019, Supplement. There is also a revision to the OPEB and PENSION notes giving instructions to obtain the future net deferrals from the Schedule of Deferrals for GASB 68 and GASB 75 2018 which are now available on the TRS website. The revision to the printout for the reconciliation tables for these also now does not contain the schedule of deferrals calculated from TRS data previously provided.
 
06/20/2019 : This update contains some revisions to the OPEB note and the Pension Note which are created in the documents routine in the Report Generator. There is also a change on the GASB 75 Data Entry Screen instructing the user to enter then amount for a20 with a negative sign ONLY if the amount is negative in the TRS table. We have also added a routine to correct for rounding errors when calculating the future net deferrals for both GASB 75 and GASB 68.
 
06/14/2019 : This update corrects an error in printing the reconciliation between the change in Exhibit A1 and B1 resulting from the adjustments for GASB 75. The error was in the print routine only. The adjusting entries were correct and resulted in the correct adjustments in the fund to government wide adjustments file.
 
06/11/2019 : This update revises the GASB 75 and GASB 68 Data Entry Screens and makes required changes in previously programmed adjusting entries. A new table is added to the printed reports from these screens which calculates the future net deferrals for the next five years and thereafter for the required table in the notes. TRS no longer provides the schedule of deferrals providing this information for each district.
 
05/23/2019 : This update corrects an error in the routine importing the long-term debt and capital items from the prior year fund to government wide worksheet. The deferred resource inflow related to the OPEB plan was being imported into the column for the debt and capital items at the beginning of the year. This amount will be entered with the other adjusting entries in the GASB 75 column.
 
05/10/2019 : This update corrects the column headings for the correct FY in Exhibit G9 - The Schedule of District's Contributions for Other Postemployment Benefits (OPEB).
 
05/01/2019 : This update makes a revision in the Excel Worksheet for GASB 75 and for the Example worksheet for GASB 75. These will be placed in the installation folder for AUDIT-L.E.A.
 
04/13/2019 : This update corrects the GASB 75 adjustment system. There is an additional adjustment added. The AUDIT-L.E.A. Instruction Manual has been revised to show the new adjustment.
 
Release 23B

Update Notes

01/15/2020 : This update confirms that the pdf file created for the annual report is set to be an Accessible PDF file. The complete report printed for the AFR must be converted to add the requirements for T.E.A. by using the Accessibility tools with Adobe Acrobat DC programs. The PDF file created in AUDIT-L.E.A. can be converted using the various software packages from Adobe that allow this conversion.
 
01/11/2020 : This update adds an option to print Exhibit A-1 on two pages with Assets and Deferred Resource Outflows on the first page and Liabilities, Deferred Resource Inflows and Net Position items on the second.
 
12/16/2019 : This update corrects an error which occurred when importing the adopted budget data from the trial balance file into the adopted budget data files in the Report Generator. The program was not checking to be sure the fund type selected to import was on the fund list.
 
12/12/2019 : This update corrects an error resulting from the update put on 12/11. The formatting command on the Statement of District Contributions for the OPEB Plan presented in RSI was including a decimal and a % mark on all lines in the report. This has now been corrected.
 
12/11/2019 : This update makes several formatting corrections for line lengths and heights. Changes are on Exhibits C1, H2, J1, and the RSI Schedule of Contributions for the OPEB plan. There is also a correction in the description on Exhibit A-1 for code 3880. The spelling for Scholarships was corrected. This change will only occur if you create or recreate the data file for Exhibit A-1.
 
12/06/2019 : This update changes the notes to the RSI schedules for the TRS pension to refer to the GASB Codification rather than the original GASB 68 pronouncement.
 
12/01/2019 : This update corrects the underline for the cash flow statement for enterprise funds under the total amount for the Net Cash Provided by Operating Activities. This is the form with no major enterprise funds and both enterprise and internal service funds.
 
11/22/2019 : This update now allows for the line to be printed after only one line item and before the total passed through amount in the SEFA. There are some minor formatting changes in Exhibits B-1, C-1 and the footnote to Exhibit G-6.
 
11/08/2019 : This update adjusts the formatting on some of the forms of the reports where the lines appeared to be too close, cutting of the bottoms of the 'y' and 'g', etc.
 
10/27/2019 : This update adds the ability to add a reconciliation row and new overall total on the tax schedules for Districts which have changed their FY this reporting period. Users should add row with 3010 in the YEARS column and enter their information on that row. Remember you can add notes to the Tax Schedule by going to row 9000 and entering the text in the NOTE box at the bottom of the screen.
 
10/19/2019 : This update allows the description for function 93 on the budget comparison print routine to expand as necessary to include the full description of the function.
 
10/07/2019 : This update adds the cut and paste icons to the tool bar for the editing of the reconciliation statements C2 and C4.
 
09/23/2019 : This update corrects the text for the Reconciliation Statements C2 and C4 and adds the revised Pension and OPEB note to the file for the Notes to the Financial Statements in the Documents Section of the Report Generator.
 
08/11/2019 : This update adds a routine to change the ending date on the tax schedule for districts who changed from 8/31 to 6/30 this year. All schedules except the tax schedules are reported on the 10 month basis - beginning September 1, 2018 and ending June 30, 2019. The tax schedule, however, must contain 12 months of data and should be reported for September 1, 2018 through August 31, 2019. When editing the FY in the Report Data/Headings menu option be sure to enter June 30 and September 1 dates for the ending and beginning of the FY.
 
08/08/2019 : This update contains a few small corrections for alignment of items in Exhibit A-1 and Exhibit C-1. The footnotes to the Schedule of the District's Proportionate Share of the Net Pension Liability and of the Not OPEB liability have also been corrected.
 
07/16/2019 : This update contains all of the revisions in the Audit Program Compliance Programs as per the June, 2019, Supplement. There is also a revision to the OPEB and PENSION notes giving instructions to obtain the future net deferrals from the Schedule of Deferrals for GASB 68 and GASB 75 2018 which are now available on the TRS website. The revision to the printout for the reconciliation tables for these also now does not contain the schedule of deferrals calculated from TRS data previously provided.
 
06/20/2019 : This update contains some revisions to the OPEB note and the Pension Note which are created in the documents routine in the Report Generator. There is also a change on the GASB 75 Data Entry Screen instructing the user to enter then amount for a20 with a negative sign ONLY if the amount is negative in the TRS table. We have also added a routine to correct for rounding errors when calculating the future net deferrals for both GASB 75 and GASB 68.
 
06/14/2019 : This update corrects an error in printing the reconciliation between the change in Exhibit A1 and B1 resulting from the adjustments for GASB 75. The error was in the print routine only. The adjusting entries were correct and resulted in the correct adjustments in the fund to government wide adjustments file.
 
06/11/2019 : This update revises the GASB 75 and GASB 68 Data Entry Screens and makes required changes in previously programmed adjusting entries. A new table is added to the printed reports from these screens which calculates the future net deferrals for the next five years and thereafter for the required table in the notes. TRS no longer provides the schedule of deferrals providing this information for each district.
 
05/23/2019 : This update corrects an error in the routine importing the long-term debt and capital items from the prior year fund to government wide worksheet. The deferred resource inflow related to the OPEB plan was being imported into the column for the debt and capital items at the beginning of the year. This amount will be entered with the other adjusting entries in the GASB 75 column.
 
05/10/2019 : This update corrects the column headings for the correct FY in Exhibit G9 - The Schedule of District's Contributions for Other Postemployment Benefits (OPEB).
 
05/01/2019 : This update makes a revision in the Excel Worksheet for GASB 75 and for the Example worksheet for GASB 75. These will be placed in the installation folder for AUDIT-L.E.A.
 
04/13/2019 : This update corrects the GASB 75 adjustment system. There is an additional adjustment added. The AUDIT-L.E.A. Instruction Manual has been revised to show the new adjustment.
 
Release 23P

Update Notes

07/16/2019 : This update contains all of the revisions in the Audit Program Compliance Programs as per the June, 2019, Supplement. There is also a revision to the OPEB and PENSION notes giving instructions to obtain the future net deferrals from the Schedule of Deferrals for GASB 68 and GASB 75 2018 which are now available on the TRS website. The revision to the printout for the reconciliation tables for these also now does not contain the schedule of deferrals calculated from TRS data previously provided.
 


Updates for RELEASE 22

Release 22A

Update Notes

01/09/2019 : This update corrects the print routine for the second page of Exhibit H2 when there are only three columns of data on the first page. The calculation of the total expenditures in the second column was doubling the amount.
 
12/13/2018 : This update corrects the print routine for the note for the Negative Program Revenue resulting from the negative on-behalf contributions related to the negative expense for the TRS OPEB plan. The print routine was cutting off the end of the first paragraph.
 
12/06/2018 : This update corrects the print routine for Exhibits C2 and C4 so that the block format for the text is correctly printed on these exhibits. Remember you should not have extra spaces at the end of your text unless you wish to add additional lines after that item.
 
12/05/2018 : This update increases the column widths for the version of the combining statement H-2 where the first page has only three columns. This has been done to accommodate larger numbers in the columns.
 
12/03/2018 : This update corrects an error which occurred when creating data files in the report generator when there are NO special revenue funds but there are internal service funds or enterprise funds.
 
11/26/2018 : This update corrects the AUDIT DATA FEED routine to correctly bring in the total of the capital projects funds in Exhibits C1 and C3 (T.E.A.'s C-2) when there are multiple major capital projects funds in the fund level statements.
 
11/11/2018 : This update adds the message "AUDIT-L.E.A. found no Errors" to print for the PEIMS check routine in Trial Balance in the event there were no errors detected from the PEIMS check routine. There is also a correction to the name of the PDF file created for Schedule L. Remember this MUST either be included with your official PDF file OR submitted separately.
 
11/08/2018 : This update corrects an error in the PEIMS check routine checking for Error 20033-0008. The EdMIS code check routines have been edited to remove object code 6491 as an invalid code. In the Report Generator there is a change to the print reports for Exhibits E1 and E2 changing the size of the headings on Exhibit E2 to match those on Exhibit E1.
 
11/05/2018 : This update corrects the code for importing the beginning fund balances from the trial balance file into the Amended Budget Data file for governmental fund types so that the amounts from the Actual account balance for all object codes beginning with a 3 are brought in rather than any amounts in the Budget Data column in the trial balance.
 
11/02/2018 : This update corrects the code for importing the budget data from trial balance to the budget files in the report generator. Amounts in the Other Uses and Sources area were not being rounded.
 
11/01/2018 : This update corrects the code for importing the data for fund 101 into the grant revenue worksheet. The routine was not properly rounding the revenue amounts.
 
10/30/2018 : This update changes the descriptions for the RSI schedules referring to the Covered Payroll when importing from the prior year RSI schedule for Pensions. This was changed with GASB 85 from Covered Employee Payroll. There is also a correction to the routine related to the On-behalf Calculation Worksheet. When the table was closed, the calculations were not being saved correctly causing a difference between what you saw on the screen and what was printed from the Worksheets menu.
 
10/23/2018 : This update corrects the footnote on the Exhibit for the District's Contributions for the TRS OPEB. There were duplicate periods at the end of the first sentence. There is a correction to the printing of Exhibit C-1 so that the control code lines up with the description a bit better. There are some description changes for some of the data files and minor changes in some Exhibit Titles made at the request of the users.
 
10/15/2018 : This update corrects the data entry screen for the reconciliation statements C-2 and C-4 so that the Font name can be edited. There is also a new file for creating these exhibits which adds the record and description for the GASB 75 implementation.
 
09/20/2018 : This update corrects the year on the name of the PDF files created in the Audit Program Generator.
 
09/17/2018 : This update revises the routine in the GASB 75 Data Entry Screen to create the adjusting entry to credit expenses and debit revenues if the district's proportionate share of the state's proportionate share of pension expense is entered as a negative number. The instructions to enter this on-behalf as a positive number even though it is a negative number this year has been removed. A document is placed in your AUDLEA18 data folder explaining GASB's Guidance on this matter. There is also a routine in the GASB 34 Exhibits under the Government Wide menu option to print the suggested note to be added to your Notes to the Financial Statements which shows the impact of this on the grants and contributions on Exhibit B-1.
 
09/09/2018 : This update revises the routine in the GASB 75 Data Entry Screen to create the adjusting entry to credit expenses and debit revenues if the district's proportionate share of the state's proportionate share of pension expense is entered as a negative number. We are still trying to confirm with TRS that this is indeed how they want this to be treated. If you ignore the negative sign when entering this amount in the data entry screen, the entry will credit revenues and debit expenses.
 
09/05/2018 : This update provides the remainder of the revised compliance program files for the audit program generator. All of the compliance programs have now been updated with the information from the April 2018 compliance supplement.
 
08/30/2018 : This update corrects the printing of the page numbers on Exhibits C2 and C4.
 
08/29/2018 : This update revises the footnote to the four-column only report for the District's Contributions to the TRS Pension (G7) changing the reference to three years of data to four years of data. The description of the Deferred Outflow Related to TRS OPEB has been revised to remove the word "Resource" on Exhibit A-1.
 
08/23/2018 : This update adds print routines for the RSI TRS schedules for the District Contributions printing four columns on one page, or for the OPEB Schedule one, two, three, or four columns according to the number of columns of data you have. There is a small change to the Pension note correcting the 2017 contribution rate. We have also added a line to the print out of the GASB 75 input screen showing the calculated amount for the district's share of the 2018 State Supplemental Appropriation. There is also a revised Example GASB 75 worksheet and a GASB 75 worksheet in Excel placed in your installation folder.

 
08/15/2018 : This update places a revised version of the OPEB note and of the sample NOTES to the Financial Statements in your Common folder for AUDIT-L.E.A. The OPEB note had to be revised as the TRS sample was not exactly correct.
 
08/13/2018 : This update replaces a crucial file in the COMMON folder for posting the GASB 75 adjustments to the fund to government wide worksheet. This will NOT change any data you have already entered into the GASB 75 Entry Screen. There are also more revised compliance programs for the Audit Program Compliance Programs including the new program for Title IV Part A added with the 2018 supplement.
 
07/20/2018 : This update corrects the printout of the GASB 68 adjustments from the GASB 68 screen so that the total in Inflows column in the first table on Deferred Resource Flows prints correctly.
 
07/18/2018 : This update corrects one of the adjusting entry calculations for the GASB 68 adjusting entries. The formula calculating the sum of the effect of the adjustment in Column 5 plus any differences between what the district reported as contributing in items B2 and B3 and the total contribution reported by TRS in Column 4. A reminder to enter the adjustment (col. 5) with the Sign but enter the contribution as a positive has been added to the screen. I also includes a revised worksheet for GASB 68 Adjustments and one for GASB 75 Adjustments which will be placed in the folder where your application is saved. For Release 22A there are four revised compliance programs - Title 1, Career and Technology, Migrant and the generic program.
 
07/11/2018 : This update corrects the reference to column numbers on the GASB 75 Entry Screen and the Report of that Data. The tables from TRS had several columns where numbers are not provided. The revised Compliance program for the School Lunch and Breakfast Cluster is also provided for Releases A and P.
 
07/04/2018 : This update adds an Auto Adjustment routine to create an adjusting entry for the trial balance file which records to fund 199 object code 6144 the district's proportionate share of the supplemental appropriation paid to the TRS OPEB plan by the State during the district's current FY. The expenditure amounts are allocated by function using the functional distribution of the 6144 amounts in the trial balance file. An entry is also made to 199 5831. There is also an additional adjustment in the GASB 75 adjustments for the government wide statements which removes these amount from 5800 and expenses as these are NOT reported in the government wide statement.

We have also added documents in the documents routine in the Report generator for the OPEB Note and for the Pension Note as separate files for your convenience. These are also still included in the example notes.

The On Behalf Allocation Worksheet no longer adds rows for removing the on-behalf payments from the grant revenue worksheet and the TRS amounts are no longer imported into this worksheet from your trial balance file. Since all of the on-behalf payments can not be reported in the government wide, rows 191 and 192 should NOT appear in the Grant Revenue worksheet.
 
06/15/2018 : This update corrects the description in the RSI schedules for TRS Pensions and OPEBs to read "Covered Payroll" rather than "Covered-Employee Payroll" as per GASB 85. The Crosscutting Section and the Title 1 compliance programs have been updated as per the April 2018 Compliance Supplement. The OPEB and Pension Notes have been updated and added to the notes to the financial statements. The RSI note example has been added to the AUDLEA Instruction Manual.
 
05/23/2018 : This update adds code to calculate the student count for the MOE Record file if that field was not included in the prior year MOE Record File. This information is imported when you import the prior year trial balance data from your data files from AUDIT-L.E.A. for 2017.
 
05/21/2018 : This update corrects the reference to the lines on the SOF for the MOE test for IDEA B. These have changed this year to lines 30, 39 and 40. There is also a correction in the password for installing updates in the About screen for Release 22A.
 
05/06/2018 : This update corrects the Make PDF file routine for Exhibit G-9 and also corrects the wording for the RSI data files for TRS Pension and OPEBs to read "District's Covered-Employee Payroll".
 
05/05/2018 : Based on some updated information from TRS the routine for the GASB75 adjusting entries has been revised. There is also a new Excel worksheet for the GASB 75 adjustments. The official information has not yet been released from TRS. When it is further revisions may be necessary.
 
05/04/2018 : This update corrects the import routine bringing the total reported under GASB 24 in the On-Behalf Allocation Worksheet into the grant revenue worksheet.
 
04/25/2018 : This update revises the descriptions on the print routine for printing the data which has been entered into the GASB 75 Data Entry Screen.
 
04/22/2018 : This update revises the GASB 75 Entry Screen and adjusting entries due to updated information from TRS. NOTE: The Final version of their worksheets are not yet available so there may be additional updates necessary.
 
Release 22B

Update Notes

01/09/2019 : This update corrects the print routine for the second page of Exhibit H2 when there are only three columns of data on the first page. The calculation of the total expenditures in the second column was doubling the amount.
 
12/13/2018 : This update corrects the print routine for the note for the Negative Program Revenue resulting from the negative on-behalf contributions related to the negative expense for the TRS OPEB plan. The print routine was cutting off the end of the first paragraph.
 
12/06/2018 : This update corrects the print routine for Exhibits C2 and C4 so that the block format for the text is correctly printed on these exhibits. Remember you should not have extra spaces at the end of your text unless you wish to add additional lines after that item.
 
12/05/2018 : This update increases the column widths for the version of the combining statement H-2 where the first page has only three columns. This has been done to accommodate larger numbers in the columns.
 
12/03/2018 : This update corrects an error which occurred when creating data files in the report generator when there are NO special revenue funds but there are internal service funds or enterprise funds.
 
11/26/2018 : This update corrects the AUDIT DATA FEED routine to correctly bring in the total of the capital projects funds in Exhibits C1 and C3 (T.E.A.'s C-2) when there are multiple major capital projects funds in the fund level statements.
 
11/11/2018 : This update adds the message "AUDIT-L.E.A. found no Errors" to print for the PEIMS check routine in Trial Balance in the event there were no errors detected from the PEIMS check routine. There is also a correction to the name of the PDF file created for Schedule L. Remember this MUST either be included with your official PDF file OR submitted separately.
 
11/08/2018 : This update corrects an error in the PEIMS check routine checking for Error 20033-0008. The EdMIS code check routines have been edited to remove object code 6491 as an invalid code. In the Report Generator there is a change to the print reports for Exhibits E1 and E2 changing the size of the headings on Exhibit E2 to match those on Exhibit E1.
 
11/05/2018 : This update corrects the code for importing the beginning fund balances from the trial balance file into the Amended Budget Data file for governmental fund types so that the amounts from the Actual account balance for all object codes beginning with a 3 are brought in rather than any amounts in the Budget Data column in the trial balance.
 
11/02/2018 : This update corrects the code for importing the budget data from trial balance to the budget files in the report generator. Amounts in the Other Uses and Sources area were not being rounded.
 
11/01/2018 : This update corrects the code for importing the data for fund 101 into the grant revenue worksheet. The routine was not properly rounding the revenue amounts.
 
10/30/2018 : This update changes the descriptions for the RSI schedules referring to the Covered Payroll when importing from the prior year RSI schedule for Pensions. This was changed with GASB 85 from Covered Employee Payroll. There is also a correction to the routine related to the On-behalf Calculation Worksheet. When the table was closed, the calculations were not being saved correctly causing a difference between what you saw on the screen and what was printed from the Worksheets menu.
 
10/23/2018 : This update corrects the footnote on the Exhibit for the District's Contributions for the TRS OPEB. There were duplicate periods at the end of the first sentence. There is a correction to the printing of Exhibit C-1 so that the control code lines up with the description a bit better. There are some description changes for some of the data files and minor changes in some Exhibit Titles made at the request of the users.
 
10/15/2018 : This update corrects the data entry screen for the reconciliation statements C-2 and C-4 so that the Font name can be edited. There is also a new file for creating these exhibits which adds the record and description for the GASB 75 implementation.
 
09/17/2018 : This update revises the routine in the GASB 75 Data Entry Screen to create the adjusting entry to credit expenses and debit revenues if the district's proportionate share of the state's proportionate share of pension expense is entered as a negative number. The instructions to enter this on-behalf as a positive number even though it is a negative number this year has been removed. A document is placed in your AUDLEA18 data folder explaining GASB's Guidance on this matter. There is also a routine in the GASB 34 Exhibits under the Government Wide menu option to print the suggested note to be added to your Notes to the Financial Statements which shows the impact of this on the grants and contributions on Exhibit B-1.
 
09/09/2018 : This update revises the routine in the GASB 75 Data Entry Screen to create the adjusting entry to credit expenses and debit revenues if the district's proportionate share of the state's proportionate share of pension expense is entered as a negative number. We are still trying to confirm with TRS that this is indeed how they want this to be treated. If you ignore the negative sign when entering this amount in the data entry screen, the entry will credit revenues and debit expenses.
 
08/30/2018 : This update corrects the printing of the page numbers on Exhibits C2 and C4.
 
08/29/2018 : This update revises the footnote to the four-column only report for the District's Contributions to the TRS Pension (G7) changing the reference to three years of data to four years of data. The description of the Deferred Outflow Related to TRS OPEB has been revised to remove the word "Resource" on Exhibit A-1.
 
08/23/2018 : This update adds print routines for the RSI TRS schedules for the District Contributions printing four columns on one page, or for the OPEB Schedule one, two, three, or four columns according to the number of columns of data you have. There is a small change to the Pension note correcting the 2017 contribution rate. We have also added a line to the print out of the GASB 75 input screen showing the calculated amount for the district's share of the 2018 State Supplemental Appropriation. There is also a revised Example GASB 75 worksheet and a GASB 75 worksheet in Excel placed in your installation folder.

 
08/15/2018 : This update places a revised version of the OPEB note and of the sample NOTES to the Financial Statements in your Common folder for AUDIT-L.E.A. The OPEB note had to be revised as the TRS sample was not exactly correct.
 
08/13/2018 : This update replaces a crucial file in the COMMON folder for posting the GASB 75 adjustments to the fund to government wide worksheet. This will NOT change any data you have already entered into the GASB 75 Entry Screen. There are also more revised compliance programs for the Audit Program Compliance Programs including the new program for Title IV Part A added with the 2018 supplement.
 
07/20/2018 : This update corrects the printout of the GASB 68 adjustments from the GASB 68 screen so that the total in Inflows column in the first table on Deferred Resource Flows prints correctly.
 
07/18/2018 : This update corrects one of the adjusting entry calculations for the GASB 68 adjusting entries. The formula calculating the sum of the effect of the adjustment in Column 5 plus any differences between what the district reported as contributing in items B2 and B3 and the total contribution reported by TRS in Column 4. A reminder to enter the adjustment (col. 5) with the Sign but enter the contribution as a positive has been added to the screen. I also includes a revised worksheet for GASB 68 Adjustments and one for GASB 75 Adjustments which will be placed in the folder where your application is saved. For Release 22A there are four revised compliance programs - Title 1, Career and Technology, Migrant and the generic program.
 
07/11/2018 : This update corrects the reference to column numbers on the GASB 75 Entry Screen and the Report of that Data. The tables from TRS had several columns where numbers are not provided. The revised Compliance program for the School Lunch and Breakfast Cluster is also provided for Releases A and P.
 
07/04/2018 : This update adds an Auto Adjustment routine to create an adjusting entry for the trial balance file which records to fund 199 object code 6144 the district's proportionate share of the supplemental appropriation paid to the TRS OPEB plan by the State during the district's current FY. The expenditure amounts are allocated by function using the functional distribution of the 6144 amounts in the trial balance file. An entry is also made to 199 5831. There is also an additional adjustment in the GASB 75 adjustments for the government wide statements which removes these amount from 5800 and expenses as these are NOT reported in the government wide statement.

We have also added documents in the documents routine in the Report generator for the OPEB Note and for the Pension Note as separate files for your convenience. These are also still included in the example notes.

The On Behalf Allocation Worksheet no longer adds rows for removing the on-behalf payments from the grant revenue worksheet and the TRS amounts are no longer imported into this worksheet from your trial balance file. Since all of the on-behalf payments can not be reported in the government wide, rows 191 and 192 should NOT appear in the Grant Revenue worksheet.
 
06/15/2018 : This update corrects the description in the RSI schedules for TRS Pensions and OPEBs to read "Covered Payroll" rather than "Covered-Employee Payroll" as per GASB 85. The Crosscutting Section and the Title 1 compliance programs have been updated as per the April 2018 Compliance Supplement. The OPEB and Pension Notes have been updated and added to the notes to the financial statements. The RSI note example has been added to the AUDLEA Instruction Manual.
 
05/23/2018 : This update adds code to calculate the student count for the MOE Record file if that field was not included in the prior year MOE Record File. This information is imported when you import the prior year trial balance data from your data files from AUDIT-L.E.A. for 2017.
 
05/21/2018 : This update corrects the reference to the lines on the SOF for the MOE test for IDEA B. These have changed this year to lines 30, 39 and 40. There is also a correction in the password for installing updates in the About screen for Release 22A.
 
05/06/2018 : This update corrects the Make PDF file routine for Exhibit G-9 and also corrects the wording for the RSI data files for TRS Pension and OPEBs to read "District's Covered-Employee Payroll".
 
05/05/2018 : Based on some updated information from TRS the routine for the GASB75 adjusting entries has been revised. There is also a new Excel worksheet for the GASB 75 adjustments. The official information has not yet been released from TRS. When it is further revisions may be necessary.
 
05/04/2018 : This update corrects the import routine bringing the total reported under GASB 24 in the On-Behalf Allocation Worksheet into the grant revenue worksheet.
 
04/25/2018 : This update revises the descriptions on the print routine for printing the data which has been entered into the GASB 75 Data Entry Screen.
 
04/22/2018 : This update revises the GASB 75 Entry Screen and adjusting entries due to updated information from TRS. NOTE: The Final version of their worksheets are not yet available so there may be additional updates necessary.
 
Release 22P

Update Notes

09/20/2018 : This update corrects the year on the name of the PDF files created in the Audit Program Generator.
 
09/05/2018 : This update provides the remainder of the revised compliance program files for the audit program generator. All of the compliance programs have now been updated with the information from the April 2018 compliance supplement.
 
08/23/2018 : There is a revised Excel example GASB 75 worksheet and a revised Excel GASB 75 worksheet placed in the installation folder.
 
08/13/2018 : This update replaces a crucial file in the COMMON folder for posting the GASB 75 adjustments to the fund to government wide worksheet. This will NOT change any data you have already entered into the GASB 75 Entry Screen. There are also more revised compliance programs for the Audit Program Compliance Programs including the new program for Title IV Part A added with the 2018 supplement.
 
07/18/2018 : This update includes the revisions using the April 2018 compliance supplement and the April 2017 supplement for Title 1, Career and Technology, Migrant, and the Generic Compliance Programs. There is also a revised worksheet for GASB 68 Adjustments and one for GASB 75 Adjustments which will be placed in the folder where your application is saved.
 
07/11/2018 : This update corrects the reference to column numbers on the GASB 75 Entry Screen and the Report of that Data. The tables from TRS had several columns where numbers are not provided. The revised Compliance program for the School Lunch and Breakfast Cluster is also provided for Releases A and P.
 
06/15/2018 : This update corrects the description in the RSI schedules for TRS Pensions and OPEBs to read "Covered Payroll" rather than "Covered-Employee Payroll" as per GASB 85. The Crosscutting Section and the Title 1 compliance programs have been updated as per the April 2018 Compliance Supplement. The OPEB and Pension Notes have been updated and added to the notes to the financial statements. The RSI note example has been added to the AUDLEA Instruction Manual.
 
Release 22R

Update Notes

01/09/2019 : This update corrects the print routine for the second page of Exhibit H2 when there are only three columns of data on the first page. The calculation of the total expenditures in the second column was doubling the amount.
 
12/13/2018 : This update corrects the print routine for the note for the Negative Program Revenue resulting from the negative on-behalf contributions related to the negative expense for the TRS OPEB plan. The print routine was cutting off the end of the first paragraph.
 
12/06/2018 : This update corrects the print routine for Exhibits C2 and C4 so that the block format for the text is correctly printed on these exhibits. Remember you should not have extra spaces at the end of your text unless you wish to add additional lines after that item.
 
12/05/2018 : This update increases the column widths for the version of the combining statement H-2 where the first page has only three columns. This has been done to accommodate larger numbers in the columns.
 
12/03/2018 : This update corrects an error which occurred when creating data files in the report generator when there are NO special revenue funds but there are internal service funds or enterprise funds.
 
11/26/2018 : This update corrects the AUDIT DATA FEED routine to correctly bring in the total of the capital projects funds in Exhibits C1 and C3 (T.E.A.'s C-2) when there are multiple major capital projects funds in the fund level statements.
 
11/11/2018 : This update adds the message "AUDIT-L.E.A. found no Errors" to print for the PEIMS check routine in Trial Balance in the event there were no errors detected from the PEIMS check routine. There is also a correction to the name of the PDF file created for Schedule L. Remember this MUST either be included with your official PDF file OR submitted separately.
 
11/08/2018 : This update corrects an error in the PEIMS check routine checking for Error 20033-0008. The EdMIS code check routines have been edited to remove object code 6491 as an invalid code. In the Report Generator there is a change to the print reports for Exhibits E1 and E2 changing the size of the headings on Exhibit E2 to match those on Exhibit E1.
 
10/30/2018 : This update changes the descriptions for the RSI schedules referring to the Covered Payroll when importing from the prior year RSI schedule for Pensions. This was changed with GASB 85 from Covered Employee Payroll. There is also a correction to the routine related to the On-behalf Calculation Worksheet. When the table was closed, the calculations were not being saved correctly causing a difference between what you saw on the screen and what was printed from the Worksheets menu.
 
10/23/2018 : This update corrects the footnote on the Exhibit for the District's Contributions for the TRS OPEB. There were duplicate periods at the end of the first sentence. There is a correction to the printing of Exhibit C-1 so that the control code lines up with the description a bit better. There are some description changes for some of the data files and minor changes in some Exhibit Titles made at the request of the users.
 
10/15/2018 : This update corrects the data entry screen for the reconciliation statements C-2 and C-4 so that the Font name can be edited. There is also a new file for creating these exhibits which adds the record and description for the GASB 75 implementation.
 
09/17/2018 : This update revises the routine in the GASB 75 Data Entry Screen to create the adjusting entry to credit expenses and debit revenues if the district's proportionate share of the state's proportionate share of pension expense is entered as a negative number. The instructions to enter this on-behalf as a positive number even though it is a negative number this year has been removed. A document is placed in your AUDLEA18 data folder explaining GASB's Guidance on this matter. There is also a routine in the GASB 34 Exhibits under the Government Wide menu option to print the suggested note to be added to your Notes to the Financial Statements which shows the impact of this on the grants and contributions on Exhibit B-1.
 
09/09/2018 : This update revises the routine in the GASB 75 Data Entry Screen to create the adjusting entry to credit expenses and debit revenues if the district's proportionate share of the state's proportionate share of pension expense is entered as a negative number. We are still trying to confirm with TRS that this is indeed how they want this to be treated. If you ignore the negative sign when entering this amount in the data entry screen, the entry will credit revenues and debit expenses.
 
08/30/2018 : This update corrects the printing of the page numbers on Exhibits C2 and C4.
 
08/29/2018 : This update revises the footnote to the four-column only report for the District's Contributions to the TRS Pension (G7) changing the reference to three years of data to four years of data. The description of the Deferred Outflow Related to TRS OPEB has been revised to remove the word "Resource" on Exhibit A-1.
 
08/23/2018 : This update adds print routines for the RSI TRS schedules for the District Contributions printing four columns on one page, or for the OPEB Schedule one, two, three, or four columns according to the number of columns of data you have. There is a small change to the Pension note correcting the 2017 contribution rate. We have also added a line to the print out of the GASB 75 input screen showing the calculated amount for the district's share of the 2018 State Supplemental Appropriation. There is also a revised Example GASB 75 worksheet and a GASB 75 worksheet in Excel placed in your installation folder.

 
08/15/2018 : This update places a revised version of the OPEB note and of the sample NOTES to the Financial Statements in your Common folder for AUDIT-L.E.A. The OPEB note had to be revised as the TRS sample was not exactly correct.
 
08/13/2018 : This update replaces a crucial file in the COMMON folder for posting the GASB 75 adjustments to the fund to government wide worksheet. This will NOT change any data you have already entered into the GASB 75 Entry Screen. There are also more revised compliance programs for the Audit Program Compliance Programs including the new program for Title IV Part A added with the 2018 supplement.
 
07/20/2018 : This update corrects the printout of the GASB 68 adjustments from the GASB 68 screen so that the total in Inflows column in the first table on Deferred Resource Flows prints correctly.
 
07/18/2018 : This update corrects one of the adjusting entry calculations for the GASB 68 adjusting entries. The formula calculating the sum of the effect of the adjustment in Column 5 plus any differences between what the district reported as contributing in items B2 and B3 and the total contribution reported by TRS in Column 4. A reminder to enter the adjustment (col. 5) with the Sign but enter the contribution as a positive has been added to the screen. I also includes a revised worksheet for GASB 68 Adjustments and one for GASB 75 Adjustments which will be placed in the folder where your application is saved. For Release 22A there are four revised compliance programs - Title 1, Career and Technology, Migrant and the generic program.
 
07/11/2018 : This update corrects the reference to column numbers on the GASB 75 Entry Screen and the Report of that Data. The tables from TRS had several columns where numbers are not provided. The revised Compliance program for the School Lunch and Breakfast Cluster is also provided for Releases A and P.
 
07/04/2018 : This update adds an Auto Adjustment routine to create an adjusting entry for the trial balance file which records to fund 199 object code 6144 the district's proportionate share of the supplemental appropriation paid to the TRS OPEB plan by the State during the district's current FY. The expenditure amounts are allocated by function using the functional distribution of the 6144 amounts in the trial balance file. An entry is also made to 199 5831. There is also an additional adjustment in the GASB 75 adjustments for the government wide statements which removes these amount from 5800 and expenses as these are NOT reported in the government wide statement.

We have also added documents in the documents routine in the Report generator for the OPEB Note and for the Pension Note as separate files for your convenience. These are also still included in the example notes.

The On Behalf Allocation Worksheet no longer adds rows for removing the on-behalf payments from the grant revenue worksheet and the TRS amounts are no longer imported into this worksheet from your trial balance file. Since all of the on-behalf payments can not be reported in the government wide, rows 191 and 192 should NOT appear in the Grant Revenue worksheet.
 
06/15/2018 : This update corrects the description in the RSI schedules for TRS Pensions and OPEBs to read "Covered Payroll" rather than "Covered-Employee Payroll" as per GASB 85. The Crosscutting Section and the Title 1 compliance programs have been updated as per the April 2018 Compliance Supplement. The OPEB and Pension Notes have been updated and added to the notes to the financial statements. The RSI note example has been added to the AUDLEA Instruction Manual.
 
05/06/2018 : This update corrects the Make PDF file routine for Exhibit G-9 and also corrects the wording for the RSI data files for TRS Pension and OPEBs to read "District's Covered-Employee Payroll".
 
05/05/2018 : Based on some updated information from TRS the routine for the GASB75 adjusting entries has been revised. There is also a new Excel worksheet for the GASB 75 adjustments. The official information has not yet been released from TRS. When it is further revisions may be necessary.
 
05/04/2018 : This update corrects the import routine bringing the total reported under GASB 24 in the On-Behalf Allocation Worksheet into the grant revenue worksheet.
 
Release 22S

Update Notes

11/11/2018 : This update adds the message "AUDIT-L.E.A. found no Errors" to print for the PEIMS check routine in Trial Balance in the event there were no errors detected from the PEIMS check routine. There is also a correction to the name of the PDF file created for Schedule L. Remember this MUST either be included with your official PDF file OR submitted separately.
 
11/08/2018 : This update corrects an error in the PEIMS check routine checking for Error 20033-0008. The EdMIS code check routines have been edited to remove object code 6491 as an invalid code. In the Report Generator there is a change to the print reports for Exhibits E1 and E2 changing the size of the headings on Exhibit E2 to match those on Exhibit E1.
 
08/23/2018 : There is a revised Excel example GASB 75 worksheet and a revised Excel GASB 75 worksheet placed in the installation folder.
 
07/18/2018 : This update includes a revised worksheet for GASB 68 Adjustments and one for GASB 75 Adjustments which will be placed in the folder where your application is saved.
 
07/11/2018 : This update corrects the reference to column numbers on the GASB 75 Entry Screen and the Report of that Data. The tables from TRS had several columns where numbers are not provided. The revised Compliance program for the School Lunch and Breakfast Cluster is also provided for Releases A and P.
 
07/04/2018 : This update adds an Auto Adjustment routine to create an adjusting entry for the trial balance file which records to fund 199 object code 6144 the district's proportionate share of the supplemental appropriation paid to the TRS OPEB plan by the State during the district's current FY. The expenditure amounts are allocated by function using the functional distribution of the 6144 amounts in the trial balance file. An entry is also made to 199 5831. There is also an additional adjustment in the GASB 75 adjustments for the government wide statements which removes these amount from 5800 and expenses as these are NOT reported in the government wide statement.

We have also added documents in the documents routine in the Report generator for the OPEB Note and for the Pension Note as separate files for your convenience. These are also still included in the example notes.

The On Behalf Allocation Worksheet no longer adds rows for removing the on-behalf payments from the grant revenue worksheet and the TRS amounts are no longer imported into this worksheet from your trial balance file. Since all of the on-behalf payments can not be reported in the government wide, rows 191 and 192 should NOT appear in the Grant Revenue worksheet.
 
06/15/2018 : This update corrects the description in the RSI schedules for TRS Pensions and OPEBs to read "Covered Payroll" rather than "Covered-Employee Payroll" as per GASB 85. The Crosscutting Section and the Title 1 compliance programs have been updated as per the April 2018 Compliance Supplement. The OPEB and Pension Notes have been updated and added to the notes to the financial statements. The RSI note example has been added to the AUDLEA Instruction Manual.
 
05/23/2018 : This update adds code to calculate the student count for the MOE Record file if that field was not included in the prior year MOE Record File. This information is imported when you import the prior year trial balance data from your data files from AUDIT-L.E.A. for 2017.
 
05/21/2018 : This update corrects the reference to the lines on the SOF for the MOE test for IDEA B. These have changed this year to lines 30, 39 and 40. There is also a correction in the password for installing updates in the About screen for Release 22A.