TOWN OF READING, MASSACHUSETTS
MUNICIPAL LIGHT DEPARTMENT
SCHEDULE OF ACCOUNTS RECEIVABLE
7/31/07
					SCHEDULE B
		PREVIOUS YEAR			CURRENT YEAR
SCHEDULE OF ACCOUNTS RECEIVABLE
RESIDENTIAL AND COMMERCIAL		6,078,833.36			4,339,082.60
ACCOUNTS RECEIVABLE - OTHER		1,083,386.26			896,367.44
ACCOUNTS RECEIVABLE - LIENS		41,654.80			46,285.99
ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES		1,067.16			1,067.16
SALES DISCOUNT LIABILITY		(341,846.65)			(284,412.84)
RESERVE FOR UNCOLLECTIBLE ACCOUNTS		(204,741.97)			(200,392.81)
TOTAL ACCOUNTS RECEIVABLE BILLED		6,658,352.96			4,797,997.54
UNBILLED ACCOUNTS RECEIVABLE		3,126,031.41			2,714,176.30
TOTAL ACCOUNTS RECEIVABLE, NET		9,784,384.37			7,512,173.84
SCHEDULE OF PREPAYMENTS
PREPAID INSURANCE		1,046,556.90			1,159,780.27
PREPAYMENT PURCHASED POWER		(1,101,803.90)			(336,388.40)
PREPAYMENT PASNY		193,297.11			194,170.65
TOTAL PREPAYMENT		138,050.11			1,017,562.52
* 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%