Loading...
HomeMy WebLinkAbout12-07-2020 EDA Packet ECONOMIC DEVELOPMENT AUTHORITY AGENDA December 7, 2020 5:00 pm City Hall Council Chambers 590 40th Avenue NE Columbia Heights, MN 55421 NOTICE THAT THIS MEETING MAY BE CONDUCTED BY A COMBINATION OF IN -PERSON AND ELECTRONIC MEANS Following a determination by City Manager Kelli Bourgeois, and emergencies declared by the United States, The State of Minnesota, and the Columbia Heights Mayor & City Council, this meeting may, pursuant to Minn. Stat. § 13D.021, occur by a combination of in -person and electronic means. In all meeting formats whether solely in-person or a combination of in- person and electronic means, members of the public who wish to attend may do so by attending in-person or by calling 1-312-626-6799 and entering meeting ID 881 1056 7645 at the scheduled meeting time. If there are any questions about this notice or attending/calling in to the meeting, please contact the City Clerk at (763) 706 -3611. 1. Call to Order 2. Roll Call 3. Pledge of Allegiance CONSENT AGENDA 4. Approve special meeting minutes of September 28, 2020, and regular meeting minutes of October 5, 2020. 5. Approve financial report and payment of bills for September, and October 2020 – Resolution 2020-18 Motion: Move to approve the Consent Agenda as presented. BUSINESS ITEMS 6. Approve CEE Contract for Home Energy Squad Services – Resolution 2020-19 Motion: Move to waive the reading of Resolution 2020-19, there being ample copies available to the public. 1 Motion: Move to adopt Resolution 2020-19, a resolution of the Columbia Heights Economic Development Authority approving the agreement with the Center for Energy and Environment to perform home energy squad visits. 7. Approve Hazardous Material Abatement Contract for 230 40th Avenue NE. Motion: Move to accept the low bid from Hummingbird Environmental LLC, for the removal of all hazardous materials located at 230 40th Avenue NE; and furthermore, to authorize the President and Executive Director to enter into agreement for same. 8. Approve Service Agreement with TimeSaver Off Site Secretarial, Inc. Motion: Move to approve the 2021 rate schedule proposed by TimSaver Off Site Secretarial, Inc. to provide minute taking services for the EDA in 2021; and furthermore, to authorize the Executive Director to enter into an agreement for the same. 9. Approve Acquisition of 960 40th Avenue NE and 1002 40th Avenue NE – Resolution 2020-20 and Resolution 2020-21. Motion: Move to waive the reading of Resolution 2020-20, there being ample copies available to the public. Motion: Move to adopt Resolution 2020-20, a resolution approving purchase agreement between the Columbia Heights Economic Development Authority and Alatus, LLC. Motion: Move to waive the reading of Resolution 2020-21, there being ample copies available to the public. Motion: Move to adopt Resolution 2020-21, a resolution approving purchase agreement between the Columbia Heights Economic Development Authority and Lori Gibson. OTHER BUSINESS 10. Adjourn 2 ECONOMIC DEVELOPMENT AUTHORITY (EDA) MINUTES OF THE MEETING OF September 28, 2020 The meeting was called to order at 6:30 pm by Chair Szurek. Members Present: Novitsky, Buesgens, Schmitt, Herringer, Murzyn, Williams and Szurek. Staff Present: Aaron Chirpich (Community Development Director), Kelly Bourgeois (City Manager), and Christy Bennett (Recording Secretary). PLEDGE OF ALLEGIANCE- RECITED Business Items: 1. Approve Subordination and Assignment Agreements as Part of the Purchase and Redevelopment Contract with BPOZ, LLC for the Redevelopment of the 40th and Central Avenue Redevelopment Site. BACKGROUND: Chirpich said the EDA has approved the sale of the redevelopment site located at 40th and Central Avenue to BPOZ, LLC. As part of the contract terms listed in the purchase and redev elopment agreement, the EDA has agreed to subordinate its rights under the agreement to the holder of any mortgage that secures construction or permanent financing for the project. At the time that the purchase and redevelopment agreement was approved, staff was still working to finalize the details of a subordination agreement that was requested by the first mortgage lender on the project, Old National Bank. Under the subordination agreement being presented, BPOZ LLC assigns all of its rights under the redevelopment Contract to Old National Bank as a condition of securing their loan for construction financing. In turn the EDA agrees to acknowledge the assignment of rights and take a subordinate position to the lender. Chirpich said that in addition to the first mortgage financing being provided by Old National Bank, BPOZ LLC has also secured financing for the project from Colliers Funding LLC. The loan provided by Colliers is in the form of a tax increment financing loan. Under this arrangement, the loan from Colliers to BPOZ is secured by an assignment of the TIF note that has been promised to BPOZ through the redevelopment contract. In other words, BPOZ is using the TIF note to secure construction financing for the project by assigning the future TIF payments to the lender. Chirpich said the subordination and assignment requests being made by the lenders on this project are typical for this type of transaction. The general provisions that support these requests are built into the purchase and redevelopment agreement that has been approved by the EDA. The EDA is simply being asked to approve the actual final agreements in preparation of the upcoming closing. STAFF RECOMMENDATION: Staff recommends approval of Resolution 2020-17 as presented. Resolution 2020-17 will approve both the subordination request made by Old National, and the Assignment and Consent agreements proposed by Colliers. Questions from members: Buesgens asked if the EDA is selling to them, what rights would the EDA have. Chirpich said we certainly don’t have as many as the primary lender at that point. We still have rights under the contract that we don’t 3 subordinate. It is a subordination of part of our rights. We can still guarantee, for example, that the minimum improvements get built in the way that we’ve approved. We could withhold the issuance of the TIF note. There are non-negotiable terms for the assessment agreement. Many of the provisions remain intact and we are the primary enforcer. Subordination contemplates something going really haywire, at which point, the bank would have a lot of money into the project and they would get the land back. If we had financial claims against Alatus, which we might, we could still go after them. Schmitt asked if there is a reason that the City stayed with Old National. Chirpich said the securing of Old National was purely a decision made by BPOZ/Alatus. It is the primary lender that they had struck a deal with; it was not part of the EDA’s decision. Motion by Schmitt, seconded by Novitsky, to waive the reading of Resolution 2020-17, there being ample copies available to the public. All Ayes. MOTION PASSED. Motion by Schmitt, seconded by Novitsky, to adopt Resolution 2020-17, a resolution approving subordination of purchase and redevelopment contract between the City, the Columbia Heights Economic Development Authority, and Old National Bank, and consenting to assignment of tax increment financing documents between BPOZ Columbia Heights, LLC and Colliers Funding LLC. All Ayes. MOTION PASSED. Other Updates Chirpich said he had an update on next week’s EDA meeting. It’s a very busy night for the City; there are a lot of different meetings going on. Chirpich said that he is still working on the details for the time. It would be the regularly scheduled meeting, but the time may need to be amended to account for traffic commission, assessment hearings, and a work session. There will be a contract for demolition of the single family home at 4441 Central Ave to be reviewed by the EDA at the meeting, so that it can be demolished this fall still. This meeting, along with all other meetings that evening, will be at the library, due to in person voting. Motion by Buesgens, seconded Murzyn, to adjourn the meeting at 6:42 pm. All Ayes. MOTION PASSED. Respectfully submitted, Christy Bennett Secretary 4 ECONOMIC DEVELOPMENT AUTHORITY (EDA) MINUTES OF THE MEETING OF October 5, 2020 The meeting was called to order at 5:00 pm by Chair Szurek. Members Present: Novitsky, Buesgens, Schmitt, Herringer, Murzyn, Szurek, and Williams (Williams arrived at 5:02, post roll call). Staff Present: Aaron Chirpich (Community Development Director), Kelly Bourgeois (City Manager), Mitchell Forney (Community Development Coordinator), and Christy Bennett (Recording Secretary). PLEDGE OF ALLEGIANCE- RECITED CONSENT AGENDA 1. Approve the minutes from the meeting of September 21, 2020. Questions from Members: There were no questions. Motion by Buesgens, seconded by Murzyn to approve the consent agenda as presented. All ayes. MOTION PASSED. BUSINESS ITEMS BACKGROUND: Forney said that the City is looking to get approval of the bid amount and contract for the demolition, site grading, and utility disconnect work for 4441 Central Ave NE. In April of 2020 the EDA purchased the property located at 4441 Central Ave NE through the commercial revitalization program. It was the ultimate goal of the EDA to demolish the single-family residential house on the property, and prepare the site for redevelopment. Community Development staff completed the bidding process for the demolition of site improvements, utility work, and the regrading of the lot. In response to the request for quotes, the EDA received 3 bids. The Bidding contractors and bid amounts are listed below. JACON, LLC $21,988 Drobnick’s Demolition $22,500 Nitti Rolloff Services Inc. $27,154 The quote submitted by JACON LLC, for $21,988 meets all of the project requirements outlined in the bid specifications. JACON LLC shall furnish the services and necessary equipment to complete all requirements specified in the scope of work. All work will be performed in accordance with OSHA regulations and any applicable Federal and State regulations. Staff expects the contracted work to be completed by the end of October 2020. STAFF RECOMMENDATION: Staff recommends awarding the contract for demolition, utility work, and regrading of 4441 Central Ave NE to JACON LLC. Staff expects the contracted work to be completed by the end of October 2020. 5 Questions from members: Herringer asked if the City has had a bid on the asbestos removal yet. Forney said yes, the EDA approved Tim Robinson one or two EDA meetings ago. The asbestos and other hazardous materials in the building included glazing in the windows and some appliances the previous owner left. The total was around $2k for the removal. Motion by Schmitt, seconded by Murzyn, to approve the proposal from JACON LLC, in the amount of $21,988, for the demolition of all site improvements, site grading, and utility disconnect work for the property located at 4441 Central Avenue NE; and furthermore, to authorize the President and Executive Director to enter into an agreement for the same. All Ayes. MOTION PASSED. OTHER UPDATES Chirpich said there is no other business this evening. Motion by Schmitt, seconded by Murzyn, to adjourn the meeting at 5:05 pm. All Ayes. MOTION PASSED. Respectfully submitted, Christy Bennett Secretary 6 City of Columbia Heights |Finance Department 590 40th Avenue NE, Columbia Heights, MN 55421 ▪ Ph: 763-706-3600 ▪ www.columbiaheightsmn.gov MEMO_EDAfinancialReports_102920.docx DATE:December 3, 2020 TO:EDA COMMISSIONERS FROM:JOSEPH KLOIBER, FINANCE DIRECTOR RE:FORMAT CHANGE TO EDA FINANCIAL REPORTS Beginning with EDA Financial Reports for the months of September 2020 and October 2020, you will notice certain format changes to the reports: ·The list of cash disbursements is changed to include all EDA-related disbursements for the month on a single page. Previously, this list typically required six to ten pages, because it only showed one fund per page, and there were pages with unnecessary subtotals. Note, the new format provides the additional information of a description for each item in the list. ·The revenue and expenditure guidelines (budgetary comparison reports) for the EDA have been changed to more closely resemble the electronic format that will be provided to the EDA commissioners in future months when computer tablets are provided to each commissioner. 7 COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY CASH DISBURSEMENTS FOR THE MONTH ENDING SEPTEMBER 30, 2020 CHECK#CHECK DATE AMOUNT VENDOR NAME FUND DETAIL DESCR 181823 9/10/2020 19.15 COMCAST 204 081020 8772105050224795 181829 9/10/2020 101.25 ECM PUBLISHERS INC 204 PHN 3989 CNTL SALE 08282 181951 9/17/2020 75.79 POPP.COM INC 204 083120-10010429 181975 9/17/2020 846.43 XCEL ENERGY (N S P)228 090820 51-0013059132-8 181732 9/3/2020 3,000.00 EHLERS & ASSOCIATES INC 346 ARBITRAGE REPORT:2015A 181915 9/17/2020 410.75 EHLERS & ASSOCIATES INC 371 T4 TIF ADMIN 181915 9/17/2020 887.50 EHLERS & ASSOCIATES INC 371 T4 TIF REPORT 182163 9/24/2020 10,200.00 SPRINT SPECTRUM REALTY C 371 SPRINT RELOCATION 182180 9/28/2020 132,263.37 AT&T MOBILITY II, LLC 371 AT&T SETTLEMENT 182181 9/30/2020 85,422.00 CROWN CASTLE AS LLC 371 CROWN CASTLE SETTLE 181915 9/17/2020 410.75 EHLERS & ASSOCIATES INC 372 T6 TIF ADMIN 181915 9/17/2020 887.50 EHLERS & ASSOCIATES INC 372 T6 RIF REPORT 181915 9/17/2020 410.75 EHLERS & ASSOCIATES INC 375 Z6 TIF ADMIN 181915 9/17/2020 887.50 EHLERS & ASSOCIATES INC 375 Z6 TIF REPORT 181915 9/17/2020 410.75 EHLERS & ASSOCIATES INC 376 C8 TIF ADMIN 181915 9/17/2020 887.50 EHLERS & ASSOCIATES INC 376 C8 TIF REPORT 182181 9/30/2020 249,578.00 CROWN CASTLE AS LLC 385 CROWN CASTLE SETTLE 181915 9/17/2020 410.75 EHLERS & ASSOCIATES INC 389 R8 TIF ADMIN 181915 9/17/2020 887.50 EHLERS & ASSOCIATES INC 389 R8 TIF REPORT 181730 9/3/2020 514.00 DU ALL SERVICE CONTRACTO 408 BOARD UP 4441 CENT 181893 9/17/2020 110.00 BARNA GUZY & STEFFEN LTD 408 CELL LSE/PURCH 3989 CEN 181893 9/17/2020 3,279.69 BARNA GUZY & STEFFEN LTD 408 LEASE TERMINATION-CROWN 181906 9/17/2020 10.80 CENTER POINT ENERGY 408 090820 11173439-8 181906 9/17/2020 10.80 CENTER POINT ENERGY 408 090820 6401438486-7 181930 9/17/2020 140.00 KENNEDY & GRAVEN 408 3989 CENTRAL AVE AGREE 181975 9/17/2020 11.18 XCEL ENERGY (N S P)408 090420 51-0012963900-4 181975 9/17/2020 11.31 XCEL ENERGY (N S P)408 090420 51-0012469064-3 181975 9/17/2020 406.82 XCEL ENERGY (N S P)408 090820 51-0012875093-9 181975 9/17/2020 119.00 XCEL ENERGY (N S P)408 090820 51-0012807608-9 182087 9/24/2020 9,574.50 BARNA GUZY & STEFFEN LTD 408 CROWN CASTLE LEASE 182087 9/24/2020 1,265.00 BARNA GUZY & STEFFEN LTD 408 ALATUS-3989 CENT 8 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 4 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 201 PLANNING & INSPECTIONS 00 REVENUE LICENSES AND PERMITS 32110 LIQUOR, WINE & BEER LICENSE 14,785.00 14,785.00 0.00 0.00 14,785.00 0 32122 FOOD SVC VEHICLES 500.00 500.00 0.00 300.00 200.00 60 ------ 32125 MULTIPLE DWELLINGS 6,900.00 6,900.00 160.00 3,520.00 3,380.00 51 ----- 32161 CONTRACTOR 17,500.00 17,500.00 640.00 10,800.00 6,700.00 61 ------ 32168 OTHER PROFESSIONAL & OCCUP 2,400.00 2,400.00 850.00 1,650.00 750.00 68 ------ 32178 OTHER AMUSEMENT LICENSES 1,000.00 1,000.00 0.00 25.00 975.00 2 32181 PLANNING AND ZONING FEES 5,200.00 5,200.00 151.25 9,776.60 4,576.60- 188 ----------!!!! 32188 OTHER BUSINESS LICENSES 3,800.00 3,800.00 100.00 908.50 2,891.50 23 -- 32191 SPRINKLER PERMIT FEES 4,000.00 4,000.00 156.65 1,713.66 2,286.34 42 ---- 32192 BUILDING & MOVING PERMITS 231,000.00 231,000.00 28,514.35 143,776.56 87,223.44 62 ------ 32194 HEATING PERMITS 20,000.00 20,000.00 2,020.11 20,005.75 5.75- 100 ---------- 32195 PLUMBING PERMITS 13,000.00 13,000.00 1,128.36 8,254.69 4,745.31 63 ------ 32197 ABANDONED PROP INSPECT FEE 500.00 500.00 0.00 0.00 500.00 0 TOTAL: LICENSES AND PERMITS 320,585.00 320,585.00 33,720.72 200,730.76 119,854.24 62 ------ MISCELLANEOUS 36260 SURCHARGE RETENTION 2,000.00 2,000.00 0.00 149.79 1,850.21 7 36290 OTHER MISC. REVENUE 0.00 0.00 30.00 30.00 30.00- 9999 ----------!!!! TOTAL: MISCELLANEOUS 2,000.00 2,000.00 30.00 179.79 1,820.21 8 TRANSFERS & NONREV RECEIPTS 39203 TRANSFER IN FROM GENERAL FND 135,000.00 135,000.00 11,250.00 101,250.00 33,750.00 75 ------- TOTAL: TRANSFERS & NONREV RECEIPTS 135,000.00 135,000.00 11,250.00 101,250.00 33,750.00 75 ------- TOTAL: REVENUE 457,585.00 457,585.00 45,000.72 302,160.55 155,424.45 66 ------ TOTAL: PLANNING & INSPECTIONS 457,585.00 457,585.00 45,000.72 302,160.55 155,424.45 66 ------ 9 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 5 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 202 ANOKA CO COMM DEV PROGRAMS 00 REVENUE 33165 FEDERAL GRANT PASS THROUGH 0.00 0.00 0.00 24,755.00 24,755.00- 9999 ----------!!!! 36400 PRINCIPAL REPAYMENT - LOANS 0.00 0.00 0.00 480.00 480.00- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 25,235.00 25,235.00- 9999 ----------!!!! TOTAL: ANOKA CO COMM DEV PROGRAMS 0.00 0.00 0.00 25,235.00 25,235.00- 9999 ----------!!!! 10 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 6 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 204 EDA ADMINISTRATION 00 REVENUE TAXES 31011 EDA CURRENT AD VALOREM 171,500.00 171,500.00 0.00 93,090.50 78,409.50 54 ----- 31014 AREA WIDE TAX 73,600.00 73,600.00 0.00 31,827.97 41,772.03 43 ---- 31020 DELINQ. AD VALOREM 0.00 0.00 0.00 782.26 782.26- 9999 ----------!!!! TOTAL: TAXES 245,100.00 245,100.00 0.00 125,700.73 119,399.27 51 ----- CHARGES FOR SERVICES 34112 ADMINISTRATIVE FEES 0.00 0.00 0.00 30.00 30.00- 9999 ----------!!!! TOTAL: CHARGES FOR SERVICES 0.00 0.00 0.00 30.00 30.00- 9999 ----------!!!! TOTAL: REVENUE 245,100.00 245,100.00 0.00 125,730.73 119,369.27 51 ----- TOTAL: EDA ADMINISTRATION 245,100.00 245,100.00 0.00 125,730.73 119,369.27 51 ----- 11 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 9 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 226 SPECIAL PROJECT REVENUE 00 REVENUE 33422 STATE GRANT 0.00 0.00 0.00 2,700.00 2,700.00- 9999 ----------!!!! 34112 ADMINISTRATIVE FEES 0.00 0.00 0.00 19,785.00 19,785.00- 9999 ----------!!!! 36225 NONDWELLING RENTS 0.00 0.00 0.00 28,455.33 28,455.33- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 50,940.33 50,940.33- 9999 ----------!!!! TOTAL: SPECIAL PROJECT REVENUE 0.00 0.00 0.00 50,940.33 50,940.33- 9999 ----------!!!! 12 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 10 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 228 DOWNTOWN PARKING 00 REVENUE 36225 NONDWELLING RENTS 15,000.00 15,000.00 2,600.00 10,400.00 4,600.00 69 ------ 39247 TRANSFER IN-SPECIAL PROJ REV 10,000.00 10,000.00 0.00 0.00 10,000.00 0 TOTAL: REVENUE 25,000.00 25,000.00 2,600.00 10,400.00 14,600.00 41 ---- TOTAL: DOWNTOWN PARKING 25,000.00 25,000.00 2,600.00 10,400.00 14,600.00 41 ---- 13 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 21 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 371 TIF T4: KMART/CENTRAL AVE 00 REVENUE TAXES 31010 CURRENT AD VALOREM 81,000.00 81,000.00 0.00 1.08- 81,001.08 0 31020 DELINQ. AD VALOREM 0.00 0.00 0.00 1.08 1.08- 9999 ----------!!!! TOTAL: TAXES 81,000.00 81,000.00 0.00 0.00 81,000.00 0 MISCELLANEOUS 36210 INTEREST ON INVESTMENTS 5,000.00 5,000.00 0.00 0.00 5,000.00 0 TOTAL: MISCELLANEOUS 5,000.00 5,000.00 0.00 0.00 5,000.00 0 TOTAL: REVENUE 86,000.00 86,000.00 0.00 0.00 86,000.00 0 TOTAL: TIF T4: KMART/CENTRAL AVE 86,000.00 86,000.00 0.00 0.00 86,000.00 0 14 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 22 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 372 HUSET PARK AREA TIF (T6) 00 REVENUE 31010 CURRENT AD VALOREM 189,800.00 189,800.00 0.00 348,949.23 159,149.23- 183 ----------!!!! 31020 DELINQ. AD VALOREM 0.00 0.00 0.00 667.98 667.98- 9999 ----------!!!! 36210 INTEREST ON INVESTMENTS 5,000.00 5,000.00 0.00 0.00 5,000.00 0 TOTAL: REVENUE 194,800.00 194,800.00 0.00 349,617.21 154,817.21- 179 ----------!!!! TOTAL: HUSET PARK AREA TIF (T6) 194,800.00 194,800.00 0.00 349,617.21 154,817.21- 179 ----------!!!! 15 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 24 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 385 TIF K2 M.U.R.P. 00 REVENUE TAXES 31010 CURRENT AD VALOREM 0.00 0.00 0.00 16,452.56 16,452.56- 9999 ----------!!!! TOTAL: TAXES 0.00 0.00 0.00 16,452.56 16,452.56- 9999 ----------!!!! TRANSFERS & NONREV RECEIPTS 39204 TRANSFER IN-OTHER 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: TRANSFERS & NONREV RECEIPTS 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 54,107.56 54,107.56- 9999 ----------!!!! TOTAL: TIF K2 M.U.R.P. 0.00 0.00 0.00 54,107.56 54,107.56- 9999 ----------!!!! 16 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 25 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 389 TIF R8 CRESTV/TRANSITION BLK 00 REVENUE TAXES 31010 CURRENT AD VALOREM 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! TOTAL: TAXES 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! TOTAL: TIF R8 CRESTV/TRANSITION BLK 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! 17 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 26 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 391 SCATTERED SITE TIF W3/W4 00 REVENUE 31010 CURRENT AD VALOREM 0.00 0.00 0.00 21,903.17 21,903.17- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 21,903.17 21,903.17- 9999 ----------!!!! TOTAL: SCATTERED SITE TIF W3/W4 0.00 0.00 0.00 21,903.17 21,903.17- 9999 ----------!!!! 18 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 28 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 408 EDA REDEVELOPMENT PROJECT FD 00 REVENUE 31012 HRA CURRENT AD VALOREM 175,000.00 175,000.00 0.00 90,755.96 84,244.04 51 ----- 31014 AREA WIDE TAX 75,100.00 75,100.00 0.00 34,996.00 40,104.00 46 ---- 34113 DEVELOPER FEES 0.00 0.00 0.00 11,000.00 11,000.00- 9999 ----------!!!! 36290 OTHER MISC. REVENUE 0.00 0.00 86.87 86.87 86.87- 9999 ----------!!!! TOTAL: REVENUE 250,100.00 250,100.00 86.87 136,838.83 113,261.17 54 ----- TOTAL: EDA REDEVELOPMENT PROJECT FD 250,100.00 250,100.00 86.87 136,838.83 113,261.17 54 ----- 19 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:40:27 Revenue Guideline GL520R-V08.14 PAGE 32 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 420 CAP IMPROVEMENT DEVELOPMENT 00 REVENUE 34113 DEVELOPER FEES 0.00 0.00 0.00 91,500.00 91,500.00- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 91,500.00 91,500.00- 9999 ----------!!!! TOTAL: CAP IMPROVEMENT DEVELOPMENT 0.00 0.00 0.00 91,500.00 91,500.00- 9999 ----------!!!! 20 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 1 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 2,312.30 9,191.94 9,191.94- 9999 ----------!!!! 1010 REGULAR EMPLOYEES 269,300.00 0.00 20,137.64 181,565.52 87,734.48 67 ------ 1011 PART-TIME EMPLOYEES 47,000.00 0.00 2,765.90 20,109.73 26,890.27 42 ---- 1020 OVERTIME-REGULAR 1,500.00 0.00 163.90 923.56 576.44 61 ------ 1050 SEVERANCE PAY 0.00 0.00 0.00 23,377.88 23,377.88- 9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 23,000.00 0.00 1,522.63 15,141.78 7,858.22 65 ------ 1220 F.I.C.A. CONTRIBUTION 24,300.00 0.00 1,778.85 16,401.91 7,898.09 67 ------ 1225 FLEX BENEFIT FICA 0.00 0.00 25.83 232.47 232.47- 9999 ----------!!!! 1300 INSURANCE 42,000.00 0.00 3,252.68 31,610.18 10,389.82 75 ------- 1510 WORKERS COMP INSURANCE PREM 2,200.00 0.00 148.73 1,362.51 837.49 61 ------ TOTAL: PERSONAL SERVICES 409,300.00 0.00 32,108.46 299,917.48 109,382.52 73 ------- SUPPLIES 2000 OFFICE SUPPLIES 1,400.00 0.00 0.00 553.07 846.93 39 --- 2020 COMPUTER SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2030 PRINTING & PRINTED FORMS 150.00 0.00 0.00 33.92 116.08 22 -- 2171 GENERAL SUPPLIES 100.00 0.00 0.00 10.99 89.01 10 - 2175 FOOD SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2280 VEHICLE REPAIR AND PARTS 600.00 0.00 66.22 96.47 503.53 16 - 2282 GAS, OIL, LUBRICANTS 500.00 0.00 47.25 357.05 142.95 71 ------- TOTAL: SUPPLIES 2,950.00 0.00 113.47 1,051.50 1,898.50 35 --- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 2,400.00 0.00 0.00 22,481.00 20,081.00- 936 ----------!!!! 3105 TRAINING & EDUC ACTIVITIES 2,000.00 0.00 0.00 0.00 2,000.00 0 3210 TELEPHONE & TELEGRAPH 900.00 0.00 0.00 159.75 740.25 17 - 3211 CELL PHONES 960.00 0.00 0.00 395.49 564.51 41 ---- 3220 POSTAGE 1,000.00 0.00 255.95 907.45 92.55 90 --------- 3250 OTHER COMMUNICATIONS 200.00 0.00 14.36 133.06 66.94 66 ------ 3310 LOCAL TRAVEL EXPENSE 500.00 0.00 0.00 0.00 500.00 0 3500 LEGAL NOTICE PUBLISHING 750.00 0.00 343.13 1,085.64 335.64- 144 ----------!!!! 3600 PROP & LIAB INSURANCE 3,200.00 0.00 266.67 2,400.03 799.97 75 ------- 4000 REPAIR & MAINT. SERVICES 825.00 0.00 44.49 294.00 531.00 35 --- 4040 INFORMATION SYS:INTERNAL SVC 9,700.00 0.00 808.33 7,274.97 2,425.03 74 ------- 4050 GARAGE, LABOR BURD. 500.00 0.00 290.07 567.46 67.46- 113 ----------! 4310 CREDIT CARD FEES 1,030.00 0.00 254.27 881.42 148.58 85 -------- 4330 SUBSCRIPTION, MEMBERSHIP 1,250.00 0.00 123.00 1,101.00 149.00 88 -------- 4380 COMMISSION & BOARDS 720.00 0.00 0.00 8.65 711.35 1 4390 TAXES & LICENSES 0.00 0.00 0.00 2,704.25 2,704.25- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 25,935.00 0.00 2,400.27 40,394.17 14,459.17- 155 ----------!!!! OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- 21 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 2 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 201 PLANNING & INSPECTIONS TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 36,247.20 355,988.15 101,696.85 77 ------- TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 36,247.20 355,988.15 101,696.85 77 ------- 22 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 3 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 202 ANOKA CO COMM DEV PROGRAMS 46350 CDBG - COMM DEV BLOCK GRANT OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 24,753.30 24,753.30- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 24,753.30 24,753.30- 9999 ----------!!!! TOTAL: CDBG - COMM DEV BLOCK GRANT 0.00 0.00 0.00 24,753.30 24,753.30- 9999 ----------!!!! 46355 ANOKA CO HRA LEVY PROJECTS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,156.00 1,156.00- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 1,156.00 1,156.00- 9999 ----------!!!! TOTAL: ANOKA CO HRA LEVY PROJECTS 0.00 0.00 0.00 1,156.00 1,156.00- 9999 ----------!!!! TOTAL: ANOKA CO COMM DEV PROGRAMS 0.00 0.00 0.00 25,909.30 25,909.30- 9999 ----------!!!! 23 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 4 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 204 EDA ADMINISTRATION 46314 ECONOMIC DEVELOPMENT AUTH PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 1,141.20 4,564.49 4,564.49- 9999 ----------!!!! 1010 REGULAR EMPLOYEES 148,300.00 0.00 11,309.08 75,198.21 73,101.79 50 ----- 1210 P.E.R.A. CONTRIBUTION 11,100.00 0.00 848.18 5,829.41 5,270.59 52 ----- 1220 F.I.C.A. CONTRIBUTION 11,300.00 0.00 899.78 6,080.02 5,219.98 53 ----- 1300 INSURANCE 21,900.00 0.00 755.58 6,512.63 15,387.37 29 -- 1510 WORKERS COMP INSURANCE PREM 1,100.00 0.00 76.08 521.87 578.13 47 ---- TOTAL: PERSONAL SERVICES 193,700.00 0.00 15,029.90 98,706.63 94,993.37 50 ----- SUPPLIES 2000 OFFICE SUPPLIES 1,300.00 0.00 0.00 0.00 1,300.00 0 2011 COMPUTER EQUIPMENT 0.00 0.00 0.00 1,891.26 1,891.26- 9999 ----------!!!! 2020 COMPUTER SUPPLIES 215.00 0.00 0.00 0.00 215.00 0 2171 GENERAL SUPPLIES 105.00 0.00 0.00 0.00 105.00 0 2175 FOOD SUPPLIES 210.00 0.00 0.00 0.00 210.00 0 TOTAL: SUPPLIES 1,830.00 0.00 0.00 1,891.26 61.26- 103 ---------- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 6,980.00 0.00 0.00 2,435.00 4,545.00 34 --- 3105 TRAINING & EDUC ACTIVITIES 1,500.00 0.00 0.00 295.00 1,205.00 19 - 3210 TELEPHONE & TELEGRAPH 900.00 0.00 75.79 621.29 278.71 69 ------ 3220 POSTAGE 700.00 0.00 25.65 250.65 449.35 35 --- 3250 OTHER COMMUNICATIONS 250.00 0.00 19.15 171.38 78.62 68 ------ 3310 LOCAL TRAVEL EXPENSE 200.00 0.00 0.00 0.00 200.00 0 3500 LEGAL NOTICE PUBLISHING 315.00 0.00 101.25 286.88 28.12 91 --------- 3600 PROP & LIAB INSURANCE 3,600.00 0.00 300.00 2,700.00 900.00 75 ------- 4000 REPAIR & MAINT. SERVICES 0.00 0.00 44.49 409.50 409.50- 9999 ----------!!!! 4040 INFORMATION SYS:INTERNAL SVC 7,300.00 0.00 608.33 5,474.97 1,825.03 74 ------- 4330 SUBSCRIPTION, MEMBERSHIP 1,500.00 0.00 0.00 0.00 1,500.00 0 4380 COMMISSION & BOARDS 925.00 0.00 0.00 105.00 820.00 11 - TOTAL: OTHER SERVICES & CHARGES 24,170.00 0.00 1,174.66 12,749.67 11,420.33 52 ----- OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- TOTAL: ECONOMIC DEVELOPMENT AUTH 239,200.00 0.00 17,829.56 127,972.56 111,227.44 53 ----- TOTAL: EDA ADMINISTRATION 239,200.00 0.00 17,829.56 127,972.56 111,227.44 53 ----- 24 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 8 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 226 SPECIAL PROJECT REVENUE 52013 EAB TREE MANAGEMENT 2010 MINOR EQUIPMENT 0.00 0.00 0.00 4,610.00 4,610.00- 9999 ----------!!!! 2160 MAINT. & CONSTRUCT MATERIALS 0.00 0.00 352.50 8,406.25 8,406.25- 9999 ----------!!!! 2171 GENERAL SUPPLIES 0.00 0.00 0.00 900.60 900.60- 9999 ----------!!!! 4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 57,965.31 57,965.31- 9999 ----------!!!! TOTAL: EAB TREE MANAGEMENT 0.00 0.00 352.50 71,882.16 71,882.16- 9999 ----------!!!! TOTAL: SPECIAL PROJECT REVENUE 0.00 0.00 352.50 71,882.16 71,882.16- 9999 ----------!!!! 25 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 9 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 228 DOWNTOWN PARKING 46317 DOWNTOWN PARKING PERSONAL SERVICES 1070 INTERDEPARTMENTAL LABOR SERV 0.00 0.00 136.02 136.02 136.02- 9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 0.00 0.00 10.19 10.19 10.19- 9999 ----------!!!! 1220 F.I.C.A. CONTRIBUTION 0.00 0.00 9.73 9.73 9.73- 9999 ----------!!!! 1300 INSURANCE 0.00 0.00 35.11 35.11 35.11- 9999 ----------!!!! 1510 WORKERS COMP INSURANCE PREM 0.00 0.00 11.08 11.08 11.08- 9999 ----------!!!! TOTAL: PERSONAL SERVICES 0.00 0.00 202.13 202.13 202.13- 9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 3,697.50 3,697.50- 9999 ----------!!!! 3600 PROP & LIAB INSURANCE 6,900.00 0.00 575.00 5,175.00 1,725.00 75 ------- 3810 ELECTRIC 0.00 0.00 846.43 4,952.70 4,952.70- 9999 ----------!!!! 3820 WATER 0.00 0.00 34.13 109.68 109.68- 9999 ----------!!!! 3850 SEWER 0.00 0.00 157.04 976.29 976.29- 9999 ----------!!!! 4000 REPAIR & MAINT. SERVICES 18,100.00 0.00 0.00 342.80 17,757.20 1 TOTAL: OTHER SERVICES & CHARGES 25,000.00 0.00 1,612.60 15,253.97 9,746.03 61 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,814.73 15,456.10 9,543.90 61 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,814.73 15,456.10 9,543.90 61 ------ 26 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 26 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 371 TIF T4: KMART/CENTRAL AVE 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 5,000.00 0.00 1,298.25 12,012.03 7,012.03- 240 ----------!!!! 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 227,885.37 227,885.37 227,885.37- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 5,000.00 0.00 229,183.62 239,897.40 234,897.40- 4797 ----------!!!! CAPITAL OUTLAY 6010 PRINCIPAL 75,000.00 0.00 0.00 0.00 75,000.00 0 6110 INTEREST 5,800.00 0.00 0.00 0.00 5,800.00 0 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 475.00 725.00 39 --- TOTAL: CAPITAL OUTLAY 82,000.00 0.00 0.00 475.00 81,525.00 0 OTHER FINANCING USES 7435 TRANSFER OUT TO: OTHER 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: OTHER FINANCING USES 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: BONDS 87,000.00 0.00 229,183.62 278,027.40 191,027.40- 319 ----------!!!! TOTAL: TIF T4: KMART/CENTRAL AVE 87,000.00 0.00 229,183.62 278,027.40 191,027.40- 319 ----------!!!! 27 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 27 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 372 HUSET PARK AREA TIF (T6) 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 9,000.00 0.00 1,298.25 1,298.25 7,701.75 14 - 4600 LOANS & GRANTS 233,900.00 0.00 0.00 302,658.46 68,758.46- 129 ----------!! TOTAL: OTHER SERVICES & CHARGES 242,900.00 0.00 1,298.25 303,956.71 61,056.71- 125 ----------!! CAPITAL OUTLAY 6010 PRINCIPAL 130,000.00 0.00 0.00 130,000.00 0.00 100 ---------- 6110 INTEREST 62,000.00 0.00 0.00 61,957.50 42.50 99 --------- 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 0.00 1,200.00 0 TOTAL: CAPITAL OUTLAY 193,200.00 0.00 0.00 191,957.50 1,242.50 99 --------- TOTAL: BONDS 436,100.00 0.00 1,298.25 495,914.21 59,814.21- 113 ----------! TOTAL: HUSET PARK AREA TIF (T6) 436,100.00 0.00 1,298.25 495,914.21 59,814.21- 113 ----------! 28 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 29 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 376 TIF DISTRICTS A3/C7/C8 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,298.25 1,298.25 1,298.25- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 1,298.25 1,298.25 1,298.25- 9999 ----------!!!! TOTAL: BONDS 0.00 0.00 1,298.25 1,298.25 1,298.25- 9999 ----------!!!! TOTAL: TIF DISTRICTS A3/C7/C8 0.00 0.00 1,298.25 1,298.25 1,298.25- 9999 ----------!!!! 29 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 30 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 385 TIF K2 M.U.R.P. 47000 TAX INCREMENT BONDS OTHER SERVICES & CHARGES 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 249,578.00 249,578.00 249,578.00- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 1,794.00 1,794.00- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 249,578.00 251,372.00 251,372.00- 9999 ----------!!!! TOTAL: TAX INCREMENT BONDS 0.00 0.00 249,578.00 251,372.00 251,372.00- 9999 ----------!!!! TOTAL: TIF K2 M.U.R.P. 0.00 0.00 249,578.00 251,372.00 251,372.00- 9999 ----------!!!! 30 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 31 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 389 TIF R8 CRESTV/TRANSITION BLK 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,298.25 1,298.25 1,298.25- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 26,847.00 26,847.00- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 1,298.25 28,145.25 28,145.25- 9999 ----------!!!! TOTAL: BONDS 0.00 0.00 1,298.25 28,145.25 28,145.25- 9999 ----------!!!! TOTAL: TIF R8 CRESTV/TRANSITION BLK 0.00 0.00 1,298.25 28,145.25 28,145.25- 9999 ----------!!!! 31 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 33 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 408 EDA REDEVELOPMENT PROJECT FD 46314 ECONOMIC DEVELOPMENT AUTH 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78 7,082.78- 9999 ----------!!!! 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 348.00 348.00- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 5,040.00 5,040.00- 9999 ----------!!!! TOTAL: ECONOMIC DEVELOPMENT AUTH 0.00 0.00 0.00 12,470.78 12,470.78- 9999 ----------!!!! 46411 FACADE IMPROVEMENT GRANT 2010 MINOR EQUIPMENT 0.00 0.00 0.00 15,526.48 15,526.48- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 5,000.00 5,000.00- 9999 ----------!!!! TOTAL: FACADE IMPROVEMENT GRANT 0.00 0.00 0.00 20,526.48 20,526.48- 9999 ----------!!!! 46414 COMMERCIAL REVITALIZATION SUPPLIES 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! TOTAL: SUPPLIES 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 6,865.30 6,865.30- 9999 ----------!!!! 3810 ELECTRIC 0.00 0.00 429.31 1,753.93 1,753.93- 9999 ----------!!!! 3830 GAS 0.00 0.00 21.60 99.21 99.21- 9999 ----------!!!! 4000 REPAIR & MAINT. SERVICES 0.00 0.00 514.00 514.00 514.00- 9999 ----------!!!! 4600 LOANS & GRANTS 50,000.00 0.00 0.00 950.00 49,050.00 1 TOTAL: OTHER SERVICES & CHARGES 50,000.00 0.00 964.91 10,182.44 39,817.56 20 -- CAPITAL OUTLAY 5110 LAND 200,000.00 0.00 0.00 129,010.43 70,989.57 64 ------ TOTAL: CAPITAL OUTLAY 200,000.00 0.00 0.00 129,010.43 70,989.57 64 ------ TOTAL: COMMERCIAL REVITALIZATION 250,000.00 0.00 964.91 132,110.09 117,889.91 52 ----- 46416 3989 CENTRAL AVE 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 14,369.19 77,765.11 77,765.11- 9999 ----------!!!! 3810 ELECTRIC 0.00 0.00 119.00 1,189.87 1,189.87- 9999 ----------!!!! 4020 BUILDING MAINT:CONTRACT SVCS 0.00 0.00 0.00 260.37 260.37- 9999 ----------!!!! 5110 LAND 0.00 0.00 0.00 54,546.69 54,546.69- 9999 ----------!!!! 5191 ASSETS FOR RESALE 0.00 0.00 0.00 18,830.48 18,830.48- 9999 ----------!!!! TOTAL: 3989 CENTRAL AVE 0.00 0.00 14,488.19 152,592.52 152,592.52- 9999 ----------!!!! 52011 DEMO 3989 CENT AVE & RAMP 2171 GENERAL SUPPLIES 0.00 0.00 0.00 206.25 206.25- 9999 ----------!!!! 3500 LEGAL NOTICE PUBLISHING 0.00 0.00 0.00 545.63 545.63- 9999 ----------!!!! TOTAL: DEMO 3989 CENT AVE & RAMP 0.00 0.00 0.00 751.88 751.88- 9999 ----------!!!! TOTAL: EDA REDEVELOPMENT PROJECT FD 250,000.00 0.00 15,453.10 318,451.75 68,451.75- 127 ----------!! 32 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:42:58 Expenditure Guideline GL520R-V08.14 PAGE 39 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 420 CAP IMPROVEMENT DEVELOPMENT 46407 3930 UNIVERSITY 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,593.75 1,906.25 1,906.25- 9999 ----------!!!! TOTAL: 3930 UNIVERSITY 0.00 0.00 1,593.75 1,906.25 1,906.25- 9999 ----------!!!! TOTAL: CAP IMPROVEMENT DEVELOPMENT 0.00 0.00 1,593.75 1,906.25 1,906.25- 9999 ----------!!!! 33 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 1 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 2,312.30 9,191.94 9,191.94-9999 ----------!!!!1000 ACCRUED SALARIES 0.00 0.00 2,312.30 9,191.94 9,191.94-9999 ----------!!!! X-090120-022 SALARY ACCRUAL AUG 2020 804 6,879.64- SALARY ACCRUAL AUG-20 A X-093020-145 SALARY ACCRUAL SEPT.2020 904 9,191.94 SALARY ACCRUAL SEP-20 A 1010 REGULAR EMPLOYEES 269,300.00 0.00 20,137.64 181,565.52 87,734.48 67 ------1010 REGULAR EMPLOYEES 269,300.00 0.00 20,137.64 181,565.52 87,734.48 67 ------ P-091120-087 PAYROLL INTERFACE 091120 10,046.93 CODE-H,PER#-1,FUND- 201 A P-092520-123 PAYROLL INTERFACE 092520 10,090.71 CODE-H,PER#-2,FUND- 201 A 1011 PART-TIME EMPLOYEES 47,000.00 0.00 2,765.90 20,109.73 26,890.27 42 ----1011 PART-TIME EMPLOYEES 47,000.00 0.00 2,765.90 20,109.73 26,890.27 42 ---- P-091120-087 PAYROLL INTERFACE 091120 1,366.68 CODE-H,PER#-1,FUND- 201 A P-092520-123 PAYROLL INTERFACE 092520 1,399.22 CODE-H,PER#-2,FUND- 201 A 1020 OVERTIME-REGULAR 1,500.00 0.00 163.90 923.56 576.44 61 ------1020 OVERTIME-REGULAR 1,500.00 0.00 163.90 923.56 576.44 61 ------ P-091120-087 PAYROLL INTERFACE 091120 81.95 CODE-H,PER#-1,FUND- 201 A P-092520-123 PAYROLL INTERFACE 092520 81.95 CODE-H,PER#-2,FUND- 201 A 1050 SEVERANCE PAY 0.00 0.00 0.00 23,377.88 23,377.88-9999 ----------!!!!1050 SEVERANCE PAY 0.00 0.00 0.00 23,377.88 23,377.88-9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 23,000.00 0.00 1,522.63 15,141.78 7,858.22 65 ------1210 P.E.R.A. CONTRIBUTION 23,000.00 0.00 1,522.63 15,141.78 7,858.22 65 ------ P-091120-087 PAYROLL INTERFACE 091120 759.67 CODE-H,PER#-1,FUND- 201 A P-092520-123 PAYROLL INTERFACE 092520 762.96 CODE-H,PER#-2,FUND- 201 A 1220 F.I.C.A. CONTRIBUTION 24,300.00 0.00 1,778.85 16,401.91 7,898.09 67 ------1220 F.I.C.A. CONTRIBUTION 24,300.00 0.00 1,778.85 16,401.91 7,898.09 67 ------ P-091120-087 PAYROLL INTERFACE 091120 886.16 CODE-H,PER#-1,FUND- 201 A P-092520-123 PAYROLL INTERFACE 092520 892.69 CODE-H,PER#-2,FUND- 201 A 1225 FLEX BENEFIT FICA 0.00 0.00 25.83 232.47 232.47-9999 ----------!!!!1225 FLEX BENEFIT FICA 0.00 0.00 25.83 232.47 232.47-9999 ----------!!!! J-093020-211 20 FLEX PLAN ADMIN EXP 123 25.83 ESTIMATED COST A 1300 INSURANCE 42,000.00 0.00 3,252.68 31,610.18 10,389.82 75 -------1300 INSURANCE 42,000.00 0.00 3,252.68 31,610.18 10,389.82 75 ------- P-091120-087 PAYROLL INTERFACE 091120 1,619.58 CODE-H,PER#-1,FUND- 201 A P-092520-123 PAYROLL INTERFACE 092520 1,633.10 CODE-H,PER#-2,FUND- 201 A 1510 WORKERS COMP INSURANCE PREM 2,200.00 0.00 148.73 1,362.51 837.49 61 ------1510 WORKERS COMP INSURANCE PREM 2,200.00 0.00 148.73 1,362.51 837.49 61 ------ P-091120-087 PAYROLL INTERFACE 091120 74.12 CODE-H,PER#-1,FUND- 201 A P-092520-123 PAYROLL INTERFACE 092520 74.61 CODE-H,PER#-2,FUND- 201 A TOTAL: PERSONAL SERVICES 409,300.00 0.00 32,108.46 299,917.48 109,382.52 73 ------- SUPPLIES 2000 OFFICE SUPPLIES 1,400.00 0.00 0.00 553.07 846.93 39 ---2000 OFFICE SUPPLIES 1,400.00 0.00 0.00 553.07 846.93 39 --- 34 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 2 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS SUPPLIES 2020 COMPUTER SUPPLIES 100.00 0.00 0.00 0.00 100.00 02020 COMPUTER SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2030 PRINTING & PRINTED FORMS 150.00 0.00 0.00 33.92 116.08 22 --2030 PRINTING & PRINTED FORMS 150.00 0.00 0.00 33.92 116.08 22 -- 2171 GENERAL SUPPLIES 100.00 0.00 0.00 10.99 89.01 10 -2171 GENERAL SUPPLIES 100.00 0.00 0.00 10.99 89.01 10 - 2175 FOOD SUPPLIES 100.00 0.00 0.00 0.00 100.00 02175 FOOD SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2280 VEHICLE REPAIR AND PARTS 600.00 0.00 66.22 96.47 503.53 16 -2280 VEHICLE REPAIR AND PARTS 600.00 0.00 66.22 96.47 503.53 16 - J-093020-179 SEPT 2020 GARAGE ALLOCAT 906 66.22 PLAN/INSPECT PARTS A 2282 GAS, OIL, LUBRICANTS 500.00 0.00 47.25 357.05 142.95 71 -------2282 GAS, OIL, LUBRICANTS 500.00 0.00 47.25 357.05 142.95 71 ------- J-093020-182 SEPT 2020 FUEL ALLOCATIO 905 47.25 PLANNING & INSPECTIONS A TOTAL: SUPPLIES 2,950.00 0.00 113.47 1,051.50 1,898.50 35 --- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 2,400.00 0.00 0.00 22,481.00 20,081.00- 936 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 2,400.00 0.00 0.00 22,481.00 20,081.00- 936 ----------!!!! 3105 TRAINING & EDUC ACTIVITIES 2,000.00 0.00 0.00 0.00 2,000.00 03105 TRAINING & EDUC ACTIVITIES 2,000.00 0.00 0.00 0.00 2,000.00 0 3210 TELEPHONE & TELEGRAPH 900.00 0.00 0.00 159.75 740.25 17 -3210 TELEPHONE & TELEGRAPH 900.00 0.00 0.00 159.75 740.25 17 - 3211 CELL PHONES 960.00 0.00 0.00 395.49 564.51 41 ----3211 CELL PHONES 960.00 0.00 0.00 395.49 564.51 41 ---- 3220 POSTAGE 1,000.00 0.00 255.95 907.45 92.55 90 ---------3220 POSTAGE 1,000.00 0.00 255.95 907.45 92.55 90 --------- J-093020-168 RECLASS POSTAGE EXPENSE 941 14.00 RECLASS POSTAGE EXPENSE A J-093020-170 POSTAGE USED JULY 1-SEPT 942 241.95 PER METER COUNT A 3250 OTHER COMMUNICATIONS 200.00 0.00 14.36 133.06 66.94 66 ------3250 OTHER COMMUNICATIONS 200.00 0.00 14.36 133.06 66.94 66 ------ D-091020-050 000298 COMCAST 181823 081020 14.36 081020 8772105050224795 002324 F N A 3310 LOCAL TRAVEL EXPENSE 500.00 0.00 0.00 0.00 500.00 03310 LOCAL TRAVEL EXPENSE 500.00 0.00 0.00 0.00 500.00 0 3500 LEGAL NOTICE PUBLISHING 750.00 0.00 343.13 1,085.64 335.64- 144 ----------!!!!3500 LEGAL NOTICE PUBLISHING 750.00 0.00 343.13 1,085.64 335.64- 144 ----------!!!! D-090320-017 022465 ECM PUBLISHERS INC 181731 292.50 TIFF DISCLOSURE 081420 N A D-091020-056 022465 ECM PUBLISHERS INC 181829 790807 50.63 PHN,BAHE,WILLIAMS 082120 N A 3600 PROP & LIAB INSURANCE 3,200.00 0.00 266.67 2,400.03 799.97 75 -------3600 PROP & LIAB INSURANCE 3,200.00 0.00 266.67 2,400.03 799.97 75 ------- J-093020-216 20 PROP & LIAB INS ALLOC 130 266.67 20 PROP & LIAB INS ALLOC A 4000 REPAIR & MAINT. SERVICES 825.00 0.00 44.49 294.00 531.00 35 ---4000 REPAIR & MAINT. SERVICES 825.00 0.00 44.49 294.00 531.00 35 --- J-093020-175 SEP 2020 COPIER ALLOCATI 943 44.49 SEP 20 COPIER CHARGE A 4040 INFORMATION SYS:INTERNAL SVC 9,700.00 0.00 808.33 7,274.97 2,425.03 74 -------4040 INFORMATION SYS:INTERNAL SVC 9,700.00 0.00 808.33 7,274.97 2,425.03 74 ------- J-093020-217 20 IS ALLOC 131 808.33 20 IS ALLOC A 4050 GARAGE, LABOR BURD. 500.00 0.00 290.07 567.46 67.46- 113 ----------!4050 GARAGE, LABOR BURD. 500.00 0.00 290.07 567.46 67.46- 113 ----------! J-093020-179 SEPT 2020 GARAGE ALLOCAT 906 290.07 PLAN/INSPECT LABOR A 35 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 3 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS OTHER SERVICES & CHARGES 4310 CREDIT CARD FEES 1,030.00 0.00 254.27 881.42 148.58 85 --------4310 CREDIT CARD FEES 1,030.00 0.00 254.27 881.42 148.58 85 -------- J-093020-154 CC FEE ALLOCATION 09/20 938 254.27 CC FEE 09/20 A 4330 SUBSCRIPTION, MEMBERSHIP 1,250.00 0.00 123.00 1,101.00 149.00 88 --------4330 SUBSCRIPTION, MEMBERSHIP 1,250.00 0.00 123.00 1,101.00 149.00 88 -------- M-090920-063 098992 ICC 181799 081420 123.00 2020 MN MECH CODE BK 073020 F N A 4380 COMMISSION & BOARDS 720.00 0.00 0.00 8.65 711.35 14380 COMMISSION & BOARDS 720.00 0.00 0.00 8.65 711.35 1 4390 TAXES & LICENSES 0.00 0.00 0.00 2,704.25 2,704.25-9999 ----------!!!!4390 TAXES & LICENSES 0.00 0.00 0.00 2,704.25 2,704.25-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 25,935.00 0.00 2,400.27 40,394.17 14,459.17- 155 ----------!!!! OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 -------7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- J-093020-212 20 TRANSFER:ADMIN LABOR 125 1,625.00 20 BUDGETED TRANSFER A TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 36,247.20 355,988.15 101,696.85 77 ------- TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 36,247.20 355,988.15 101,696.85 77 ------- 36 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 4 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 202 ANOKA CO COMM DEV PROGRAMS 46350 CDBG - COMM DEV BLOCK GRANT OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!! TOTAL: CDBG - COMM DEV BLOCK GRANT 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!! 46355 ANOKA CO HRA LEVY PROJECTS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!! TOTAL: ANOKA CO HRA LEVY PROJECTS 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!! TOTAL: ANOKA CO COMM DEV PROGRAMS 0.00 0.00 0.00 25,909.30 25,909.30-9999 ----------!!!! 37 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 5 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 204 EDA ADMINISTRATION 46314 ECONOMIC DEVELOPMENT AUTH PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 1,141.20 4,564.49 4,564.49-9999 ----------!!!!1000 ACCRUED SALARIES 0.00 0.00 1,141.20 4,564.49 4,564.49-9999 ----------!!!! X-090120-022 SALARY ACCRUAL AUG 2020 804 3,423.29- SALARY ACCRUAL AUG-20 A X-093020-145 SALARY ACCRUAL SEPT.2020 904 4,564.49 SALARY ACCRUAL SEP-20 A 1010 REGULAR EMPLOYEES 148,300.00 0.00 11,309.08 75,198.21 73,101.79 50 -----1010 REGULAR EMPLOYEES 148,300.00 0.00 11,309.08 75,198.21 73,101.79 50 ----- P-091120-087 PAYROLL INTERFACE 091120 5,603.47 CODE-H,PER#-1,FUND- 204 A P-092520-123 PAYROLL INTERFACE 092520 5,705.61 CODE-H,PER#-2,FUND- 204 A 1210 P.E.R.A. CONTRIBUTION 11,100.00 0.00 848.18 5,829.41 5,270.59 52 -----1210 P.E.R.A. CONTRIBUTION 11,100.00 0.00 848.18 5,829.41 5,270.59 52 ----- P-091120-087 PAYROLL INTERFACE 091120 420.26 CODE-H,PER#-1,FUND- 204 A P-092520-123 PAYROLL INTERFACE 092520 427.92 CODE-H,PER#-2,FUND- 204 A 1220 F.I.C.A. CONTRIBUTION 11,300.00 0.00 899.78 6,080.02 5,219.98 53 -----1220 F.I.C.A. CONTRIBUTION 11,300.00 0.00 899.78 6,080.02 5,219.98 53 ----- P-091120-087 PAYROLL INTERFACE 091120 445.76 CODE-H,PER#-1,FUND- 204 A P-092520-123 PAYROLL INTERFACE 092520 454.02 CODE-H,PER#-2,FUND- 204 A 1300 INSURANCE 21,900.00 0.00 755.58 6,512.63 15,387.37 29 --1300 INSURANCE 21,900.00 0.00 755.58 6,512.63 15,387.37 29 -- P-091120-087 PAYROLL INTERFACE 091120 362.10 CODE-H,PER#-1,FUND- 204 A P-092520-123 PAYROLL INTERFACE 092520 393.48 CODE-H,PER#-2,FUND- 204 A 1510 WORKERS COMP INSURANCE PREM 1,100.00 0.00 76.08 521.87 578.13 47 ----1510 WORKERS COMP INSURANCE PREM 1,100.00 0.00 76.08 521.87 578.13 47 ---- P-091120-087 PAYROLL INTERFACE 091120 37.71 CODE-H,PER#-1,FUND- 204 A P-092520-123 PAYROLL INTERFACE 092520 38.37 CODE-H,PER#-2,FUND- 204 A TOTAL: PERSONAL SERVICES 193,700.00 0.00 15,029.90 98,706.63 94,993.37 50 ----- SUPPLIES 2000 OFFICE SUPPLIES 1,300.00 0.00 0.00 0.00 1,300.00 02000 OFFICE SUPPLIES 1,300.00 0.00 0.00 0.00 1,300.00 0 2011 COMPUTER EQUIPMENT 0.00 0.00 0.00 1,891.26 1,891.26-9999 ----------!!!!2011 COMPUTER EQUIPMENT 0.00 0.00 0.00 1,891.26 1,891.26-9999 ----------!!!! 2020 COMPUTER SUPPLIES 215.00 0.00 0.00 0.00 215.00 02020 COMPUTER SUPPLIES 215.00 0.00 0.00 0.00 215.00 0 2171 GENERAL SUPPLIES 105.00 0.00 0.00 0.00 105.00 02171 GENERAL SUPPLIES 105.00 0.00 0.00 0.00 105.00 0 2175 FOOD SUPPLIES 210.00 0.00 0.00 0.00 210.00 02175 FOOD SUPPLIES 210.00 0.00 0.00 0.00 210.00 0 TOTAL: SUPPLIES 1,830.00 0.00 0.00 1,891.26 61.26- 103 ---------- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 6,980.00 0.00 0.00 2,435.00 4,545.00 34 ---3050 EXPERT & PROFESSIONAL SERV. 6,980.00 0.00 0.00 2,435.00 4,545.00 34 --- 3105 TRAINING & EDUC ACTIVITIES 1,500.00 0.00 0.00 295.00 1,205.00 19 -3105 TRAINING & EDUC ACTIVITIES 1,500.00 0.00 0.00 295.00 1,205.00 19 - 3210 TELEPHONE & TELEGRAPH 900.00 0.00 75.79 621.29 278.71 69 ------3210 TELEPHONE & TELEGRAPH 900.00 0.00 75.79 621.29 278.71 69 ------ D-091720-078 022200 POPP.COM INC 181951 992633654 75.79 083120-10010429 201325 F N A 38 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 6 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 204 EDA ADMINISTRATION 46314 ECONOMIC DEVELOPMENT AUTH OTHER SERVICES & CHARGES 3220 POSTAGE 700.00 0.00 25.65 250.65 449.35 35 ---3220 POSTAGE 700.00 0.00 25.65 250.65 449.35 35 --- J-093020-170 POSTAGE USED JULY 1-SEPT 942 25.65 PER METER COUNT A 3250 OTHER COMMUNICATIONS 250.00 0.00 19.15 171.38 78.62 68 ------3250 OTHER COMMUNICATIONS 250.00 0.00 19.15 171.38 78.62 68 ------ D-091020-050 000298 COMCAST 181823 081020 19.15 081020 8772105050224795 002324 F N A 3310 LOCAL TRAVEL EXPENSE 200.00 0.00 0.00 0.00 200.00 03310 LOCAL TRAVEL EXPENSE 200.00 0.00 0.00 0.00 200.00 0 3500 LEGAL NOTICE PUBLISHING 315.00 0.00 101.25 286.88 28.12 91 ---------3500 LEGAL NOTICE PUBLISHING 315.00 0.00 101.25 286.88 28.12 91 --------- D-091020-056 022465 ECM PUBLISHERS INC 181829 791875 101.25 PHN 3989 CNTL SALE 08282 N A 3600 PROP & LIAB INSURANCE 3,600.00 0.00 300.00 2,700.00 900.00 75 -------3600 PROP & LIAB INSURANCE 3,600.00 0.00 300.00 2,700.00 900.00 75 ------- J-093020-216 20 PROP & LIAB INS ALLOC 130 300.00 20 PROP & LIAB INS ALLOC A 4000 REPAIR & MAINT. SERVICES 0.00 0.00 44.49 409.50 409.50-9999 ----------!!!!4000 REPAIR & MAINT. SERVICES 0.00 0.00 44.49 409.50 409.50-9999 ----------!!!! J-093020-175 SEP 2020 COPIER ALLOCATI 943 44.49 SEP 20 COPIER CHARGE A 4040 INFORMATION SYS:INTERNAL SVC 7,300.00 0.00 608.33 5,474.97 1,825.03 74 -------4040 INFORMATION SYS:INTERNAL SVC 7,300.00 0.00 608.33 5,474.97 1,825.03 74 ------- J-093020-217 20 IS ALLOC 131 608.33 20 IS ALLOC A 4330 SUBSCRIPTION, MEMBERSHIP 1,500.00 0.00 0.00 0.00 1,500.00 04330 SUBSCRIPTION, MEMBERSHIP 1,500.00 0.00 0.00 0.00 1,500.00 0 4380 COMMISSION & BOARDS 925.00 0.00 0.00 105.00 820.00 11 -4380 COMMISSION & BOARDS 925.00 0.00 0.00 105.00 820.00 11 - TOTAL: OTHER SERVICES & CHARGES 24,170.00 0.00 1,174.66 12,749.67 11,420.33 52 ----- OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 -------7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- J-093020-212 20 TRANSFER:ADMIN LABOR 125 1,625.00 20 BUDGETED TRANSFER A TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 14,625.00 4,875.00 75 ------- TOTAL: ECONOMIC DEVELOPMENT AUTH 239,200.00 0.00 17,829.56 127,972.56 111,227.44 53 ----- TOTAL: EDA ADMINISTRATION 239,200.00 0.00 17,829.56 127,972.56 111,227.44 53 ----- 39 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 12 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 226 SPECIAL PROJECT REVENUE 52013 EAB TREE MANAGEMENT 2010 MINOR EQUIPMENT 0.00 0.00 0.00 4,610.00 4,610.00-9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 0.00 4,610.00 4,610.00-9999 ----------!!!! 2160 MAINT. & CONSTRUCT MATERIALS 0.00 0.00 352.50 8,406.25 8,406.25-9999 ----------!!!!2160 MAINT. & CONSTRUCT MATERIALS 0.00 0.00 352.50 8,406.25 8,406.25-9999 ----------!!!! D-091020-055 026480 SYLVA CORPORATION INC 181879 64352 352.50 MULCH N A 2171 GENERAL SUPPLIES 0.00 0.00 0.00 900.60 900.60-9999 ----------!!!!2171 GENERAL SUPPLIES 0.00 0.00 0.00 900.60 900.60-9999 ----------!!!! 4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 57,965.31 57,965.31-9999 ----------!!!!4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 57,965.31 57,965.31-9999 ----------!!!! TOTAL: EAB TREE MANAGEMENT 0.00 0.00 352.50 71,882.16 71,882.16-9999 ----------!!!! TOTAL: SPECIAL PROJECT REVENUE 0.00 0.00 352.50 71,882.16 71,882.16-9999 ----------!!!! 40 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 13 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 228 DOWNTOWN PARKING 46317 DOWNTOWN PARKING PERSONAL SERVICES 1070 INTERDEPARTMENTAL LABOR SERV 0.00 0.00 136.02 136.02 136.02-9999 ----------!!!!1070 INTERDEPARTMENTAL LABOR SERV 0.00 0.00 136.02 136.02 136.02-9999 ----------!!!! P-091120-087 PAYROLL INTERFACE 091120 136.02 CODE-H,PER#-1,FUND- 228 A 1210 P.E.R.A. CONTRIBUTION 0.00 0.00 10.19 10.19 10.19-9999 ----------!!!!1210 P.E.R.A. CONTRIBUTION 0.00 0.00 10.19 10.19 10.19-9999 ----------!!!! P-091120-087 PAYROLL INTERFACE 091120 10.19 CODE-H,PER#-1,FUND- 228 A 1220 F.I.C.A. CONTRIBUTION 0.00 0.00 9.73 9.73 9.73-9999 ----------!!!!1220 F.I.C.A. CONTRIBUTION 0.00 0.00 9.73 9.73 9.73-9999 ----------!!!! P-091120-087 PAYROLL INTERFACE 091120 9.73 CODE-H,PER#-1,FUND- 228 A 1300 INSURANCE 0.00 0.00 35.11 35.11 35.11-9999 ----------!!!!1300 INSURANCE 0.00 0.00 35.11 35.11 35.11-9999 ----------!!!! P-091120-087 PAYROLL INTERFACE 091120 35.11 CODE-H,PER#-1,FUND- 228 A 1510 WORKERS COMP INSURANCE PREM 0.00 0.00 11.08 11.08 11.08-9999 ----------!!!!1510 WORKERS COMP INSURANCE PREM 0.00 0.00 11.08 11.08 11.08-9999 ----------!!!! P-091120-087 PAYROLL INTERFACE 091120 11.08 CODE-H,PER#-1,FUND- 228 A TOTAL: PERSONAL SERVICES 0.00 0.00 202.13 202.13 202.13-9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 3,697.50 3,697.50-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 3,697.50 3,697.50-9999 ----------!!!! 3600 PROP & LIAB INSURANCE 6,900.00 0.00 575.00 5,175.00 1,725.00 75 -------3600 PROP & LIAB INSURANCE 6,900.00 0.00 575.00 5,175.00 1,725.00 75 ------- J-093020-216 20 PROP & LIAB INS ALLOC 130 575.00 20 PROP & LIAB INS ALLOC A 3810 ELECTRIC 0.00 0.00 846.43 4,952.70 4,952.70-9999 ----------!!!!3810 ELECTRIC 0.00 0.00 846.43 4,952.70 4,952.70-9999 ----------!!!! D-091720-089 005695 XCEL ENERGY (N S P) 181975 0859444364 846.43 090820 51-0013059132-8 N A 3820 WATER 0.00 0.00 34.13 109.68 109.68-9999 ----------!!!!3820 WATER 0.00 0.00 34.13 109.68 109.68-9999 ----------!!!! J-093020-079 CITY UB BILLS-SECTION 2 901 34.13 UTILITIES-JUNE,JULY,AUG A 3850 SEWER 0.00 0.00 157.04 976.29 976.29-9999 ----------!!!!3850 SEWER 0.00 0.00 157.04 976.29 976.29-9999 ----------!!!! J-093020-079 CITY UB BILLS-SECTION 2 901 157.04 UTILITIES-JUNE,JULY,AUG A 4000 REPAIR & MAINT. SERVICES 18,100.00 0.00 0.00 342.80 17,757.20 14000 REPAIR & MAINT. SERVICES 18,100.00 0.00 0.00 342.80 17,757.20 1 TOTAL: OTHER SERVICES & CHARGES 25,000.00 0.00 1,612.60 15,253.97 9,746.03 61 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,814.73 15,456.10 9,543.90 61 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,814.73 15,456.10 9,543.90 61 ------ 41 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 38 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 371 TIF T4: KMART/CENTRAL AVE 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 5,000.00 0.00 1,298.25 12,012.03 7,012.03- 240 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 5,000.00 0.00 1,298.25 12,012.03 7,012.03- 240 ----------!!!! D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84309 410.75 T4 TIF ADMIN 001560 P M A D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84326 887.50 T4 TIF REPORT 001560 P M A 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 227,885.37 227,885.37 227,885.37-9999 ----------!!!!4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 227,885.37 227,885.37 227,885.37-9999 ----------!!!! D-092420-113 028495 SPRINT SPECTRUM REALTY C 182163 1-21-2020 10,200.00 SPRINT RELOCATION 202030 P M A D-092820-126 028505 AT&T MOBILITY II, LLC 182180 9-25-2020 132,263.37 AT&T SETTLEMENT 203044 P N A M-093020-140 028515 CROWN CASTLE AS LLC 182181 9-25-2020 85,422.00 CROWN CASTLE SETTLE 203044 P N A TOTAL: OTHER SERVICES & CHARGES 5,000.00 0.00 229,183.62 239,897.40 234,897.40-4797 ----------!!!! CAPITAL OUTLAY 6010 PRINCIPAL 75,000.00 0.00 0.00 0.00 75,000.00 06010 PRINCIPAL 75,000.00 0.00 0.00 0.00 75,000.00 0 6110 INTEREST 5,800.00 0.00 0.00 0.00 5,800.00 06110 INTEREST 5,800.00 0.00 0.00 0.00 5,800.00 0 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 475.00 725.00 39 ---6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 475.00 725.00 39 --- TOTAL: CAPITAL OUTLAY 82,000.00 0.00 0.00 475.00 81,525.00 0 OTHER FINANCING USES 7435 TRANSFER OUT TO: OTHER 0.00 0.00 0.00 37,655.00 37,655.00-9999 ----------!!!!7435 TRANSFER OUT TO: OTHER 0.00 0.00 0.00 37,655.00 37,655.00-9999 ----------!!!! TOTAL: OTHER FINANCING USES 0.00 0.00 0.00 37,655.00 37,655.00-9999 ----------!!!! TOTAL: BONDS 87,000.00 0.00 229,183.62 278,027.40 191,027.40- 319 ----------!!!! TOTAL: TIF T4: KMART/CENTRAL AVE 87,000.00 0.00 229,183.62 278,027.40 191,027.40- 319 ----------!!!! 42 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 39 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 372 HUSET PARK AREA TIF (T6) 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 9,000.00 0.00 1,298.25 1,298.25 7,701.75 14 -3050 EXPERT & PROFESSIONAL SERV. 9,000.00 0.00 1,298.25 1,298.25 7,701.75 14 - D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84309 410.75 T6 TIF ADMIN 001560 P M A D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84326 887.50 T6 RIF REPORT 001560 P M A 4600 LOANS & GRANTS 233,900.00 0.00 0.00 302,658.46 68,758.46- 129 ----------!!4600 LOANS & GRANTS 233,900.00 0.00 0.00 302,658.46 68,758.46- 129 ----------!! TOTAL: OTHER SERVICES & CHARGES 242,900.00 0.00 1,298.25 303,956.71 61,056.71- 125 ----------!! CAPITAL OUTLAY 6010 PRINCIPAL 130,000.00 0.00 0.00 130,000.00 0.00 100 ----------6010 PRINCIPAL 130,000.00 0.00 0.00 130,000.00 0.00 100 ---------- 6110 INTEREST 62,000.00 0.00 0.00 61,957.50 42.50 99 ---------6110 INTEREST 62,000.00 0.00 0.00 61,957.50 42.50 99 --------- 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 0.00 1,200.00 06200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 0.00 1,200.00 0 TOTAL: CAPITAL OUTLAY 193,200.00 0.00 0.00 191,957.50 1,242.50 99 --------- TOTAL: BONDS 436,100.00 0.00 1,298.25 495,914.21 59,814.21- 113 ----------! TOTAL: HUSET PARK AREA TIF (T6) 436,100.00 0.00 1,298.25 495,914.21 59,814.21- 113 ----------! 43 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 41 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 376 TIF DISTRICTS A3/C7/C8 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,298.25 1,298.25 1,298.25-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,298.25 1,298.25 1,298.25-9999 ----------!!!! D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84309 410.75 C8 TIF ADMIN 001560 P M A D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84326 887.50 C8 TIF REPORT 001560 P M A TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 1,298.25 1,298.25 1,298.25-9999 ----------!!!! TOTAL: BONDS 0.00 0.00 1,298.25 1,298.25 1,298.25-9999 ----------!!!! TOTAL: TIF DISTRICTS A3/C7/C8 0.00 0.00 1,298.25 1,298.25 1,298.25-9999 ----------!!!! 44 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 42 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 385 TIF K2 M.U.R.P. 47000 TAX INCREMENT BONDS OTHER SERVICES & CHARGES 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 249,578.00 249,578.00 249,578.00-9999 ----------!!!!4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 249,578.00 249,578.00 249,578.00-9999 ----------!!!! M-093020-140 028515 CROWN CASTLE AS LLC 182181 9-25-2020 249,578.00 CROWN CASTLE SETTLE 203044 P N A 4600 LOANS & GRANTS 0.00 0.00 0.00 1,794.00 1,794.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 1,794.00 1,794.00-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 249,578.00 251,372.00 251,372.00-9999 ----------!!!! TOTAL: TAX INCREMENT BONDS 0.00 0.00 249,578.00 251,372.00 251,372.00-9999 ----------!!!! TOTAL: TIF K2 M.U.R.P. 0.00 0.00 249,578.00 251,372.00 251,372.00-9999 ----------!!!! 45 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 43 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 389 TIF R8 CRESTV/TRANSITION BLK 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,298.25 1,298.25 1,298.25-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,298.25 1,298.25 1,298.25-9999 ----------!!!! D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84309 410.75 R8 TIF ADMIN 001560 P M A D-091720-078 005825 EHLERS & ASSOCIATES INC 181915 84326 887.50 R8 TIF REPORT 001560 P M A 4600 LOANS & GRANTS 0.00 0.00 0.00 26,847.00 26,847.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 26,847.00 26,847.00-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 1,298.25 28,145.25 28,145.25-9999 ----------!!!! TOTAL: BONDS 0.00 0.00 1,298.25 28,145.25 28,145.25-9999 ----------!!!! TOTAL: TIF R8 CRESTV/TRANSITION BLK 0.00 0.00 1,298.25 28,145.25 28,145.25-9999 ----------!!!! 46 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 45 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 408 EDA REDEVELOPMENT PROJECT FD 46314 ECONOMIC DEVELOPMENT AUTH 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78 7,082.78-9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78 7,082.78-9999 ----------!!!! 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 348.00 348.00-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 348.00 348.00-9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 5,040.00 5,040.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 5,040.00 5,040.00-9999 ----------!!!! TOTAL: ECONOMIC DEVELOPMENT AUTH 0.00 0.00 0.00 12,470.78 12,470.78-9999 ----------!!!! 46411 FACADE IMPROVEMENT GRANT 2010 MINOR EQUIPMENT 0.00 0.00 0.00 15,526.48 15,526.48-9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 0.00 15,526.48 15,526.48-9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 5,000.00 5,000.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 5,000.00 5,000.00-9999 ----------!!!! TOTAL: FACADE IMPROVEMENT GRANT 0.00 0.00 0.00 20,526.48 20,526.48-9999 ----------!!!! 46414 COMMERCIAL REVITALIZATION SUPPLIES 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! TOTAL: SUPPLIES 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 6,865.30 6,865.30-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 6,865.30 6,865.30-9999 ----------!!!! 3810 ELECTRIC 0.00 0.00 429.31 1,753.93 1,753.93-9999 ----------!!!!3810 ELECTRIC 0.00 0.00 429.31 1,753.93 1,753.93-9999 ----------!!!! D-091720-089 005695 XCEL ENERGY (N S P) 181975 0859065359 11.18 090420 51-0012963900-4 N A D-091720-089 005695 XCEL ENERGY (N S P) 181975 0859201308 11.31 090420 51-0012469064-3 N A D-091720-089 005695 XCEL ENERGY (N S P) 181975 0859443347 406.82 090820 51-0012875093-9 N A 3830 GAS 0.00 0.00 21.60 99.21 99.21-9999 ----------!!!!3830 GAS 0.00 0.00 21.60 99.21 99.21-9999 ----------!!!! D-091720-089 004945 CENTER POINT ENERGY 181906 11173439-8 10.80 090820 11173439-8 N A D-091720-089 004945 CENTER POINT ENERGY 181906 6401438486-7 10.80 090820 6401438486-7 N A 4000 REPAIR & MAINT. SERVICES 0.00 0.00 514.00 514.00 514.00-9999 ----------!!!!4000 REPAIR & MAINT. SERVICES 0.00 0.00 514.00 514.00 514.00-9999 ----------!!!! D-090320-017 012710 DU ALL SERVICE CONTRACTO 181730 8841 514.00 BOARD UP 4441 CENT N A 4600 LOANS & GRANTS 50,000.00 0.00 0.00 950.00 49,050.00 14600 LOANS & GRANTS 50,000.00 0.00 0.00 950.00 49,050.00 1 TOTAL: OTHER SERVICES & CHARGES 50,000.00 0.00 964.91 10,182.44 39,817.56 20 -- CAPITAL OUTLAY 5110 LAND 200,000.00 0.00 0.00 129,010.43 70,989.57 64 ------5110 LAND 200,000.00 0.00 0.00 129,010.43 70,989.57 64 ------ TOTAL: CAPITAL OUTLAY 200,000.00 0.00 0.00 129,010.43 70,989.57 64 ------ TOTAL: COMMERCIAL REVITALIZATION 250,000.00 0.00 964.91 132,110.09 117,889.91 52 ----- 46416 3989 CENTRAL AVE 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 14,369.19 77,765.11 77,765.11-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 14,369.19 77,765.11 77,765.11-9999 ----------!!!! D-091720-078 003290 KENNEDY & GRAVEN 181930 156250 140.00 3989 CENTRAL AVE AGREE 000509 P M A D-091720-081 012010 BARNA GUZY & STEFFEN LTD 181893 220070 110.00 CELL LSE/PURCH 3989 CEN 000383 P M A D-091720-081 012010 BARNA GUZY & STEFFEN LTD 181893 220069 3,279.69 LEASE TERMINATION-CROWN 000383 P M A 47 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 46 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 408 EDA REDEVELOPMENT PROJECT FD 46416 3989 CENTRAL AVE 3050 EXPERT & PROFESSIONAL SERV. D-092420-116 012010 BARNA GUZY & STEFFEN LTD 182087 221517 9,574.50 CROWN CASTLE LEASE 000383 P M A D-092420-116 012010 BARNA GUZY & STEFFEN LTD 182087 221518 1,265.00 ALATUS-3989 CENT 000383 P M A 3810 ELECTRIC 0.00 0.00 119.00 1,189.87 1,189.87-9999 ----------!!!!3810 ELECTRIC 0.00 0.00 119.00 1,189.87 1,189.87-9999 ----------!!!! D-091720-089 005695 XCEL ENERGY (N S P) 181975 0859430894 119.00 090820 51-0012807608-9 N A 4020 BUILDING MAINT:CONTRACT SVCS 0.00 0.00 0.00 260.37 260.37-9999 ----------!!!!4020 BUILDING MAINT:CONTRACT SVCS 0.00 0.00 0.00 260.37 260.37-9999 ----------!!!! 5110 LAND 0.00 0.00 0.00 54,546.69 54,546.69-9999 ----------!!!!5110 LAND 0.00 0.00 0.00 54,546.69 54,546.69-9999 ----------!!!! 5191 ASSETS FOR RESALE 0.00 0.00 0.00 18,830.48 18,830.48-9999 ----------!!!!5191 ASSETS FOR RESALE 0.00 0.00 0.00 18,830.48 18,830.48-9999 ----------!!!! TOTAL: 3989 CENTRAL AVE 0.00 0.00 14,488.19 152,592.52 152,592.52-9999 ----------!!!! 52011 DEMO 3989 CENT AVE & RAMP 2171 GENERAL SUPPLIES 0.00 0.00 0.00 206.25 206.25-9999 ----------!!!!2171 GENERAL SUPPLIES 0.00 0.00 0.00 206.25 206.25-9999 ----------!!!! 3500 LEGAL NOTICE PUBLISHING 0.00 0.00 0.00 545.63 545.63-9999 ----------!!!!3500 LEGAL NOTICE PUBLISHING 0.00 0.00 0.00 545.63 545.63-9999 ----------!!!! TOTAL: DEMO 3989 CENT AVE & RAMP 0.00 0.00 0.00 751.88 751.88-9999 ----------!!!! TOTAL: EDA REDEVELOPMENT PROJECT FD 250,000.00 0.00 15,453.10 318,451.75 68,451.75- 127 ----------!! 48 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 10/21/2020 9:44:01 Exp. Guideline with Detail GL525R-V08.14 PAGE 56 FOR THE PERIOD(S) JAN 01, 2020 THROUGH SEP 30, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 420 CAP IMPROVEMENT DEVELOPMENT 46407 3930 UNIVERSITY 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,593.75 1,906.25 1,906.25-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 1,593.75 1,906.25 1,906.25-9999 ----------!!!! D-090320-017 005135 MN POLLUTION CONTROL AGE 181762 10000110188 125.00 VIC REIMB-ROOT PROP 081820 P N A D-090320-017 005135 MN POLLUTION CONTROL AGE 181762 10000110078 1,468.75 VIC REIMB-ROOT PROP 081820 P N A TOTAL: 3930 UNIVERSITY 0.00 0.00 1,593.75 1,906.25 1,906.25-9999 ----------!!!! TOTAL: CAP IMPROVEMENT DEVELOPMENT 0.00 0.00 1,593.75 1,906.25 1,906.25-9999 ----------!!!! 49 COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY CASH DISBURSEMENTS FOR THE MONTH ENDING OCTOBER 30, 2020 CHECK#CHECK DATE AMOUNT VENDOR NAME FUND DETAIL DESCR 182202 10/1/2020 14.36 COMCAST 201 091020 8772105050224795 182328 10/8/2020 9,840.60 METRO COUNCIL ENVIROMENT 201 SAC SEPT 2020 182332 10/8/2020 2,211.16 MN DEPT OF LABOR & INDUS 201 3RD QTR 2020SURCHARGE 182379 10/8/2020 79.98 AMAZON.COM 201 NISPIRIA HEPA FILTERS 182665 10/29/2020 271.93 RAPIT PRINTING - NEW BRI 201 RECEIPT FORMS 182665 10/29/2020 306.16 RAPIT PRINTING - NEW BRI 201 INSPECTION RECORD FORM 182187 10/1/2020 46 ANOKA COUNTY PROPERTY RE 204 REV RECORDING FEE 182202 10/1/2020 19.15 COMCAST 204 091020 8772105050224795 182562 10/22/2020 79.34 POPP.COM INC 204 093020-10010429 182211 10/1/2020 330 HIGH PROFILE GROUNDS MAI 228 VANBUREN RAMP CLEANOUT 182583 10/22/2020 814.69 XCEL ENERGY (N S P)228 100720 51-0013059132-8 182410 10/15/2020 437.5 EHLERS & ASSOCIATES INC 372 ANNUAL TIF REPORTING 182258 10/8/2020 650 ANGSTROM ANALYTICAL INC 408 ASBESTOS DEMO SURVEY 182259 10/8/2020 47,482.91 ANOKA COUNTY 408 3989 CENTRAL 2ND HALF 182259 10/8/2020 3,316.70 ANOKA COUNTY 408 3889 CENTRAL 2ND HALF 182259 10/8/2020 79.52 ANOKA COUNTY 408 950 40TH 2ND HALF 182259 10/8/2020 26.62 ANOKA COUNTY 408 4827 UNIVERSITY 2ND 182260 10/8/2020 2,289.73 ANOKA COUNTY PROPERTY RE 408 230 40TH AVE 1ST HALF 182260 10/8/2020 1,152.46 ANOKA COUNTY PROPERTY RE 408 4441 CENTRAL FULL YEAR 182410 10/15/2020 900 EHLERS & ASSOCIATES INC 408 3989 CENTRAL PROF SERV 182410 10/15/2020 295 EHLERS & ASSOCIATES INC 408 3989 CENTRAL PROF SERV 182431 10/15/2020 940 KENNEDY & GRAVEN 408 3989 CENTRAL PROF SERV 182456 10/15/2020 1,000.00 PRO-TEC DESIGN INC 408 FACADE GRANT CAMERAS 182507 10/22/2020 10.8 CENTER POINT ENERGY 408 100820 11173439-8 182507 10/22/2020 18.92 CENTER POINT ENERGY 408 100820 6401438486-7 182583 10/22/2020 400.82 XCEL ENERGY (N S P)408 100720 51-0012875093-9 182583 10/22/2020 10.69 XCEL ENERGY (N S P)408 100620 51-0012963900-4 182583 10/22/2020 13.49 XCEL ENERGY (N S P)408 100620 51-0012469064-3 182643 10/29/2020 6.95 KLOIBER, JOSEPH 408 CERTIF MAIL:AT&T STTLMT 182670 10/29/2020 2,632.00 ROBINSON ENVIRONMENTAL I 408 4441 CNTRL ASBESTOS RMVL 50 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 4 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 201 PLANNING & INSPECTIONS 00 REVENUE LICENSES AND PERMITS 32110 LIQUOR, WINE & BEER LICENSE 14,785.00 14,785.00 0.00 0.00 14,785.00 0 32122 FOOD SVC VEHICLES 500.00 500.00 0.00 300.00 200.00 60 ------ 32125 MULTIPLE DWELLINGS 6,900.00 6,900.00 0.00 3,520.00 3,380.00 51 ----- 32161 CONTRACTOR 17,500.00 17,500.00 1,040.00 11,840.00 5,660.00 67 ------ 32168 OTHER PROFESSIONAL & OCCUP 2,400.00 2,400.00 2,350.00 4,000.00 1,600.00- 166 ----------!!!! 32178 OTHER AMUSEMENT LICENSES 1,000.00 1,000.00 550.15 575.15 424.85 57 ----- 32181 PLANNING AND ZONING FEES 5,200.00 5,200.00 685.50 10,462.10 5,262.10- 201 ----------!!!! 32188 OTHER BUSINESS LICENSES 3,800.00 3,800.00 1,250.00 2,158.50 1,641.50 56 ----- 32191 SPRINKLER PERMIT FEES 4,000.00 4,000.00 209.25 1,922.91 2,077.09 48 ---- 32192 BUILDING & MOVING PERMITS 231,000.00 231,000.00 9,572.17 153,348.73 77,651.27 66 ------ 32194 HEATING PERMITS 20,000.00 20,000.00 2,166.25 22,172.00 2,172.00- 110 ----------! 32195 PLUMBING PERMITS 13,000.00 13,000.00 1,165.50 9,420.19 3,579.81 72 ------- 32197 ABANDONED PROP INSPECT FEE 500.00 500.00 0.00 0.00 500.00 0 TOTAL: LICENSES AND PERMITS 320,585.00 320,585.00 18,988.82 219,719.58 100,865.42 68 ------ MISCELLANEOUS 36260 SURCHARGE RETENTION 2,000.00 2,000.00 92.13 241.92 1,758.08 12 - 36290 OTHER MISC. REVENUE 0.00 0.00 0.00 30.00 30.00- 9999 ----------!!!! 36293 SAC/WAC CHARGES COLLECTED 0.00 0.00 99.40 99.40 99.40- 9999 ----------!!!! TOTAL: MISCELLANEOUS 2,000.00 2,000.00 191.53 371.32 1,628.68 18 - TRANSFERS & NONREV RECEIPTS 39203 TRANSFER IN FROM GENERAL FND 135,000.00 135,000.00 11,250.00 112,500.00 22,500.00 83 -------- TOTAL: TRANSFERS & NONREV RECEIPTS 135,000.00 135,000.00 11,250.00 112,500.00 22,500.00 83 -------- TOTAL: REVENUE 457,585.00 457,585.00 30,430.35 332,590.90 124,994.10 72 ------- TOTAL: PLANNING & INSPECTIONS 457,585.00 457,585.00 30,430.35 332,590.90 124,994.10 72 ------- 51 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 5 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 202 ANOKA CO COMM DEV PROGRAMS 00 REVENUE 33165 FEDERAL GRANT PASS THROUGH 0.00 0.00 0.00 24,755.00 24,755.00- 9999 ----------!!!! 36400 PRINCIPAL REPAYMENT - LOANS 0.00 0.00 0.00 480.00 480.00- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 25,235.00 25,235.00- 9999 ----------!!!! TOTAL: ANOKA CO COMM DEV PROGRAMS 0.00 0.00 0.00 25,235.00 25,235.00- 9999 ----------!!!! 52 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 6 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 204 EDA ADMINISTRATION 00 REVENUE TAXES 31011 EDA CURRENT AD VALOREM 171,500.00 171,500.00 0.00 93,090.50 78,409.50 54 ----- 31014 AREA WIDE TAX 73,600.00 73,600.00 0.00 31,827.97 41,772.03 43 ---- 31020 DELINQ. AD VALOREM 0.00 0.00 0.00 782.26 782.26- 9999 ----------!!!! TOTAL: TAXES 245,100.00 245,100.00 0.00 125,700.73 119,399.27 51 ----- CHARGES FOR SERVICES 34112 ADMINISTRATIVE FEES 0.00 0.00 0.00 30.00 30.00- 9999 ----------!!!! TOTAL: CHARGES FOR SERVICES 0.00 0.00 0.00 30.00 30.00- 9999 ----------!!!! TOTAL: REVENUE 245,100.00 245,100.00 0.00 125,730.73 119,369.27 51 ----- TOTAL: EDA ADMINISTRATION 245,100.00 245,100.00 0.00 125,730.73 119,369.27 51 ----- 53 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 9 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 226 SPECIAL PROJECT REVENUE 00 REVENUE 33422 STATE GRANT 0.00 0.00 0.00 2,700.00 2,700.00- 9999 ----------!!!! 34112 ADMINISTRATIVE FEES 0.00 0.00 0.00 19,785.00 19,785.00- 9999 ----------!!!! 36225 NONDWELLING RENTS 0.00 0.00 40,518.32 68,973.65 68,973.65- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 40,518.32 91,458.65 91,458.65- 9999 ----------!!!! TOTAL: SPECIAL PROJECT REVENUE 0.00 0.00 40,518.32 91,458.65 91,458.65- 9999 ----------!!!! 54 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 10 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 228 DOWNTOWN PARKING 00 REVENUE 36225 NONDWELLING RENTS 15,000.00 15,000.00 2,600.00 13,000.00 2,000.00 86 -------- 39247 TRANSFER IN-SPECIAL PROJ REV 10,000.00 10,000.00 0.00 0.00 10,000.00 0 TOTAL: REVENUE 25,000.00 25,000.00 2,600.00 13,000.00 12,000.00 52 ----- TOTAL: DOWNTOWN PARKING 25,000.00 25,000.00 2,600.00 13,000.00 12,000.00 52 ----- 55 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 21 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 371 TIF T4: KMART/CENTRAL AVE 00 REVENUE TAXES 31010 CURRENT AD VALOREM 81,000.00 81,000.00 0.00 1.08- 81,001.08 0 31020 DELINQ. AD VALOREM 0.00 0.00 0.00 1.08 1.08- 9999 ----------!!!! TOTAL: TAXES 81,000.00 81,000.00 0.00 0.00 81,000.00 0 MISCELLANEOUS 36210 INTEREST ON INVESTMENTS 5,000.00 5,000.00 0.00 0.00 5,000.00 0 TOTAL: MISCELLANEOUS 5,000.00 5,000.00 0.00 0.00 5,000.00 0 TOTAL: REVENUE 86,000.00 86,000.00 0.00 0.00 86,000.00 0 TOTAL: TIF T4: KMART/CENTRAL AVE 86,000.00 86,000.00 0.00 0.00 86,000.00 0 56 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 22 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 372 HUSET PARK AREA TIF (T6) 00 REVENUE 31010 CURRENT AD VALOREM 189,800.00 189,800.00 0.00 348,949.23 159,149.23- 183 ----------!!!! 31020 DELINQ. AD VALOREM 0.00 0.00 0.00 667.98 667.98- 9999 ----------!!!! 36210 INTEREST ON INVESTMENTS 5,000.00 5,000.00 0.00 0.00 5,000.00 0 TOTAL: REVENUE 194,800.00 194,800.00 0.00 349,617.21 154,817.21- 179 ----------!!!! TOTAL: HUSET PARK AREA TIF (T6) 194,800.00 194,800.00 0.00 349,617.21 154,817.21- 179 ----------!!!! 57 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 24 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 385 TIF K2 M.U.R.P. 00 REVENUE TAXES 31010 CURRENT AD VALOREM 0.00 0.00 0.00 16,452.56 16,452.56- 9999 ----------!!!! TOTAL: TAXES 0.00 0.00 0.00 16,452.56 16,452.56- 9999 ----------!!!! TRANSFERS & NONREV RECEIPTS 39204 TRANSFER IN-OTHER 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: TRANSFERS & NONREV RECEIPTS 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 54,107.56 54,107.56- 9999 ----------!!!! TOTAL: TIF K2 M.U.R.P. 0.00 0.00 0.00 54,107.56 54,107.56- 9999 ----------!!!! 58 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 25 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 389 TIF R8 CRESTV/TRANSITION BLK 00 REVENUE TAXES 31010 CURRENT AD VALOREM 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! TOTAL: TAXES 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! TOTAL: TIF R8 CRESTV/TRANSITION BLK 0.00 0.00 0.00 29,891.44 29,891.44- 9999 ----------!!!! 59 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 26 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 391 SCATTERED SITE TIF W3/W4 00 REVENUE 31010 CURRENT AD VALOREM 0.00 0.00 0.00 21,903.17 21,903.17- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 21,903.17 21,903.17- 9999 ----------!!!! TOTAL: SCATTERED SITE TIF W3/W4 0.00 0.00 0.00 21,903.17 21,903.17- 9999 ----------!!!! 60 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 28 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 408 EDA REDEVELOPMENT PROJECT FD 00 REVENUE 31012 HRA CURRENT AD VALOREM 175,000.00 175,000.00 0.00 90,755.96 84,244.04 51 ----- 31014 AREA WIDE TAX 75,100.00 75,100.00 0.00 34,996.00 40,104.00 46 ---- 34113 DEVELOPER FEES 0.00 0.00 61,951.95 72,951.95 72,951.95- 9999 ----------!!!! 36290 OTHER MISC. REVENUE 0.00 0.00 0.00 86.87 86.87- 9999 ----------!!!! 39100 SALE OF LAND 0.00 0.00 5,550,000.00 5,550,000.00 5,550,000.00- 9999 ----------!!!! TOTAL: REVENUE 250,100.00 250,100.00 5,611,951.95 5,748,790.78 5,498,690.78- 2298 ----------!!!! TOTAL: EDA REDEVELOPMENT PROJECT FD 250,100.00 250,100.00 5,611,951.95 5,748,790.78 5,498,690.78- 2298 ----------!!!! 61 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:01:50 Revenue Guideline GL520R-V08.14 PAGE 32 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING ADOPTED BUDGET REVISED BUDGET AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 420 CAP IMPROVEMENT DEVELOPMENT 00 REVENUE 34113 DEVELOPER FEES 0.00 0.00 0.00 91,500.00 91,500.00- 9999 ----------!!!! TOTAL: REVENUE 0.00 0.00 0.00 91,500.00 91,500.00- 9999 ----------!!!! TOTAL: CAP IMPROVEMENT DEVELOPMENT 0.00 0.00 0.00 91,500.00 91,500.00- 9999 ----------!!!! 62 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 1 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 1,443.82 10,635.76 10,635.76- 9999 ----------!!!! 1010 REGULAR EMPLOYEES 269,300.00 0.00 20,137.64 201,703.16 67,596.84 74 ------- 1011 PART-TIME EMPLOYEES 47,000.00 0.00 1,765.30 21,875.03 25,124.97 46 ---- 1020 OVERTIME-REGULAR 1,500.00 0.00 100.16 1,023.72 476.28 68 ------ 1050 SEVERANCE PAY 0.00 0.00 0.00 23,377.88 23,377.88- 9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 23,000.00 0.00 1,517.85 16,659.63 6,340.37 72 ------- 1220 F.I.C.A. CONTRIBUTION 24,300.00 0.00 1,697.44 18,099.35 6,200.65 74 ------- 1225 FLEX BENEFIT FICA 0.00 0.00 25.83 258.30 258.30- 9999 ----------!!!! 1300 INSURANCE 42,000.00 0.00 3,252.67 34,862.85 7,137.15 83 -------- 1510 WORKERS COMP INSURANCE PREM 2,200.00 0.00 141.91 1,504.42 695.58 68 ------ TOTAL: PERSONAL SERVICES 409,300.00 0.00 30,082.62 330,000.10 79,299.90 80 -------- SUPPLIES 2000 OFFICE SUPPLIES 1,400.00 0.00 0.00 553.07 846.93 39 --- 2020 COMPUTER SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2030 PRINTING & PRINTED FORMS 150.00 0.00 578.09 612.01 462.01- 408 ----------!!!! 2171 GENERAL SUPPLIES 100.00 0.00 79.98 90.97 9.03 90 --------- 2175 FOOD SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2280 VEHICLE REPAIR AND PARTS 600.00 0.00 13.78 110.25 489.75 18 - 2282 GAS, OIL, LUBRICANTS 500.00 0.00 28.48 385.53 114.47 77 ------- TOTAL: SUPPLIES 2,950.00 0.00 700.33 1,751.83 1,198.17 59 ----- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 2,400.00 0.00 0.00 22,481.00 20,081.00- 936 ----------!!!! 3105 TRAINING & EDUC ACTIVITIES 2,000.00 0.00 0.00 0.00 2,000.00 0 3210 TELEPHONE & TELEGRAPH 900.00 0.00 0.00 159.75 740.25 17 - 3211 CELL PHONES 960.00 0.00 0.00 395.49 564.51 41 ---- 3220 POSTAGE 1,000.00 0.00 0.00 907.45 92.55 90 --------- 3250 OTHER COMMUNICATIONS 200.00 0.00 14.36 147.42 52.58 73 ------- 3310 LOCAL TRAVEL EXPENSE 500.00 0.00 0.00 0.00 500.00 0 3500 LEGAL NOTICE PUBLISHING 750.00 0.00 0.00 1,085.64 335.64- 144 ----------!!!! 3600 PROP & LIAB INSURANCE 3,200.00 0.00 266.67 2,666.70 533.30 83 -------- 4000 REPAIR & MAINT. SERVICES 825.00 0.00 20.45 314.45 510.55 38 --- 4040 INFORMATION SYS:INTERNAL SVC 9,700.00 0.00 808.33 8,083.30 1,616.70 83 -------- 4050 GARAGE, LABOR BURD. 500.00 0.00 118.13 685.59 185.59- 137 ----------!!! 4310 CREDIT CARD FEES 1,030.00 0.00 338.69 1,220.11 190.11- 118 ----------! 4330 SUBSCRIPTION, MEMBERSHIP 1,250.00 0.00 0.00 1,101.00 149.00 88 -------- 4380 COMMISSION & BOARDS 720.00 0.00 0.00 8.65 711.35 1 4390 TAXES & LICENSES 0.00 0.00 0.00 2,704.25 2,704.25- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 25,935.00 0.00 1,566.63 41,960.80 16,025.80- 161 ----------!!!! OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- 63 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 2 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 201 PLANNING & INSPECTIONS TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 33,974.58 389,962.73 67,722.27 85 -------- TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 33,974.58 389,962.73 67,722.27 85 -------- 64 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 3 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 202 ANOKA CO COMM DEV PROGRAMS 46350 CDBG - COMM DEV BLOCK GRANT OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 24,753.30 24,753.30- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 24,753.30 24,753.30- 9999 ----------!!!! TOTAL: CDBG - COMM DEV BLOCK GRANT 0.00 0.00 0.00 24,753.30 24,753.30- 9999 ----------!!!! 46355 ANOKA CO HRA LEVY PROJECTS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,156.00 1,156.00- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 1,156.00 1,156.00- 9999 ----------!!!! TOTAL: ANOKA CO HRA LEVY PROJECTS 0.00 0.00 0.00 1,156.00 1,156.00- 9999 ----------!!!! TOTAL: ANOKA CO COMM DEV PROGRAMS 0.00 0.00 0.00 25,909.30 25,909.30- 9999 ----------!!!! 65 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 4 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 204 EDA ADMINISTRATION 46314 ECONOMIC DEVELOPMENT AUTH PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 732.88 5,297.37 5,297.37- 9999 ----------!!!! 1010 REGULAR EMPLOYEES 148,300.00 0.00 10,904.76 86,102.97 62,197.03 58 ----- 1210 P.E.R.A. CONTRIBUTION 11,100.00 0.00 817.86 6,647.27 4,452.73 59 ----- 1220 F.I.C.A. CONTRIBUTION 11,300.00 0.00 868.87 6,948.89 4,351.11 61 ------ 1300 INSURANCE 21,900.00 0.00 755.59 7,268.22 14,631.78 33 --- 1510 WORKERS COMP INSURANCE PREM 1,100.00 0.00 73.51 595.38 504.62 54 ----- TOTAL: PERSONAL SERVICES 193,700.00 0.00 14,153.47 112,860.10 80,839.90 58 ----- SUPPLIES 2000 OFFICE SUPPLIES 1,300.00 0.00 0.00 0.00 1,300.00 0 2011 COMPUTER EQUIPMENT 0.00 0.00 0.00 1,891.26 1,891.26- 9999 ----------!!!! 2020 COMPUTER SUPPLIES 215.00 0.00 0.00 0.00 215.00 0 2171 GENERAL SUPPLIES 105.00 0.00 0.00 0.00 105.00 0 2175 FOOD SUPPLIES 210.00 0.00 0.00 0.00 210.00 0 TOTAL: SUPPLIES 1,830.00 0.00 0.00 1,891.26 61.26- 103 ---------- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 6,980.00 0.00 46.00 2,481.00 4,499.00 35 --- 3105 TRAINING & EDUC ACTIVITIES 1,500.00 0.00 0.00 295.00 1,205.00 19 - 3210 TELEPHONE & TELEGRAPH 900.00 0.00 79.34 700.63 199.37 77 ------- 3220 POSTAGE 700.00 0.00 0.00 250.65 449.35 35 --- 3250 OTHER COMMUNICATIONS 250.00 0.00 19.15 190.53 59.47 76 ------- 3310 LOCAL TRAVEL EXPENSE 200.00 0.00 0.00 0.00 200.00 0 3500 LEGAL NOTICE PUBLISHING 315.00 0.00 0.00 286.88 28.12 91 --------- 3600 PROP & LIAB INSURANCE 3,600.00 0.00 300.00 3,000.00 600.00 83 -------- 4000 REPAIR & MAINT. SERVICES 0.00 0.00 20.45 429.95 429.95- 9999 ----------!!!! 4040 INFORMATION SYS:INTERNAL SVC 7,300.00 0.00 608.33 6,083.30 1,216.70 83 -------- 4330 SUBSCRIPTION, MEMBERSHIP 1,500.00 0.00 0.00 0.00 1,500.00 0 4380 COMMISSION & BOARDS 925.00 0.00 0.00 105.00 820.00 11 - TOTAL: OTHER SERVICES & CHARGES 24,170.00 0.00 1,073.27 13,822.94 10,347.06 57 ----- OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- TOTAL: ECONOMIC DEVELOPMENT AUTH 239,200.00 0.00 16,851.74 144,824.30 94,375.70 60 ------ TOTAL: EDA ADMINISTRATION 239,200.00 0.00 16,851.74 144,824.30 94,375.70 60 ------ 66 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 8 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 226 SPECIAL PROJECT REVENUE 52013 EAB TREE MANAGEMENT 1010 REGULAR EMPLOYEES 0.00 0.00 11,100.25 11,100.25 11,100.25- 9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 0.00 0.00 832.52 832.52 832.52- 9999 ----------!!!! 1220 F.I.C.A. CONTRIBUTION 0.00 0.00 820.42 820.42 820.42- 9999 ----------!!!! 1300 INSURANCE 0.00 0.00 1,998.41 1,998.41 1,998.41- 9999 ----------!!!! 1510 WORKERS COMP INSURANCE PREM 0.00 0.00 394.26 394.26 394.26- 9999 ----------!!!! 2010 MINOR EQUIPMENT 0.00 0.00 1,319.91 5,929.91 5,929.91- 9999 ----------!!!! 2160 MAINT. & CONSTRUCT MATERIALS 0.00 0.00 0.00 8,406.25 8,406.25- 9999 ----------!!!! 2171 GENERAL SUPPLIES 0.00 0.00 285.76 1,186.36 1,186.36- 9999 ----------!!!! 4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 57,965.31 57,965.31- 9999 ----------!!!! TOTAL: EAB TREE MANAGEMENT 0.00 0.00 16,751.53 88,633.69 88,633.69- 9999 ----------!!!! TOTAL: SPECIAL PROJECT REVENUE 0.00 0.00 16,751.53 88,633.69 88,633.69- 9999 ----------!!!! 67 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 9 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 228 DOWNTOWN PARKING 46317 DOWNTOWN PARKING PERSONAL SERVICES 1070 INTERDEPARTMENTAL LABOR SERV 0.00 0.00 0.00 136.02 136.02- 9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 0.00 0.00 0.00 10.19 10.19- 9999 ----------!!!! 1220 F.I.C.A. CONTRIBUTION 0.00 0.00 0.00 9.73 9.73- 9999 ----------!!!! 1300 INSURANCE 0.00 0.00 0.00 35.11 35.11- 9999 ----------!!!! 1510 WORKERS COMP INSURANCE PREM 0.00 0.00 0.00 11.08 11.08- 9999 ----------!!!! TOTAL: PERSONAL SERVICES 0.00 0.00 0.00 202.13 202.13- 9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 330.00 4,027.50 4,027.50- 9999 ----------!!!! 3600 PROP & LIAB INSURANCE 6,900.00 0.00 575.00 5,750.00 1,150.00 83 -------- 3810 ELECTRIC 0.00 0.00 814.69 5,767.39 5,767.39- 9999 ----------!!!! 3820 WATER 0.00 0.00 2.43 112.11 112.11- 9999 ----------!!!! 3850 SEWER 0.00 0.00 168.39 1,144.68 1,144.68- 9999 ----------!!!! 4000 REPAIR & MAINT. SERVICES 18,100.00 0.00 0.00 342.80 17,757.20 1 TOTAL: OTHER SERVICES & CHARGES 25,000.00 0.00 1,890.51 17,144.48 7,855.52 68 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,890.51 17,346.61 7,653.39 69 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,890.51 17,346.61 7,653.39 69 ------ 68 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 26 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 371 TIF T4: KMART/CENTRAL AVE 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 5,000.00 0.00 0.00 12,012.03 7,012.03- 240 ----------!!!! 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 0.00 227,885.37 227,885.37- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 5,000.00 0.00 0.00 239,897.40 234,897.40- 4797 ----------!!!! CAPITAL OUTLAY 6010 PRINCIPAL 75,000.00 0.00 0.00 0.00 75,000.00 0 6110 INTEREST 5,800.00 0.00 0.00 0.00 5,800.00 0 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 475.00 725.00 39 --- TOTAL: CAPITAL OUTLAY 82,000.00 0.00 0.00 475.00 81,525.00 0 OTHER FINANCING USES 7435 TRANSFER OUT TO: OTHER 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: OTHER FINANCING USES 0.00 0.00 0.00 37,655.00 37,655.00- 9999 ----------!!!! TOTAL: BONDS 87,000.00 0.00 0.00 278,027.40 191,027.40- 319 ----------!!!! TOTAL: TIF T4: KMART/CENTRAL AVE 87,000.00 0.00 0.00 278,027.40 191,027.40- 319 ----------!!!! 69 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 27 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 372 HUSET PARK AREA TIF (T6) 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 9,000.00 0.00 437.50 1,735.75 7,264.25 19 - 4600 LOANS & GRANTS 233,900.00 0.00 0.00 302,658.46 68,758.46- 129 ----------!! TOTAL: OTHER SERVICES & CHARGES 242,900.00 0.00 437.50 304,394.21 61,494.21- 125 ----------!! CAPITAL OUTLAY 6010 PRINCIPAL 130,000.00 0.00 0.00 130,000.00 0.00 100 ---------- 6110 INTEREST 62,000.00 0.00 0.00 61,957.50 42.50 99 --------- 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 0.00 1,200.00 0 TOTAL: CAPITAL OUTLAY 193,200.00 0.00 0.00 191,957.50 1,242.50 99 --------- TOTAL: BONDS 436,100.00 0.00 437.50 496,351.71 60,251.71- 113 ----------! TOTAL: HUSET PARK AREA TIF (T6) 436,100.00 0.00 437.50 496,351.71 60,251.71- 113 ----------! 70 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 29 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 376 TIF DISTRICTS A3/C7/C8 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,298.25 1,298.25- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 1,298.25 1,298.25- 9999 ----------!!!! TOTAL: BONDS 0.00 0.00 0.00 1,298.25 1,298.25- 9999 ----------!!!! TOTAL: TIF DISTRICTS A3/C7/C8 0.00 0.00 0.00 1,298.25 1,298.25- 9999 ----------!!!! 71 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 30 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 385 TIF K2 M.U.R.P. 47000 TAX INCREMENT BONDS OTHER SERVICES & CHARGES 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 0.00 249,578.00 249,578.00- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 1,794.00 1,794.00- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 251,372.00 251,372.00- 9999 ----------!!!! TOTAL: TAX INCREMENT BONDS 0.00 0.00 0.00 251,372.00 251,372.00- 9999 ----------!!!! TOTAL: TIF K2 M.U.R.P. 0.00 0.00 0.00 251,372.00 251,372.00- 9999 ----------!!!! 72 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 31 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 389 TIF R8 CRESTV/TRANSITION BLK 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,298.25 1,298.25- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 26,847.00 26,847.00- 9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 28,145.25 28,145.25- 9999 ----------!!!! TOTAL: BONDS 0.00 0.00 0.00 28,145.25 28,145.25- 9999 ----------!!!! TOTAL: TIF R8 CRESTV/TRANSITION BLK 0.00 0.00 0.00 28,145.25 28,145.25- 9999 ----------!!!! 73 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 33 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 408 EDA REDEVELOPMENT PROJECT FD 46314 ECONOMIC DEVELOPMENT AUTH 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78 7,082.78- 9999 ----------!!!! 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 3,282.00 3,630.00 3,630.00- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 5,040.00 5,040.00- 9999 ----------!!!! TOTAL: ECONOMIC DEVELOPMENT AUTH 0.00 0.00 3,282.00 15,752.78 15,752.78- 9999 ----------!!!! 46411 FACADE IMPROVEMENT GRANT 2010 MINOR EQUIPMENT 0.00 0.00 1,000.00 16,526.48 16,526.48- 9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 5,000.00 5,000.00- 9999 ----------!!!! TOTAL: FACADE IMPROVEMENT GRANT 0.00 0.00 1,000.00 21,526.48 21,526.48- 9999 ----------!!!! 46414 COMMERCIAL REVITALIZATION SUPPLIES 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! TOTAL: SUPPLIES 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 6,865.30 6,865.30- 9999 ----------!!!! 3810 ELECTRIC 0.00 0.00 382.50 2,136.43 2,136.43- 9999 ----------!!!! 3830 GAS 0.00 0.00 29.72 128.93 128.93- 9999 ----------!!!! 4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 514.00 514.00- 9999 ----------!!!! 4390 TAXES & LICENSES 0.00 0.00 2,289.73 2,289.73 2,289.73- 9999 ----------!!!! 4600 LOANS & GRANTS 50,000.00 0.00 0.00 950.00 49,050.00 1 TOTAL: OTHER SERVICES & CHARGES 50,000.00 0.00 2,701.95 12,884.39 37,115.61 25 -- CAPITAL OUTLAY 5110 LAND 200,000.00 0.00 4,871.66 133,882.09 66,117.91 66 ------ TOTAL: CAPITAL OUTLAY 200,000.00 0.00 4,871.66 133,882.09 66,117.91 66 ------ TOTAL: COMMERCIAL REVITALIZATION 250,000.00 0.00 7,573.61 139,683.70 110,316.30 55 ----- 46416 3989 CENTRAL AVE 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 2,135.00 79,900.11 79,900.11- 9999 ----------!!!! 3220 POSTAGE 0.00 0.00 6.95 6.95 6.95- 9999 ----------!!!! 3810 ELECTRIC 0.00 0.00 0.00 1,189.87 1,189.87- 9999 ----------!!!! 4020 BUILDING MAINT:CONTRACT SVCS 0.00 0.00 0.00 260.37 260.37- 9999 ----------!!!! 4390 TAXES & LICENSES 0.00 0.00 1,152.46 1,152.46 1,152.46- 9999 ----------!!!! 5110 LAND 0.00 0.00 32,833.93 87,380.62 87,380.62- 9999 ----------!!!! 5191 ASSETS FOR RESALE 0.00 0.00 0.00 18,830.48 18,830.48- 9999 ----------!!!! 6210 MISCELLANEOUS FISCAL CHARGES 0.00 0.00 814.00 814.00 814.00- 9999 ----------!!!! TOTAL: 3989 CENTRAL AVE 0.00 0.00 36,942.34 189,534.86 189,534.86- 9999 ----------!!!! 52011 DEMO 3989 CENT AVE & RAMP 2171 GENERAL SUPPLIES 0.00 0.00 0.00 206.25 206.25- 9999 ----------!!!! 3500 LEGAL NOTICE PUBLISHING 0.00 0.00 0.00 545.63 545.63- 9999 ----------!!!! TOTAL: DEMO 3989 CENT AVE & RAMP 0.00 0.00 0.00 751.88 751.88- 9999 ----------!!!! TOTAL: EDA REDEVELOPMENT PROJECT FD 250,000.00 0.00 48,797.95 367,249.70 117,249.70- 146 ----------!!!! 74 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:12:49 Expenditure Guideline GL520R-V08.14 PAGE 39 LEVEL OF DETAIL 1.0 THRU 3.0 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- 420 CAP IMPROVEMENT DEVELOPMENT 46407 3930 UNIVERSITY 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,906.25 1,906.25- 9999 ----------!!!! TOTAL: 3930 UNIVERSITY 0.00 0.00 0.00 1,906.25 1,906.25- 9999 ----------!!!! TOTAL: CAP IMPROVEMENT DEVELOPMENT 0.00 0.00 0.00 1,906.25 1,906.25- 9999 ----------!!!! 75 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 1 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 1,443.82 10,635.76 10,635.76-9999 ----------!!!!1000 ACCRUED SALARIES 0.00 0.00 1,443.82 10,635.76 10,635.76-9999 ----------!!!! X-100120-145 SALARY ACCRUAL SEPT.2020 904 9,191.94- SALARY ACCRUAL SEP-20 A X-103120-349 SALARY ACCURAL OCT 20 1004 10,635.76 SALARY ACCRUAL OCT 20 A 1010 REGULAR EMPLOYEES 269,300.00 0.00 20,137.64 201,703.16 67,596.84 74 -------1010 REGULAR EMPLOYEES 269,300.00 0.00 20,137.64 201,703.16 67,596.84 74 ------- P-100920-251 PAYROLL INTERFACE 100920 10,046.93 CODE-H,PER#-1,FUND- 201 A P-102320-252 PAYROLL INTERFACE 102320 10,090.71 CODE-H,PER#-2,FUND- 201 A 1011 PART-TIME EMPLOYEES 47,000.00 0.00 1,765.30 21,875.03 25,124.97 46 ----1011 PART-TIME EMPLOYEES 47,000.00 0.00 1,765.30 21,875.03 25,124.97 46 ---- P-100920-251 PAYROLL INTERFACE 100920 1,220.25 CODE-H,PER#-1,FUND- 201 A P-102320-252 PAYROLL INTERFACE 102320 545.05 CODE-H,PER#-2,FUND- 201 A 1020 OVERTIME-REGULAR 1,500.00 0.00 100.16 1,023.72 476.28 68 ------1020 OVERTIME-REGULAR 1,500.00 0.00 100.16 1,023.72 476.28 68 ------ P-100920-251 PAYROLL INTERFACE 100920 72.84 CODE-H,PER#-1,FUND- 201 A P-102320-252 PAYROLL INTERFACE 102320 27.32 CODE-H,PER#-2,FUND- 201 A 1050 SEVERANCE PAY 0.00 0.00 0.00 23,377.88 23,377.88-9999 ----------!!!!1050 SEVERANCE PAY 0.00 0.00 0.00 23,377.88 23,377.88-9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 23,000.00 0.00 1,517.85 16,659.63 6,340.37 72 -------1210 P.E.R.A. CONTRIBUTION 23,000.00 0.00 1,517.85 16,659.63 6,340.37 72 ------- P-100920-251 PAYROLL INTERFACE 100920 758.98 CODE-H,PER#-1,FUND- 201 A P-102320-252 PAYROLL INTERFACE 102320 758.87 CODE-H,PER#-2,FUND- 201 A 1220 F.I.C.A. CONTRIBUTION 24,300.00 0.00 1,697.44 18,099.35 6,200.65 74 -------1220 F.I.C.A. CONTRIBUTION 24,300.00 0.00 1,697.44 18,099.35 6,200.65 74 ------- P-100920-251 PAYROLL INTERFACE 100920 874.28 CODE-H,PER#-1,FUND- 201 A P-102320-252 PAYROLL INTERFACE 102320 823.16 CODE-H,PER#-2,FUND- 201 A 1225 FLEX BENEFIT FICA 0.00 0.00 25.83 258.30 258.30-9999 ----------!!!!1225 FLEX BENEFIT FICA 0.00 0.00 25.83 258.30 258.30-9999 ----------!!!! J-103120-285 20 FLEX PLAN ADMIN EXP 123 25.83 ESTIMATED COST A 1300 INSURANCE 42,000.00 0.00 3,252.67 34,862.85 7,137.15 83 --------1300 INSURANCE 42,000.00 0.00 3,252.67 34,862.85 7,137.15 83 -------- P-100920-251 PAYROLL INTERFACE 100920 1,619.58 CODE-H,PER#-1,FUND- 201 A P-102320-252 PAYROLL INTERFACE 102320 1,633.09 CODE-H,PER#-2,FUND- 201 A 1510 WORKERS COMP INSURANCE PREM 2,200.00 0.00 141.91 1,504.42 695.58 68 ------1510 WORKERS COMP INSURANCE PREM 2,200.00 0.00 141.91 1,504.42 695.58 68 ------ P-100920-251 PAYROLL INTERFACE 100920 73.12 CODE-H,PER#-1,FUND- 201 A P-102320-252 PAYROLL INTERFACE 102320 68.79 CODE-H,PER#-2,FUND- 201 A TOTAL: PERSONAL SERVICES 409,300.00 0.00 30,082.62 330,000.10 79,299.90 80 -------- SUPPLIES 2000 OFFICE SUPPLIES 1,400.00 0.00 0.00 553.07 846.93 39 ---2000 OFFICE SUPPLIES 1,400.00 0.00 0.00 553.07 846.93 39 --- 76 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 2 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS SUPPLIES 2020 COMPUTER SUPPLIES 100.00 0.00 0.00 0.00 100.00 02020 COMPUTER SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2030 PRINTING & PRINTED FORMS 150.00 0.00 578.09 612.01 462.01- 408 ----------!!!!2030 PRINTING & PRINTED FORMS 150.00 0.00 578.09 612.01 462.01- 408 ----------!!!! D-102920-259 013490 RAPIT PRINTING - NEW BRI 182665 223443 271.93 RECEIPT FORMS N A D-102920-259 013490 RAPIT PRINTING - NEW BRI 182665 223444 306.16 INSPECTION RECORD FORM N A 2171 GENERAL SUPPLIES 100.00 0.00 79.98 90.97 9.03 90 ---------2171 GENERAL SUPPLIES 100.00 0.00 79.98 90.97 9.03 90 --------- M-100820-200 003660 AMAZON.COM 182379 2320237 79.98 NISPIRIA HEPA FILTERS N A 2175 FOOD SUPPLIES 100.00 0.00 0.00 0.00 100.00 02175 FOOD SUPPLIES 100.00 0.00 0.00 0.00 100.00 0 2280 VEHICLE REPAIR AND PARTS 600.00 0.00 13.78 110.25 489.75 18 -2280 VEHICLE REPAIR AND PARTS 600.00 0.00 13.78 110.25 489.75 18 - J-103120-352 2020 GARAGE ALLOCATION 1006 13.78 PLAN/INSPECT PARTS A 2282 GAS, OIL, LUBRICANTS 500.00 0.00 28.48 385.53 114.47 77 -------2282 GAS, OIL, LUBRICANTS 500.00 0.00 28.48 385.53 114.47 77 ------- J-103120-348 OCT 20 FUEL ALLOCATION 1005 28.48 PLANNING & INSPECTION A TOTAL: SUPPLIES 2,950.00 0.00 700.33 1,751.83 1,198.17 59 ----- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 2,400.00 0.00 0.00 22,481.00 20,081.00- 936 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 2,400.00 0.00 0.00 22,481.00 20,081.00- 936 ----------!!!! 3105 TRAINING & EDUC ACTIVITIES 2,000.00 0.00 0.00 0.00 2,000.00 03105 TRAINING & EDUC ACTIVITIES 2,000.00 0.00 0.00 0.00 2,000.00 0 3210 TELEPHONE & TELEGRAPH 900.00 0.00 0.00 159.75 740.25 17 -3210 TELEPHONE & TELEGRAPH 900.00 0.00 0.00 159.75 740.25 17 - 3211 CELL PHONES 960.00 0.00 0.00 395.49 564.51 41 ----3211 CELL PHONES 960.00 0.00 0.00 395.49 564.51 41 ---- 3220 POSTAGE 1,000.00 0.00 0.00 907.45 92.55 90 ---------3220 POSTAGE 1,000.00 0.00 0.00 907.45 92.55 90 --------- 3250 OTHER COMMUNICATIONS 200.00 0.00 14.36 147.42 52.58 73 -------3250 OTHER COMMUNICATIONS 200.00 0.00 14.36 147.42 52.58 73 ------- D-100120-138 000298 COMCAST 182202 091020 14.36 091020 8772105050224795 002324 F N A 3310 LOCAL TRAVEL EXPENSE 500.00 0.00 0.00 0.00 500.00 03310 LOCAL TRAVEL EXPENSE 500.00 0.00 0.00 0.00 500.00 0 3500 LEGAL NOTICE PUBLISHING 750.00 0.00 0.00 1,085.64 335.64- 144 ----------!!!!3500 LEGAL NOTICE PUBLISHING 750.00 0.00 0.00 1,085.64 335.64- 144 ----------!!!! 3600 PROP & LIAB INSURANCE 3,200.00 0.00 266.67 2,666.70 533.30 83 --------3600 PROP & LIAB INSURANCE 3,200.00 0.00 266.67 2,666.70 533.30 83 -------- J-103120-290 20 PROP & LIAB INS ALLOC 130 266.67 20 PROP & LIAB INS ALLOC A 4000 REPAIR & MAINT. SERVICES 825.00 0.00 20.45 314.45 510.55 38 ---4000 REPAIR & MAINT. SERVICES 825.00 0.00 20.45 314.45 510.55 38 --- J-103120-322 OCT 2020 COPIER ALLOCATI 1037 20.45 OCT 20 COPIER CHARGE A 4040 INFORMATION SYS:INTERNAL SVC 9,700.00 0.00 808.33 8,083.30 1,616.70 83 --------4040 INFORMATION SYS:INTERNAL SVC 9,700.00 0.00 808.33 8,083.30 1,616.70 83 -------- J-103120-291 20 IS ALLOC 131 808.33 20 IS ALLOC A 4050 GARAGE, LABOR BURD. 500.00 0.00 118.13 685.59 185.59- 137 ----------!!!4050 GARAGE, LABOR BURD. 500.00 0.00 118.13 685.59 185.59- 137 ----------!!! J-103120-352 2020 GARAGE ALLOCATION 1006 118.13 PLAN/INSPECT LABOR A 77 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 3 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 201 PLANNING & INSPECTIONS 42400 PLANNING & INSPECTIONS OTHER SERVICES & CHARGES 4310 CREDIT CARD FEES 1,030.00 0.00 338.69 1,220.11 190.11- 118 ----------!4310 CREDIT CARD FEES 1,030.00 0.00 338.69 1,220.11 190.11- 118 ----------! J-103120-305 CC FEE ALLOCATION 10/20 1033 338.69 CC FEE 10/20 A 4330 SUBSCRIPTION, MEMBERSHIP 1,250.00 0.00 0.00 1,101.00 149.00 88 --------4330 SUBSCRIPTION, MEMBERSHIP 1,250.00 0.00 0.00 1,101.00 149.00 88 -------- 4380 COMMISSION & BOARDS 720.00 0.00 0.00 8.65 711.35 14380 COMMISSION & BOARDS 720.00 0.00 0.00 8.65 711.35 1 4390 TAXES & LICENSES 0.00 0.00 0.00 2,704.25 2,704.25-9999 ----------!!!!4390 TAXES & LICENSES 0.00 0.00 0.00 2,704.25 2,704.25-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 25,935.00 0.00 1,566.63 41,960.80 16,025.80- 161 ----------!!!! OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 --------7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- J-103120-286 20 TRANSFER:ADMIN LABOR 125 1,625.00 20 BUDGETED TRANSFER A TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 33,974.58 389,962.73 67,722.27 85 -------- TOTAL: PLANNING & INSPECTIONS 457,685.00 0.00 33,974.58 389,962.73 67,722.27 85 -------- 78 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 4 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 202 ANOKA CO COMM DEV PROGRAMS 46350 CDBG - COMM DEV BLOCK GRANT OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!! TOTAL: CDBG - COMM DEV BLOCK GRANT 0.00 0.00 0.00 24,753.30 24,753.30-9999 ----------!!!! 46355 ANOKA CO HRA LEVY PROJECTS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!! TOTAL: ANOKA CO HRA LEVY PROJECTS 0.00 0.00 0.00 1,156.00 1,156.00-9999 ----------!!!! TOTAL: ANOKA CO COMM DEV PROGRAMS 0.00 0.00 0.00 25,909.30 25,909.30-9999 ----------!!!! 79 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 5 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 204 EDA ADMINISTRATION 46314 ECONOMIC DEVELOPMENT AUTH PERSONAL SERVICES 1000 ACCRUED SALARIES 0.00 0.00 732.88 5,297.37 5,297.37-9999 ----------!!!!1000 ACCRUED SALARIES 0.00 0.00 732.88 5,297.37 5,297.37-9999 ----------!!!! X-100120-145 SALARY ACCRUAL SEPT.2020 904 4,564.49- SALARY ACCRUAL SEP-20 A X-103120-349 SALARY ACCURAL OCT 20 1004 5,297.37 SALARY ACCRUAL OCT 20 A 1010 REGULAR EMPLOYEES 148,300.00 0.00 10,904.76 86,102.97 62,197.03 58 -----1010 REGULAR EMPLOYEES 148,300.00 0.00 10,904.76 86,102.97 62,197.03 58 ----- P-100920-251 PAYROLL INTERFACE 100920 5,607.39 CODE-H,PER#-1,FUND- 204 A P-102320-252 PAYROLL INTERFACE 102320 5,297.37 CODE-H,PER#-2,FUND- 204 A 1210 P.E.R.A. CONTRIBUTION 11,100.00 0.00 817.86 6,647.27 4,452.73 59 -----1210 P.E.R.A. CONTRIBUTION 11,100.00 0.00 817.86 6,647.27 4,452.73 59 ----- P-100920-251 PAYROLL INTERFACE 100920 420.56 CODE-H,PER#-1,FUND- 204 A P-102320-252 PAYROLL INTERFACE 102320 397.30 CODE-H,PER#-2,FUND- 204 A 1220 F.I.C.A. CONTRIBUTION 11,300.00 0.00 868.87 6,948.89 4,351.11 61 ------1220 F.I.C.A. CONTRIBUTION 11,300.00 0.00 868.87 6,948.89 4,351.11 61 ------ P-100920-251 PAYROLL INTERFACE 100920 446.05 CODE-H,PER#-1,FUND- 204 A P-102320-252 PAYROLL INTERFACE 102320 422.82 CODE-H,PER#-2,FUND- 204 A 1300 INSURANCE 21,900.00 0.00 755.59 7,268.22 14,631.78 33 ---1300 INSURANCE 21,900.00 0.00 755.59 7,268.22 14,631.78 33 --- P-100920-251 PAYROLL INTERFACE 100920 362.10 CODE-H,PER#-1,FUND- 204 A P-102320-252 PAYROLL INTERFACE 102320 393.49 CODE-H,PER#-2,FUND- 204 A 1510 WORKERS COMP INSURANCE PREM 1,100.00 0.00 73.51 595.38 504.62 54 -----1510 WORKERS COMP INSURANCE PREM 1,100.00 0.00 73.51 595.38 504.62 54 ----- P-100920-251 PAYROLL INTERFACE 100920 37.75 CODE-H,PER#-1,FUND- 204 A P-102320-252 PAYROLL INTERFACE 102320 35.76 CODE-H,PER#-2,FUND- 204 A TOTAL: PERSONAL SERVICES 193,700.00 0.00 14,153.47 112,860.10 80,839.90 58 ----- SUPPLIES 2000 OFFICE SUPPLIES 1,300.00 0.00 0.00 0.00 1,300.00 02000 OFFICE SUPPLIES 1,300.00 0.00 0.00 0.00 1,300.00 0 2011 COMPUTER EQUIPMENT 0.00 0.00 0.00 1,891.26 1,891.26-9999 ----------!!!!2011 COMPUTER EQUIPMENT 0.00 0.00 0.00 1,891.26 1,891.26-9999 ----------!!!! 2020 COMPUTER SUPPLIES 215.00 0.00 0.00 0.00 215.00 02020 COMPUTER SUPPLIES 215.00 0.00 0.00 0.00 215.00 0 2171 GENERAL SUPPLIES 105.00 0.00 0.00 0.00 105.00 02171 GENERAL SUPPLIES 105.00 0.00 0.00 0.00 105.00 0 2175 FOOD SUPPLIES 210.00 0.00 0.00 0.00 210.00 02175 FOOD SUPPLIES 210.00 0.00 0.00 0.00 210.00 0 TOTAL: SUPPLIES 1,830.00 0.00 0.00 1,891.26 61.26- 103 ---------- OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 6,980.00 0.00 46.00 2,481.00 4,499.00 35 ---3050 EXPERT & PROFESSIONAL SERV. 6,980.00 0.00 46.00 2,481.00 4,499.00 35 --- D-100120-138 005385 ANOKA COUNTY PROPERTY RE 182187 20-1795 46.00 REV RECORDING FEE N A 3105 TRAINING & EDUC ACTIVITIES 1,500.00 0.00 0.00 295.00 1,205.00 19 -3105 TRAINING & EDUC ACTIVITIES 1,500.00 0.00 0.00 295.00 1,205.00 19 - 80 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 6 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 204 EDA ADMINISTRATION 46314 ECONOMIC DEVELOPMENT AUTH OTHER SERVICES & CHARGES 3210 TELEPHONE & TELEGRAPH 900.00 0.00 79.34 700.63 199.37 77 -------3210 TELEPHONE & TELEGRAPH 900.00 0.00 79.34 700.63 199.37 77 ------- D-102220-241 022200 POPP.COM INC 182562 992638701 79.34 093020-10010429 201325 F N A 3220 POSTAGE 700.00 0.00 0.00 250.65 449.35 35 ---3220 POSTAGE 700.00 0.00 0.00 250.65 449.35 35 --- 3250 OTHER COMMUNICATIONS 250.00 0.00 19.15 190.53 59.47 76 -------3250 OTHER COMMUNICATIONS 250.00 0.00 19.15 190.53 59.47 76 ------- D-100120-138 000298 COMCAST 182202 091020 19.15 091020 8772105050224795 002324 F N A 3310 LOCAL TRAVEL EXPENSE 200.00 0.00 0.00 0.00 200.00 03310 LOCAL TRAVEL EXPENSE 200.00 0.00 0.00 0.00 200.00 0 3500 LEGAL NOTICE PUBLISHING 315.00 0.00 0.00 286.88 28.12 91 ---------3500 LEGAL NOTICE PUBLISHING 315.00 0.00 0.00 286.88 28.12 91 --------- 3600 PROP & LIAB INSURANCE 3,600.00 0.00 300.00 3,000.00 600.00 83 --------3600 PROP & LIAB INSURANCE 3,600.00 0.00 300.00 3,000.00 600.00 83 -------- J-103120-290 20 PROP & LIAB INS ALLOC 130 300.00 20 PROP & LIAB INS ALLOC A 4000 REPAIR & MAINT. SERVICES 0.00 0.00 20.45 429.95 429.95-9999 ----------!!!!4000 REPAIR & MAINT. SERVICES 0.00 0.00 20.45 429.95 429.95-9999 ----------!!!! J-103120-322 OCT 2020 COPIER ALLOCATI 1037 20.45 OCT 20 COPIER CHARGE A 4040 INFORMATION SYS:INTERNAL SVC 7,300.00 0.00 608.33 6,083.30 1,216.70 83 --------4040 INFORMATION SYS:INTERNAL SVC 7,300.00 0.00 608.33 6,083.30 1,216.70 83 -------- J-103120-291 20 IS ALLOC 131 608.33 20 IS ALLOC A 4330 SUBSCRIPTION, MEMBERSHIP 1,500.00 0.00 0.00 0.00 1,500.00 04330 SUBSCRIPTION, MEMBERSHIP 1,500.00 0.00 0.00 0.00 1,500.00 0 4380 COMMISSION & BOARDS 925.00 0.00 0.00 105.00 820.00 11 -4380 COMMISSION & BOARDS 925.00 0.00 0.00 105.00 820.00 11 - TOTAL: OTHER SERVICES & CHARGES 24,170.00 0.00 1,073.27 13,822.94 10,347.06 57 ----- OTHER FINANCING USES 7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 --------7100 OPER. TRANSFER OUT - LABOR 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- J-103120-286 20 TRANSFER:ADMIN LABOR 125 1,625.00 20 BUDGETED TRANSFER A TOTAL: OTHER FINANCING USES 19,500.00 0.00 1,625.00 16,250.00 3,250.00 83 -------- TOTAL: ECONOMIC DEVELOPMENT AUTH 239,200.00 0.00 16,851.74 144,824.30 94,375.70 60 ------ TOTAL: EDA ADMINISTRATION 239,200.00 0.00 16,851.74 144,824.30 94,375.70 60 ------ 81 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 12 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 226 SPECIAL PROJECT REVENUE 52013 EAB TREE MANAGEMENT 1010 REGULAR EMPLOYEES 0.00 0.00 11,100.25 11,100.25 11,100.25-9999 ----------!!!!1010 REGULAR EMPLOYEES 0.00 0.00 11,100.25 11,100.25 11,100.25-9999 ----------!!!! P-100920-251 PAYROLL INTERFACE 100920 4,361.42 CODE-H,PER#-1,FUND- 226 A P-102320-252 PAYROLL INTERFACE 102320 6,738.83 CODE-H,PER#-2,FUND- 226 A 1210 P.E.R.A. CONTRIBUTION 0.00 0.00 832.52 832.52 832.52-9999 ----------!!!!1210 P.E.R.A. CONTRIBUTION 0.00 0.00 832.52 832.52 832.52-9999 ----------!!!! P-100920-251 PAYROLL INTERFACE 100920 327.10 CODE-H,PER#-1,FUND- 226 A P-102320-252 PAYROLL INTERFACE 102320 505.42 CODE-H,PER#-2,FUND- 226 A 1220 F.I.C.A. CONTRIBUTION 0.00 0.00 820.42 820.42 820.42-9999 ----------!!!!1220 F.I.C.A. CONTRIBUTION 0.00 0.00 820.42 820.42 820.42-9999 ----------!!!! P-100920-251 PAYROLL INTERFACE 100920 323.45 CODE-H,PER#-1,FUND- 226 A P-102320-252 PAYROLL INTERFACE 102320 496.97 CODE-H,PER#-2,FUND- 226 A 1300 INSURANCE 0.00 0.00 1,998.41 1,998.41 1,998.41-9999 ----------!!!!1300 INSURANCE 0.00 0.00 1,998.41 1,998.41 1,998.41-9999 ----------!!!! P-100920-251 PAYROLL INTERFACE 100920 832.37 CODE-H,PER#-1,FUND- 226 A P-102320-252 PAYROLL INTERFACE 102320 1,166.04 CODE-H,PER#-2,FUND- 226 A 1510 WORKERS COMP INSURANCE PREM 0.00 0.00 394.26 394.26 394.26-9999 ----------!!!!1510 WORKERS COMP INSURANCE PREM 0.00 0.00 394.26 394.26 394.26-9999 ----------!!!! P-100920-251 PAYROLL INTERFACE 100920 137.99 CODE-H,PER#-1,FUND- 226 A P-102320-252 PAYROLL INTERFACE 102320 256.27 CODE-H,PER#-2,FUND- 226 A 2010 MINOR EQUIPMENT 0.00 0.00 1,319.91 5,929.91 5,929.91-9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 1,319.91 5,929.91 5,929.91-9999 ----------!!!! D-101520-186 028550 LANO EQUIPMENT 182432 02-784862 1,319.91 AUGER BIT N A 2160 MAINT. & CONSTRUCT MATERIALS 0.00 0.00 0.00 8,406.25 8,406.25-9999 ----------!!!!2160 MAINT. & CONSTRUCT MATERIALS 0.00 0.00 0.00 8,406.25 8,406.25-9999 ----------!!!! 2171 GENERAL SUPPLIES 0.00 0.00 285.76 1,186.36 1,186.36-9999 ----------!!!!2171 GENERAL SUPPLIES 0.00 0.00 285.76 1,186.36 1,186.36-9999 ----------!!!! M-100820-200 009495 HOME DEPOT #2802 182379 WG15847510 376.00 STEEL FENCE T-POST 083120 P N A M-100820-200 009495 HOME DEPOT #2802 182379 WG15847510 90.24- RTN STEEL FENCE T-POST 083120 P N A 4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 57,965.31 57,965.31-9999 ----------!!!!4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 57,965.31 57,965.31-9999 ----------!!!! TOTAL: EAB TREE MANAGEMENT 0.00 0.00 16,751.53 88,633.69 88,633.69-9999 ----------!!!! TOTAL: SPECIAL PROJECT REVENUE 0.00 0.00 16,751.53 88,633.69 88,633.69-9999 ----------!!!! 82 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 13 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 228 DOWNTOWN PARKING 46317 DOWNTOWN PARKING PERSONAL SERVICES 1070 INTERDEPARTMENTAL LABOR SERV 0.00 0.00 0.00 136.02 136.02-9999 ----------!!!!1070 INTERDEPARTMENTAL LABOR SERV 0.00 0.00 0.00 136.02 136.02-9999 ----------!!!! 1210 P.E.R.A. CONTRIBUTION 0.00 0.00 0.00 10.19 10.19-9999 ----------!!!!1210 P.E.R.A. CONTRIBUTION 0.00 0.00 0.00 10.19 10.19-9999 ----------!!!! 1220 F.I.C.A. CONTRIBUTION 0.00 0.00 0.00 9.73 9.73-9999 ----------!!!!1220 F.I.C.A. CONTRIBUTION 0.00 0.00 0.00 9.73 9.73-9999 ----------!!!! 1300 INSURANCE 0.00 0.00 0.00 35.11 35.11-9999 ----------!!!!1300 INSURANCE 0.00 0.00 0.00 35.11 35.11-9999 ----------!!!! 1510 WORKERS COMP INSURANCE PREM 0.00 0.00 0.00 11.08 11.08-9999 ----------!!!!1510 WORKERS COMP INSURANCE PREM 0.00 0.00 0.00 11.08 11.08-9999 ----------!!!! TOTAL: PERSONAL SERVICES 0.00 0.00 0.00 202.13 202.13-9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 330.00 4,027.50 4,027.50-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 330.00 4,027.50 4,027.50-9999 ----------!!!! D-100120-139 099428 HIGH PROFILE GROUNDS MAI 182211 55632 330.00 VANBUREN RAMP CLEANOUT N A 3600 PROP & LIAB INSURANCE 6,900.00 0.00 575.00 5,750.00 1,150.00 83 --------3600 PROP & LIAB INSURANCE 6,900.00 0.00 575.00 5,750.00 1,150.00 83 -------- J-103120-290 20 PROP & LIAB INS ALLOC 130 575.00 20 PROP & LIAB INS ALLOC A 3810 ELECTRIC 0.00 0.00 814.69 5,767.39 5,767.39-9999 ----------!!!!3810 ELECTRIC 0.00 0.00 814.69 5,767.39 5,767.39-9999 ----------!!!! D-102220-241 005695 XCEL ENERGY (N S P) 182583 0865059485 814.69 100720 51-0013059132-8 N A 3820 WATER 0.00 0.00 2.43 112.11 112.11-9999 ----------!!!!3820 WATER 0.00 0.00 2.43 112.11 112.11-9999 ----------!!!! J-103120-180 CITY UB BILLS-SECTION 3 1001 2.43 UTILITIES-JULY,AUG,SEPT A 3850 SEWER 0.00 0.00 168.39 1,144.68 1,144.68-9999 ----------!!!!3850 SEWER 0.00 0.00 168.39 1,144.68 1,144.68-9999 ----------!!!! J-103120-180 CITY UB BILLS-SECTION 3 1001 168.39 UTILITIES-JULY,AUG,SEPT A 4000 REPAIR & MAINT. SERVICES 18,100.00 0.00 0.00 342.80 17,757.20 14000 REPAIR & MAINT. SERVICES 18,100.00 0.00 0.00 342.80 17,757.20 1 TOTAL: OTHER SERVICES & CHARGES 25,000.00 0.00 1,890.51 17,144.48 7,855.52 68 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,890.51 17,346.61 7,653.39 69 ------ TOTAL: DOWNTOWN PARKING 25,000.00 0.00 1,890.51 17,346.61 7,653.39 69 ------ 83 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 39 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 371 TIF T4: KMART/CENTRAL AVE 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 5,000.00 0.00 0.00 12,012.03 7,012.03- 240 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 5,000.00 0.00 0.00 12,012.03 7,012.03- 240 ----------!!!! 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 0.00 227,885.37 227,885.37-9999 ----------!!!!4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 0.00 227,885.37 227,885.37-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 5,000.00 0.00 0.00 239,897.40 234,897.40-4797 ----------!!!! CAPITAL OUTLAY 6010 PRINCIPAL 75,000.00 0.00 0.00 0.00 75,000.00 06010 PRINCIPAL 75,000.00 0.00 0.00 0.00 75,000.00 0 6110 INTEREST 5,800.00 0.00 0.00 0.00 5,800.00 06110 INTEREST 5,800.00 0.00 0.00 0.00 5,800.00 0 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 475.00 725.00 39 ---6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 475.00 725.00 39 --- TOTAL: CAPITAL OUTLAY 82,000.00 0.00 0.00 475.00 81,525.00 0 OTHER FINANCING USES 7435 TRANSFER OUT TO: OTHER 0.00 0.00 0.00 37,655.00 37,655.00-9999 ----------!!!!7435 TRANSFER OUT TO: OTHER 0.00 0.00 0.00 37,655.00 37,655.00-9999 ----------!!!! TOTAL: OTHER FINANCING USES 0.00 0.00 0.00 37,655.00 37,655.00-9999 ----------!!!! TOTAL: BONDS 87,000.00 0.00 0.00 278,027.40 191,027.40- 319 ----------!!!! TOTAL: TIF T4: KMART/CENTRAL AVE 87,000.00 0.00 0.00 278,027.40 191,027.40- 319 ----------!!!! 84 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 40 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 372 HUSET PARK AREA TIF (T6) 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 9,000.00 0.00 437.50 1,735.75 7,264.25 19 -3050 EXPERT & PROFESSIONAL SERV. 9,000.00 0.00 437.50 1,735.75 7,264.25 19 - D-101520-181 005825 EHLERS & ASSOCIATES INC 182410 84524 437.50 ANNUAL TIF REPORTING 001560 P M A 4600 LOANS & GRANTS 233,900.00 0.00 0.00 302,658.46 68,758.46- 129 ----------!!4600 LOANS & GRANTS 233,900.00 0.00 0.00 302,658.46 68,758.46- 129 ----------!! TOTAL: OTHER SERVICES & CHARGES 242,900.00 0.00 437.50 304,394.21 61,494.21- 125 ----------!! CAPITAL OUTLAY 6010 PRINCIPAL 130,000.00 0.00 0.00 130,000.00 0.00 100 ----------6010 PRINCIPAL 130,000.00 0.00 0.00 130,000.00 0.00 100 ---------- 6110 INTEREST 62,000.00 0.00 0.00 61,957.50 42.50 99 ---------6110 INTEREST 62,000.00 0.00 0.00 61,957.50 42.50 99 --------- 6200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 0.00 1,200.00 06200 FISCAL AGENT CHARGES 1,200.00 0.00 0.00 0.00 1,200.00 0 TOTAL: CAPITAL OUTLAY 193,200.00 0.00 0.00 191,957.50 1,242.50 99 --------- TOTAL: BONDS 436,100.00 0.00 437.50 496,351.71 60,251.71- 113 ----------! TOTAL: HUSET PARK AREA TIF (T6) 436,100.00 0.00 437.50 496,351.71 60,251.71- 113 ----------! 85 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 42 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 376 TIF DISTRICTS A3/C7/C8 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,298.25 1,298.25-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,298.25 1,298.25-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 1,298.25 1,298.25-9999 ----------!!!! TOTAL: BONDS 0.00 0.00 0.00 1,298.25 1,298.25-9999 ----------!!!! TOTAL: TIF DISTRICTS A3/C7/C8 0.00 0.00 0.00 1,298.25 1,298.25-9999 ----------!!!! 86 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 43 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 385 TIF K2 M.U.R.P. 47000 TAX INCREMENT BONDS OTHER SERVICES & CHARGES 4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 0.00 249,578.00 249,578.00-9999 ----------!!!!4344 SETTLEMENTS AND JUDGMENTS 0.00 0.00 0.00 249,578.00 249,578.00-9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 1,794.00 1,794.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 1,794.00 1,794.00-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 251,372.00 251,372.00-9999 ----------!!!! TOTAL: TAX INCREMENT BONDS 0.00 0.00 0.00 251,372.00 251,372.00-9999 ----------!!!! TOTAL: TIF K2 M.U.R.P. 0.00 0.00 0.00 251,372.00 251,372.00-9999 ----------!!!! 87 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 44 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 389 TIF R8 CRESTV/TRANSITION BLK 47000 BONDS OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,298.25 1,298.25-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,298.25 1,298.25-9999 ----------!!!! 4600 LOANS & GRANTS 0.00 0.00 0.00 26,847.00 26,847.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 26,847.00 26,847.00-9999 ----------!!!! TOTAL: OTHER SERVICES & CHARGES 0.00 0.00 0.00 28,145.25 28,145.25-9999 ----------!!!! TOTAL: BONDS 0.00 0.00 0.00 28,145.25 28,145.25-9999 ----------!!!! TOTAL: TIF R8 CRESTV/TRANSITION BLK 0.00 0.00 0.00 28,145.25 28,145.25-9999 ----------!!!! 88 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 46 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 408 EDA REDEVELOPMENT PROJECT FD 46314 ECONOMIC DEVELOPMENT AUTH 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78 7,082.78-9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78 7,082.78-9999 ----------!!!! 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 3,282.00 3,630.00 3,630.00-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 3,282.00 3,630.00 3,630.00-9999 ----------!!!! D-100820-152 008380 ANGSTROM ANALYTICAL INC 182258 4158 650.00 ASBESTOS DEMO SURVEY N A D-102920-263 027530 ROBINSON ENVIRONMENTAL I 182670 12971 2,632.00 4441 CNTRL ASBESTOS RMVL 101920 P N A 4600 LOANS & GRANTS 0.00 0.00 0.00 5,040.00 5,040.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 5,040.00 5,040.00-9999 ----------!!!! TOTAL: ECONOMIC DEVELOPMENT AUTH 0.00 0.00 3,282.00 15,752.78 15,752.78-9999 ----------!!!! 46411 FACADE IMPROVEMENT GRANT 2010 MINOR EQUIPMENT 0.00 0.00 1,000.00 16,526.48 16,526.48-9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 1,000.00 16,526.48 16,526.48-9999 ----------!!!! D-101520-181 028005 PRO-TEC DESIGN INC 182456 96785 1,000.00 FACADE GRANT CAMERAS 201929 P N A 4600 LOANS & GRANTS 0.00 0.00 0.00 5,000.00 5,000.00-9999 ----------!!!!4600 LOANS & GRANTS 0.00 0.00 0.00 5,000.00 5,000.00-9999 ----------!!!! TOTAL: FACADE IMPROVEMENT GRANT 0.00 0.00 1,000.00 21,526.48 21,526.48-9999 ----------!!!! 46414 COMMERCIAL REVITALIZATION SUPPLIES 2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!!2010 MINOR EQUIPMENT 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! TOTAL: SUPPLIES 0.00 0.00 0.00 7,082.78- 7,082.78 9999 ----------!!!! OTHER SERVICES & CHARGES 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 6,865.30 6,865.30-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 6,865.30 6,865.30-9999 ----------!!!! 3810 ELECTRIC 0.00 0.00 382.50 2,136.43 2,136.43-9999 ----------!!!!3810 ELECTRIC 0.00 0.00 382.50 2,136.43 2,136.43-9999 ----------!!!! D-102220-241 005695 XCEL ENERGY (N S P) 182583 0865062191 400.82 100720 51-0012875093-9 N A D-102220-241 005695 XCEL ENERGY (N S P) 182583 0864677049 10.69 100620 51-0012963900-4 N A D-102220-241 005695 XCEL ENERGY (N S P) 182583 0864837214 13.49 100620 51-0012469064-3 N A R-102920-282 XCEL ENERGY 174606 42.50- REFUND XCEL ACCOUNT A 3830 GAS 0.00 0.00 29.72 128.93 128.93-9999 ----------!!!!3830 GAS 0.00 0.00 29.72 128.93 128.93-9999 ----------!!!! D-102220-241 004945 CENTER POINT ENERGY 182507 11173439-8 10.80 100820 11173439-8 N A D-102220-241 004945 CENTER POINT ENERGY 182507 6401438486-7 18.92 100820 6401438486-7 N A 4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 514.00 514.00-9999 ----------!!!!4000 REPAIR & MAINT. SERVICES 0.00 0.00 0.00 514.00 514.00-9999 ----------!!!! 4390 TAXES & LICENSES 0.00 0.00 2,289.73 2,289.73 2,289.73-9999 ----------!!!!4390 TAXES & LICENSES 0.00 0.00 2,289.73 2,289.73 2,289.73-9999 ----------!!!! D-100820-156 005385 ANOKA COUNTY PROPERTY RE 182260 353024320104 2,289.73 230 40TH AVE 1ST HALF 093020 P N A 4600 LOANS & GRANTS 50,000.00 0.00 0.00 950.00 49,050.00 14600 LOANS & GRANTS 50,000.00 0.00 0.00 950.00 49,050.00 1 TOTAL: OTHER SERVICES & CHARGES 50,000.00 0.00 2,701.95 12,884.39 37,115.61 25 -- CAPITAL OUTLAY 89 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 47 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 408 EDA REDEVELOPMENT PROJECT FD 46414 COMMERCIAL REVITALIZATION CAPITAL OUTLAY 5110 LAND 200,000.00 0.00 4,871.66 133,882.09 66,117.91 66 ------5110 LAND 200,000.00 0.00 4,871.66 133,882.09 66,117.91 66 ------ J-101920-268 PAY ASSMT ON CITY-OWNED 1028 4,871.66 4441 CENTRAL AVE A TOTAL: CAPITAL OUTLAY 200,000.00 0.00 4,871.66 133,882.09 66,117.91 66 ------ TOTAL: COMMERCIAL REVITALIZATION 250,000.00 0.00 7,573.61 139,683.70 110,316.30 55 ----- 46416 3989 CENTRAL AVE 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 2,135.00 79,900.11 79,900.11-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 2,135.00 79,900.11 79,900.11-9999 ----------!!!! D-101520-174 003290 KENNEDY & GRAVEN 182431 157029 940.00 3989 CENTRAL PROF SERV 000509 P M A D-101520-181 005825 EHLERS & ASSOCIATES INC 182410 84523 900.00 3989 CENTRAL PROF SERV 001560 P M A D-101520-181 005825 EHLERS & ASSOCIATES INC 182410 84522 295.00 3989 CENTRAL PROF SERV 001560 P M A 3220 POSTAGE 0.00 0.00 6.95 6.95 6.95-9999 ----------!!!!3220 POSTAGE 0.00 0.00 6.95 6.95 6.95-9999 ----------!!!! D-102920-263 098952 KLOIBER, JOSEPH 182643 092920 6.95 CERTIF MAIL:AT&T STTLMT N A 3810 ELECTRIC 0.00 0.00 0.00 1,189.87 1,189.87-9999 ----------!!!!3810 ELECTRIC 0.00 0.00 0.00 1,189.87 1,189.87-9999 ----------!!!! 4020 BUILDING MAINT:CONTRACT SVCS 0.00 0.00 0.00 260.37 260.37-9999 ----------!!!!4020 BUILDING MAINT:CONTRACT SVCS 0.00 0.00 0.00 260.37 260.37-9999 ----------!!!! 4390 TAXES & LICENSES 0.00 0.00 1,152.46 1,152.46 1,152.46-9999 ----------!!!!4390 TAXES & LICENSES 0.00 0.00 1,152.46 1,152.46 1,152.46-9999 ----------!!!! D-100820-156 005385 ANOKA COUNTY PROPERTY RE 182260 363024220042 1,152.46 4441 CENTRAL FULL YEAR 093020 P N A 5110 LAND 0.00 0.00 32,833.93 87,380.62 87,380.62-9999 ----------!!!!5110 LAND 0.00 0.00 32,833.93 87,380.62 87,380.62-9999 ----------!!!! D-100820-156 011700 ANOKA COUNTY 182259 363024320110 47,482.91 3989 CENTRAL 2ND HALF N A D-100820-156 011700 ANOKA COUNTY 182259 363024320261 3,316.70 3889 CENTRAL 2ND HALF N A D-100820-156 011700 ANOKA COUNTY 182259 363024320258 79.52 950 40TH 2ND HALF N A D-100820-156 011700 ANOKA COUNTY 182259 263024310088 26.62 4827 UNIVERSITY 2ND N A J-102820-366 3989 CENTRAL AVE PROCEED 1043 16,865.52- REIMB PRORATED RE TAX A J-102820-366 3989 CENTRAL AVE PROCEED 1043 1,178.06- REIMB PRORATED RE TAX A J-102820-366 3989 CENTRAL AVE PROCEED 1043 28.24- REIMB PRORATED RE TAX A 5191 ASSETS FOR RESALE 0.00 0.00 0.00 18,830.48 18,830.48-9999 ----------!!!!5191 ASSETS FOR RESALE 0.00 0.00 0.00 18,830.48 18,830.48-9999 ----------!!!! 6210 MISCELLANEOUS FISCAL CHARGES 0.00 0.00 814.00 814.00 814.00-9999 ----------!!!!6210 MISCELLANEOUS FISCAL CHARGES 0.00 0.00 814.00 814.00 814.00-9999 ----------!!!! J-102820-366 3989 CENTRAL AVE PROCEED 1043 814.00 CLOSECOST:1ST AMER TITLE A TOTAL: 3989 CENTRAL AVE 0.00 0.00 36,942.34 189,534.86 189,534.86-9999 ----------!!!! 52011 DEMO 3989 CENT AVE & RAMP 2171 GENERAL SUPPLIES 0.00 0.00 0.00 206.25 206.25-9999 ----------!!!!2171 GENERAL SUPPLIES 0.00 0.00 0.00 206.25 206.25-9999 ----------!!!! 3500 LEGAL NOTICE PUBLISHING 0.00 0.00 0.00 545.63 545.63-9999 ----------!!!!3500 LEGAL NOTICE PUBLISHING 0.00 0.00 0.00 545.63 545.63-9999 ----------!!!! TOTAL: DEMO 3989 CENT AVE & RAMP 0.00 0.00 0.00 751.88 751.88-9999 ----------!!!! TOTAL: EDA REDEVELOPMENT PROJECT FD 250,000.00 0.00 48,797.95 367,249.70 117,249.70- 146 ----------!!!! 90 ACS FINANCIAL SYSTEM CITY OF COLUMBIA HEIGHTS 11/16/2020 13:14:12 Exp. Guideline with Detail GL525R-V08.14 PAGE 57 FOR THE PERIOD(S) JAN 01, 2020 THROUGH OCT 31, 2020 ANNUAL ACT MTD POSTED ACT YTD POSTED REMAINING REVISED BUDGET ENCUMBERED AND IN PROCESS AND IN PROCESS BALANCE PCT ----------------------------------- -------------- -------------- -------------- -------------- -------------- --- -------------- SOURCE-JE-ID VENDOR/CUSTOMER/EXPLANATION REF/REC/CHK INVOICE AMOUNT DESCRIPTION P.O. F 9 FIL ------------ ------ ------------------------ ------ --------------- -------------- ------------------------ ------ - - - 420 CAP IMPROVEMENT DEVELOPMENT 46407 3930 UNIVERSITY 3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,906.25 1,906.25-9999 ----------!!!!3050 EXPERT & PROFESSIONAL SERV. 0.00 0.00 0.00 1,906.25 1,906.25-9999 ----------!!!! TOTAL: 3930 UNIVERSITY 0.00 0.00 0.00 1,906.25 1,906.25-9999 ----------!!!! TOTAL: CAP IMPROVEMENT DEVELOPMENT 0.00 0.00 0.00 1,906.25 1,906.25-9999 ----------!!!! 91 Resolution 2020-18 RESOLUTION NO. 2020-18 A RESOLUTION OF THE ECONOMIC DEVELOPMENT AUTHORITY OF COLUMBIA HEIGHTS, MINNESOTA, APPROVING THE FINANCIAL STATEMENTS FOR THE MONTHS OF SEPTEMBER AND OCTOBER 2020, AND THE PAYMENT OF THE BILLS FOR THE MONTHS OF SEPTEMBER AND OCTOBER 2020. WHEREAS, the Columbia Heights Economic Development Authority (the “EDA”) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the EDA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the EDA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and WHEREAS, the financial statements for the months of September and October, 2020 have been reviewed by the EDA Commission; and WHEREAS, the EDA has examined the financial statements and finds them to be acceptable as to both form and accuracy; and WHEREAS, the EDA Commission has other means to verify the intent of Section 469.096, Subd. 9, including but not limited to Comprehensive Annual Financial Reports, Annual City approved Budgets, Audits and similar documentation; and WHEREAS, financials statements are held by the City’s Finance Department in a method outlined by the State of Minnesota’s Records Retention Schedule, NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Economic Development Authority that it has examined the referenced financial statements including the check history, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the check history as presented in writing is approved for payment out of proper funds; and BE IT FURTHER RESOLVED this resolution is made a part of the permanent records of the Columbia Height s Economic Development Authority. ORDER OF ECONOMIC DEVELOPMENT AUTHORITY Passed this 7th day of December, 2020 Offered by: Seconded by: Roll Call: President Attest: Assistant Secretary 92 AGENDA SECTION BUSINESS ITEMS ITEM NO. 6 MEETING DATE DECEMBER 7, 2020 CITY OF COLUMBIA HEIGHTS – ECONOMIC DEVELOPMENT AUTHORITY Subsidized Home Energy Squad Approval 2021-2023 ITEM: Approve CEE Contract for Home Energy Squad Services DEPARTMENT: Community Development CITY MANAGER’S APPROVAL: BY/DATE: Mitchell Forney, 12/02/20 BY/DATE: BACKGROUND: In April 2019 the EDA Approved a partnership with the Center for Energy and Environment (CEE) to provide subsidized home energy inspections through CEE’s Home Energy Squad program. This program was renewed in 2020 and has seen 51 households take advantage of the subsidized home visits. In the past 2 years the City has funded the program with a max contribution of $5,000 per year. CEE offers two different types of visits under its home energy program. Energy Saver visits cost $70 and include an insulation inspection, safety check on heating and water systems, and the direct install of energy-saving materials where possible, including high-efficiency showerheads, faucet aerators, door weather stripping, programmable thermostats, and LED light bulbs. Energy Planner visits cost $100 and include everything offered in an Energy Saver visit plus a blower door test to check for air leaks, visual inspection of insulation levels with use of infrared camera, heating system and hot water heater combustion safety tests, and a report to the homeowner on recommended energy upgrades. For the last two years the EDA has only funded the Energy Planner visits, formerly called the Enhanced Visit, in an attempt to influence homeowners to take advantage of the more robu st program. Due to the fact that the EDA’s contribution has been underutilized for the last two years, Community Development staff recommends funding both programs during this agreement cycle. Once the program reaches its potential of serving 100 households per year, the contribution may be altered again to refocus on the Energy Planner visits. If approved the City would subsidize both types of visits by 50 percent, $35 for Energy Saver visits and $50 for Energy Planner Visits. The agreement included with this letter has a term length of three years. CEE recently re-negotiated their partnership with Excel energy and has signed a new three year agreement to operate the Home Energy Squad Program. CEE has requested that future agreements follow the agreement c ycle they have with Excel Energy so that all their partnerships are renewed at the same time. STAFF RECOMMENDATION: Staff recommends approving Resolution 2020-19, a resolution approving an agreement with the Center for Energy and Environment to subsidize Home Energy Squad visits. RECOMMENDED MOTION(S): Motion: Move to waive the reading of Resolution 2020-19, there being ample copies available to the public. Motion: Move to adopt Resolution 2020-19, a resolution of the Columbia Heights Economic Development Authority approving the agreement with the Center for Energy and Environment to perform Home Energy Squad visits. 93 City of Columbia Heights - Council Letter Page 2 ATTACHMENTS: 1. Home Energy Squad Partnership Agreement 2. Resolution 2020-19 94 AGREEMENT to Perform Home Energy Squad Visits In the City of Columbia Heights This Agreement is made by and between the Columbia Heights Economic Development (“EDA”) with offices at 590 40th Ave NE Columbia Heights, MN 55421and the Center for Energy and Environment (“CEE”), with offices at 212 3rd Avenue North, Suite 560, Minneapolis, Minnesota 55401. The following agreement is for the Center for Energy and Environment (CEE) to deliver Home Energy Squad Planner visits to residents of the City of Columbia Heights. PROGRAM SCOPE The purpose of the Home Energy Squad visits is to promote energy conservation in residential properties. Energy Saver visits offer energy efficient installs, and Energy Planner visits offer installs, diagnostic tests, and follow-up services. CEE will perform Home Energy Squad Energy Saver and Energy Planner visits for residents per the fee schedule listed below. ELIGIBLE PROPERTIES Properties must be residential (from 1-4 units) and located within the geographical boundaries of the City of Columbia Heights. Individual owners of condominiums or town homes are eligible for funding. CEE TASKS 1. Conduct Home Energy Squad Energy Saver Visits. CEE will conduct Home Energy Squad Energy Saver visits to help homeowners identify and implement energy savings opportunities in their homes. The visit will include an insulation inspection, safety check on heating system and water, and the direct install of energy-saving materials where possible, including high-efficiency showerheads, faucet aerators, door weather stripping, programmable thermostats and LED light bulbs. 2. Conduct Home Energy Squad Energy Planner Visits. CEE will conduct Home Energy Squad Energy Planner visits to help homeowners identify and implement energy savings opportunities in their homes. The Energy Planner visit will include the direct install of energy-saving materials where possible, including high-efficiency showerheads, faucet aerators, door weather stripping, programable thermostats and LED light bulbs. In addition, it will include a blower door test to check for air leaks, visual inspection of insulation levels with use of infrared camera as weather permits, heating system and hot water heater combustion safety tests and a report to the homeowner on recommended energy upgrades (if resident is a renter, permission from the landlord may be required for doing these additional diagnostic services). The co-pay and exact package of services are subject to change based on programma tic considerations, including CEE’s agreement with utilities and other factors which are outside the bounds of this agreement. CEE will notify the Columbia Heights EDA prior to any changes taking effect. CEE will lead a community-based marketing campaign to promote the program. The Columbia Heights EDA shall provide assistance in developing and implementing this campaign. 3. Providing Air Sealing and Insulation quotes. If air sealing and/or insulation are recommended at a Home Energy Squad Energy Planner visit, CEE may provide a quote to the resident that would be honored by participating insulation contractors. CEE is an independent third party to any transaction between the resident and the insulation contractor. CEE does not receive any compensation from insulation contractors, nor does CEE, CenterPoint Energy or Xcel Energy accept any liability for any work performed by these Type of Home Energy Squad Visit EDA payment Resident co-pay Energy Saver visit $35 $35 Energy Planner visit $50 $50 95 contractors. Any agreement for work done by the contractors is solely between the contractor and the resident. 4. Follow-up services and insulation contractor assistance. If major upgrades (air sealing, insulation and furnace or boiler replacement) are recommended at the visit, CEE will follow-up with homeowners through email or by phone to encourage implementation. When a quote is provided CEE has the ability to schedule insulation work directly with a qualified contractor making it easier for homeowner to move forward with recommendations. CEE will also provide contact information to program participants who have follow-up questions after the home visit. CITY TASKS 1. Assist and coordinate with CEE on marketing activities. This includes working with CEE on press releases, articles in CITY newsletters, water bill inserts, promoting program on CITY website, CITY email lists, assistance in coordinating with neighborhood and other CITY leaders, assistance in reserving workshop and event space as needed. PAYMENT CEE shall submit regular invoices to the Columbia Heights EDA for activity performed under this agreement. Invoices will be emailed to the Community Development Department. The Columbia Heights EDA will reimburse CEE $35 for every Energy Saver visit and $50 for every Home Energy Squad Planner visit completed not to exceed $5,000 per year without further authorization from the EDA. CONTACTS The following individuals shall be contacts for this program: COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT CONTACT PERSON Aaron Chirpich Community Development Department, City of Columbia Heights achirpich@columbiaheightsmn.gov 763-706-3670 CEE CONTACT PERSON Stacy Boots Camp, Center for Energy and Environment Assistant Outreach Manager sbootscamp@mncee.org or 612-244-2429 TERM The project shall run from January, 1 2021 through December 31, 2023 and may be extended upon mutual agreement by the parties. In witness thereof, the parties have executed this work order as of the date written below. COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY CENTER FOR ENERGY AND ENVIRONMENT By: By: Date: Date: TAX ID 41-1647799 96 Resolution 2020-19 RESOLUTION NO. 2020-19 A RESOLUTION OF THE COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY APPROVING THE AGREEMENT WITH THE CENTER FOR ENERGY AND ENVIRONMENT TO PERFORM HOME ENERGY SQUAD VISITS. BE IT RESOLVED BY the Board of Commissioners of the Columbia Heights Economic Development Authority (the "EDA") as follows: WHEREAS, the EDA has determined that it is necessary and desirable to promote energy conservation within the City of Columbia Heights (the “City”); and WEREAS, the EDA has continually supported the partnership with the Center for Energy and Environment (“CEE”) to work towards a more energy efficient city; and WHEREAS, the EDA has reviewed the Agreement to Perform Home Energy Squad Enhanced Visits in the City (the “Agreement”) and has determined to partner with CEE for the purposes of subsidizing home energy squad visits, lowering energy costs of residential properties, and increasing the City’s energy efficiency; NOW, THEREFORE BE IT RESOLVED that the EDA hereby approves the form and substance of the Agreement in the form presented; and BE IT FURTHER RESOLVED, that Kelli Bourgeois, as the Executive Director of the EDA is hereby authorized, empowered and directed for and on behalf of the EDA to enter into the Agreement and take such action as deemed necessary and appropriate to carry out the purpose of the foregoing resolution. ORDER OF ECONOMIC DEVELOPMENT AUTHORITY Passed this 7th day of December, 2020 Offered by: Seconded by: Roll Call: President Attest: Assistant Secretary 97 AGENDA SECTION BUSINESS ITEMS ITEM NO. 7 MEETING DATE DECEMBER 7, 2020 CITY OF COLUMBIA HEIGHTS – ECONOMIC DEVELOPMENT AUTHORITY 230 40th, Hazardous Material Abatement ITEM: Approve Hazardous Material Abatement Contract for 230 40th Avenue NE. DEPARTMENT: Community Development CITY MANAGER’S APPROVAL: BY/DATE: Mitchell Forney, 12/3/2020 BY/DATE: BACKGROUND: This memo is in regards to approving a bid for the removal of hazardous material from 230 40th Avenue NE. In December of 2019 the EDA purchased the property located at 230 40th Ave through the Commercial Revitalization Program. It was the ultimate goal of the EDA to demolish the blighted single family residential house on the property and prepare the site for future redevelopment. The House itself will not be demolished until the spring of 2021 after the structure has been utilized for training by the Fire Department. The scope of work submitted in the bid request included the removal of asbestos containing materials, appliances, and accessories containing hazardous materials. In response to the request for bids, the EDA received 2 quotes. The quote submitted by Hummingbird Environmental LLC was determined to be the lowest qualified bid. For $1,500 Hummingbird Environmental LLC shall furnish the services and necessary equipment to complete all work specified in the scope of work. All work will be performed in accordance with OSHA regulations, Minnesota Department of Health Asbestos Abatement Rules, and other applicable Federal and State regulations. Hummingbird Environmental LLC shall insure proper clean up, transport, and disposal of hazardous and asbestos containing materials. Bid Spreadsheet: Company Total Dennis Environmental Operations $ 2,000.00 Hummingbird Environmental LLC $ 1,500.00 STAFF RECOMMENDATION: Staff recommends awarding the contract to the low bidder for abatement work at 230 40th Ave NE to Hummingbird Environmental LLC. RECOMMENDED MOTION(S): Motion: Move to accept the low bid from Hummingbird Environmental LLC, for the removal of all hazardous materials located at 230 40th Avenue NE; and furthermore, to authorize the President and Executive Director to enter into an agreement for the same. ATTACHMENTS: 1. Sample Agreement 2. Demolition Survey 3. Dennis Environmental Operations Bid 4. Hummingbird Environmental, LLC Bid 98 1 EDA IN AND FOR THE CITY OF COLUMBIA HEIGHTS CONTRACT FOR REMOVAL OF ASBESTOS, AND OTHER HAZARDOUS MATERIALS FROM 230 40th AVE NE, COLUMBIA HEIGHTS For valuable consideration as set forth below, this Contract dated the __ day of December, 2020, is made and entered into between the Economic Development Authority in and for the City of Columbia Heights, a public body corporate and political created pursuant to the laws of the State of Minnesota ("EDA") and Hummingbird Environmental LLC. a Minnesota Limited Liability Company ("Contractor"). 1. CONTRACT DOCUMENTS Contractor hereby promises and agrees to perform and comply with all the provisions of this Contract and the Proposal dated November 6, 2020, prepared by Contractor attached hereto as Exhibit A for the removal of asbestos-containing materials, and removal of other hazardous materials in preparation for demolition of the residential property located at 230 40th Ave NE, Columbia Heights, Minnesota (“Property”). The survey prepared by Angstrom Analytical, Inc. dated June 30, 2020 (“Survey”) identifies certain hazardous materials that shall be removed by Contractor from the Property and is attached hereto as Exhibit B. The Contract, Proposal and Survey shall comprise the total agreement of the parties hereto. No oral order, objection, or claim by any party to the other shall affect or modify any of the terms or obligations contained in this Contract. 2. THE WORK The work to be performed by Contractor under this Contract (hereinafter the "Work"), is defined in the Proposal as removal of asbestos-containing materials, and removal of hazardous and solid waste materials identified on the Survey, excluding the fuel tanks, in preparation for demolition of the residence located on the Property. As part of the Work, Contractor agrees to remove all excess material from the Property. 3. CONTRACT PRICE The EDA agrees to pay Contractor the sum of $1,500.00 in exchange for Contractor furnishing labor and materials for the Work at the Property, payable within 30 days of Contractor’s completion of the Work. Contractor may start work on this project upon its execution of this Contract. 4. COMPLETION DATE/LIQUIDATED DAMAGES Contractor shall complete all Work on or before January 30th, 2021. ("Completion Date"). Due to the difficulty in ascertaining and establishing the actual damages which the EDA would 99 2 sustain, liquidated damages are specified as follows for failure of Contractor to complete his performance under this Contract by the Completion Date: for every calendar day that the Contract shall remain uncompleted beyond the Completion Date of January 30th, 2021, Contractor shall pay the EDA $50.00 per day as liquidated damages. 5. INSURANCE Before beginning actual work under this Contract, Contractor shall submit to the EDA and obtain the EDA's approval of a certificate of insurance on Standard Form C.I.C.C.-701 or ACORD 25 forms, showing the following insurance coverage, and listing the EDA and City as a loss payee under the policies: a. General Contractor Liability: $1,000,000.00 b. Workman's Compensation: Statutory Amounts This certificate must provide for the above coverages to be in effect from the date of the Contract until 30 days after the Completion Date, and must provide the insurance coverage will not be canceled by the insurance company without 30 day’s written notice to the EDA of intent to cancel. The certificate must further provide that Contractor’s insurance coverage is primary coverage notwithstanding any insurance coverage carried by the City or EDA that may apply to injury or damage relating to the maintenance or repair of the City streets or rights-of-way by either the City, EDA or any employee, agent, independent contractor or any other person or entity retained by the City or EDA to perform the services described herein. All insurance is subject to the review and approval of the Columbia Heights City Attorney. 6. LAWS, REGULATIONS AND SAFETY Contractor shall give all notices and comply with all laws, ordinances, rules and regulations applicable to performance under this Contract. Contractor shall provide adequate signs and/or barricades, and will take all necessary precautions for the protection of the Work and the safety of the public. 7. INDEMNIFICATION To the fullest extent permitted by law, Contractor shall indemnify and hold harmless the EDA, its agents and employees from and against all claims, damages, losses and expenses, including but not limited to attorney's fees, arising out of or resulting from the performance of Work, provided that any such claim, damage, loss or expense (1) is attributable to bodily injury, sickness, disease or death, or to injury or to destruction of tangible property (other than the Work itself) including the loss of use resulting therefrom, and (2) is caused in whole or in part by any negligent act or omission of Contractor, any Subcontractor, anyone directly or indirectly employed by any of them or anyone 100 3 for whose acts any of them may be liable, regardless of whether or not it is caused in part by a party indemnified hereunder. 8. ASSIGNMENT Contractor shall not assign or transfer, whether by an assignment or novation or otherwise, any of its rights, duties, benefits, obligations, liabilities or responsibilities without prior written consent of the EDA. 9. NOTICE The address and telephone number of Contractor for purposes of giving notices and any other purpose under this Contract shall be 522 Concord Street North, Suite 400, South St. Paul, MN 55075, 651-457-4699. The address of the EDA for purposes of giving notices and any other purposes under this Contract shall be 590 40th Avenue NE, Columbia Heights, MN 55421. IN WITNESS WHEREOF, the parties to this Contract have hereunto set their hands and seals as of the day and year first above written. ECONOMIC DEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS By: ____________________________________ Kelli Bourgeois Its: Executive Director Hummingbird Environmental LLC. By: ____________________________________ Its: ____________________________________ 101 102 103 104 DENNIS ENVIRONMENTAL OPERATIONS 551 Topping Street St. Paul, MN 55103 (651) 488-4835 Phone (651) 488-4624 Fax PROPOSAL November 20th 2020 Mitchell Forney Community Development Coordinator City of Columbia Heights 590 40th Avenue NE Columbia Heights, MN 55421 mforney@columbiaheughtsmn.gov Re: Asbestos Abatement & Appliance Disposal 230 40th Avenue NE Columbia Heights, MN 55421 Dennis Environmental Operations will provide the following abatement services: Removal & disposal of asbestos containing materials & appliers listed in Angstrom Analytical Inc. Report dated June 30th 2020. Price $ 2,000.00 Price valid for 30 days. The Owner/General Contractor is responsible for any necessary disconnects. Price includes disposal, OSHA sampling, labor and materials. All work will be performed in accordance with OSHA, state and federal regulations. We carry industry standard insurance; any additional insurance requests may result in additional charges. Submitted, Eric Johnson, Project Manager Accepted 105 Hummingbird Environmental LLC 29929 County 5 Blvd Red Wing MN 55066 Mailing Address: 522 Concord Street North, Suite 400, South St. Paul, MN 55075 (651) 457-4699 AsbestosJoe@yahoo.com PROPOSAL / CONTRACT FOR: City of Columbia Heights Attn: Mitchell Forney mforney@columbiaheightsmn.gov 763-706-3674 Project: 230 40th Ave NE Columbia Heights MN Removal and disposal of positive ACM as stated in survey: $950.00 Removal and disposal of listed hazardous materials: $550.00 TOTAL: $1,500.00 NOTE: POSSIBLE EXTRAS: CONTRACT PRICE The contract Price for the work shall be: $1,500.00 HUMMINGBIRD will invoice for completed work as it deems appropriate; invoices shall be paid by Client on a net thirty-day (30) basis at HUMMINGBIRD address shown above. Authorized Hummingbird Environmental Signature Authorized Client Signat ure By: Joe Yager/__________________ By: ___________________ Its: Project Manager Its: Date: 11-6-2020 Date: 106 AGENDA SECTION BUSINESS ITEM ITEM NO. 8 MEETING DATE DECEMBER 7, 2020 CITY OF COLUMBIA HEIGHTS – ECONOMIC DEVELOPMENT AUTHORITY ITEM: Approve Service Agreement with TimeSaver Off Site Secretarial, Inc. DEPARTMENT: Community Development CITY MANAGER’S APPROVAL: BY/DATE: Aaron Chirpich, December 3, 2020 BY/DATE: BACKGROUND: The Community Development department has made the move to one full time Administrative Assistant over the past year. This position is responsible for all administrative duties serving the department, including work that supports the activities of the EDA. To accommodate the move to a single Administrative Assistant, the workload for the position needs to be reduced or streamlined wherever possible. To achieve this objective, staff recommends that the EDA contract with TimSaver Secretarial to complete meeting minutes on behalf of the EDA. TimeSavers currently provide minute taking services for the City Council, and they have proposed adding the EDA to the City’s base contract. The company will use video recordings of EDA meetings to complete the work. Timesavers will bill the EDA separately from the City according the terms of the attached rate schedule. STAFF RECOMMENDATION: Staff recommends approving the proposed Timesaver Secretarial 2021 rate schedule as presented for minute taking services. RECOMMENDED MOTION: Motion: Move to approve the 2021 rate schedule proposed by TimeSaver Off Site Secretarial, Inc. to provide minute taking services for the EDA in 2021; and furthermore, to authorize the Executive Director to enter into an agreement for the same. ATTACHMENTS: 1. TimeSaver 2021 Rate Schedule 107 ADDENDUM TO RECORDING SECRETARY SERVICE AGREEMENT Dated: December 31, 2020 By and between TimeSaver Off Site Secretarial, Inc. and City of Columbia Heights, 590 40 th Avenue NE, Columbia Heights, MN 55421. 1. EXTENSION OF RECORDING SECRETARIAL SERVICE AGREEMENT: The term of the existing Recording Secretary Service Agreement dated December 31, 2019, shall be extended under the same terms and conditions to December 31, 2021. 2. TOSS CHARGES: TOSS shall be paid for its services as recording secretary for each meeting with a one (1) hour minimum, the highest rate prevailing, as follows: a. Base Rate: One Hundred Fifty-One and 00/100 dollars ($151.00) for any meeting up to one (1) hour (billable time) plus Thirty-Six and 00/100 dollars ($36.00) for each thirty (30) minutes following the first one (1) hour; or b. Unit Rate: Forty-Nine and 50/00 dollars ($49.50) for the first hour of meeting time and Thirty-Three and 00/100 dollars ($33.00) for every hour after the first hour plus Fifteen and 50/100 dollars ($15.50) for each page of draft minutes for submission to the City of Columbia Heights for its preparation of final minutes. At the end of the term of this Addendum or any extension of it, the parties may make a new Agreement or extend or modify the terms of this Agreement. IN WITNESS WHEREOF, the undersigned have executed this Addendum to the Recording Secretary Service Agreement as of the day and year indicated. January ___, 2021 CITY OF COLUMBIA HEIGHTS By Kelli Bourgeois Its City Manager November 1, 2020 TIMESAVER OFF SITE SECRETARIAL, INC. By Carla Wirth Its President & CEO AGENDA SECTION BUSINESS ITEM ITEM NO. 9 MEETING DATE DECEMBER 7, 2020 CITY OF COLUMBIA HEIGHTS – ECONOMIC DEVELOPMENT AUTHORITY ITEM: Approve Acquisition of 960 40th Avenue NE and 1002 40th Avenue NE. DEPARTMENT: Community Development CITY MANAGER’S APPROVAL: BY/DATE: Aaron Chirpich, December 3, 2020 BY/DATE: BACKGROUND – 960 40th AVENUE: During the predevelopment planning phase for the 3989 Central redevelopment project, it became clear that the acquisition of 960 40th Avenue NE was necessary for the successful completion of the larger project. The necessity to acquire 960 40th Avenue is driven by its close proximity to the redevelopment site and the need to maintain alley access to nearby properties during construction. The single-family home located at 960 40th Avenue sits just four (4) feet from the western property line that adjoins the redevelopment site. Directly west of the house and five feet from the property line of 960 40th Avenue there is a narrow alley. This alley serves as an access point to the garages of two additional homes in the immediate vicinity. Beneath the alley lies a City storm sewer line that has to be relocated as part of the broader redevelopment project. To keep the project on schedule, this sewer line has to be relocated at the beginning of the project. Removal and relocation of the current storm sewer line requires removal of the alley. Because the alley is so close to the primary excavation for the underground parking structure of the new development, the alley will be removed for a long period of time and the hole where the alley used to be will be over 10 feet deep. Therefore, to maintain access for the other homes nearby that utilize the alley for their garages, a new access point is required. To achieve the new access point, Alatus has purchased the property at 960 40th Avenue and they have torn down the former detached garage that was on the site. Removal of the garage has allowed access for the adjacent property owners to be achieved along the eastern side of 960 40th Avenue, effectively bypassing the former narrow alley. Alatus originally approached staff in June of 2020 to see if the EDA could entertain the purchase of 960 40th Avenue at that time, as Alatus had reached out to the owner and determined that the owner was interested in selling. Staff responded to Alatus by stating that the EDA could not consider the purchase because the EDA’s redevelopment funds were tied up in the purchase of the 3989 Central Avenue redevelopment site. Staff did indicate that 960 40th Avenue would be a property of interest to the EDA once the closing of 3989 Central was completed. Now that the EDA has closed on the sale of the redevelopment site to Alatus, staff recommends moving forward with the acquisition of 960 40th Avenue. Staff considers the property to be a priority acquisition for redevelopment given the poor condition of the home and its close proximity to the new development. Alatus has purchased the property for $225,000 and has paid the former owner an additional $55,000 in relocation assistance, for a total investment of $280,000. The tax assessed value of the property is $185,000. Alatus has offered the property to the EDA for $225,000. Staff considers this a fair deal given the fact that the acquisitio n was necessary to ensure the success of the larger project, and Alatus has agreed to cover the relocation expenses. Staff has no immediate plans for redevelopment of the site, as additional adjacent properties will have to be acquired to assemble enough land for a larger project. 109 City of Columbia Heights - EDA Letter Page 2 BACKGROUND – 1002 40th Avenue: 1002 40th Avenue is located just west of 960 40th Avenue and was offered for sale on 11-20-20 with a list price of $165,000. The listing agent indicated that there were multiple pending offers on the first day it was listed and informed staff that no offers would be reviewed until 11-23-20. Staff submitted an offer of $175,000 on 11-23-20, and the offer was accepted the next day. The seller received multiple offers for the home, and indicated that the EDA’s offer was not the highest price offer received. The other higher price offers were viewed as less secure than the EDA’s. The tax assessed value of the property is $172,000. Staff considers this potential acquisition to be a priority given its proximity to the 3989 Central Avenue redevelopment site, and the 960 40th Avenue property disscued above. STAFF RECOMMENDATION: Staff recommends that the EDA approve the purchase of both properties as part of a strategic land acquisition effort that will promote additional redevelopment in the immediate vicinity of the 3989 Central Avenue site. In addition to the base acquisition price of each home, staff anticipates that demolition and site clearing costs for both properties combined will total $50,000, bringing the total project budget to $450,000. Funding will come from the EDA redevelopment Fund 408. RECOMMENDED MOTION(S) Motion: Move to waive the reading of Resolution 2020-20, there being ample copies available to the public. Motion: Move to adopt Resolution 2020-20, a resolution approving the purchase agreement between the Columbia Heights Economic Development Authority and Alatus, LLC. Motion: Move to waive the reading of Resolution 2020-21, there being ample copies available to the public. Motion: Move to adopt Resolution 2020-21, a resolution approving the purchase agreement between the Columbia Heights Economic Development Authority and Lori Gibson. ATTACHMENTS:  Resolution 2020-20  Resolution 2020-21  Location Map  960 40th Avenue Purchase Agreement  1002 40th Avenue Purchase Agreement 110 A-1 Resolution 2020-20 COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY RESOLUTION NO. 2020-20 RESOLUTION APPROVING PURCHASE AGREEMENT BETWEEN THE COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY AND ALATUS, LLC BE IT RESOLVED BY the Board of Commissioners ("Board") of the Columbia Heights Economic Development Authority (the "Authority") as follows: Section 1. Recitals. 1.01. The Authority and Alatus, LLC (“Seller”) desire to enter into a purchase agreement (the “Purchase Agreement”) pursuant to which the Authority will acquire certain property in the City located at 960 40th Avenue NE (the “Property”) from the Seller for economic redevelopment purposes. The Property is described in Exhibit A attached hereto. 1.02. Pursuant to the Purchase Agreement, the Authority will purchase the Property from the Seller for a purchase price of $225,000 plus related closing costs. 1.03. The Authority finds that acquisition of the Property is consistent with the City’s Comprehensive Plan and will result in redevelopment of a substandard property, and that such acquisition will facilitate the economic redevelopment and revitalization of this area of the City. Section 2. Purchase Agreement Approved. 2.01. The Authority hereby ratifies and approves the actions of Authority staff in researching the Property and preparing and presenting the Purchase Agreement. The Authority approves the Purchase Agreement in the form presented to the Authority and on file at City Hall, subject to modifications that do not alter the substance of the transaction and that are approved by the President and Executive Director, provided that execution of the Purchase Agreement by those officials shall be conclusive evidence of their approval. 2.02. Authority staff and officials are authorized to take all actions necessary to perform the Authority’s obligations under the Purchase Agreement as a whole, including without limitation execution of any documents to which the Authority is a party referenced in or att ached to the Purchase Agreement, and any deed or other documents necessary to acquire the Property from the Seller, all as described in the Purchase Agreement. Approved this 7th day of December, 2020, by the Board of Commissioners of the Columbia Heights Economic Development Authority. 111 _________________________________ President ATTEST: __________________________________ Secretary 112 A-1 Resolution 2020-20 EXHIBIT A PROPERTY Lot 23, Block 6, Reservoir Hills, Columbia Heights, Anoka County, Minnesota 113 A-1 Resolution 2020-21 COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY RESOLUTION NO. 2020-21 RESOLUTION APPROVING PURCHASE AGREEMENT BETWEEN THE COLUMBIA HEIGHTS ECONOMIC DEVELOPMENT AUTHORITY AND LORI GIBSON BE IT RESOLVED BY the Board of Commissioners ("Board") of the Columbia Heights Economic Development Authority (the "Authority") as follows: Section 1. Recitals. 1.01. The Authority and Lori Gibson (“Seller”) desire to enter into a purchase agreement (the “Purchase Agreement”) pursuant to which the Authority will acquire certain property in the City located at 1002 40th Avenue NE (the “Property”) from the Seller for economic redevelopment purposes. The Property is described in Exhibit A attached hereto. 1.02. Pursuant to the Purchase Agreement, the Authority will purchase the Property from the Seller for a purchase price of $175,000 plus related closing costs. 1.03. The Authority finds that acquisition of the Property is consistent with the City’s Comprehensive Plan and will result in redevelopment of a substandard property, and that such acquisition will facilitate the economic redevelopment and revitalization of this area of the City. Section 2. Purchase Agreement Approved. 2.01. The Authority hereby ratifies and approves the actions of Authority staff and of Re/Max Synergy acting as the Authority’s real estate broker (“Broker”) in researching the Property and preparing and presenting the Purchase Agreement. The Authority approves the Purchase Agreement in the form presented to the Authority and on file at City Hall, subject to modifications that do not alter the substance of the transaction and that are approved by the President and Executive Director, provided that execution of the Purchase Agreement by those officials shall be conclusive evidence of their approval. 2.02. Authority staff and officials are authorized to take all actions necessary to perform the Authority’s obligations under the Purchase Agreement as a whole, including without limitation execution of any documents to which the Authority is a party referenced in or attached to the Purchase Agreement, and any deed or other documents necessary to acquire the Property from the Seller, all as described in the Purchase Agreement. Approved this 7th day of December, 2020, by the Board of Commissioners of the Columbia Heights Economic Development Authority. 114 _________________________________ President ATTEST: __________________________________ Secretary 115 A-1 Resolution 2020-21 EXHIBIT A PROPERTY Lot 19, Block 6, Reservoir Hills, Anoka County, Minnesota. 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168