TOWN OF READING, MASSACHUSETTS
MUNICIPAL LIGHT DEPARTMENT
SCHEDULE OF ACCOUNTS RECEIVABLE
5/31/07
					SCHEDULE B
		PREVIOUS YEAR			CURRENT YEAR
SCHEDULE OF ACCOUNTS RECEIVABLE
RESIDENTIAL AND COMMERCIAL		3,529,713.97			3,220,692.08	*
ACCOUNTS RECEIVABLE - OTHER		443,180.54			249,527.53
ACCOUNTS RECEIVABLE - LIENS		45,646.88			48,170.97
ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES		1,067.16			1,067.16
SALES DISCOUNT LIABILITY		(178,965.02)			(241,802.14)	*
RESERVE FOR UNCOLLECTABLE ACCOUNTS		(171,620.28)			(196,100.63)
TOTAL ACCOUNTS RECEIVABLE BILLED		3,669,023.25			3,081,554.97
UNBILLED ACCOUNTS RECEIVABLE		2,568,181.94			3,126,031.41
TOTAL ACCOUNTS RECEIVABLE, NET		6,237,205.19			6,207,586.38
SCHEDULE OF PREPAYMENTS
PREPAID INSURANCE		509,635.38			515,774.76
PREPAYMENT PURCHASED POWER		130,662.99			(182,828.65)
PREPAYMENT PASNY		193,472.00			193,297.11
TOTAL PREPAYMENT		833,770.37			526,243.22
* ACCOUNTS RECEIVABLE AGING CURRENT YEAR:
RESIDENTIAL AND COMMERCIAL		4,989,817.08
LESS: SALES DISCOUNT LIABILITY		(327,940.81)
GENERAL LEDGER BALANCE		4,661,876.27
CURRENT		4,157,203.63		88.73%
30 DAYS		322,960.43		6.89%
60 DAYS		114,446.88		2.44%
90 DAYS		55,269.01		1.18%
OVER 90 DAYS		35,643.24		0.76%
TOTAL		4,685,523.19		100.00%