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 27

Release 27A

Update Notes

02/05/2024 : This update corrects the MOE test for IDEA B for function 71. We failed to restrict the specific object codes for function 71 to fund 199 only. This only applies to expenditures in other funds for the right-to-leases and SBITAs.
 
01/12/2024 : This update edits the print routine for Exhibit A-1 allowing more lines to print on the page for the form with only governmental activities.
 
01/06/2024 : This update edits the titles for Exhibit J1, G3 and G5 to read FOR THE YEAR ENDED AUGUST 31, 2023 rather than FOR THE YEAR 2023. This change is made to be consistent with other exhibit titles. If you want to change these in existing reports, select the HEADING option in the Report Data when printing or previewing any Exhibit and select the option to change the fiscal year. Re-enter the correct fiscal year information and be sure to click on the green arrow in the navigator bar. The titles will be changed when you close the Headings screen.
 
01/04/2024 : This update makes another correction to the print routine for Exhibit B-1 which occurred on the second page when the district has a capital grant and no enterprise funds and no component units.
 
01/03/2024 : This update corrects an error when importing the beginning of the year balances in the fund to government wide worksheet. If the user chooses the option to import assets and debt beginning balances only, the software was incorrectly importing a beginning balance for GASB 75 - control code 2605. This does not occur in the routine to import all adjusting entries from the prior year into the fund to government wide worksheet.
 
01/02/2024 : This update corrects an error printing the second page of Exhibit B-1 when the district has a capital grant and no enterprise fund and no component unit.
 
12/27/2023 : This update corrects an error printing the second page of Exhibit B-1 when the district has capital grants and no enterprise fund but does have a component unit.
 
12/13/2023 : This makes a correction to the Audit Data Feed. The error occurred if there were amounts in an enterprise fund for long-term debt 2502. An amount was entered in the data feed file for 2516. We have also added a routine to enter a zero on SF9 for L-1 in the event that box is left empty. This is now required by TEA.
 
12/11/2023 : We have been advised by TEA that amounts reported in 2130 or 2131 on Exhibit A-1 should be rolled into 2501 and amounts in 2131 in Exhibit C-1 should be rolled into 2130 for the Audit Data Feed. This update makes those changes. We have also corrected the default date for Exhibit C-3 to place a space between the month and the day for the fiscal year.
 
11/30/2023 : This update corrects an error printing Exhibit C-3 which happens when the only major fund is the general fund and there are NO non-major governmental funds. If you do not have this circumstance, you do not need to install this update. This update includes the changes made in the previous updates including the update of 11/29. The 11/29/23 update is very important. If you did not install that update, please install this latest update so that your exhibit C-3 will print correctly in the event you have only one major fund - the General Fund - but you DO have non-major governmental funds.
 
11/29/2023 : This update corrects an error printing Exhibit C-3 which happens when the only major fund is the general fund but there are other non-major governmental funds. This is an error created when we revised the software earlier to accommodate a special circumstance where there was only a general fund and no other governmental funds.
 
11/28/2023 : This update corrects the PEIMS check routine in the Trial Balance program for change TEA made to 20032-0153 error check to allow object codes 6514 and 6526 to also be reported with function 71 in special revenue funds. Please be sure function 71 is not included for funds 269, 278, 279, 280, 284, 285 or 345 as per check 20032-0150.
 
11/22/2023 : This update corrects the routine to print Exhibit C-3 which occurs when the only fund is the general fund.
 
11/15/2023 : This update corrects the name for the PDF file as required by TEA. We have also added the Exhibit Number L-1 to the Schools First Questionnaire.
 
11/10/2023 : This update adds the routine in the Report Generator to produce the Note explaining how the negative on-behalf amounts in the TRS-Care plan affects the measurement of the grants and contributions by function in Exhibit B-1. It is not required by TEA. It provides information you may wish to include in the notes to the financial statements.
 
11/02/2023 : This update corrects an error in printing or previewing Exhibit C-3 when there are no non-major governmental funds.
 
11/02/2023 : This update corrects the calculation routines for the tax schedule which now does not include the amounts placed on row 9001 in the calculation of the totals on row 2XXX.
 
10/27/2023 : This update corrects an error in the PEIMS check routine when checking the rules requiring the ADA. There is also a correction in the Report Generator allowing the total debt service column or total capital projects column to be included in the combining statements when there are both major and nonmajor funds. If you are having that problem with the combining statements, you should go to the Report Generator and select the Data Files option and then select the option to create or recreate data files and from the list select the Recreate the Report Information File ONLY. Do this after installing this update. We have also added the Fresh Fruit and Vegetable Program (10.582) to the Child Nutrition Cluster in the SEFA data file.
 
10/08/2023 : This update revises the tax schedule to only show the amount for the new requirement for the refunds in the M&O column. If you have no refunds to report, enter a .02 in that cell on row 9001. Add this if you do not have it with the description - Taxes Refunded Under 26.1115, Tax Code. The amount will print as 0.00.
 
09/19/2023 : This update adds the new row on the tax schedule for the amount refunded under Section 26.1115 of the Tax Code. This row is also added to the Audit Data Feed. If you have already created the data file for the tax schedule, you can add a row to that schedule using the control code 9001. The amount should be entered in only column 31 and it should be entered as a positive number.

There is also a correction to the second page of the RSI Schedule for the OPEB Liability. The date in the first column on the second page is now correct.
 
09/13/2023 : There are three issues corrected in this update. First, the Exhibit file in the common folder incorrectly had the FY 2022. This has been corrected. If you have already created your data files in the Report Generator, you will need to correct this by selecting HEADINGS in the Report Data Screen when printing or previewing and clicking the option to Change the Fiscal Year. An error calculating the liabilities when importing data into the custodial fund was corrected. The print routine for the tax schedule has been correct so that footnote now prints on the Tax Schedule.
 
09/11/2023 : This update includes a critical correction to the MOE tests for IDEA-B. Our code calculating the deficiency for the per capita items was not working correctly. We have now corrected that error. There is also a small change in the data file and query for custodial funds as reported in the E Exhibits.
 
08/09/2023 : This update includes a correction to the title of the Lead Sheet by Objects report. This update also includes the remainder of the compliance programs for the Audit Program Generator and the revised notes for GASB 68 and GASB 75.
 
08/02/2023 : This update includes the revised notes, pension note, RSI note, etc. in the Report Generator. Several updates to the compliance programs are included in the Audit Program Generator.
 
07/13/2023 : This update includes a revised User Manual for AUDIT-L.E.A. with some corrections to the Example Financial Report. We have also included the revised compliance programs for the Generic, Cross-cutting, Title 1, IDEA Cluster, and the ESSER funds for the Audit Program Generator. The RSI note for the Pensions and OPEB tables is also updated for the 2023 reporting period.
 
05/15/2023 : This update contains a critical update to the AUDIT DATA FEED routine in the Report Generator. We have been advised by TEA of a significant change in the data required to be entered for Exhibits C1 and C2 (our C3). TEA is now requiring that the totals for the Non-Major Governmental funds be included as well as a column for the sum of all Major funds other than GF, CP, DS and Food Service (240).
 
04/01/2023 : The example adjusting entries in the AUDIT-L.E.A. Manual failed to include the depreciation for the Right-to-Use lease assets. These are now included in Entry # 13. This update includes the revised User Manual.
 
03/31/2023 : The example worksheets for the allocation of the profit(loss) of internal service funds by function for the fund to government wide adjustment were accidentally left out of the example worksheets in the AUDIT-L.E.A. manual. This update provides a corrected version of the manual.
 
03/27/2023 : We have been advised by TEA that the Other Resource code to be used for the Proceeds of the SBITA arrangement should be 7949. They did not assign a specific code for this but they DO want it to be separate from the 7913 for the Right-to-Use lease proceeds. This update changes that description in the data file for creating Exhibit C-3 and the changes have been made in the Example Statements in the Manual.
 
Release 27B

Update Notes

02/05/2024 : This update corrects the MOE test for IDEA B for function 71. We failed to restrict the specific object codes for function 71 to fund 199 only. This only applies to expenditures in other funds for the right-to-leases and SBITAs.
 
01/12/2024 : This update edits the print routine for Exhibit A-1 allowing more lines to print on the page for the form with only governmental activities.
 
01/06/2024 : This update edits the titles for Exhibit J1, G3 and G5 to read FOR THE YEAR ENDED AUGUST 31, 2023 rather than FOR THE YEAR 2023. This change is made to be consistent with other exhibit titles. If you want to change these in existing reports, select the HEADING option in the Report Data when printing or previewing any Exhibit and select the option to change the fiscal year. Re-enter the correct fiscal year information and be sure to click on the green arrow in the navigator bar. The titles will be changed when you close the Headings screen.
 
01/04/2024 : This update makes another correction to the print routine for Exhibit B-1 which occurred on the second page when the district has a capital grant and no enterprise funds and no component units.
 
01/03/2024 : This update corrects an error when importing the beginning of the year balances in the fund to government wide worksheet. If the user chooses the option to import assets and debt beginning balances only, the software was incorrectly importing a beginning balance for GASB 75 - control code 2605. This does not occur in the routine to import all adjusting entries from the prior year into the fund to government wide worksheet.
 
01/02/2024 : This update corrects an error printing the second page of Exhibit B-1 when the district has a capital grant and no enterprise fund and no component unit.
 
12/27/2023 : This update corrects an error printing the second page of Exhibit B-1 when the district has capital grants and no enterprise fund but does have a component unit.
 
12/13/2023 : This makes a correction to the Audit Data Feed. The error occurred if there were amounts in an enterprise fund for long-term debt 2502. An amount was entered in the data feed file for 2516. We have also added a routine to enter a zero on SF9 for L-1 in the event that box is left empty. This is now required by TEA.
 
12/11/2023 : We have been advised by TEA that amounts reported in 2130 or 2131 on Exhibit A-1 should be rolled into 2501 and amounts in 2131 in Exhibit C-1 should be rolled into 2130 for the Audit Data Feed. This update makes those changes. We have also corrected the default date for Exhibit C-3 to place a space between the month and the day for the fiscal year.
 
11/30/2023 : This update corrects an error printing Exhibit C-3 which happens when the only major fund is the general fund and there are NO non-major governmental funds. If you do not have this circumstance, you do not need to install this update. This update includes the changes made in the previous updates including the update of 11/29. The 11/29/23 update is very important. If you did not install that update, please install this latest update so that your exhibit C-3 will print correctly in the event you have only one major fund - the General Fund - but you DO have non-major governmental funds.
 
11/29/2023 : This update corrects an error printing Exhibit C-3 which happens when the only major fund is the general fund but there are other non-major governmental funds. This is an error created when we revised the software earlier to accommodate a special circumstance where there was only a general fund and no other governmental funds.
 
11/28/2023 : This update corrects the PEIMS check routine in the Trial Balance program for change TEA made to 20032-0153 error check to allow object codes 6514 and 6526 to also be reported with function 71 in special revenue funds. Please be sure function 71 is not included for funds 269, 278, 279, 280, 284, 285 or 345 as per check 20032-0150.
 
11/22/2023 : This update corrects the routine to print Exhibit C-3 which occurs when the only fund is the general fund.
 
11/15/2023 : This update corrects the name for the PDF file as required by TEA. We have also added the Exhibit Number L-1 to the Schools First Questionnaire.
 
11/10/2023 : This update adds the routine in the Report Generator to produce the Note explaining how the negative on-behalf amounts in the TRS-Care plan affects the measurement of the grants and contributions by function in Exhibit B-1. It is not required by TEA. It provides information you may wish to include in the notes to the financial statements.
 
11/02/2023 : This update corrects an error in printing or previewing Exhibit C-3 when there are no non-major governmental funds.
 
11/02/2023 : This update corrects the calculation routines for the tax schedule which now does not include the amounts placed on row 9001 in the calculation of the totals on row 2XXX.
 
10/27/2023 : This update corrects an error in the PEIMS check routine when checking the rules requiring the ADA. There is also a correction in the Report Generator allowing the total debt service column or total capital projects column to be included in the combining statements when there are both major and nonmajor funds. If you are having that problem with the combining statements, you should go to the Report Generator and select the Data Files option and then select the option to create or recreate data files and from the list select the Recreate the Report Information File ONLY. Do this after installing this update. We have also added the Fresh Fruit and Vegetable Program (10.582) to the Child Nutrition Cluster in the SEFA data file.
 
10/08/2023 : This update revises the tax schedule to only show the amount for the new requirement for the refunds in the M&O column. If you have no refunds to report, enter a .02 in that cell on row 9001. Add this if you do not have it with the description - Taxes Refunded Under 26.1115, Tax Code. The amount will print as 0.00.
 
09/19/2023 : This update adds the new row on the tax schedule for the amount refunded under Section 26.1115 of the Tax Code. This row is also added to the Audit Data Feed. If you have already created the data file for the tax schedule, you can add a row to that schedule using the control code 9001. The amount should be entered in only column 31 and it should be entered as a positive number.

There is also a correction to the second page of the RSI Schedule for the OPEB Liability. The date in the first column on the second page is now correct.
 
09/13/2023 : There are three issues corrected in this update. First, the Exhibit file in the common folder incorrectly had the FY 2022. This has been corrected. If you have already created your data files in the Report Generator, you will need to correct this by selecting HEADINGS in the Report Data Screen when printing or previewing and clicking the option to Change the Fiscal Year. An error calculating the liabilities when importing data into the custodial fund was corrected. The print routine for the tax schedule has been correct so that footnote now prints on the Tax Schedule.
 
09/11/2023 : This update includes a critical correction to the MOE tests for IDEA-B. Our code calculating the deficiency for the per capita items was not working correctly. We have now corrected that error. There is also a small change in the data file and query for custodial funds as reported in the E Exhibits.
 
08/09/2023 : This update includes a correction to the title of the Lead Sheet by Objects report. This update also includes the remainder of the compliance programs for the Audit Program Generator and the revised notes for GASB 68 and GASB 75.
 
08/02/2023 : This update includes the revised notes, pension note, RSI note, etc. in the Report Generator. Several updates to the compliance programs are included in the Audit Program Generator.
 
07/13/2023 : This update includes a revised User Manual for AUDIT-L.E.A. with some corrections to the Example Financial Report. We have also included the revised compliance programs for the Generic, Cross-cutting, Title 1, IDEA Cluster, and the ESSER funds for the Audit Program Generator. The RSI note for the Pensions and OPEB tables is also updated for the 2023 reporting period.
 
05/15/2023 : This update contains a critical update to the AUDIT DATA FEED routine in the Report Generator. We have been advised by TEA of a significant change in the data required to be entered for Exhibits C1 and C2 (our C3). TEA is now requiring that the totals for the Non-Major Governmental funds be included as well as a column for the sum of all Major funds other than GF, CP, DS and Food Service (240).
 
04/01/2023 : The example adjusting entries in the AUDIT-L.E.A. Manual failed to include the depreciation for the Right-to-Use lease assets. These are now included in Entry # 13. This update includes the revised User Manual.
 
03/31/2023 : The example worksheets for the allocation of the profit(loss) of internal service funds by function for the fund to government wide adjustment were accidentally left out of the example worksheets in the AUDIT-L.E.A. manual. This update provides a corrected version of the manual.
 
03/27/2023 : We have been advised by TEA that the Other Resource code to be used for the Proceeds of the SBITA arrangement should be 7949. They did not assign a specific code for this but they DO want it to be separate from the 7913 for the Right-to-Use lease proceeds. This update changes that description in the data file for creating Exhibit C-3 and the changes have been made in the Example Statements in the Manual.
 
Release 27P

Update Notes

08/09/2023 : This update includes a correction to the title of the Lead Sheet by Objects report. This update also includes the remainder of the compliance programs for the Audit Program Generator and the revised notes for GASB 68 and GASB 75.
 
08/02/2023 : This update includes the revised notes, pension note, RSI note, etc. in the Report Generator. Several updates to the compliance programs are included in the Audit Program Generator.
 
07/13/2023 : This update includes a revised User Manual for AUDIT-L.E.A. with some corrections to the Example Financial Report. We have also included the revised compliance programs for the Generic, Cross-cutting, Title 1, IDEA Cluster, and the ESSER funds for the Audit Program Generator. The RSI note for the Pensions and OPEB tables is also updated for the 2023 reporting period.
 
05/16/2023 : 4/1/2023 - The example adjusting entries failed to include the depreciation for the Right-to-Use lease assets. These are now included in Entry # 13. This update includes the revised User Manual.
 
Release 27R

Update Notes

01/12/2024 : This update edits the print routine for Exhibit A-1 allowing more lines to print on the page for the form with only governmental activities.
 
01/06/2024 : This update edits the titles for Exhibit J1, G3 and G5 to read FOR THE YEAR ENDED AUGUST 31, 2023 rather than FOR THE YEAR 2023. This change is made to be consistent with other exhibit titles. If you want to change these in existing reports, select the HEADING option in the Report Data when printing or previewing any Exhibit and select the option to change the fiscal year. Re-enter the correct fiscal year information and be sure to click on the green arrow in the navigator bar. The titles will be changed when you close the Headings screen.
 
01/04/2024 : This update makes another correction to the print routine for Exhibit B-1 which occurred on the second page when the district has a capital grant and no enterprise funds and no component units.
 
01/03/2024 : This update corrects an error when importing the beginning of the year balances in the fund to government wide worksheet. If the user chooses the option to import assets and debt beginning balances only, the software was incorrectly importing a beginning balance for GASB 75 - control code 2605. This does not occur in the routine to import all adjusting entries from the prior year into the fund to government wide worksheet.
 
01/02/2024 : This update corrects an error printing the second page of Exhibit B-1 when the district has a capital grant and no enterprise fund and no component unit.
 
12/27/2023 : This update corrects an error printing the second page of Exhibit B-1 when the district has capital grants and no enterprise fund but does have a component unit.
 
12/13/2023 : This makes a correction to the Audit Data Feed. The error occurred if there were amounts in an enterprise fund for long-term debt 2502. An amount was entered in the data feed file for 2516. We have also added a routine to enter a zero on SF9 for L-1 in the event that box is left empty. This is now required by TEA.
 
12/11/2023 : We have been advised by TEA that amounts reported in 2130 or 2131 on Exhibit A-1 should be rolled into 2501 and amounts in 2131 in Exhibit C-1 should be rolled into 2130 for the Audit Data Feed. This update makes those changes. We have also corrected the default date for Exhibit C-3 to place a space between the month and the day for the fiscal year.
 
11/30/2023 : This update corrects an error printing Exhibit C-3 which happens when the only major fund is the general fund and there are NO non-major governmental funds. If you do not have this circumstance, you do not need to install this update. This update includes the changes made in the previous updates including the update of 11/29. The 11/29/23 update is very important. If you did not install that update, please install this latest update so that your exhibit C-3 will print correctly in the event you have only one major fund - the General Fund - but you DO have non-major governmental funds.
 
11/29/2023 : This update corrects an error printing Exhibit C-3 which happens when the only major fund is the general fund but there are other non-major governmental funds. This is an error created when we revised the software earlier to accommodate a special circumstance where there was only a general fund and no other governmental funds.
 
11/22/2023 : This update corrects the routine to print Exhibit C-3 which occurs when the only fund is the general fund.
 
11/15/2023 : This update corrects the name for the PDF file as required by TEA. We have also added the Exhibit Number L-1 to the Schools First Questionnaire.
 
11/10/2023 : This update adds the routine in the Report Generator to produce the Note explaining how the negative on-behalf amounts in the TRS-Care plan affects the measurement of the grants and contributions by function in Exhibit B-1. It is not required by TEA. It provides information you may wish to include in the notes to the financial statements.
 
11/02/2023 : This update corrects an error in printing or previewing Exhibit C-3 when there are no non-major governmental funds.
 
11/02/2023 : This update corrects the calculation routines for the tax schedule which now does not include the amounts placed on row 9001 in the calculation of the totals on row 2XXX.
 
10/27/2023 : This update corrects an error in the PEIMS check routine when checking the rules requiring the ADA. There is also a correction in the Report Generator allowing the total debt service column or total capital projects column to be included in the combining statements when there are both major and nonmajor funds. If you are having that problem with the combining statements, you should go to the Report Generator and select the Data Files option and then select the option to create or recreate data files and from the list select the Recreate the Report Information File ONLY. Do this after installing this update. We have also added the Fresh Fruit and Vegetable Program (10.582) to the Child Nutrition Cluster in the SEFA data file.
 
10/08/2023 : This update revises the tax schedule to only show the amount for the new requirement for the refunds in the M&O column. If you have no refunds to report, enter a .02 in that cell on row 9001. Add this if you do not have it with the description - Taxes Refunded Under 26.1115, Tax Code. The amount will print as 0.00.
 
09/19/2023 : This update adds the new row on the tax schedule for the amount refunded under Section 26.1115 of the Tax Code. This row is also added to the Audit Data Feed. If you have already created the data file for the tax schedule, you can add a row to that schedule using the control code 9001. The amount should be entered in only column 31 and it should be entered as a positive number.

There is also a correction to the second page of the RSI Schedule for the OPEB Liability. The date in the first column on the second page is now correct.
 
09/13/2023 : There are three issues corrected in this update. First, the Exhibit file in the common folder incorrectly had the FY 2022. This has been corrected. If you have already created your data files in the Report Generator, you will need to correct this by selecting HEADINGS in the Report Data Screen when printing or previewing and clicking the option to Change the Fiscal Year. An error calculating the liabilities when importing data into the custodial fund was corrected. The print routine for the tax schedule has been correct so that footnote now prints on the Tax Schedule.
 
09/11/2023 : This update includes a critical correction to the MOE tests for IDEA-B. Our code calculating the deficiency for the per capita items was not working correctly. We have now corrected that error. There is also a small change in the data file and query for custodial funds as reported in the E Exhibits.
 
08/09/2023 : This update includes a correction to the title of the Lead Sheet by Objects report. This update also includes the remainder of the compliance programs for the Audit Program Generator and the revised notes for GASB 68 and GASB 75.
 
08/02/2023 : This update includes the revised notes, pension note, RSI note, etc. in the Report Generator. Several updates to the compliance programs are included in the Audit Program Generator.
 
07/13/2023 : This update includes a revised User Manual for AUDIT-L.E.A. with some corrections to the Example Financial Report. We have also included the revised compliance programs for the Generic, Cross-cutting, Title 1, IDEA Cluster, and the ESSER funds for the Audit Program Generator. The RSI note for the Pensions and OPEB tables is also updated for the 2023 reporting period.
 
05/15/2023 : This update contains a critical update to the AUDIT DATA FEED routine in the Report Generator. We have been advised by TEA of a significant change in the data required to be entered for Exhibits C1 and C2 (our C3). TEA is now requiring that the totals for the Non-Major Governmental funds be included as well as a column for the sum of all Major funds other than GF, CP, DS and Food Service (240).
 
Release 27S

Update Notes

02/05/2024 : This update corrects the MOE test for IDEA B for function 71. We failed to restrict the specific object codes for function 71 to fund 199 only. This only applies to expenditures in other funds for the right-to-leases and SBITAs.
 
11/28/2023 : This update corrects the PEIMS check routine in the Trial Balance program for change TEA made to 20032-0153 error check to allow object codes 6514 and 6526 to also be reported with function 71 in special revenue funds. Please be sure function 71 is not included for funds 269, 278, 279, 280, 284, 285 or 345 as per check 20032-0150.
 
10/27/2023 : This update corrects an error in the PEIMS check routine when checking the rules requiring the ADA. There is also a correction in the Report Generator allowing the total debt service column or total capital projects column to be included in the combining statements when there are both major and nonmajor funds. If you are having that problem with the combining statements, you should go to the Report Generator and select the Data Files option and then select the option to create or recreate data files and from the list select the Recreate the Report Information File ONLY. Do this after installing this update. We have also added the Fresh Fruit and Vegetable Program (10.582) to the Child Nutrition Cluster in the SEFA data file.
 
09/11/2023 : This update includes a critical correction to the MOE tests for IDEA-B. Our code calculating the deficiency for the per capita items was not working correctly. We have now corrected that error. There is also a small change in the data file and query for custodial funds as reported in the E Exhibits.
 
08/09/2023 : This update includes a correction to the title of the Lead Sheet by Objects report. This update also includes the remainder of the compliance programs for the Audit Program Generator and the revised notes for GASB 68 and GASB 75.
 
07/13/2023 : This update includes a revised User Manual for AUDIT-L.E.A. with some corrections to the Example Financial Report. We have also included the revised compliance programs for the Generic, Cross-cutting, Title 1, IDEA Cluster, and the ESSER funds for the Audit Program Generator. The RSI note for the Pensions and OPEB tables is also updated for the 2023 reporting period.
 
04/01/2023 : The example adjusting entries in the AUDIT-L.E.A. Manual failed to include the depreciation for the Right-to-Use lease assets. These are now included in Entry # 13. This update includes the revised User Manual.
 
03/31/2023 : The example worksheets for the allocation of the profit(loss) of internal service funds by function for the fund to government wide adjustment were accidentally left out of the example worksheets in the AUDIT-L.E.A. manual. This update provides a corrected version of the manual.
 


Updates for RELEASE 26

Release 26A

Update Notes

01/16/2023 : This update corrects the spending compliance test for State Comp Ed. The allowed spending in fund 283 is added when calculating the total eligible expenditures made by the District.
 
01/04/2023 : This update allows the user to print, preview or create a PDF file for the MOE IDEA-B tests even if all of the required information to correctly calculate the results of the tests has not been entered by the user.
 
11/30/2022 : This update corrects the import routine to the balance sheet data file for custodial funds so that the amount of 3900 can be correctly calculated when there are no restricted net position items.
 
11/29/2022 : This update adds a routine to increase the page number on the second page on Exhibit A-1 when the option to split the report into two pages is chosen. With this option, the Assets and Deferred Resource Outflows are presented on the first page and the Liabilities, Deferred Resource Inflows and Equities are presented on the second page. The page number will now increase by 1 on the second page.
 
11/22/2022 : This update revises the print routine for Exhibit H-1 allowing for larger numbers in each column.
 
11/19/2022 : This update makes a change to the IDEA MOE test routine to accommodate the case when the state share is imputed to be zero.
 
11/15/2022 : This update contains the rest of the revisions for the auditors reports in the Documents section of the Report Generator.
 
11/14/2022 : This update contains the revised Auditor Opinions in the Documents file in the Report Generator. These have been revised to meet the new requirements. Most are completed. There are four additional report options under the OMB selection that have not yet been revised. They will be available soon.
 
11/10/2022 : This update corrects an error in the print-all routine in the Report Generator. The print routine for Exhibit G-9 District's Contributions for Other Postemployment Benefits (OPEB) was not printing correctly.
 
11/07/2022 : This update corrects the position of the control codes when printing Exhibit A-1 for the form with both enterprise funds and a component unit.
 
11/07/2022 : This update puts the NEW SCHOOLS menu item back in the main screen for AUDIT-L.E.A. Release 26 A.
 
11/06/2022 : This update corrects the routine for the MOE for IDEA-B with amended budget and the routine testing the proposed budget to see if the budgeted amounts would meet the MOE requirements. All changes in all previous updates are included in this file.
 
11/05/2022 : TEA has advised that the expenditure amounts in Exhibit -J4 should NOT include the ESSER funds. This update calculates that amount and provides it when you run the tests in the Trial Balance for the enhanced programs. The print routines for Exhibit A1 and B1 with EF funds and Component Units has been revised to allow for more rows of data to print on one page. There is an additional change in the Excess Cash for food serices report now allowing for any 124x object code. There is also an important correction to the routine for the IDEA-B MOE test.
 
10/31/2022 : This update corrects the test for Excess Cash in food service to be consistent with changes in the ARM manual. There is also a correction to the print all routines in the Report Generator applying the changes made to print the SEFA.
 
10/25/2022 : We have been advised that the subtotals on the SEFA should now include all ALN with the same code disregarding the different alpha characters at the end of the ALN. This update makes that change for the SEFA. This is a change in the print routine only. There is no need to change your data file.
 
10/21/2022 : This is a critical update correcting the routine which creates the data file for the SEFA. The new funds added for fund 284 and 285 were not coming into the data file correctly. This update now allows them to come in correctly as part of the IDEA-B cluster. If you have already created the data file and do not want to recreate it, you can recode the control code so that these programs are listed following the others with the same ALN and be certatin the ALN number is correct. If you recreate the data file, you will need to import the amounts again after recreating the file.
 
10/13/2022 : This update adds additional field width to the descriptions for Exhibit A-1. There is also a change in the data file providing these descriptions when the data file for Exhibit A-1 is created. Additional information has been added to the description for the Net Investment in Capital Assets which now includes "and Right-to-Use Lease Assets". All print routines have been revised to accommodate this longer description. If you have both enterprise funds and one column for a component unit you will need to shorten this description. If you have already created your data file for Exhibit A-1 in the Report Generator you will need to recreate the file in order to implement this change. Remember to populate this data file you only need to open the fund to government wide worksheet and preview Exhibit D-1 if you have enterprise funds and open the data file for the component units containing the balance sheet information.
 
10/10/2022 : This update corrects the routine printing the PDF file for the District's Proportionate Share of the Net OPEB Liability. While the exhibit prints correctly the PDF file routine did not print the first page. The pdf file in the routine creating the entrire Annual Report as a PDF file did print the first page.
 
10/02/2022 : This update corrects the file name for the Audit Data Feed. This should by the county-district number followed by 21. There is also a new print routine for Exhibit A-1 which prints with smaller fonts when there are too many rows of data to print on one page.
 
09/24/2022 : This update changes the font on the new J-4 Schedule so that it matches the font used for all of the other exhibits.
 
09/22/2022 : This update corrects the print routine for the Materiality Planning Report. The error occurred in the first column on the second page of the report.
 
09/07/2022 : This update corrects the PEIMS edit checks to recognize these funds as no longer reserved or unavailable. The funds are 279, 280, 284 and 285. The correct names for the combining statements are now included in the Report Information File. If you have already created that file you can go to the report generator and select the Create or Recreate Files and select the Report Information File only to add the titles for these funds in addition to titles for funds 281, 282, and 283..
 
08/12/2022 : This update places the Help file in the application folder. The HELP buttons and menu options will now work correctly.
 
08/09/2022 : This update provides the updated compliance programs for the Audit Program Generator. All have now been unpdated with the April 2022 Compliance Supplement.
 
08/01/2022 : This update adds some new checks for the PEIMS check routine. The Pension and OPEB notes have been completed for this reporting period and there is a modification in the Notes to RSI. The Pension and OPEB notes have been added to the sample notes to the financial statements.
 
07/26/2022 : This update makes corrections to all of the MOE tests for IDEA-B. There was an error in calculating the per capita deficiencies.
 
06/25/2022 : This update makes corrections to all of the MOE tests for ESSA (Title 1) routines including those in the proposed budget screen.
 
06/07/2022 : This update includes all previous updates AND it makes a slight correction in the data entry screens for GASB 75 and GASB 68 in the Report Generator.
 
06/06/2022 : This update adds Gifted and Talented Program in the Trial Balance Program for testing the required spending percentage. There are several updates in the Compliance Program in the Audit Program Generator including a new program for the Food Distribution Cluster and the updates from the April 2022 Compliance Supplement for the ESSER funds, the Child Nutrition Cluster, Title 1 and the Cross-cutting and generic audit programs. We have also updated the compliance program for the State Mandated Programs to include Gifted and Talented program. There are some mimor corrections in the Report Generator as well.
 
05/09/2022 : This update places the icon to set up a new school back in the tool bar on the main screen in Release 26 A.
 
05/02/2022 : This update corrects the wording on one of the GASB 68 adjusting entries.
 
04/07/2022 : This update corrects an error in the routine to create the entire PDF file in the Report Generator. One version of the combining statement H-11 was not included. This is the combining statement for trust funds and occurred if you have only two of these funds reported in Exhibit H-11.
 
04/01/2022 : This update corrects the import routine to import prior year data files into the Trial Balance. The routine will now look for the TB21.dat file in the folder you have selected.
 
Release 26B

Update Notes

01/16/2023 : This update corrects the spending compliance test for State Comp Ed. The allowed spending in fund 283 is added when calculating the total eligible expenditures made by the District.
 
01/04/2023 : This update allows the user to print, preview or create a PDF file for the MOE IDEA-B tests even if all of the required information to correctly calculate the results of the tests has not been entered by the user.
 
11/30/2022 : This update corrects the import routine to the balance sheet data file for custodial funds so that the amount of 3900 can be correctly calculated when there are no restricted net position items.
 
11/29/2022 : This update adds a routine to increase the page number on the second page on Exhibit A-1 when the option to split the report into two pages is chosen. With this option, the Assets and Deferred Resource Outflows are presented on the first page and the Liabilities, Deferred Resource Inflows and Equities are presented on the second page. The page number will now increase by 1 on the second page.
 
11/22/2022 : This update revises the print routine for Exhibit H-1 allowing for larger numbers in each column.
 
11/19/2022 : This update makes a change to the IDEA MOE test routine to accommodate the case when the state share is imputed to be zero.
 
11/15/2022 : This update contains the rest of the revisions for the auditors reports in the Documents section of the Report Generator.
 
11/14/2022 : This update contains the revised Auditor Opinions in the Documents file in the Report Generator. These have been revised to meet the new requirements. Most are completed. There are four additional report options under the OMB selection that have not yet been revised. They will be available soon.
 
11/10/2022 : This update corrects an error in the print-all routine in the Report Generator. The print routine for Exhibit G-9 District's Contributions for Other Postemployment Benefits (OPEB) was not printing correctly.
 
11/07/2022 : This update corrects the position of the control codes when printing Exhibit A-1 for the form with both enterprise funds and a component unit.
 
11/06/2022 : This update corrects the routine for the MOE for IDEA-B with amended budget and the routine testing the proposed budget to see if the budgeted amounts would meet the MOE requirements. All changes in all previous updates are included in this file.
 
10/31/2022 : This update corrects the test for Excess Cash in food service to be consistent with changes in the ARM manual. There is also a correction to the print all routines in the Report Generator applying the changes made to print the SEFA.
 
10/25/2022 : We have been advised that the subtotals on the SEFA should now include all ALN with the same code disregarding the different alpha characters at the end of the ALN. This update makes that change for the SEFA. This is a change in the print routine only. There is no need to change your data file.
 
10/21/2022 : This is a critical update correcting the routine which creates the data file for the SEFA. The new funds added for fund 284 and 285 were not coming into the data file correctly. This update now allows them to come in correctly as part of the IDEA-B cluster. If you have already created the data file and do not want to recreate it, you can recode the control code so that these programs are listed following the others with the same ALN and be certatin the ALN number is correct. If you recreate the data file, you will need to import the amounts again after recreating the file.
 
10/13/2022 : This update adds additional field width to the descriptions for Exhibit A-1. There is also a change in the data file providing these descriptions when the data file for Exhibit A-1 is created. Additional information has been added to the description for the Net Investment in Capital Assets which now includes "and Right-to-Use Lease Assets". All print routines have been revised to accommodate this longer description. If you have both enterprise funds and one column for a component unit you will need to shorten this description. If you have already created your data file for Exhibit A-1 in the Report Generator you will need to recreate the file in order to implement this change. Remember to populate this data file you only need to open the fund to government wide worksheet and preview Exhibit D-1 if you have enterprise funds and open the data file for the component units containing the balance sheet information.
 
10/10/2022 : This update corrects the routine printing the PDF file for the District's Proportionate Share of the Net OPEB Liability. While the exhibit prints correctly the PDF file routine did not print the first page. The pdf file in the routine creating the entrire Annual Report as a PDF file did print the first page.
 
10/02/2022 : This update corrects the file name for the Audit Data Feed. This should by the county-district number followed by 21. There is also a new print routine for Exhibit A-1 which prints with smaller fonts when there are too many rows of data to print on one page.
 
09/24/2022 : This update changes the font on the new J-4 Schedule so that it matches the font used for all of the other exhibits.
 
09/22/2022 : This update corrects the print routine for the Materiality Planning Report. The error occurred in the first column on the second page of the report.
 
09/07/2022 : This update corrects the PEIMS edit checks to recognize these funds as no longer reserved or unavailable. The funds are 279, 280, 284 and 285. The correct names for the combining statements are now included in the Report Information File. If you have already created that file you can go to the report generator and select the Create or Recreate Files and select the Report Information File only to add the titles for these funds in addition to titles for funds 281, 282, and 283..
 
08/12/2022 : This update places the Help file in the application folder. The HELP buttons and menu options will now work correctly.
 
08/01/2022 : This update adds some new checks for the PEIMS check routine. The Pension and OPEB notes have been completed for this reporting period and there is a modification in the Notes to RSI. The Pension and OPEB notes have been added to the sample notes to the financial statements.
 
07/26/2022 : This update makes corrections to all of the MOE tests for IDEA-B. There was an error in calculating the per capita deficiencies.
 
06/25/2022 : This update makes corrections to all of the MOE tests for ESSA (Title 1) routines including those in the proposed budget screen.
 
06/07/2022 : This update includes all previous updates AND it makes a slight correction in the data entry screens for GASB 75 and GASB 68 in the Report Generator.
 
06/06/2022 : This update adds Gifted and Talented Program in the Trial Balance Program for testing the required spending percentage. There are several updates in the Compliance Program in the Audit Program Generator including a new program for the Food Distribution Cluster and the updates from the April 2022 Compliance Supplement for the ESSER funds, the Child Nutrition Cluster, Title 1 and the Cross-cutting and generic audit programs. We have also updated the compliance program for the State Mandated Programs to include Gifted and Talented program. There are some mimor corrections in the Report Generator as well.
 
05/02/2022 : This update corrects the wording on one of the GASB 68 adjusting entries.
 
04/07/2022 : This update corrects an error in the routine to create the entire PDF file in the Report Generator. One version of the combining statement H-11 was not included. This is the combining statement for trust funds and occurred if you have only two of these funds reported in Exhibit H-11.
 
04/01/2022 : This update corrects the import routine to import prior year data files into the Trial Balance. The routine will now look for the TB21.dat file in the folder you have selected.
 
Release 26P

Update Notes

08/12/2022 : This update places the Help file in the application folder. The HELP buttons and menu options will now work correctly.
 
08/09/2022 : This update provides the updated compliance programs for the Audit Program Generator. All have now been unpdated with the April 2022 Compliance Supplement.
 
06/06/2022 : This update adds Gifted and Talented Program in the Trial Balance Program for testing the required spending percentage. There are several updates in the Compliance Program in the Audit Program Generator including a new program for the Food Distribution Cluster and the updates from the April 2022 Compliance Supplement for the ESSER funds, the Child Nutrition Cluster, Title 1 and the Cross-cutting and generic audit programs. We have also updated the compliance program for the State Mandated Programs to include Gifted and Talented program. There are some mimor corrections in the Report Generator as well.
 
Release 26R

Update Notes

11/30/2022 : This update corrects the import routine to the balance sheet data file for custodial funds so that the amount of 3900 can be correctly calculated when there are no restricted net position items.
 
11/29/2022 : This update adds a routine to increase the page number on the second page on Exhibit A-1 when the option to split the report into two pages is chosen. With this option, the Assets and Deferred Resource Outflows are presented on the first page and the Liabilities, Deferred Resource Inflows and Equities are presented on the second page. The page number will now increase by 1 on the second page.
 
11/22/2022 : This update revises the print routine for Exhibit H-1 allowing for larger numbers in each column.
 
11/15/2022 : This update contains the rest of the revisions for the auditors reports in the Documents section of the Report Generator.
 
11/14/2022 : This update contains the revised Auditor Opinions in the Documents file in the Report Generator. These have been revised to meet the new requirements. Most are completed. There are four additional report options under the OMB selection that have not yet been revised. They will be available soon.
 
11/10/2022 : This update corrects an error in the print-all routine in the Report Generator. The print routine for Exhibit G-9 District's Contributions for Other Postemployment Benefits (OPEB) was not printing correctly.
 
11/07/2022 : This update corrects the position of the control codes when printing Exhibit A-1 for the form with both enterprise funds and a component unit.
 
11/05/2022 : TEA has advised that the expenditure amounts in Exhibit -J4 should NOT include the ESSER funds. This update calculates that amount and provides it when you run the tests in the Trial Balance for the enhanced programs. The print routines for Exhibit A1 and B1 with EF funds and Component Units has been revised to allow for more rows of data to print on one page. There is an additional change in the Excess Cash for food serices report now allowing for any 124x object code. There is also an important correction to the routine for the IDEA-B MOE test.
 
10/31/2022 : This update corrects the test for Excess Cash in food service to be consistent with changes in the ARM manual. There is also a correction to the print all routines in the Report Generator applying the changes made to print the SEFA.
 
10/25/2022 : We have been advised that the subtotals on the SEFA should now include all ALN with the same code disregarding the different alpha characters at the end of the ALN. This update makes that change for the SEFA. This is a change in the print routine only. There is no need to change your data file.
 
10/21/2022 : This is a critical update correcting the routine which creates the data file for the SEFA. The new funds added for fund 284 and 285 were not coming into the data file correctly. This update now allows them to come in correctly as part of the IDEA-B cluster. If you have already created the data file and do not want to recreate it, you can recode the control code so that these programs are listed following the others with the same ALN and be certatin the ALN number is correct. If you recreate the data file, you will need to import the amounts again after recreating the file.
 
10/13/2022 : This update adds additional field width to the descriptions for Exhibit A-1. There is also a change in the data file providing these descriptions when the data file for Exhibit A-1 is created. Additional information has been added to the description for the Net Investment in Capital Assets which now includes "and Right-to-Use Lease Assets". All print routines have been revised to accommodate this longer description. If you have both enterprise funds and one column for a component unit you will need to shorten this description. If you have already created your data file for Exhibit A-1 in the Report Generator you will need to recreate the file in order to implement this change. Remember to populate this data file you only need to open the fund to government wide worksheet and preview Exhibit D-1 if you have enterprise funds and open the data file for the component units containing the balance sheet information.
 
10/10/2022 : This update corrects the routine printing the PDF file for the District's Proportionate Share of the Net OPEB Liability. While the exhibit prints correctly the PDF file routine did not print the first page. The pdf file in the routine creating the entrire Annual Report as a PDF file did print the first page.
 
10/02/2022 : This update corrects the file name for the Audit Data Feed. This should by the county-district number followed by 21. There is also a new print routine for Exhibit A-1 which prints with smaller fonts when there are too many rows of data to print on one page.
 
09/24/2022 : This update changes the font on the new J-4 Schedule so that it matches the font used for all of the other exhibits.
 
09/07/2022 : This update corrects the PEIMS edit checks to recognize these funds as no longer reserved or unavailable. The funds are 279, 280, 284 and 285. The correct names for the combining statements are now included in the Report Information File. If you have already created that file you can go to the report generator and select the Create or Recreate Files and select the Report Information File only to add the titles for these funds in addition to titles for funds 281, 282, and 283..
 
08/12/2022 : This update places the Help file in the application folder. The HELP buttons and menu options will now work correctly.
 
08/01/2022 : This update adds some new checks for the PEIMS check routine. The Pension and OPEB notes have been completed for this reporting period and there is a modification in the Notes to RSI. The Pension and OPEB notes have been added to the sample notes to the financial statements.
 
06/07/2022 : This update includes all previous updates AND it makes a slight correction in the data entry screens for GASB 75 and GASB 68 in the Report Generator.
 
06/06/2022 : This update adds Gifted and Talented Program in the Trial Balance Program for testing the required spending percentage. There are several updates in the Compliance Program in the Audit Program Generator including a new program for the Food Distribution Cluster and the updates from the April 2022 Compliance Supplement for the ESSER funds, the Child Nutrition Cluster, Title 1 and the Cross-cutting and generic audit programs. We have also updated the compliance program for the State Mandated Programs to include Gifted and Talented program. There are some mimor corrections in the Report Generator as well.
 
05/02/2022 : This update corrects the wording on one of the GASB 68 adjusting entries.
 
04/07/2022 : This update corrects an error in the routine to create the entire PDF file in the Report Generator. One version of the combining statement H-11 was not included. This is the combining statement for trust funds and occurred if you have only two of these funds reported in Exhibit H-11.
 
Release 26S

Update Notes

01/16/2023 : This update corrects the spending compliance test for State Comp Ed. The allowed spending in fund 283 is added when calculating the total eligible expenditures made by the District.
 
01/04/2023 : This update allows the user to print, preview or create a PDF file for the MOE IDEA-B tests even if all of the required information to correctly calculate the results of the tests has not been entered by the user.
 
11/19/2022 : This update makes a change to the IDEA MOE test routine to accommodate the case when the state share is imputed to be zero.
 
11/06/2022 : This update corrects the routine for the MOE for IDEA-B with amended budget and the routine testing the proposed budget to see if the budgeted amounts would meet the MOE requirements. All changes in all previous updates are included in this file.
 
11/05/2022 : TEA has advised that the expenditure amounts in Exhibit -J4 should NOT include the ESSER funds. This update calculates that amount and provides it when you run the tests in the Trial Balance for the enhanced programs. The print routines for Exhibit A1 and B1 with EF funds and Component Units has been revised to allow for more rows of data to print on one page. There is an additional change in the Excess Cash for food serices report now allowing for any 124x object code. There is also an important correction to the routine for the IDEA-B MOE test.
 
10/31/2022 : This update corrects the test for Excess Cash in food service to be consistent with changes in the ARM manual. There is also a correction to the print all routines in the Report Generator applying the changes made to print the SEFA.
 
09/22/2022 : This update corrects the print routine for the Materiality Planning Report. The error occurred in the first column on the second page of the report.
 
09/07/2022 : This update corrects the PEIMS edit checks to recognize these funds as no longer reserved or unavailable. The funds are 279, 280, 284 and 285. The correct names for the combining statements are now included in the Report Information File. If you have already created that file you can go to the report generator and select the Create or Recreate Files and select the Report Information File only to add the titles for these funds in addition to titles for funds 281, 282, and 283..
 
08/12/2022 : This update places the Help file in the application folder. The HELP buttons and menu options will now work correctly.
 
08/01/2022 : This update adds some new checks for the PEIMS check routine. The Pension and OPEB notes have been completed for this reporting period and there is a modification in the Notes to RSI. The Pension and OPEB notes have been added to the sample notes to the financial statements.
 
07/26/2022 : This update makes corrections to all of the MOE tests for IDEA-B. There was an error in calculating the per capita deficiencies.
 
06/25/2022 : This update makes corrections to all of the MOE tests for ESSA (Title 1) routines including those in the proposed budget screen.
 
06/06/2022 : This update adds Gifted and Talented Program in the Trial Balance Program for testing the required spending percentage. There are several updates in the Compliance Program in the Audit Program Generator including a new program for the Food Distribution Cluster and the updates from the April 2022 Compliance Supplement for the ESSER funds, the Child Nutrition Cluster, Title 1 and the Cross-cutting and generic audit programs. We have also updated the compliance program for the State Mandated Programs to include Gifted and Talented program. There are some mimor corrections in the Report Generator as well.
 


Updates for RELEASE 25

Release 25A

Update Notes

01/06/2022 : This update adds Cluster #5 for the SEFA to accommodate the Food Distribution Cluster. The ASL numbers are 10.565, 10.568 and 10.569. There is also a new print routine for Exhibits E-1 and E-2 for reports with Private Purpose Trust funds, Custodial Funds AND a Fiduciary Component Unit.
 
12/29/2021 : This update makes some additional font size corrections for some forms of Exhibit A1 and Exhibit B1
 
12/28/2021 : This update corrects the font size on the sub-headings of the print routine for Exhibit A-1 when there is one component unit and no enterprise funds. The heading for Restricted Net Position Items is also now printing on this form. There is also a change for one of the forms for Exhibit B-1 changing the font size for the bottom section of the report and removing unwanted lines in the component unit columns.
 
12/15/2021 : This update corrects the routine creating the data file containing the PEIMS data for filing in the Trial Balance File. The routine was rolling the new ESSER fund number 281 and 282 into the 289 - Other Federally Funded Special Revenue Funds. This update removes these two funds from that roll up and brings them into the file as distinct funds.
 
12/13/2021 : This update corrects the page numbering for the second page of Exhibit B-1 for the routine with no enterprise funds but with component units.
 
12/08/2021 : This update corrects an error printing only 3 columns of data in Exhibit C-1. The lines at the top of the page were not printing correctly.
 
12/07/2021 : This update adds a third page to the print routine for Exhibit H11.
 
12/01/2021 : This update adjusts the pdf file created for Exhibit B-1 so that commas are not cut off under the numbers. There is also an additional adjustment to the routine importing information from the enterprise fund data file into the Government Wide Statement of Net Position data file.
 
11/29/2021 : This update corrects the print routines for Exhibit D-3 so that the new line added in the previous update does not print in an empty column.
 
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

01/06/2022 : This update adds Cluster #5 for the SEFA to accommodate the Food Distribution Cluster. The ASL numbers are 10.565, 10.568 and 10.569. There is also a new print routine for Exhibits E-1 and E-2 for reports with Private Purpose Trust funds, Custodial Funds AND a Fiduciary Component Unit.
 
12/29/2021 : This update makes some additional font size corrections for some forms of Exhibit A1 and Exhibit B1
 
12/28/2021 : This update corrects the font size on the sub-headings of the print routine for Exhibit A-1 when there is one component unit and no enterprise funds. The heading for Restricted Net Position Items is also now printing on this form. There is also a change for one of the forms for Exhibit B-1 changing the font size for the bottom section of the report and removing unwanted lines in the component unit columns.
 
12/15/2021 : This update corrects the routine creating the data file containing the PEIMS data for filing in the Trial Balance File. The routine was rolling the new ESSER fund number 281 and 282 into the 289 - Other Federally Funded Special Revenue Funds. This update removes these two funds from that roll up and brings them into the file as distinct funds.
 
12/13/2021 : This update corrects the page numbering for the second page of Exhibit B-1 for the routine with no enterprise funds but with component units.
 
12/08/2021 : This update corrects an error printing only 3 columns of data in Exhibit C-1. The lines at the top of the page were not printing correctly.
 
12/07/2021 : This update adds a third page to the print routine for Exhibit H11.
 
12/01/2021 : This update adjusts the pdf file created for Exhibit B-1 so that commas are not cut off under the numbers. There is also an additional adjustment to the routine importing information from the enterprise fund data file into the Government Wide Statement of Net Position data file.
 
11/29/2021 : This update corrects the print routines for Exhibit D-3 so that the new line added in the previous update does not print in an empty column.
 
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

01/06/2022 : This update adds Cluster #5 for the SEFA to accommodate the Food Distribution Cluster. The ASL numbers are 10.565, 10.568 and 10.569. There is also a new print routine for Exhibits E-1 and E-2 for reports with Private Purpose Trust funds, Custodial Funds AND a Fiduciary Component Unit.
 
12/29/2021 : This update makes some additional font size corrections for some forms of Exhibit A1 and Exhibit B1
 
12/28/2021 : This update corrects the font size on the sub-headings of the print routine for Exhibit A-1 when there is one component unit and no enterprise funds. The heading for Restricted Net Position Items is also now printing on this form. There is also a change for one of the forms for Exhibit B-1 changing the font size for the bottom section of the report and removing unwanted lines in the component unit columns.
 
12/13/2021 : This update corrects the page numbering for the second page of Exhibit B-1 for the routine with no enterprise funds but with component units.
 
12/08/2021 : This update corrects an error printing only 3 columns of data in Exhibit C-1. The lines at the top of the page were not printing correctly.
 
12/07/2021 : This update adds a third page to the print routine for Exhibit H11.
 
12/01/2021 : This update adjusts the pdf file created for Exhibit B-1 so that commas are not cut off under the numbers. There is also an additional adjustment to the routine importing information from the enterprise fund data file into the Government Wide Statement of Net Position data file.
 
11/29/2021 : This update corrects the print routines for Exhibit D-3 so that the new line added in the previous update does not print in an empty column.
 
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

12/15/2021 : This update corrects the routine creating the data file containing the PEIMS data for filing in the Trial Balance File. The routine was rolling the new ESSER fund number 281 and 282 into the 289 - Other Federally Funded Special Revenue Funds. This update removes these two funds from that roll up and brings them into the file as distinct funds.
 
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.