TOWN OF READING, MASSACHUSETTS
MUNICIPAL LIGHT DEPARTMENT
SCHEDULE OF ACCOUNTS RECEIVABLE
11/30/07
					SCHEDULE B
		PREVIOUS YEAR			CURRENT YEAR
SCHEDULE OF ACCOUNTS RECEIVABLE
RESIDENTIAL AND COMMERCIAL		4,412,997.62			4,648,820.20
ACCOUNTS RECEIVABLE - OTHER		313,616.59			215,034.23
ACCOUNTS RECEIVABLE - LIENS		49,557.54			62,738.41
ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES		1,067.16			1,067.16
SALES DISCOUNT LIABILITY		(298,035.96)			(275,821.87)
RESERVE FOR UNCOLLECTIBLE ACCOUNTS		(205,241.64)			(212,588.31)
TOTAL ACCOUNTS RECEIVABLE BILLED		4,273,961.31			4,439,249.82
UNBILLED ACCOUNTS RECEIVABLE		3,126,031.41			2,714,176.30
TOTAL ACCOUNTS RECEIVABLE, NET		7,399,992.72			7,153,426.12
SCHEDULE OF PREPAYMENTS
PREPAID INSURANCE		860,580.88			880,256.26
PREPAYMENT PURCHASED POWER		(10,206.82)			68,804.82
PREPAYMENT PASNY		193,297.11			194,170.65
TOTAL PREPAYMENT		1,043,671.17			1,143,231.73
* 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%