TOWN OF READING, MASSACHUSETTS
MUNICIPAL LIGHT DEPARTMENT
SCHEDULE OF ACCOUNTS RECEIVABLE
8/31/07
					SCHEDULE B
		PREVIOUS YEAR			CURRENT YEAR
SCHEDULE OF ACCOUNTS RECEIVABLE
RESIDENTIAL AND COMMERCIAL		4,783,617.82			3,660,375.00
ACCOUNTS RECEIVABLE - OTHER		409,966.23			305,547.14
ACCOUNTS RECEIVABLE - LIENS		33,134.17			45,524.46
ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES		1,067.16			1,067.16
SALES DISCOUNT LIABILITY		(262,586.50)			(233,530.70)
RESERVE FOR UNCOLLECTIBLE ACCOUNTS		(208,094.56)			(197,984.68)
TOTAL ACCOUNTS RECEIVABLE BILLED		4,757,104.32			3,580,998.38
UNBILLED ACCOUNTS RECEIVABLE		3,126,031.41			2,714,176.30
TOTAL ACCOUNTS RECEIVABLE, NET		7,883,135.73			6,295,174.68
SCHEDULE OF PREPAYMENTS
PREPAID INSURANCE		1,729,107.87			862,850.92
PREPAYMENT PURCHASED POWER		(777,167.82)			(392,077.32)
PREPAYMENT PASNY		193,297.11			194,170.65
TOTAL PREPAYMENT		1,145,237.16			664,944.25
* 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%