2006-2007 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 2008-2009 school district budget programs for the 2006-2007 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 2006-2007 information are identified when the district receives the 2008-2009 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, 2007 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 three files and SAVE THEM TO A DISKETTE. Do not save them to your hard drive, as this will cause problems with the installation.

Once the downloads are complete, from the hard drive prompt in DOS( e.g., C:> ), type A:INSTAUDS.

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	147 kb	Technical Manual
asw.xls	Microsoft Excel			461 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 signed transmittal letters can be sent to the DOE following this transmission. Follow these steps to transmit your data:

1. Place the audsum diskette in your PC’s floppy drive
2. Open the Web-enabled DOENET shortcut on your PC
3. Select "Upload from Remote"
4. You will be prompted to select a disk drive "A" or "B"
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/njded/data/collections/wdoenet/