Loading...
3.5. Revenue Expenditure Report 12-14-200910-05-2009 08:43 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2009 920-EDA FINANCIAL SUMMARY 75.00 OF YEAR COMP. CURRENT CURRENT YEAR TO DATE ~ OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY EDA TOTAL REVENUES EXPENDITURE SUMMARY Economic Development Economic Development TOTAL Economic Development TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 432,500 .00 992.03 210,161. 65 48. 59 222,338 .35 432,500 .00 992.03 210,161. 65 48. 59 222,338 .35 283,100. 00 22,090.48 167,563. 24 59.19 115,536. 76 283,100. 00 22,090.48 167,563. 24 59.19 115,536. 76 283,100. ----------- 00 -- - 22,090.48 ------------ - 167,563. ---------- 24 59.19 -- ------- - 115,536. ---------- 76 -- 149,400. 00 ( 21,098.45) 42,598. 41 106,801. 59 10-05-2009 08:43 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2009 920-EDA 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE EDA Taxes 920-3-0000-3111 Current Ad Valorem Taxes TOTAL Taxes Intergovernmental Rev 920-3-0000-3342 Other Local Grants TOTAL Intergovernmental Rev Other Revenue 920-3-0000-3621 Interest Income 920-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 920-3-0000-3949 Transfer-HRA TOTAL Transfers In 407,000.00 407,000.00 0.00 0.00 22,000.00 991.21 0.00 0.82 22,000.00 992.03 9,716.62 44.17 12,283.38 0.82 0.00 ( 0.82) 9,717.44 44.17 12,282.56 3,500.00 0.00 3,500.00 100.00 0.00 3,500.00 0.00 3,500.00 100.00 0.00 0.00 195,444.21 48.02 211,555.79 0.00 195,444.21 48.02 211,555.79 0.00 1,500.00 0.00 ( 1,500.00) 0.00 1,500.00 0.00 ( 1,500.00) TOTAL EDA 432,500. 00 992. 03 210,161 .65 48 .59 222,338.35 TOTAL REVENUE 432,500. ----------- 00 -- --- 992. -------- 03 -- 210,161 ---------- .65 --- 48 ---- .59 --- 222,338.35 ------------- 10-OS-2009 08:43 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2009 920-EDA Economic Development 75. 00% OF YEAR COMP. Economic Development CURRENT CURRENT YEAR TO DATE $ OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 920-4-6210-4101 Regular Pay 80,450 .00 13,586 .38 49,335 .05 61 .32 31,114 .95 920-4-6210-4103 Part-time Pay 12,600 .00 3,150 .96 8,402 .56 66 .69 4,197 .44 920-4-6210-4104 PERA 5,900 .00 984 .63 3,658 .85 62 .01 2,241 .15 920-4-6210-4105 FICA 5,800 .00 922 .61 3,253 .07 56 .09 2,546 .93 920-4-6210-4107 Medicare 1,350 .00 215 .81 760 .94 56 .37 589 .06 920-4-6210-4108 Insurance 10,800 .00 1,060 .36 5,217 .80 48 .31 5,562 .20 920-4-6210-4109 Workers Comp 350 .00 0 .00 255 .90 73 .11 94 .10 TOTAL Personal Services 117,250 .00 19,920 .75 70,884 .17 60 .46 46,365 .83 Supplies 920-4-6210-4201 Office Supplies 2,700 .00 325 .85 1,388 .48 51. 43 1,311 .52 520-4-6210-4212 Fuels & Lubs 150 .00 0 .00 0 .00 0. 00 150 .00 TOTAL Supplies 2,850 .00 325 .85 1,388 .48 48. 72 1,461 .52 Other Services & Charges 920-4-6210-4304 Legal Fees 10,000 .00 0 .00 0 .00 0. 00 10,000 .00 920-4-6210-4319 Other Professional Services 58,000 .00 18 .97 59,161 .05 102. 00 ( 1,161 .05) 920-4-6210-4321 Telephone 200 .00 0 .00 0 .00 0. 00 200 .00 920-4-6210-4322 Postage 2,000 .00 0 .00 573 .47 28. 67 1,426 .53 920-4-6210-4331 Travel, Conferences & Schools 8,700 .00 1,440 .41 7,094 .71 81. 55 1,605 .29 920-4-6210-4349 Advertising/Marketing 58,600 .00 0 .00 9,174 .31 15. 66 49,425 .69 920-4-6210-4359 Publishing 600 .00 0 .00 0 .00 0. 00 600 .00 920-4-6210-4361 Insurance 200 .00 0 .00 0 .00 0. 00 200 .00 920-4-6210-4433 Dues & Subscriptions 1,700 .00 384 .50 2,238 .25 131. 66 ( 538 .25) 920-4-6210-4440 Miscellaneous 6,000 .00 0 .00 48 .80 0. 81 5,951 .20 TOTAL Other Services & Charges 146,000. 00 1,843 .88 78,290 .59 53. 62 67,709 .41 Transfers Out 920-4-6210-4721 Transfer-General Fund 17,000. 00 0 .00 17,000 .00 100. 00 0 .00 TOTAL Transfers Out 17,000. 00 0 .00 17,000 .00 100. 00 0. 00 TOTAL Economic Development 283,100. 00 22,090 .48 167,563. 24 59. 19 115,536. 76 TOTAL Economic Development 283,100. 00 22,090. 48 167,563. 24 59. 19 115,536. 76 TOTAL EXPENDITURES 283,100. 00 22,090. 48 167,563. 24 59. 19 115,536. 76 REVENUES OVER/(UNDER) EXPENDITURES 149,400. 00 ( 21,098. 45) 42,598. 41 106,801. 59 10-05-2009 8:42 AM D E T A I L L I S T I N G PAGE: 3 FUND 920- EDA PERIOD TO USE: Sep-2009 T HRU Sep-2009 DEPT 6210 Economic Development SUPPRESS Z EROS ACCOUNTS: ALL POST DATE TRAM # REFERENCE PACKET======DESCRIPTION------- VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== FUND: 920-EDA ______________ _______ ___________________________________________ ____ ________________ ______________ _____________ ___ _____________ _____ 4-6210-4 201 office Supplies B E G I N N I N G B A L A N C E 1, 062 .63 9/14/09 9/10 A00198 CHK: 003858 00389 2010 PLANNER 16112 10 .68 1,073 .31 ANNIE DECKERT INV# 091409 /PO# 9/14/09 9/10 A00201 CHK: 003861 00389 OFFICE SUPPLIES 17440 35 .71 1,109 .02 CITY OF ELK RIVER INV# 09142009 /PO# 9/14/09 9/10 A00201 CHK: 003861 00389 COLOR TONER CARTRIDGES 17440 279 .46 1,388 .48 CITY OF ELK RIVER INV# 09142009. /PO# _____________ SEPTEMBER ACTIVITY DB: 3 25.85 CR: 0.00 325 .85 4-6210-4 319 Other Professional Services B E G I N N I N G B A L A N C E 59, 142 .08 9/14/09 9/10 A00203 CHK: 003863 00389 FAST SERVICES - JULY 21475 18 .97 59,161 .05 HOISINGTON KOEGLER GROUP INV# 008-065-9 /PO# ------------= SEPTEMBER ACTIVITY DB: 18.97 CR: 0.00 18 .9'7 4-6210-4 331 Travel, Conferences & Schools B E G I N N I N G B A L A N C E 5,654 .30 9/01/09 9/16 A00206 CHK: 000116 00395 AMERICAN - TRAINING AIRF 35099 249 .20 5,903 .50 US BANK INV# 8252009 /PO# 9/14/09 9/10 A00198 CHK: 003858 00389 MILEAGE 16112 105 .33 6,008 .83 ANNIE DECKERT INV# 091409 /PO# 9/14/09 9/10 A00199 CHK: 003859 00389 NDC TRAINING EXP 16112 444 .90 6,453 .73 ANNIE DECKERT INV# 09142009 /PO# 9/14/09 9/10 A00204 CHK: 003864 00389 NDC TRAINING EXP-DECKERT 10462 640 .98 7,094 .71 ST LOUIS UNION STATION INV# 80097613 /PO# _____________ SEPTEMBER ACTIVITY DB: 1,4 40.41 CR: 0.00 1,440 .41 4-6210-4433 Dues & Subscriptions B E G I N N I N G B A L A N C E 1, 853. 75 9/14/09 9/10 A00200 CHK: 003860 00389 MEMBERSHIP DUES-DECKERT 10325 34. 50 1,888. 25 ELK RIVER AREA TOASTMASTE INV# 37 /PO# 9/14/09 9/10 A00202 CHK: 003862 00389 CLUB DUES 7/1/09-12/ 31/0 17792 350. 00 2,238. 25 ELK RIVER ROTARY CLUB INV# 61 /PO# ------------= SEPTEMBER ACTIVITY DB: 384.50 CR: 0.00 384. 50 10-OS-2009 8:42 AM D E T A I L L I S T I N G PAGE: 4 FUND 920-EDA PERIOD TO USE: Sep-2009 THRU Sep-2009 DEPT 6230 Business Incubator SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! *-*-*-*-*-*-*-*-*-*-*-*-*-* ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 77,509.34 0.00 REPORTED ACTIVITY: 2,169.73 0.00 ENDING BALANCES: 79,679.07 0.00 11-OS-2009 09:24 AM CITY OF ELK RIVER PAGE: 1 OCTOBER 31, 2009 BALANCE SHEET AS OF: OCTOBER 31ST, 2009 920-EDA ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 920-1010 Cash - EDA 1,043,717.03 1,043,717.03 TOTAL ASSETS 1,043,717.03 -------------- LIABILITIES EQUITY 920-2400 Fund Balance 1,001,548.55 TOTAL BEGINNING EQUITY 1,001,548.55 TOTAL REVENUE 219,134.11 TOTAL EXPENSES 176,965.63 TOTAL REVENUE OVER/(UNDER) EXPENSES 42,168.48 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 1,043,717.03 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 1,043,717.03 11-OS-2009 09:23 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2009 920-EDA FINANCIAL SUMMARY 83. 33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY EDA 432,500.00 8,972.46 219,134.11 50 .67 213,365.89 TOTAL REVENUES 432,500.00 8,972.46 ------------- ------------- ------------- ------------- 219,134.11 ------------- ------------- 50 ---- ---- .67 --- --- 213,365.89 ------------- ------------- EXPENDITURE SUMMARY Economic Development Economic Development TOTAL Economic Development TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 283,100. 00 9,402 .39 176,965 .63 62.51 106,134. 37 283,100. 00 9,402 .39 176,965 .63 62.51 106,134. 37 283,100. 00 9,402 .39 176,965 .63 62.51 106,134. 37 149,400. 00 ( 429 .93) 42,168 .48 107,231. 52 it-OS-2009 09:23 AM 920-EDA REVENUES CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2009 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE GDA Taxes 920-3-0000-3111 Current Ad Valorem Taxes TOTAL Taxes Intergovernmental Rev 920-3-0000-3322 MV Credit 920-3-0000-3342 Other Local Grants TOTAL Intergovernmental Rev Other Revenue 920-3-0000-3621 Interest Income 920-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 920-3-0000-3949 Transfer-HRA TOTAL Transfers In TOTAL EDA 407,000 .00 0. 00 195,444. 21 48. 02 211,555. 79 407,000 .00 0 .00 195,444. 21 48. 02 211,555. 79 0 .00 7,087. 56 7,087. 56 0. 00 ( 7,087. 56) 0 .00 0 .00 1,500. 00 0. 00 ( 1,500. 00) 0 .00 7,087. 56 8,587. 56 0. 00 ( 8,587. 56) 22,000 .00 917 .34 10,633. 96 48. 34 11,366. 04 0 .00 967. 56 968. 38 0. 00 ( 968. 36) 22,000 .00 1,884. 90 11,602. 34 52. 74 10,397. 66 3,500 .00 0. 00 3,500. 00 100. 00 0. 00 3,500 .00 0 .00 3,500. 00 100. 00 0. 00 432,500.00 8,972.46 219,134.11 50.67 213,365.89 'TOTAL REVENUE 432,500.00 8,972.46 219,134.11 50.67 213,365.89 ------------- ------------- ------------- ------- ------------- ------------- ------------- ------------- ------- ------------- 11-OS-2009 09:23 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPOR T (UNAUDITED) AS OF: OCTOBER 31ST, 2009 920-EDA Economic Development 83 .33% OF YEAR COMP. Economic Development CURRENT CURRENT YEAR TO D ATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 920-4-6210-4101 Regular Pay 80,450 .00 0 .00 49,335 .05 61 .32 31,114 .95 920-4-6210-4103 Part-time Pay 12,600 .00 0 .00 8,402 .56 66 .69 4,197 .44 920-4-6210-4104 PERA 5,900 .00 0 .00 3,658 .85 62 .01 2,241 .15 920-4-6210-4105 FICA 5,800 .00 0 .00 3,253 .07 56 .09 2,546 .93 920-4-6210-4107 Medicare 1,350 .00 0 .00 760 .94 56 .37 589 .06 920-4-6210-4108 Insurance 10,800 .00 0 .00 5,217 .80 48 .31 5,582 .20 920-4-6210-4109 Workers Comp 350 .00 0 .00 255 .90 73 .11 94 .10 TOTAL Personal Services 117,250 .00 0 .00 70,884 .17 60 .46 46,365 .83 supplies 920-4-6210-4201 Office Supplies 2,700 .00 174 .04 1,562 .52 57 .87 1,137 .48 920-4-6210-4212 Fuels & Lubs 150 .00 0 .00 0 .00 0 .00 150 .00 TOTAL Supplies 2,850 .00 174 .04 1,562 .52 54 .83 1,287 .48 Other Services & Charges 920-4-6210-4304 Legal Fees 10,000. 00 0 .00 0 .00 0 .00 10,000 .00 920-4-6210-4319 Other Professional Services 58,000 .00 7,472 .75 66,633 .80 114 .89 ( 8,633 .80) 920-4-6210-4321 Telephone 200 .00 0 .00 0 .00 0 .00 200 .00 920-4-6210-4322 Postage 2,000. 00 0 .00 573 .47 28 .67 1,426 .53 920-4-6210-4331 Travel, Conferences & Schools 8,700. 00 726 .80 7,821 .51 89 .90 878 .49 920-4-6210-4349 Advertising/Marketing 58,600 .00 768 .80 9,943 .11 16 .97 48,656 .89 920-4-6210-4359 Publishing 600. 00 0 .00 0 .00 0 .00 600 .00 920-4-6210-4361 Insurance 200. 00 0 .00 0 .00 0 .00 200 .00 920-4-6210-4433 Dues & Subscriptions 1,700. 00 260 .00 2,498 .25 146 .96 ( 798 .25) 920-4-6210-4440 Miscellaneous 6,000. 00 0 .00 48 .80 0 .81 5,951 .20 TOTAL Other Services & Charges 146,000. 00 9,228 .35 87,518 .94 59 .94 58,481 .06 Transfers Out 920-4-6210-4721 Transfer-General Fund 17,000. 00 0 .00 17,000 .00 100. 00 0. 00 TOTAL Transfers Out 17,000. 00 0. 00 17,000 .00 100. 00 0. 00 TOTAL Economic Development 283,100. 00 9,402. 39 176,965 .63 62. 51 106,134. 37 TOTAL Economic Development 283,100. 00 9,402. 39 176,965 .63 62. 51 106,134. 37 TOTAL EXPENDITURES 283,100. 00 9,402. 39 176,965. 63 62. 51 106,134. 37 REVENUES OVER/(UNDER) EXPENDITURES 149,400. 00 ( 429. 93) 42,168. 48 107,231. 52 11 -OS-2009 9:21 AM D E T A I L L I S T I N G PAGE: 4 FUND 920 -EDA PERIOD TO USE: Oct-2009 T HRU OCt-2009 DEPT 6210 Economic Development SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== FUND: 920-EDA - - --------------------- 4-6210-4201 ------------------------------------------- Office Supplies ---- -- -- ---------- -------------- ------------- --- ------------- ----- B E G I N N I N G B A L A N C E 1, 388 .48 10/12/09 10/13 A00211 CHK: 003866 00412 TONER & PRINT CARTRIDGES 17440 136 .19 1,524 .67 CITY OF ELK RIVER INV# 101209 /PO# 10/12/09 10/13 A00211 CHK: 003866 00412 OFFICE SUPPLIES 17440 25 .28 1,549 .95 CITY OF ELK RIVER INV# 101209. /PO# 10/12/09 10/13 A00211 CHK: 003866 00412 GENL OFFICE SUPPLIES 17440 12 .57 1,562 .52 CITY OF ELK RIVER INV# 10122009 /PO# _____________ OCTOBER ACTIVITY DB: 1 74.04 CR: 0.00 174 .04 4- 6210-4319 Other PYOfeSSiorial Services B E G I N N I N G B A L A N C E 59, 161 .05 10/12/09 10/13 A00212 CHK: 003867 00412 AUG FAST PHASE 2 SVCS 21475 2,797 .90 61,958 .95 HOISINGTON KOEGLER GROUP INV# 009-025-1 /PO# 10/12/09 10/13 A00212 CHK: 003867 00412 SEPT FAST PHASE 2 SVCS 21475 4,674 .85 66,633 .80 HOISINGTON KOEGLER GROUP INV# 009-025-2 /PO# _____________ OCTOBER ACTIVITY DB: 7,4 72.75 CR: 0.00 7,472 .75 4- 6210-4331 Travel, Conferences & Schools B E G I N N I N G B A L A N C E 7,094 .71 10/07/09 10/14 A00217 CHK: 000118 00416 SENSIBLE LAND USE - REG. 35099 38 .00 7,132 .71 US BANK INV# 9252009 /PO# 10/12/09 10/13 A00210 CHK: 003865 00412 LEADERSHIP ELK RIVER DEC 17355 325 .00 7,457 .71 ELK RIVER AREA CHAMBER OF INV# 753 /PO# 10/12/09 10/13 A00213 CHK: 003868 00412 MAY-AUG MILEAGE/MTG EXP 25140 363 .80 7,821 .51 CATHERINE MEHELICH INV# 101209 /PO# ------------- OCTOBER ACTIVITY DB: 726.80 CR: 0.00 726 .80 4-6210-4349 Advertising/Marketing B E G I N N I N G B A L A N C E 9, 174. 31 10/07/09 10/14 A00217 CHK: 000118 00416 COBORNS - ENTERPRISE MN 35099 77. 12 9,251. 43 US BANK INV# 9252009 /PO# 10/07/09 10/14 A00217 CHK: 000118 00416 PANERA - ENTERPRISE MN E 35099 40. 96 9,292. 39 US BANK INV# 9252009 /PO# 10/07/09 10/14 A00217 CHK: 000118 00416 CARIBOU - ENTERPRISE MN 35099 69. 47 9,361. 86 US BANK INV# 9252009 /PO# 11-OS-2009 9:21 AM D E T A I L L I S T I N G PAGE: 5 FUND 920- EDA PERIOD TO USE: Oct-2009 THRU Oct-2009 DEPT 6210 Economic Development SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== 10/12/09 10/13 A00214 CHK: 003869 00412 MNCAR DUES DECKERT 10324 195.00 9,556. 86 THE MNCAR EXCHANGE INV# 111602 /PO# ?.0/12/09 10/13 A00215 CHK: 003870 00412 QTRLY MEMBER FEES 10324 386.25 9,943. 11 THE MNCAR EXCHANGE INV# 513064 /PO# ------------= OCTOBER ACTIVITY DB: 768.80 CR: 0.00 768.80 4-6210-4433 Dues ~ Subs criptions B E G I N N I N G B A L A N C E 2, 238. 25 10/12/09 10/13 A00210 CHK: 003865 00412 MEMBERSHIP FEES 17355 260.00 2,498. 25 ELK RIVER AREA CHAMBER OF INV# 842 /PO# ------------= OCTOBER ACTIVITY DB: 260.00 CR: 0.00 260.00 *-*-*-*-*-*-*-* -*-*-*- *-*- 000 ERRORS IN THIS REPORT! *_*_ *_*_*_+_* _*_*_*_*_*_*_* ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 79,679 .07 0. 00 REPORTED ACTIVITY: 9,402 .39 0. 00 ENDING BALANCES: 89,081 .46 0. 00 12-04-2009 01:00 PM CITY OF ELK RIVER PAGE: 1 NUVEMBER 3of 2~~7 BALANCE SHEET AS OF: NOVEMBER 30TH, 2009 920-EDA ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 520-1010 CdSh - EDA 1,038,192.31 1,038,192.31 TOTAL ASSETS 1,038,192.31 LIABILITIES EQUITY 920-2400 Fund Balance 1,001,548.55 TOTAL BEGINNING EQUITY 1,001,548.55 TOTAL REVENUE 218,975.60 TOTAL EXPENSES 182,331.84 TOTAL REVENUE OVER/(UNDER) EXPENSES 36,643.76 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 1,038,192.31 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 1,038,192.31 12-04-2009 12:58 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2009 920-EDA FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY EDA 432,500 .00 ( 158. 51) 218,975. 60 50. 63 213,524 .40 TOTAL REVENUES 432,500 .00 ( 158. 51) 218,975. 60 50. 63 213,524 .40 EXPENDITURE SUMMARY Economic Development Economic Development 283,100 .00 5,366. 21 182,331. 84 64.41 100,768. 16 TOTAL Economic Development 283,100 .00 5,366. 21 182,331. 84 64.41 100,768. 16 TOTAL EXPENDITURES 283,100 .00 5,366. 21 182,331. 84 64.41 100,768. 16 REVENUES OVER/(UNDER) EXPENDITURES 149,400 .00 ( 5,524. 72) 36,643. 76 112,756. 24 12-04-2009 12:58 PM 520-EDA REVENUES EDA Taxes 920-3-0000-3111 Current Ad Valorem Taxes TOTAL Taxes IntergOVerrimeritdl Rev 920-3-0000-3322 MV Credit 920-3-0000-3342 Other Local Grants TOTAL Intergovernmental Rev Other Revenue 920-3-0000-3621 Interest Income 920-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue 'T'ransfers In 520-3-0000-3949 Transfer-HRA TOTAL Transfers In CZTY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2009 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 407,000. 00 0. 00 195,444 .21 48 .02 211,555 .79 407,000. 00 0. 00 195,444 .21 48 .02 211,555 .79 0. 00 0. 00 7,087 .56 0 .00 ( 7,087 .56) 0. 00 0. 00 1,500 .00 0 .00 ( 1,500 .00) 0. 00 0. 00 8,587 .56 0 .00 ( 8,587 .56) 22,000. 00 809. 05 11,443 .01 52 .01 10,556 .99 0. 00 ( 967. 56) 0 .82 0 .00 ( 0 .82) 22,000. 00 ( 158. 51) 11,443 .83 52 .02 10,556 .17 3,500. 00 0. 00 3,500 .00 100 .00 0 .00 3,500. 00 0. 00 3,500 .00 100 .00 0 .00 TOTAL EDA 432,500. 00 ( 158. 51) 218,975 .60 50 .63 213,524 .40 TOTAL REVENUE 432,500. -------- ----------- 00 ( -- -- -- --- 158. ------- -------- 51) -- -- - 218,975 ------- --------- .60 --- --- 50 --- ---- .63 - --- 213,524 -------- ---------- .40 -- --- 12-09-2009 12:58 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2009 920-EDA Economic Development Economic Development DEPARTMENTAL EXPENDITURES 91.67°s OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 920-9-6210-4101 Regular Pay 80,450 .00 0 .00 49,335 .05 61 .32 31,114 .95 920-4-6210-4103 Part-time Pay 12,600 .00 0 .00 8,402 .56 66 .69 4,197 ,44 920-4-6210-4104 PERA 5,900 .00 0 .00 3,658 .85 62 .01 2,241. 15 920-4-6210-4105 FICA 5,800 .00 0 .00 3,253. 07 56 .09 2,546. 93 920-4-6210-4107 Medicare 1,350 .00 0 .00 760. 94 56 .37 589. 06 920-4-6210-4108 Insurance 10,800 .00 0 .00 5,217. 80 48 .31 5,582. 20 920-4-6210-4109 Workers Comp 350 .00 98 .00 353. 90 101 .11 ( 3. 90) TOTAL Personal Services 117,250 .00 98 .00 70,982. 17 60 .54 46,267. 83 Supplies 920-4-6210-4201 Office Supplies 2,700 .00 352 .69 1,915. 21 70 .93 784. 79 920-4-6210-4212 Fuels & Lubs 150 .00 0 .00 0. 00 0 .00 150. 00 TOTAL Supplies 2,850 .00 352 .69 1,915. 21 67 .20 934. 79 Other Services & Charges 920-4-6210-4304 Legal Fees 10,000. 00 0 .00 0. 00 0 .00 10,000. 00 920-4-6210-4319 Other Professional Services 58,000. 00 0 .00 66,633. 80 114 .89 ( 8,633. 60) 920-4-6210-4321 Telephone 200. 00 0 .00 0. 00 0 .00 200. 00 920-4-6210-4322 Postage 2,000. 00 142 .35 715. 82 35 .79 1,284. 18 920-4-6210-4331 Travel, Conferences & Schools 8,700. 00 763 .56 8,585. 07 98 .68 114. 93 920-4-6210-4349 Advertising/Marketing 58,600. 00 3,863 .61 13,806. 72 23 .56 44,793. 28 920-9-6210-4359 Publishing 600. 00 0 .00 0. 00 0 .00 600. 00 920-4-6210-4361 Insurance 200. 00 146 .00 146. 00 73 .00 54. 00 920-4-6210-4433 Dues & Subscriptions 1,700. 00 0 .00 2,498. 25 146 .96 ( 798. 25) 920-4-6210-4440 Miscellaneous 6,000. 00 0 .00 48. 80 0 .81 5,951. 20 TOTAL Other Services & Charges 146,000. 00 4,915 .52 92,434. 46 63 .31 53,565. 54 Transfers Out 920-4-6210-4721 Transfer-General Fund 17,000. 00 0. 00 17,000. 00 100. 00 0. 00 TOTAL Transfers Out 17,000. 00 0. 00 17,000. 00 100. 00 0. 00 TOTAL Economic Development 283,100. 00 5,366. 21 182,331. 84 64. 41 100,768. 16 TOTAL Economic Development 283,100 .00 5,366 .21 182,331 .84 64.41 100,768 .16 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 283,100 199,400 .00 .00 ( 5,366. 5,524. 21 72) 182,331. 36,643. 84 64.41 76 100,768. 112,756. 16 24 12-04-2009 12:59 PM D E T A I L L I S T I N G PAGE: 4 FU ND 920 -EDA PERIOD TO USE: Nov-2009 T HRU Nov-2 009 DE PT 621 0 Economic Development SUPPRESS Z EROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ==== BALANCE==== FUND: 92 0-EDA ________ 4- _____________ 6210-4201 __________________________________________ Office Supplies _____ ________________ ______________ _____________ _________ _______ _____ B E G I N N I N G B A L A N C E 1, 562 .52 11/09/09 11/10 A00221 CHK : 003873 00450 PLANNER,CALENDAR TABS,MI 17490 40 .43 1,602 .95 CITY OF ELK RIVER INV# 11092009. /PO# 11/09/09 11/10 A00221 CHK : 003873 00450 PAPER, TONERS, MISC 17440 312 .26 1,915 .21 CITY OF ELK RIVER INV# 11092009. /PO# ------------- NOVEMBER ACTIVITY DB: 3 52.69 CR: 0.00 352 .69 4- 6210-4322 Postage B E G I N N I N G B A L A N C E 573 .47 11/09/09 11/10 A00221 CHK : 003873 00450 POSTAGE FOR METER 17440 142 .35 715. 82 CITY OF ELK RIVER INV# 1192009 /PO# ____ _________ NOVEMBER ACTIVITY DB: 142.35 CR: 0.00 142 .35 4- 6210-4331 Travel, Con ferences & Schools B E G I N N I N G B A L A N C E 7, 8 21. 51 11/06/09 11/25 A00226 CHK: 000119 00464 NWA - AIRFARE DECKERT 35099 189. 20 8,010. 71 US BANK INV# 102609 /PO# 11/06/09 11/25 A00226 CHK: 000119 00464 EDAM - REGISTRATION 35099 60. 00 8,070. 71 US BANK INV# 102609 /PO# 11/06/09 11/25 A00226 CHK: 000119 00464 HOLIDAY INN - REFUND 35099 O. O1CR 8,070. 70 US BANK INV# 102609 /PO# 11/09/09 11/10 A00219 CHK: 003871 00450 NDC TRAINING EXP 16112 47. 09CR 8,023. 61 ANNIE DECKERT INV# 11092009 /PO# 11/09/09 11/10 A00219 CHK: 003871 00450 OCTOBER EXPENSES 16112 65. 45 8,089. 06 ANNIE DECKERT INV# 110909 /PO# 11/09/09 11/10 A00219 CHK: 003871 00450 NDC TRAINING EXP 16112 386. 91 8,475. 97 ANNIE DECKERT INV# 110909. /PO# 11/09/09 11/10 A00219 CHK: 003871 00450 MILEAGE 16112 16. 50 8,492. 47 ANNIE DECKERT INV# 11092009 /PO# 11/09/09 11/10 A00220 CHK: 003872 00450 MFG'S WK BREAKFAST-DECKE 17355 20. 00 8,512. 47 ELK RIVER AREA CHAMBER OF INV# 1182 /PO# 11/09/09 11/10 A00224 CHK: 003876 00450 MILEAGE SEPT-OCT 25140 72. 60 8,585. 07 CATHERINE MEHELICH INV# 110909 /PO# ____ _________ NOVEMBER ACTIVITY DB: 81 0.66 CR: 47.lOCR 763. 56 12-04-2009 12:59 PM D E T A I L L I S T I N G PAGE: 5 FU ND 920 -EDA PERIOD TO USE: Nov-2009 TH RU Nov-2 009 DE PT 6210 Economic Development SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT== == ==== BALANCE ==== ________ 4- ______ 6210-4 _______ 349 _______________ Advertising/ ________________________________ Marketing _______ ____ ___________________ ______________ ________ _______ _____ B E G I N N I N G B A L A N C E 9, 943 .11 11/03/09 11/04 B14533 MISC # 011899 00790 ENTERPRISE MN REIMBURSEM ENT JE# 005082 187 .SSCR 9,755 .56 11/06/09 11/25 A00226 CHK: 000119 00464 APPLEBEES - BRE LUNCH 35099 62. 27 9,817 .83 US BANK INV# 102609 /PO# 11/06/09 11/25 A00226 CHK: 000119 00464 PILGRIM CLEANERS - DRY C 35099 28 .22 9,846 .05 US BANK INV# 102609 /PO# 11/06/09 11/25 A00226 CHK: 000119 00464 FAST SIGNS - BANNER 35099 178 .78 10,029 .83 US BANK INV# 102609 /PO# 11/06/09 11/25 A00226 CHK: 000119 00464 DEPOT - MNCAR EXPO 35099 100. 53 10,125 .36 US BANK INV# 102609 /PO# 11/09/09 11/10 A00219 CHK: 003871 00450 OCTOBER EXPENSES 16112 25. 77 10,151 .13 ANNIE DECKERT INV# 110909 /PO# 11/09/09 11/10 A00221 CHK: 003873 00450 MNCAR EXPO EXPENSE-TV 17440 222. 30 10,373 .43 CITY OF ELK RIVER INV# 119200 9. /PO# 11/09/09 11/10 A00222 CHK: 003874 00450 TRADE SHOW DISPLAY SIGNS 17760 283. 29 10,656 .72 ELK RIVER PRINTING & VENT INV# 028710 /PO# 11/09/09 11/10 A00223 CHK: 003875 00450 2009 MNCAR EXPO DISPLAY 10624 3,150. 00 13,806 .72 LI FESPEAKS MEDIA LLC INV# 1043 /PO# ----- -------= NOVEMBER ACTIVITY DB: 4,051.16 CR: 187.SSCR 3,863. 61 4- 6210-4361 Insurance B E G I N N I N G B A L A N C E 0 .00 11/09/09 11/10 A00221 CHK: 003873 00450 OPEN MTG LAW ANNUAL PAY 17440 146. 00 146 .00 CITY OF ELK RIVER INV# 110920 09 /PO# _____________ NOVEMBER ACTIVITY DB: 146.00 CR: 0.00 146. 00 *-*-*-*- *-*-*- *-*-*-* -*-*- 000 ERRORS IN THIS REPORT' *_+_ +_+_+ _+_+_+_+_+_+_+_+_+ ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 89,081 .46 0. 00 REPORTED ACTIVITY: 5,502 .86 234. 65CR ENDING BALANCES: 94,584 .32 234. 65CR