2007-2008 Audit Summary Worksheet

The following information is provided for independent school auditors. The manual and respective program will enable the auditors to prepare the Audit Summary Worksheet, which is required by the New Jersey Department of Education. Some of these files are large and may require significant time and computer resources.

Again this year, the independent school auditor must submit the audsum diskette, along with the transmittal letter, to the school district. The school district will be responsible for transmission of the audit summary data via the web enabled DOENET.  

As a reminder, the data submitted on the audit summary worksheet diskette will be automatically downloaded into the 2009-2010 school district budget programs for the 2007-2008 actual columns.  Therefore, the board secretaries/business administrators must receive copies of all reports generated from the diskette so they can attest to the accuracy of the data and sign off on the transmittal letter.  If discrepancies in the 2007-2008 information are identified when the district receives the 2009-2010 budget program, corrections to these actual numbers can only be made through the submission of a new audit summary worksheet diskette by your office.  This restriction has been our practice for the past ten years.  In addition, we are asking that the special revenue funds be reported in the Audit Summary Worksheet on a budgetary basis of accounting as presented in the Combining Schedule of Revenues and Expenditures.

A transmittal letter will automatically print when transferring the data to the DOE diskette.  The transmittal letter and diskette should be sent to the school district. Both the auditor and the board secretary/business administrator should sign the transmittal letter.  The completed diskette should be used in the transmission of the audsum data via Web Enabled DOENET by the school district. The transmittal letter should be sent by November 5, 2008 to:

New Jersey Department of Education
Attn:  Heather Leary, Division of Finance
P.O. Box 500
Trenton, NJ  08625-0500

IMPORTANT: Click on the following file to setup the audsum application:

aud07.exe

click on OK

1. click on set up
2. When prompted, press any key to continue.
3. The window will close on its own.
4. Open the installed audsum application from the hard drive prompt in DOS ( e.g., C:> ) by typing cd\audsum07 and hitting enter.
5. Type aud07 and hit enter. The county selection screen will appear.

PLEASE NOTE: YOU MUST REOPEN YOUR AUDSUM USING THE FOLLOWING PROCEDURE TO ENSURE PRINTING CAPABILITIES AND SUCCESSFUL TRANSFER OF DATA TO A DISKETTE. OPEN THE DOS PROMPT AND TYPE THE FOLLOWING:

C:\cd\a07####     (where #### = the lea code)
C:\A07####>aud07

The following files make-up the technical documentation for the software. Download each and print them using the appropriate software.

File Name	Format	File Name	Format	File Size	Description
audsum_man.doc	Microsoft Word	audsum_man.pdf	PDF	240 kb	Technical Manual
asw.xls	Microsoft Excel			406 kb	Audit Summary Worksheet

DISTRICT INSTRUCTIONS FOR SUBMITTING
THE AUDIT SUMMARY

All districts must submit the Audit Summary data by transmitting the files over the Web-enabled DOENET. The deadline for transmitting data this year is November 5, 2008. The signed transmittal letters can be sent to the DOE following this transmission. Follow these steps to transmit your data:

1. Place the audsum diskette or USB key in your PC’s floppy drive or USB drive
2. Open the Web-enabled DOENET shortcut on your PC
3. Select "Upload from Remote"
4. You will be prompted to select the appropriate disk drive
5. Type the appropriate letter
6. DOENET will establish a connection with the NJDOE computer
7. You will be prompted for your username and password
8. You may see some flashing while the files are being transferred
9. You should now see the DOENET main menu
10. If data was previously transferred, you will get a warning that this data will overwrite the previous data

For additional information on the DOENET software, please refer to the technical manual on our website at http://www.state.nj.us/education/data/collections/wdoenet/