HomeMy WebLinkAbout03 - Cash City of Brooklyn Center
Combined Bank Reconciliation
12/31 /2007
Beginning Ending
Balance Debits Credits Balance
Balance per Wells Fargo Statement 609 1 (2 552
6, 851, 787.20 (6
Deposits in Transit - general acct 147 (147,424.77) -
342, 688.42 342, 688.42
Credit Card Deposits in Transit 23 (23,833.91) -
47, 840.41 47, 840.41
InvestAccount Activity Outstanding 63 (4 5 575
O/S taxes 98, 945.03 (98, 945.03) -
Missing Sept Cashbar deposit 307.00 (307.00) -
Deposit Correction - -
Outstanding Checks - general acct (304,593.12) 304 -
(210, 373.63) (210, 373.63)
Payroll zero balance activity 36, 742, 592.76 910, 741.90 37,653, 334.66
Payroll disbursements (36,881,232.41) (792,901.68) (37
Ledger Balance 500, 327.77 3,673, 926.53 (2, 886, 969.95) 1,287,284.35
Bank Balance 0.00 910 (910,741.90) 0.00
Payroll sweep activity (36, 742, 592.76) (910, 741.90) (37, 653, 334.66)
0.00 0.00
O/S State taxes (16, 631.73) 16, 631.73 0.00
O/S Fed tax pymt (81, 958.04) 81, 958.04 0.00
O/S Deferred comp (355.26) 0.00 (355.26)
Outstanding Checks - payroll acct (39,694.62) 39 0.00
(20,444.17) (20,444.17)
Payroll disbursements 36 792 37
0.00 0.00 0.00 0.00
g: \depts\ finance \cashrpts \cityrpts \bank_rec.xls
CITY OF BROOKLYN CENTER
CASH AND INVESTMENTS BY FUND
12/31/2007
12/31/2007 12/31/2006
MAJOR FUNDS:
GENERAL FUND:
GENERAL 8 7
PAYROLL 87 80
TOTAL GENERAL - UNRESTRICTED 8,317,016.93 7,857,238.92
INVESTMENT FUND - PERFORMANCE DEPOSITS 161 234
TOTAL GENERAL - RESTRICTED 161,000.00 234,210.00
SPECIAL REVENUE FUNDS:
TIF DISTRICT #3 12,754,462.42 20,306,744.71
DEBT SERVICE FUND:
SPECIAL ASSESSMENT BONDS
GO IMPROVEMENT BONDS -1996A - 483
GO IMPROVEMENT BONDS -1997A 408 117
GO IMPROVEMENT BONDS -1998A 267 300
GO IMPROVEMENT BONDS -1999A 302 344
GO IMPROVEMENT BONDS -2000A 500 519
GO IMPROVEMENT BONDS -2001A 348 374
GO IMPROVEMENT BONDS -2003A 278 293
GO IMPROVEMENT BONDS -2004C 415 416
GO IMPROVEMENT BONDS -2006A 495 237
TOTAL SPECIAL ASSESSMENT BONDS 3,018,165.07 3,087,980.41
CAPITAL PROJECTS FUNDS:
INFRASTRUCTURE CONSTRUCTION (1,054,562.70) (262,206.46)
ENTERPRISE FUNDS:
MUNICIPAL LIQUOR
MUNICIPAL LIQUOR 1,199,464.77 949,471.34
GOLF COURSE
CENTERBROOK GOLF COURSE 50,970.20 81,900.13
EARLE BROWN HERITAGE CENTER
EARLE BROWN HERITAGE CENTER 1,151,029.56 1,141,255.45
WATER UTILITY
WATER UTILITY 2,068,788.11 1,811,509.16
SANITARY SEWER UTILITY
SANITARY SEWER UTILITY 2A64J 15.60 1,926,733.32
STORM SEWER UTILITY
STORM SEWER UTILITY 1,380,820.45 1,353,495.69
Cash and investments by fund 1
CITY OF BROOKLYN CENTER
CASH AND INVESTMENTS BY FUND
12/31/2007
12/31/2007 12/31/2006
NONMAJOR FUNDS:
SPECIAL REVENUE FUNDS:
H RA - -
E DA 1, 831, 552.30 1, 824, 738.84
EARLE BROWN TIF DISTRICT
TIF DISTRICT #1 7 410
TIF DISTRICT #2 297 5
304 415
TIF DISTRICT #4 126 95
POLICE FORFEITURE - 48
CDBG - 4
CITY INITIATIVES GRANT 65 140
TOTAL SPECIAL REVENUE FUNDS 2,328,271.16 2,529,748.23
DEBT SERVICE FUND:
GENERAL OBLIGATION BONDS
GO BLDG BONDS - POL &FIRE REF - 2004A 1 1
GO TAX INCREMENT BONDS
GO TAX INCREMENT REF -2004B - -
GO TAX INCREMENT BONDS -2004D 2 -
2, 534, 809.00 -
TOTAL DEBT SERVICE FUNDS 3,691,209.23 1,097,603.13
CAPITAL PROJECTS FUNDS:
CAPITAL RESERVE EMERGENCY FUND 1 1
CAPITAL IMPROVEMENTS FUND 635 584
MUNICIPAL STATE AID CONSTRUCT 60 262
EBHC CAPITAL FUND 422 260
STREET RECONSTRUCTION 1 1
TECHNOLOGY FUND 540 486
TOTAL CAPITAL PROJECT FUNDS 4,484,302.29 4,736,330.79
ENTERPRISE FUNDS:
RECYCLING 767.51 5
STREET LIGHT UTILITY 154 102
TOTAL ENTERPRISE FUNDS 154,858.18 107,666.85
INTERNAL SERVICE FUNDS:
CENTRAL GARAGE 4 5
EMPLOYEE RETIREMENT BENEFIT 1 1
COMPENSATED ABSENCES 1 964
TOTAL INTERNAL SERVICE FUNDS 6,836,295.18 7,488,355.47
TOTAL ALL FUNDS 49 54
Cash and investments by fund 2
CITY OF BROOKLYN CENTER
CASH AND INVESTMENTS BY FUND
12/31/2007
12/31/2007 12/31/2006
COMPONENTS OF CASH AND INVESTMENTS:
General Checking 1 86
Payroll Checking - -
Petty Cash and Change Funds 8 8
4M Fund 8 10
4M Plus Fund 9 16
WF Investments 29 27
Accrued Interest 116 128
49 54
Cash and investments - Statement 1 48 54
Restricted Cash and investments - Statement 1 161 234
49 54
Cash and investments by fund 3
December
City of Brooklyn Center
Cash Deposit Report
For the Month of December
Administration Recreation EBHC Golf Liquor Store Total JV Balance
Date Deposit Deposit Deposit Cards Cash bar Deposit Cards Deposit Cards Deposits Number Debit Amount Credit Amount 500,327.77
1 707.25 - - 1,354.00 16,980.13 13,033.37 32,074.75 532,402.52
2 98.50 - - - - 98.50 532,501.02
3 20,198.81 823.25 23,321.84 17,523.10 7,887.45 4,514.69 74,269.14 606,770.16
4 32,999.36 6,762.69 - - 6,995.06 5,118.00 51,875.11 658,645.27
5 21,224.24 674.00 65,677.89 3,324.80 7,519.02 4,479.48 102,899.43 761,544.70
6 18,827.94 491.00 - - 236.00 8,488.03 4,966.74 33,009.71 12/6 register 231,626.34 562,928.07
7 12,090.09 609.75 20,275.00 4.00 14,339.17 9,762.51 57,080.52 12/7 FF payroll 51,834.93 568,173.66
8 210.75 - - 4,617.50 17,659.09 13,553.48 36,040.82 604,214.48
9 139.50 - - - - 139.50 604,353.98
10 44,058.02 2,167.62 14,677.82 17,393.31 7,595.93 4,710.06 90,602.76 694,956.74
11 32,121.29 491.05 - - 499.30 7,452.19 5,202.16 45,765.99 DOLI payment 1,802.72 738,920.01
12 39,326.70 1,178.50 9,647.46 346.27 6,973.07 4,359.67 61,831.67 800,751.68
13 15,667.23 337.75 1,625.00 1,512.13 4.50 8,501.67 5,781.21 33,429.49 12/13 register 382,234.99 451,946.18
14 13,277.00 754.00 - - 16,684.89 11,539.01 42,254.90 12/14 payroll 374,698.02 119,503.06
15 749.50 - - 3,080.25 18,615.48 12,686.77 35,132.00 12/14 4M transfer 700,000.00 854,635.06
16 318.25 - - - - 318.25 854,953.31
17 31,346.42 885.33 26,211.15 5,691.29 9,981.11 6,180.20 80,295.50 935,248.81
18 134,182.11 23,308.40 2,308.52 (2,984.42) 7,807.85 6,652.04 171,274.50 1,106,523.32
19 13,070.69 577.75 - - 8,312.56 6,204.12 28,165.12 Sales Tax 63,202.00 1,071,486.44
20 22,980.86 432.75 6,554.78 - 9,805.91 9,575.65 49,349.95 12/20 register 925,633.22 195,203.16
21 15,431.84 552.61 4,587.90 - 18,219.41 17,057.60 55,849.36 251,052.52
22 213.75 - 100.00 24,097.31 22,979.19 47,390.25 298,442.77
23 108.50 - - - - 108.50 298,551.27
24 1,988.49 70.25 - - 22,820.72 22,209.34 47,088.80 12/24 4M transfer 700,000.00 1,045,640.08
25 - - - - - 1,045,640.08
26 107,068.37 275.40 - - 305.00 8,237.06 4,667.93 120,553.76 1,166,193.84
27 26,913.54 219.75 72,637.08 3,708.91 9,255.57 6,150.20 118,885.05 12/27 register 381,087.17 903,991.71
28 15,000.86 2,344.75 1,375.14 2,141.62 15,691.76 10,086.68 46,640.81 12/28 payroll 500,000.00 366,368.73 1,084,263.80
29 458.00 - - 2,896.50 18,412.74 15,523.25 37,290.49 12/28 4M transfer 1,121,554.29
30 96.00 - - - - 96.00 1,121,650.29
31 144,862.07 303.25 53,537.27 - 729.80 42,049.36 28,848.76 270,330.51 1,391,980.80
1,391,980.80
1,391,980.80
Interest 800.97 1,392,781.77
Void Checks (47.93) 1,392,829.70
Cash Bar 1,392,829.70
NSF Checks 653.66 1,392,176.04
CC fees 5,639.65 1,386,536.39
Misc bank Corr 1,386,536.39
98,945.03 1,287,591.36
0.01 1,287,591.35
Write off cash bar 1,287,591.35
deposit from Sept 07 1,287,591.35
(not posted by bank) (307.00) 1,287,284.35
1,287,284.35
1,287,284.35
Deposits 1,770,141.14
Total 762,635.93 46,359.85 302,436.85 48,761.01 13,417.85 305.00 - 340,382.54 255,842.11 1,770,141.14 Other debits 1,900,493.97
Totals 3,670,635.11 2,883,678.54 1,287,284.35
Total 46,359.85 351,197.86 13,417.85 305.00 596,224.65
Deposits 1,465,538.02
CC Deposit 304,603.12
Deposits in Transit = 342,688.42 Totals 1,770,141.14
Page 1
CITY OF BROOKLYN CENTER
TEST FOR PLEDGED COLLATERAL
12/31/07
Wells Fargo Bank - City as custodian
Cash Bank Balance 12/31/07
General Account 000 - 1000008 552
Payroll Account 000 - 1000016 0.00
552, 669.00
FDIC Coverage - $100,000 per custodian 100
Total Cash & CDs requiring pledged collateral 452
Amount of Required Collateral (110 %) 497
Pledged Collateral by the bank 754
Excess (deficit) Collateral 256, 967.05
Collateral coverage
PAGE czs
WELLS FAR-GO PLEDGE REPORT
COLLATERAL Pon Mza BROOKLYN CENTER, czrx OF
rATo, DECEMBER 31 2007 DEPOszzuar INeTI=Imu. xFcALIr
� �� SEQ. �' �� FACE CURRENT FACE DESCRIPTION R� �� * � MARKET ��
FEDERAL RESERVE BANK
58 3140BEFDe 002150 1 743 FNcL 848964 a.00 01/01/36 754,902 95
Page 1 of 14
WELLS FARGO BANK, N.A.
PUBLIC ENTITIES SPECIALTY MARKET Account Number: 000 - 1010016
POST OFFICE BOX B 514 1010016
MINNEAPOLIS, MN 55479 Statement Start Date: 12/01/07
Statement End Date: 12/31/07
CITY OF BROOKLYN CENTER
GENERAL FUND
6301 SHINGLE CREEK PKWY
MINNEAPOLIS MN 55430 -2113
For Customer Assistance:
Call 800 - 225 -5935 (1- 800 - CALL - WELLS).
-------------------------------------------------------------------------------
Account Number Beginning Balance Ending Balance
Choice IV- Public Funds
{nib}
000 - 1010016 609,542.00 552,669.00
-------------------------------------------------------------------------------
News from Wells Fargo
Introducing Security Questions
In the coming months, we'll ask all online customers to make their accounts
even safer by selecting and answering three security questions. If we ever need
to confirm your identity, your correct answers to these questions will help us
verify it's you. To learn more, visit our Security Questions Overview at
www. wellsfargo .com /securityquestions
Quick and easy to set up, security questions help protect your account and keep
your identity safe.
-------------------------------------------------------------------------------
Credits
Deposits
Effective Posted
Date Date Amount Transaction Detail
Dec 03 2 Deposit
Dec 04 70,677.31 Deposit
Dec 04 16,980.13 Deposit
Dec 05 23,321.84 Deposit
Dec 10 65,677.89 Deposit
Dec 12 20,275.00 Deposit
Dec 12 14,677.82 Deposit
Dec 12 499.30 Deposit
Dec 14 9 Deposit
Dec 17 1 Deposit
Dec 19 26,211.15 Deposit
Dec 20 2 Deposit
Dec 24 22,980.86 Deposit
Dec 24 6 Deposit
Dec 27 4 Deposit
Dec 28 72,637.08 Deposit
.......................................... ...............................
360,832.04 Total Deposits
-------------------------------------------------------------------------------
Continued on next page
Page 2 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Deposits/ Bank Credits
Effective Posted
Date Date Amount Transaction Detail
Dec 03 63,507.83 Stagecoach Sweep Credit
Dec 03 24,992.01 Cash Deposited - Post Verify
Dec 03 8 Cash Deposited - Post Verify
Dec 03 6 Cash Deposited - Post Verify
Dec 03 513.06 Cash Deposited - Post Verify
Dec 03 8 12 /03Bankcard Deposit
- 0329033000
Dec 03 3 12 /03Bankcard Deposit
- 0329033000
Dec 03 3 12 /03Bankcard Deposit
- 0329033001
Dec 03 1 12 /03Bankcard Deposit
- 0329033001
Dec 03 113.79 American Express Settlement
071203 3220009393 Brooklyn
CTR3220009393
Dec 03 65.98 American Express Settlement
071201 3220009393 Brooklyn
CTR3220009393
Dec 03 20.84 Stagecoach Sweep Interest
Payment
Dec 04 32,547.98 Stagecoach Sweep Credit
Dec 04 17,003.63 Cash Deposited - Post Verify
Dec 04 16,472.20 Cash Deposited - Post Verify
Dec 04 707.25 Cash Deposited - Post Verify
Dec 04 697.50 Cash Deposited - Post Verify
Dec 04 98.50 Cash Deposited - Post Verify
Dec 04 6 12 /04Bankcard Deposit
- 0329033004
Dec 04 6 12 /04Bankcard Deposit
- 0329033000
Dec 04 3 12 /04Bankcard Deposit
- 0329033001
Dec 04 3.56 Stagecoach Sweep Interest
Payment
Dec 05 52,511.70 Stagecoach Sweep Credit
Dec 05 20,198.81 Cash Deposited - Post Verify
Dec 05 7 Cash Deposited - Post Verify
Dec 05 1 Cash Deposited - Post Verify
Dec 05 823.25 Cash Deposited - Post Verify
Dec 05 17,523.10 12 /05Bankcard Deposit
- 0329033004
Dec 05 5 12 /05Bankcard Deposit
- 0329033000
Dec 05 1 12 /05Bankcard Deposit
- 0329033001
Dec 05 5.65 Stagecoach Sweep Interest
Payment
Dec 06 27,278.54 Stagecoach Sweep Credit
Dec 06 32,999.36 Cash Deposited - Post Verify
Dec 06 6 Cash Deposited - Post Verify
Dec 06 3 12 /06Bankcard Deposit
- 0329033000
Dec 06 1 12 /06Bankcard Deposit
- 0329033001
Dec 06 104.81 American Express Settlement
071206 3220009393 Brooklyn
CTR3220009393
Dec 06 2.89 Stagecoach Sweep Interest
Payment
Dec 07 70,311.14 Stagecoach Sweep Credit
Dec 06 Dec 07 6 Cash Deposited - Post Verify
-------------------------------------------------------------------------------
Continued on next page
Page 3 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Deposits/ Bank Credits
Effective Posted
Date Date Amount Transaction Detail
Dec 07 21,224.24 Cash Deposited - Post Verify
Dec 07 7 Cash Deposited - Post Verify
Dec 07 674.00 Cash Deposited - Post Verify
Dec 07 2 12 /07Bankcard Deposit
- 0329033000
Dec 07 1 12 /07Bankcard Deposit
- 0329033001
Dec 07 69.02 American Express Settlement
071207 3220009393 Brooklyn
CTR3220009393
Dec 07 7.45 Stagecoach Sweep Interest
Payment
Dec 10 76,518.10 Stagecoach Sweep Credit
Dec 10 18,827.94 Cash Deposited - Post Verify
Dec 10 491.00 Cash Deposited - Post Verify
Dec 10 6 12 /10Bankcard Deposit
- 0329033000
Dec 10 3 12 /10Bankcard Deposit
- 0329033000
Dec 10 2 12 /10Bankcard Deposit
- 0329033001
Dec 10 1 12 /10Bankcard Deposit
- 0329033001
Dec 10 4.00 12 /10Bankcard Deposit
- 0329033004
Dec 10 3 American Express Settlement
071210 3224714741 Earl Brown
H3224714741
Dec 10 71.99 American Express Settlement
071210 3220009393 Brooklyn
CTR3220009393
Dec 10 61.23 American Express Settlement
071208 3220009393 Brooklyn
CTR3220009393
Dec 10 23.91 Stagecoach Sweep Interest
Payment
Dec 11 74,570.37 Stagecoach Sweep Credit
Dec 11 17,393.31 12 /11Bankcard Deposit
- 0329033004
Dec 11 9 12 /11Bankcard Deposit
- 0329033000
Dec 11 4 12 /11Bankcard Deposit
- 0329033001
Dec 11 40.36 American Express Settlement
071211 3220009393 Brooklyn
CTR3220009393
Dec 11 7.77 Stagecoach Sweep Interest
Payment
Dec 12 79,385.66 Stagecoach Sweep Credit
Dec 12 44,058.02 Cash Deposited - Post Verify
Dec 12 17,659.09 Cash Deposited - Post Verify
Dec 12 14,339.17 Cash Deposited - Post Verify
Dec 12 11,759.88 Cash Deposited - Post Verify
Dec 12 8 Cash Deposited - Post Verify
Dec 12 7 Cash Deposited - Post Verify
Dec 12 4 Cash Deposited - Post Verify
Dec 12 2 Cash Deposited - Post Verify
Dec 12 609.75 Cash Deposited - Post Verify
Dec 12 330.21 Cash Deposited - Post Verify
Dec 12 236.00 Cash Deposited - Post Verify
Dec 12 210.75 Cash Deposited - Post Verify
Dec 12 139.50 Cash Deposited - Post Verify
-------------------------------------------------------------------------------
Continued on next page
Page 4 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Deposits/ Bank Credits
Effective Posted
Date Date Amount Transaction Detail
Dec 12 2 12 /12Bankcard Deposit
- 0329033000
Dec 12 1 12 /12Bankcard Deposit
- 0329033001
Dec 12 7.86 Stagecoach Sweep Interest
Payment
Dec 13 69,714.59 Stagecoach Sweep Credit
Dec 13 32,121.29 Cash Deposited - Post Verify
Dec 13 7 Cash Deposited - Post Verify
Dec 13 491.05 Cash Deposited - Post Verify
Dec 13 3 12 /13Bankcard Deposit
- 0329033000
Dec 13 1 12 /13Bankcard Deposit
- 0329033001
Dec 13 346.27 12 /13Bankcard Deposit
- 0329033004
Dec 13 228.96 American Express Settlement
071213 3220009393 Brooklyn
CTR3220009393
Dec 13 7.02 Stagecoach Sweep Interest
Payment
Dec 14 136,067.02 Stagecoach Sweep Credit
Dec 14 700,000.00 WT Fed #00690 U.S. Bank,N.A.
/ORG =4M Fund Main Fund Account
Srf# 071214006218
Trn #071214027735 Rfb#
071214006218
Dec 14 39,326.70 Cash Deposited - Post Verify
Dec 14 1 Cash Deposited - Post Verify
Dec 14 2 12 /14Bankcard Deposit
- 0329033000
Dec 14 1 12 /14Bankcard Deposit
- 0329033001
Dec 14 8.39 American Express Settlement
071214 3220009393 Brooklyn
CTR3220009393
Dec 14 13.70 Stagecoach Sweep Interest
Payment
Dec 17 490,346.46 Stagecoach Sweep Credit
Dec 17 15,667.23 Cash Deposited - Post Verify
Dec 17 337.75 Cash Deposited - Post Verify
Dec 17 4.50 Cash Deposited - Post Verify
Dec 17 8 12 /17Bankcard Deposit
- 0329033000
Dec 17 4 12 /17Bankcard Deposit
- 0329033000
Dec 17 3 12 /17Bankcard Deposit
- 0329033001
Dec 17 1 12 /17Bankcard Deposit
- 0329033001
Dec 17 750.00 12 /17Bankcard Deposit
- 0329033004
Dec 17 762.13 American Express Settlement
071217 3224714741 Earl Brown
H3224714741
Dec 17 177.95 American Express Settlement
071217 3220009393 Brooklyn
CTR3220009393
Dec 17 43.60 American Express Settlement
071215 3220009393 Brooklyn
CTR3220009393
-------------------------------------------------------------------------------
Continued on next page
Page 5 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Deposits/ Bank Credits
Effective Posted
Date Date Amount Transaction Detail
Dec 17 150.68 Stagecoach Sweep Interest
Payment
Dec 18 375,184.17 Stagecoach Sweep Credit
Dec 18 18,615.48 Cash Deposited - Post Verify
Dec 18 16,684.89 Cash Deposited - Post Verify
Dec 18 13,277.00 Cash Deposited - Post Verify
Dec 18 8 Cash Deposited - Post Verify
Dec 18 6 Cash Deposited - Post Verify
Dec 18 754.00 Cash Deposited - Post Verify
Dec 18 749.50 Cash Deposited - Post Verify
Dec 18 318.25 Cash Deposited - Post Verify
Dec 18 8 12 /18Bankcard Deposit
- 0329033000
Dec 18 3 12 /18Bankcard Deposit
- 0329033001
Dec 18 2 12 /18Bankcard Deposit
- 0329033004
Dec 18 15.92 American Express Settlement
071218 3220009393 Brooklyn
CTR3220009393
Dec 18 38.43 Stagecoach Sweep Interest
Payment
Dec 19 254,618.67 Stagecoach Sweep Credit
Dec 19 31,346.42 Cash Deposited - Post Verify
Dec 19 9 Cash Deposited - Post Verify
Dec 19 885.33 Cash Deposited - Post Verify
Dec 19 4 12 /19Bankcard Deposit
- 0329033000
Dec 19 1 12 /19Bankcard Deposit
- 0329033001
Dec 19 25.20 Stagecoach Sweep Interest
Payment
Dec 20 206,024.69 Stagecoach Sweep Credit
Dec 20 134,182.11 Cash Deposited - Post Verify
Dec 20 23,308.40 Cash Deposited - Post Verify
Dec 20 7 Cash Deposited - Post Verify
Dec 20 3 Cash Deposited - Post Verify
Dec 20 3 12 /20Bankcard Deposit
- 0329033000
Dec 20 2 12 /20Bankcard Deposit
- 0329033001
Dec 20 2 American Express Settlement
071220 3224714741 Earl Brown
H3224714741
Dec 20 121.80 American Express Settlement
071220 3220009393 Brooklyn
CTR3220009393
Dec 20 19.31 Stagecoach Sweep Interest
Payment
Dec 21 167,625.14 Stagecoach Sweep Credit
Dec 21 3 12 /21Bankcard Deposit
- 0329033000
Dec 21 2 12 /21Bankcard Deposit
- 0329033001
Dec 21 88.64 American Express Settlement
071221 3220009393 Brooklyn
CTR3220009393
Dec 21 16.30 Stagecoach Sweep Interest
Payment
Dec 24 43,983.05 Stagecoach Sweep Credit
-------------------------------------------------------------------------------
Continued on next page
Page 6 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Deposits/ Bank Credits
Effective Posted
Date Date Amount Transaction Detail
Dec 24 700,000.00 WT Fed #01298 U.S. Bank,N.A.
/ORG =4M Fund Main Fund Account
Srf# 071224013499
Trn #071224041273 Rfb#
071224013499
Dec 24 13,070.69 Cash Deposited - Post Verify
Dec 24 8 Cash Deposited - Post Verify
Dec 24 577.75 Cash Deposited - Post Verify
Dec 24 432.75 Cash Deposited - Post Verify
Dec 24 12,198.07 12 /24Bankcard Deposit
- 0329033000
Dec 24 6 12 /24Bankcard Deposit
- 0329033000
Dec 24 4 12 /24Bankcard Deposit
- 0329033001
Dec 24 2 12 /24Bankcard Deposit
- 0329033001
Dec 24 238.45 American Express Settlement
071222 3220009393 Brooklyn
CTR3220009393
Dec 24 62.12 American Express Settlement
071224 3220009393 Brooklyn
CTR3220009393
Dec 24 13.52 Stagecoach Sweep Interest
Payment
Dec 26 807,039.58 Stagecoach Sweep Credit
Dec 26 16,505.58 12 /26Bankcard Deposit
- 0329033000
Dec 26 6 12 /26Bankcard Deposit
- 0329033001
Dec 26 129.95 American Express Settlement
071225 3220009393 Brooklyn
CTR3220009393
Dec 26 100.00 American Express Settlement
071225 3224714741 Earl Brown
H3224714741
Dec 26 162.53 Stagecoach Sweep Interest
Payment
Dec 27 491,032.64 Stagecoach Sweep Credit
Dec 27 24,097.31 Cash Deposited - Post Verify
Dec 27 22,820.72 Cash Deposited - Post Verify
Dec 27 18,219.41 Cash Deposited - Post Verify
Dec 27 15,431.84 Cash Deposited - Post Verify
Dec 27 9 Cash Deposited - Post Verify
Dec 27 1 Cash Deposited - Post Verify
Dec 27 16,797.31 12 /27Bankcard Deposit
- 0329033000
Dec 27 6 12 /27Bankcard Deposit
- 0329033001
Dec 27 454.25 American Express Settlement
071227 3220009393 Brooklyn
CTR3220009393
Dec 27 48.59 Stagecoach Sweep Interest
Payment
Dec 28 534,480.51 Stagecoach Sweep Credit
Dec 28 500,000.00 WT Fed #01158 U.S. Bank,N.A.
/ORG =4M Fund Main Fund Account
Srf# 071228010005
Trn #071228040807 Rfb#
071228010005
Dec 28 107,068.37 Cash Deposited - Post Verify
Dec 28 552.61 Cash Deposited - Post Verify
-------------------------------------------------------------------------------
Continued on next page
Page 7 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Deposits/ Bank Credits
Effective Posted
Date Date Amount Transaction Detail
Dec 28 275.40 Cash Deposited - Post Verify
Dec 28 213.75 Cash Deposited - Post Verify
Dec 28 108.50 Cash Deposited - Post Verify
Dec 28 70.25 Cash Deposited - Post Verify
Dec 28 3 12 /28Bankcard Deposit
- 0329033004
Dec 28 1 12 /28Bankcard Deposit
- 0329033001
Dec 28 1 12 /28Bankcard Deposit
- 0329033000
Dec 28 52.89 Stagecoach Sweep Interest
Payment
Dec 31 614,657.35 Stagecoach Sweep Credit
Dec 31 6 12 /31Bankcard Deposit
- 0329033000
Dec 31 3 12 /31Bankcard Deposit
- 0329033000
Dec 31 1 12 /31Bankcard Deposit
- 0329033001
Dec 31 1 12 /31Bankcard Deposit
- 0329033001
Dec 31 425.33 American Express Settlement
071231 3220009393 Brooklyn
CTR3220009393
Dec 31 328.42 American Express Settlement
071229 3220009393 Brooklyn
CTR3220009393
Dec 31 172.87 Stagecoach Sweep Interest
Payment
.......................................... ...............................
7 Total Electronic Deposits/
Bank Credits
.......................................... ...............................
8 Total Credits
-------------------------------------------------------------------------------
Debits
Electronic Debits/ Bank Debits
Effective Posted
Date Date Amount Transaction Detail
Dec 03 103,880.88 ZBA Funding Account Transfer
To 1010008
Dec 03 32,547.98 Stagecoach Sweep Debit
Dec 04 6.40 Discover Network Settlement
071201 601101707332910 Bc
Liquor
Dec 04 25,225.89 ZBA Funding Account Transfer
To 1010008
Dec 04 52,511.70 Stagecoach Sweep Debit
Dec 05 282.42 Return Item Charge - Paper MN
071205
Dec 05 63.60 American Express Axp Discnt
071205 3220009393 Brooklyn
CTR3220009393
Dec 05 4.25 American Express Axp Discnt
071205 3224714741 Earl Brown
H3224714741
Dec 05 3 ZBA Funding Account Transfer
To 1010008
Dec 05 27,278.54 Stagecoach Sweep Debit
-------------------------------------------------------------------------------
Continued on next page
Page 8 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Debits/ Bank Debits
Effective Posted
Date Date Amount Transaction Detail
Dec 06 780.79 ZBA Funding Account Transfer
To 1010008
Dec 06 70,311.14 Stagecoach Sweep Debit
Dec 07 178.12 Return Item Charge - Paper MN
071207
Dec 07 6 ZBA Funding Account Transfer
To 1010008
Dec 07 76,518.10 Stagecoach Sweep Debit
Dec 10 22,440.41 ZBA Funding Account Transfer
To 1010008
Dec 10 74,570.37 Stagecoach Sweep Debit
Dec 11 1 Labor & Industry epayment
071210 DLIMN1000001527
Jordetdaniel
Dec 11 1 ZBA Funding Account Transfer
To 1010008
Dec 11 79,385.66 Stagecoach Sweep Debit
Dec 12 2 Bankcard Interchange Fee -
0329033000
Dec 12 1 Bankcard Interchange Fee -
0329033001
Dec 12 829.03 Bankcard Fee - 0329033000
Dec 12 661.29 Bankcard Interchange Fee -
0329033004
Dec 12 401.51 Bankcard Fee - 0329033001
Dec 12 56.00 Bankcard Fee - 0329033004
Dec 12 55.84 Bankcard Fee - 0329033002
Dec 12 13.47 Bankcard Interchange Fee -
0329033002
Dec 12 18,466.62 ZBA Funding Account Transfer
To 1010008
Dec 12 69,714.59 Stagecoach Sweep Debit
Dec 13 2 ZBA Funding Account Transfer
To 1010008
Dec 13 136,067.02 Stagecoach Sweep Debit
Dec 14 340,704.70 ZBA Funding Account Transfer
To 1010008
Dec 14 490,346.46 Stagecoach Sweep Debit
Dec 17 15,036.93 ZBA Funding Account Transfer
To 1010008
Dec 17 375,184.17 Stagecoach Sweep Debit
Dec 18 12,867.43 ZBA Funding Account Transfer
To 1010008
Dec 18 254,618.67 Stagecoach Sweep Debit
Dec 19 40,757.00 MN Dept Revenue MN Rev Pay
071219 99073609133 Brooklyn
Center City O
Dec 19 19,586.00 MN Dept Revenue MN Rev Pay
071219 99073610703 Earle Brown
Heritage C
Dec 19 2 MN Dept Revenue MN Rev Pay
071219 99073610860 Brooklyn
Center City O
Dec 19 1 ZBA Funding Account Transfer
To 1010008
Dec 19 206,024.69 Stagecoach Sweep Debit
Dec 20 2 12 /20Bankcard Deposit
- 0329033004
Dec 20 1 ZBA Funding Account Transfer
To 1010008
Dec 20 167,625.14 Stagecoach Sweep Debit
-------------------------------------------------------------------------------
Continued on next page
Page 9 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Electronic Debits/ Bank Debits
Effective Posted
Date Date Amount Transaction Detail
Dec 21 1 ZBA Funding Account Transfer
To 1010008
Dec 21 43,983.05 Stagecoach Sweep Debit
Dec 24 100.00 Return Item Charge - Paper AZ
071224
Dec 24 93.12 Return Item Charge - Paper MN
071224
Dec 24 822.24 ZBA Funding Account Transfer
To 1010008
Dec 24 807,039.58 Stagecoach Sweep Debit
Dec 26 2 ZBA Funding Account Transfer
To 1010008
Dec 26 491,032.64 Stagecoach Sweep Debit
Dec 27 534,480.51 Stagecoach Sweep Debit
Dec 28 233,424.89 ZBA Funding Account Transfer
To 1010008
Dec 28 614,657.35 Stagecoach Sweep Debit
Dec 31 117,598.17 ZBA Funding Account Transfer
To 1010008
Dec 31 575,259.58 Stagecoach Sweep Debit
............................................ ...............................
6 Total Electronic Debits/ Bank
Debits
Checks Paid
Check # Date Amount Check # Date Amount
..... ............................... ..... ...............................
134129 Dec 14 250.00 136448* Dec 04 682.00
134780* Dec 18 12.00 136455* Dec 03 2
135020* Dec 20 19.25 136458* Dec 05 2
135440* Dec 06 95.00 136467* Dec 04 41,126.54
135781* Dec 07 43.00 136468 Dec 28 10.00
136051* Dec 21 100.00 136469 Dec 05 20,162.82
136135* Dec 18 5.00 136470 Dec 12 1
136223* Dec 03 22.00 136471 Dec 04 590.00
136334* Dec 10 4 136472 Dec 06 523.14
136337* Dec 06 250.00 136473 Dec 05 71.50
136339* Dec 14 26.79 136474 Dec 05 276.90
136344* Dec 12 4 136475 Dec 04 1
136359* Dec 03 374.00 136476 Dec 03 62.10
136362* Dec 06 140.73 136477 Dec 04 17,678.00
136368* Dec 04 94.50 136480* Dec 03 11,451.29
136370* Dec 07 400.00 136481 Dec 03 19.40
136375* Dec 03 15.96 136482 Dec 10 375.00
136388* Dec 28 295.00 136483 Dec 05 12,863.05
136401* Dec 04 4.76 136484 Dec 04 480.00
136402 Dec 24 73.20 136485 Dec 05 41,272.92
136406* Dec 13 274.90 136486 Dec 24 3.96
136427* Dec 04 344.00 136488* Dec 05 1
136429* Dec 14 7 136489 Dec 04 2
136430 Dec 05 300.00 136490 Dec 04 127.16
136437* Dec 05 132.40 136491 Dec 04 513.58
136444* Dec 14 15.47 136492 Dec 03 70.85
136445 Dec 18 176.00 136493 Dec 03 329.98
-------------------------------------------------------------------------------
Continued on next page
Page 10 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Checks Paid
Check # Date Amount Check # Date Amount
..... ............................... ..... ...............................
136494 Dec 06 108.39 136559 Dec 04 33.07
136495 Dec 03 964.61 136560 Dec 04 40.50
136497* Dec 04 247.75 136562* Dec 04 941.33
136498 Dec 05 481.60 136563 Dec 03 8
136499 Dec 04 195.00 136564 Dec 03 107.57
136500 Dec 17 46.20 136565 Dec 03 25.02
136501 Dec 04 2 136567* Dec 03 2
136503* Dec 04 58.98 136568 Dec 04 340.29
136504 Dec 05 255.00 136569 Dec 04 19,399.25
136505 Dec 05 246.65 136570 Dec 07 488.86
136506 Dec 04 2 136571 Dec 03 410.51
136507 Dec 12 113.78 136572 Dec 12 250.00
136509* Dec 05 87.23 136573 Dec 11 77.81
136510 Dec 04 3 136574 Dec 10 546.00
136511 Dec 05 433.87 136575 Dec 13 90.00
136512 Dec 05 255.58 136576 Dec 10 3
136513 Dec 06 2 136577 Dec 18 16.10
136515* Dec 03 1 136579* Dec 07 112.52
136516 Dec 10 275.13 136580 Dec 12 12,085.91
136517 Dec 05 129.76 136581 Dec 10 1
136518 Dec 03 21.18 136582 Dec 14 68.01
136520* Dec 04 1 136583 Dec 12 320.00
136521 Dec 05 171.27 136584 Dec 13 5
136522 Dec 05 197.49 136585 Dec 12 1
136523 Dec 07 1 136586 Dec 11 353.40
136524 Dec 03 29,754.00 136587 Dec 17 150.00
136526* Dec 04 8 136588 Dec 20 183.74
136527 Dec 04 94.58 136589 Dec 10 106.33
136528 Dec 31 30.67 136590 Dec 07 457.85
136530* Dec 04 250.00 136591 Dec 07 565.30
136531 Dec 12 145.00 136592 Dec 13 520.90
136532 Dec 04 478.22 136593 Dec 10 59.88
136533 Dec 05 3 136594 Dec 11 1
136534 Dec 07 262.11 136595 Dec 11 164.02
136535 Dec 14 6 136596 Dec 12 160.00
136536 Dec 07 707.19 136597 Dec 12 90.00
136537 Dec 04 1 136598 Dec 12 127.80
136538 Dec 05 17.90 136599 Dec 13 111.00
136539 Dec 07 1 136600 Dec 13 435.63
136540 Dec 05 1 136601 Dec 11 16,149.13
136541 Dec 05 311.50 136602 Dec 12 249.86
136542 Dec 04 458.41 136603 Dec 12 105.00
136543 Dec 07 75.80 136604 Dec 12 370.00
136544 Dec 04 178.99 136605 Dec 12 854.85
136545 Dec 04 89.35 136606 Dec 17 10.25
136546 Dec 05 500.00 136607 Dec 12 668.01
136548* Dec 04 43.54 136608 Dec 12 98.37
136549 Dec 03 262.11 136609 Dec 07 3
136550 Dec 06 574.25 136610 Dec 18 221.41
136551 Dec 07 550.00 136611 Dec 10 29.85
136552 Dec 04 765.71 136612 Dec 28 750.00
136554* Dec 04 26.78 136613 Dec 13 335.22
136556* Dec 05 718.93 136614 Dec 07 276.97
136557 Dec 04 352.77 136615 Dec 10 9
136558 Dec 05 219.97 136616 Dec 11 2
-------------------------------------------------------------------------------
Continued on next page
Page 11 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Checks Paid
Check # Date Amount Check # Date Amount
..... ............................... ..... ...............................
136617 Dec 12 959.35 136672 Dec 19 150.00
136618 Dec 13 245.87 136673 Dec 28 775.98
136619 Dec 18 14.31 136674 Dec 31 41.66
136620 Dec 11 341.34 136675 Dec 18 73.84
136621 Dec 07 3 136676 Dec 18 320.95
136622 Dec 12 610.14 136677 Dec 18 716.32
136623 Dec 12 1 136678 Dec 14 529.67
136624 Dec 07 23,537.71 136679 Dec 18 675.00
136625 Dec 12 127.50 136680 Dec 20 119.50
136626 Dec 12 1 136681 Dec 24 60.16
136627 Dec 11 183.14 136682 Dec 17 533.09
136628 Dec 11 9 136683 Dec 14 1
136629 Dec 07 148.67 136685* Dec 18 15.98
136630 Dec 10 1 136686 Dec 19 31.95
136631 Dec 07 308.42 136687 Dec 21 250.00
136632 Dec 13 48.70 136688 Dec 14 103.75
136633 Dec 12 117.12 136689 Dec 18 8.25
136634 Dec 12 2 136690 Dec 17 1
136635 Dec 14 60.53 136691 Dec 18 185.00
136636 Dec 11 760.62 136692 Dec 18 75.00
136637 Dec 13 94.55 136693 Dec 18 3
136638 Dec 10 209.81 136694 Dec 17 11,090.31
136639 Dec 12 720.00 136695 Dec 19 1
136640 Dec 10 166.80 136696 Dec 18 285.00
136641 Dec 11 56,069.14 136698* Dec 18 2
136642 Dec 11 1 136699 Dec 19 515.86
136643 Dec 07 4 136700 Dec 18 154.24
136644 Dec 11 2 136701 Dec 17 19,862.40
136645 Dec 11 1 136702 Dec 17 300.52
136646 Dec 10 237.49 136703 Dec 18 101.18
136647 Dec 14 150.00 136704 Dec 18 1
136648 Dec 13 591.08 136705 Dec 17 303.50
136649 Dec 10 66.69 136706 Dec 18 370.66
136650 Dec 11 1 136707 Dec 18 97.84
136651 Dec 10 390.00 136708 Dec 27 47.50
136652 Dec 11 395.00 136709 Dec 14 166.10
136653 Dec 10 1 136710 Dec 14 2
136654 Dec 26 127.03 136711 Dec 18 170.18
136655 Dec 12 396.00 136712 Dec 17 6
136656 Dec 14 3.76 136713 Dec 19 110.48
136657 Dec 12 493.89 136714 Dec 14 61.25
136658 Dec 11 16.64 136715 Dec 18 5
136659 Dec 12 988.08 136716 Dec 18 5
136660 Dec 12 8.00 136717 Dec 17 318.44
136661 Dec 11 111.25 136718 Dec 18 38.32
136662 Dec 12 29,775.06 136719 Dec 14 596.57
136663 Dec 14 792.00 136720 Dec 17 354.83
136664 Dec 13 590.49 136722* Dec 17 78.00
136665 Dec 18 25.73 136723 Dec 24 115.18
136666 Dec 10 255.22 136724 Dec 18 72.35
136667 Dec 17 11,331.97 136725 Dec 17 60.81
136668 Dec 18 350.00 136727* Dec 18 25.49
136669 Dec 10 54.27 136728 Dec 14 371.47
136670 Dec 20 326.08 136729 Dec 20 263.90
136671 Dec 17 287.00 136730 Dec 14 224.35
-------------------------------------------------------------------------------
Continued on next page
Page 12 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Checks Paid
Check # Date Amount Check # Date Amount
..... ............................... ..... ...............................
136731 Dec 18 10,049.99 136788 Dec 17 103.68
136732 Dec 20 97,248.59 136789 Dec 21 368.20
136733 Dec 19 619.48 136790 Dec 18 2
136734 Dec 17 50.95 136791 Dec 21 25.97
136735 Dec 20 3 136792 Dec 27 5
136736 Dec 20 120.60 136793 Dec 14 23.16
136737 Dec 20 700.00 136794 Dec 19 203.42
136738 Dec 18 2 136795 Dec 17 351.45
136739 Dec 20 350.09 136796 Dec 18 320.00
136740 Dec 19 11,720.65 136798* Dec 17 1
136741 Dec 20 254.09 136799 Dec 19 1
136742 Dec 14 16,846.55 136801* Dec 17 2
136743 Dec 17 3 136802 Dec 18 386.28
136744 Dec 18 145.35 136803 Dec 18 1
136745 Dec 18 6 136804 Dec 17 8.34
136747* Dec 14 806.36 136805 Dec 18 3
136749* Dec 18 22.61 136806 Dec 19 56.63
136750 Dec 14 828.73 136807 Dec 18 624.08
136751 Dec 14 7 136808 Dec 18 1
136752 Dec 17 89,977.91 136809 Dec 19 627.47
136753 Dec 18 6.62 136810 Dec 18 33.39
136754 Dec 14 222.74 136812* Dec 17 1
136755 Dec 14 94.47 136813 Dec 17 36.18
136756 Dec 24 52.78 136816* Dec 18 146,010.00
136757 Dec 18 20.00 136818* Dec 21 48.99
136758 Dec 14 250.00 136819 Dec 26 29.92
136759 Dec 14 16.46 136820 Dec 26 383.43
136760 Dec 19 1 136821 Dec 26 112.50
136761 Dec 18 300.00 136822 Dec 26 132.05
136762 Dec 19 194.70 136823 Dec 26 878.62
136763 Dec 18 16.81 136824 Dec 28 828.00
136764 Dec 18 38.47 136825 Dec 27 103.50
136765 Dec 18 66.17 136827* Dec 27 140.00
136766 Dec 31 898.17 136828 Dec 21 1
136767 Dec 18 840.00 136829 Dec 27 112.60
136768 Dec 18 299.93 136830 Dec 27 109.00
136769 Dec 14 2 136833* Dec 26 243,750.90
136770 Dec 26 237.45 136834 Dec 28 13,487.45
136771 Dec 18 62.61 136835 Dec 26 79.88
136772 Dec 17 67.56 136836 Dec 28 206.60
136773 Dec 18 685.43 136837 Dec 27 30,967.23
136774 Dec 17 1 136838 Dec 28 1
136775 Dec 18 281.25 136839 Dec 24 250.00
136776 Dec 14 8 136840 Dec 24 125.00
136777 Dec 18 186.05 136841 Dec 26 1
136778 Dec 18 119.01 136842 Dec 28 188.00
136779 Dec 18 95.80 136844* Dec 24 216.50
136780 Dec 21 940.77 136845 Dec 26 192.77
136781 Dec 20 4 136846 Dec 26 10.50
136782 Dec 17 2 136848* Dec 27 166.00
136783 Dec 17 133.11 136849 Dec 21 1
136784 Dec 20 60.30 136850 Dec 28 774.35
136785 Dec 18 419.28 136851 Dec 31 95.80
136786 Dec 17 869.14 136852 Dec 24 270.00
136787 Dec 17 1 136853 Dec 24 24.03
-------------------------------------------------------------------------------
Continued on next page
Page 13 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
Checks Paid
Check # Date Amount Check # Date Amount
..... ............................... ..... ...............................
136854 Dec 26 1 136913 Dec 26 500.00
136855 Dec 26 37.28 136914 Dec 24 250.00
136856 Dec 24 351.24 136915 Dec 24 2
136857 Dec 28 192.00 136916 Dec 27 2
136858 Dec 21 96.98 136917 Dec 24 2
136860* Dec 26 127.89 136918 Dec 27 1
136861 Dec 28 271.58 136919 Dec 27 330.70
136862 Dec 26 625.16 136920 Dec 31 158.69
136863 Dec 21 1 136921 Dec 28 50,386.19
136864 Dec 26 90.00 136923* Dec 28 196.00
136865 Dec 26 8 136926* Dec 28 7.99
136866 Dec 26 15,699.94 136927 Dec 26 1
136867 Dec 21 90.00 136928 Dec 24 395.00
136868 Dec 27 49.97 136929 Dec 28 234.29
136869 Dec 24 112.50 136930 Dec 21 387.42
136870 Dec 27 2 136931 Dec 28 308.00
136871 Dec 21 2 136932 Dec 26 596.30
136873* Dec 26 34.22 136933 Dec 31 3
136874 Dec 26 4 136934 Dec 24 752.43
136875 Dec 28 605.80 136935 Dec 28 6.34
136876 Dec 21 15,492.30 136936 Dec 28 118.49
136877 Dec 27 62.00 136937 Dec 26 8.34
136878 Dec 21 95.32 136939* Dec 27 151.09
136879 Dec 24 16,589.17 136941* Dec 24 11,739.15
136880 Dec 26 15,392.39 136942 Dec 28 295.20
136881 Dec 24 440.00 136945* Dec 27 52.00
136882 Dec 27 189.22 136946 Dec 24 255.22
136883 Dec 31 120.10 136947 Dec 28 54.50
136884 Dec 21 100.28 136949* Dec 26 16,917.50
136886* Dec 21 25,963.00 136951* Dec 31 259.20
136887 Dec 27 16,421.34 136954* Dec 28 4
136889* Dec 27 659.62 136955 Dec 28 73.23
136890 Dec 26 3 136963* Dec 31 256.00
136891 Dec 26 3 136964 Dec 31 189.65
136892 Dec 21 2 136965 Dec 31 617.45
136893 Dec 21 1 136966 Dec 28 705.98
136894 Dec 21 153,771.82 136967 Dec 28 2
136895 Dec 26 1 136975* Dec 28 127,674.35
136896 Dec 21 9 136976 Dec 31 5
136897 Dec 28 101.00 136983* Dec 31 12,366.26
136899* Dec 24 72.76 136986* Dec 31 18,909.49
136900 Dec 28 189.57 136988* Dec 31 3
136901 Dec 24 1 136990* Dec 31 117.15
136902 Dec 31 525.00 136991 Dec 31 416.68
136903 Dec 31 4 136995* Dec 31 106.72
136904 Dec 27 1 136997* Dec 28 1
136905 Dec 31 539.10 137004* Dec 28 13,836.39
136906 Dec 24 177.92 137005 Dec 31 85.15
136908* Dec 26 53,800.90 137007* Dec 31 1
136909 Dec 26 95.80 137009* Dec 31 378.66
136910 Dec 26 4 137010 Dec 31 187.44
136911 Dec 27 31.42 137012* Dec 28 62.50
136912 Dec 26 695.64
............................................ ...............................
*Gap in check sequence 2 Total Checks Paid
-------------------------------------------------------------------------------
Continued on next page
Page 14 of 14
Account Number: 000 - 1010016
CITY OF BROOKLYN CENTER
GENERAL FUND Statement End Date: 12/31/07
............................................ ...............................
8 Total Debits
-------------------------------------------------------------------------------
Daily Ledger Balance Summary
Date Balance Date Balance
..... ............................... ..... ...............................
Nov 30 609,542.00 Dec 17 524,467.00
Dec 03 537,135.00 Dec 18 514,100.00
Dec 04 521,356.00 Dec 19 554,538.00
Dec 05 533,721.00 Dec 20 660,364.00
Dec 06 530,642.00 Dec 21 571,518.00
Dec 07 515,762.00 Dec 24 546,638.00
Dec 10 573,453.00 Dec 26 503,525.00
Dec 11 501,667.00 Dec 27 518,156.00
Dec 12 577,145.00 Dec 28 669,115.00
Dec 13 545,486.00 Dec 31 552,669.00
Dec 14 545,347.00
Average Daily Ledger Balance 560,419.51
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Thank you for banking with Wells Fargo. Member FDIC
R09132P CITY OF BROOKLYN CENTER 1/2/2008 16:14:47
Reconciliations Print - Outstanding Items Page - 1
Account Number : 90300 -1010 CASH IN BANK WELLS FARGO
Subledger ... Date Thru ... 12/31/2007
Ledger Type ... AA
Reference Reference Amount Explanation G/L Subledger
1 2 Date
00113875 00118453 4.37- TSERING, KARMA 7/15/2004
00116750 00119028 12.81- MALDONADO, JORGE 12/16/2004
00117272 00119122 202.36- TITLE ONE INC 1/13/2005
00117680 00111815 120.00- 10,000 LAKES CHAPTER 2/10/2005
00118855 00119578 21.24- DAVI ES, LINDA 4/14/2005
00118857 00119543 6.58- DEVRIES, THOMAS 4/14/2005
00119892 00120323 4.86- MARICH, SCOTT 6/9/2005
00119947 00101730 18.82- ROSS, BILL 6/9/2005
00123179 00107583 115.55- EMERGENCY AUTOMOTIVE TECH INC 12/1/2005
00123336 00121073 5.48- MORROW, FRANCES 12/8/2005
00123383 00121079 32.04- YANG, CHENG PAO 12/8/2005
00124641 00121301 50.00- HENNEPIN COUNTY CHILDREN 2/16/2006
00125334 00121402 63.58- TCM PROPERTIES 3/23/2006
00125756 00121468 10.52- DOERR, JOSHUA 4/20/2006
00125835 00121478 50.92- WILLIAMS, ED 4/20/2006
00125880 00121494 45.00- GARDFREY, TWANDA 4/27/2006
00125999 00121510 5.00- KWAIDAH, PAULINE 5/4/2006
00126045 00121515 177.67- TAH I RO, M U H E 5/4/2006
00126063 00121523 10.52- ALBERS, JOANNA B 5/11/2006
00126084 00121524 45.86- CAMPIS, ORLANDO 5/11/2006
00126384 00121576 50.00- FRASER, GARY 5/25/2006
00126495 00121578 50.00- YANG, ZOUA THAO 5/25/2006
00126760 00121677 15.25- WILLIAMS, JOHNNIE 6/8/2006
00127084 00121811 292.55- BOYCE, NANCY 6/29/2006
00127470 00121895 35.00- DORN, RANDY 7/20/2006
00127869 00121984 25.97- CHANTHACHACK, BOONLAD 8/10/2006
00128408 00122108 30.20- NGUYEN, MAI 9/7/2006
00129372 00122331 4.00- ALI, FATU 11/2/2006
00129474 00122339 4.00- TANOE, AMAKIE 11/2/2006
00129476 00122351 289.20- TIMBERLAND TITLE 11/2/2006
00130358 00122501 20.29- WILMES, JOHN 12/21/2006
00130451 00122508 23.62- OKINS, BETTY LOU 12/28/2006
00131461 00122664 98.31- KIRKWOOD, LISA 2/22/2007
00131482 00122667 22.57- PELTEKOS, LULA 2/22/2007
00131800 00122723 46.51- MINNESOTA ABSTRACT TITLE 3/15/2007
00132022 00122756 50.00- GORDON, JOHN R 3/29/2007
00133032 00122901 118.25- JOHNSON, RICHARD 5/24/2007
00133576 00123047 38.00- ISRAEL, ISHMAEL 6/21/2007
00133578 00123052 129.23- JEAN, EMMANUEL 6/21/2007
00133841 00123047 20.00- ISRAEL, ISHMAEL 7/5/2007
R09132P CITY OF BROOKLYN CENTER 1/2/2008 16:14:47
Reconciliations Print - Outstanding Items Page - 2
Reference Reference Amount Explanation G/L Subledger
1 2 Date
00134340 00123308 72.00- YOCHUM, DAN 7/26/2007
00135028 00124403 119.42- MANN, RANDY 9/6/2007
00135093 00124472 177.73- ALL AMERICAN TITLE 9/13/2007
00135262 00105743 140.17- COMMERS, KRISTI 9/20/2007
00135508 00125198 56.39- BOBA CAFE 10/4/2007
00135664 00122366 248.11- FIRST FINANCIAL TITLE 10/11/2007
00135778 00105743 146.47- COMMERS, KRISTI 10/18/2007
00135788 00118328 43.00- DEERING, LUCY 10/18/2007
00135961 00125774 19.00- HERBST, TONI 10/25/2007
00135962 00125776 32.17- HOME TEAM COM INC 10/25/2007
00135963 00125773 88.00- HOWARD, AMBER 10/25/2007
00136050 00122332 450.00- BROOKLYN CENTER HIGH SCHOOL B 11/1/2007
00136311 00126542 305.93- HSBC 11/15/2007
00136325 00120230 57.04- MEYER, TARA 11/15/2007
00136361 00126642 15.00- ALIO, HABI BA 11/21/2007
00136381 00107032 4,731.00- CANADA GOOSE PROGRAM 11/21/2007
00136404 00121942 19.13- GARDNER'S CAMDEN HARDWARE HANK 11/21/2007
00136414 00126542 108.29- HSBC 11/21/2007
00136432 00126648 25.00- NORTHWEST AIRLINES 11/21/2007
00136440 00107434 430.48- POLZ, JOHN R 11/21/2007
00136463 00126643 125.00- WILLIS, DEDRIC 11/21/2007
00136487 00126953 451.12- CHASE BANK 11/29/2007
00136514 00107186 987.00- IND SCHOOL DIST 279 11/29/2007
00136684 00122881 50.05- BEST ASSETS 12/13/2007
00136697 00127389 19.28- CHASE HOME FINANCIAL 12/13/2007
00136721 00127379 250.00- FINNISH AMERICAN CULTURAL 12/13/2007
00136726 00127386 67.78- GATLIN, LEE 12/13/2007
00136746 00116926 15.57- LA ROSE, BOBBY 12/13/2007
00136748 00106381 488.15- LIFE SAFETY SYSTEMS 12/13/2007
00136797 00122940 152.21- TWINSOURCE 12/13/2007
00136800 00102235 2,707.73- UNITED BUSINESS MAIL 12/13/2007
00136811 00105404 208.00- WILSON DEVELOPMENT SERVICES 12/13/2007
00136814 00121155 41.29- BROOKS MALL PROPERTY 12/13/2007
00136815 00121155 69.98- BROOKS MALL PROPERTY 12/13/2007
00136817 00102623 67.10- A REGAL IMPRESSION 12/20/2007
00136826 00124724 17.05- AT &T MOBILITY 12/20/2007
00136831 00102121 91.00- BROOKLYN CENTER HIGH SCHOOL 12/20/2007
00136832 00105697 503.00- BROOKLYN SENIOR ADULT CLUB 12/20/2007
00136843 00104323 61.86- CITY WIDE WINDOW SERVICES INC 12/20/2007
00136847 00101935 794.52- CURTIS INDUSTRIES INC 12/20/2007
00136859 00106550 1,156.89- FINNWOOD COMPANY 12/20/2007
00136872 00101670 265.00- HENNEPIN COUNTY TREASURER 12/20/2007
00136885 00106381 320.00- LIFE SAFETY SYSTEMS 12/20/2007
R09132P CITY OF BROOKLYN CENTER 1/2/2008 16:14:47
Reconciliations Print - Outstanding Items Page - 3
Reference Reference Amount Explanation G/L Subledger
1 2 Date
00136888 00101825 408.00- LUV PAINTING INC 12/20/2007
00136898 00121950 7,780.00- NABEE LLC 12/20/2007
00136907 00116003 74.50- PEASLEY, TROY 12/20/2007
00136922 00127471 89.90- SOMMERFELD TOOLS FOR WOOD 12/20/2007
00136924 00102713 648.59- ST CROIX RECREATION CO INC 12/20/2007
00136925 00120271 143.78- STELTER, DOUGLAS 12/20/2007
00136938 00117519 122.46- VESSEY, BRETT 12/20/2007
00136940 00102541 225.00- VISIBLE GLASS INC 12/20/2007
00136943 00105474 88.00- WHITCOMB, STACEY 12/20/2007
00136944 00127472 50.00- WISCONSIN MUNICIPAL CLERKS ASS 12/20/2007
00136948 00106428 13,359.76- XCEL ENERGY 12/20/2007
00136950 00102180 328.98- ALEX AIR APPARATUS INC 12/27/2007
00136952 00120253 94.15- ARCTIC GLACIER ICE 12/27/2007
00136953 00121278 545.29- ASPEN MILLS 12/27/2007
00136956 00122750 81.00- BERLSON IMPORTS LLC 12/27/2007
00136957 00117305 15.98- BILLS GUN SHOP & RANGE 12/27/2007
00136958 00122511 55.38- BILLS GUNS SHOP & RANGE NORTH 12/27/2007
00136959 00121606 18,959.70- CAPITOL BEVERAGES SALES 12/27/2007
00136960 00101915 30,018.90- CARSON CLELLAND & SCHREDER 12/27/2007
00136961 00102032 433.85- CBC PUBLIC UTILITIES 12/27/2007
00136962 00102723 2,375.15- CHISAGO LAKES DISTRIBUTING CO 12/27/2007
00136968 00104682 4,377.12- EAGLE WINE COMPANY 12/27/2007
00136969 00106385 576.00- EXTREME BEVERAGES 12/27/2007
00136970 00103596 281.90- FLEX COMPENSATION INC 12/27/2007
00136971 00127874 3,216.40- FOGELBERG, JAY C 12/27/2007
00136972 00117524 43.27- FOURTH JUDICIAL DISTRICT 12/27/2007
00136973 00101265 343.70- GETTMAN COMPANY 12/27/2007
00136974 00101267 6,044.72- GRIGGS COOPER & CO 12/27/2007
00136977 00127858 55.00- HELIO LLC 12/27/2007
00136978 00106784 333.25- HOHENSTEINS INC 12/27/2007
00136979 00125773 352.00- HOWARD, AMBER 12/27/2007
00136980 00101223 1,200.00- HUMBOLDT SQUARE CLEANERS 12/27/2007
00136981 00105319 412.16- INFINITY WIRELESS 12/27/2007
00136982 00127859 300.00- JACKSON, LARRY 12/27/2007
00136984 00101376 41,129.86- JOHNSON BROTHERS 12/27/2007
00136985 00112923 31.49- KEEPRS INC 12/27/2007
00136987 00102080 3,078.00- KNOX COMPANY 12/27/2007
00136989 00101475 9,442.08- MARK VII DISTRIB 12/27/2007
00136992 00122394 700.00- MONEY MAILER OF CENTRAL WEST M 12/27/2007
00136993 00117998 250.00- NELSON ELECTRIC MOTOR REPAIR 12/27/2007
00136994 00106516 829.00- NORTH MEMORIAL CLINIC 12/27/2007
00136996 00102406 278.52- OFFICE DEPOT 12/27/2007
00136998 00101843 604.50- PEAK STAFFING 12/27/2007
R09132P CITY OF BROOKLYN CENTER 1/2/2008 16:14:47
Reconciliations Print - Outstanding Items Page - 4
Reference Reference Amount Explanation G/L Subledger
1 2 Date
00136999 00101629 417.15- PEPSI -COLA COMPANY 12/27/2007
00137000 00102478 67.09- PETTY CASH - SHARON KNUTSON 12/27/2007
00137001 00101632 14,930.55- PHILLIPS WINE & SPIRITS 12/27/2007
00137002 00107226 175.00- POSTMASTER 12/27/2007
00137003 00107224 387.29- POSTMASTER PERMT2170 12/27/2007
00137006 00127862 184.87- SPEEDWAY SA #4058 12/27/2007
00137008 00122330 404.00- SURLY BREWING COMPANY 12/27/2007
00137011 00101237 440.00- WANDZEL, DANIEL 12/27/2007
00137013 00106428 25,030.30- XCEL ENERGY 12/27/2007
Total Open Amount 210,373.63 -
Balance per Book 1,494,983.73
Books plus Open 1,705,357.36
R073241 CITY OF BROOKLYN CENTER 1/16/2008 8:39:34
Reconciliation Register
Payroll Bank Reconciliation Page - 1
G/L Bank Account 00003866 CASH IN BANK WELLS FARGO
R Check Detail .. ....... Status .. Employee .......
C Number R Date Control SB Net Pay I C Description Number Name
132013 N 4/7/2006 236571 1 55.88 C Computer Check
55.88
133630 N 10/6/2006 257297 1 9.43 1 C Computer Check
9.43
133928 N 11/17/2006 261731 1 20.28 C Computer Check
20.28
136414 N 10/5/2007 306181 1 462.59 C Computer Check
462.59
136578 N 11/2/2007 308101 1 24.56 C Computer Check
136560 N 11/2/2007 308055 1 117.29 C Computer Check
136517 N 11/2/2007 307948 1 70.28 C Computer Check
212.13
136607 N 11/16/2007 311159 1 31.14 C Computer Check
136651 N 11/16/2007 311361 1 68.60 C Computer Check
99.74
136652 N 11/16/2007 309552 1 75.62- 1 Z
75.62-
136732 N 11/30/2007 312545 1 8.85 C Computer Check
136720 N 11/30/2007 312509 1 35.87 C Computer Check
44.72
136796 N 12/7/2007 312668 1 352.92 C Computer Check
136805 N 12/7/2007 312640 1 445.35 C Computer Check
136803 N 12/7/2007 312659 1 1,357.05 C Computer Check
2,155.32
136843 N 12/14/2007 314375 1 66.50 C Computer Check
136829 N 12/14/2007 314393 1 72.33 C Computer Check
136834 N 12/14/2007 314401 1 357.98 C Computer Check
136828 N 12/14/2007 314130 1 222.32 C Computer Check
136815 N 12/14/2007 314109 1 149.48 C Computer Check
136865 N 12/14/2007 314171 1 151.43 C Computer Check
136831 N 12/14/2007 314499 1 316.13 C Computer Check
136844 N 12/14/2007 314541 1 153.91 C Computer Check
136857 N 12/14/2007 314475 1 13.28 C Computer Check
1,503.36
137046 N 12/28/2007 317305 1 79.66 C Computer Check
137004 N 12/28/2007 317314 1 118.91 C Computer Check
137031 N 12/28/2007 317322 1 86.36 C Computer Check
137001 N 12/28/2007 317327 1 192.08 C Computer Check
137035 N 12/28/2007 317328 1 22.16 C Computer Check
137034 N 12/28/2007 317243 1 35.88 C Computer Check
137011 N 12/28/2007 317245 1 48.24 C Computer Check
136999 N 12/28/2007 317250 1 192.08 C Computer Check
R073241 CITY OF BROOKLYN CENTER 1/16/2008 8:39:34
Reconciliation Register
Payroll Bank Reconciliation Page - 2
G/L Bank Account 00003866 CASH IN BANK WELLS FARGO
R Check Detail .. ....... Status .. Employee .......
C Number R Date Control SB Net Pay I C Description Number Name
137024 N 12/28/2007 317265 1 97.34 C Computer Check
137032 N 12/28/2007 317279 1 79.40 C Computer Check
137012 N 12/28/2007 317292 1 116.75 C Computer Check
137079 N 12/28/2007 317303 1 433.42 C Computer Check
137030 N 12/28/2007 317371 1 76.96 C Computer Check
137075 N 12/28/2007 317304 1 433.43 C Computer Check
137015 N 12/28/2007 317386 1 81.26 C Computer Check
137006 N 12/28/2007 317389 1 110.82 C Computer Check
137023 N 12/28/2007 317390 1 192.08 C Computer Check
137029 N 12/28/2007 317391 1 155.14 C Computer Check
137008 N 12/28/2007 317338 1 169.92 C Computer Check
137055 N 12/28/2007 317347 1 125.01 C Computer Check
137007 N 12/28/2007 317352 1 192.10 C Computer Check
137026 N 12/28/2007 317356 1 73.53 C Computer Check
137077 N 12/28/2007 317369 1 513.05 C Computer Check
137053 N 12/28/2007 317001 1 151.57 C Computer Check
137066 N 12/28/2007 317025 1 992.29 C Computer Check
137071 N 12/28/2007 317036 1 2,860.29 C Computer Check
137070 N 12/28/2007 317042 1 1,798.93 C Computer Check
136998 N 12/28/2007 316939 1 51.87 C Computer Check
137000 N 12/28/2007 316943 1 310.30 C Computer Check
137051 N 12/28/2007 316951 1 80.19 C Computer Check
137013 N 12/28/2007 316960 1 145.38 C Computer Check
137016 N 12/28/2007 316967 1 169.78 C Computer Check
137025 N 12/28/2007 316976 1 138.22 C Computer Check
137033 N 12/28/2007 316988 1 219.53 C Computer Check
137036 N 12/28/2007 316993 1 100.83 C Computer Check
137037 N 12/28/2007 316997 1 155.14 C Computer Check
136992 N 12/28/2007 316998 1 294.92 C Computer Check
137039 N 12/28/2007 316999 1 1,029.05 C Computer Check
137027 N 12/28/2007 317234 1 155.14 C Computer Check
137009 N 12/28/2007 317222 1 74.78 C Computer Check
137010 N 12/28/2007 317185 1 316.03 C Computer Check
137028 N 12/28/2007 317187 1 271.44 C Computer Check
137048 N 12/28/2007 317193 1 1,898.58 C Computer Check
137061 N 12/28/2007 317197 1 75.83 C Computer Check
137017 N 12/28/2007 317204 1 184.70 C Computer Check
137049 N 12/28/2007 317048 1 224.68 C Computer Check
136996 N 12/28/2007 316935 1 310.30 C Computer Check
137044 N 12/28/2007 317119 1 209.43 C Computer Check
137080 N 12/28/2007 317125 1 111.56 C Computer Check
15,956.34
R073241 CITY OF BROOKLYN CENTER 1/16/2008 8:39:34
Reconciliation Register
Payroll Bank Reconciliation Page - 3
G/L Bank Account 00003866 CASH IN BANK WELLS FARGO
R Check Detail .. ....... Status .. Employee .......
C Number R Date Control SB Net Pay I C Description Number Name
20,519.79 Computer Check
Grand Total Auto Deposit
20,519.79 Computer Check
Manual Check
20,519.79 Total All Checks
I Pa I of 4
WELD FARGO BANK, N.A. 2,342 CO DU)
PUBLIC ENTITIES SPECIALTY MARKET Account Number: 1
POST OFFICE BOX B 514 1 10008
MINNEAPOLIS, MN 55479 S t a tem ent Start a te: 12/01/07
S tatement End .date: 12131107
�
C ITY OF BROOKLYN CENTER
PAYROLL ACCOUNT
63 01 SHINGLE CREEK PKWY
BROOK TER MN 55430-211
For Customer Assistance:
C a 1180 0 - 225 - 5935 1 B0-C A LL -W E L LS).
Ac count N umber Beginning Bala ice Total Credits Total Debits Ending Balance
Bus i n ess Case
M Acct Public
Fund
000- 1010008 910p741.90 - 910,741M 0
N ews from Welts Fargo
Introducing Security Qu
In the coming months, w'e'lt ask all online customers to make their account even safer by selecting and answering
three security questions. If we ever need to confirm your identity, "our correct answers to these questions will h iel p
us verify it's yore. To learn more, visit our Security Questions Overview at www,welisfargo-comisecurityquestions
Q uick and easy to set Grp, security questions help pro tect your account and keep your identity safe.
C redits - E lectronic Deposits! Bank Credits
Effective Poste' Amount Transaction Detail
Date Date
Dec 03 103,880.88 Zero Balance Account Transfer From 1010016
Dec 04 25,225.89 Zero Balance Account Transfer From 101001
Dec 05 3,077. 17 Zer o Balance Acco Transfer From 101001
Dec 06 780.79 Zero Balance Account Transfer From 10100
Dec 07 6, Z ero Balance Account Transfer From 101001
D ec 10 22 440.41 Zero Balance Account Transfer From 10 100 76
Dec 'If 1, 16174 Zero Balance Account Transfer from 1010016
Dec 12 18,466. Zero B alance Account Transf F rom 101001
Dec 13 2 " 192.13 Zero Balance Account Transfer From 1010016
D ec 14 340, 704. Zero 3 W e Ac count Transter From 10 100 16
D ec 17 15, 036.93 Zero Ba Account Transfer From 101001
D ec 12p867. 43 Zero Balan Ac count Transfer From 10100
D ec 1 ,q 1 Zero B alance a :nt Transfer From 101001
D ec 11566. Zero Balance Account Transfer Fron7 101
Dec 21 I 106. 60 Zero Balance Account Transfer From 101001
D ec 24 822 .24 Zero Balance Account Transfer From 101
Dec 26 2,24100 Zero Balance Account Transfer rrom 101001
Dec 233 Zero Balance Accaunt Transfer From 10100
1 11 7p t T Fero Balance Account Transfer From 1010016
....................• ...........,..- ............ y.,,a,..__ .. ....................................... Ff sf as rt ri wra F. r
1 O 74 1.90 Total Electronic Depositsl Bank Credits
C ontinued on next page
J�III I III111itII11llIIIIIIII 11 1 IIIII II� ----------- y .}
Pa 2 of 4
V-0
23
Cit Of Brookl Center Account Number.- 000-1010008
Pa Account 1010008
Statement End Date: 12131107
. . .................. . . . ... . i r. i f .. e. f dk f f i} i }. } , i f Yl f L' } y i f f f Y} i} Y T Y} Y! t ll^ }! t Y d t N- t .. t. a a a t i t c t i T }! }{ i Y P Y f T. T t T Y'! Y! Y -! !! T +k . Y. Y! Y T a.} T!. ! T.! +•.• ............... . . . . . +
9100 741.90 Total Credits
A-
D eb 113'
Electronic Debits/ Bank Debits
Effective Posted Amount Transaction Detail
Date Date
Dec 03 87,958.04 IRS Usataxp ' y mt 120307 270773700591942 Cit Of
Brookl Conte
Dec 03 16 63 1 . 73 MN Dept Revenue MN Rev Pa 071201
99073581358 Brookl Center Cit 0
Dec 04 355.26 Orchard Trust Ke 704667648996 000O Cit Of
Brookl
Dec 10 13,32100 IRS Usataxp 121007 270774400953404 Cit Of
Brookl Cents
Dec 10 2,489.4-1 MN Dept Revenue MN Rev Pa 071208
9,9073613134 Brookl Center Cit 0
Dec 14 234,008.32 Cit Of Brookl Pa 121307 1010008 Cit Of
Brookl Cent
Dec 14 85,134.18 IR 5 Usa tap t 12140 7 2 1 7-38 63 Ci t 0 f
Brookl Conte
D ec 14 16t742.59 MNDept Revenue MN Rev Pa 071214
99073W519 Brookl Center Cit 0
Dec 17 355.26 Orchard Trust Ke 2&Xk),5364159 00000 y Of
Brookl
Dec 28 227p 768. 48 Ci t Of B ro o kl Pa 11 12270 7 1010008 Cit Of
BrooklyIn Cent
Dec 31 81,2 95.79 IRS Usataxp 123107 270776500688759 Cit Of
Brookl erg to
Aft.9
Dec J7 16,155.84 MN Dept Revenue MN Rev Pa 071229
99073732983 Brookl Center Cit 0
.................... ......... .............................
776o217.90 Total Electronic Debitsl Bank Debits
Checks Paid
Check # Date Amount Check # Date Amount Check # Date Amowit
. . . . • . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243 . . . . . . • . 1. . . . .1 .......... . . . . . . . . . . . . . . . . .. .... . . .............. r .. .. .. . . . . . .
63
13 Dec 07 .80 136680* Dec 07 453.46 136715 Dec 04 136.51
135818* D ec 14 63.56 136691" Dec 04 1 m 138.99 136716 Dec 04 338.84
136391 * Dec 12 151.43, 136692 Dec 04 l 13,6717 Dec 19 132.98
136449* D ec 14 58.03 136693 D eli 12 86.61 136718 Dec 12 43.70
1 J 64 78 * D ec 12 151,45 136694 Dec 05 52.58 136719 Dec 26 211,.36
136522* Dec 05 51.87 136695 Dec 0-4 395.37 136721 D ec 19 162.05
136524* Dec 04 15 6,62 136696 D ec 14 65.83 136722 Dec 07 12250
136528* Dec 12 14.81 136697 Dec 05 183.91 1.36723 Dec 03 2'411,72
136535* D ec 14 70.64 136698 Dec 05 106.77 136724 Dec 04 863.74
136542* Dec 03 140.38 136699 Dec 07 74.17 136725 D ec 18 9,28
136547* D ec 05' 35.87 136700 Dec 04 208. 17 136726 D ec 20.66
136566" D ec 12 151.44 136701 Dec 12 210.56 136727 D ec 376.39
136581 " Dec 14 203.17 136702 Dec 04 159.55 136728 Dec 06 9.44
136612* Dec 05 54.91 136703 Dec 07 118.93 .136729 Dec 26 9.29
136614* Dec 04 15 8.61 136704 Dec 03 27.58 136730 Dec 03 104.15
136620* Dec 06 307.37 136705 Dec 04 108.01 136731 D ec 04 514.46
136624* D ec 14 76.18 136706 Dec 06 46398 136733* Dec 04 1,961.58
136627* Dec 11 237 10 1367,07 Dec 04 145.14 136734 Dec 04 1,831.33
136634* Dec 03 161.40 13-6708 Dec 04 176� 12 136735 Dec 05 224.69
136637* Dec 05 86.36 136709 Dec 04 64.85 136736 Dec 03 42 7.95
136639* Dec 05 35.86 136710 D ec 14 47.16 136737 Dec 04 80.19,
136657* Dec 03 206..33 136714 Dec 04 465.85 136738 Dec 03 186.24
136660" Dec 12 151.44 136712 Dec 07 92..66 136739 D ec 18 30.09
136661 Dec 04 154.23 136714* Dec 05 71.97 136740 Dec 12 66.09
Continued an next pa
10954905 11 000446 1 02 1 0 10 10 10 1
a �
Page 3 of 4
2,344
City Of Brooklyn Center Account ' , r: 000-1010008
Payroll Account 10 MOB
Statement End .Bate. 1213 7107
C a
Ch # Date Amount Check # Date Amount Check # Date Amount
.+ r ..a . a e r i i . •Y ! t t i f . t B t. t e.. a a. t a s h i t{ t..r t .. a t a a a n .. .. .. e . a. . e- e r a e a .. e r fi r .. i r. r. e ... . a ...... r ...,-... .... r ....... .. a. a .. . a ....... . a ........• .. . r... .. ... ..................... ........ a ...... .
136741 Dec 3 133.21 136807 D ec 12 71 7.07 136876 Dec 20 30 4.3
136742 D ec 0 4 238.12 136808 Dec 10 98.27 138877 Dec 18 181.8 #
1 36744* Dec 34 313.29 136809 Dec IS 294.94 136878 Dec 18 905.39
136745 Dec 0 3 1, 7.59 136810 Dec 17' 79&03 136879 Dec 18 9
136748 Dec 03 187-39 136811 Dec 17 113.93 136880 Dec 18 749.01
138747 Dec 04 576.86 136812 Dec 18 166.52 136881 Dec 17 2 1 70x06
136748 Dec 05 35.49 136813 Dec 17 398.37 138882 Dec 18 583.56
136749 Dec 03 567.93 136814 Dec 18 19E65 136883 Dec 18 1,576.35
136750 Dec 0 4 73.45 136816# Dec 20 20.33 136884 Dec 1 7 1
136751 Dec 04 363.34 136817 Dec 31 260.69 136885 Dec 17 978..80
138752 Dec 04 17 .81 1"18 Dec 21 136x04 136336 Dec 14 1
138753 Dec 04 2,041.11 136819 D ec 13 81.23 f368 Dec 17 32510
136754 Dec 3 823, 81 13682 Dec 26 7 . '8 1,16888 Dec 19 620.02
138755 Dec 0 4 2, 493.49 136821 Dec 31 55. 14 136889 Dec 18 394.00
138786 Dec 03 35,3.36 136822 Dec 18 99. 69 136890 Dec 18 4 '7.81
136757 D ec 04 2.460.36 136823 Dec 18 294.59 136891 Dec 2 423.49
136738 Dec 04 1,247.04 136824 Dec 18 133.22 136892 Dec 28 402.3'3
136759 Dec 05 1 136825 Dec 2 4 48.24 136833 D ec 18 111.54
138761 Dec 07 418-30 136826 Dec 17 68.13 136894 Dec 17 1
136 762 Dec 06 445. 11 136827 Dec 26 181.11 136895 Dec 17 1, 224.08
138763 Dec 04 416.24 13 3 * Dec 26 315.80 136896 Dec 14 1, 6 '4.64
136764 Dec 05 599..8 136832* D ec 19 341.26 136897 Dec 17 850.76
136765 Dec 24 393.99 136833 D 31 74.0'3 136,993" Dec 31 796..48
36760 Dec 04 433.43 136835* D ec 4 206.8 1 36994 Dec 31 105.17
136767 Dec 04 652.38 136836 Dec 24 61 .78 136995 Dec 31 395.38
136768 D er, 0 4 847.87 136637 Dec 20 81,28 1 36997 * Dec 31 293+
136769 Dec 04 1, 182.39 136838 D ec 19 107.94 1 37002 * Dec 31 99.15
36771 Dec 04 843.71 136833 Dec 18 211.83 137003 Dec 31 158.69
1 36772 Dec 12 l o , 196-19 13684' Dec 20 319.88 137005 Dec 31 27.58
36773 Dec 13 859 97 138841 Dec 24 73.54 13701 Dec 31 125.33
138774 Dec 3 346.39 1,36642 Dec 21 320,02 137018* Dec 3 1 344.83
138775 Dec 12 1,189.77 136845* Dec 20 192.08 137919 Dec 31 192.1
136776 Dec 12 2,559.86 13 684 6 Dec 1 44.32 137020 Doc 31 5Z5
136777 D ec 12 1 136847 Dec 26 86.36 137021 Dec 3 1 339.86
136778 Dec 12 879.54 136848 Dec,26 1 92.33 137022 Dec 31 2Z67
136779 Doc 10 1 56 136849 Dec 20 130.84 13 7038 * Dec 3 1 2
136780 Dec 12 1 t 26& 09 136850 Doc 24 37,83 13 7040 * Dec 28 141.
136781 e 12 983.78 136851 Dec 17 Z f 7 .17 137041 1 313.40
136782 Der, 12
857.88 1 36852 D ec 18 1, 029.06 137042
Dec W 75.52
38783 Dec 18 24 .45 136853 Dec 17 143.84 137043 Dec 31 74.3
1 38784 Dec 10 1, 19Z35 136854 Dec 18 453x27 137045* Dec 31 664.43
136785 Dec 17 602.05 136855 Dec 17 22Z60 137047* Dec 31 2 042.88
138788 Dec 12 397.6 ' 136856 Dec 18 712.92 1370.59* Dec 3 322_89
136787 Dec 10 � 11 x.04 136858* Dec 18 Z 182,91 137052' Doc 31 188_25
1 36788 D ec 12 922.05' 136859 Dec 17 1, 694..9 7 137054* Dec 28 1 57.96
136789 Dec 12 228.86 136860 Dec 20 224. 69 137056* Dec 28 611.
136790 Dec 208.60 136801 Dec 2 322.88 137057 Dec 31 258.62
138791 Dec IL 3 662.26 136862 D ec 1 80.9 137058 Dec 3 1 300.00
136792 Dec 11 926.64 136863 D ec 19 186.24 -137059 Dec 31 152M
1 36793 D ec 2 1 185.73 136864 D eg 18 12.03 137060 Dec 3 1 582.13
36794 Dec 07 3,80&28 136866* Dec 14 94.16 137062* Dec 28 7 5.06
138795 D ec 12 4M82 136867 Dec 31 70.89 137063 D ec 31 185.30
135797* Dec 10 1.071=47 136868 Dec 14 573.47 137084 Dec 31 307. 11
136798 Dec 12 795.79 136869 Dec 17 165.50 137065 Dec 31 984.02
36799 Dec 2 6 1,197.47 136870 Dec 14 153.52 137067 Dec 31 596.68
13 Dec 97 1,05L54 136871 Dec 17 144.34 137068 Dec 31 1,933.34
1361 Dec 12 718.39 136872 Dec 18 X8'.87 137069 Dec 28 573.88
136802 Dec 12 1 136873 Dec 18 185.08 137072 Dec 31 978.80
136834* Dec 12 Iw55.77 136874 Dec 14 71'36 137073 Dec 31 98 1.76
136806* Dec 10 80731 136875 Dec 8 102,85 137074 Dec 31 418.48
Continued on next page
1 11110111111111111111111111i 111111111111,111111111 117 [1111111111111 whl F*�4RW %I 1 It (I in A1A I nAI A A A I A 1 d , .
i
e e 4 of
City Of Brooklyn Center Account N umber. , 000- 1010008
Payroll Ac 1018
S tateme n t End Date: 121311
C hecks Paid
Cheek # Da Amount Check # Date Amount Cheer # Date Amount
.........;.._...# 4#. #...z. #...___taraia -sart. ii ....,............. .,........... F # ■ #�i -.. iiiil ...... ......,�.., _ ... ....... . ..... 1 � # '.a- a � b ..... . 4 . c # t Y + ! # ! #a r a r i . i .
e ,"' .! Dec 1 684.
137078* D ec 28 5 1 7 .74 1 37082 Dec 1 I 137084 Dec 31 850.
. a ............ ... ....... .- .. ..° 4 # r # . # . # . ! . # F ! + a ■ i a a ! i t=r ■ t 4 . i cF i . a .... .. ............ .. .. . i .. . ...... # . .. a . . a .... ... r ... .... .. r .. .. .. . a
*Gap in check sequence 134,524,00 Total Checks Paid
..:.............................Fi.a. aa=i... a...........-.. ......................._..:.. +. F i. ..... .. ......... ! #.. Y. .......F a..... .........- ..................... . �..
# #Fi # -Fi #ii •tii d�.
.... . . .
910,741.90 Total Debits
D a ily L edger Balanc Summary
Date Balance Date Balance Date Balance
... . . a ......... .
....a. _ #- Fii..� #�!!! #.l aFtlara #iii .•i ii lii :.ii .. ii.si.i.
N ov 0. 0 0 Dec 11 0.00 D ec 20 O M
D ec 03 0.00 Dec 12 0.00 Dec 2 1 0.00
D ec .' D ec 13 0.00 Dec 24 0.00
D ec 05 0,00 Dec 14 0.00 Dec 26 0.00
Dec 06 0.00 ec 17 0.00 Dec 28 0.00
Dec 07 0.00 Dec 18 0.00 Dec 31 0.00
Dec 10 0.00 Dec 19 0.00
verage Da ily L edger B glance 0.00
Wells Fargo has inn solutions designed to meet your business needs
I Credit SeivIces I Business Payrol Services 1 F- u ipment Pinang
I Treasury Management Services i Internatio Trade ServIces 1 Corporate Finance
For more informa an our products and services,
p lease contact y our Wells F ro representative or visit us o nii n a t - elt l r *
NOTICE: vii Fargo Bank, N.A. may fu rnish informati a bout accounts belong to individua including sol
proprietorships, to co nsu mer reponi agencies. If this applies to you, you have the right to i u to the accuracy of
info that we have reported . writing to us at: v r raft Collecti and Recovery PO Box 5058 Portland,,
OR . 97208-5058. You must describe the specific informati that is inacrurate or in dispute and the basis for arl
disp ute with suppo documentation. In the case of information that relates to are identity theft, you w ill reed to
p rovide u. s with a identity theft report.
Thank you for banking with Wells Fargo. Member FDI
� 0954803 1 1000446104 [ 01 01 01 10 1 n
CITY OF BROOKLYN CENTER
PETTY CASH FUNDS
12/31/2007
12/31/2007 12/31/2006
GENERAL FUND:
City Clerk 200.00 200.00
Police Admin 135.00 100.00
Parks 100.00 100.00
Police - 435.00 50.00 450.00
ENTERPRISE FUNDS:
EBHC 200.00 200.00
TOTAL CITY PETTY CASH 635.00 650.00
CHANGE FUNDS
GENERAL FUND:
Main Reception 175.00 175.00
Finance 1 1
Police Department 75.00 50.00
CARS 150.00 1 150.00 1
Liquor Store #1 2 2
Liquor Store #2 2 5 2 5
Centerbrook 400.00 400.00
TOTAL CHANGE FUNDS 7,500.00 7,475.00
Petty Cash & Change Funds