Entering Audit Report Data Step 5: The AFR and Balance Sheet Validation Audited screen will appear. Confirm that the Calculations’ tab is – ‘AFR presented first on the screen and the field consists of 1 (General)’. Then click the All’ button in order to ‘Section:’ ‘Fund ‘Import import the district’s predetermined selective FY 2018 Audited Annual Financial Report and Balance Sheet data into the ‘Audited AFR (A)’ column within the Calculations’ and Sheet Calculations’ tabs. ‘AFR ‘Balance Under the tab, the selective Audited Annual Financial Report data will display in the Step 6: Calculations’ AFR’ ‘AFR ‘Audited column. Then use the district’s FY 2018 Audit Report or proposed FY 2018 audit data received from the district’s auditor in order to obtain the amount that corresponds to the individual Fund, row description, and Audited AFR amount. Please use the Audit Report’s Statement of Revenues, Expenditures, and Changes in Fund Balance Governmental Funds (Funds 1, 2, 21, 22, 310, 320, 360, & 400) to obtain the amounts that will be entered into the Report (B)’ column within the SEEK ‘Audit Application. NOTE: Some of the Funds may be recorded in the Combining Statement of Revenues, Expenditures, and Changes in Fund Balances - Nonmajor Governmental Funds. Step 7: your cursor over the within the Report (B)’ column and 1 - Total Revenues’ row, then click on ‘$0.00’ ‘Audit ‘Fund the cell and enter the corresponding amount from the Audit Report. Enter any comments in the section by clicking on ‘Comments’ the specific comment field. To move to the next row, click on the designated cell in the Report (B)’ column. Repeat this ‘Audit process until all required Report (B)’ fields are completed for Fund 1. The shaded fields or areas contain built in formulas; ‘Audit therefore, it will not allow you to enter any amounts into the shaded fields. However, you may enter comments in the shaded fields corresponding sections. To determine Financing Sources’ and Financing Uses’, refer to the next page. ‘Comments’ ‘Other ‘Other Please the amounts and the amounts listed in the together and enter the add Transfers In Other Financing Sources Audit Report combined amount in to the Financing Sources’ field within the Calculations’ tab. ‘Other ‘AFR
Entering Audit Report Data Step 5: The AFR and Balance Sheet Validation – Audited screen will appear. Confirm that the ‘AFR Calculations’ tab is presented first on the screen and the ‘Section:’ field consists of ‘Fund 1 (General)’. Then click the ‘Import All’ button in order to import the district’s predetermined selective FY 2018 Audited Annual Financial Report and Balance Sheet data into the ‘Audited AFR (A)’ column within the ‘AFR Calculations’ and ‘Balance Sheet Calculations’ tabs. Step 6: Under the ‘AFR Calculations’ tab, the selective Audited Annual Financial Report data will display in the ‘Audited AFR’ column. Then use the district’s FY 2018 Audit Report or proposed FY 2018 audit data received from the district’s auditor in order to obtain the amount that corresponds to the individual Fund, row description, and Audited AFR amount. Please use the Audit Report’s Statement of Revenues, Expenditures, and Changes in Fund Balance Governmental Funds (Funds 1, 2, 21, 22, 310, 320, 360, & 400) to obtain the amounts that will be entered into the ‘Audit Report (B)’ column within the SEEK Application. NOTE: Some of the Funds may be recorded in the Combining Statement of Revenues, Expenditures, and Changes in Fund Balances - Nonmajor Governmental Funds. Step 7: your cursor over the ‘$0.00’ within the ‘Audit Report (B)’ column and ‘Fund 1 - Total Revenues’ row, then click on the cell and enter the corresponding amount from the Audit Report. Enter any comments in the ‘Comments’ section by clicking on the specific comment field. To move to the next row, click on the designated cell in the ‘Audit Report (B)’ column. Repeat this process until all required ‘Audit Report (B)’ fields are completed for Fund 1. The shaded fields or areas contain built in formulas; therefore, it will not allow you to enter any amounts into the shaded fields. However, you may enter comments in the shaded fields corresponding ‘Comments’ sections. To determine ‘Other Financing Sources’ and ‘Other Financing Uses’, refer to the next page. Please add the Transfers In amounts and the Other Financing Sources amounts listed in the Audit Report together and enter the combined amount in to the ‘Other Financing Sources’ field within the ‘AFR Calculations’ tab.
AFR%20and%20Balance%20Sheet%20Validation%20Instructions%20Dated%2010-10-18.docx