Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
05 - AR-DFOG
CITY OF BROOKLYN CENTER ACCOUNTS RECEIVABLE AND DUE FROM OTHER GOVERNMENTS ALL FUNDS - LEAD 12/31/2006 FUND NAME Accounts Due from ACCOUNT /DESCRIPTION Receivable Other Gov'ts MAJOR FUNDS: GENERAL FUND 60 18 SPECIAL REVENUE FUNDS: TIF DISTRICT #3 - 39 DEBT SERVICE FUND: SPECIAL ASSESSMENT BONDS - - ENTERPRISE FUNDS: MUNICIPAL LIQUOR 7 - GOLF COURSE - - EARLE BROWN HERITAGE CENTER 223 - WATER UTILITY 380 - SANITARY SEWER UTILITY 816 - STORM SEWER UTILITY 333 93 NONMAJOR FUNDS: SPECIAL REVENUE FUNDS: H RA - - EDA - - EARLE BROWN TIF DISTRICT - - TIF DISTRICT #4 - - POLICE FORFEITURE - - CDBG - - CITY INITIATIVES GRANT - 24 TOTAL SPECIAL REVENUE FUNDS - 24,064.43 DEBT SERVICE FUNDS: GENERAL OBLIGATION BONDS - - GO TAX INCREMENT BONDS - - TOTAL DEBT SERVICE FUNDS - - CAPITAL PROJECTS FUNDS: CAPITAL RESERVE EMERGENCY FUND - - CAPITAL IMPROVEMENTS FUND - - INFRASTRUCTURE CONSTRUCTION 16 - MUNICIPAL STATE AID CONSTRUCT - 56 EBHC CAPITAL FUND - - STREET RECONSTRUCTION 164 - TECHNOLOGY FUND - - TOTAL CAPITAL PROJECT FUNDS 180,865.29 56,056.08 ENTERPRISE FUNDS: RECYCLING 60 - STREET LIGHT UTILITY 55 - TOTAL ENTERPRISE FUNDS 116,510.76 - INTERNAL SERVICE FUNDS: CENTRAL GARAGE 14 - EMPLOYEE RETIREMENT BENEFIT 422.69 - COMPENSATED ABSENCES - - TOTAL INTERNAL SERVICE FUNDS 14,770.36 - TOTAL ALL FUNDS 2,133,011.72 231,941.78 CITY OF BROOKLYN CENTER ACCOUNTS RECEIVABLE AND DUE FROM OTHER GOVERNMENTS ALL FUNDS - DETAIL 12/31/2006 FUND NAME Accounts Due from ACCOUNT /DESCRIPTION Receivable Other Gov'ts MAJOR FUNDS: GENERAL FUND: 1205 Accounts Receivable - Billed 13 1215 Misc Accounts Receivable 46 1230 Returned Checks 3 1231 Allowance for Returned Checks (3,376.45) 1325 Due from Other Govt Units 18 TOTAL GENERAL 60,073.58 18,126.29 SPECIAL REVENUE FUNDS: TIF DISTRICT #3 1325 Due from Other Govt Units - 39,784.00 DEBT SERVICE FUND: SPECIAL ASSESSMENT BONDS TOTAL SPECIAL ASSESSMENT BONDS - - NONMAJOR FUNDS: SPECIAL REVENUE FUNDS: H RA EDA CDBG EARLE BROWN TIF DISTRICT TIF DISTRICT #4 POLICE FORFEITURE CITY INITIATIVES GRANT 1325 Due from Other Govt Units 24 TOTAL SPECIAL REVENUE FUNDS - 24,064.43 DEBT SERVICE FUNDS: GENERAL OBLIGATION BONDS GO TAX INCREMENT BONDS TOTAL DEBT SERVICE FUNDS - - CITY OF BROOKLYN CENTER ACCOUNTS RECEIVABLE AND DUE FROM OTHER GOVERNMENTS ALL FUNDS - DETAIL 12/31/2006 FUND NAME Accounts Due from ACCOUNT /DESCRIPTION Receivable Other Gov'ts CAPITAL PROJECTS FUNDS: CAPITAL IMPROVEMENTS FUND MUNICIPAL STATE AID CONSTRUCT 1325 Due from Other Govt Units 56 CAPITAL RESERVE EMERGENCY FUND INFRASTRUCTURE CONSTRUCTION 1205 Accounts Receivable - Billed 16 - EBHC CAPITAL FUND 1215 Misc Accounts Receivable STREET RECONSTRUCTION 1215 Misc Accounts Receivable 164 TECHNOLOGY FUND 1205 Accounts Receivable - Billed TOTAL CAPITAL PROJECT FUNDS 180,865.29 56,056.08 ENTERPRISE FUNDS: STREET LIGHT UTILITY RECYCLING TOTAL ENTERPRISE FUNDS - - INTERNAL SERVICE FUNDS: CENTRAL GARAGE 1205 Accounts Receivable - Billed 3 1215 Misc Accounts Receivable 10 EMPLOYEE RETIREMENT BENEFIT COMPENSATED ABSENCES TOTAL INTERNAL SERVICE FUNDS 14,347.67 - CITY OF BROOKLYN CENTER ACCOUNTS RECEIVABLE AND DUE FROM OTHER GOVERNMENTS UTILITY FUNDS DETAIL 12/31/2006 FUND NAME Accounts Due from ACCOUNT /DESCRIPTION Receivable Other Gov'ts ENTERPRISE FUNDS: WATER UTILITY 1205 Accounts Receivable - Billed 52 1210 Utility Receivables 146 1220 Unbilled Accounts Receivable 180 1230 Returned Checks - 1235 Bankruptcy Receivable 954.84 TOTAL WATER UTILITY 380,019.87 - SANITARY SEWER UTILITY 1205 Accounts Receivable - Billed 16 1210 Utility Receivables 377 1220 Unbilled Accounts Receivable 422 TOTAL SANITARY SEWER 816,289.26 - STORM SEWER UTILITY 1210 Utility Receivables 108 1220 Unbilled Accounts Receivable 224 1325 Due from Other Governments 93 TOTAL STORM SEWER 333,141.24 93,910.98 STREET LIGHT UTILITY 1210 Utility Receivables 22 1220 Unbilled Accounts Receivable 33 TOTAL STREET LIGHT UTILITY 55,661.94 - RECYCLING 1210 Utility Receivables 27 1220 Unbilled Accounts Receivable 33 TOTAL RECYCLING 60,848.82 - TOTAL ENTERPRISE FUNDS 1,645,961.13 93,910.98 CITY OF BROOKLYN CENTER ACCOUNTS RECEIVABLE AND DUE FROM OTHER GOVERNMENTS LIQUOR, GOLF, EBHC DETAIL 12/31/2006 FUND NAME Accounts Due from ACCOUNT /DESCRIPTION Receivable Other Gov'ts ENTERPRISE FUNDS: MUNICIPAL LIQUOR 1215 Misc Accounts Receivable 7 - TOTAL MUNICIPAL LIQUOR 7,780.00 - GOLF COURSE 1230 Returned Checks 81.75 - 1231 Allowance for Returned Checks (81.75) - TOTAL GOLF COURSE - - EARLE BROWN HERITAGE CENTER 1205 Accounts Receivable - Billed 242 - 1205 -1 Accts Rec.- Billed (Manual) 1 1215 Misc Accounts Receivable 194.20 - 1232 Estimated Uncollectible A/R (20,872.00) - 1325 Due from Other Govt Units - - TOTAL EARLE BROWN HERITAGE CENTER 223,561.36 - CITY OF BROOKLYN CENTER ACCOUNTS RECEIVABLE AND DUE FROM OTHER GOVERNMENTS ENTERPRISE FUNDS - REVENUE DETAIL 12/31/2006 FUND NAME Sales and Other ACCOUNT /DESCRIPTION user fees Revenues ENTERPRISE FUNDS: MUNICIPAL LIQUOR Operations 5 Miscellaneous Revenue 44 GOLF COURSE Operations 250 Miscellaneous Revenue 2 EARLE BROWN HERITAGE CENTER Operations 4 Miscellaneous Revenue 841123.59 CITY OF BROOKLYN CENTER UNBILLED PUBLIC UTILITY REVENUES DECEMBER 31, 2006 Storm Unbilled Sanitary Unbilled Street Unbilled Billing Date Days/ Fire lines Unbilled Recycle Unbilled Drainage Storm Sewer Sanitary Light Street Light Water Unbilled Order Dist Billed Percent Sales Fire lines Sales Recycle Sales Drainage Sales Sewer Sales Sales Sales Water 1 2 1/3/2007 88/91 500.00 483.52 9,377.39 9,068.25 78,556.24 75,966.47 153,618.28 148,553.94 11,460.97 11,083.14 69,831.92 67,529.77 96.70% 2 1 1/17/2007 74/91 387.50 315.11 11,954.58 9,721.31 67,646.51 55,009.25 133,774.35 108,783.54 9,301.13 7,563.56 52,503.82 42,695.41 81.32% 3 4 1/31/2007 60/91 500.00 329.67 6,487.56 4,277.51 74,626.14 49,204.05 99,333.91 65,494.89 10,652.83 7,023.84 40,305.90 26,575.32 65.93% 4 3 2/14/2007 46/91 112.50 56.87 9,151.57 4,626.07 31,803.60 16,076.55 80,488.54 40,686.51 5,809.92 2,936.88 36,630.49 18,516.51 50.55% 5 6 2/28/2007 32/91 187.50 65.93 12,557.66 4,415.88 57,856.73 20,345.22 125,322.09 44,069.31 9,795.70 3,444.64 49,010.07 17,234.31 35.16% 6 5 3/21/2007 11/91 525.00 63.46 10,780.03 1,303.08 65,752.24 7,948.07 124,212.05 15,014.64 10,062.38 1,216.33 55,649.65 6,726.88 12.09% 2,212.50 1,314.56 60,308.79 33,412.10 376,241.46 224,549.61 716,749.22 422,602.83 57,082.93 33,268.39 303,931.85 179,278.20 Dist last billed 2006 bill date 2007 days in cycle days in 2006 December accruals 2 10/4/2006 1/3/2007 91.00 88.00 60100 -1220 180,592.76 1 10/18/2006 1/17/2007 91.00 74.00 49141 -4702 1,314.56 4 11/1/2006 1/31/2007 91.00 60.00 49141 -4701 179,278.20 3 11/15/2006 2/14/2007 91.00 46.00 65300 -1220 33,412.10 6 11/29/2006 2/28/2007 91.00 32.00 49311 -4751 33,412.10 5 12/20/2006 3/21/2007 91.00 11.00 65100 -1220 224,549.61 49411 -4731 224,549.61 60200 -1220 422,602.83 49251 -4721 422,602.83 65200 -1220 33,268.39 49571 -4741 33,268.39 R55GLACT2 LOGIS001 Activity by Co, BU, Object.Sub CITY OF BROOKLYN CENTER 4/6/2007 14:07:02 Ledger AA General Ledger Activity w Balances IN PROGRESS Page - 1 1/1/2006 - 12/31/2006 Object 1215 Doc Doc No GL Date Rec /Ck# Account Number Description Current DB Amount Current CR Amount GL Explanation / Remark Address Name 10100 GENERAL FUND 10100 GENERAL FUND JE 35251 1/1/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 2,566.00 CARS PAYMENT RECD 1/4/06 JE 35252 1/1/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 937.93 8 -20 -05 AUCTION OF ABAND PROP JE 35856 1/1/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 96.59 REC'BLE FOR SURCHARGE OVERPAY JE 36240 1/1/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 43,273.50 ACCRUE DEC LODGING TAX JE 37414 3/31/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 21.00 ACCOUNTS RECEIVABLE JE 37415 3/31/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 1,161.90 permit 21764 paid in error JE 37416 3/31/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 21.00 ADJUST 2003 ACCTS RECEIVABLE JE 37417 3/31/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 1,856.16 NEISEN & CARMODY 2003 FICA RC 43018 9/20/2006 092006R 10100 -1215 MISC ACCOUNTS RECEIVABLE 42.00 ACCOUNTS RECEIVABLE (ERR) RC 43020 9/22/2006 092206R 10100 -1215 MISC ACCOUNTS RECEIVABLE 42.00 ACCOUNTS RECEIVABLE (ERR) REV JE 45831 12/31/2006 10100 -1215 MISC ACCOUNTS RECEIVABLE 46,422.30 DEC LODGING TAX Total 10100 -1215 49,850.08 BB TSD 49,850.08 Net BB 46,506.30 DB 49,934.08 CR 3,427.78- Net 46,422.30 Ending Balance Total BU 10100 49,850.08 BB TSD 49,850.08 Net BB 46,506.30 DB 49,934.08 CR 3,427.78- Net 46,422.30 Ending Balance Total Co 10100 49 BB TSD 49,850.08 Net BB 46 DB 49 CR 3,427.78- Net 46,422.30 Ending Balance 40800 EBHC CAPITAL FUND 40800 EBHC CAPITAL FUND JE 36239 1/1/2006 40800 -1215 MISC ACCOUNTS RECEIVABLE 391.80 REBATEON DISHWASHER Total 40800 -1215 391.80 BB TSD 391.80 Net BB DB 391.80 CR 391.80- Net Ending Balance Total BU 40800 391.80 BB TSD 391.80 Net BB DB 391.80 CR 391.80- Net Ending Balance Total Co 40800 391.80 BB TSD 391.80 Net BB DB 391.80 CR 391.80- Net Ending Balance 40900 STREET RECONSTRUCTION 40900 STREET RECONSTRUCTION JE 35858 1/1/2006 40900 -1215 MISC ACCOUNTS RECEIVABLE 100,516.24 XCEL ENERGY 4TH QTR FRANCH FEE JE 35860 1/1/2006 40900 -1215 MISC ACCOUNTS RECEIVABLE 63,478.35 CENTERPOINT 4TH QTR FRANCH FEE JE 46319 12/31/2006 40900 -1215 MISC ACCOUNTS RECEIVABLE 99,705.82 XCEL 4TH QUARTER JE 46320 12/31/2006 40900 -1215 MISC ACCOUNTS RECEIVABLE 64,829.72 CENTERPOINT 4TH QUARTER Total 40900 -1215 163,994.59 BB TSD 163,994.59 Net BB 164,535.54 DB 163,994.59 CR 540.95 Net 164,535.54 Ending Balance Total BU 40900 163 BB TSD 163,994.59 Net BB 164 DB 163 CR 540.95 Net 164,535.54 Ending Balance Total Co 40900 163 BB TSD 163,994.59 Net BB 164 DB 163 CR 540.95 Net 164,535.54 Ending Balance 60900 BROOKLYN CENTER LIQUOR R55GLACT2 LOGIS001 Activity by Co, BU, Object.Sub CITY OF BROOKLYN CENTER 4/6/2007 14:07:02 Ledger AA General Ledger Activity w Balances IN PROGRESS Page - 2 1/1/2006 - 12/31/2006 Object 1215 Doc Doc No GL Date Rec /Ck# Account Number Description Current DB Amount Current CR Amount GL Explanation / Remark Address Name 60900 BROOKLYN CENTER LIQUOR Total 60900 -1215 7,780.00 BB TSD 7,780.00 Net BB DB CR Net 7,780.00 Ending Balance Total BU 60900 7 BB TSD 7,780.00 Net BB DB CR Net 7,780.00 Ending Balance Total Co 60900 7 BB TSD 7,780.00 Net BB DB CR Net 7,780.00 Ending Balance 61700 EARLE BROWN HERITAGE CENTER 61700 EARLE BROWN HERITAGE CENTER JE 35250 1/1/2006 61700 -1215 MISC ACCOUNTS RECEIVABLE 3,356.00 INS REIMB FOR EBHC ROOF 1/4/06 JE 45579 12/31/2006 61700 -1215 MISC ACCOUNTS RECEIVABLE 194.20 MOVE OFFICE RENTAL REV TO A/R Total 61700 -1215 3,356.00 BB TSD 3,356.00 Net BB 194.20 DB 3,356.00 CR 3,161.80- Net 194.20 Ending Balance Total BU 61700 3 BB TSD 3,356.00 Net BB 194.20 DB 3 CR 3,161.80- Net 194.20 Ending Balance Total Co 61700 3 BB TSD 3,356.00 Net BB 194.20 DB 3 CR 3,161.80- Net 194.20 Ending Balance 70100 CENTRAL GARAGE 70100 CENTRAL GARAGE JE 45835 12/31/2006 70100 -1215 MISC ACCOUNTS RECEIVABLE 10,757.85 INSURANCE REC'D FOR 2006 Total 70100 -1215 BB TSD Net BB 10,757.85 DB CR 10,757.85 Net 10,757.85 Ending Balance Total BU 70100 BB TSD Net BB 10 DB CR 10,757.85 Net 10,757.85 Ending Balance Total Co 70100 BB TSD Net BB 10 DB CR 10,757.85 Net 10,757.85 Ending Balance R55GLACT2 LOGIS001 Activity by Co, BU, Object.Sub CITY OF BROOKLYN CENTER 4/6/2007 14:08:13 Ledger AA General Ledger Activity w Balances IN PROGRESS Page - 1 1/1/2006 - 12/31/2006 Object 1325 Doc Doc No GL Date Rec /Ck# Account Number Description Current DB Amount Current CR Amount GL Explanation / Remark Address Name 10100 GENERAL FUND 10100 GENERAL FUND JE 35247 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 597.50 HEAT GRANT REC'D 1/3/06 JE 35248 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 3,518.69 E911 DECEMBER 2005 GRANT JE 35491 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 15,082.96 DEC COURT FINES REC'D 1/18/06 JE 35494 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 768.00 SEC 8 HSG INSP DEC JE 35495 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 3,128.83 COMM TRIPSTERS - NEW HOPE JE 35855 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 3,518.69 E -911 GRANT FOR DECEMBER JE 35859 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 1,296.00 SEC 8 HSG INSP NOV 2005 JE 36241 1/1/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 1,326.00 CITY OF ROBBINSDALE 2/15/06 RC 35417 1/18/2006 28038 10100 -1325 DUE FROM OTHER GOVT UNITS 2,948.30 UNEMPLOYMENT REFUND STATE OF MN JE 45828 12/31/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 1,056.00 SECTION 8 INSP FOR NOV JE 45829 12/31/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 1,032.00 SECTION 8 INSP FOR DEC JE 45830 12/31/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 14,038.39 DEC COURT FINES JE 46322 12/31/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 1,599.92 VEST REIMB FROM STATE JE 46323 12/31/2006 10100 -1325 DUE FROM OTHER GOVT UNITS 399.98 VEST REIMB FROM STATE Total 10100 -1325 32,184.97 BB TSD 32,184.97 Net BB 18,126.29 DB 32,184.97 CR 14,058.68- Net 18,126.29 Ending Balance Total BU 10100 32 BB TSD 32,184.97 Net BB 18 DB 32 CR 14,058.68- Net 18,126.29 Ending Balance Total Co 10100 32 BB TSD 32,184.97 Net BB 18 DB 32 CR 14,058.68- Net 18,126.29 Ending Balance 28600 CITY INITIATIVES GRANT FUND 28600 CITY INITIATIVES GRANT FUND JE 35253 1/1/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 4,606.37 SAFE N SOBER RECD 1/4/06 JE 35254 1/1/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 2,465.44 PEACEMAKERS GRANT DECEMBER JE 35496 1/1/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 5,075.01 JABG GRANT RECEIVED 1/25/06 JE 36652 1/1/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 6,644.49 ACCRUE JAG GRANT EARNED JE 36886 1/1/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 25,191.18 ACCRUE AUTO THEFT GRANT RECS JE 46324 12/31/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 18,451.55 AUTO THEFT 123106 JE 46325 12/31/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 698.88 OPER NITE CAP 123106 JE 47434 12/31/2006 28600 -1325 DUE FROM OTHER GOVT UNITS 4,914.00 REC'VBLE FOR CADET -DPS GRANT Total 28600 -1325 43,982.49 BB TSD 43,982.49 Net BB 24,064.43 DB 43,982.49 CR 19,918.06- Net 24,064.43 Ending Balance Total BU 28600 43 BB TSD 43,982.49 Net BB 24 DB 43 CR 19,918.06- Net 24,064.43 Ending Balance Total Co 28600 43 BB TSD 43,982.49 Net BB 24 DB 43 CR 19,918.06- Net 24,064.43 Ending Balance 40200 MUNICIPAL STATE AID CONSTRUCT 40200 MUNICIPAL STATE AID CONSTRUCT R55GLACT2 LOGIS001 Activity by Co, BU, Object.Sub CITY OF BROOKLYN CENTER 4/6/2007 14:08:13 Ledger AA General Ledger Activity w Balances IN PROGRESS Page - 2 1/1/2006 - 12/31/2006 Object 1325 Doc Doc No GL Date Rec /Ck# Account Number Description Current DB Amount Current CR Amount GL Explanation / Remark Address Name Company 40200 Continued JE 35492 1/1/2006 40200 -1325 DUE FROM OTHER GOVT UNITS 56,884.00 MSA RECEIVED 01/18/06 JE 35493 1/1/2006 40200 -1325 DUE FROM OTHER GOVT UNITS 22,561.57 MSA RECEIVED 01/19/06 JE 36887 1/1/2006 40200 -1325 DUE FROM OTHER GOVT UNITS 13,587.48 MSA RECEIVED 2 -9 -06 JE 46321 12/31/2006 40200 -1325 DUE FROM OTHER GOVT UNITS 56,056.08 MSA REC'D 109 - 108 -007 Total 40200 -1325 93,033.05 BB TSD 93,033.05 Net BB 56,056.08 DB 93,033.05 CR 36,976.97- Net 56,056.08 Ending Balance Total BU 40200 93,033.05 BB TSD 93,033.05 Net BB 56,056.08 DB 93,033.05 CR 36,976.97- Net 56,056.08 Ending Balance Total Co 40200 93,033.05 BB TSD 93,033.05 Net BB 56,056.08 DB 93,033.05 CR 36,976.97- Net 56,056.08 Ending Balance 61700 EARLE BROWN HERITAGE CENTER 61700 EARLE BROWN HERITAGE CENTER RC 37808 4/5/2006 29409 61700 -1325 DUE FROM OTHER GOVT UNITS 14,933.00 AMENDED SALES TAX REFUND MN DEPT OF REVENUE Total 61700 -1325 14,933.00 BB TSD 14,933.00 Net BB DB 14,933.00 CR 14,933.00- Net Ending Balance Total BU 61700 14,933.00 BB TSD 14,933.00 Net BB DB 14,933.00 CR 14,933.00- Net Ending Balance Total Co 61700 14,933.00 BB TSD 14,933.00 Net BB DB 14,933.00 CR 14,933.00- Net Ending Balance R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 1 Company: 10100 GENERAL FUND Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61 -90 91 -120 Over 120 Customer: 121491 3D DOLLAR PLUS Phone Number: ( ) Credit Limit Insured Credit Limit RI 4419 10100 001 4/20/20065/20/2006 50.00 50.00 50.00 Customer: 121491 3D DOLLAR PLUS 50.00 50.00 50.00 Customer: 121096 CASTRO, LUIS IGLESIAS Phone Number: ( ) Credit Limit Insured Credit Limit RI 4160 10100 001 12/9/20051/8/2006 50.00 50.00 50.00 RI 4161 10100 001 12/9/20051/8/2006 75.00 75.00 75.00 RI 4162 10100 001 12/9/20051/8/2006 100.00 100.00 100.00 Customer: 121096 CASTRO, LUIS 225.00 225.00 225.00 IGLESIAS Customer: 119136 COMCAST Phone Number: ( ) Credit Limit Insured Credit Limit RI 5038 10100 001 1/26/20072/25/2007 200.00 200.00 200.00 Customer: 119136 COMCAST 200.00 200.00 200.00 Customer: 117511 DUO, ORA Phone Number: ( ) Credit Limit Insured Credit Limit RI 2684 10100 001 1/16/20042/15/2004 645.13 645.13 645.13 Customer: 117511 DUO, ORA 645.13 645.13 645.13 Customer: 121320 JENA, ELIE ANN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4290 10100 001 2/16/20063/18/2006 93.65 93.65 93.65 Customer: 121320 JENA, ELIE ANN 93.65 93.65 93.65 Customer: 101146 LOGIS Phone Number: ( ) Credit Limit Insured Credit Limit RI 5005 10100 001 12/22/200Q/1/2007 724.50 724.50 724.50 Customer: 101146 LOGIS 724.50 724.50 724.50 Customer: 118184 QWEST Phone Number: ( ) Credit Limit Insured Credit Limit RI 5039 10100 001 1/26/20072/25/2007 2,149.00 2,149.00 2,149.00 Customer: 118184 QWEST 2,149.00 2,149.00 2,149.00 Customer: 100530 RILEY RESIDENCE Phone Number: ( ) Credit Limit Insured Credit Limit RI 2692 10100 001 1/16/20042/15/2004 75.00 75.00 75.00 RI 2693 10100 001 1/16/20042/15/2004 100.00 100.00 100.00 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 2 Company: 10100 GENERAL FUND Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61 -90 91 -120 Over 120 RI 2694 10100 001 1/16/20042/15/2004 125.00 125.00 125.00 Customer: 100530 RILEY RESIDENCE 300.00 300.00 300.00 Customer: 122617 TCG MINNESOTA INC Phone Number: ( ) Credit Limit Insured Credit Limit RI 5037 10100 001 1/26/20072/25/2007 7,193.00 7,193.00 7,193.00 Customer: 122617 TCG MINNESOTA 7,193.00 7,193.00 7,193.00 INC Customer: 122616 UNDERGROUND PIERCING INC Phone Number: ( ) Credit Limit Insured Credit Limit RI 5036 10100 001 1/26/20072/25/2007 721.00 721.00 721.00 Customer: 122616 UNDERGROUND 721.00 721.00 721.00 PIERCING INC Customer: 121427 WEALTHSPRING MORTGAGE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4375 10100 001 4/3/2006 5/3/2006 50.00 50.00 50.00 RI 4376 10100 001 4/3/2006 5/3/2006 75.00 75.00 75.00 RI 4377 10100 001 4/3/2006 5/3/2006 100.00 100.00 100.00 RI 4420 10100 001 4/20/20065/20/2006 125.00 125.00 125.00 RI 4421 10100 001 4/20/20065/20/2006 150.00 150.00 150.00 RI 4465 10100 001 5/16/20066/15/2006 175.00 175.00 175.00 RI 4466 10100 001 5/16/20066/15/2006 200.00 200.00 200.00 RI 4467 10100 001 5/16/20066/15/2006 225.00 225.00 225.00 RI 4468 10100 001 5/16/20066/15/2006 250.00 250.00 250.00 Customer: 121427 WEALTHSPRING 1,350.00 1,350.00 1,350.00 MORTGAGE Company: 10100 GENERAL FUND 13,651.28 13,651.28 10,263.00 724.50 2,663.78 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 3 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 121695 1975 ROBERT STREET PARTNER Phone Number: ( ) Credit Limit Insured Credit Limit RI 4878 40700 001 10/24/200Q 1 /23/2006 100.00 100.00 100.00 Customer: 121695 1975 ROBERT 100.00 100.00 100.00 STREET PARTNER Customer: 121966 A- HAMEED, ABDULKAREE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4680 40700 001 7/31 /20068/30/2006 168.75 168.75 168.75 RI 4740 40700 001 9/1/2006 10/1/2006 180.00 180.00 180.00 RI 4740 40700 002 9/1/2006 10/1/2006 100.00 100.00 100.00 Customer: 121966 A- HAMEED, 448.75 448.75 448.75 ABDULKAREE Customer: 121697 AJASA, MONSURU Phone Number: ( ) Credit Limit Insured Credit Limit RI 4535 40700 001 6/8/2006 7/8/2006 112.50 112.50 112.50 RI 4911 40700 001 11/13/200Q2/13/2006 101.25 101.25 101.25 RI 4911 40700 00211/13/200Q2/13/2006 100.00 100.00 100.00 Customer: 121697 AJASA, MONSURU 313.75 313.75 201.25 112.50 Customer: 121700 BANKHEAD, CURTIS & CECILYN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4539 40700 001 6/8/2006 7/8/2006 135.00 135.00 135.00 RI 4671 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 RI 4702 40700 001 8/11 /20069/10/2006 101.25 101.25 101.25 Customer: 121700 BANKHEAD, CURTIS 336.25 336.25 336.25 & CECILYN Customer: 121705 BEN -EL- HAFFAF, WHAMED Phone Number: ( ) Credit Limit Insured Credit Limit RI 4544 40700 001 6/8/2006 7/8/2006 135.00 135.00 135.00 Customer: 121705 BEN -EL- HAFFAF, 135.00 135.00 135.00 WHAMED Customer: 121693 BENNETT, ELIZABETH Phone Number: ( ) Credit Limit Insured Credit Limit RI 4531 40700 001 6/8/2006 7/8/2006 112.50 112.50 112.50 RI 4797 40700 001 9/26/200610/26/2006 100.00 100.00 100.00 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 4 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 121693 BENNETT, 212.50 212.50 100.00 112.50 ELIZABETH Customer: 100362 BONIFACE, JACK Phone Number: ( ) Credit Limit Insured Credit Limit RI 4546 40700 001 6/8/2006 7/8/2006 112.50 112.50 112.50 Customer: 100362 BONIFACE, JACK 112.50 112.50 112.50 Customer: 122254 BONILLA, MARINA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4833 40700 001 10/6/200611/5/2006 100.00 100.00 100.00 Customer: 122254 BONILLA, MARINA 100.00 100.00 100.00 Customer: 122382 BREWER, JAVAIL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4908 40700 001 11/13/20002/13/2006 112.50 112.50 112.50 RI 4908 40700 00211/13/20002/13 /2006 100.00 100.00 100.00 Customer: 122382 BREWER, JAVAIL 212.50 212.50 212.50 Customer: 122091 BROOKLYN CENTER LLC Phone Number: ( ) Credit Limit Insured Credit Limit RI 4741 40700 001 9/1/2006 10/1/2006 112.50 112.50 112.50 Customer: 122091 BROOKLYN CENTER 112.50 112.50 112.50 LLC Customer: 121683 BROWN, DION Phone Number: ( ) Credit Limit Insured Credit Limit RI 4520 40700 001 6/8/2006 7/8/2006 90.00 90.00 90.00 RI 4625 40700 001 7/13/20068/12/2006 100.00 100.00 100.00 RI 4625 40700 002 7/13/20068/12/2006 112.50 112.50 112.50 RI 4750 40700 001 9/1/2006 10/1/2006 90.00 90.00 90.00 RI 4750 40700 002 9/1/2006 10/1/2006 100.00 100.00 100.00 RI 4876 40700 001 10/24/20001/23/2006 135.00 135.00 135.00 RI 4876 40700 002 10/24/20001/23/2006 100.00 100.00 100.00 Customer: 121683 BROWN, DION 727.50 727.50 235.00 492.50 Customer: 121701 CALHOUN, JOHN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4540 40700 001 6/8/2006 7/8/2006 135.00 135.00 135.00 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 5 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 RI 4906 40700 001 11/13/20002/13/2006 90.00 90.00 90.00 RI 4906 40700 00211/13/20002/13 /2006 100.00 100.00 100.00 Customer: 121701 CALHOUN, JOHN 325.00 325.00 190.00 135.00 Customer: 122315 CHRISTOPHER, DONALD Phone Number: ( ) Credit Limit Insured Credit Limit RI 4877 40700 001 10/24/20001/23/2006 100.00 100.00 100.00 Customer: 122315 CHRISTOPHER, 100.00 100.00 100.00 DONALD Customer: 121692 CIPRIANO, WUILBERTH Phone Number: ( ) Credit Limit Insured Credit Limit RI 4530 40700 001 6/8/2006 7/8/2006 135.00 135.00 135.00 Customer: 121692 CIPRIANO, 135.00 135.00 135.00 WUILBERTH Customer: 122146 CORBITT, BRETT Phone Number: ( ) Credit Limit Insured Credit Limit RI 4776 40700 001 9/14/200610/14/2006 100.00 100.00 100.00 Customer: 122146 CORBITT, BRETT 100.00 100.00 100.00 Customer: 121699 DEBAR, NATHANIEL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4538 40700 001 6/8/2006 7/8/2006 135.00 135.00 135.00 RI 4744 40700 001 9/1/2006 10/1/2006 100.00 100.00 100.00 Customer: 121699 DEBAR, NATHANIEL 235.00 235.00 235.00 Customer: 121696 DIXON, SHAWN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4534 40700 002 6/8/2006 7/8/2006 90.00 90.00 90.00 Customer: 121696 DIXON, SHAWN 90.00 90.00 90.00 Customer: 121736 DOLL, EDWARD Phone Number: ( ) Credit Limit Insured Credit Limit RI 4770 40700 001 9/14/200610/14/2006 100.00 100.00 100.00 Customer: 121736 DOLL, EDWARD 100.00 100.00 100.00 Customer: 122190 EDWARDS, ERROL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4792 40700 001 9/26/200610/26/2006 90.00 90.00 90.00 RI 4792 40700 002 9/26/200610/26/2006 100.00 100.00 100.00 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 6 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 122190 EDWARDS, ERROL 190.00 190.00 190.00 Customer: 121690 ERDAHL, THEODORE /ELLIOTT /LINDA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4528 40700 001 6/8/2006 7/8/2006 157.50 157.50 157.50 Customer: 121690 ERDAHL, 157.50 157.50 157.50 THEODORE /ELLIOTT /LINDA Customer: 100028 EVANSON, DAVID Phone Number: ( ) Credit Limit Insured Credit Limit RI 4547 40700 001 6/8/2006 7/8/2006 247.50 247.50 247.50 RI 4790 40700 001 9/26/200610/26/2006 247.50 247.50 247.50 RI 4790 40700 002 9/26/200610/26/2006 100.00 100.00 100.00 Customer: 100028 EVANSON, DAVID 595.00 595.00 347.50 247.50 Customer: 121698 EVANSON, MELBA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4537 40700 001 6/8/2006 7/8/2006 270.00 270.00 270.00 Customer: 121698 EVANSON, MELBA 270.00 270.00 270.00 Customer: 122044 FLOYD, ROBERTA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4708 40700 001 8/21 /20069/20/2006 112.50 112.50 112.50 RI 4713 40700 001 8/21 /20069/20/2006 100.00 100.00 100.00 Customer: 122044 FLOYD, ROBERTA 212.50 212.50 212.50 Customer: 121687 GROVES, TIMOTHY Phone Number: ( ) Credit Limit Insured Credit Limit RI 4524 40700 001 6/8/2006 7/8/2006 112.50 112.50 112.50 Customer: 121687 GROVES, TIMOTHY 112.50 112.50 112.50 Customer: 122250 HANSON, JOEL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4827 40700 001 10/6/200611/5/2006 135.00 135.00 135.00 RI 4827 40700 002 10/6/200611/5/2006 100.00 100.00 100.00 Customer: 122250 HANSON, JOEL 235.00 235.00 235.00 Customer: 121877 HARTFIEL, ROBERT Phone Number: ( ) Credit Limit Insured Credit Limit RI 4615 40700 001 7/13/20068/12/2006 112.50 112.50 112.50 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 7 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 RI 4673 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 RI 4709 40700 001 8/21 /20069/20/2006 112.50 112.50 112.50 RI 4875 40700 001 10/24/20001 /23/2006 135.00 135.00 135.00 RI 4875 40700 002 10/24/20001/23/2006 100.00 100.00 100.00 Customer: 121877 HARTFIEL, ROBERT 560.00 560.00 235.00 325.00 Customer: 121681 HIMMEL, JOEL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4517 40700 001 6/8/2006 7/8/2006 90.00 90.00 90.00 RI 4551 40700 001 6/16/20067/16/2006 985.13 985.13 985.13 Customer: 121681 HIMMEL, JOEL 1,075.13 1,075.13 1,075.13 Customer: 121702 HINES, ANTHONY Phone Number: ( ) Credit Limit Insured Credit Limit RI 4541 40700 001 6/8/2006 7/8/2006 112.50 112.50 112.50 RI 4799 40700 001 9/26/200610/26/2006 112.50 112.50 112.50 RI 4799 40700 002 9/26/200610/26/2006 100.00 100.00 100.00 Customer: 121702 HINES, ANTHONY 325.00 325.00 212.50 112.50 Customer: 122383 JENKINS, DERRYL & ROBERTA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4909 40700 001 11/13/20002/13/2006 157.50 157.50 157.50 Customer: 122383 JENKINS, DERRYL 157.50 157.50 157.50 & ROBERTA Customer: 120653 LAO, MATHA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4873 40700 001 10/24/20001/23/2006 146.25 146.25 146.25 RI 4873 40700 002 10/24/20001/23/2006 100.00 100.00 100.00 Customer: 120653 LAO, MATHA 246.25 246.25 246.25 Customer: 122196 LEAVITT, DAVID & CAROLINE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4801 40700 001 9/26/200610/26/2006 101.25 101.25 101.25 RI 4801 40700 002 9/26/200610/26/2006 100.00 100.00 100.00 Customer: 122196 LEAVITT, DAVID & 201.25 201.25 201.25 CAROLINE R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 8 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 120533 LEMM, CHAD Phone Number: ( ) Credit Limit Insured Credit Limit RI 4677 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 Customer: 120533 LEMM, CHAD 100.00 100.00 100.00 Customer: 122095 LODAHL, MARY Phone Number: ( ) Credit Limit Insured Credit Limit RI 4746 40700 001 9/1/2006 10/1/2006 90.00 90.00 90.00 Customer: 122095 LODAHL, MARY 90.00 90.00 90.00 Customer: 121686 MACKE, STEVEN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4523 40700 001 6/8/2006 7/8/2006 90.00 90.00 90.00 Customer: 121686 MACKE, STEVEN 90.00 90.00 90.00 Customer: 122139 MALZAHN, NINA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4768 40700 001 9/14/200610/14/2006 100.00 100.00 100.00 Customer: 122139 MALZAHN, NINA 100.00 100.00 100.00 Customer: 122194 MARIOVICH, JERRY Phone Number: ( ) Credit Limit Insured Credit Limit RI 4796 40700 001 9/26/200610/26/2006 90.00 90.00 90.00 RI 4796 40700 002 9/26/200610/26/2006 100.00 100.00 100.00 Customer: 122194 MARIOVICH, JERRY 190.00 190.00 190.00 Customer: 121737 MARTIN, LEONARD Phone Number: ( ) Credit Limit Insured Credit Limit RI 4747 40700 001 9/1/2006 10/1/2006 112.50 112.50 112.50 RI 4747 40700 002 9/1/2006 10/1/2006 100.00 100.00 100.00 Customer: 121737 MARTIN, LEONARD 212.50 212.50 212.50 Customer: 121960 MARTIN, MARIBEL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4670 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 RI 4670 40700 002 7/31 /20068/30/2006 123.75 123.75 123.75 RI 4872 40700 001 10/24/200Q 1 /23/2006 123.75 123.75 123.75 RI 4872 40700 002 10/24/200Q1/23/2006 100.00 100.00 100.00 Customer: 121960 MARTIN, MARIBEL 447.50 447.50 223.75 223.75 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 9 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 121880 MATTHEWS, SHANNON Phone Number: ( ) Credit Limit Insured Credit Limit RI 4620 40700 001 7/13/20068/12/2006 100.00 100.00 100.00 Customer: 121880 MATTHEWS, 100.00 100.00 100.00 SHANNON Customer: 122090 MCLAIN, ALAKHI Phone Number: ( ) Credit Limit Insured Credit Limit RI 4739 40700 001 9/1/2006 10/1/2006 135.00 135.00 135.00 RI 4739 40700 002 9/1/2006 10/1/2006 100.00 100.00 100.00 Customer: 122090 MCLAIN, ALAKHI 235.00 235.00 235.00 Customer: 122094 MCNEIL, THERESA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4745 40700 001 9/1/2006 10/1/2006 101.25 101.25 101.25 Customer: 122094 MCNEIL, THERESA 101.25 101.25 101.25 Customer: 121682 METROPOLITAN CAPITAL VENTURE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4519 40700 001 6/8/2006 7/8/2006 90.00 90.00 90.00 Customer: 121682 METROPOLITAN 90.00 90.00 90.00 CAPITAL VENTURE Customer: 121881 MOORE, GERALDINE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4621 40700 001 7/13/20068/12/2006 135.00 135.00 135.00 RI 4874 40700 001 10/24/200Q 1 /23/2006 112.50 112.50 112.50 RI 4874 40700 002 10/24/200Q 1 /23/2006 100.00 100.00 100.00 Customer: 121881 MOORE, GERALDINE 347.50 347.50 212.50 135.00 Customer: 122144 MOORE, OVETTA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4774 40700 001 9/14/200610/14/2006 100.00 100.00 100.00 Customer: 122144 MOORE, OVETTA 100.00 100.00 100.00 Customer: 122007 NEVALA, JACK & TINA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4698 40700 001 8/11 /20069/10/2006 274.25 274.25 274.25 Customer: 122007 NEVALA, JACK & 274.25 274.25 274.25 TINA Customer: 121883 NYAKUNDI, PATRICK Phone Number: ( ) Credit Limit Insured Credit Limit R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 10 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 RI 4623 40700 001 7/13/20068/12/2006 135.00 135.00 135.00 Customer: 121883 NYAKUNDI, 135.00 135.00 135.00 PATRICK Customer: 122045 OESTREICH, ERIC Phone Number: ( ) Credit Limit Insured Credit Limit RI 4710 40700 001 8/21 /20069/20/2006 90.00 90.00 90.00 Customer: 122045 OESTREICH, ERIC 90.00 90.00 90.00 Customer: 121962 OGUNLEYE, OSAMWANYI Phone Number: ( ) Credit Limit Insured Credit Limit RI 4675 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 RI 4711 40700 001 8/21 /20069/20/2006 146.25 146.25 146.25 Customer: 121962 OGUNLEYE, 246.25 246.25 246.25 OSAMWANYI Customer: 121706 OLDENBURG, RICHAR & SANDRA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4545 40700 001 6/8/2006 7/8/2006 135.00 135.00 135.00 RI 4672 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 Customer: 121706 OLDENBURG, 235.00 235.00 235.00 RICHAR & SANDRA Customer: 122189 OLLESTAD, ERIC Phone Number: ( ) Credit Limit Insured Credit Limit RI 4791 40700 001 9/26/200610/26/2006 146.25 146.25 146.25 Customer: 122189 OLLESTAD, ERIC 146.25 146.25 146.25 Customer: 100892 OMAN, ZEV Phone Number: ( ) Credit Limit Insured Credit Limit RI 4616 40700 001 7/13/20068/12/2006 135.00 135.00 135.00 RI 4826 40700 001 10/6/200611/5/2006 90.00 90.00 90.00 RI 4826 40700 002 10/6/200611/5/2006 90.00 90.00 90.00 RI 4826 40700 003 10/6/200611/5/2006 100.00 100.00 100.00 Customer: 100892 OMAN, ZEV 415.00 415.00 280.00 135.00 Customer: 122252 OSTERLUND, CARL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4830 40700 001 10/6/200611/5/2006 100.00 100.00 100.00 Customer: 122252 OSTERLUND, CARL 100.00 100.00 100.00 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 11 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 122314 REEVES, JOSEPH & ALBERTHA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4871 40700 001 10/24/200Q 1 /23/2006 1,062.87 1,062.87 1,062.87 Customer: 122314 REEVES, JOSEPH & 1,062.87 1,062.87 1,062.87 ALBERTHA Customer: 121704 ROONEY, JOSEPH Phone Number: ( ) Credit Limit Insured Credit Limit RI 4543 40700 001 6/8/2006 7/8/2006 90.00 90.00 90.00 Customer: 121704 ROONEY, JOSEPH 90.00 90.00 90.00 Customer: 122191 ROYLE, AIMEE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4793 40700 001 9/26/200610/26/2006 90.00 90.00 90.00 Customer: 122191 ROYLE, AIMEE 90.00 90.00 90.00 Customer: 122142 SAUNDERS, KEVIN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4772 40700 001 9/14/200610/14/2006 100.00 100.00 100.00 Customer: 122142 SAUNDERS, KEVIN 100.00 100.00 100.00 Customer: 122145 SCULLY, PAUL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4775 40700 001 9/14/200610/14/2006 100.00 100.00 100.00 Customer: 122145 SCULLY, PAUL 100.00 100.00 100.00 Customer: 121684 SIMMONS, CHRISTOPHER Phone Number: ( ) Credit Limit Insured Credit Limit RI 4521 40700 001 6/8/2006 7/8/2006 90.00 90.00 90.00 RI 4624 40700 001 7/13/20068/12/2006 100.00 100.00 100.00 RI 4624 40700 002 7/13/20068/12/2006 135.00 135.00 135.00 Customer: 121684 SIMMONS, 325.00 325.00 325.00 CHRISTOPHER Customer: 121884 SIPRASEUTH, STHIANE & NETTA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4627 40700 001 7/13/20068/12/2006 100.00 100.00 100.00 RI 4627 40700 002 7/13/20068/12/2006 135.00 135.00 135.00 RI 4828 40700 001 10/6/200611/5/2006 112.50 112.50 112.50 RI 4828 40700 002 10/6/200611/5/2006 100.00 100.00 100.00 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 12 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 121884 SIPRASEUTH, 447.50 447.50 212.50 235.00 STHIANE & NETTA Customer: 122192 SPENCE, WILLIAM & SUSAN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4794 40700 001 9/26/200610/26/2006 168.75 168.75 168.75 Customer: 122192 SPENCE, WILLIAM 168.75 168.75 168.75 & SUSAN Customer: 122197 STEVENS, MARVIN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4802 40700 001 9/26/200610/26/2006 100.00 100.00 100.00 Customer: 122197 STEVENS, MARVIN 100.00 100.00 100.00 Customer: 121961 THELEN, TORY Phone Number: ( ) Credit Limit Insured Credit Limit RI 4674 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 Customer: 121961 THELEN, TORY 100.00 100.00 100.00 Customer: 122047 THOMAS, JONATHAN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4714 40700 001 8/21 /20069/20/2006 100.00 100.00 100.00 Customer: 122047 THOMAS, JONATHAN 100.00 100.00 100.00 Customer: 122089 THOMAS, KEVIN Phone Number: ( ) Credit Limit Insured Credit Limit RI 4738 40700 001 9/1/2006 10/1/2006 157.50 157.50 157.50 RI 4738 40700 002 9/1/2006 10/1/2006 100.00 100.00 100.00 Customer: 122089 THOMAS, KEVIN 257.50 257.50 257.50 Customer: 121691 VANG, THAO & MAI Phone Number: ( ) Credit Limit Insured Credit Limit RI 4529 40700 001 6/8/2006 7/8/2006 112.50 112.50 112.50 RI 4626 40700 001 7/13/20068/12/2006 100.00 100.00 100.00 RI 4626 40700 002 7/13/20068/12/2006 135.00 135.00 135.00 Customer: 121691 VANG, THAO & MAI 347.50 347.50 347.50 Customer: 122141 VANSLYKE, TODD & DIANNE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4771 40700 001 9/14/200610/14/2006 100.00 100.00 100.00 RI 4831 40700 001 10/6/200611/5/2006 100.00 100.00 100.00 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 13 Company: 40700 INFRASTRUCTURE CONSTRUCTION Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 122141 VANSLYKE, TODD & 200.00 200.00 100.00 100.00 DIANNE Customer: 121964 VASQUEZ, GENARO & JESSICA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4678 40700 001 7/31 /20068/30/2006 100.00 100.00 100.00 Customer: 121964 VASQUEZ, GENARO 100.00 100.00 100.00 & JESSICA Customer: 121685 VERGARA, AGUSTIN & YESENIA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4522 40700 001 6/8/2006 7/8/2006 90.00 90.00 90.00 Customer: 121685 VERGARA, AGUSTIN 90.00 90.00 90.00 & YESENIA Customer: 122381 VUE, LOR PAO Phone Number: ( ) Credit Limit Insured Credit Limit RI 4907 40700 001 11/13/200Q2/13/2006 90.00 90.00 90.00 Customer: 122381 VUE, LO R PAO 90.00 90.00 90.00 Customer: 121968 WELLES, JASON Phone Number: ( ) Credit Limit Insured Credit Limit RI 4682 40700 001 7/31 /20068/30/2006 135.00 135.00 135.00 Customer: 121968 WELLES, JASON 135.00 135.00 135.00 Customer: 122043 WERNER, JOANNE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4707 40700 001 8/21 /20069/20/2006 146.25 146.25 146.25 Customer: 122043 WERNER, JOANNE 146.25 146.25 146.25 Customer: 121879 WHITE, MASON Phone Number: ( ) Credit Limit Insured Credit Limit RI 4619 40700 001 7/13/20068/12/2006 100.00 100.00 100.00 Customer: 121879 WHITE, MASON 100.00 100.00 100.00 Customer: 122093 YANG, KAO Phone Number: ( ) Credit Limit Insured Credit Limit RI 4743 40700 001 9/1/2006 10/1/2006 100.00 100.00 100.00 Customer: 122093 YANG, KAO 100.00 100.00 100.00 Company: 40700 INFRASTRUCTURE 16,329.75 16,329.75 851.25 3,442.87 2,446.25 9,589.38 CONSTRUCTION R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 14 Company: 60100 WATER UTILITY FUND Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 121738 AJUWON, TIFFANY Phone Number: ( ) Credit Limit Insured Credit Limit RI 4561 60100 001 6/16/20067/16/2006 1,068.39 1,068.39 1,068.39 Customer: 121738 AJUWON, TIFFANY 1,068.39 1,068.39 1,068.39 Customer: 122504 METROPOLITAN COURIER CORPORATION Phone Number: ( ) Credit Limit Insured Credit Limit RI 5004 60100 001 12/22/2000/21/2007 2,981.95 2,981.95 2,981.95 Customer: 122504 METROPOLITAN 2,981.95 2,981.95 2,981.95 COURIER CORPORATION Customer: 122462 SPRINT Phone Number: ( ) Credit Limit Insured Credit Limit RI 4965 60100 001 12/7/20061/6/2007 75,580.71 23,618.84 23,618.84 RC 34543 12/29/2006 51,961.87 - Customer: 122462 SPRINT 23,618.84 23,618.84 23,618.84 Customer: 119022 VERIZON WIRELESS Phone Number: ( ) Credit Limit Insured Credit Limit RI 4966 60100 001 12/7/20061/6/2007 23,618.97 1,124.71 1,124.71 RC 34544 12/29/2006 22,494.26 - Customer: 119022 VERIZON WIRELESS 1,124.71 1,124.71 1,124.71 Customer: 111565 XM SATELLITE RADIO INC Phone Number: ( ) Credit Limit Insured Credit Limit RI 4967 60100 001 12/7/20061/6/2007 23,618.97 23,618.97 23,618.97 Customer: 111565 XM SATELLITE 23,618.97 23,618.97 23,618.97 RADIO INC Company: 60100 WATER UTILITY FUND 52,412.86 52,412.86 51,344.47 1,068.39 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 15 Company: 60200 SEWER UTILITY FUND Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 100288 SEARS AUTO Phone Number: ( ) Credit Limit Insured Credit Limit RI 4667 60200 001 7/31/20068/30/2006 16,142.54 16,142.54 16,142.54 Customer: 100288 SEARS AUTO 16,142.54 16,142.54 16,142.54 Company: 60200 SEWER UTILITY FUND 16,142.54 16,142.54 16,142.54 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 16 Company: 61700 EARLE BROWN HERITAGE CENTER Aging Date 12/31/2006 ..........Document.......... Invoice G/L Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 122491 AGA MEDICAL Phone Number: ( ) Credit Limit Insured Credit Limit RI 5007 61700 001 12/15/20002/29/2006 8,332.75 8,332.75 8,332.75 Customer: 122491 AGA MEDICAL 8,332.75 8,332.75 8,332.75 Customer: 122493 ALBU, ELIZABETH Phone Number: ( ) Credit Limit Insured Credit Limit RI 5010 61700 001 12/16/20002/29/2006 17.11 17.11 17.11 Customer: 122493 ALBU, ELIZABETH 17.11 17.11 17.11 Customer: 121047 ASSOCIATION FOR FACILITIES MANAGERS Phone Number: ( ) Credit Limit Insured Credit Limit RI 4945 61700 001 11/13/20001/30/2006 10,602.80 10,602.80 10,602.80 Customer: 121047 ASSOCIATION FOR 10,602.80 10,602.80 10,602.80 FACILITIES MANAGERS Customer: 100500 BAE SYSTEMS Phone Number: ( ) Credit Limit Insured Credit Limit RI 5001 61700 001 12/13/20002/19/2006 4,662.66 31.13 31.13 RC 18669H 12/20/2006 4,631.53 - Customer: 100500 BAE SYSTEMS 31.13 31.13 31.13 Customer: 100991 BERG,JACKIE Phone Number: ( ) Credit Limit Insured Credit Limit RI 1675 61700 001 9/21/20029/30/2002 387.15 387.15 387.15 Customer: 100991 BERG,JACKIE 387.15 387.15 387.15 Customer: 100538 BUREAU OF EDUCATION & RESEARCH Phone Number: ( ) Credit Limit Insured Credit Limit RI 4957 61700 001 11 /28/20001 /30/2006 392.51 392.51 392.51 RI 4960 61700 001 11 /29/20001 /30/2006 826.69 826.69 826.69 Customer: 100538 BUREAU OF 1,219.20 1,219.20 1,219.20 EDUCATION & RESEARCH Customer: 122527 CARLSON, SUE Phone Number: ( ) Credit Limit Insured Credit Limit RI 5013 61700 001 12/30/20002/31/2006 957.71 957.71 957.71 Customer: 122527 CARLSON, SUE 957.71 957.71 957.71 Customer: 100114 CITY OF BROOKLYN CENTER Phone Number: ( ) Credit Limit Insured Credit Limit R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 17 Company: 61700 EARLE BROWN HERITAGE CENTER Aging Date 12/31/2006 ..........Document.......... Invoice G/L Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 RI 4988 61700 001 12/6/200612/19/2006 971.32 971.32 971.32 Customer: 100114 CITY OF BROOKLYN 971.32 971.32 971.32 CENTER Customer: 122484 ENERVATION Phone Number: ( ) Credit Limit Insured Credit Limit RI 4982 61700 001 12/8/200612/15/2006 4,188.62 4,188.62 4,188.62 Customer: 122484 ENERVATION 4,188.62 4,188.62 4,188.62 Customer: 100773 FAIRVIEW HEALTH SERVICES Phone Number: ( ) Credit Limit Insured Credit Limit RI 4995 61700 001 12/13/200Q2/19/2006 19,942.12 19,942.12 19,942.12 Customer: 100773 FAIRVIEW HEALTH 19,942.12 19,942.12 19,942.12 SERVICES Customer: 100073 Fox Productions Phone Number: ( ) Credit Limit Insured Credit Limit RI 1247 61700 001 3/12/20023/31/2002 2,000.00 1,250.00 1,250.00 RC 13577 4/7/2003 100.00 - RC 13932A 7/14/2003 33.33 - RS 8950 7/31/2003 16.67 - RC 14014 8/5/2003 33.33 - RC 14109 9/4/2003 33.33 - RC 14238 10/6/2003 66.67 - RS 10209 9/30/2003 16.67 - RC 14367 11/6/2003 33.33 - RC 14444 12/8/2003 66.67 - RS 11871 12/31/2003 33.33 - RC 14928H 5/7/2004 166.67 - RC 15075H 6/10/2004 33.33 - RC 15287H 8/5/2004 33.33 - RC 15393H 9/9/2004 66.67 - RS 19131 8/31/2004 16.67 - RI 1376 61700 001 5/20/20025/31/2002 2,131.20 1,947.87 1,947.87 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 18 Company: 61700 EARLE BROWN HERITAGE CENTER Aging Date 12/31/2006 ..........Document.......... Invoice G/L Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 RS 11255 11/30/2003 50.00 - RS 18561 7/31/2004 100.00 - RS 19641 9/30/2004 33.33 - Customer: 100073 Fox Productions 3,197.87 3,197.87 3,197.87 Customer: 121087 FRANDSEN FINANCIAL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4994 61700 001 12/12/20002/19/2006 1,599.38 1,599.38 1,599.38 Customer: 121087 FRANDSEN 1,599.38 1,599.38 1,599.38 FINANCIAL Customer: 118202 FRED PRYOR SEMINARS Phone Number: ( ) Credit Limit Insured Credit Limit RI 4999 61700 001 12/13/20002/19/2006 388.90 388.90 388.90 Customer: 118202 FRED PRYOR 388.90 388.90 388.90 SEMINARS Customer: 101049 GENERAL MILLS Phone Number: ( ) Credit Limit Insured Credit Limit RI 4996 61700 001 12/13/20002/19/2006 713.21 713.21 713.21 Customer: 101049 GENERAL MILLS 713.21 713.21 713.21 Customer: 119014 HAROLD EATMON MINISTRIES Phone Number: ( ) Credit Limit Insured Credit Limit RI 4937 61700 001 11/10/20001/16/2006 5,859.96 1,000.00 1,000.00 RC 18645H 12/13/2006 4,859.96 - RI 5014 61700 001 12/31/20002/31/2006 4,366.28 4,366.28 4,366.28 RM 34214 61700 001 11 /11 /20001 /30/2006 1,000.00- 1,000.00- 1,000.00 - Customer: 119014 HAROLD EATMON 4,366.28 4,366.28 4,366.28 MINISTRIES Customer: 120514 HENNEPIN COUNTY PUBLIC HEALTH Phone Number: ( ) Credit Limit Insured Credit Limit RI 4883 61700 001 10/17/2000 0/27/2006 2,137.62 2,137.62 2,137.62 Customer: 120514 HENNEPIN COUNTY 2,137.62 2,137.62 2,137.62 PUBLIC HEALTH Customer: 122492 HENNEPIN COUNTY SHERIFFS' DEPT. ASSN. Phone Number: ( ) Credit Limit Insured Credit Limit RI 5009 61700 001 12/16/20002/29/2006 8,028.48 7,375.80 7,375.80 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 19 Company: 61700 EARLE BROWN HERITAGE CENTER Aging Date 12/31/2006 ..........Document.......... Invoice G/L Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 RS 123106 H -D 12/31/2006 652.68 - Customer: 122492 HENNEPIN COUNTY 7,375.80 7,375.80 7,375.80 SHERIFFS' DEPT. ASSN. Customer: 100063 IMAGINE! PRINT SOLUTIONS Phone Number: ( ) Credit Limit Insured Credit Limit RI 5008 61700 001 12/16/200Q2/29/2006 33,500.02 33,500.02 33,500.02 Customer: 100063 IMAGINE! PRINT 33,500.02 33,500.02 33,500.02 SOLUTIONS Customer: 111621 ISLAMIC CENTER OF MN Phone Number: ( ) Credit Limit Insured Credit Limit RI 5015 61700 001 12/31/200Q2/31/2006 2,326.62 2,326.62 2,326.62 Customer: 111621 ISLAMIC CENTER 2,326.62 2,326.62 2,326.62 OF MN Customer: 100065 JACKSON - DAWSON COMMUNICATIONS Phone Number: ( ) Credit Limit Insured Credit Limit RI 5011 61700 001 12/19/200Q2/28/2006 15,792.71 15,792.71 15,792.71 Customer: 100065 JACKSON - DAWSON 15,792.71 15,792.71 15,792.71 COMMUNICATIONS Customer: 122257 LAI INTERNATIONAL Phone Number: ( ) Credit Limit Insured Credit Limit RI 4837 61700 001 10/2/200610/11/2006 53.25 53.25 53.25 RI 4913 61700 001 11/l/200611/10/2006 1,285.06 1,285.06 1,285.06 RI 4973 61700 001 12/l/200612/8/2006 1,285.06 1,285.06 1,285.06 Customer: 122257 LAI 2,623.37 2,623.37 1,285.06 1,285.06 53.25 INTERNATIONAL Customer: 100302 MEDTRONIC Phone Number: ( ) Credit Limit Insured Credit Limit RI 4961 61700 001 11 /30/200Q 1 /30/2006 1,367.70 1,367.70 1,367.70 RI 4993 61700 001 12/12/200Q2/19/2006 1,200.69 1,200.69 1,200.69 RI 5003 61700 001 12/14/200Q2/19/2006 5,862.26 5,862.26 5,862.26 Customer: 100302 MEDTRONIC 8,430.65 8,430.65 7,062.95 1,367.70 Customer: 101108 MEDTRONIC Phone Number: ( ) Credit Limit Insured Credit Limit RI 4981 61700 001 12/6/200612/15/2006 442.41 442.41 442.41 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 20 Company: 61700 EARLE BROWN HERITAGE CENTER Aging Date 12/31/2006 ..........Document.......... Invoice G/L Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 RM 34744 61700 001 12/31 /20002/31 /2006 63.90- 63.90- 63.90 - Customer: 101108 MEDTRONIC 378.51 378.51 63.90- 442.41 Customer: 120777 MEDTRONIC Phone Number: ( ) Credit Limit Insured Credit Limit RI 4992 61700 001 12/12/20002/19/2006 11,886.97 11,886.97 11,886.97 Customer: 120777 MEDTRONIC 11,886.97 11,886.97 11,886.97 Customer: 122488 MN ASSOCIATION OF REALTORS Phone Number: ( ) Credit Limit Insured Credit Limit RI 4991 61700 001 12/11/20002/19/2006 15,637.89 15,637.89 15,637.89 Customer: 122488 MN ASSOCIATION 15,637.89 15,637.89 15,637.89 OF REALTORS Customer: 119358 MN COUNCIL OF TEACHERS OF LANGUAGE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4884 61700 001 10/20/20000/27/2006 18,885.00 18,860.00 18,860.00 RS 123106 H -C 12/31/2006 25.00 - Customer: 119358 MN COUNCIL OF 18,860.00 18,860.00 18,860.00 TEACHERS OF LANGUAGE Customer: 100576 MN INSTITUTE LEGAL EDUCATION Phone Number: ( ) Credit Limit Insured Credit Limit RI 2143 61700 001 5/9/2003 5/29/2003 1,957.76 1,957.76 1,957.76 RI 2145 61700 001 5/16/20035/29/2003 2,132.89 2,132.89 2,132.89 RI 2156 61700 001 5/22/20035/29/2003 1,848.94 1,848.94 1,848.94 RI 2201 61700 001 6/13/20036/26/2003 1,963.47 1,963.47 1,963.47 RI 2219 61700 001 6/26/20036/30/2003 2,275.65 2,275.65 2,275.65 Customer: 100576 MN INSTITUTE 10,178.71 10,178.71 10,178.71 LEGAL EDUCATION Customer: 101087 MNHSWA Phone Number: ( ) Credit Limit Insured Credit Limit RI 4983 61700 001 12/8/200612/15/2006 3,976.24 3,976.24 3,976.24 Customer: 101087 MNHSWA 3,976.24 3,976.24 3,976.24 Customer: 100509 NATIONAL KARATE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4975 61700 001 12/2/200612/8/2006 1,176.62 1,176.62 1,176.62 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 21 Company: 61700 EARLE BROWN HERITAGE CENTER Aging Date 12/31/2006 ..........Document.......... Invoice G/L Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 100509 NATIONAL KARATE 1,176.62 1,176.62 1,176.62 Customer: 119147 NETWORTH Phone Number: ( ) Credit Limit Insured Credit Limit RI 4932 61700 001 11/9/200611/16/2006 6,015.23 6,015.23 6,015.23 Customer: 119147 NETWORTH 6,015.23 6,015.23 6,015.23 Customer: 100026 NORTH MEMORIAL MEDICAL CENTER Phone Number: ( ) Credit Limit Insured Credit Limit RI 4934 61700 001 11/9/200611/16/2006 3,804.26 3,804.26 3,804.26 Customer: 100026 NORTH MEMORIAL 3,804.26 3,804.26 3,804.26 MEDICAL CENTER Customer: 119060 NYSTROM Phone Number: ( ) Credit Limit Insured Credit Limit RI 4984 61700 001 12/8/200612/15/2006 8,370.98 8,370.98 8,370.98 Customer: 119060 NYSTROM 8,370.98 8,370.98 8,370.98 Customer: 101062 OFFICE MAX Phone Number: ( ) Credit Limit Insured Credit Limit RI 4855 61700 001 10/11/200Q0/20/2006 4,081.48 4,081.48 4,081.48 Customer: 101062 OFFICE MAX 4,081.48 4,081.48 4,081.48 Customer: 100330 SISTER KENNY INSTITUTE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4930 61700 001 11/8/200611/16/2006 9,554.98 9,554.98 9,554.98 Customer: 100330 SISTER KENNY 9,554.98 9,554.98 9,554.98 INSTITUTE Customer: 100986 STAFF DEVELOPMENT RESOURCES Phone Number: ( ) Credit Limit Insured Credit Limit RI 4972 61700 001 12/l/200612/8/2006 566.91 566.91 566.91 RI 4990 61700 001 12/7/200612/19/2006 606.55 579.93 579.93 RS 123106 H -E 12/31/2006 26.62 - Customer: 100986 STAFF 1,146.84 1,146.84 1,146.84 DEVELOPMENT RESOURCES Customer: 121088 TSI Phone Number: ( ) Credit Limit Insured Credit Limit RI 4153 61700 00212/3/200512/1 /2005 RI 4978 61700 001 12/2/200612/8/2006 12,761.39 12,761.39 12,761.39 R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 22 Company: 61700 EARLE BROWN HERITAGE CENTER Aging Date 12/31/2006 ..........Document.......... Invoice G/L Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 121088 TSI 12,761.39 12,761.39 12,761.39 Customer: 122360 WHEATON, TOYEE & PRINCE Phone Number: ( ) Credit Limit Insured Credit Limit RI 4898 61700 001 10/28/200Q 0/31 /2006 2,533.63 333.63 333.63 RC 18594H 11/27/2006 1,700.00 - RC 18636H 12/11/2006 500.00 - Customer: 122360 WHEATON, TOYEE & 333.63 333.63 333.63 PRINCE Company: 61700 EARLE BROWN 237,266.07 237,266.07 7,586.71 156,600.42 33,849.23 25,465.98 13,763.73 HERITAGE CENTER R0313420113 CITY OF BROOKLYN CENTER 4/6/2007 14:04:07 LOG00004 A/R Details with Aging Page- 23 Company: 70100 CENTRAL GARAGE Aging Date 12/31/2006 ..........Document.......... Invoice Due Date/ Ty Number Company Item Date Check Date Original Amount Open Amount Current 1 -30 31 -60 61-90 91 - 120 Over 120 Customer: 101017 IND SCHOOL DISTRICT 286 Phone Number: ( ) Credit Limit Insured Credit Limit RI 5040 70100 001 1/26/20072/25/2007 3,589.82 3,589.82 3,589.82 Customer: 101017 IND SCHOOL 3,589.82 3,589.82 3,589.82 DISTRICT 286 Company: 70100 CENTRAL GARAGE 3,589.82 3,589.82 3,589.82 Grand Total 339,392.32 339,392.32 21,439.53 208,669.39 34,700.48 28,908.85 2,446.25 43,227.82 City of Brooklyn Center Enterprise Funds Analytical Information 12/31/2006 2005 2006 Water Utility Fund Water Rates $1.07/1, 000 gal $1.11 /1, 000 gal Gallons pumped 1 1,317,319,000 Gallons billed 1,109,230,124 1 connections 8 8 accounts billed 8 8 Sanitary Sewer Fund connections 8 8 accounts billed 8 8 rates $57.17/res qtr $59.46/res qtr Storm Sewer Fund accounts billed 8 8 rates $11.85 /res qtr $11.85 /res qtr Municipal Liquor Fund Golf Course Fund 20780 Number of rounds played a 2 211 100 rate per round $9.82 $10.00 EBHC Fund rentals 579 559 rate changes? Recycling and Refuse Fund rates $7.05 /res qtr $7.35 /res qtr accounts billed 8 8 Street Light Utility Fund rates $3.21 /res qtr $3.21 /res qtr accounts billed 8 81610 CITY OF BROOKLYN CENTER CERTIFIED UB 12/31/2006 Spring -06 Fall -06 Per resolution 165 151 adjustments (14,813.29) -8.97% - 0.00% Removed from U B 150 151, 761.57 adjustments 0.00% 0.00% Actual certification to Assessing 150 151 Prepayments March 6 - April 9, 332.54 - May 1, 831.44 - June 1 - July 2, 000.93 - August 1 - September 3 7 October 1 4 November 3 3 December - - Certified to County 119, 310.33 135, 960.06 ALLOWANCE FOR UNCOLLECTIBLE ACCOUNTS 61700 -1232 12/31/2006 A/R at 12 -31 -04 298, 086.71 Identified doubtful accounts (See attached) (13,764.00) 284, 322.71 x 2.5% 7,108.00 Plus identified doubtful accounts 13 Allowance for uncollectible accounts 20 CONVENTION CENTER CATERING INN TOTAL 2006 Sales Revenue 946 3 63 4 % of Total Sales 22.52% 75.96% 1.52% 100.00% Allocation of identified accounts 2 10 - 13 Allocation of the balance 1 5 108 7 Allocation 4 16 108 20 49852 -6436 49853 -6436 49855 -6436 61700 -1232 CONVENTION CENTER CATERING INN TOTAL Reverse entry at 12 -31 -04 (4 (18,185) (88) (22,772) Allowance at 12 -31 -06 4 16 108 20 Expense Required to Adjust ADA (114) (1,806) 20 (1,900) IDENTIFIED DOUBTFUL ACCOUNTS 12/31/2006 ORIGINAL INVOICE AMOUNT Bal Due CC Cater Inn Total Charges Berg, Jackie 387.15 159.75 11 - 11 MN Institute Legal Education 10 1 8 10 Fox Production 3 4 7 11 Total 13, 763.73 6 26, 797.00 - 33, 587.21 20.22% 79.78% 0.00% 100.00% ALLOCATION OF BALANCE DUE: 2 10, 980.70 - 13, 763.73 BANKRUPTCY RECEIVABLE 2006 Amount Written Off Date Date Account Written off Fire Storm Street Written off Chapter Number Name Address UB System Lines Recycling Drainage Sewer Lights Water Penalties Total G/L 13 212275000903 Roberts 1012 Woodbine Lane 5/18/2006 14.70 23.70 118.92 6.62 41.52 61.63 267.09 13 607401000703 Retic 5329 Irving Ave N 5/18/2006 7.35 11.85 59.46 3.31 86.15 16.81 184.93 7 608044000805 Qualey 5637 Bryant Ave N 5/18/2006 7.05 11.85 57.17 3.21 23.54 31.13 133.95 (7.05) (11.85) (57.17) (3.21) (23.54) (31.13) (133.95) 12/27/2006 7 608078010602 Baribeau 5537 Aldrich Ave N 10/4/2006 7.35 11.85 59.46 3.31 16.43 98.40 (7.35) (11.85) (59.46) (3.31) (16.43) (98.40) 12/27/2006 13 100437010008 Taylor 7205 Perry Ct E 11/2/2006 14.70 23.70 118.92 6.62 56.18 37.43 257.55 13 607379000504 Stensrud 5436 James Ave N 12/29/2006 14.70 23.70 118.92 6.62 68.16 13.17 245.27 Total - 51.45 82.95 416.22 23.17 252.01 129.04 954.84 DA OEM 07 LLAR E) FOR RENT V ❑FOR ACCT. i CASH FROM TO i PAID CHECK MONEY DUE I ' ❑ORDER B � January 4, 2007 Mr. Janis Blumental Mr, Jim Moy Blumental`s Architecture 6235 Earle Brown Drive Brooklyn Center, MN-55430 Dear Janis and Jim: • The November 2006 CPI figures for CPI -U, U.S. City Average was listed as 201.5. This is an increase over the November 2004 CPI figure of 190.9. The base rent is then increased for this lease as of December 1, 2006 per Section 3.2 O (ii)15 The rental amount for the next twenty -four month period from December 1, 2006 to December 1, 2008, will be $45,590.37 annually or $3,,799.20 monthly. Please let me know if you have any questions. As always, we value your presence at the Earle Brown Heritage Center. Sincerely, lw P Judith L. Berg eland General Manager JB Cc: Curt Boganey, Assistant City Manager DAT 0j'j WA q4 Fran Hanson, City Staff Accountant Account Summa For Transactions Between: 12/1/2005 and 12/3112006 Account Number Account Name Total WIdrawals Total Deposits Balance Comments 1270 Anderson, Dennis $1.74 $421.46 $419.72 health insurance is for spouse 1225 Dirks, Robert $5,411.39 $4,991.67 ($419.72) 1227 Downer, Joel $11,973-44 $11,973-44 $0.00 1230 Giving, Gary $386.40 $386 $0.00 1235 Hennessy, Mary G $5,036.64 $4,991.67 ($44.97) underpaid January and February, made up January, waiting for February additional (dif bltw 2005 & 2006 premium) 1248 Moen, Andrew $6,391.84 $6,433.84 $42.00 overbilled /overpaid January, February, March optional life insurance 1249 Mueller, Jean $339.40 $339.40 $0.00 1253 Ploumen, Barbara $5,411.39 $4,991.67 ($419.72) 1255 Rayl Jr, John R $386.40 $386.40 $0.00 1265 Tombers, David A $14,714.52 $14 $0.00 1267 Weeks, Gregory $10,643.88 $10,643.88 $0.00 Grand Total ($422.69) y ,Ilk �•. Y Wednesday, January l7, 2007 Page .I of I